Works with Excel, Google Sheets, Apple Numbers, and LibreOffice.
The file has column headings and 12 blank rows. It contains no macros, formulas, tracking, or sample tenant data.
What the template tracks
| Group | Columns |
|---|---|
| Rental | Property, unit, tenant, rental period |
| Timing | Due date, date received |
| Money | Charge, payment, late fee, other charge or credit, balance |
| Evidence | Payment method, receipt number, notes |
The separate charge and payment columns are intentional. If $1,500 is due and only $1,000 arrives, keep the $1,500 charge, enter the $1,000 payment, and leave the remaining $500 visible. Do not replace the amount due with the amount received.
What a filled row looks like
| Property | Unit | Tenant | Rental period | Due | Received | Charge | Payment | Balance | Method |
|---|---|---|---|---|---|---|---|---|---|
| 123 Example St | 2A | Example Tenant | September 2026 | Sep 1 | Sep 3 | $1,500 | $1,000 | $500 | Bank transfer |
This example shows a partial payment. In a real ledger, add another row when the remaining $500 arrives rather than changing the first payment. The names and address above are fictional.
How to use it
- Open the CSV in your spreadsheet app and save a working copy in that app's normal format.
- Use one row for each charge, payment, credit, or correction. Do not combine several transactions into one row.
- Enter the date money was actually received, the period it covers, and the payment method.
- Reconcile non-cash payments with your bank or payment service each month.
- Keep receipts, bank records, and notes that support each entry. Back up the working file separately.
A blank template does not calculate for you
CSV is a plain data format, so this download does not contain formulas. You can add a running-balance formula in your spreadsheet, but check it after inserting or deleting rows. If you would rather avoid maintaining formulas, the Landlord Ledger demo shows the app's rent history and calculated balance display.