{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Control","BAS Summary","GST Collected & Paid NEW","GST Collected & Paid OLD","GST Owing","FBT Rec","GST Worksheet","PAYG Instalment Worksheet","DIY"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":10,"comments":4,"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":"Control","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,7,2,8]]}
[{"$f":"CONCATENATE(TEXT(F4,(\"yyyy\")),\" BAS Summary & Reconciliation\")","v":"2024 BAS Summary & Reconciliation"}]
[null,null,null,null,null,"From Date","Status List"]
[null,null,null,null,null,{"$f":"EOMONTH('BAS Summary'!O5,-12)+1","v":"2023-07-01"},null,"Rolling Forward"]
[null,null,null,null,null,{"$f":"F8","v":"2024-01-31"},"C","First SAP Date","Done2024"]
[null,null,null,null,null,null,"E","Update balance date from drop down list","Done2024"]
[null,null,null,null,null,"SAP","R","Check ATO link at bottom of BAS summary","Done2024"]
[null,null,null,null,null,"2023-12-31"]
[null,null,null,null,null,{"$f":"EOMONTH(F7,1)","v":"2024-01-31"}]
[null,null,null,null,null,"2024-02-29"]
[null,null,null,null,null,"2024-03-31"]
[null,null,null,null,null,"2024-04-30"]
[null,null,null,null,null,"2024-05-31"]
[null,null,null,null,null,"2024-06-30"]
[null,null,null,null,null,"2024-07-31"]
[null,null,null,null,null,"2024-08-31"]
[null,null,null,null,null,"2024-09-30"]
[null,null,null,null,null,"2024-10-31"]
[null,null,null,null,null,"2024-11-30"]

{"sheet":"BAS Summary","index":1,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":false,"merged":[[82,5,82,14],[44,3,44,4],[51,3,51,4],[8,15,9,15],[49,3,49,5],[43,3,43,4],[46,3,46,4],[47,3,47,4],[52,3,52,4],[50,3,50,4],[75,3,75,4],[48,3,48,4],[45,3,45,4],[33,3,34,14],[3,17,3,19],[4,17,6,19],[6,2,7,15],[24,3,25,14],[0,13,0,15],[3,2,3,3],[1,13,1,15],[3,14,3,15],[4,14,4,15],[23,2,23,15]]}
[null,"ℹ","BAS Summary",null,null,null,null,null,null,null,null,null,null,"Client Name"]
[null,null,{"$f":"CONCATENATE(\"Year Ended\",\" \",TEXT(O5,\"dd mmmm yyyy\"))","v":"Year Ended 30 June 2024"},null,null,null,null,null,null,null,null,null,null,"Preparer Name"]
[]
[null,null,"Accounting Methods for Reconciliations",null,null,null,null,{"$f":"IF(OR(AND('GST Worksheet'!Q24<>0,'GST Worksheet'!Q24<>'BAS Summary'!E23),AND('GST Worksheet'!S43<>0,'GST Worksheet'!S43<>'BAS Summary'!F23)),\"WARNING:  Figures in the GST worksheet do not agree with this summary\",\"\")","v":""},null,null,null,null,null,"ABN",null,null,null,"Help or Feedback"]
[null,null,"Activity Statements",null,"Select",null,null,{"$f":"IF(AND('PAYG Instalment Worksheet'!P24<>0,'PAYG Instalment Worksheet'!P24<>'BAS Summary'!J23),\"WARNING:  Figures in the PAYGI worksheet do not agree with this summary\",\"\")","v":""},null,null,null,null,null,"Balance Date","2024-06-30",null,null,"Click on the mail button above to send us an email to get help on using this spreadsheet or to provide feedback."]
[null,null,"Financial Report",null,"Select"]
[null,null,"Summary of Activity Statements Lodged with the ATO"]
[]
[null,null,"Form",null,"GST Collected","GST","GST","Gross","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine","Payable","Paid In Full"]
[null,null,"Status","Period","Or Instalment","Paid","Balance","Wages","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","(Refund)"]
[null,null,null,{"$f":"EOMONTH($O$5,-11)","v":"2023-07-31"},null,null,{"$f":"E11-F11","v":0},null,null,null,null,null,null,null,{"$f":"G11+I11+J11+K11+L11+M11+N11","v":0},1,null,"<<<  Enter 1 for yes or enter 0 or leave blank for no"]
[null,null,null,{"$f":"EOMONTH($O$5,-10)","v":"2023-08-31"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(O5,-9),\" mmm yy\"),\"  /  Quarter 1\")","v":" Sep 23  /  Quarter 1"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-8)","v":"2023-10-31"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-7)","v":"2023-11-30"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(O5,-6),\" mmm yy\"),\"  /  Quarter 2\")","v":" Dec 23  /  Quarter 2"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-5)","v":"2024-01-31"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-4)","v":"2024-02-29"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(O5,-3),\" mmm yy\"),\"  /  Quarter 3\")","v":" Mar 24  /  Quarter 3"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-2)","v":"2024-04-30"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"EOMONTH($O$5,-1)","v":"2024-05-31"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,{"$f":"CONCATENATE(TEXT(O5,\" mmm yy\"),\"  /  Quarter 4\",\"  /  Annual\")","v":" Jun 24  /  Quarter 4  /  Annual"},null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,"Totals",{"$f":"SUM(E11:E22)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Form Status Codes   C - Correction to an earlier activity statement included,   E - Error in this activity statement corrected in a later activity statement,   R - Revision"]
[null,null,null,"Reconcile with Client Accounting System"]
[{"$f":"IF(OR($E$29>0,$F$29>0,$G$29>0,$H$29>0,$I$29>0,$J$29>0,$K$29>0,$L$29>0,$M$29>0,$N$29>0,$O$29>0,$E$30>0,$F$30>0,$G$30>0,$H$30>0,$I$30>0,$J$30>0,$K$30>0,$L$30>0,$M$30>0,$N$30>0,$O$30>0),0,\"blank\")","v":"blank"}]
[{"$f":"IF(OR($E$29>0,$F$29>0,$G$29>0,$H$29>0,$I$29>0,$J$29>0,$K$29>0,$L$29>0,$M$29>0,$N$29>0,$O$29>0,$E$30>0,$F$30>0,$G$30>0,$H$30>0,$I$30>0,$J$30>0,$K$30>0,$L$30>0,$M$30>0,$N$30>0,$O$30>0),0,\"blank\")","v":"blank"},null,null,null,"GST","GST","GST","Gross","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine"]
[{"$f":"IF(OR($E$29>0,$F$29>0,$G$29>0,$H$29>0,$I$29>0,$J$29>0,$K$29>0,$L$29>0,$M$29>0,$N$29>0,$O$29>0,$E$30>0,$F$30>0,$G$30>0,$H$30>0,$I$30>0,$J$30>0,$K$30>0,$L$30>0,$M$30>0,$N$30>0,$O$30>0),0,\"blank\")","v":"blank"},null,null,null,"Collected","Paid","Balance","Wages","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","Total"]
[{"$f":"IF(OR($E$29>0,$F$29>0,$G$29>0,$H$29>0,$I$29>0,$J$29>0,$K$29>0,$L$29>0,$M$29>0,$N$29>0,$O$29>0,$E$30>0,$F$30>0,$G$30>0,$H$30>0,$I$30>0,$J$30>0,$K$30>0,$L$30>0,$M$30>0,$N$30>0,$O$30>0),0,\"blank\")","v":"blank"},null,null,"Client Annual Totals",null,null,{"$f":"E29-F29","v":0},null,null,null,null,null,null,null,{"$f":"G29+I29+J29+K29+L29+M29+N29","v":0}]
[{"$f":"IF(OR($E$29>0,$F$29>0,$G$29>0,$H$29>0,$I$29>0,$J$29>0,$K$29>0,$L$29>0,$M$29>0,$N$29>0,$O$29>0,$E$30>0,$F$30>0,$G$30>0,$H$30>0,$I$30>0,$J$30>0,$K$30>0,$L$30>0,$M$30>0,$N$30>0,$O$30>0),0,\"blank\")","v":"blank"},null,null,"BAS Above",{"$f":"E23","v":0},{"$f":"F23","v":0},{"$f":"E30-F30","v":0},{"$f":"H23","v":0},0,0,0,0,0,0,{"$f":"G30+I30+J30+K30+L30+M30+N30","v":0}]
[null,null,null,"Variation",{"$f":"E29-E30","v":0},{"$f":"F29-F30","v":0},{"$f":"E31-F31","v":0},{"$f":"H29-H30","v":0},0,0,0,0,0,0,0]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Calculate Amounts Owing to ATO at \",TEXT(O5,\"dd mmm yyyy\"))","v":"Calculate Amounts Owing to ATO at 30 Jun 2024"}]
[]
[null,null,null,null,null,null,null,null,"PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine"]
[null,null,null,null,null,"GST","Interest","Penalties","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","Total"]
[null,null,null,"Activity Statement Debts & (Refunds Due)"]
[null,null,null,"Prior Year Debts/(Refunds) Brought Forward",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F39:N39)","v":0}]
[null,null,null,"Less Payments Made & Refunds Received",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F40:N40)","v":0}]
[null,null,null,{"$f":"CONCATENATE(\"Prior Year Debts/(Refunds) at \",TEXT(O5,\"dd mmm\"))","v":"Prior Year Debts/(Refunds) at 30 Jun"},null,{"$f":"F39-F40","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(OR(F43<>0,G43<>0,H43<>0,I43<>0,J43<>0,K43<>0,L43<>0,M43<>0,N43<>0,O43<>0),0,\"blank\")","v":"blank"},null,null,"Current Year Debts/(Refunds) as Above",null,{"$f":"G23","v":0},null,null,{"$f":"I23","v":0},0,0,0,0,0,{"$f":"F42+G42+H42+I42+J42+K42+L42+M42+N42","v":0}]
["blank",null,null,"General Interest Charge (GIC) & Penalties",null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Amounts Owing/(Refundable)",null,{"$f":"SUM(F41:F48)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Less Payments, (Refunds) & (Credits)"]
[{"$f":"IF(OR(F53<>0,G53<>0,H53<>0,I53<>0,J53<>0,K53<>0,L53<>0,M53<>0,N53<>0,O53<>0),0,\"blank\")","v":"blank"},null,null,"ATO Interest Received",null,null,null,null,null,null,null,null,null,null,{"$f":"G52","v":0}]
[null,null,null,"Payments/(Refunds) as Ticked Above",null,{"$f":"SUMIF($P$11:$P$22,1,G11:G22)","v":0},null,null,{"$f":"SUMIF($P$11:$P$22,1,I11:I22)","v":0},0,0,0,0,0,{"$f":"SUM(F53:N53)","v":0}]
[{"$f":"IF(OR(F55<>0,G55<>0,H55<>0,I55<>0,J55<>0,K55<>0,L55<>0,M55<>0,N55<>0,O55<>0),0,\"blank\")","v":"blank"},null,null,"Other Payments/(Refunds) Etc","Date"]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F55:N55)","v":0}]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["blank",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Payments, (Refunds) & (Credits)",null,{"$f":"SUM(F52:F75)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"CONCATENATE(\"Amounts Owing/(Refundable) at \",TEXT(O5,\"dd-mm-yy\"))","v":"Amounts Owing/(Refundable) at 30-06-24"},null,{"$f":"F49-F76","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,"GST","Interest","Penalties","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine","Total"]
[null,null,null,null,null,null,null,null,"Withheld","Instal","Instal","Credits","Car Tax","Eq Tax"]
[]
[null,null,null,null,null,"Go to the ATO website to view PS LA 2011/20 on allocating part payments of tax debts"]
[]
[{"$f":"IF(OR(F86<>0,G86<>0,H86<>0,I86<>0,J86<>0,K86<>0,L86<>0,M86<>0,N86<>0,O86<>0),0,\"blank\")","v":"blank"}]

{"sheet":"GST Collected & Paid NEW","index":2,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,11,1,12],[2,11,2,12]]}
[]
["ℹ","GST Collected & Paid",null,null,null,"Profit & Loss Statement",null,null,null,null,null,{"$f":"'BAS Summary'!N1","v":"Client Name"}]
[null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,{"$f":"B3","v":"Year Ended 30 June 2024"},null,null,null,null,null,{"$f":"'BAS Summary'!N2","v":"Preparer Name"}]
[]
[null,"Summary","Sales","Purchases",null,"Paste here"]
[]
[null,"Totals from P & L statement (excl GST)"]
[null,"Capital Subject to GST (excl GST)"]
[null,null,{"$f":"C7+C8","v":0},{"$f":"D7+D8","v":0}]
[null,"Less items not subject to GST below",{"$f":"SUM(C18:C528)","v":0},{"$f":"SUM(D18:D528)","v":0}]
[null,"Amounts subject to GST",{"$f":"C9-C10","v":0},{"$f":"D9-D10","v":0}]
[null,"GST @ 10%",{"$f":"C11*0.1","v":0},{"$f":"D11*0.1","v":0}]
[null,"GST per BAS Summary",{"$f":"'BAS Summary'!E23","v":0},{"$f":"'BAS Summary'!F23","v":0}]
[null,"Reconciliation balance",{"$f":"C13-C12","v":0},{"$f":"D13-D12","v":0}]
[]
[null,"Amounts Not Subject to GST","Sales","Purchases"]

