{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["How to use the spreadsheet","Income and expense tracker","Disclaimer"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":0,"comments":19,"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 spreadsheet","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 green section."]
[]
[{"$nulls":4},"2. Use the headings on the left hand side of the green 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 grey 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 corner 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":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[[112,10,112,12],[7,1,7,3],[6,4,6,5],[9,4,9,5],[10,4,10,5],[12,1,12,12],[9,1,9,3],[10,1,10,3],[2,1,2,13],[5,4,5,5],[6,1,6,3],[7,4,7,5],[5,1,5,3]],"flags":["formulas_cached_only"]}
[]
[]
[null,"Income and expense tracker for landlords"]
[]
[]
[null,"Total Income from Property",null,null,0]
[null,"Gross Profit",null,null,0]
[null,"Property Related Expenditures",null,null,0]
[]
[null,"Total Property Related Expenditures",null,null,0]
[null,"Net Profit",null,null,0]
["Use these tax bands to determine how much tax \nyou may have to pay on your net profit",null,null,"The net profit is the \namount you may have to pay tax on. "]
[null,"Tax Year 6th April 2024 to 5th April 2025"]
["Property Expenditures","April","May","June","July","August","September","October","November","December","January","February","March","Totals"]
[]
["PROPERTY INCOME RECEIVED"]
["Rental Income Received",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Income Received i.e. ground rent",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Money Retained From Tenant Deposit",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["FINANCE CHARGES"]
["Interest Charged on Finance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Interest Charged on Loan",0,0,0,0,0,0,0,0,0,0,0,0,0]
["20% Tax Credit on Mortgage Interest",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["RENTS, RATES, INSURANCE & GROUND RENTS"]
["Rents"]
["Ground Rent",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Rates"]
["Water Rates",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Council Tax",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electricity Supply Charges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Supply Charges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["TV Satellite System Expenditure",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Television Licence Costs",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telephone Line Rental Charges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Property Service Charges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Insurance"]
["Contents Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Buildings Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Landlord Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electrical Appliance Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Appliance Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Plumbing & Drainage Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Electricity Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legal Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["MAINTENANCE, REPAIRS & RENEWALS"]
["Maintenance & Repairs"]
["External Maintenance & Repairs",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Internal Maintenance & Repairs",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Renewals - Fixtures & Fittings"]
["Bathroom",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kitchen",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gas Fires, Central Heating Systems",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Doors & Windows",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Renewals - Furniture & Furnishings"]
["Living Room",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Dining Room",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kitchen",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bathroom",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 1",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 2",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 3",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedroom 4",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lounge",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hall",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Garage",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["COST OF SERVICES INCLUDING WAGES"]
["Property Services"]
["Porterage",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Washing & Ironing",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gardening",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Property Cleaning",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Wages"]
["Wages for Employee A",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Wages for Employee B",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["OTHER COSTS"]
["Travel Costs"]
["Train Journey Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bus Journey Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vehicle Expenses i.e. car",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Travel Costs",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"April","May","June","July","August","September","October","November","December","January","February","March",0]
["Other Typical Landlord Costs"]
["Safety Certificates - Gas",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Safety Certificates - Electricity",0,0,0,0,0,0,0,0,0,0,0,0,0]
["EPC Certificate",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Stationery, e.g., stamps, envelopes, books",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Computer equipment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bad Debts",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legal and professional costs",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Furniture/appliance rentals",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Advertisement costs",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Letting agent costs",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Books, magazines, etc",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Security/smoke alarms",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bank Charges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telephone Calls",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"SUBTOTAL",null,null,0]

{"sheet":"Disclaimer","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,"This ‘Landlord Vision’ spreadsheet is produced for general guidance only, and professional advice should be sought before any decision is made. Nothing in this spreadsheet should be construed as the giving of advice. Individual circumstances can vary and therefore no responsibility can be accepted by the contributors or the publisher, Landlord Vision Ltd, for any action taken, or any decision made to refrain from action, by any users of this spreadsheet. All rights reserved. No part of this spreadsheet may be reproduced or transmitted in any form or by any means. To the fullest extent permitted by law, the contributors and Landlord Vision do not accept liability for any direct, indirect, special, consequential or other losses or damages of whatsoever kind arising from using this spreadsheet."]