Free rent ledger template

A rent ledger records every charge and payment on a tenancy, in date order, with the balance owed after each one. Enter the charges and payments, check the running balance, then print the ledger or download it for Excel.

What a rent ledger should include

  • The tenant, the address and the unit.
  • Any balance carried over from before the first entry.
  • Every charge on the date it was due — rent, fees and other charges — each on its own line.
  • Every payment on the date it was received, with how it was paid.
  • Credits, such as a concession, as their own lines.
  • The running balance after each entry.

Who uses a rent ledger

A tenant applying for rental assistance, a caseworker, a landlord preparing a late rent notice and a court deciding a nonpayment case all start from the ledger, because it shows what was charged, what was paid and when.

Late fees on the ledger

Where a state limits late fees or requires a grace period, a fee charged too early or too high shows up on the ledger. Seayora’s answers by state give each late fee rule with its statute.

Rent ledgers on Seayora

On Seayora, each rent charge and payment is recorded on the lease as it happens, so the history a ledger shows never has to be rebuilt from bank statements.

Frequently asked questions

What is a rent ledger?

A running record of every charge and payment on a tenancy — rent, fees and credits — with the balance owed after each entry.

What is the difference between a rent ledger and a rent roll?

A rent ledger is the history of charges and payments for one tenant or unit over time. A rent roll is a snapshot of every unit in a property on one date.

How do I show a credit or a refund on a rent ledger?

Enter a credit, such as a concession, in the payment column on its own line with a description. Enter a refund paid back to the tenant in the charge column, so the balance stays right.

Related pages