{"sheet":"GST Collected & Paid OLD","index":3,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,5,50,6],[51,5,51,6],[52,5,52,6],[54,5,54,6],[5,6,5,7],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[34,1,34,2],[34,5,34,6],[35,1,35,2],[35,5,35,6],[36,5,36,6],[37,1,37,2],[37,5,37,6],[39,1,42,3],[43,1,46,3],[31,1,31,2],[31,5,31,6],[32,1,32,2],[32,5,32,6],[33,1,33,2],[33,5,33,6],[28,1,28,2],[28,5,28,6],[29,1,29,2],[29,5,29,6],[30,1,30,2],[30,5,30,6],[25,1,25,2],[25,5,25,6],[26,1,26,2],[26,5,26,6],[27,1,27,2],[27,5,27,6],[21,1,21,2],[21,5,21,6],[22,5,22,6],[23,1,23,2],[23,5,23,6],[24,5,24,6],[0,6,0,7],[1,6,1,7],[7,1,7,3],[7,5,7,7],[10,1,10,2],[10,5,10,6],[4,1,4,2],[5,1,5,2],[4,6,4,7],[16,1,16,2],[16,5,16,6],[17,1,17,2],[17,5,17,6],[19,1,19,2],[19,5,19,6],[5,9,6,15],[4,9,4,15],[47,1,48,3],[9,1,9,2],[9,5,9,6],[11,1,11,2],[11,5,11,6],[12,1,12,2],[12,5,12,6],[13,1,13,2],[13,5,13,6],[14,1,14,2],[14,5,14,6],[15,1,15,2],[15,5,15,6],[24,1,24,2]]}
[null,"GST Collected & Paid",null,null,null,null,{"$f":"'BAS Summary'!N1:N1","v":"Client Name"}]
[null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,null,{"$f":"'BAS Summary'!N2:N2","v":"Preparer Name"}]
[]
[]
[null,"GST Accounting Method for BAS",null,{"$f":"IF('BAS Summary'!E5<>\"Select\",'BAS Summary'!E5,\"\")","v":""},null,{"$f":"'BAS Summary'!N4","v":"ABN"},{"$f":"IF('BAS Summary'!O4:O4<>\"\",'BAS Summary'!O4:O4,\"\")","v":""},null,null,"Financial Reports"]
[null,"Accounting Method in Financial Reports",null,{"$f":"IF('BAS Summary'!E6<>\"Select\",'BAS Summary'!E6,\"\")","v":""},null,{"$f":"'BAS Summary'!N5","v":"Balance Date"},{"$f":"'BAS Summary'!O5:O5","v":"2024-06-30"},null,null,"Where the GST accounting method for BAS purposes is cash, use cash-based financial reports to reconcile where possible and ignore debtors and creditors."]
[]
[null,"Sales per Financial Report",null,null,null,"Purchases per Financial Report"]
[]
[null,"Sales",null,null,null,"Purchases"]
[null,"Professional Fees",null,null,null,"Other Cost of Goods Sold"]
[null,"Contract Income",null,null,null,"Direct Expenses"]
[null,"FBT Contributions",null,null,null,"Overhead Expenses"]
[null,"Sale of Fixed Assets",null,null,null,"Capital Purchases"]
[null,null,null,null,null,"Prepayments"]
[]
[]
[]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Opening Debtors (note below)\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Closing Debtors (note below)\",\"No Adjustment for Debtors Required\"))","v":"No Adjustment for Debtors Required"},null,{"$f":"IF(B19<>\"No Adjustment for Debtors Required\",C19/11*10,0)","v":0},null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Opening Creditors (note below)\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Closing Creditors (note below)\",\"No Adjustment for Creditors Required\"))","v":"No Adjustment for Creditors Required"},null,{"$f":"IF(F19<>\"No Adjustment for Creditors Required\",G19/11*10,0)","v":0}]
[null,"Sub-Total",null,{"$f":"SUM(D10:D19)","v":0},null,"Sub-total",null,{"$f":"SUM(H10:H19)","v":0}]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"less Closing Debtors (note below)\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"less Opening Debtors (note below)\",\"No Adjustment for Debtors Required\"))","v":"No Adjustment for Debtors Required"},null,{"$f":"C21/11*10","v":0},null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"less Closing Creditors (note below)\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"less Opening Creditors (note below)\",\"No Adjustment for Creditors Required\"))","v":"No Adjustment for Creditors Required"},null,{"$f":"G21/11*10","v":0}]
[null,"Total Sales for GST Purposes",null,{"$f":"D20-D21","v":0},null,"Total Purchases for GST Purposes",null,{"$f":"H20-H21","v":0}]
[]
[null,"Less Sales Not Subject to GST",null,null,null,"Less Purchases Not Subject to GST"]
[null,"GST-free sales",null,null,null,"Amortisation"]
[null,"Input-taxed sales",null,null,null,"Bank Charges"]
[null,"Export sales",null,null,null,"Borrowing Costs"]
[null,null,null,null,null,"Depreciation"]
[null,null,null,null,null,"Donations"]
[null,null,null,null,null,"Entertainment"]
[null,null,null,null,null,"Filing Fees"]
[null,null,null,null,null,"Fines"]
[null,"Total Sales Not Subject to GST",null,{"$f":"SUM(D25:D32)","v":0},null,"Fringe Benefits Tax"]
[null,"Total Sales Subject to GST",null,{"$f":"D22-D33","v":0},null,"Hire Purchase Charges"]
[null,"GST Collected Above @ 10%",null,{"$f":"IF(D34>0,ROUND(D34*0.1,0),0)","v":0},null,"Insurance - Personal"]
[null,"GST Collected per BAS",null,{"$f":"'BAS Summary'!E23","v":0},null,"Interest"]
[null,null,null,null,null,"Licences & Government Fees"]
[null,{"$f":"IF(D35<>D36,\"Discrepancy\",\"\")","v":""},null,{"$f":"IF(D35=D36,\"Agrees\",D35-D36)","v":"Agrees"},null,"Motor Vehicle Registration"]
[null,null,null,null,null,"Rates & Taxes"]
[null,"NOTE 1:  You will only need to make adjustments above for Debtors and Creditors where the GST Accounting Method for BAS preparation is not the same as the Accounting Method in Financial Reports produced for this reconciliation.",null,null,null,"Salaries & Wages"]
[null,null,null,null,null,"Staff Amenities"]
[null,null,null,null,null,"Stamp Duty"]
[null,null,null,null,null,"Subcontractors Not Registered for GST"]
[null,"NOTE 2:  Opening Debtor and Creditor balances should exclude\ninvoices without GST.  Closing Debtor and Creditor balances should include all invoices as the reconciliation process will identify those invoices without GST.",null,null,null,"Superannuation"]
[]
[]
[]
[null,"NOTE 3:  All Debtor and Creditor balances entered above should\nbe shown at their GST-inclusive value."]
[]
[null,null,null,null,null,"Total Purchases Not Subject to GST",null,{"$f":"SUM(H25:H49)","v":0}]
[null,null,null,null,null,"Total Purchases Subject to GST",null,{"$f":"H22-H50","v":0}]
[null,null,null,null,null,"GST Paid Above @ 10%",null,{"$f":"IF(H51>0,ROUND(H51*0.1,0),0)","v":0}]
[null,null,null,null,null,"GST Paid per BAS",null,{"$f":"'BAS Summary'!F23","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(H52<>H53,\"Discrepancy\",\"\")","v":""},null,{"$f":"IF(H52<>H53,H52-H53,\"Agrees\")","v":"Agrees"}]

