San Francisco · Google Sheets template
Rent payment reconciliation worksheet — San Francisco
Base rent due, received, credits and disputed amounts in separate columns so the balance is arithmetic anyone can check. Late fees and passthroughs sit in an informational column and never in the amount a 3-day notice could demand. The deposit is tracked separately and never applied to arrears during the tenancy.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Formulas verified on import.
Open Google SheetPreview
Blue cells are formulas; SAMPLE rows are synthetic.
| Summary | Total due | =SUM(C:C) | Total received | =SUM(F:F) | Credits | =SUM(H:H) | Disputed | =SUM(I:I) | Balance excl. disputed and fees | =C3-E3-G3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Period | Due date | Base rent due | Payment ref | Received date | Amount received | Allocated to | Credits | Disputed | Passthroughs / fees (info) | Period balance | Note |
| SAMPLE 2026-07 | 2026-07-01 | 3200 | Zelle #B7C3 | 2026-07-03 | 3200 | 2026-07 | 0 | 0 | 0 | =C6-F6-H6 | Paid 2 days after due |
| SAMPLE 2026-08 | 2026-08-01 | 3200 | Check #1044 | 2026-08-09 | 2400 | 2026-08 | 0 | 0 | 0 | =C7-F7-H7 | Partial payment |
| SAMPLE 2026-08 (credit) | 0 | 0 | 2026-08 | 150 | 0 | 0 | =C8-F8-H8 | Abatement: 3 days no hot water | |||
| SAMPLE 2026-09 | 2026-09-01 | 3200 | 0 | 2026-09 | 0 | 0 | 14.75 | =C9-F9-H9 | No payment as of 09-29; Rent Board fee passthrough noted (verify) |
Field definitions
- Base rent due
- From the lease or the last §827 notice; excludes passthroughs
- Received
- Each payment as it arrived; receipt on request
- Credits
- Agreed abatements, with the agreement on file
- Disputed
- Kept out of the balance
- Passthroughs / fees
- Rent Board fee, utilities, late fees: informational; never in a 3-day notice
- Summary
- Totals, balance with and without disputed