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

{"sheet":"Income","index":0,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[0,1,0,2],[5,0,5,3],[6,1,6,2],[17,0,17,2],[27,0,27,3],[37,0,37,4]]}
["Name:"]
["TFN:","if new client"]
["DOB:","if new client"]
["Financial Year:"]
[]
["INCOME STATEMENTS"]
["Occupation:"]
[]
["EMPLOYER ABN","GROSS PAYMENTS","ALLOWANCES","TAX WITHHELD"]
[]
[]
[]
[]
[]
["Total",{"$f":"SUBTOTAL(109,IncomeStatements[GROSS PAYMENTS])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncomeStatements[ALLOWANCES])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,IncomeStatements[TAX WITHHELD])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed."]
[]
["INTEREST"]
["BANK ACCOUNT","GROSS INTEREST","TAX WITHHELD"]
[]
[]
[]
[]
[]
["Total",{"$f":"SUBTOTAL(109,Interest[GROSS INTEREST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Interest[TAX WITHHELD])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed."]
[]
["DIVIDENDS"]
["COMPANY","FRANKED AMOUNT","FRANKING CREDIT","UNFRANKED AMOUNT"]
[]
[]
[]
[]
[]
["Total",{"$f":"SUBTOTAL(109,Dividends[FRANKED AMOUNT])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Dividends[FRANKING CREDIT])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Dividends[UNFRANKED AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed."]
[]
["CAPITAL GAINS/LOSSES"]
["ASSET","PURCHASE DATE","COST","SALE DATE","SALE AMOUNT"]
[]
[]
["Total",{"$f":"SUBTOTAL(109,CapitalGains[PURCHASE DATE])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,CapitalGains[COST])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,CapitalGains[SALE DATE])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,CapitalGains[SALE AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Insert new rows as needed.",{"$nulls":3},"SEE NEXT TAB >>"]

{"sheet":"Deductions","index":1,"n_rows":46,"n_cols":4,"rows_kept":46,"merged":[[27,0,27,1],[27,2,27,3],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1]]}
["Name:",{"$f":"Income!B1","v":0}]
["TFN:",{"$f":"Income!B2","v":"if new client"}]
["DOB:",{"$f":"Income!B3","v":"if new client"}]
["Financial Year:",{"$f":"Income!B4","v":0}]
["Occupation:",{"$f":"Income!B7","v":0}]
[]
["DEDUCTIONS"]
[]
["DATE","DEDUCTION INFO","CATEGORY (YOU MAY LEAVE THIS FOR BA)","AMOUNT"]
{"$rows_empty":16}
["Total",null,null,{"$f":"SUBTOTAL(109,Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Tab through to insert new rows as needed."]
["EXAMPLES",null,"SUMMARY"]
["LABEL",null,"LABEL (BENEFIT ACCOUNTING USE)","TOTAL"]
["Travel to various work sites, other than to and from work.",null,"D1 - Kms",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D1 - Kms\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["% of fuel, registration, insurance, repairs, etc.",null,"D1 - Car Expenses",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D1 - Car Expenses\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Work travel not reimbursed (flights/accom/meals, parking/tolls).",null,"D2 - Travel Expenses",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D2 - Travel Expenses\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Uniforms, boots, sunglasses, etc.",null,"D3 - Uniforms or Protective Gear",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D3 - Uniforms or Protective Gear\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Course fees, textbooks, stationery, travel to/from uni:work.",null,"D4 - Education Expenses",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D4 - Education Expenses\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Supplies, tools, stationery, phone/internet, briefcase, device, etc.",null,"D5 - Other-Work Related Expenses",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D5 - Other-Work Related Expenses\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Number of hours worked from home @ 80c shortcut method.",null,"D5 - Work From Home (hours)",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D5 - Work From Home (hours)\",Deductions[AMOUNT])*0.8","v":{"v":0,"d":"0.00"}}]
["Electricity, internet, home r&m, supplies/office furniture.",null,"D5 - Work From Home (% of expenses)",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D5 - Work From Home (% of expenses)\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Claims >$300ea for mv, tools, office furniture, etc",null,"D5 - Asset Purchases",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D5 - Asset Purchases\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Bank fees, certain advisory, financial market subscriptions, etc",null,"D7 - Interest Deductions",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D7 - Interest Deductions\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
[null,null,"D8 - Dividend Deductions",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D8 - Dividend Deductions\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Where an item was not purchased as part of the donation.",null,"D9 - Gifts or Donations",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D9 - Gifts or Donations\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Accountant fees, travel to/from, ATO interest charged.",null,"D10 - Cost of Managing Tax Affairs",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D10 - Cost of Managing Tax Affairs\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Received by your fund before 30th June up to concessional cap.",null,"D12 - Superannuation Contributions",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D12 - Superannuation Contributions\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
["Premiums paid outside your super fund.",null,"D15 - Income Protection",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D15 - Income Protections\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
[null,null,"D15 - Other Deductions, Jury Duty, Etc",{"$f":"SUMIF(Deductions[CATEGORY (YOU MAY LEAVE THIS FOR BA)],\"D15 - Other Deductions, Jury Duty, Etc\",Deductions[AMOUNT])","v":{"v":0,"d":"0.00"}}]
[null,null,"Check Total",{"$f":"SUM(D30:D45)","v":{"v":0,"d":"0.00"}}]