{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Main Worksheet","Projection Worksheet"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":25,"comments":1,"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":"Main Worksheet","index":0,"n_rows":100,"n_cols":38,"rows_kept":100,"cut":false,"hidden":false,"merged":[[6,18,25,18],[46,18,48,18],[6,22,6,24],[7,22,7,24],[8,22,8,24],[9,22,9,24],[10,22,10,24],[11,22,11,24],[0,12,0,14],[1,12,1,14],[10,10,10,13],[11,10,11,13],[7,10,7,14],[55,19,55,22],[56,18,64,18],[54,19,54,22],[5,3,5,14],[7,3,7,4],[51,19,51,20],[52,19,52,20],[9,10,9,13],[26,10,26,13],[5,22,5,25],[48,10,48,11],[54,3,54,14],[44,10,44,13],[46,10,46,13],[43,10,43,13],[29,10,29,13],[88,19,88,22],[76,3,77,14],[83,19,83,21],[82,19,82,21],[73,19,73,21],[86,19,86,22],[81,19,81,21],[69,3,69,4],[84,19,84,21],[85,19,85,21],[75,19,75,22],[76,19,76,21],[74,19,74,21],[72,19,72,22],[67,18,70,18],[57,30,57,33],[72,5,74,9],[87,19,87,21],[56,29,56,37],[57,29,58,29],[57,34,57,37],[80,19,80,22],[66,19,66,21],[62,19,62,21],[67,19,67,22],[63,19,63,21],[64,19,64,21],[65,19,65,21],[56,24,56,27],[56,5,56,8],[61,19,61,22]]}
[null,null,null,"Profit & Tax Projection - Companies",null,null,null,null,null,null,null,null,"Client Name",null,null,null,null,null,null,"HIDE"]
[null,null,null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(T9, \"dd mmmm yyyy\"))","v":"Year Ended 30 June 2018"},null,null,null,null,null,null,null,null,"Preparer Name",null,null,null,null,null,null,"HIDE"]
[]
[]
[]
[null,null,null,"PROJECTED PROFIT & TAXABLE INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions","Start of Year",null,null,"Rolling Forward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"When calculating net profit/(loss) for the period, either use the part-year profit shown in accounts prepared by your client and make the relevant adjustments OR use the part-year profit in accounts prepared by your practice. \n\nYou can change or delete all existing descriptions as they are provided for quick data entry purposes only.  Click on the sort icons to sort each list in alphabetical order.\n\nThe descriptions shown in the \"Adjustments\" section are those that might typically be found in accounts prepared by your client.\n\nYou can select one of three options for projecting profit for the remaining period.  You can annualise the part year profit, enter details of projected income and expenses in the projection worksheet for transfer to the main sheet or simply enter totals for projected income and expenses in the main sheet.",{"$f":"EOMONTH(T9,-12)+1","v":"2017-07-01"},null,null,"Tax law changes",null,null,"Done2018"]
[null,null,null,"Net Profit/(Loss)",null,null,null,null,null,null,"Taxable Income",null,null,null,null,null,null,null,null,"End of Year",null,null,"Year Ended",null,null,"2018-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z8","v":"2018-06-30"},null,null,"Base rate entity turnover",null,null,"$25m"]
[null,null,null,"Period Commencing","2017-07-01",null,null,null,null,null,"Projected Annual Profit/(Loss) Brought Forward",null,null,null,{"$f":"E44","v":0},null,null,null,null,"Days in Year",null,null,"Update tax rates below",null,null,"Done2018"]
[null,null,null,"Period Ending","2017-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T9-T7+1","v":365}]
[null,null,null,"Source of Profit Figure for the Period","Select",null,null,null,null,null,"Add (if not included in accounts)",null,null,null,null,null,null,null,null,"Days to Project"]
[null,null,null,null,null,null,null,null,null,null,"Capital Gains",null,null,null,null,null,null,null,null,{"$f":"T9-E11+1","v":182}]
[null,null,null,{"$f":"IF(E12=\"Client\",\"Net Profit/(Loss) for the Period Per Client\",IF(E12=\"Accountant\",\"Net Profit/(Loss) for the Period Per Accountant\",\"Net Profit/(Loss) for the Period\"))","v":"Net Profit/(Loss) for the Period"},null,null,null,null,null,null,"Closing Debtors (for accrual accounting taxpayers)"]
[null,null,null,null,null,null,null,null,null,null,"Closing Stock"]
[null,null,null,"Deduct/(Add) Income Adjustments",null,null,null,null,null,null,"FBT Contribution"]
[null,null,null,"GST Refunds",null,null,null,null,null,null,"Opening Creditors"]
[null,null,null,"Loans Received - Other",null,null,null,null,null,null,"Profit on Sale of Plant & Equipment"]
[null,null,null,"Loans Received - Owner(s)"]
[null,null,null,"Tax Refund"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Income Adjustments",{"$f":"SUM(E17:E26)","v":0},null,null,null,null,null,"Total Amounts Added to Taxable Income",null,null,null,{"$f":"SUM(O13:O26)","v":0}]
[null,null,null,"Sub-Total",{"$f":"E14-E27","v":0},null,null,null,null,null,"Sub-Total",null,null,null,{"$f":"O10+O27","v":0}]
[]
[null,null,null,"Add/(Deduct) Expense Adjustments",null,null,null,null,null,null,"Deduct (if not included in accounts)"]
[null,null,null,"Assets Acquired",null,null,null,null,null,null,"Closing Creditors"]
[null,null,null,"GST Payments",null,null,null,null,null,null,"Depreciation"]
[null,null,null,"Hire Purchase Repayments",null,null,null,null,null,null,"Hire Purchase Charges"]
[null,null,null,"Income Tax Payments",null,null,null,null,null,null,"Interest"]
[null,null,null,"Loan Repayments",null,null,null,null,null,null,"Loss on Sale of Plant & Equipment"]
[null,null,null,"Loans to Owner(s)",null,null,null,null,null,null,"Opening Debtors (for accrual accounting taxpayers)"]
[null,null,null,"Private Expenses",null,null,null,null,null,null,"Opening Stock"]
[null,null,null,null,null,null,null,null,null,null,"Tax Losses Deducted"]
[]
[]
[null,null,null,"Total Expense Adjustments",{"$f":"SUM(E31:E40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected"]
[null,null,null,"Net Profit/(Loss) for the Period after Adjustments",{"$f":"E28+E41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Profit "]
[null,null,null,"Add Projected Profit/(Loss) for the Remaining Period",{"$f":"IF(T44=1,E48,IF(T44=2,E49,E53))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Method"]
[null,null,null,"Projected Annual Profit/(Loss) Carried Forward",{"$f":"E42+E43","v":0},null,null,null,null,null,"Total Amounts Deducted from Taxable Income",null,null,null,{"$f":"SUM(O31:O43)","v":0},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"Projected Taxable Income/(Loss)",null,null,null,{"$f":"O28-O44","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Times Tax Rate",null,"Base Rate Entity",null,{"$f":"IF(U46=TRUE,CompaniesSBE,Companies)","v":0.3},null,null,null,"Company Tax Rate","Base rate entity?",false]
[null,null,null,"Method Used to Project Profit/(Loss) for the Remaining Period",null,null,null,null,null,null,"Tax on Projected Taxable Income","SBE",null,null,{"$f":"IF(O45>0,O45*O46,0)","v":0},null,null,null,{"$f":"CONCATENATE(\"A base rate entity is a company that has an aggregated turnover of less than \",Z9,\" and carries on a business.\")","v":"A base rate entity is a company that has an aggregated turnover of less than $25m and carries on a business."}]
[null,null,null," Annualise Part-Year Profit",{"$f":"E42/(E11-E10+1)*T13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxpayer Types"]
[null,null,null," Transfer from Worksheet",{"$f":"'Projection Worksheet'!D52","v":0},null,null,null,null,null,"Less PAYG Instalments:",null,{"$f":"EOMONTH(T9,-9)","v":"2017-09-30"},null,null,null,null,null,null,"Resident"]
[null,null,null," Summary as Shown Below",null,null,null,null,null,null,null,null,{"$f":"EOMONTH(M49,3)","v":"2017-12-31"},null,null,null,null,null,null,"Non-Resident"]
[null,null,null,"Projected Income",null,null,null,null,null,null,null,null,{"$f":"EOMONTH(M50,3)","v":"2018-03-31"},null,null,null,null,null,null,"Non-Taxable"]
[null,null,null,"Less Projected Expenses",null,null,null,null,null,null,null,null,{"$f":"EOMONTH(M51,3)","v":"2018-06-30"},null,{"$f":"SUM(N49:N52)","v":0}]
[null,null,null,"Projected Profit",{"$f":"E51-E52","v":0},null,null,null,null,null," Tax Payable/(Refundable) Before Tax Planning",null,null,null,{"$f":"O47-O52","v":0}]
[]
[null,null,null,"ESTIMATE OF TAX PAYABLE WITH TAX PLANNING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Tax Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Planning","Residents 2018"]
[null,null,null,null,"Taxpayer","Residents Situation",null,null,null,"Taxable","Other","Taxable","Tax on","Less Tax","Tax on ",null,null,null,"Use this section to record and calculate the tax effect of an alternative strategy to paying company tax on the projected taxable income above this year.\n\nShow various alternatives in the Taxable Income column.  Any balance remaining will be automatically calculated in the last row of the table and taxed at the company rate.",0,18200,0,0,null,"Situation",null,null,null,null,"Add to Tax Payable"]
[null,null,null,"Alternative Allocation of Company Profit","Type","F","P","S","H","Income","Income","Income","Taxable Inc","on Other Inc","Allocated Inc",null,null,null,null,{"$f":"U57+1","v":18201},37000,0,0.19,null,"Married","Pensioner","Mcare Surch","HELP",null,"Mcare Thres","Taxable Income",null,null,null,"Other Income"]
[null,null,null,"Additional deductible superannuation contributions by this company",null,null,null,null,null,null,null,{"$f":"J59","v":0},{"$f":"J59*SuperFunds","v":0},null,{"$f":"M59","v":0},null,null,null,null,{"$f":"U58+1","v":37001},87000,3572,0.32500000000000001,null,null,null,null,null,null,null,"Mcare Levy","Mcare Surch","HELP","Total","Mcare Levy","Mcare Surch","HELP","Total"]
[null,null,null,"Low rate director 1 fees / bonus / wage",null,null,null,null,null,null,null,{"$f":"J60+K60","v":0},{"$f":"IF(L60>0,IF(AND(E60=\"Resident\",L60>ResidentTaxFree),VLOOKUP(L60,Residents,3,TRUE)+(L60-VLOOKUP(L60,Residents,1,TRUE))*(VLOOKUP(L60,Residents,4,TRUE)),0)-IF(AND(E60=\"Resident\",L60>ResidentTaxFree,L60<LitoLow+1),LitoOffset,0)-IF(AND(E60=\"Resident\",L60>ResidentTaxFree,L60>LitoLow,L60<LitoHigh),LitoOffset-((L60-LitoLow)*LitoPhaseOut),0)+IF(E60=\"Non-Resident\",VLOOKUP(L60,NonResidents,3,TRUE)+(L60-VLOOKUP(L60,NonResidents,1,TRUE))*(VLOOKUP(L60,NonResidents,4,TRUE)),0),0)+IF(E60=\"Resident\",AH60,0)","v":0},{"$f":"IF(K60>0,IF(AND(E60=\"Resident\",K60>ResidentTaxFree),VLOOKUP(K60,Residents,3,TRUE)+(K60-VLOOKUP(K60,Residents,1,TRUE))*(VLOOKUP(K60,Residents,4,TRUE)),0)-IF(AND(E60=\"Resident\",K60>ResidentTaxFree,K60<LitoLow+1),LitoOffset,0)-IF(AND(E60=\"Resident\",K60>ResidentTaxFree,K60>LitoLow,K60<LitoHigh),LitoOffset-((K60-LitoLow)*LitoPhaseOut),0)+IF(E60=\"Non-Resident\",VLOOKUP(K60,NonResidents,3,TRUE)+(K60-VLOOKUP(K60,NonResidents,1,TRUE))*(VLOOKUP(K60,NonResidents,4,TRUE)),0),0)+IF(E60=\"Resident\",AL60,0)","v":0},{"$f":"M60-N60","v":0},{"$f":"IF(O60>(J60*$O$46),\"W\",\"\")","v":""},null,null,null,{"$f":"U59+1","v":87001},180000,19822,0.37,null,false,false,false,false,null,{"$f":"IF(AND(Y60=TRUE,Z60=TRUE),MedicareThreshPensionerFamily,0)+IF(AND(Y60=TRUE,Z60=FALSE),MedicareThresFamilies,0)+IF(AND(Y60=FALSE,Z60=TRUE),MedicareThreshPensionerSingle,0)+IF(AND(Y60=FALSE,Z60=FALSE),MedicareThreshSingle,0)","v":21655},{"$f":"IF(L60>AD60,L60*MedicareRate,0)","v":0},{"$f":"IF(AA60=TRUE,L60*MedicareSurchargeRate,0)","v":0},{"$f":"IF(AB60=TRUE,L60*VLOOKUP(L60,Help,4,TRUE),0)","v":0},{"$f":"SUM(AE60:AG60)","v":0},{"$f":"IF(K60>AD60,K60*MedicareRate,0)","v":0},{"$f":"IF(AA60=TRUE,K60*MedicareSurchargeRate,0)","v":0},{"$f":"IF(AB60=TRUE,K60*VLOOKUP(K60,Help,4,TRUE),0)","v":0},{"$f":"SUM(AI60:AK60)","v":0}]
[null,null,null,"Low rate director 2 fees / bonus / wage",null,null,null,null,null,null,null,{"$f":"J61+K61","v":0},0,0,0,{"$f":"IF(O61>(J61*$O$46),\"W\",\"\")","v":""},null,null,null,{"$f":"U60+1","v":180001},null,54232,0.45,null,false,false,false,false,null,21655,0,0,0,{"$f":"SUM(AE61:AG61)","v":0},0,0,0,{"$f":"SUM(AI61:AK61)","v":0}]
[null,null,null,"Service/Consulting fee to loss company",null,null,null,null,null,null,null,0,0,0,0,"",null,null,null,"Low Income Tax Offset (residents only) for 2018",null,null,null,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"J63+K63","v":0},0,0,0,"",null,null,null,"Offset Amount",null,null,445,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,null,"Tax free with LITO",null,null,{"$f":"U57+(LitoOffset/W58)","v":20542.105263157893},null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,null,"Full Offset",null,null,37000,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,null,"No Offset",null,null,66667,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,"Tax Calculations","Phase-out Rate",null,null,1.4999999999999999E-2,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,"You can account for any part of the allocated taxable income which will have a zero tax rate by selecting \"Non-Taxable\" as the taxpayer type.","Non-Residents 2018",null,null,null,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",null,null,null,0,87000,0,0.32500000000000001,null,false,false,false,false,null,21655,0,0,0,0,0,0,0,0]
[null,null,null,"Projected company taxable income after tax planning (the bal)",null,null,null,null,null,{"$f":"O45-SUM(J59:J69)","v":0},null,{"$f":"J70","v":0},{"$f":"L70*O46","v":0},null,0,null,null,null,null,{"$f":"U69+1","v":87001},180000,28275,0.37]
[null,null,null,null,null,null,null,null,"Projected Taxable Income to Deal With",{"$f":"SUM(J59:J70)","v":0},null,null,null,"Total Tax Payable With Tax Planning",{"$f":"SUM(O59:O70)","v":0},null,null,null,null,{"$f":"U70+1","v":180001},null,62685,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Less PAYG Instalments",{"$f":"O52","v":0}]
[null,null,null,"Situation Options - Applies to Resident Type Only",null,{"$f":"IF(J70<0,\"Error:  Total Income Allocated Exceeds Taxable Income\",\"\")","v":""},null,null,null,null,null,null,null,"Overall Tax Payable/(Refundable) After Tax Planning",{"$f":"O71-O72","v":0},null,null,null,null,"Companies 2018"]
[null,null,null,"F - Family for Medicare    P - Senior Australian/Pensioner for Medicare",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard (full) rate",null,null,0.3]
[null,null,null,"S - Medicare Levy Surcharge Applied    H - Help/TSL Debt Repayment",null,null,null,null,null,null,null,null,null,"Tax Saved or Deferred by Tax Planning",{"$f":"O53-O73","v":0},null,null,null,null,"Base rate entity",null,null,0.27500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P60=\"w\",P61=\"w\",P62=\"w\",P63=\"w\",P64=\"w\",P65=\"w\",P66=\"w\",P67=\"w\",P68=\"w\",P69=\"w\"),\"W = Warning: the tax payable on one or more allocations of income exceeds the company rate\",\"\")","v":""},null,null,null,null,"Superannuation Funds 2018"]
[null,null,null,"NOTE:  Personal income tax calculations include the standard tax-free threshold with allowance for the low income, but no other, tax offset.  Tax also includes Medicare levy and surcharge where applicable, the latter using the tier 3 rate of the levy, and without increased thresholds for children where applicable.  Repayments on any HELP/TSL debt where applicable uses taxable income and not Repayment Income.  Medicare levy is calculated at the full rate for singles, families or pensioners as applicable from the lower threshold (i.e. no shade-in calculations are made).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat rate for all superannuation funds",null,null,0.15]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicare 2018 (from PAYG withholding schedule)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Levy rate",null,null,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold - single",null,null,21655]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold - families",null,null,36541]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold - single pensioner",null,null,34244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold - family pensioner",null,null,47670]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicare Surcharge 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surcharge rate using Tier 3",null,null,1.4999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HELP & TLS Repayments 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,55873,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U90+1","v":55874},62238,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U91+1","v":62239},68602,null,4.4999999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68603,72207,null,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72208,77618,null,5.5E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77619,84062,null,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84063,88486,null,6.5000000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88487,97377,null,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97378,103765,null,7.4999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103766,10000000,null,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U99+1","v":10000001},20000000]

{"sheet":"Projection Worksheet","index":1,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,6,9,6]]}
[]
[null,null,{"$f":"CONCATENATE(\"Income & Expense Projections \",\"for \",'Main Worksheet'!M1)","v":"Income & Expense Projections for Client Name"}]
[null,null,{"$f":"CONCATENATE(\"For the Period from \",TEXT('Main Worksheet'!$E$11+1, \"dd mmm yyyy\"),\" to \",TEXT('Main Worksheet'!$T$9, \"dd mmm yyyy\"))","v":"For the Period from 01 Jan 2018 to 30 Jun 2018"}]
[]
[null,null,null,null,null,null,"Instructions"]
[null,null,"Income",null,null,null,"You can change or delete all existing descriptions as they are provided for quick data entry purposes only.\n\nThe sort icons will sort each list in alphabetical order."]
[null,null,"Contracting"]
[null,null,"Professional Fees"]
[null,null,"Sales"]
[]
[]
[]
[null,null," Total Income ",{"$f":"SUBTOTAL(109,Income[Column1])","v":0}]
[]
[]
[]
[]
[null,null,"Less Expenses"]
[null,null,"Accounting "]
[null,null,"Advertising"]
[null,null,"Bank Charges"]
[null,null,"Computer Software & Supplies"]
[null,null,"Donations"]
[null,null,"Electricity & Gas"]
[null,null,"Freight & Cartage"]
[null,null,"Hire of Plant & Equipment"]
[null,null,"Insurance"]
[null,null,"Interest"]
[null,null,"Lease Payments"]
[null,null,"Materials & Supplies"]
[null,null,"Motor Vehicle Expenses"]
[null,null,"Postage"]
[null,null,"Printing & Stationery"]
[null,null,"Purchases"]
[null,null,"Rates & Land Taxes"]
[null,null,"Rent"]
[null,null,"Repairs & Maintenance"]
[null,null,"Salaries & Wages"]
[null,null,"Subcontractors"]
[null,null,"Subscriptions"]
[null,null,"Sundries"]
[null,null,"Superannuation"]
[null,null,"Telephone "]
[]
[]
[]
[null,null,"  Total Expenses  ",{"$f":"SUBTOTAL(109,Expenses[Column1])","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Profit/(Loss) for the Period from \",TEXT('Main Worksheet'!$E$11+1, \"dd mmm yyyy\"),\" to \",TEXT('Main Worksheet'!$T$9, \"dd mmm yyyy\"))","v":"Profit/(Loss) for the Period from 01 Jan 2018 to 30 Jun 2018"},{"$f":"Income[[#Totals],[Column1]]-Expenses[[#Totals],[Column1]]","v":0}]