{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","BAS Summary Calc"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":"Introduction","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,19,4],[5,0,5,4],[15,1,16,4],[3,0,4,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4]]}
[]
[]
["Introduction"]
["After you have input the applicant(s) Name, ABN and their declared income the calculator will utilise the income from their BAS to support the applicant(s) declared income. "]
[]
["Please note; Sales less Non-Capital Purchases IS NOT the applicant(s) actual income.  It is only to be used to help support the income that the applicant(s) has declared on their Borrower Repayment Declaration."]
[]
["How to use the calculator:"]
[]
["Step 1","Enter the applicant(s) name, ABN and declared income. The date will automatically populate."]
["Step 2","Enter the Total Sales from G1 on the BAS statements (Older BAS Statements may refer to this section as Gross Sales)"]
["Step 3","If applicable - Enter any Non GST Sales. (This section is usually shown on older versions of BAS Statements, if not shown, please proceed to step 4)"]
["Step 4","Enter owed by ATO figure from 1B  The calculator will automatically calculate non-capital purchases."]
["Step 5","Additional Expenses:  If there have been Capital Purchases please include.  These are usually one off large expense items such as major equipment or motor vehicles and do no occur on a regular basis. We will require evidence of this.  "]
[null,"If applicant(s) do work in the food industry, we will need to be advised of their fresh food expense as fresh food does not attract any GST and therefore will not be shown on the BAS statements.  You will need to ask the applicant and include notes in the explanation box."]
["Step 6","If the percentage of sales income is unusually high or inconsistent with the gross margin outlined by the BAS statements a detailed explanation will be required.  The notes could include the type of industry that the applicant(s) operates in that show very low Non-Capital Purchases as is often the case in service based or low overhead commercial operations. These added notes are very important for us to understand the unique nature of your applicant(s) business so be as detailed as possible.  For example a self employed sole trader accountant who works from home would have very low Non Capital Purchases and therefore a higher level of declared income."]
[]
["Step 7","If you have any questions regarding the calculator please contact your BDM to discuss in more detail."]

{"sheet":"BAS Summary Calc","index":1,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,0,11,1],[34,1,34,2],[38,0,47,3],[7,1,7,2],[10,1,10,2],[29,1,29,2],[30,1,30,2],[8,1,8,2],[9,1,9,2],[30,3,30,4],[34,3,34,4],[32,0,32,4]]}
[]
[]
[]
[]
[]
[]
[]
["Date:         ",{"$f":"TODAY()","v":"2020-06-22"}]
["Entity Name:          "]
["Entity ABN:          "]
["Declared Net Profit Before Tax:"]
[]
["Income/Sales from BAS"]
["Qtr","G1 - Total Sales (GST applicable)","Non GST Sales"]
["Q1",null,0]
["Q2",null,0]
["Q3",null,0]
["Q4",null,0]
["Total",{"$f":"SUM(B15:B18)","v":0},{"$f":"SUM(C15:C18)","v":0}]
[]
["Expenses/Purchases from BAS"]
["Qtr","1B - Owed by ATO Amount (GST Section Only)","Capital purchases (evidence required to use)","Non Capital Purchases","Tax payable on GST Margin","Net"]
["Q1",null,0,{"$f":"IF(H33>0,H33,(B23*11)-C23)","v":0},{"$f":"(B15-C15-D23)/11","v":0},{"$f":"B15-D23-E23","v":0}]
["Q2",null,0,{"$f":"IF(H34>0,H34,(B24*11)-C24)","v":0},{"$f":"(B16-C16-D24)/11","v":0},{"$f":"B16-D24-E24","v":0}]
["Q3",null,0,{"$f":"IF(H35>0,H35,(B25*11)-C25)","v":0},{"$f":"(B17-C17-D25)/11","v":0},{"$f":"B17-D25-E25","v":0}]
["Q4",null,0,{"$f":"IF(H36>0,H36,(B26*11)-C26)","v":0},{"$f":"(B18-C18-D26)/11","v":0},{"$f":"B18-D26-E26","v":0}]
["Total",{"$f":"SUM(B23:B26)","v":0},{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},{"$f":"SUM(E23:E26)","v":0},{"$f":"SUM(F23:F26)","v":0}]
[]
["Summary"]
["Sales less Non Capital Purchases (and tax on margin):",{"$f":"F27","v":0}]
["Declared Net Profit Before Tax:",{"$f":"B11","v":0},null,{"$f":"IF(B30>=B31,\"OK\",\"REFER TO BDM / LA TROBE FINANCIAL AS DECLARED INCOME IS GREATER THAN MARGIN ON SALES \")","v":"OK"}]
[null,null,null,null,null,null,null,"Non-Capital Purchases","OR"]
["PLEASE NOTE:  If applicant is declaring an income that is unusually high for the industry or inconsistent with the gross margin outlined by the BAS statements, a detailed explanation will be required",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["Percentage Of Sales Vs Income Declared:",{"$f":"B31/(B19+C19)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(B35>0.4,\"REFER TO BDM / LA TROBE FINANCIAL AS MARGIN DECLARED MAY BE UNUSUALLY HIGH\",\"OK\")","v":{"$error":"#DIV/0!"}},null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H33:H36)","v":0}]
["Explanation if applicable.  Please see introduction page for example:"]