{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["BAS Summary","GST Collected & Paid NEW","GST Collected & Paid OLD","GST Owing","FBT Rec","GST Worksheet","PAYG Instalment Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":5,"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":"BAS Summary","index":0,"n_rows":86,"n_cols":25,"rows_kept":86,"cut":false,"hidden":false,"merged":[[19,24,19,27],[13,24,14,27],[18,24,18,27],[17,24,17,27],[16,24,16,27],[15,24,15,27],[4,21,4,22],[1,14,1,16],[7,3,7,16],[25,4,25,15],[4,15,4,16],[5,15,5,16],[24,3,24,16],[2,20,3,20],[0,14,0,16],[83,6,83,15],[45,4,45,5],[52,4,52,5],[9,16,10,16],[50,4,50,6],[44,4,44,5],[47,4,47,5],[48,4,48,5],[53,4,53,5],[34,4,34,15],[51,4,51,5],[76,4,76,5],[49,4,49,5],[46,4,46,5],[4,3,4,4]]}
[null,null,"ℹ","BAS Summary",null,null,null,null,null,null,null,null,null,null,"Client Name",null,null,null,null,"HIDE","HIDE"]
[null,null,null,{"$f":"CONCATENATE(\"Year Ended\",\" \",TEXT(P6,\"dd mmmm yyyy\"))","v":"Year Ended 30 June 2023"},null,null,null,null,null,null,null,null,null,null,"Preparer Name",null,null,null,null,"HIDE","HIDE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status List"]
[]
[null,null,null,"Accounting Methods for Reconciliations",null,null,null,null,{"$f":"IF(OR(AND('GST Worksheet'!Q24<>0,'GST Worksheet'!Q24<>'BAS Summary'!F24),AND('GST Worksheet'!S43<>0,'GST Worksheet'!S43<>'BAS Summary'!G24)),\"WARNING:  Figures in the GST worksheet do not agree with this summary\",\"\")","v":""},null,null,null,null,null,"ABN",null,null,null,null,"From Date",null,"Rolling Forward"]
[null,null,null,"Activity Statements",null,"Select",null,null,{"$f":"IF(AND('PAYG Instalment Worksheet'!P24<>0,'PAYG Instalment Worksheet'!P24<>'BAS Summary'!K24),\"WARNING:  Figures in the PAYGI worksheet do not agree with this summary\",\"\")","v":""},null,null,null,null,null,"Balance Date","2023-06-30",null,null,null,{"$f":"EOMONTH(P6,-12)+1","v":"2022-07-01"},"C","First SAP Date","Done2023"]
[null,null,null,"Financial Report",null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T11","v":"2023-01-31"},"E","Update balance date from drop down list","Done2023"]
[null,null,null,"Summary of Activity Statements Lodged with the ATO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAP"]
[null,null,null,"Form",null,"GST Collected","GST","GST","Gross","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine","Payable","Paid In Full",null,null,"2022-12-31"]
[null,null,null,"Status","Period","Or Instalment","Paid","Balance","Wages","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","(Refund)",null,null,null,{"$f":"EOMONTH(T10,1)","v":"2023-01-31"}]
[null,null,null,null,{"$f":"EOMONTH($P$6,-11)","v":"2022-07-31"},null,null,{"$f":"F12-G12","v":0},null,null,null,null,null,null,null,{"$f":"H12+J12+K12+L12+M12+N12+O12","v":0},1,null,null,{"$f":"EOMONTH(T11,1)","v":"2023-02-28"},null,null,null,null,"<<<  Enter 1 for yes or enter 0 or leave blank for no"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-10)","v":"2022-08-31"},null,null,{"$f":"F13-G13","v":0},null,null,null,null,null,null,null,{"$f":"H13+J13+K13+L13+M13+N13+O13","v":0},1,null,null,"2023-03-31"]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(P6,-9),\" mmm yy\"),\"  /  Quarter 1\")","v":" Sep 22  /  Quarter 1"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-04-30",null,null,null,null,"How To Copy This Summary To\nAn Annual Accounts Jobpaper file"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-8)","v":"2022-10-31"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-05-31"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-7)","v":"2022-11-30"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-06-30",null,null,null,null,"1. Open the Annual Accounts Jobpaper file"]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(P6,-6),\" mmm yy\"),\"  /  Quarter 2\")","v":" Dec 22  /  Quarter 2"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-07-31",null,null,null,null,"2. For each column here to be copied -"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-5)","v":"2023-01-31"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-08-31",null,null,null,null,"(a) Select those cells with your mouse"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-4)","v":"2023-02-28"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-09-30",null,null,null,null,"(b) Right click and select copy"]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(EOMONTH(P6,-3),\" mmm yy\"),\"  /  Quarter 3\")","v":" Mar 23  /  Quarter 3"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-10-31",null,null,null,null,"(c) Paste into the corresponding column"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-2)","v":"2023-04-30"},null,null,0,null,null,null,null,null,null,null,0,1,null,null,"2023-11-30"]
[null,null,null,null,{"$f":"EOMONTH($P$6,-1)","v":"2023-05-31"},null,null,0,null,null,null,null,null,null,null,0,1]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(P6,\" mmm yy\"),\"  /  Quarter 4\",\"  /  Annual\")","v":" Jun 23  /  Quarter 4  /  Annual"},null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,"Totals",{"$f":"SUM(F12:F23)","v":0},{"$f":"SUM(G12:G23)","v":0},0,0,0,0,0,{"$f":"SUM(M12:M23)","v":0},0,0,{"$f":"SUM(P12:P23)","v":0}]
[null,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,null,"Reconcile with Client Accounting System"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($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,$P$30>0,$F$31>0,$G$31>0,$H$31>0,$I$31>0,$J$31>0,$K$31>0,$L$31>0,$M$31>0,$N$31>0,$O$31>0,$P$31>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,"GST","GST","GST","Gross","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine",null,null,null,null,{"$f":"IF(OR($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,$P$30>0,$F$31>0,$G$31>0,$H$31>0,$I$31>0,$J$31>0,$K$31>0,$L$31>0,$M$31>0,$N$31>0,$O$31>0,$P$31>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,"Collected","Paid","Balance","Wages","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","Total",null,null,null,{"$f":"IF(OR($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,$P$30>0,$F$31>0,$G$31>0,$H$31>0,$I$31>0,$J$31>0,$K$31>0,$L$31>0,$M$31>0,$N$31>0,$O$31>0,$P$31>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,"Client Annual Totals",null,null,{"$f":"F30-G30","v":0},null,null,null,null,null,null,null,{"$f":"H30+J30+K30+L30+M30+N30+O30","v":0},null,null,null,{"$f":"IF(OR($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,$P$30>0,$F$31>0,$G$31>0,$H$31>0,$I$31>0,$J$31>0,$K$31>0,$L$31>0,$M$31>0,$N$31>0,$O$31>0,$P$31>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,"BAS Above",{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"F31-G31","v":0},{"$f":"I24","v":0},{"$f":"J24","v":0},0,0,0,0,0,{"$f":"H31+J31+K31+L31+M31+N31+O31","v":0},null,null,null,{"$f":"IF(OR($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,$P$30>0,$F$31>0,$G$31>0,$H$31>0,$I$31>0,$J$31>0,$K$31>0,$L$31>0,$M$31>0,$N$31>0,$O$31>0,$P$31>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,"Variation",{"$f":"F30-F31","v":0},{"$f":"G30-G31","v":0},{"$f":"F32-G32","v":0},{"$f":"I30-I31","v":0},{"$f":"J30-J31","v":0},0,0,0,0,0,{"$f":"P30-P31","v":0}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Calculate Amounts Owing to ATO at \",TEXT(P6,\"dd mmm yyyy\"))","v":"Calculate Amounts Owing to ATO at 30 Jun 2023"}]
[]
[null,null,null,null,null,null,null,null,null,"PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine"]
[null,null,null,null,null,null,"GST","Interest","Penalties","Withheld","Instal","Instal","Credits","Car Tax","Eq Tax","Total"]
[null,null,null,null,"Activity Statement Debts & (Refunds Due)"]
[null,null,null,null,"Prior Year Debts/(Refunds) Brought Forward",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G40:O40)","v":0}]
[null,null,null,null,"Less Payments Made & Refunds Received",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G41:O41)","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(\"Prior Year Debts/(Refunds) at \",TEXT(P6,\"dd mmm\"))","v":"Prior Year Debts/(Refunds) at 30 Jun"},null,{"$f":"G40-G41","v":0},{"$f":"H40-H41","v":0},0,0,{"$f":"K40-K41","v":0},{"$f":"L40-L41","v":0},{"$f":"M40-M41","v":0},0,0,{"$f":"P40-P41","v":0}]
[null,null,null,null,"Current Year Debts/(Refunds) as Above",null,{"$f":"H24","v":0},null,null,{"$f":"J24","v":0},0,0,0,0,0,{"$f":"G43+H43+I43+J43+K43+L43+M43+N43+O43","v":0},null,null,null,{"$f":"IF(OR(G44<>0,H44<>0,I44<>0,J44<>0,K44<>0,L44<>0,M44<>0,N44<>0,O44<>0,P44<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,"General Interest Charge (GIC) & Penalties",null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Total Amounts Owing/(Refundable)",null,{"$f":"SUM(G42:G49)","v":0},{"$f":"SUM(H42:H49)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Less Payments, (Refunds) & (Credits)"]
[null,null,null,null,"ATO Interest Received",null,null,null,null,null,null,null,null,null,null,{"$f":"H53","v":0},null,null,null,{"$f":"IF(OR(G54<>0,H54<>0,I54<>0,J54<>0,K54<>0,L54<>0,M54<>0,N54<>0,O54<>0,P54<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,"Payments/(Refunds) as Ticked Above",null,{"$f":"SUMIF($Q$12:$Q$23,1,H12:H23)","v":0},null,null,{"$f":"SUMIF($Q$12:$Q$23,1,J12:J23)","v":0},0,0,0,0,0,{"$f":"SUM(G54:O54)","v":0}]
[null,null,null,null,"Other Payments/(Refunds) Etc","Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G56:O56)","v":0},null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Total Payments, (Refunds) & (Credits)",null,{"$f":"SUM(G53:G76)","v":0},{"$f":"SUM(H53:H76)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"CONCATENATE(\"Amounts Owing/(Refundable) at \",TEXT(P6,\"dd-mm-yy\"))","v":"Amounts Owing/(Refundable) at 30-06-23"},null,{"$f":"G50-G77","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G78:O78)","v":0}]
[]
[]
[null,null,null,null,null,null,"GST","Interest","Penalties","PAYG","PAYG","FBT","Fuel Tax","Luxury","Wine","Total"]
[null,null,null,null,null,null,null,null,null,"Withheld","Instal","Instal","Credits","Car Tax","Eq Tax"]
[]
[null,null,null,null,null,null,"Go to the ATO website to view PS LA 2011/20 on allocating part payments of tax debts"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G87<>0,H87<>0,I87<>0,J87<>0,K87<>0,L87<>0,M87<>0,N87<>0,O87<>0,P87<>0),0,\"blank\")","v":"blank"}]

{"sheet":"GST Collected & Paid NEW","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,12,1,13],[2,12,2,13]]}
[]
[null,"ℹ","GST Collected & Paid",null,null,null,"Profit & Loss Statement",null,null,null,null,null,{"$f":"'BAS Summary'!O1","v":"Client Name"}]
[null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,{"$f":"C3","v":"Year Ended 30 June 2023"},null,null,null,null,null,{"$f":"'BAS Summary'!O2","v":"Preparer Name"}]
[]
[null,null,"Summary","Sales","Purchases",null,"Paste here"]
[]
[null,null,"Totals from P & L statement (excl GST)"]
[null,null,"Capital Subject to GST (excl GST)"]
[null,null,null,{"$f":"D7+D8","v":0},{"$f":"E7+E8","v":0}]
[null,null,"Less items not subject to GST below",{"$f":"SUM(D18:D528)","v":0},{"$f":"SUM(E18:E528)","v":0}]
[null,null,"Amounts subject to GST",{"$f":"D9-D10","v":0},{"$f":"E9-E10","v":0}]
[null,null,"GST @ 10%",{"$f":"D11*0.1","v":0},{"$f":"E11*0.1","v":0}]
[null,null,"GST per BAS Summary",{"$f":"'BAS Summary'!F24","v":0},{"$f":"'BAS Summary'!G24","v":0}]
[null,null,"Reconciliation balance",{"$f":"D13-D12","v":0},{"$f":"E13-E12","v":0}]
[]
[null,null,"Amounts Not Subject to GST","Sales","Purchases"]

{"sheet":"GST Collected & Paid OLD","index":2,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,11,4,13],[47,3,48,5],[9,3,9,4],[9,7,9,8],[11,3,11,4],[11,7,11,8],[12,3,12,4],[12,7,12,8],[13,3,13,4],[13,7,13,8],[14,3,14,4],[14,7,14,8],[15,3,15,4],[15,7,15,8],[24,3,24,4],[24,7,24,8],[0,8,0,9],[1,8,1,9],[7,3,7,5],[7,7,7,9],[10,3,10,4],[10,7,10,8],[4,3,4,4],[5,3,5,4],[4,8,4,9],[16,3,16,4],[16,7,16,8],[17,3,17,4],[17,7,17,8],[19,3,19,4],[19,7,19,8],[21,3,21,4],[21,7,21,8],[22,7,22,8],[23,3,23,4],[23,7,23,8],[25,3,25,4],[25,7,25,8],[26,3,26,4],[26,7,26,8],[27,3,27,4],[27,7,27,8],[28,3,28,4],[28,7,28,8],[29,3,29,4],[29,7,29,8],[30,3,30,4],[30,7,30,8],[31,3,31,4],[31,7,31,8],[32,3,32,4],[32,7,32,8],[33,3,33,4],[33,7,33,8],[42,7,42,8],[43,7,43,8],[34,3,34,4],[34,7,34,8],[35,3,35,4],[35,7,35,8],[36,7,36,8],[37,3,37,4],[37,7,37,8],[39,3,42,5],[43,3,46,5],[5,11,7,13],[50,7,50,8],[51,7,51,8],[52,7,52,8],[54,7,54,8],[5,8,5,9],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8]]}
[null,null,null,"GST Collected & Paid",null,null,null,null,{"$f":"'BAS Summary'!O1:O1","v":"Client Name"}]
[null,null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,null,{"$f":"'BAS Summary'!O2:O2","v":"Preparer Name"}]
[]
[]
[null,null,null,"GST Accounting Method for BAS",null,{"$f":"IF('BAS Summary'!F6<>\"Select\",'BAS Summary'!F6,\"\")","v":""},null,{"$f":"'BAS Summary'!O5","v":"ABN"},{"$f":"IF('BAS Summary'!P5:P5<>\"\",'BAS Summary'!P5:P5,\"\")","v":""},null,null,"Financial Reports"]
[null,null,null,"Accounting Method in Financial Reports",null,{"$f":"IF('BAS Summary'!F7<>\"Select\",'BAS Summary'!F7,\"\")","v":""},null,{"$f":"'BAS Summary'!O6","v":"Balance Date"},{"$f":"'BAS Summary'!P6:P6","v":"2023-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,null,null,"Sales per Financial Report",null,null,null,"Purchases per Financial Report"]
[]
[null,null,null,"Sales",null,null,null,"Purchases"]
[null,null,null,"Professional Fees",null,null,null,"Other Cost of Goods Sold"]
[null,null,null,"Contract Income",null,null,null,"Direct Expenses"]
[null,null,null,"FBT Contributions",null,null,null,"Overhead Expenses"]
[null,null,null,"Sale of Fixed Assets",null,null,null,"Capital Purchases"]
[null,null,null,null,null,null,null,"Prepayments"]
[]
[]
[]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Opening Debtors (note below)\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Closing Debtors (note below)\",\"No Adjustment for Debtors Required\"))","v":"No Adjustment for Debtors Required"},null,{"$f":"IF(D19<>\"No Adjustment for Debtors Required\",E19/11*10,0)","v":0},null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Opening Creditors (note below)\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Closing Creditors (note below)\",\"No Adjustment for Creditors Required\"))","v":"No Adjustment for Creditors Required"},null,{"$f":"IF(H19<>\"No Adjustment for Creditors Required\",I19/11*10,0)","v":0}]
[null,null,null,"Sub-Total",null,{"$f":"SUM(F10:F19)","v":0},null,"Sub-total",null,{"$f":"SUM(J10:J19)","v":0}]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"less Closing Debtors (note below)\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"less Opening Debtors (note below)\",\"No Adjustment for Debtors Required\"))","v":"No Adjustment for Debtors Required"},null,{"$f":"E21/11*10","v":0},null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"less Closing Creditors (note below)\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"less Opening Creditors (note below)\",\"No Adjustment for Creditors Required\"))","v":"No Adjustment for Creditors Required"},null,{"$f":"I21/11*10","v":0}]
[null,null,null,"Total Sales for GST Purposes",null,{"$f":"F20-F21","v":0},null,"Total Purchases for GST Purposes",null,{"$f":"J20-J21","v":0}]
[]
[null,null,null,"Less Sales Not Subject to GST",null,null,null,"Less Purchases Not Subject to GST"]
[null,null,null,"GST-free sales",null,null,null,"Amortisation"]
[null,null,null,"Input-taxed sales",null,null,null,"Bank Charges"]
[null,null,null,"Export sales",null,null,null,"Borrowing Costs"]
[null,null,null,null,null,null,null,"Depreciation"]
[null,null,null,null,null,null,null,"Donations"]
[null,null,null,null,null,null,null,"Entertainment"]
[null,null,null,null,null,null,null,"Filing Fees"]
[null,null,null,null,null,null,null,"Fines"]
[null,null,null,"Total Sales Not Subject to GST",null,{"$f":"SUM(F25:F32)","v":0},null,"Fringe Benefits Tax"]
[null,null,null,"Total Sales Subject to GST",null,{"$f":"F22-F33","v":0},null,"Hire Purchase Charges"]
[null,null,null,"GST Collected Above @ 10%",null,{"$f":"IF(F34>0,ROUND(F34*0.1,0),0)","v":0},null,"Insurance - Personal"]
[null,null,null,"GST Collected per BAS",null,{"$f":"'BAS Summary'!F24","v":0},null,"Interest"]
[null,null,null,null,null,null,null,"Licences & Government Fees"]
[null,null,null,{"$f":"IF(F35<>F36,\"Discrepancy\",\"\")","v":""},null,{"$f":"IF(F35=F36,\"Agrees\",F35-F36)","v":"Agrees"},null,"Motor Vehicle Registration"]
[null,null,null,null,null,null,null,"Rates & Taxes"]
[null,null,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,null,null,"Staff Amenities"]
[null,null,null,null,null,null,null,"Stamp Duty"]
[null,null,null,null,null,null,null,"Subcontractors Not Registered for GST"]
[null,null,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,null,null,"NOTE 3:  All Debtor and Creditor balances entered above should\nbe shown at their GST-inclusive value."]
[]
[null,null,null,null,null,null,null,"Total Purchases Not Subject to GST",null,{"$f":"SUM(J25:J49)","v":0}]
[null,null,null,null,null,null,null,"Total Purchases Subject to GST",null,{"$f":"J22-J50","v":0}]
[null,null,null,null,null,null,null,"GST Paid Above @ 10%",null,{"$f":"IF(J51>0,ROUND(J51*0.1,0),0)","v":0}]
[null,null,null,null,null,null,null,"GST Paid per BAS",null,{"$f":"'BAS Summary'!G24","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(J52<>J53,\"Discrepancy\",\"\")","v":""},null,{"$f":"IF(J52<>J53,J52-J53,\"Agrees\")","v":"Agrees"}]

