{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Update Rental Records","List"],"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":"Update Rental Records","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[10,2,10,4],[12,6,12,7],[1,0,1,7],[2,0,2,7],[0,0,0,7],[3,0,3,7],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[12,0,12,4]]}
[]
["13-000-RBIZZ"]
["team@rbizz.com.au"]
["RENTAL RECORD KEEPING"]
[null,null,null,"IMPORTANT - Please ensure all transactions fall within the first and last date of the financial year."]
[]
[null,"Property Address"]
[null,"Date property first available for rent:"]
[null,"Number of weeks available for rent in the year:"]
[null,"Your ownership percentage:"]
[null,"Financial Year"]
[]
["Rental Record Keeping",{"$nulls":5},"Rental Summary"]
["Date","Description","Type","Amount","Notes",null,null,"Amount"]
[{"$nulls":6},"INCOME:"]
[{"$nulls":6},"Rental Income",{"$f":"SUMIF($C$15:$C$507,G16,$D$15:$D$507)","v":0}]
[{"$nulls":6},"Other rental related income",{"$f":"SUMIF($C$15:$C$507,G17,$D$15:$D$507)","v":0}]
[{"$nulls":6},"Total Rental Income",{"$f":"SUM(H16:H17)","v":0}]
[{"$nulls":6},"EXPENSE:"]
[{"$nulls":6},"Advertising for tenants",{"$f":"SUMIF($C$15:$C$507,G20,$D$15:$D$507)","v":0}]
[{"$nulls":6},"Body corporate",0]
[{"$nulls":6},"Borrowing expenses",0]
[{"$nulls":6},"Cleaning",0]
[{"$nulls":6},"Council rates",0]
[{"$nulls":6},"Capital allowances",0]
[{"$nulls":6},"Gardening/lawn mowing",0]
[{"$nulls":6},"Insurance",0]
[{"$nulls":6},"Interest on loans",0]
[{"$nulls":6},"Land tax",0]
[{"$nulls":6},"Legal fees",0]
[{"$nulls":6},"Pest control",0]
[{"$nulls":6},"Property agent fees/commission",0]
[{"$nulls":6},"Repairs and maintenance",0]
[{"$nulls":6},"Capital works deductions",0]
[{"$nulls":6},"Stationery, telephone and postage",0]
[{"$nulls":6},"Travel expenses",0]
[{"$nulls":6},"Water charges",0]
[{"$nulls":6},"Sundry rental expenses",0]
[{"$nulls":6},"Total Rental Expenses",{"$f":"SUM(H20:H38)","v":0}]
[]
[{"$nulls":6},"Net Rent",{"$f":"+H18-H39","v":0}]
[]
[{"$nulls":6},"OTHERS:"]
[{"$nulls":6},"New asset purchased",{"$f":"SUMIF($C$15:$C$507,G44,$D$15:$D$507)","v":0}]
[{"$nulls":6},"Other expenses",0]

{"sheet":"List","index":1,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Rental Income"]
["Other rental related income"]
["Advertising for tenants"]
["Body corporate"]
["Borrowing expenses"]
["Cleaning"]
["Council rates"]
["Capital allowances"]
["Gardening/lawn mowing"]
["Insurance"]
["Interest on loans"]
["Land tax"]
["Legal fees"]
["Pest control"]
["Property agent fees/commission"]
["Repairs and maintenance"]
["Capital works deductions"]
["Stationery, telephone and postage"]
["Travel expenses"]
["Water charges"]
["Sundry rental expenses"]
["New asset purchased"]
["Other expenses"]