FREE TEMPLATE

Rent ledger template

Tell us the rent and when it starts. We'll build a year of charges with a running balance — you fill in the payments.

Recorded as a note, not added to the rent balance — a deposit isn't rent.

Your ledger

12 months · $17,400.00

First charge November 1, 2026. Fill in each payment as it arrives; the balance column shows what's still owed.

Google Sheets: File → Import → Upload, then choose the file.

Preview

Rent ledger

Tenant: —Property: —

DateDescriptionChargePaymentBalance
November 1, 2026November 2026 rent$1,450.00$1,450.00
December 1, 2026December 2026 rent$1,450.00$2,900.00
January 1, 2027January 2027 rent$1,450.00$4,350.00
February 1, 2027February 2027 rent$1,450.00$5,800.00
March 1, 2027March 2027 rent$1,450.00$7,250.00
April 1, 2027April 2027 rent$1,450.00$8,700.00
May 1, 2027May 2027 rent$1,450.00$10,150.00
June 1, 2027June 2027 rent$1,450.00$11,600.00
July 1, 2027July 2027 rent$1,450.00$13,050.00
August 1, 2027August 2027 rent$1,450.00$14,500.00
September 1, 2027September 2027 rent$1,450.00$15,950.00
October 1, 2027October 2027 rent$1,450.00$17,400.00

How to use a rent ledger

A rent ledger is one running list per tenant: every charge, every payment, and the balance after each. Charges go in as they come due; payments go in the day they arrive. If the balance column reads $0 after a payment, the tenant is current.

  • One ledger per tenant, not per property — when a tenant moves out, their ledger closes.
  • Record payments on the date received, even if they're late. The gap between the charge date and the payment date is the history you'll want later.
  • Add other charges on their own line — a late fee, a utility bill the lease makes the tenant pay — so the balance always explains itself.
  • Keep the deposit out of it. A security deposit isn't rent and belongs to the tenant until you've accounted for it at move-out.

Why it matters

A ledger is what you hand a judge in an eviction, a lender who asks about rental income, or an accountant at tax time. A pile of bank statements and Venmo screenshots can say the same thing — but it takes an afternoon to prove it.

QUESTIONS

Common questions

What is a rent ledger?

A running record of every rent charge and every payment for one tenant, with the balance after each line. It's the document you'll want if there's ever a dispute, a late-rent notice, or a question from a lender or court.

How do I open the template in Google Sheets?

Download the CSV, then in Google Sheets choose File → Import → Upload and select the file. In Excel, simply open the file.

What's the difference between a rent ledger and a rent receipt?

A receipt confirms one payment. A ledger shows the whole history — every charge, every payment, and the balance — so you can see at a glance whether a tenant is current.