Rent Ledger & Rent Receipt Template: Tenant Payment Tracker with Late Fees, Partial Payments + Fillable PDF Receipts

Always know who has paid, who owes what, and send a proper receipt for every payment.

For landlords with up to 20 tenants. Log each payment once; the ledger, rent roll and receipts fill themselves in.

WHAT'S INSIDE

- Tenant Ledger: pick a tenant and see 12 months of rent due, late fees, other charges, payments, a running balance and a status (Paid, Paid late, Partial, Unpaid, Upcoming, Prepaid)

- Rent Roll: every tenant and month on one screen, with the balance owed today

- Partial payments, early payments and catch-up payments handled automatically (choose which month a payment is for)

- Optional late fees: OFF by default. Switch on and set your own flat fee and grace days (per tenant if needed). Charged once per month, never compounding

- Other charges and credits: utility pass-through, pet rent, damage charges, waived fees

- Auto-numbered receipts: pick a receipt number and a printable receipt appears, including what's still owed for that month

- Fillable PDF rent receipts (4 receipts, 2 per page) for cash or paper payments

- Fillable one-page paper ledger + editable Word / Google Docs receipt

- SAMPLE-DATA version (5 tenants) + clean blank version

- Quick-Start Guide (PDF)

WORKS WITH

Excel and Google Sheets for the spreadsheet; Adobe Acrobat Reader, Mac Preview or Chrome/Edge for the fillable PDFs; Word or Google Docs for the DOCX.

Late-fee limits and receipt rules vary by state and city. The spreadsheet only uses the amounts you enter.

NOT LEGAL OR TAX ADVICE

These are generic organizational templates, not state-specific forms. They are not a lease, notice or eviction document. Landlord-tenant rules (deposits, late fees, receipts, inspections) vary by state and city: check yours.

LICENSE

Use for every property you own + up to 3 client properties you manage. No resale or sharing of the blank templates.

Instant download (.zip). Questions about the files: hello@keyandkit.com. Free updates: keyandkit.com/updates