For small landlords with 1 to 20 units
Know who has paid. Know what is broken.
A rent ledger that counts days late, a repair log that counts days open, expenses by unit and a yearly cash flow summary. Works in Google Sheets and should open in Excel, with nothing to subscribe to.
Instant download · One-time price · Single-user license
Start HereSample DataSettingsUnitsRent LedgerRepairsExpensesSummary
| Month | Unit | Rent due | Paid | Balance | Days late | Status |
|---|---|---|---|---|---|---|
| Oct | Unit A | $1,150 | $1,150 | $0 | 0 | Paid |
| Oct | Unit B | $1,050 | $1,050 | 29 | Late | |
| Oct | Unit C | $950 | $950 | $0 | 0 | Paid |
Sample data only. All names and amounts are made up.
What's inside
- Units. Tenant, monthly rent, the day rent is due, deposit held and lease end, with days to lease end.
- Rent Ledger. One row per unit per month. Rent due and the due date fill in. Type what landed and when; balance, days late, status and your late fee (if any) follow.
- Repairs. Date reported, issue, urgency, contractor, status, cost and days open. Open requests stay highlighted.
- Expenses. Insurance, utilities, supplies and more, per unit or shared.
- Summary. Rent due, collected, open balance, repair costs, other expenses and net cash flow, per unit and per month.
How it works
- Download the .xlsx right after checkout.
- Open it in Google Sheets (File › Import › Upload). It should open in Excel too.
- Clear the samples and enter your own units and rents in Settings.
Local Shift templates are organizing tools. They are not tax, legal or financial advice and make no promise about income or results. Figures are only as accurate as what you enter.