{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,0,1,8],[8,0,8,1],[10,0,10,1],[23,0,23,3],[42,6,42,10]]}
["2.3 Business Activity Statement - Worksheet "]
["For Businesses on \"Simpler BAS\" process - (GST turnover <$10m)"]
[]
["This worksheet is designed to support a self employed applicant(s) income declaration (Alt Doc)    "]
[]
["Please extract the following data from the supplied BAS and perform the required calculations"]
[]
[]
["Client Name: "]
[]
["ABN:"]
[]
[null,null,null,null,null,null,"Quarter 1",null,null,null,"Quarter 2"]
["Period",null,null,null,null,"2021-07-01","to","2021-09-30",null,"2021-10-01","to","2021-12-30"]
[]
["G1 - Total Sales",null,null,null,null,0,null,null,null,0]
[]
[]
["1B - ATO owes you (owed by ATO).",null,null,null,null,0,null,null,null,0]
[]
[]
["W1 - Total salary, wages & other payments ^",null,null,null,null,0,null,null,null,0]
[]
["^Exclude any \"salary/wage\" amount that can be confirmed, or reasonably assumed, to be paid to the applicant(s).  "]
[]
["Calculations"]
[]
["Total Purchases - Estimate",null,null,null,null,{"$f":"F19/0.0909","v":0},null,null,null,{"$f":"J19/0.0909","v":0}]
["(1B divided by 9.09%)"]
[]
["Were there any large \"one-off\" Capital Purchases",null,null,null,null,null,"No","Select",null,null,"No","Select"]
["(drop down box)"]
["Value of large \"one off\" Capital Purchases"]
["*Proof required to exclude a Capital Purchase(s) from calculations "]
[]
["Total Purchases - Revised",null,null,null,null,{"$f":"F28-F33","v":0},null,null,null,{"$f":"J28-J33","v":0}]
["(Total Purchases Estimate minus Capital Purchases)"]
[]
["Surplus Income Estimate",null,null,null,null,{"$f":"F16-F36-F22","v":0},null,null,null,{"$f":"J16-J36-J22","v":0}]
["(G1 minus Total Purchases Revised minus W1)"]
[]
[]
["Annualised Surplus Income Estimate",null,null,null,null,null,{"$f":"(F39+J39)*2","v":0}]
["(Quarter 1 plus Quarter 2 multiple by 2)"]
[]
["This is to be used as a guide only & additional information may be sought to help meet Responsible Lending Guidelines"]
[]
[]
[]
[]
[]
[]
[]
[null,"Yes"]
[null,"No"]