{"sheet":"GST Owing","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,6,4,7],[26,1,26,2],[12,1,12,2],[13,1,13,2],[12,5,12,6],[13,5,13,6],[20,1,20,2],[19,1,19,2],[24,5,24,6],[24,1,24,2],[14,5,14,6],[22,5,22,6],[17,5,17,6],[11,1,11,2],[14,1,14,2],[4,1,4,2],[23,5,23,6],[21,5,21,6],[15,1,15,2],[16,1,16,2],[18,1,18,2],[10,5,10,6],[16,5,16,6],[10,1,10,2],[17,1,17,2],[5,6,5,7],[8,1,8,3],[8,5,8,7],[15,5,15,6],[11,5,11,6],[5,1,5,2]]}
[null,"GST Liability Reconciliation",null,null,null,null,null,{"$f":"'BAS Summary'!N1","v":"Client Name"}]
[null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,null,null,{"$f":"'BAS Summary'!N2","v":"Preparer Name"}]
[]
[]
[null,"GST Accounting Method for BAS",null,{"$f":"IF('BAS Summary'!E5<>\"Select\",'BAS Summary'!E5,\"\")","v":""},null,"ABN",{"$f":"IF('BAS Summary'!O4<>\"\",'BAS Summary'!O4,\"\")","v":""}]
[null,"Accounting Method in Financial Reports",null,{"$f":"IF('BAS Summary'!E6<>\"Select\",'BAS Summary'!E6,\"\")","v":""},null,"Balance Date",{"$f":"'BAS Summary'!O5:O5","v":"2024-06-30"}]
[]
[]
[null,"GST Liability from Activity Statements",null,null,null,"GST Liability from General Ledger"]
[]
[null,"Owing/(Refundable) from BAS Summary",null,{"$f":"'BAS Summary'!F77","v":0},null,"GST Collected"]
[null,"Add/(Deduct) Adjustments to BAS Lodged",null,null,null,"Refunds from ATO"]
[]
[]
[]
[]
[]
[]
[null,"GST Owing/(Refundable) after Adjustments",null,{"$f":"SUM(D11:D18)","v":0},null,"Total GST Credit Balances in Ledger",null,{"$f":"SUM(H11:H18)","v":0}]
[]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Add GST on Debtors:\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Add GST on Creditors:\",\"No Debtor or Creditor Adjustment\"))","v":"No Debtor or Creditor Adjustment"},null,null,null,"Less"]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Closing Debtors\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Closing Creditors\",\"\"))","v":""},null,{"$f":"C22/11","v":0},null,"GST Paid"]
[null,"Sub-Total",null,{"$f":"D19+D22","v":0},null,"Payments to ATO"]
[]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Less GST on Creditors:\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Less GST on Debtors:\",\"No Debtor or Creditor Adjustment\"))","v":"No Debtor or Creditor Adjustment"}]
[null,{"$f":"IF(AND($D$5=\"Cash\",$D$6=\"Accruals\"),\"Closing Creditors\",IF(AND($D$5=\"Accruals\",$D$6=\"Cash\"),\"Closing Debtors\",\"\"))","v":""},null,{"$f":"C26/11","v":0},null,"Total GST Debit Balances in Ledger",null,{"$f":"SUM(H22:H25)","v":0}]
[null,"Expected GST Liability in Ledger",null,{"$f":"D23-D26","v":0},null,"Actual GST Liability in Ledger",null,{"$f":"H19-H26","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(D27<>H27,\"Reconciliation Error\",\"\")","v":""},{"$f":"IF(D27<>H27,D27-H27,\"Reconciled\")","v":"Reconciled"}]

