06 · Rental Ledger
Rental Ledger and Landlord Spreadsheet
A rental ledger for a small landlord, with a multi-property dashboard, a rent roll, a deposit tracker, and cash-flow and return calculators.
$8
Spreadsheet · Printable PDF · Hyperlinked PDF
Secure checkout through Payhip. Instant download after purchase.
Refunds: if a file won't open, is missing something, or isn't as described, email [email protected] within 14 days of purchase and we'll fix it or give you a full refund. TABWORK is a brand of IQ Learning LLC.

Who it is for
Small landlords in the US or Australia who want one workbook for rent, expenses, deposits, and returns, plus matching condition reports and a screening checklist.
The hero tool
The multi-property dashboard totals rent collected, expenses, outstanding rent, late flags, deposits held, and upcoming lease renewals or inspections, for up to 10 properties. Cash-flow, cap-rate, and cash-on-cash calculators read the rent roll, the expense ledger, and the figures you enter for value, cash invested, and annual debt service.
What is included
- A calculating workbook that opens in Excel, Google Sheets, and Numbers (no macros)
- A printable PDF (19 letter-size pages; also prints on A4)
- A hyperlinked PDF for tablet annotation apps
- Multi-property dashboard, rent roll, security deposit tracker, and expense ledger
- US Schedule E and Australian ATO category map with a region switch in one file
- Cash-flow, cap-rate, and cash-on-cash calculators, plus a year-end summary
- Move-in and move-out condition reports, and a fair-housing-neutral screening checklist
- A start-here note and a personal-use license
The file includes a full-year sample for Property A and Property B that you can delete. Use short labels (Property A, Tenant 1) on pages you might share. The category maps, calculators, and checklists are planning aids, not official forms.
Inside the file
These are real page renders from the planner, not mock layouts.



Questions about the Rental Ledger
What opens the spreadsheet?
It opens in any spreadsheet app. There are no macros. Cells you type in are tinted; leave the formula cells alone.
How many properties does it track?
Up to 10. The dashboard totals rent collected, expenses, outstanding rent, late flags, deposits held, and upcoming renewals or inspections.
Can I give a tenant a record of their rent payments?
The rent roll keeps each tenant's payments in one place, so you can print or share that record when a tenant asks. It is your own record, not an official form.
Does it work outside the US?
It includes a US Schedule E and an Australian ATO category map with a region switch in one file. The maps are planning aids, not tax filings.
How much is it, and where do I buy it?
It is $8 on Payhip, with secure checkout and an instant download.
Related
Planning tool only. Not tax, legal, financial, or fair-housing advice, and not a tax filing or a legal form.
