{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["How to use the tracker","Income and Expense tracker"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":0,"comments":18,"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","formulas":"cached_only"}

{"sheet":"How to use the tracker","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[{"$nulls":4},"1. Enter all your income and expense details in the red section."]
[]
[{"$nulls":4},"2. Use the headings on the left hand side of the red section to guide you through the types of income and expense you can record."]
[]
[{"$nulls":4},"3. Once you've entered all your details, the navy section at the top of the spreadsheet will calculate your totals"]
[{"$nulls":4},"4. The net profit is the amount you may have to pay tax on, use the tax band information in the top left hand of the spreadsheet to see current tax bands."]
[]
[{"$nulls":4},"We hope you find this tracker useful, if you have any feedback for us on this tracker email:"]
[{"$nulls":4},"admin@landlordvision.co.uk"]
[]
[{"$nulls":4},"To get started click the Income and Expense tracker tab."]

{"sheet":"Income and Expense tracker","index":1,"n_rows":112,"n_cols":15,"rows_kept":112,"cut":false,"hidden":false,"merged":[[50,11,50,13],[12,2,12,13],[18,11,18,13],[9,2,9,5],[9,6,9,7],[23,11,23,13],[28,11,28,13],[39,11,39,13],[10,2,10,5],[10,6,10,7],[2,2,2,14],[7,2,7,5],[7,6,7,7],[8,2,8,5],[5,2,5,5],[6,3,6,5],[5,6,5,7],[111,11,111,13],[83,11,83,13],[87,11,87,13],[94,11,94,13],[55,11,55,13],[76,11,76,13],[62,11,62,13]],"flags":["formulas_cached_only"]}
["Copyright RLA Landlord Vision Ltd"]
[]
[null,null,"                          Landlord Income and Expense Tracker"]
[]
[]
[null,null,"Total Income from Property",null,null,null,0]
[null,null,null,"Gross Profit",null,null,null,0]
[null,null,"Property Related Expenditures",null,null,null,0]
[]
[null,null,"Total Property Related Expenditures",null,null,null,0]
["Use these tax bands to determine how much tax you may have to pay on your net profit",null,"Net Profit",null,null,null,0,null,"The net profit is the \namount you may have to pay tax on. "]
[]
[null,null,"Tax Year April 2020 to April 2021"]
["Property Expenditures",null,"April","May","June","July","August","September","October","November","December","January","February","March","Totals"]
[]
["PROPERTY INCOME RECEIVED"]
["Rental Income Received",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Income Received i.e. ground rent",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["FINANCE CHARGES"]
["Interest Charged on Finance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Interest Charged on Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["20% Tax Credit on Disallowed Interest",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["RENTS, RATES, INSURANCE & GROUND RENTS"]
["Rents"]
["Ground Rent",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Rates"]
["Water Rates",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Council Tax",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electricity Supply Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Supply Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TV Satellite System Expenditure",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Television Licence Costs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telephone Line Rental Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Property Service Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Insurance"]
["Contents Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Buildings Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Landlord Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electrical Appliance Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Appliance Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Plumbing & Drainage Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electricity Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legal Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["MAINTENANCE, REPAIRS & RENEWALS"]
["Maintenance & Repairs"]
["External Maintenance & Repairs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Internal Maintenance & Repairs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Renewals - Fixtures & Fittings"]
["Bathroom",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kitchen",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Fires, Central Heating Systems",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Doors & Windows",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Renewals - Furniture & Furnishings"]
["Living Room",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Dining Room",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kitchen",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bathroom",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 1",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 2",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 3",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 4",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lounge",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hall",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Garage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["COST OF SERVICES INCLUDING WAGES"]
["Property Services"]
["Porterage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Washing & Ironing",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gardening",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Property Cleaning",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Wages"]
["Wages for Employee A",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Wages for Employee B",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["OTHER COSTS"]
["Travel Costs"]
["Train Journey Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bus Journey Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vehicle Expences i.e. car",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Travel Costs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]
["Other Typical Landlord Costs"]
["Safety Certificates - Gas",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Safety Certificates - Electricity",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Stationery, e.g., stamps, envelopes, books",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Computer equipment",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bad Debts",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legal and professional costs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Furniture/appliance rentals",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Advertisement costs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Letting agent costs",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Books, magazines, etc",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Books/Magazines/Newsletters",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Security/smoke alarms",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bank Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telephone Calls",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},"SUBTOTAL",null,null,0]