{"sheet":"FBT Rec","index":5,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,5,12,6],[13,5,13,6],[16,5,16,6],[22,5,22,6],[23,5,23,6],[5,1,5,3],[5,5,5,8],[5,10,5,12],[10,5,10,6],[11,5,11,6],[25,5,25,6],[26,5,26,6],[21,10,21,12],[22,10,22,12],[23,10,23,12],[24,10,24,12],[24,5,24,6]]}
[]
[null,"FBT Reconciliation",null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N1","v":"Client Name"}]
[null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N2","v":"Preparer Name"}]
[]
[]
[null,"FBT Expense",null,null,null,"FBT Liability",null,null,null,null,{"$f":"CONCATENATE(\"Payments After\",\" \",TEXT('BAS Summary'!O5,\"dd/mm/yyyy\"))","v":"Payments After 30/06/2024"}]
[]
[null,{"$f":"CONCATENATE(\"Payable Per\",\" \",TEXT(Control!F4,\"yyyy\"),\" \",\"FBT Return (before instalments)\")","v":"Payable Per 2024 FBT Return (before instalments)"},null,null,null,{"$f":"CONCATENATE(\"Opening Balance as at\",\" \",TEXT(Control!F3,\"dd/mm/yyyy\"))","v":"Opening Balance as at 01/07/2023"},null,null,null,null,"Description","Date","Amount"]
[]
[null,"Add  ",null,null,null,"Add"]
[null,{"$f":"CONCATENATE(\"Jun\",\" \",TEXT(Control!F4,\"yyyy\"),\" Instalment\")","v":"Jun 2024 Instalment"},{"$f":"'BAS Summary'!K22","v":0},null,null,{"$f":"CONCATENATE(TEXT(Control!F4,\"yyyy\"),\" FBT Expense\")","v":"2024 FBT Expense"},null,{"$f":"D28","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H11:H14)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I8+I14","v":0}]
[null,null,null,null,null,"Less"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Balance Paid/(Refunded) Per\",\" \",TEXT(Control!F4,\"yyyy\"),\" \",\"Return\")","v":"Balance Paid/(Refunded) Per 2024 Return"}]
[null,null,null,{"$f":"SUM(C11:C18)","v":0},null,{"$f":"CONCATENATE(\"Payment - Jun\",\" \",TEXT(Control!F4,\"yyyy\")-1,\" Instalment\")","v":"Payment - Jun 2023 Instalment"},1,{"$f":"IF(G18=1,C21,0)","v":0}]
[null,null,null,{"$f":"D8+D18","v":0},null,{"$f":"CONCATENATE(\"Payment - Sep\",\" \",TEXT(Control!F4,\"yyyy\")-1,\" Instalment\")","v":"Payment - Sep 2023 Instalment"},1,{"$f":"IF(G19=1,'BAS Summary'!K13,0)","v":0},null,null,null,null,{"$f":"SUM(M9:M18)","v":0}]
[null,"Less",null,null,null,{"$f":"CONCATENATE(\"Payment - Dec\",\" \",TEXT(Control!F4,\"yyyy\")-1,\" Instalment\")","v":"Payment - Dec 2023 Instalment"},1,{"$f":"IF(G20=1,'BAS Summary'!K16,0)","v":0}]
[null,{"$f":"CONCATENATE(\"Jun\",\" \",TEXT(Control!F4,\"yyyy\")-1,\" Instalment\")","v":"Jun 2023 Instalment"},null,null,null,{"$f":"CONCATENATE(\"Payment - Mar\",\" \",TEXT(Control!F4,\"yyyy\"),\" Instalment\")","v":"Payment - Mar 2024 Instalment"},1,{"$f":"IF(G21=1,'BAS Summary'!K19,0)","v":0}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Payment - Jun\",\" \",TEXT(Control!F4,\"yyyy\"),\" Instalment\")","v":"Payment - Jun 2024 Instalment"},0,{"$f":"IF(G22=1,'BAS Summary'!K22,0)","v":0},null,null,"Warning"]
[null,null,null,null,null,null,null,null,null,null,"Do not use this sheet to calculate FBT for substituted accounting periods"]
[]
[]
[]
[null,null,null,{"$f":"SUM(C21:C27)","v":0},null,null,null,null,{"$f":"SUM(H17:H27)","v":0}]
[null,{"$f":"CONCATENATE(,,TEXT(Control!F4,\"yyyy\"),\" FBT Expense\")","v":"2024 FBT Expense"},null,{"$f":"D19-D27","v":0},null,{"$f":"CONCATENATE(\"Closing Balance as at\",\" \",TEXT('BAS Summary'!O5,\"dd/mm/yyyy\"))","v":"Closing Balance as at 30/06/2024"},null,null,{"$f":"I15-I27","v":0}]
[null,"General Ledger Balance",null,null,null,"General Ledger Balance"]
[null,"Discrepancy",null,{"$f":"D28-D29","v":0},null,"Discrepancy",null,null,{"$f":"I28-I29","v":0}]

