Skip to main content

Free landlord tool

Rent Ledger Template

Record what a tenant was charged and what they paid, see the balance after every line, and download the ledger as a CSV file or print it.

Your details

What the tenant owed before the first line. Enter a credit as a negative number.

Charges and payments

DateDescriptionChargePaymentBalance
$1,500.00
$0.00
$1,500.00
$100.00
$1,600.00
$0.00

Preview

Rent Ledger

Tenant: Jordan Rivera

Property: 412 Maple Street, Unit 2B, Springfield

DateDescriptionChargePaymentBalance
Opening balance$0.00
September 1, 2026Rent$1,500.00$1,500.00
September 3, 2026Payment received$1,500.00$0.00
October 1, 2026Rent$1,500.00$1,500.00
October 6, 2026Payment received$1,400.00$100.00
November 1, 2026Rent$1,500.00$1,600.00
November 2, 2026Payment received$1,600.00$0.00
Total charged
$4,500.00
Total paid
$4,500.00
Balance owed
$0.00

Your browser's print dialog can save the document as a PDF.

Everything is calculated in your browser. Nothing you type is sent anywhere or saved.

What a rent ledger is for

A rent ledger is a running record of everything a tenant is charged and everything they pay, in date order, with the balance after each line. It answers the question every tenant dispute comes down to: how much was owed, and when.

Charges are rent and anything else the lease allows you to bill, such as utilities you pass through. Payments are what the tenant actually paid. A positive balance is money owed to you; a negative one is a credit the tenant has with you.

How to keep one

Add a charge on the day each rent falls due and a payment on the day the money arrives, not the day you notice it. Record partial payments as they come, so the ledger always shows the true balance.

Keep one ledger per tenant and lease, and start a new one when a lease ends. If a tenancy ends in a dispute or a court case, a clean, dated ledger is the evidence you will be asked for first.

Worked example

Rent is $1,500 a month. September is charged on the 1st and paid in full on the 3rd, leaving nothing owed. October is charged on the 1st and the tenant pays $1,400 on the 6th, leaving $100 owed.

November's rent takes the balance to $1,600, and a payment of $1,600 on November 2 brings it back to zero. The ledger shows $4,500 charged and $4,500 paid across the three months.

This tool keeps the ledger in your browser while the page is open. Download or print it before you leave; nothing is saved.

Frequently asked questions

What is a tenant ledger?

A dated record of every charge to a tenant and every payment from them, with a running balance. It is the standard way to show what a tenant owes at any point in the tenancy.

Can I open the ledger in Excel or Google Sheets?

Yes. Download it as CSV and open the file in any spreadsheet. Amounts are written as plain numbers so the spreadsheet can total them.

How do I record a credit or an overpayment?

Enter the payment as received. If it is more than what was owed, the balance goes negative, which shows a credit in the tenant's favor that later charges will use up.

Is my ledger saved?

No. Everything stays in your browser and disappears when you close the page. Download the CSV to keep working on it later.

Bring your spreadsheets into one place

Porchyard imports bank-statement CSVs with column mapping and duplicate detection, and you categorize each transaction to its property. Try it free for 30 days.