{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Monthly Income Report","Quarterly Sales Report"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Monthly Income Report","index":0,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[31,15,31,17],[31,18,31,22],[31,23,31,27],[31,28,31,32],[38,15,38,17],[38,18,38,22],[38,23,38,27],[38,28,38,32],[24,28,24,32],[1,5,1,7],[24,15,24,17],[24,18,24,22],[24,23,24,27]]}
["Please input in yellow area",{"$nulls":4},"Monthly Income Report"]
[{"$nulls":5},"2021-2022"]
[]
[null,"Jul-21","Aug-21","Sep-21","Oct-21","Nov-21","Dec-21","Jan-22","Feb-22","Mar-22","Apr-22","May-22","Jun-22"]
[]
["Didi"]
["Trip mileage"]
["Income"]
["Other Income"]
["- Deductions"]
["DiDi Total Income",{"$f":"SUM(B8:B10)","v":0},{"$f":"SUM(C8:C10)","v":0},{"$f":"SUM(D8:D10)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Uber"]
["Trip mileage"]
["Fare"]
["Other Income"]
["- Deductions"]
["Uber Total Income",{"$f":"SUM(B15:B17)","v":0},{"$f":"SUM(C15:C17)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Ola"]
["Trip mileage"]
["Fare"]
["Other Income"]
["- Deductions"]
["Ola Total Income",{"$f":"SUM(B22:B24)","v":0},{"$f":"SUM(C22:C24)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Additional 1"]
["Trip mileage"]
["Fare"]
["Other Income"]
["- Deductions"]
["Ola Total Income",{"$f":"SUM(B29:B31)","v":0},{"$f":"SUM(C29:C31)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Additional 2"]
["Trip mileage"]
["Fare"]
["Other Income"]
["- Deductions"]
["Ola Total Income",{"$f":"SUM(B36:B38)","v":0},{"$f":"SUM(C36:C38)","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Quarterly Sales Report","index":1,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,2,2,6],[2,8,2,12],[2,14,2,18],[2,20,2,24],[2,26,2,29]]}
[{"$nulls":11},"QUARTERLY SALES AND EXPENSE REPORT"]
[]
[null,null,"Q1",{"$nulls":5},"Q2",{"$nulls":5},"Q3",{"$nulls":5},"Q4",{"$nulls":5},"Year"]
[null,null,"Incl. GST","Bus %","Incl GST","GST","Excl. GST",null,"Incl. GST","Bus %","Incl GST","GST","Excl. GST",null,"Incl. GST","Bus %","Incl GST","GST","Excl. GST",null,"Incl. GST","Bus %","Incl GST","GST","Excl. GST",null,"Incl. GST","Incl GST","GST","Excl. GST"]
[null,"Sales"]
[null,{"$f":"+'Monthly Income Report'!A6","v":"Didi"},{"$f":"SUM('Monthly Income Report'!B11:D11)","v":0},1,{"$f":"C6*D6","v":0},0,{"$f":"E6-F6","v":0},null,{"$f":"SUM('Monthly Income Report'!E11:G11)","v":0},1,{"$f":"I6*J6","v":0},0,{"$f":"K6-L6","v":0},null,{"$f":"SUM('Monthly Income Report'!H11:J11)","v":0},1,{"$f":"O6*P6","v":0},0,{"$f":"Q6-R6","v":0},null,{"$f":"SUM('Monthly Income Report'!K11:M11)","v":0},1,{"$f":"U6*V6","v":0},0,{"$f":"W6-X6","v":0},null,{"$f":"+C6+I6+O6+U6","v":0},{"$f":"+E6+K6+Q6+W6","v":0},0,0]
[null,{"$f":"+'Monthly Income Report'!A13","v":"Uber"},{"$f":"SUM('Monthly Income Report'!B18:D18)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!E18:G18)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!H18:J18)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!K18:M18)","v":0},1,0,0,0,null,0,0,0,0]
[null,{"$f":"+'Monthly Income Report'!A20","v":"Ola"},{"$f":"SUM('Monthly Income Report'!B25:D25)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!E25:G25)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!H25:J25)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!K25:M25)","v":0},1,0,0,0,null,0,0,0,0]
[null,{"$f":"+'Monthly Income Report'!A27","v":"Additional 1"},{"$f":"SUM('Monthly Income Report'!B32:D32)","v":0},1,{"$f":"C9*D9","v":0},0,{"$f":"E9-F9","v":0},null,{"$f":"SUM('Monthly Income Report'!E32:G32)","v":0},1,{"$f":"I9*J9","v":0},0,{"$f":"K9-L9","v":0},null,{"$f":"SUM('Monthly Income Report'!H32:J32)","v":0},1,{"$f":"O9*P9","v":0},0,{"$f":"Q9-R9","v":0},null,{"$f":"SUM('Monthly Income Report'!K32:M32)","v":0},1,{"$f":"U9*V9","v":0},0,{"$f":"W9-X9","v":0},null,0,0,0,0]
[null,{"$f":"+'Monthly Income Report'!A34","v":"Additional 2"},{"$f":"SUM('Monthly Income Report'!B39:D39)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!E39:G39)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!H39:J39)","v":0},1,0,0,0,null,{"$f":"SUM('Monthly Income Report'!K39:M39)","v":0},1,0,0,0,null,0,0,0,0]
[null,"Total Gross Sales",{"$f":"SUM(C6:C10)","v":0},null,{"$f":"SUM(E6:E10)","v":0},{"$f":"SUM(F6:F10)","v":0},{"$f":"SUM(G6:G10)","v":0},null,{"$f":"SUM(I6:I10)","v":0},null,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(L6:L10)","v":0},{"$f":"SUM(M6:M10)","v":0},null,{"$f":"SUM(O6:O10)","v":0},null,{"$f":"SUM(Q6:Q10)","v":0},{"$f":"SUM(R6:R10)","v":0},{"$f":"SUM(S6:S10)","v":0},null,{"$f":"SUM(U6:U10)","v":0},null,{"$f":"SUM(W6:W10)","v":0},{"$f":"SUM(X6:X10)","v":0},{"$f":"SUM(Y6:Y10)","v":0},null,{"$f":"SUM(AA6:AA10)","v":0},{"$f":"SUM(AB6:AB10)","v":0},{"$f":"SUM(AC6:AC10)","v":0},{"$f":"SUM(AD6:AD10)","v":0}]
[]
[null,"Expenses"]
[null,"Car - Interest",null,1,{"$f":"C14*D14","v":0},{"$f":"E14/11","v":0},{"$f":"E14-F14","v":0},null,null,1,{"$f":"I14*J14","v":0},{"$f":"K14/11","v":0},{"$f":"K14-L14","v":0},null,null,1,{"$f":"O14*P14","v":0},{"$f":"Q14/11","v":0},{"$f":"Q14-R14","v":0},null,null,1,{"$f":"U14*V14","v":0},{"$f":"W14/11","v":0},{"$f":"W14-X14","v":0},null,{"$f":"+C14+I14+O14+U14","v":0},{"$f":"+E14+K14+Q14+W14","v":0},{"$f":"+F14+L14+R14+X14","v":0},{"$f":"+G14+M14+S14+Y14","v":0}]
[null,"Car - Depreciation",null,1,{"$f":"C15*D15","v":0},0,0,null,null,1,{"$f":"I15*J15","v":0},0,0,null,null,1,{"$f":"O15*P15","v":0},0,0,null,null,1,{"$f":"U15*V15","v":0},0,0,null,0,0,0,0]
[null,"Car - Fuel",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Lease",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Rego",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Insurance & Roadside",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Maintenance",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Tolls",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Parking",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Car - Miscellaneous",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Mobile Usage",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Internet Usage",null,1,{"$f":"C25*D25","v":0},0,{"$f":"E25-F25","v":0},null,null,1,{"$f":"I25*J25","v":0},0,{"$f":"K25-L25","v":0},null,null,1,{"$f":"O25*P25","v":0},0,{"$f":"Q25-R25","v":0},null,null,1,{"$f":"U25*V25","v":0},0,{"$f":"W25-X25","v":0},null,0,0,0,0]
[null,"Printing & Stationery",null,1,{"$f":"C26*D26","v":0},0,{"$f":"E26-F26","v":0},null,null,1,{"$f":"I26*J26","v":0},0,{"$f":"K26-L26","v":0},null,null,1,{"$f":"O26*P26","v":0},0,{"$f":"Q26-R26","v":0},null,null,1,0,0,0,null,0,0,0,0]
[null,"Equipment - Purchase",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Home Office Expenses",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Home Office Utilities",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Office Expenses",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Office Utilities",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Software Subscription",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Education & Training",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Add your expense",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Add your expense",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Add your expense",null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,null,1,0,0,0,null,0,0,0,0]
[null,"Add above this row"]
[null,"Total Expenses",{"$f":"SUM(C14:C37)","v":0},null,{"$f":"SUM(E14:E37)","v":0},0,0,null,{"$f":"SUM(I14:I37)","v":0},null,{"$f":"SUM(K14:K37)","v":0},0,0,null,{"$f":"SUM(O14:O37)","v":0},null,{"$f":"SUM(Q14:Q37)","v":0},0,0,null,{"$f":"SUM(U14:U37)","v":0},null,{"$f":"SUM(W14:W37)","v":0},0,0,null,{"$f":"SUM(AA14:AA37)","v":0},{"$f":"SUM(AB14:AB37)","v":0},0,0]
[]
[null,"PROFIT",{"$f":"C11-C38","v":0},null,null,{"$f":"F11-F38","v":0},0,null,0,null,null,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,{"$f":"AA11-AA38","v":0},0,0,0]
[]
[]
[]
[null,"SUMMARY"]
[null,null,"Qtr 1","Qtr 2","Qtr3","Qtr4","Year"]
[]
[null,"Gross Sales (incl. of GST)",{"$f":"+E11","v":0},{"$f":"+K11","v":0},{"$f":"+Q11","v":0},{"$f":"+W11","v":0},{"$f":"SUM(C47:F47)","v":0}]
[null,"GST",{"$f":"-F11","v":0},{"$f":"-L11","v":0},{"$f":"-R11","v":0},{"$f":"-X11","v":0},0]
[null,"Gross Sales (net of GST)",{"$f":"SUM(C47:C48)","v":0},{"$f":"SUM(D47:D48)","v":0},0,{"$f":"SUM(F47:F48)","v":0},0]
[]
[null,"Expenses (incl. GST)",{"$f":"+E38","v":0},{"$f":"+K38","v":0},{"$f":"+Q38","v":0},{"$f":"+W38","v":0},0]
[null,"GST",{"$f":"-F38","v":0},{"$f":"-L38","v":0},{"$f":"-R38","v":0},{"$f":"-X38","v":0},0]
[null,"Expenses (net of GST)",{"$f":"SUM(C51:C52)","v":0},{"$f":"SUM(D51:D52)","v":0},0,{"$f":"SUM(F51:F52)","v":0},0]
[]
[null,"Profit",{"$f":"C49-C53","v":0},{"$f":"D49-D53","v":0},0,{"$f":"F49-F53","v":0},0]
[null,"Check",{"$f":"IF(C55=G40,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(D55=M40,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(E55=S40,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(F55=Y40,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(G55=AD40,\"Ok\",\"Check\")","v":"Ok"}]
[null,"Net GST (Payable)/Refundable",{"$f":"C48-C52","v":0},0,0,0,0]