{"sheet":"GST Worksheet","index":6,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[26,18,27,18],[9,19,10,19],[28,19,29,19],[26,14,27,16],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[26,6,27,8],[26,9,27,12],[29,4,29,5],[21,4,21,5],[22,4,22,5],[41,4,41,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[6,17,6,18],[13,4,13,5],[11,4,11,5],[8,7,8,10],[8,12,8,14],[12,4,12,5],[10,4,10,5],[7,4,7,5]]}
[]
[null,null,null,null,"GST Calculation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N1","v":"Client Name"},"HIDE"]
[null,null,null,null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N2","v":"Preparer Name"},"HIDE"]
[]
[]
[]
[null,null,null,null,"GST Period","Select",null,null,null,null,null,null,null,null,null,null,"ABN",{"$f":"'BAS Summary'!O4","v":0}]
[null,null,null,null,{"$f":"IF(AND(F7=\"Select\",OR(Q24<>0,S43<>0)),\"Warning:  GST period not selected\",\"\")","v":""}]
[null,null,null,null,null,null,"Sales","Less Sales Not Subject to GST",null,null,null,null,"Adjustments & Corrections",null,null,null,"GST"]
[null,null,null,null,null,null,"Total Sales (incl GST)","Export\nSales","Other\nGST-Free Sales","Input Taxed Sales","Total Sales Not Subject to GST","Sales Subject to GST","Adjustments (if applic)","Corrections to Previous Act Stats","Total Adjustments /Corrections","Taxable\nSales ","GST on Sales\n(1A on BAS)",null,null,"Figs for transfer"]
[null,null,null,null,"GST Payable on Sales",null,"G1","G2","G3","G4","G5","G6","G7",null,null,"G8","G9"]
[null,null,null,null,{"$f":" 'BAS Summary'!D11","v":"2023-07-31"},null,null,null,null,null,{"$f":"SUM(H12:J12)","v":0},{"$f":"G12-K12","v":0},null,null,{"$f":"M12+N12","v":0},{"$f":"L12+O12","v":0},{"$f":"P12/11","v":0},null,null,{"$f":"IF($F$7=\"Monthly\",Q12,0)","v":0}]
[null,null,null,null,{"$f":" 'BAS Summary'!D12","v":"2023-08-31"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q13,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D13","v":" Sep 23  /  Quarter 1"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q14,0)+IF($F$7=\"Quarterly\",SUM(Q12:Q14),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D14","v":"2023-10-31"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q15,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D15","v":"2023-11-30"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q16,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D16","v":" Dec 23  /  Quarter 2"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q17,0)+IF($F$7=\"Quarterly\",SUM(Q15:Q17),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D17","v":"2024-01-31"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q18,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D18","v":"2024-02-29"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q19,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D19","v":" Mar 24  /  Quarter 3"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q20,0)+IF($F$7=\"Quarterly\",SUM(Q18:Q20),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D20","v":"2024-04-30"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q21,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D21","v":"2024-05-31"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q22,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D22","v":" Jun 24  /  Quarter 4  /  Annual"},null,null,null,null,null,0,0,null,null,0,0,0,null,null,{"$f":"IF($F$7=\"Monthly\",Q23,0)+IF($F$7=\"Quarterly\",SUM(Q21:Q23),0)+IF($F$7=\"Annually\",Q24,0)","v":0}]
[null,null,null,null,"Totals",null,{"$f":"SUM(G12:G23)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(T12:T23)","v":0}]
[]
[]
[null,null,null,null,null,null,"Purchases",null,null,"Less Purchases Not Subject to GST",null,null,null,null,"Adjustments & Corrections",null,null,null,"GST"]
[]
[null,null,null,null,null,null,"Capital Purchases (incl GST)","Non-Capital Purchases (incl GST)","Total Purchases","Purchases for Input Taxed Sales","Purchases Without GST in the Price","Private Use & Non-Deductible","Purchases Not Subject to GST","Purchases Subject to GST","Adjustments (if applic)","Corrections to Previous Act Stats","Total Adjustments /Corrections","Purchases on Which to Claim GST","GST on Purchases\n(1B on BAS)","Figs for transfer"]
[null,null,null,null,"GST Refundable on Purchases",null,"G10","G11","G12","G13","G14","G15","G16","G17","G18",null,null,"G19","G20"]
[null,null,null,null,{"$f":"E12","v":"2023-07-31"},null,null,null,{"$f":"G31+H31","v":0},null,null,null,{"$f":"SUM(J31:L31)","v":0},{"$f":"I31-M31","v":0},null,null,{"$f":"O31+P31","v":0},{"$f":"N31+Q31","v":0},{"$f":"R31/11","v":0},{"$f":"IF($F$7=\"Monthly\",S31,0)","v":0}]
[null,null,null,null,{"$f":"E13","v":"2023-08-31"},null,null,null,{"$f":"G32+H32","v":0},null,null,null,{"$f":"SUM(J32:L32)","v":0},{"$f":"I32-M32","v":0},null,null,{"$f":"O32+P32","v":0},{"$f":"N32+Q32","v":0},{"$f":"R32/11","v":0},{"$f":"IF($F$7=\"Monthly\",S32,0)","v":0}]
[null,null,null,null," Sep 23  /  Quarter 1",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S33,0)+IF($F$7=\"Quarterly\",SUM(S31:S33),0)","v":0}]
[null,null,null,null,"2023-10-31",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S34,0)","v":0}]
[null,null,null,null,"2023-11-30",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S35,0)","v":0}]
[null,null,null,null," Dec 23  /  Quarter 2",null,null,null,0,null,null,null,{"$f":"SUM(J36:L36)","v":0},0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S36,0)+IF($F$7=\"Quarterly\",SUM(S34:S36),0)","v":0}]
[null,null,null,null,"2024-01-31",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S37,0)","v":0}]
[null,null,null,null,"2024-02-29",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S38,0)","v":0}]
[null,null,null,null," Mar 24  /  Quarter 3",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S39,0)+IF($F$7=\"Quarterly\",SUM(S37:S39),0)","v":0}]
[null,null,null,null,"2024-04-30",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S40,0)","v":0}]
[null,null,null,null,"2024-05-31",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S41,0)","v":0}]
[null,null,null,null," Jun 24  /  Quarter 4  /  Annual",null,null,null,0,null,null,null,0,0,null,null,0,0,0,{"$f":"IF($F$7=\"Monthly\",S42,0)+IF($F$7=\"Quarterly\",SUM(S40:S42),0)+IF($F$7=\"Annually\",S43,0)","v":0}]
[null,null,null,null,"Totals",null,{"$f":"SUM(G31:G42)","v":0},0,0,{"$f":"SUM(J31:J42)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(T31:T42)","v":0}]

