{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Work Related Expenses","List5"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"Work Related Expenses","index":0,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[6,2,6,4],[7,2,7,4],[7,6,7,7],[9,0,9,4],[9,6,9,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,1]]}
[]
["13-000-RBIZZ"]
["team@rbizz.com.au"]
["OTHER DEDUCTIONS / EXPENSES"]
["IMPORTANT : Please select a category to each expense in column C. For the list of category please refer column G. Please scroll the dropdown list to select the right category."]
[{"$nulls":7},{"$f":"SUM(D12:D499)","v":0}]
[null,"Name",{"$nulls":5},{"$f":"SUM(H13:H15,H17:H20,H22:H31,H33:H34,H36,H38:H46,H48:H50,H52:H75)","v":0}]
[null,"Financial Year",{"$nulls":4},{"$f":"IF(H6=H7,\"\",\"You have missed selecting category in column C\")","v":""}]
[]
["Other Expenses Details",{"$nulls":5},"Other Expenses Summary"]
["Date","Description","Select Expense Category - Ref Colm G","Amount","Notes",null,null,"Amount"]
[{"$nulls":6},"EXPENSE:"]
[{"$nulls":6},"Travel - Fare",{"$f":"SUMIF($C$12:$C$506,G13,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Travel - Meal",{"$f":"SUMIF($C$12:$C$506,G14,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Travel - Others",{"$f":"SUMIF($C$12:$C$506,G15,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Toal Travel Expenses",{"$f":"SUM(H13:H15)","v":0}]
[{"$nulls":6},"Uniform - Occupation Specific",{"$f":"SUMIF($C$12:$C$506,G17,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Uniform - Protective",{"$f":"SUMIF($C$12:$C$506,G18,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Uniform - Compulsory",{"$f":"SUMIF($C$12:$C$506,G19,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Uniform - Non-compulsory",{"$f":"SUMIF($C$12:$C$506,G20,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Toal Uniform Expenses",{"$f":"SUM(H17:H20)","v":0}]
[{"$nulls":6},"Self Education - Laptop",{"$f":"SUMIF($C$12:$C$506,G22,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Self Education - Desktop",0]
[{"$nulls":6},"Self Education - Tablet",0]
[{"$nulls":6},"Self Education - Phone",0]
[{"$nulls":6},"Self Education - Educaiton Fee",0]
[{"$nulls":6},"Self Education - Study Material",0]
[{"$nulls":6},"Self Education - Repairs",0]
[{"$nulls":6},"Self Education - Car Expenses",0]
[{"$nulls":6},"Self Education - Parking & Tolls",0]
[{"$nulls":6},"Self Education - Others",0]
[{"$nulls":6},"Toal Self Education Expenses",{"$f":"SUM(H22:H31)","v":0}]
[{"$nulls":6},"Tools - Up to $300 each",{"$f":"SUMIF($C$12:$C$506,G33,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Tools - More than $300 each",0]
[{"$nulls":6},"Toal Tools Expenses",{"$f":"SUM(H33:H34)","v":0}]
[{"$nulls":6},"Gifts and donations",0]
[]
[{"$nulls":6},"Mobile phone usage",0]
[{"$nulls":6},"Landline usage",0]
[{"$nulls":6},"Internet usage",0]
[{"$nulls":6},"Mobile phone device",0]
[{"$nulls":6},"Landline device",0]
[{"$nulls":6},"Internet device",0]
[{"$nulls":6},"Computer device",0]
[{"$nulls":6},"Computer consumables",0]
[{"$nulls":6},"Repairs and maintenance",0]
[{"$nulls":6},"Toal Phone, net & computer Expenses",{"$f":"SUM(H38:H46)","v":0}]
[{"$nulls":6},"Tax Affairs - Interest by ATO",0]
[{"$nulls":6},"Tax Affairs - Litigation",0]
[{"$nulls":6},"Tax Affairs - Tax Agent Fee",0]
[{"$nulls":6},"Toal Tax Affairs Expenses",{"$f":"SUM(H48:H50)","v":0}]
[{"$nulls":6},"Sun protection",0]
[{"$nulls":6},"Union fee",0]
[{"$nulls":6},"Personal super contribution",0]
[{"$nulls":6},"Project pool",0]
[{"$nulls":6},"Insurance - income protection/illness/sickness",0]
[{"$nulls":6},"Foreign exchange loss",0]
[{"$nulls":6},"Membership Fee - professional / trade",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]
[{"$nulls":6},"write name of deduction if needed",0]

{"sheet":"List5","index":1,"n_rows":56,"n_cols":1,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+'Work Related Expenses'!G13","v":"Travel - Fare"}]
[{"$f":"+'Work Related Expenses'!G14","v":"Travel - Meal"}]
[{"$f":"+'Work Related Expenses'!G15","v":"Travel - Others"}]
[{"$f":"+'Work Related Expenses'!G17","v":"Uniform - Occupation Specific"}]
[{"$f":"+'Work Related Expenses'!G18","v":"Uniform - Protective"}]
[{"$f":"+'Work Related Expenses'!G19","v":"Uniform - Compulsory"}]
[{"$f":"+'Work Related Expenses'!G20","v":"Uniform - Non-compulsory"}]
[{"$f":"+'Work Related Expenses'!G22","v":"Self Education - Laptop"}]
[{"$f":"+'Work Related Expenses'!G23","v":"Self Education - Desktop"}]
[{"$f":"+'Work Related Expenses'!G24","v":"Self Education - Tablet"}]
[{"$f":"+'Work Related Expenses'!G25","v":"Self Education - Phone"}]
[{"$f":"+'Work Related Expenses'!G26","v":"Self Education - Educaiton Fee"}]
[{"$f":"+'Work Related Expenses'!G27","v":"Self Education - Study Material"}]
[{"$f":"+'Work Related Expenses'!G28","v":"Self Education - Repairs"}]
[{"$f":"+'Work Related Expenses'!G29","v":"Self Education - Car Expenses"}]
[{"$f":"+'Work Related Expenses'!G30","v":"Self Education - Parking & Tolls"}]
[{"$f":"+'Work Related Expenses'!G31","v":"Self Education - Others"}]
[{"$f":"+'Work Related Expenses'!G33","v":"Tools - Up to $300 each"}]
[{"$f":"+'Work Related Expenses'!G34","v":"Tools - More than $300 each"}]
[{"$f":"+'Work Related Expenses'!G36","v":"Gifts and donations"}]
[{"$f":"+'Work Related Expenses'!G38","v":"Mobile phone usage"}]
[{"$f":"+'Work Related Expenses'!G39","v":"Landline usage"}]
[{"$f":"+'Work Related Expenses'!G40","v":"Internet usage"}]
[{"$f":"+'Work Related Expenses'!G41","v":"Mobile phone device"}]
[{"$f":"+'Work Related Expenses'!G42","v":"Landline device"}]
[{"$f":"+'Work Related Expenses'!G43","v":"Internet device"}]
[{"$f":"+'Work Related Expenses'!G44","v":"Computer device"}]
[{"$f":"+'Work Related Expenses'!G45","v":"Computer consumables"}]
[{"$f":"+'Work Related Expenses'!G46","v":"Repairs and maintenance"}]
[{"$f":"+'Work Related Expenses'!G48","v":"Tax Affairs - Interest by ATO"}]
[{"$f":"+'Work Related Expenses'!G49","v":"Tax Affairs - Litigation"}]
[{"$f":"+'Work Related Expenses'!G50","v":"Tax Affairs - Tax Agent Fee"}]
[{"$f":"+'Work Related Expenses'!G52","v":"Sun protection"}]
[{"$f":"+'Work Related Expenses'!G53","v":"Union fee"}]
[{"$f":"+'Work Related Expenses'!G54","v":"Personal super contribution"}]
[{"$f":"+'Work Related Expenses'!G55","v":"Project pool"}]
[{"$f":"+'Work Related Expenses'!G56","v":"Insurance - income protection/illness/sickness"}]
[{"$f":"+'Work Related Expenses'!G57","v":"Foreign exchange loss"}]
[{"$f":"+'Work Related Expenses'!G58","v":"Membership Fee - professional / trade"}]
[{"$f":"IF('Work Related Expenses'!G59=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G59)","v":""}]
[{"$f":"IF('Work Related Expenses'!G60=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G60)","v":""}]
[{"$f":"IF('Work Related Expenses'!G61=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G61)","v":""}]
[{"$f":"IF('Work Related Expenses'!G62=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G62)","v":""}]
[{"$f":"IF('Work Related Expenses'!G63=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G63)","v":""}]
[{"$f":"IF('Work Related Expenses'!G64=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G64)","v":""}]
[{"$f":"IF('Work Related Expenses'!G65=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G65)","v":""}]
[{"$f":"IF('Work Related Expenses'!G66=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G66)","v":""}]
[{"$f":"IF('Work Related Expenses'!G67=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G67)","v":""}]
[{"$f":"IF('Work Related Expenses'!G68=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G68)","v":""}]
[{"$f":"IF('Work Related Expenses'!G69=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G69)","v":""}]
[{"$f":"IF('Work Related Expenses'!G70=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G70)","v":""}]
[{"$f":"IF('Work Related Expenses'!G71=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G71)","v":""}]
[{"$f":"IF('Work Related Expenses'!G72=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G72)","v":""}]
[{"$f":"IF('Work Related Expenses'!G73=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G73)","v":""}]
[{"$f":"IF('Work Related Expenses'!G74=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G74)","v":""}]
[{"$f":"IF('Work Related Expenses'!G75=\"write name of deduction if needed\",\"\",'Work Related Expenses'!G75)","v":""}]