Partial Rent Payments in the Rent Roll
The Rent Roll grid shows one row per property and one column per recent month. The glyph in each cell tells you at a glance whether rent for that month is on track:
- ✓ green — full rent received (within 5% of the expected amount)
- ≈ amber — partial payment (received less than 95% of expected); the actual dollar amount appears underneath
- ✗ red — no payment found and the property was active that month
- — grey — no payment found and no expected rent is configured. Payments with no expected-rent setting show a checkmark without a full-payment comparison; an active property’s status remains Untracked.
Why the 5% margin
Tenants often round down to the nearest dollar, deduct a small late fee they negotiated, or pay rent in two parts that don't sum to the exact penny. The 5% margin keeps these legitimate full payments from flagging as partial. For a $2,630 expected rent, anything from $2,499 up reads as ✓; anything below reads as ≈.
How to inspect a specific cell
Hover any cell in the grid to see the precise figures:
CAD 2,367.00 received / 2,630.00 expected (-263.00)
A negative delta means the tenant paid less than expected; a positive delta (rare) means they overpaid (sometimes happens with first + last month combined).
For missed rent (✗), the hover shows the expected amount so you can quickly chase the tenant: Missed: expected CAD 2,630.00.
Where the "expected" comes from
The expected monthly rent is the value you set on the property in Settings → "Set up ExpenseBot for what you track" → Rental Property → Expected rent. If you've never set a value, the property shows as Untracked in the Status column with a Set rent → link that opens the property editor directly. Until you set an expected rent, the Rent Roll can't tell partial from full payments — every received payment shows as ✓.
Multi-source rent
A single month often has multiple rent payments — for example, a tenant who pays in two installments. The Rent Roll sums all rent payments for that property in that month before comparing to expected, so two $1,000 deposits read as a full ✓ for a $2,000 expected rent. This relies on Gmail income detection or your bank reconciliation having caught both payments.
Late rent that lands in the next month
The Rent Roll groups payments by their recorded Income date. If March rent arrives April 3 and its Income date is April 3, it appears in April; ExpenseBot does not automatically backfill it into March. Review the Income entry and your records before interpreting a missing-month flag.
Auto-matched rent (tenant-name and amount cascade)
The bottom of the Rent Roll preview lists MAYBE chips — payments that look like rent but didn't match a configured property by address. Each chip shows source name, amount, and date so you can spot duplicates or assign the payment to a property if appropriate. The chips also surface payments the AI matched to a property by tenant name or unique amount when no address was in the email — those land directly on the property row in the grid (not as MAYBE chips), and a counter at the top shows auto-matched N via tenant/amount.
What if I want to mark a partial as "paid in cash for the rest"?
Use Add Income in the app (or edit the Income tab manually) to log the cash portion. The Rent Roll re-runs against the Income tab, so the next preview will show the full amount.
What if expected rent changes mid-year?
Update Expected rent in Settings → "Set up ExpenseBot for what you track" → Rental Property whenever rent rolls over (annual increase, lease change). The Rent Roll uses the property’s current expected-rent setting for every month in a new preview or generated report. It does not retain a separate expected-rent history for past months. An already generated report remains a snapshot; review older periods carefully after changing this setting.