Rent ledger example: partial payments and running balances
This fictional rent ledger starts with $200 already due, adds $1,200 rent, records payments of $700 and $500, and applies a $100 credit. The closing rent balance is $100 due. A $1,200 security deposit stays separate.
All amounts are USD. The names, dates and transactions below are synthetic examples, not customer records. For definitions and a comparison with rent rolls and receipts, read what a rent ledger records.
The starting position
Imagine a tenancy at Cedar Court, Unit 4. The record begins on October 1, 2026, with $200 rent carried forward from the previous record. October rent is $1,200. The deposit receipt is entered separately on October 1. It does not pay the carried balance or October’s charge.
The opening balance should represent the position immediately before the new transactions. If the $200 already includes earlier charges and payments, importing those transactions again would count them twice.
A transaction-by-transaction rent ledger
| Date | Entry | Charge | Payment or credit | Rent balance due |
|---|---|---|---|---|
| October 1 | Opening balance brought forward | — | — | $200 |
| October 1 | Deposit received: $1,200 held separately | — | — | $200 |
| October 1 | October rent charge | $1,200 | — | $1,400 |
| October 3 | First payment | — | $700 | $700 |
| October 10 | Second payment | — | $500 | $200 |
| October 12 | Agreed rent credit | — | $100 | $100 |
$200 + $1,200 − $700 − $500 − $100 = $100 rent due. Payments total $1,200, the credit totals $100, and the deposit held is $1,200. Those are different figures with different meanings.
The tenant paid an amount equal to October’s rent, yet $100 remains due because the ledger began with a $200 balance. A list of payments alone would miss that context. Keep the opening position visible when sharing the statement.
Why the two payments need separate rows
The $700 and $500 payments happened on different dates. Combining them into one $1,200 payment would hide when each amount was received. Record each payment once, add its reference, and use the rent period to explain which month it relates to.
A rent period is a label for the record; it does not establish a legally required allocation order. The running balance shown here is the total recorded position for this tenancy. Check the lease, supporting records and applicable rules when allocation is disputed.
Credits, overpayments and rent refunds
The $100 credit reduces rent due without recording cash received. Describe why it was agreed so it can be distinguished from the two payments. Counting the credit as another payment would overstate the money received.
A negative rent balance represents a credit in this app. If another $150 payment followed the example, the $100 due would become a $50 rent credit. That is an illustration of the calculation, not an instruction to collect an extra payment.
A recorded rent refund has the opposite effect of a payment: it increases the rent balance. Refunding $50 from that $50 credit would return the balance to zero. Recording a $50 refund immediately after the table’s $100 due would instead increase the amount due to $150. Enter a refund only to reflect the actual event.
Keep the deposit outside rent arithmetic
The $1,200 deposit received changes deposit held, while the rent balance stays at $200 on that row. A deposit return reduces deposit held without automatically changing rent due. Do not record the same deposit as both a deposit and a rent payment.
RentLedgerKit’s separate totals help avoid treating all money received as rent. They do not decide whether a deposit may be applied, retained or returned in a particular situation.
Correct an entry without hiding the original
Suppose the $700 payment was accidentally entered twice. A second copy would wrongly reduce the closing balance from $100 due to a $600 credit. In a saved workspace, use a reversal against the duplicate and explain the mistake. The reversal adds back its $700 effect, restoring $100 due, while both the duplicate and correction remain visible.
If the amount itself was wrong, reverse the incorrect payment and add a new payment with the correct details. A correction changes the record; it does not send or recover money.
Check the example against your own records
Use the free balance checker to map one CSV or XLSX sheet, review possible duplicates and compare reported balances with computed figures. Choose the right opening date and as-of date. A missing transaction can leave the arithmetic consistent but the record incomplete.
Build a record with the free rent ledger generator, then export a PDF or CSV before closing the free tool. Saving uploads records to your account; see data handling and access and workspace pricing. This example explains the app’s arithmetic and is not legal, tax or accounting advice for a specific tenancy.