{"sheet":"GST Owing","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,7,10,8],[16,7,16,8],[10,3,10,4],[17,3,17,4],[5,8,5,9],[8,3,8,5],[8,7,8,9],[15,7,15,8],[11,7,11,8],[5,3,5,4],[23,7,23,8],[21,7,21,8],[15,3,15,4],[16,3,16,4],[18,3,18,4],[4,8,4,9],[26,3,26,4],[12,3,12,4],[13,3,13,4],[12,7,12,8],[13,7,13,8],[20,3,20,4],[19,3,19,4],[24,7,24,8],[24,3,24,4],[14,7,14,8],[22,7,22,8],[17,7,17,8],[11,3,11,4],[14,3,14,4],[4,3,4,4]]}
[null,null,null,"GST Liability Reconciliation",null,null,null,null,null,{"$f":"'BAS Summary'!O1","v":"Client Name"}]
[null,null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,null,null,{"$f":"'BAS Summary'!O2","v":"Preparer Name"}]
[]
[]
[null,null,null,"GST Accounting Method for BAS",null,{"$f":"'BAS Summary'!F6","v":"Select"},null,"ABN",{"$f":"'BAS Summary'!P5","v":0}]
[null,null,null,"Accounting Method in Financial Reports",null,{"$f":"'BAS Summary'!F7","v":"Select"},null,"Balance Date",{"$f":"'BAS Summary'!P6:P6","v":"2023-06-30"}]
[]
[]
[null,null,null,"GST Liability from Activity Statements",null,null,null,"GST Liability from General Ledger"]
[]
[null,null,null,"Owing/(Refundable) from BAS Summary",null,{"$f":"'BAS Summary'!G78","v":0},null,"GST Collected"]
[null,null,null,"Add/(Deduct) Adjustments to BAS Lodged",null,null,null,"Refunds from ATO"]
[]
[]
[]
[]
[]
[]
[null,null,null,"GST Owing/(Refundable) after Adjustments",null,{"$f":"SUM(F11:F18)","v":0},null,"Total GST Credit Balances in Ledger",null,{"$f":"SUM(J11:J18)","v":0}]
[]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Add GST on Debtors:\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Add GST on Creditors:\",\"No Debtor or Creditor Adjustment\"))","v":"No Debtor or Creditor Adjustment"},null,null,null,"Less"]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Closing Debtors\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Closing Creditors\",\"\"))","v":""},null,{"$f":"E22/11","v":0},null,"GST Paid"]
[null,null,null,"Sub-Total",null,{"$f":"F19+F22","v":0},null,"Payments to ATO"]
[]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Less GST on Creditors:\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Less GST on Debtors:\",\"No Debtor or Creditor Adjustment\"))","v":"No Debtor or Creditor Adjustment"}]
[null,null,null,{"$f":"IF(AND($F$5=\"Cash\",$F$6=\"Accruals\"),\"Closing Creditors\",IF(AND($F$5=\"Accruals\",$F$6=\"Cash\"),\"Closing Debtors\",\"\"))","v":""},null,{"$f":"E26/11","v":0},null,"Total GST Debit Balances in Ledger",null,{"$f":"SUM(J22:J25)","v":0}]
[null,null,null,"Expected GST Liability in Ledger",null,{"$f":"F23-F26","v":0},null,"Actual GST Liability in Ledger",null,{"$f":"J19-J26","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(F27<>J27,\"Reconciliation Error\",\"\")","v":""},{"$f":"IF(F27<>J27,F27-J27,\"Reconciled\")","v":"Reconciled"}]

