Partial rent payments tracker: monitor balances when tenants pay part of monthly rent
Two of the four tenants at Madison Square Apartments paid only part of the rent this month. The Rent Ledger marks those rows Partial and keeps the shortfall in Balance and Running balance, with any late fee shown beside it.
Free: Rent Due & Late Fee Calculator, one Excel tab. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on running a small rental. Unsubscribe in one click. Privacy.
General information only, not tax, legal or accounting advice. Late-fee, deposit and notice rules vary by state, city and lease; check your own. Names and numbers in the example are invented.
What changes for this kind of rental
A ledger row reads Partial when Amount paid is above zero but below Rent due. Balance is Rent due minus Amount paid for that one row. Running balance then carries each unit's balance forward from row to row, so a tenant short two months in a row shows a larger figure than one short once. Keep the rows in date order or that column reads wrong.
The late fee has its own column. While a row is short, Days late runs from the due date plus the grace days up to the as-of date; once the rent is paid in full it stops at the Date paid. When Days late reaches 1 or more, the fee is charged once for that row, shown as charged, not assumed collected, and never added to Rent due or Balance.
A worked month: Madison Square Apartments
Invented names and numbers, to show the shape. 4 units on the Units & Leases tab, all with the Property cell set to Madison Square Apartments.
| Unit | Tenant | Monthly rent |
|---|---|---|
| A | Alice Patel | $1,500 |
| B | Bob Chen | $1,200 |
| C | Carol Martinez | $1,400 |
| D | David Lee | $1,300 |
Occupied units schedule $5,400 a month.
One Rent Ledger row per occupied unit for the month:
| Unit | Tenant | Rent due | Amount paid | Balance |
|---|---|---|---|---|
| A | Alice Patel | $1,500 | $1,500 | $0 |
| B | Bob Chen | $1,200 | $800 | $400 |
| C | Carol Martinez | $1,400 | $700 | $700 |
| D | David Lee | $1,300 | $1,300 | $0 |
| Total | $5,400 | $4,300 | $1,100 |
The month shows $4,300 collected of $5,400 scheduled, with $1,100 still owed.
Bills for the month, one Expenses row each:
| Bill | Category | Amount | How it is logged |
|---|---|---|---|
| Water and sewer, shared meter | Utilities | $240 | Split by units: 4 units, $60 each |
| HVAC filter and ductwork cleaning | Repairs | $185 | Property level, not split |
| Property manager monthly fee | Management fees | $360 | Property level, not split |
| Common area carpet cleaning | Cleaning and maintenance | $150 | Property level, not split |
| Total | $935 |
The split bills total $240. The Expenses tab divides each equally by the number of units listed for the property (4), so each unit carries $60 of them.
Where each piece goes in the workbook
- Start Here: Type the grace days, the late-fee type (Flat or Percent) with its amount and optional cap, and the as-of date. Status, Days late and Running balance are measured against the as-of date, so set it before you read the ledger.
- Units & Leases: Type one row each for units A through D: Property, tenant, lease dates, Monthly rent, Due day and Status set to Occupied. Deposit held fills in from the Deposits tab, so leave that cell alone.
- Rent Ledger: Type one row per unit per month: Unit, Month, Due date, Monthly rent, Amount paid and Date paid. For a short payer, type only what arrived. Status, Days late, Late fee, Balance and Running balance fill themselves.
- P&L: Read Scheduled rent, Rent collected and Not yet collected for the month. Not yet collected is scheduled minus collected, so the short payers land there. Late fees charged sits below it as information only, not income.
Two formulas worth a cell of their own
- Units in a property, the number behind every split:
=COUNTIF('Units & Leases'!$B$6:$B$15,"Madison Square Apartments")returns 4 here. - Rent paid by one unit across the ledger:
=SUMIFS('Rent Ledger'!$G$6:$G$505,'Rent Ledger'!$A$6:$A$505,"A")returns $1,500 on this example.
Four tracking tips
- Type what arrived, never what is left. If Unit B sends part of the rent, Amount paid holds that part and Balance does the subtraction. Typing the shortfall instead makes both Status and Balance come out wrong.
- Running balance is kept per unit, so Unit B's shortfall never appears in Unit C's figure. For a building-wide number use the Not yet collected line on the P&L, which is scheduled rent minus rent collected.
- The ledger holds one Amount paid and one Date paid per row. When a short payer sends the rest later, raise Amount paid to the total received so far. Status moves to Paid or Paid late depending on the Date paid you type.
- A short row's Days late moves with the as-of date, because the rent is not paid in full. For a live ledger type =TODAY() on Start Here. For a worked example keep a fixed date so the numbers hold still while you review.
Questions
Does a Partial row always get a late fee?
No. The fee follows Days late, not Status. After the grace days on Start Here, a short row's Days late runs up to the as-of date. At 1 or more, the fee is charged once for that row, as a flat amount or a percent of Rent due with an optional cap. It is never added to Rent due or Balance.
Can a tenant's deposit cover a short month?
Your lease and local rules decide that, not the workbook. Deposits stay out of rent and out of the P&L, and typing deposit money as Amount paid would count it as rent collected. If you keep part of a deposit, record the amount kept and a note on that tenant's Deposits row.
Related landlord guides
- Rent payment tracker spreadsheet: a late-status formula
- Rental property income and expense spreadsheet: a 12-month duplex log
- Late fee calculator in Excel: a formula with a grace period
More landlord guides
- Landlord spreadsheets by property type and lease situation
- Basement apartment and ADU rental income and expense spreadsheet: two very different units
- Condo rental income and expense spreadsheet: one unit, HOA dues and assessment
- Fourplex rental income and expense spreadsheet: four units, partial payment
- House-hack rental income and expense spreadsheet: live in one unit, rent the others
- Month-to-month tenants rent tracker spreadsheet: leave Lease end empty, watch the ledger
- Rent increase at lease renewal: plan and preview increases as leases end
- Room rental income and expense spreadsheet: four rooms, three tenants, one empty room
- Single-family rental income and expense spreadsheet: one house, one tenant
- Small apartment building rent roll spreadsheet: six units, one vacant
- Tenant turnover and vacancy tracker: monitor move-outs, move-ins, and prorated rent
- Triplex rental income and expense spreadsheet: three units, shared water
Already built
The Landlord Rent & Expense Tracker has the rent roll, rent ledger, expenses, deposits and P&L tabs wired together, with example data on every tab. One Excel file, $29.