{"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":3,"rows_kept":40,"merged":[[3,0,3,2]]}
["Business Name:"]
["Financial Year:"]
[]
["INCOME"]
["DATE","CUSTOMER/SALE DETAILS","TOTAL"]
{"$rows_empty":33}
["Total",null,{"$f":"SUBTOTAL(109,Income[TOTAL])","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":4,"rows_kept":74,"merged":[[0,1,0,2],[3,0,3,3]]}
["Business Name:",{"$f":"Income!B1","v":0}]
["Financial Year:",{"$f":"Income!B2","v":0}]
[]
["EXPENSES"]
["DATE","SUPPLIER","CATEGORY","TOTAL"]
{"$rows_empty":32}
["Total",null,null,{"$f":"SUBTOTAL(109,Expenses[TOTAL])","v":{"v":0,"d":"0.00"}}]
["Net Profit/-Loss"]
["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":3,"rows_kept":44,"merged":[[0,1,0,2],[4,0,4,2],[8,0,8,2]]}
["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"]
[]
["INCOME"]
["Total Income",null,{"$f":"Income[[#Totals],[TOTAL]]","v":{"v":0,"d":"0.00"}}]
[]
["EXPENSES"]
[{"$f":"Expenses!C44","v":"Accounting Fees"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Accounting Fees\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C45","v":"Advertising/Marketing"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Advertising/Marketing\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C46","v":"Assets Immediate Writeoff"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Assets Immediate Writeoff\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C47","v":"Bank Fees"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Bank Fees\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C48","v":"Client Gifts/Donations"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Client Gifts/Donations\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C49","v":"Clothing & Uniforms"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Clothing & Uniforms\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C50","v":"Electricity"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Electricity\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C51","v":"Home Office"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Home Office\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C52","v":"Insurance"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Insurance\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C53","v":"Legal & Professional Fees"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Legal & Professional Fees\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C54","v":"Materials"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Materials\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C55","v":"Merchant Fees"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Merchant Fees\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C56","v":"MV - Car Loan/Lease Payment"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Car Loan/Lease Payment\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C57","v":"MV - Fuel"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Fuel\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C58","v":"MV - Insurance"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Insurance\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C59","v":"MV - Maintenance"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Maintenance\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C60","v":"MV - Registration"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"MV - Registration\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C61","v":"Office Supplies"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Office Supplies\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C62","v":"Parking/Tolls"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Parking/Tolls\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C63","v":"Phone/Internet"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Phone/Internet\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C64","v":"Postage"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Postage\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C65","v":"Query"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Query\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C66","v":"Rent/Lease/Outgoings"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Rent/Lease/Outgoings\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C67","v":"Repairs & Maintenance"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Repairs & Maintenance\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C68","v":"Staff Amenities/Meetings"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Staff Amenities/Meetings\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C69","v":"Stock Purchases"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Stock Purchases\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C70","v":"Subcontractors"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Subcontractors\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C71","v":"Subscriptions"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Subscriptions\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C72","v":"Superannuation"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Superannuation\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C73","v":"Tools"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Tools\",Expenses[TOTAL])","v":0}]
[{"$f":"Expenses!C74","v":"Travel"},null,{"$f":"SUMIF(Expenses[CATEGORY],\"Travel\",Expenses[TOTAL])","v":0}]
["Total Expenses",null,{"$f":"SUM(C11:C41)","v":{"v":0,"d":"0.00"}}]
[]
["Net Profit/-Loss",null,{"$f":"C8-C42","v":{"v":0,"d":"0.00"}}]