{"sheet":"PAYG Instalment Worksheet","index":7,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,4,6,6],[7,6,8,8],[7,9,8,12],[7,13,8,15],[15,4,15,5],[15,16,15,17],[21,16,21,17],[11,16,11,17],[12,16,12,17],[22,4,22,5],[22,16,22,17],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[9,18,10,18],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[14,16,14,17],[13,16,13,17],[6,16,6,17],[17,16,17,17],[18,16,18,17],[19,16,19,17],[20,16,20,17],[16,16,16,17],[10,16,10,17]]}
[]
[null,null,null,null,"PAYG Instalment Calculation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N1","v":"Client Name"},"HIDE"]
[null,null,null,null,{"$f":"'BAS Summary'!C2","v":"Year Ended 30 June 2024"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!N2","v":"Preparer Name"}]
[]
[]
[null,null,null,null,"PAYGI Period","Select"]
[null,null,null,null,{"$f":"IF(AND(F6=\"Select\",P24<>0),\"Warning:  PAYGI period not selected\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"ABN",{"$f":"'BAS Summary'!O4","v":0}]
[null,null,null,null,null,null,"Option 1 - Instalment Amount",null,null,"Option 2 - Instalment Income Times Rate",null,null,null,"Instalment Payable"]
[]
[null,null,null,null,null,null,"ATO Instalment","Estimated Tax for the Year","Varied Instalment","PAYG Instalment Income","EITHER\nATO Rate","OR\nVaried Rate","Instalment Amount","PAYG Instalment","Less Credit from PAYGI Variation","PAYG Instalment Payable",null,null,"Figs for transfer"]
[null,null,null,null,null,null,"T7","T8","T9","T1","T2","T3","T11","5A","5B",null,"Select Instalment Option"]
[null,null,null,null,{"$f":"'BAS Summary'!D11","v":"2023-07-31"},null,null,null,null,null,null,null,{"$f":"IF(L12>0,J12*L12,J12*K12)","v":0},{"$f":"IF(Q12=\"Use ATO Instalment\",G12,0)+IF(Q12=\"Use Varied Instalment\",I12,0)+IF(Q12=\"Use Income Times Rate\",M12,0)","v":0},null,{"$f":"N12-O12","v":0},null,null,{"$f":"IF($F$6=\"Monthly\",P12,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D12","v":"2023-08-31"},null,null,null,null,null,null,null,{"$f":"IF(L13>0,J13*L13,J13*K13)","v":0},{"$f":"IF(Q13=\"Use ATO Instalment\",G13,0)+IF(Q13=\"Use Varied Instalment\",I13,0)+IF(Q13=\"Use Income Times Rate\",M13,0)","v":0},null,{"$f":"N13-O13","v":0},null,null,{"$f":"IF($F$6=\"Monthly\",P13,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D13","v":" Sep 23  /  Quarter 1"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P14,0)+IF($F$6=\"Quarterly\",SUM(P12:P14),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D14","v":"2023-10-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P15,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D15","v":"2023-11-30"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P16,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D16","v":" Dec 23  /  Quarter 2"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P17,0)+IF($F$6=\"Quarterly\",SUM(P15:P17),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D17","v":"2024-01-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P18,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D18","v":"2024-02-29"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P19,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D19","v":" Mar 24  /  Quarter 3"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P20,0)+IF($F$6=\"Quarterly\",SUM(P18:P20),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D20","v":"2024-04-30"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P21,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D21","v":"2024-05-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P22,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!D22","v":" Jun 24  /  Quarter 4  /  Annual"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$6=\"Monthly\",P23,0)+IF($F$6=\"Quarterly\",SUM(P21:P23),0)+IF($F$6=\"Annually\",P24,0)","v":0}]
[null,null,null,null,"Totals",null,null,null,null,{"$f":"SUM(J12:J23)","v":0},null,null,null,0,0,0,null,null,{"$f":"SUM(S12:S23)","v":0}]

{"sheet":"DIY","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}