An Excel workbook (XLSX) for landlords and hosts with up to 10 rental units: record monthly rent due, actual receipts, outstanding rent, paid costs and refundable deposits, and review the month on one Overview sheet. A BLANK workbook, a fictional DEMO and a PDF quick-start guide are included.

The problem it solves

Rent obligations, partial payments, repairs and refundable deposits end up in different notes and files, so it is hard to see what is owed, what arrived and what each unit cost.

Who it is for

Landlords, long-let owners and hosts with a small portfolio (up to 10 units) who want a simple record of rent and costs in desktop Excel.

What you get

• Compare rent due with payments received per unit, including partial and late payments
• See outstanding and overdue rent for the month you select, up to an as-of date
• Record paid property costs and see rent cash less paid costs
• Keep refundable deposits in their own register, outside rent income
• Flagged-input checks highlight duplicate IDs, unknown references and invalid dates or amounts
• Start from the BLANK workbook or learn first with the fictional DEMO

How you use it

1. Download and unzip your purchase, then read the quick-start PDF and try the fictional DEMO.
2. Open the BLANK workbook in desktop Microsoft Excel and use Save As to create your own working copy.
3. Add your units, then enter each month's rent due in Rent Due (gold cells are inputs; keep formula cells intact).
4. Record every receipt in Payments, paid costs in Expenses and refundable deposits in Deposits.
5. Choose the month and as-of date on Overview, review the flagged-record count, and save dated XLSX backups.

Questions