Rental income and expenses spreadsheet: the four tabs
| Tab | One row is | Columns |
|---|---|---|
| Income | One payment received | Date, property, unit, tenant, amount, type (rent, deposit, other), reference |
| Expenses | One cost paid | Date, property, category, supplier, amount, receipt reference, capital? (yes/no) |
| Monthly | One property, one month | Rent received, expenses, mortgage payment, cash flow |
| Annual | One property, one tax year | Total income, total expenses by category, capital costs, finance costs |
Record deposits as their own type and leave them out of rental income. A deposit held for the tenant is not your income, and mixing it in will overstate the year.
Give the receipt reference a simple pattern, such as the date plus a number ("0314-1"), and use the same reference as the file name of the receipt photo. Then anyone can find the paper behind a line in seconds.
Letvy's home screen shows the month's rent collected, expenses, loan payment and net cash flow, worked out from what you record. Get it on Google Play
Monthly summary and property cash flow
On the Monthly tab, each cell adds up the log for one property and one month, for example =SUMIFS(Income!E:E,Income!B:B,$A2,Income!H:H,B$1) where column H on the Income tab holds the month. Do the same for expenses, then subtract.
Cash flow is what is left after everything, including the mortgage payment. It is the number that tells you whether a property pays for itself each month. Try your own figures:
Property cash flow calculator
In the example, £1,100 rent less a 4% allowance for empty time is £1,056. Take off £180 of running costs and a £520 mortgage payment and £356 a month is left, or £4,272 a year.
Cash flow and taxable profit are different numbers. The full mortgage payment reduces your cash, but for tax only the interest is relevant, and it is treated in a restricted way for residential lets. Keep the interest and capital parts of the mortgage on separate lines.
Set the annual summary to the tax year
UK landlords report rental income by tax year, which runs from 6 April to 5 April. Build the Annual tab on those dates rather than January to December, so its totals match what goes on your Self Assessment return.
Useful columns for each property:
- Total rent received
- Other income from the letting (for example, charges to tenants for services)
- Expenses by category, using the same categories as the Expenses tab
- Finance costs (mortgage interest) on their own line
- Capital costs on their own line, kept for the future rather than the year's expenses
If you own a property jointly, keep the full figures in the spreadsheet and add a column for your share. HMRC's guidance on working out your rental income explains how different types of ownership are treated.
Landlord record keeping: what to keep and for how long
GOV.UK's page on records for rental income says to keep details of:
- The dates when you let out the property
- All the rent you receive
- Income from services you provide to tenants
- Rent books, receipts, invoices and bank statements
- The allowable expenses you pay to run the property
Records can be on paper or digital. How long you must keep them is set out on GOV.UK's how long to keep your records page. Keep records for capital costs for as long as you own the property, since they can matter when you sell.
Making Tax Digital for Income Tax requires some landlords to keep digital records and send updates to HMRC using compatible software. Whether and when it applies depends on your income; use HMRC's Making Tax Digital checker to find out.
Year-end checklist
- Check that the Income tab's total for each month matches the rent that reached your bank account.
- Look for expenses without a receipt reference and find the paperwork while it is still easy to get.
- Move anything that is an improvement rather than a repair into capital costs.
- Split the mortgage into interest and capital using the lender's annual statement.
- Save a copy of the finished year as a PDF or separate file, and back it up somewhere other than your computer.
- Start a fresh Income and Expenses tab for the new tax year, keeping the same columns.
If you hand the year to an accountant, send the Annual tab plus the two logs. A clear breakdown by property and category usually means fewer questions and a smaller bill.
Let the totals add themselves up
Letvy records rent and expenses against each property and can produce PDF statements and CSV exports for your accountant.
Get it on Google PlayiPhone version coming soon
More guides
- How to Track Rent Payments: A Monthly Routine for LandlordsA five-step monthly routine to track rent payments: set what is due, check the bank on a fixed day, match each payment, record part payments properly and log every chase.
- Rent Tracker Spreadsheet: Columns, Formulas and LayoutSet up a rent tracker spreadsheet that shows who has paid, who paid part and who still owes: the columns, three formulas that do the checking and a 12-month schedule tab.
- Landlord Expenses List: Categories, Examples and What to KeepA landlord expenses list to use as recording categories, how HMRC separates allowable expenses from capital costs, repair or improvement examples and how to log a cost.
- Rental Yield Calculator: Gross and Net Yield Worked OutWork out gross and net rental yield with a free calculator. Formulas, a worked example in pounds, what to count as costs, voids, and yield on the cash you put in.
Published by Zoranta, the developer of Letvy.