{"sheet":"FBT Rec","index":4,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,6,5,8],[32,6,32,8],[5,11,5,12],[6,11,8,12]]}
[]
[null,null,"FBT Reconciliation",null,null,null,null,null,{"$f":"'BAS Summary'!O1","v":"Client Name"},"HIDE"]
[null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,null,null,{"$f":"'BAS Summary'!O2","v":"Preparer Name"},"HIDE"]
[]
[]
[null,null,"FBT Expense",null,null,null,"FBT Liability",null,null,null,null,"Warning"]
[null,null,null,null,null,null,null,null,null,null,null,"Do not use this sheet to calculate FBT for substituted accounting periods"]
[null,null,{"$f":"CONCATENATE(\"Amount Payable Per\",\" \",TEXT('BAS Summary'!T7,\"yyyy\"),\" \",\"FBT Return (before instalments)\")","v":"Amount Payable Per 2023 FBT Return (before instalments)"},null,null,null,{"$f":"CONCATENATE(\"Opening Balance as at\",\" \",TEXT('BAS Summary'!T6,\"dd/mm/yyyy\"))","v":"Opening Balance as at 01/07/2022"}]
[]
[null,null,"Add  ",null,null,null,"Add"]
[null,null,{"$f":"CONCATENATE(\"Jun\",\" \",TEXT('BAS Summary'!T7,\"yyyy\"),\" Instalment\")","v":"Jun 2023 Instalment"},{"$f":"'BAS Summary'!L23","v":0},null,null,{"$f":"CONCATENATE(TEXT('BAS Summary'!T7,\"yyyy\"),\" FBT Expense\")","v":"2023 FBT Expense"},{"$f":"E28","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,null,"Less"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Balance Paid/(Refunded) Per\",\" \",TEXT('BAS Summary'!T7,\"yyyy\"),\" \",\"Return\")","v":"Balance Paid/(Refunded) Per 2023 Return"}]
[null,null,null,null,{"$f":"SUM(D11:D18)","v":0},null,{"$f":"CONCATENATE(\"Payment - Jun\",\" \",TEXT('BAS Summary'!T7,\"yyyy\")-1,\" Instalment\")","v":"Payment - Jun 2022 Instalment"},{"$f":"IF(J18=TRUE,D21,0)","v":0},null,true]
[null,null,null,null,{"$f":"E8+E18","v":0},null,{"$f":"CONCATENATE(\"Payment - Sep\",\" \",TEXT('BAS Summary'!T7,\"yyyy\")-1,\" Instalment\")","v":"Payment - Sep 2022 Instalment"},{"$f":"IF(J19=TRUE,'BAS Summary'!L14,0)","v":0},null,true]
[null,null,"Less",null,null,null,{"$f":"CONCATENATE(\"Payment - Dec\",\" \",TEXT('BAS Summary'!T7,\"yyyy\")-1,\" Instalment\")","v":"Payment - Dec 2022 Instalment"},{"$f":"IF(J20=TRUE,'BAS Summary'!L17,0)","v":0},null,true]
[null,null,{"$f":"CONCATENATE(\"Jun\",\" \",TEXT('BAS Summary'!T7,\"yyyy\")-1,\" Instalment\")","v":"Jun 2022 Instalment"},null,null,null,{"$f":"CONCATENATE(\"Payment - Mar\",\" \",TEXT('BAS Summary'!T7,\"yyyy\"),\" Instalment\")","v":"Payment - Mar 2023 Instalment"},{"$f":"IF(J21=TRUE,'BAS Summary'!L20,0)","v":0},null,true]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Payment - Jun\",\" \",TEXT('BAS Summary'!T7,\"yyyy\"),\" Instalment\")","v":"Payment - Jun 2023 Instalment"},{"$f":"IF(J22=TRUE,'BAS Summary'!L23,0)","v":0},null,false]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(D21:D27)","v":0},null,null,null,{"$f":"SUM(H17:H27)","v":0}]
[null,null,{"$f":"CONCATENATE(,,TEXT('BAS Summary'!T7,\"yyyy\"),\" FBT Expense\")","v":"2023 FBT Expense"},null,{"$f":"E19-E27","v":0},null,{"$f":"CONCATENATE(\"Closing Balance as at\",\" \",TEXT('BAS Summary'!P6,\"dd/mm/yyyy\"))","v":"Closing Balance as at 30/06/2023"},null,{"$f":"I15-I27","v":0}]
[null,null,"General Ledger Balance",null,null,null,"General Ledger Balance"]
[null,null,"Discrepancy",null,{"$f":"E28-E29","v":0},null,"Discrepancy",null,{"$f":"I28-I29","v":0}]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Payments After\",\" \",TEXT('BAS Summary'!P6,\"dd/mm/yyyy\"))","v":"Payments After 30/06/2023"}]
[]
[null,null,null,null,null,null,"Description","Date","Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I36:I45)","v":0}]

