A rent ledger that makes partial payments easy to follow

Keep charges and receipts separate

A rent charge records what a tenant is expected to pay for a period. A payment records money actually received on a date. Keeping both avoids the common spreadsheet shortcut of replacing the expected rent with whatever arrived.

Follow a partial-payment example

For an illustrative monthly charge of $1,800, a $1,200 receipt leaves $600 outstanding. When another $400 arrives, add a second payment and the remaining balance becomes $200. Do not rewrite the first receipt as $1,600: preserving both receipts keeps their dates and references visible.

Swipe or scroll sideways to see every column.

Compare rent balances with recorded cash flow

Use the rent period deliberately

A payment received this month may settle a previous month. Assign the appropriate rent period while retaining the actual received date. That lets an owner answer both “How much cash arrived in September?” and “How much of August’s rent is still outstanding?” without forcing both reports to be the same.

Correct mistakes with a trail

If a duplicate payment was entered, reverse the duplicate with a reason rather than quietly editing unrelated records. A credit and a cash refund are different events. Document what happened and link the relevant proof so a co-owner can understand the correction later.

Use reminders as communication, not legal notices

Check the ledger and recipient before sending a friendly payment reminder. A recorded amount may need explanation if there is a dispute or an agreed adjustment. StayVue templates help prepare correspondence; they do not determine whether a fee, increase or formal notice is allowed under local tenancy rules. Use the appropriate local process for those questions.