{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Jul-Sep","Oct-Dec","Jan-Mar","Apr-Jun","YTD Summary","Expense Category Fields"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Jul-Sep","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"merged":[[0,1,0,4],[4,0,4,4],[4,6,4,8],[5,6,5,7],[9,6,9,7],[20,0,20,6]]}
["Business Name:"]
["Financial Year:"]
["Shaded cells are formulas and will calculate automatically."]
[]
["INCOME",{"$nulls":5},"BAS SUMMARY"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL","GST","SUBTOTAL (EX GST)",null,"BAS LABEL",null,"AMOUNT"]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Total Sales","G1",{"$f":"IncSep[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Collected","1A",{"$f":"IncSep[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Paid","1B",{"$f":"ExpSep[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Payable/-Refund",null,{"$f":"I8-I9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncSep[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncSep[[#This Row],[TOTAL]]-IncSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUBTOTAL(109,IncSep[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncSep[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncSep[SUBTOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed. Hint: press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]
[]
["EXPENSES"]
["Hint: If the GST within a purchase is not 10%, input the GST amount manually or use separate rows for the GST inclusive and GST free amounts."]
["Hint: Items which do not include GST are bank fees, interest, some licenses, ASIC fees, etc. Motor vehicle registration only contains GST in the CTP portion."]
["DATE","SUPPLIER","CATEGORY","GST (Y/N)","TOTAL","GST","TOTAL (EX GST)"]
[{"$nulls":5},{"$f":"IF(D25=\"Yes\",(E25/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D26=\"Yes\",(E26/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D50=\"Yes\",(E50/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpSep[[#This Row],[TOTAL]]-ExpSep[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,ExpSep[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpSep[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpSep[TOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Net Profit/-Loss",{"$nulls":5},{"$f":"IncSep[[#Totals],[SUBTOTAL (EX GST)]]-ExpSep[[#Totals],[TOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}}]
["Hint: Insert new rows as needed or press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]

{"sheet":"Oct-Dec","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"merged":[[0,1,0,4],[4,0,4,4],[4,6,4,8],[5,6,5,7],[9,6,9,7],[20,0,20,6]]}
["Business Name:",{"$f":"'Jul-Sep'!B1","v":0}]
["Financial Year:",{"$f":"'Jul-Sep'!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
[]
["INCOME",{"$nulls":5},"BAS SUMMARY"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL","GST","SUBTOTAL (EX GST)",null,"BAS LABEL",null,"AMOUNT"]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Total Sales","G1",{"$f":"IncDec[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Collected","1A",{"$f":"IncDec[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Paid","1B",{"$f":"ExpDec[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Payable/-Refund",null,{"$f":"I8-I9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncDec[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#This Row],[TOTAL]]-IncDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUBTOTAL(109,IncDec[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncDec[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncDec[SUBTOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed. Hint: press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]
[]
["EXPENSES"]
["Hint: If the GST within a purchase is not 10%, input the GST amount manually or use separate rows for the GST inclusive and GST free amounts."]
["Hint: Items which do not include GST are bank fees, interest, some licenses, ASIC fees, etc. Motor vehicle registration only contains GST in the CTP portion."]
["DATE","SUPPLIER","CATEGORY","GST (Y/N)","TOTAL","GST","TOTAL (EX GST)"]
[{"$nulls":5},{"$f":"IF(D25=\"Yes\",(E25/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D26=\"Yes\",(E26/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpDec[[#This Row],[TOTAL]]-ExpDec[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,ExpDec[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpDec[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpDec[TOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Net Profit/-Loss",{"$nulls":5},{"$f":"IncDec[[#Totals],[SUBTOTAL (EX GST)]]-ExpDec[[#Totals],[TOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}}]
["Hint: Insert new rows as needed or press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]

{"sheet":"Jan-Mar","index":2,"n_rows":55,"n_cols":9,"rows_kept":55,"merged":[[0,1,0,4],[4,0,4,4],[4,6,4,8],[5,6,5,7],[9,6,9,7],[20,0,20,6]]}
["Business Name:",{"$f":"'Jul-Sep'!B1","v":0}]
["Financial Year:",{"$f":"'Jul-Sep'!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
[]
["INCOME",{"$nulls":5},"BAS SUMMARY"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL","GST","SUBTOTAL (EX GST)",null,"BAS LABEL",null,"AMOUNT"]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Total Sales","G1",{"$f":"IncMar[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Collected","1A",{"$f":"IncMar[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Paid","1B",{"$f":"ExpMar[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Payable/-Refund",null,{"$f":"I8-I9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncMar[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#This Row],[TOTAL]]-IncMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUBTOTAL(109,IncMar[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncMar[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncMar[SUBTOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed. Hint: press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]
[]
["EXPENSES"]
["Hint: If the GST within a purchase is not 10%, input the GST amount manually or use separate rows for the GST inclusive and GST free amounts."]
["Hint: Items which do not include GST are bank fees, interest, some licenses, ASIC fees, etc. Motor vehicle registration only contains GST in the CTP portion."]
["DATE","SUPPLIER","CATEGORY","GST (Y/N)","TOTAL","GST","TOTAL (EX GST)"]
[{"$nulls":5},{"$f":"IF(D25=\"Yes\",(E25/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D26=\"Yes\",(E26/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpMar[[#This Row],[TOTAL]]-ExpMar[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,ExpMar[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpMar[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpMar[TOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Net Profit/-Loss",{"$nulls":5},{"$f":"IncMar[[#Totals],[SUBTOTAL (EX GST)]]-ExpMar[[#Totals],[TOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}}]
["Hint: Insert new rows as needed or press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]

{"sheet":"Apr-Jun","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"merged":[[0,1,0,4],[4,0,4,4],[4,6,4,8],[5,6,5,7],[9,6,9,7],[20,0,20,6]]}
["Business Name:",{"$f":"'Jul-Sep'!B1","v":0}]
["Financial Year:",{"$f":"'Jul-Sep'!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
[]
["INCOME",{"$nulls":5},"BAS SUMMARY"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL","GST","SUBTOTAL (EX GST)",null,"BAS LABEL",null,"AMOUNT"]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Total Sales","G1",{"$f":"IncJun[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Collected","1A",{"$f":"IncJun[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"GST Paid","1B",{"$f":"ExpJun[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}},null,"Payable/-Refund",null,{"$f":"I8-I9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IncJun[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#This Row],[TOTAL]]-IncJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUBTOTAL(109,IncJun[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncJun[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncJun[SUBTOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed. Hint: press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]
[]
["EXPENSES"]
["Hint: If the GST within a purchase is not 10%, input the GST amount manually or use separate rows for the GST inclusive and GST free amounts."]
["Hint: Items which do not include GST are bank fees, interest, some licenses, ASIC fees, etc. Motor vehicle registration only contains GST in the CTP portion."]
["DATE","SUPPLIER","CATEGORY","GST (Y/N)","TOTAL","GST","TOTAL (EX GST)"]
[{"$nulls":5},{"$f":"IF(D25=\"Yes\",(E25/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D26=\"Yes\",(E26/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D52=\"Yes\",(E52/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"ExpJun[[#This Row],[TOTAL]]-ExpJun[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,ExpJun[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpJun[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpJun[TOTAL (EX GST)])","v":{"v":0,"d":"0.00"}}]
["Net Profit/-Loss",{"$nulls":5},{"$f":"IncJun[[#Totals],[SUBTOTAL (EX GST)]]-ExpJun[[#Totals],[TOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}}]
["Hint: Insert new rows as needed or press \"Tab\" key when the last cell is selected (above the Total row) to create more rows."]

{"sheet":"YTD Summary","index":4,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[0,1,0,5],[1,1,1,2],[3,0,3,5],[10,0,10,5],[13,0,13,5]]}
["Business Name:",{"$f":"'Jul-Sep'!B1","v":0}]
["Financial Year:",{"$f":"'Jul-Sep'!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
["BAS SUMMARY"]
["BAS LABEL","Jul - Sep","Oct - Dec","Jan - Mar","Apr - Jun","TOTAL"]
["Total Sales       G1",{"$f":"IncSep[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B6:E6)","v":{"v":0,"d":"0.00"}}]
["GST Collected 1A",{"$f":"IncSep[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B7:E7)","v":{"v":0,"d":"0.00"}}]
["GST Paid          1B",{"$f":"ExpSep[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"ExpDec[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"ExpMar[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"ExpJun[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:E8)","v":{"v":0,"d":"0.00"}}]
["Payable/-Refund",{"$f":"B7-B8","v":{"v":0,"d":"0.00"}},{"$f":"C7-C8","v":{"v":0,"d":"0.00"}},{"$f":"D7-D8","v":{"v":0,"d":"0.00"}},{"$f":"E7-E8","v":{"v":0,"d":"0.00"}},{"$f":"F7-F8","v":{"v":0,"d":"0.00"}}]
[]
["YEAR TO DATE SUMMARY"]
[null,"Jul - Sep","Oct - Dec","Jan - Mar","Apr - Jun","YTD"]
["Total Income",{"$f":"IncSep[[#Totals],[SUBTOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}},{"$f":"IncDec[[#Totals],[SUBTOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}},{"$f":"IncMar[[#Totals],[SUBTOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}},{"$f":"IncJun[[#Totals],[SUBTOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B13:E13)","v":{"v":0,"d":"0.00"}}]
["Expenses"]
[{"$f":"'Expense Category Fields'!B3","v":"Accounting Fees"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Accounting Fees\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Accounting Fees\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Accounting Fees\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Accounting Fees\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B15:E15)","v":0}]
[{"$f":"'Expense Category Fields'!B4","v":"Advertising/Marketing"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Advertising/Marketing\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Advertising/Marketing\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Advertising/Marketing\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Advertising/Marketing\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B5","v":"Assets Immediate Writeoff"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Assets Immediate Writeoff\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Assets Immediate Writeoff\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Assets Immediate Writeoff\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Assets Immediate Writeoff\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B6","v":"Bank Fees"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Bank Fees\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Bank Fees\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Bank Fees\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Bank Fees\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B7","v":"Client Gifts/Donations"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Client Gifts/Donations\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Client Gifts/Donations\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Client Gifts/Donations\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Client Gifts/Donations\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B19:E19)","v":0}]
[{"$f":"'Expense Category Fields'!B8","v":"Clothing & Uniforms"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Clothing & Uniforms\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Clothing & Uniforms\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Clothing & Uniforms\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Clothing & Uniforms\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B9","v":"Electricity"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Electricity\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Electricity\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Electricity\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Electricity\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B10","v":"Home Office"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Home Office\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Home Office\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Home Office\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Home Office\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B11","v":"Insurance"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Insurance\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Insurance\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Insurance\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Insurance\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B12","v":"Legal & Professional Fees"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Legal & Professional Fees\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Legal & Professional Fees\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Legal & Professional Fees\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Legal & Professional Fees\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B14","v":"Materials"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Materials\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Materials\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Materials\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Materials\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B15","v":"Merchant Fees"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Merchant Fees\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Merchant Fees\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Merchant Fees\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Merchant Fees\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B26:E26)","v":0}]
[{"$f":"'Expense Category Fields'!B16","v":"MV - Car Loan/Lease Payment"},{"$f":"SUMIF(ExpSep[CATEGORY],\"MV - Car Loan/Lease Payment\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"MV - Car Loan/Lease Payment\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"MV - Car Loan/Lease Payment\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"MV - Car Loan/Lease Payment\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B17","v":"MV - Fuel"},{"$f":"SUMIF(ExpSep[CATEGORY],\"MV - Fuel\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"MV - Fuel\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"MV - Fuel\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"MV - Fuel\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B18","v":"MV - Insurance"},{"$f":"SUMIF(ExpSep[CATEGORY],\"MV - Insurance\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"MV - Insurance\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"MV - Insurance\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"MV - Insurance\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B19","v":"MV - Maintenance"},{"$f":"SUMIF(ExpSep[CATEGORY],\"MV - Maintenance\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"MV - Maintenance\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"MV - Maintenance\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"MV - Maintenance\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B20","v":"MV - Registration"},{"$f":"SUMIF(ExpSep[CATEGORY],\"MV - Registration\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"MV - Registration\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"MV - Registration\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"MV - Registration\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B21","v":"Office Supplies"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Office Supplies\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Office Supplies\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Office Supplies\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Office Supplies\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B22","v":"Parking/Tolls"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Parking/Tolls\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Parking/Tolls\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Parking/Tolls\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Parking/Tolls\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B23","v":"Phone/Internet"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Phone/Internet\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Phone/Internet\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Phone/Internet\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Phone/Internet\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B24","v":"Postage"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Postage\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Postage\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Postage\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Postage\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B25","v":"Query"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Query\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Query\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Query\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Query\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B26","v":"Rent/Lease/Outgoings"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Rent/Lease/Outgoings\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Rent/Lease/Outgoings\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Rent/Lease/Outgoings\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Rent/Lease/Outgoings\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B27","v":"Repairs & Maintenance"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Repairs & Maintenance\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Repairs & Maintenance\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Repairs & Maintenance\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Repairs & Maintenance\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B28","v":"Staff Amenities/Meetings"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Staff Amenities/Meetings\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Staff Amenities/Meetings\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Staff Amenities/Meetings\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Staff Amenities/Meetings\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B29","v":"Stock Purchases"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Stock Purchases\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Stock Purchases\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Stock Purchases\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Stock Purchases\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B30","v":"Subcontractors"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Subcontractors\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Subcontractors\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Subcontractors\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Subcontractors\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B41:E41)","v":0}]
[{"$f":"'Expense Category Fields'!B31","v":"Subscriptions"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Subscriptions\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Subscriptions\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Subscriptions\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Subscriptions\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B32","v":"Superannuation"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Superannuation\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Superannuation\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Superannuation\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Superannuation\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B43:E43)","v":0}]
[{"$f":"'Expense Category Fields'!B33","v":"Tools"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Tools\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Tools\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Tools\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Tools\",ExpJun[TOTAL (EX GST)])","v":0},0]
[{"$f":"'Expense Category Fields'!B34","v":"Travel"},{"$f":"SUMIF(ExpSep[CATEGORY],\"Travels\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Travels\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Travels\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Travels\",ExpJun[TOTAL (EX GST)])","v":0},0]
[]
["Total Expenses",{"$f":"SUM(B15:B46)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C15:C46)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D15:D46)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E15:E46)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F15:F46)","v":{"v":0,"d":"0.00"}}]
[]
["Net Profit/-Loss",{"$f":"B13-B47","v":{"v":0,"d":"0.00"}},{"$f":"C13-C47","v":{"v":0,"d":"0.00"}},{"$f":"D13-D47","v":{"v":0,"d":"0.00"}},{"$f":"E13-E47","v":{"v":0,"d":"0.00"}},{"$f":"F13-F47","v":{"v":0,"d":"0.00"}}]
[]
["Loan Repayment/ATO",{"$f":"SUMIF(ExpSep[CATEGORY],\"Loan Repayment/ATO\",ExpSep[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpDec[CATEGORY],\"Loan Repayment/ATO\",ExpDec[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpMar[CATEGORY],\"Loan Repayment/ATO\",ExpMar[TOTAL (EX GST)])","v":0},{"$f":"SUMIF(ExpJun[CATEGORY],\"Loan Repayment/ATO\",ExpJun[TOTAL (EX GST)])","v":0},{"$f":"SUM(B51:E51)","v":0}]

{"sheet":"Expense Category Fields","index":5,"n_rows":34,"n_cols":2,"rows_kept":34}
[]
[null,"Category Fields:"]
[null,"Accounting Fees"]
[null,"Advertising/Marketing"]
[null,"Assets Immediate Writeoff"]
[null,"Bank Fees"]
[null,"Client Gifts/Donations"]
[null,"Clothing & Uniforms"]
[null,"Electricity"]
[null,"Home Office"]
[null,"Insurance"]
[null,"Legal & Professional Fees"]
[null,"Loan Repayment/ATO"]
[null,"Materials"]
[null,"Merchant Fees"]
[null,"MV - Car Loan/Lease Payment"]
[null,"MV - Fuel"]
[null,"MV - Insurance"]
[null,"MV - Maintenance"]
[null,"MV - Registration"]
[null,"Office Supplies"]
[null,"Parking/Tolls"]
[null,"Phone/Internet"]
[null,"Postage"]
[null,"Query"]
[null,"Rent/Lease/Outgoings"]
[null,"Repairs & Maintenance"]
[null,"Staff Amenities/Meetings"]
[null,"Stock Purchases"]
[null,"Subcontractors"]
[null,"Subscriptions"]
[null,"Superannuation"]
[null,"Tools"]
[null,"Travel"]