Description
Watch the setup guide & full tour
Track every tenant's rent in one tidy ledger: charges, payments, running balances, late fees, statements and receipts.
What's Inside
- START HERE: setup steps, ledger entry types, colour key
- DASHBOARD: rent roll, collected this month, total owed, tenants in arrears, late fees due, deposits held, collection rate, chart
- SETUP: rent due day, grace days, late-fee rules (flat, per day, cap), payment methods, properties
- TENANTS: up to 60 tenants with unit, lease dates, rent, deposit, balance, last payment and standing
- LEDGER: 2,000 rows of charges, payments, credits and deposits with a running balance per tenant
- RENT GRID: 12 months of rent paid per tenant, green / amber / red
- LATE FEES: pick a month, see paid, short, days late and the late fee for each tenant
- TENANT STATEMENT: printable statement with full history and balance due
- RENT RECEIPT: printable receipt for any payment, filled in for you
Why You'll Like It
- Running balance on every ledger row, per tenant
- Late fees worked out from your own grace days and fee rules
- Printable tenant statements and rent receipts
- Works in Excel AND Google Sheets (many rent ledgers are Sheets-only)
- Formulas only: no macros, no add-ons, no subscription
- Sample data for 8 tenants, following today's date
How It Works
- Download the .xlsx file and the Setup Guide PDF
- Excel: open it. Google Sheets: create a blank sheet, then File > Import > Upload > Replace spreadsheet
- Follow the Start Here tab, or watch the setup video
Please Note
- Digital download, no physical item is shipped
- A computer is recommended for setup; the Google Sheets app works for quick updates
- An organising tool for your own records, not legal, tax or financial advice. Check late-fee rules where your property is.
- For personal and business use. Please don't resell or share the files
Want your own store like this one? createdigitaltools.com runs on Hostinger WordPress hosting. Start your own shop with Hostinger, or try the no-code Hostinger Website Builder.
Affiliate links: I may earn a commission at no extra cost to you.
