{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Income","Expenses","YTD Summary"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Income","index":0,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[4,0,4,4]]}
["Business Name:"]
["Period:"]
["Shaded cells are formulas and will calculate automatically."]
[]
["INCOME"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL","GST","SUBTOTAL (EX GST)"]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"Income[[#This Row],[TOTAL]]/11","v":{"v":0,"d":"0.00"}},{"$f":"Income[[#This Row],[TOTAL]]-Income[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUBTOTAL(109,Income[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Income[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Income[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."]

{"sheet":"Expenses","index":1,"n_rows":74,"n_cols":7,"rows_kept":74,"merged":[[3,0,3,6]]}
["Business Name:",{"$f":"Income!B1","v":0}]
["Period:",{"$f":"Income!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
["EXPENSES"]
["Hint: If the GST within a purchase is not 10%, input the GST amount manually or use separate rows for the GST incl/free portions."]
["Hint: Items which do not include GST are bank fees, interest, some licenses, ASIC fees, etc."]
["Hint: 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(D9=\"Yes\",(E9/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D10=\"Yes\",(E10/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(D28=\"Yes\",(E28/11),0)","v":{"v":0,"d":"0.00"}},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$f":"Expenses[[#This Row],[TOTAL]]-Expenses[[#This Row],[GST]]","v":{"v":0,"d":"0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Expenses[TOTAL])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Expenses[GST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Expenses[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."]
[]
[null,null,"Category Fields:"]
[null,null,"Accounting Fees"]
[null,null,"Advertising/Marketing"]
[null,null,"Assets Immediate Writeoff"]
[null,null,"Bank Fees"]
[null,null,"Client Gifts/Donations"]
[null,null,"Clothing & Uniforms"]
[null,null,"Electricity"]
[null,null,"Home Office"]
[null,null,"Insurance"]
[null,null,"Legal & Professional Fees"]
[null,null,"Materials"]
[null,null,"Merchant Fees"]
[null,null,"MV - Car Loan/Lease Payment"]
[null,null,"MV - Fuel"]
[null,null,"MV - Insurance"]
[null,null,"MV - Maintenance"]
[null,null,"MV - Registration"]
[null,null,"Office Supplies"]
[null,null,"Parking/Tolls"]
[null,null,"Phone/Internet"]
[null,null,"Postage"]
[null,null,"Query"]
[null,null,"Rent/Lease/Outgoings"]
[null,null,"Repairs & Maintenance"]
[null,null,"Staff Amenities/Meetings"]
[null,null,"Stock Purchases"]
[null,null,"Subcontractors"]
[null,null,"Subscriptions"]
[null,null,"Superannuation"]
[null,null,"Tools"]
[null,null,"Travel"]

{"sheet":"YTD Summary","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"merged":[[4,0,4,1],[4,3,4,5],[6,3,6,4],[8,0,8,1]]}
["Business Name:",{"$f":"Income!B1","v":0}]
["Financial Year:",{"$f":"Income!B2","v":0}]
["Shaded cells are formulas and will calculate automatically."]
[]
["YEAR TO DATE SUMMARY",null,null,"ANNUAL GST RETURN"]
[]
["INCOME",null,null,"BAS LABEL",null,"AMOUNT"]
["Total Income",{"$f":"Income[[#Totals],[SUBTOTAL (EX GST)]]","v":{"v":0,"d":"0.00"}},null,"Total Sales","G1",{"$f":"Income[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"GST Collected","1A",{"$f":"Income[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
["EXPENSES",null,null,"GST Paid","1B",{"$f":"Expenses[[#Totals],[GST]]","v":{"v":0,"d":"0.00"}}]
[{"$f":"Expenses!C44","v":"Accounting Fees"},{"$f":"SUMIF(Expenses[CATEGORY],\"Accounting Fees\",Expenses[TOTAL (EX GST)])","v":0},null,"Payable/-Refund",null,{"$f":"F9-F10","v":{"v":0,"d":"0.00"}}]
[{"$f":"Expenses!C45","v":"Advertising/Marketing"},{"$f":"SUMIF(Expenses[CATEGORY],\"Advertising/Marketing\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C46","v":"Assets Immediate Writeoff"},{"$f":"SUMIF(Expenses[CATEGORY],\"Assets Immediate Writeoff\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C47","v":"Bank Fees"},{"$f":"SUMIF(Expenses[CATEGORY],\"Bank Fees\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C48","v":"Client Gifts/Donations"},{"$f":"SUMIF(Expenses[CATEGORY],\"Client Gifts/Donations\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C49","v":"Clothing & Uniforms"},{"$f":"SUMIF(Expenses[CATEGORY],\"Clothing & Uniforms\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C50","v":"Electricity"},{"$f":"SUMIF(Expenses[CATEGORY],\"Electricity\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C51","v":"Home Office"},{"$f":"SUMIF(Expenses[CATEGORY],\"Home Office\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C52","v":"Insurance"},{"$f":"SUMIF(Expenses[CATEGORY],\"Insurance\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C53","v":"Legal & Professional Fees"},{"$f":"SUMIF(Expenses[CATEGORY],\"Legal & Professional Fees\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C54","v":"Materials"},{"$f":"SUMIF(Expenses[CATEGORY],\"Materials\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C55","v":"Merchant Fees"},{"$f":"SUMIF(Expenses[CATEGORY],\"Merchant Fees\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C56","v":"MV - Car Loan/Lease Payment"},{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Car Loan/Lease Payment\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C57","v":"MV - Fuel"},{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Fuel\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C58","v":"MV - Insurance"},{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Insurance\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C59","v":"MV - Maintenance"},{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Maintenance\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C60","v":"MV - Registration"},{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Registration\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C61","v":"Office Supplies"},{"$f":"SUMIF(Expenses[CATEGORY],\"Office Supplies\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C62","v":"Parking/Tolls"},{"$f":"SUMIF(Expenses[CATEGORY],\"Parking/Tolls\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C63","v":"Phone/Internet"},{"$f":"SUMIF(Expenses[CATEGORY],\"Phone/Internet\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C64","v":"Postage"},{"$f":"SUMIF(Expenses[CATEGORY],\"Postage\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C65","v":"Query"},{"$f":"SUMIF(Expenses[CATEGORY],\"Query\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C66","v":"Rent/Lease/Outgoings"},{"$f":"SUMIF(Expenses[CATEGORY],\"Rent/Lease/Outgoings\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C67","v":"Repairs & Maintenance"},{"$f":"SUMIF(Expenses[CATEGORY],\"Repairs & Maintenance\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C68","v":"Staff Amenities/Meetings"},{"$f":"SUMIF(Expenses[CATEGORY],\"Staff Amenities/Meetings\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C69","v":"Stock Purchases"},{"$f":"SUMIF(Expenses[CATEGORY],\"Stock Purchases\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C70","v":"Subcontractors"},{"$f":"SUMIF(Expenses[CATEGORY],\"Subcontractors\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C71","v":"Subscriptions"},{"$f":"SUMIF(Expenses[CATEGORY],\"Subscriptions\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C72","v":"Superannuation"},{"$f":"SUMIF(Expenses[CATEGORY],\"Superannuation\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C73","v":"Tools"},{"$f":"SUMIF(Expenses[CATEGORY],\"Tools\",Expenses[TOTAL (EX GST)])","v":0}]
[{"$f":"Expenses!C74","v":"Travel"},{"$f":"SUMIF(Expenses[CATEGORY],\"Travel\",Expenses[TOTAL (EX GST)])","v":0}]
["Total Expenses",{"$f":"SUM(B11:B41)","v":{"v":0,"d":"0.00"}}]
[]
["Net Profit/-Loss",{"$f":"B8-B42","v":{"v":0,"d":"0.00"}}]