{"sheet":"GST Worksheet","index":5,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,17,6,18],[13,4,13,5],[11,4,11,5],[8,7,8,10],[8,12,8,14],[12,4,12,5],[6,6,6,8],[10,4,10,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],[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]]}
[]
[null,null,null,null,"GST Calculation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!O1","v":"Client Name"},"HIDE"]
[null,null,null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!O2","v":"Preparer Name"},"HIDE"]
[]
[]
[]
[null,null,null,null,"GST Period","Select",{"$f":"IF(AND(F7=\"Select\",OR(Q24<>0,S43<>0)),\"Warning:  GST period not selected\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"ABN",{"$f":"'BAS Summary'!P5","v":0}]
[]
[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'!E12","v":"2022-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'!E13","v":"2022-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'!E14","v":" Sep 22  /  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'!E15","v":"2022-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'!E16","v":"2022-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'!E17","v":" Dec 22  /  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'!E18","v":"2023-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'!E19","v":"2023-02-28"},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'!E20","v":" Mar 23  /  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'!E21","v":"2023-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'!E22","v":"2023-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'!E23","v":" Jun 23  /  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":"2022-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":"2022-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 22  /  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,"2022-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,"2022-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 22  /  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,"2023-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,"2023-02-28",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 23  /  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,"2023-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,"2023-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 23  /  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":6,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[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],[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],[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],[7,6,8,8],[7,9,8,12],[7,13,8,15],[15,4,15,5],[15,16,15,17]]}
[]
[null,null,null,null,"PAYG Instalment Calculation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!O1","v":"Client Name"},"HIDE"]
[null,null,null,null,{"$f":"'BAS Summary'!D2","v":"Year Ended 30 June 2023"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'BAS Summary'!O2","v":"Preparer Name"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABN",{"$f":"'BAS Summary'!P5","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'!E12","v":"2022-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$7=\"Monthly\",P12,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E13","v":"2022-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$7=\"Monthly\",P13,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E14","v":" Sep 22  /  Quarter 1"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P14,0)+IF($F$7=\"Quarterly\",SUM(P12:P14),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E15","v":"2022-10-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P15,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E16","v":"2022-11-30"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P16,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E17","v":" Dec 22  /  Quarter 2"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P17,0)+IF($F$7=\"Quarterly\",SUM(P15:P17),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E18","v":"2023-01-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P18,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E19","v":"2023-02-28"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P19,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E20","v":" Mar 23  /  Quarter 3"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P20,0)+IF($F$7=\"Quarterly\",SUM(P18:P20),0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E21","v":"2023-04-30"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P21,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E22","v":"2023-05-31"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P22,0)","v":0}]
[null,null,null,null,{"$f":"'BAS Summary'!E23","v":" Jun 23  /  Quarter 4  /  Annual"},null,null,null,null,null,null,null,0,0,null,0,null,null,{"$f":"IF($F$7=\"Monthly\",P23,0)+IF($F$7=\"Quarterly\",SUM(P21:P23),0)+IF($F$7=\"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":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}