Tenant Payment Ledger

About this tool

Record the rent you charge and the payments you receive for each tenant or unit, with dates and how each payment was made. The ledger keeps a running balance for every tenant and shows how much is owed in total. Your ledger is kept only in this browser.

How it works

• Each entry can have a charge, a payment or both. Charges add to the balance of that tenant and payments take it away.
• The balance column is worked out down the list, in the order the entries appear, separately for each tenant. Keep entries in date order.
• A negative balance means the tenant has paid ahead.
• Owed by all tenants adds up only the positive balances. Balance by tenant shows charged, paid and balance for each tenant or unit.

Common questions

Why does a running balance look wrong after I add an old entry?

The running balance follows the order of the list, not the dates. Move older entries above newer ones, or export the file, sort it by date and import it again.

Does the final balance per tenant depend on the order?

No. Balance by tenant is all charges minus all payments for that tenant. Only the running balance on each line depends on the order.

Can this ledger be used as an official rent record?

It is a simple personal record. Rules on rent records and receipts depend on your country, so keep bank statements and receipts too, and ask a local adviser if there is a dispute.