Partial payments keep a balance. Late turns red on the 6th.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Door | Tenant | Due | Paid | Paid on | Balance | Status |
| 2 | 412 Alder St · A | Jide Okafor | $1,150 | $1,150 | Nov 1 | $0 | Paid |
| 3 | 412 Alder St · B | Rosa Delgado | $1,100 | $600 | Nov 3 | $500 | Partial |
| 4 | 88 Fenwick Ave | Tom and Ali Brandt | $1,650 | $1,650 | Nov 2 | $0 | Paid |
| 5 | 1907 Larkin Rd · 1 | Kevin Marsh | $925 | $0 | $925 | Late | |
| 6 | 1907 Larkin Rd · 2 | Mei Tanaka | $950 | $950 | Nov 4 | $0 | Paid |
| 7 | Total | $5,775 | $4,350 | $1,425 |
Type how often a job repeats. The next due date fills itself.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Job | Door | Every (months) | Last done | Next due | Status |
| 2 | Smoke and CO detector test | 1907 Larkin Rd | 6 | Apr 29, 2026 | Oct 29, 2026 | Late, 9 days |
| 3 | Furnace service | 88 Fenwick Ave | 12 | Nov 15, 2025 | Nov 15, 2026 | Due in 8 days |
| 4 | Gutter clean | 412 Alder St | 6 | May 28, 2026 | Nov 28, 2026 | Due in 21 days |
| 5 | Water heater flush | 1907 Larkin Rd | 12 | Dec 2, 2025 | Dec 2, 2026 | Due in 25 days |
| 6 | HVAC filter change | 412 Alder St | 3 | Sep 20, 2026 | Dec 20, 2026 | In 43 days |
| 7 | Dryer vent clean | 88 Fenwick Ave | 12 | Feb 14, 2026 | Feb 14, 2027 | In 99 days |
Every expense grouped by property and by IRS Schedule E line.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Schedule E line | 412 Alder St | 88 Fenwick Ave | 1907 Larkin Rd | Total |
| 2 | 3 Rents received | $23,150 | $18,150 | $19,700 | $61,000 |
| 3 | 5 Advertising | $1,780 | $0 | $1,375 | $3,155 |
| 4 | 6 Auto and travel | $0 | $1,160 | $1,060 | $2,220 |
| 5 | 7 Cleaning and maintenance | $610 | $1,330 | $0 | $1,940 |
| 6 | 9 Insurance | $0 | $0 | $1,760 | $1,760 |
| 7 | 10 Legal and other professional fees | $0 | $1,375 | $1,890 | $3,265 |
| 8 | 12 Mortgage interest paid to banks | $0 | $1,235 | $1,295 | $2,530 |
| 9 | 14 Repairs | $3,760 | $0 | $445 | $4,205 |
| 10 | 15 Supplies | $1,295 | $1,855 | $1,150 | $4,300 |
| 11 | 16 Taxes | $2,045 | $0 | $700 | $2,745 |
| 12 | 17 Utilities | $1,955 | $2,155 | $0 | $4,110 |
| 13 | 19 Other | $830 | $1,775 | $3,735 | $6,340 |
| 14 | Total expenses | $12,275 | $10,885 | $13,410 | $36,570 |
| 15 | Net before depreciation | $10,875 | $7,265 | $6,290 | $24,430 |
The Start here tab. Every other tab fills from these rows.
Finish your doors. Monday then shows who owes rent and which repair is due this week.
See the rent tab filled in