TENANT LEDGER
LED-2026-1106
Tenant & Property
Unit:
Lease / reference ID:
Period: to
Balance Summary
Opening balance: $0.00Total charges: $0.00Total payments: $0.00Current balance: $0.00 (Settled)
Transactions
No entries added.
Tenant Ledger Template & Payment Tracker
Use this free tenant ledger template to record rent charges and payments and generate a clear running balance — what was charged, what was paid, when, how, and what remains, calculated automatically as you go. A straightforward rent ledger for anyone tracking payment history without separate accounting software.
Ledger details
STEP 1 OF 3
Tenant & Property Information
What Is a Tenant Ledger?
A tenant ledger tracks charges (like rent, late fees, and utilities) and payments for a tenant over time, so a landlord or property manager can see what was charged, what was paid, and the resulting balance at a glance.
How the Running Balance Works
Charges increase the balance and payments reduce it. Starting from an optional opening balance, each entry updates a running balance calculated directly from the entries in the ledger — nothing is estimated or assumed.
Manual Record-Keeping, Not Payment Processing
This tool does not connect to a bank, payment gateway, or financial account, and it does not collect or process payments. It is a manual record and calculation tool for tracking rental payment history.
Worked Example: Tracking Rent Payments in a Ledger
A tenant starts the month with a $0 opening balance. On the 1st, a $1,600 rent charge is added, bringing the balance to $1,600. On the 3rd, the tenant pays $1,600 by bank transfer, bringing the balance back to $0. The next month, a $75 late fee is added when rent arrives a few days late — the ledger shows exactly when each charge and payment happened and what, if anything, is still owed.
Common Mistakes When Keeping a Rent Ledger
Logging payments in a different order than they happened, which throws off the running balance; forgetting to record fees like late charges or utility pass-throughs as their own line items; mixing up which property or unit an entry belongs to when managing several tenants; and not reconciling the ledger balance against your bank records periodically.
Frequently Asked Questions
Add an opening balance if one applies, then log charges and payments as they happen — a $1,600 rent charge on the 1st, a $1,600 payment by bank transfer on the 3rd. The running balance updates automatically with each entry you add.
Many landlords do both. A rent receipt is a standalone document handed to the tenant for one specific payment; the ledger is your own running record of everything over time. Issuing a receipt per payment and keeping the ledger behind the scenes covers both bases.
A negative current balance means the tenant has paid more than they were charged so far, shown here as a credit. It's a straightforward calculation from the entries you've logged — this tool doesn't make any determination about what's actually owed beyond what you enter.
Yes. Add it as a separate charge — for example, a $75 late fee a few days after rent was due — rather than folding it into the rent amount, so your records show exactly what each charge was for.
No. This is a manual record-keeping and calculation tool only — it doesn't connect to a bank, payment gateway, or financial account, and it never collects or processes any actual payments. You log what already happened; it keeps the running total straight for you.
Yes. Set the ledger's start and end dates to cover whatever period you need, and print or download the full entry history and running balance as a single PDF — useful for an annual summary or a final move-out reconciliation.
Related Tools
Work Order Generator
Generate printable work orders for property management operations.
Maintenance Request Generator
Create clear maintenance requests to review, print, or download.
Rent Receipt Generator
Create a professional rent receipt to review, print, or download.
Lease Renewal Tracker
Track upcoming lease renewal dates, renewal status, and tenant follow-ups across your properties.