Rental Property Spreadsheet 2027: Rent Roll, Expenses and Cash Flow, Excel Template

Rent, costs, cash flow and who still owes you, for every property, in one Excel file that does the adding up for you.

WHY THIS ONE
• One table for all payments. No copy of the sheet for every property: type each payment once, with the property and tenant, and everything updates.
• Rent roll. Every tenant, month by month: paid, due, late or part paid, in colour. Late after the day you choose.
• Every property: income, costs, net income, yield so far and cash flow after the mortgage. Shared costs (insurance, accountant) split by number of units.
• Deposits kept apart from income, with how much you hold per tenant and per property.
• Formulas that work. Every formula is checked by automated tests against an independent calculation, in real Excel, before release. No macros, no scripts, no passwords.

WHAT'S INSIDE (10 tabs)
Start here, Settings, Rent, Expenses, Dashboard, Monthly, Properties, Tenants, Rent roll, Calc (every number can be traced).
• Dashboard: income, expenses, net income, cash flow, occupancy, rent owed to you now, deposits you hold, late payments, tenants who owe rent, and a Data check that tells you what is missing.
• Monthly: rent, other income, expenses by category, net income, mortgage principal, cash flow, deposits held.
• Room for 20 properties, 60 tenants, 2,000 payments and 1,000 expenses. Leases that start or end mid year.

YOU GET
• The blank file and a sample file with 3 properties and 6 tenants from January to September 2027.
• A 3 page PDF quick start guide.
• Excel 2016 or newer. We test every release in Excel on Windows. Not tested yet: Excel for Mac, Excel for the web, Google Sheets, Apple Numbers.

GOOD TO KNOW
• Any currency. English only for now.
• This is a tool for your own records, not tax, legal or accounting advice.
• Personal and business use for your own rentals; please do not resell the file.

Digital download only; no physical item will be shipped. For EU consumers, the statutory right of withdrawal is lost when the supply of digital content begins only if you have expressly consented to immediate supply, acknowledged the loss of that right, and the legally required confirmation has been provided. This does not affect your statutory rights if the files are faulty or not as described, or any applicable Etsy Purchase Protection. If you have trouble accessing or using your purchased files, please send us an Etsy Message with your order number and we will help.

Digital download only; no physical item will be shipped. For EU consumers, the statutory right of withdrawal is lost when the supply of digital content begins only if you have expressly consented to immediate supply, acknowledged the loss of that right, and the legally required confirmation has been provided. This does not affect your statutory rights if the files are faulty or not as described, or any applicable Etsy Purchase Protection. If you have trouble accessing or using your purchased files, please send us an Etsy Message with your order number, file name and a description of the problem. We will help you resolve it. Please do not send card or payment details.

AI was used to create the background scene of the listing images.