Free landlord template

Rent Ledger Template

A free Excel rent ledger for landlords. Record charges and payments for each tenant, keep a running balance automatically, and see who owes what at a glance.

Download the template

Works in Excel, Google Sheets, Numbers and LibreOffice. No sign-up.

What's inside

The Ledger sheet has one row per charge or payment. The Summary sheet totals each tenant automatically. Here is the worked example included in the file:

DateTenantUnitDescriptionChargePaymentBalance
2026-11-01J. SmithUnit ANovember rent$1,450$1,450
2026-11-03J. SmithUnit APayment, bank transfer$1,450$0
2026-12-01J. SmithUnit ADecember rent$1,450$1,450
2026-12-08J. SmithUnit ALate fee$50$1,500
2026-12-10J. SmithUnit APayment, check #1042$1,000$500

How to use the rent ledger

Add a row whenever money is owed or received. On the first of the month, enter the rent as a charge. When the tenant pays, add a new row with the amount in the payment column and a note on how they paid, such as bank transfer or check number. Add late fees, utility rebills or repair charges as charges too. The balance column updates automatically: charges increase it and payments reduce it.

Use one ledger file per property, with the tenant and unit on every row. The Summary sheet uses those names to total charges, payments and the current balance for each tenant, so you can see arrears at a glance without scrolling.

Why keep a rent ledger

A clear payment history protects both you and your tenant. It settles disagreements about what was paid and when, supports deposit deductions, and gives your accountant clean numbers at tax time. If a case ever reaches a court or tribunal, a consistent ledger with dates and payment references is far more convincing than scattered bank statements.

Tips for accurate records

Record entries as they happen rather than at the end of the month. Keep payment references, like transfer IDs and check numbers, in the description. Never overwrite old rows; if you make a mistake, add a correcting entry so the history stays intact. Store a backup copy in cloud storage. Before you buy your next property, check the numbers with the rental property calculator.

Frequently asked questions

What should a rent ledger include?

At minimum: the date, the tenant and unit, what was charged (rent, late fees, other charges), what was paid, how it was paid, and the running balance. Keeping every entry in one place makes disputes, deposit returns and tax time much easier.

Does the template calculate balances automatically?

Yes. The Excel file has formulas that keep a running balance for each row and a summary sheet that totals charges, payments and the balance owed per tenant.

Can I use it in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas work the same way. You can also import the CSV version.

How long should I keep rent records?

Many landlords keep rent ledgers and receipts for at least as long as their tax records, often several years. Check the rules where you live and ask your accountant.

Is the template really free?

Yes. There is no sign-up and no watermark. Download it and edit it however you like.