A tenant ledger template that keeps the running balance.

Record one commercial tenant's charges (base rent, CAM estimates, CAM true-ups, late fees) and every payment, full or partial. The balance after each line is worked out for you. Print a statement for the tenant, download a CSV, or take the spreadsheet template to Excel or Google Sheets.

  • Free, no signup
  • Saved only in this browser; nothing is sent to TenantPoint
  • Printable statement, CSV, and a spreadsheet template

Spreadsheet template · CSV

Rather keep it in Excel or Google Sheets? The template has the running-balance formula built in, a filled-in sample tenant, and 40 blank rows for yours.

Loading the ledger…

What goes on a commercial tenant ledger.

Five columns, and one line for everything that changes what the tenant owes.

Every line has a date, a description, an amount in either charges or payments and credits, and the balance after it. A balance above zero is what the tenant owes; below zero, the tenant has a credit that carries into the next month.

Lines on a commercial tenant ledger
LineColumnWhen to post it
Base rentChargesOn the due date in the lease, usually the 1st
CAM, tax, or insurance estimateChargesWith the rent each month, at the current estimate
CAM true-up, tenant owes moreChargesWhen the year's reconciliation goes to the tenant
CAM true-up, tenant paid too muchPayments and creditsSame date, as a credit
Late feeChargesOnly when the lease allows it and the grace period has passed
Returned paymentChargesThe day the bank reverses it, putting the amount back
PaymentPayments and creditsThe day it arrives, with the check number or ACH reference
Credit or concessionPayments and creditsWhen agreed in writing, with what it is for

A worked example: a partial payment, a late fee, and a CAM credit.

The fictional Boardwalk Books, Suite 114: $4,850 base rent and a $945 CAM estimate each month.

  1. July: $5,795 billed on the 1st, paid in full on the 3rd. Balance $0.00.
  2. August: $5,795 billed, $3,000 paid on the 8th. The partial payment leaves $2,795.00, and a $250 late fee under the lease takes the balance to $3,045.00.
  3. September: $5,795 billed, so $8,840.00 is owed. A $6,000 payment leaves $2,840.00, and the 2025 CAM reconciliation credits $418.60 for estimates that ran above the tenant’s actual share: $2,421.40.
  4. October: $5,795 billed and $5,795 paid on the 4th. The month is covered, but the balance is still $2,421.40.

That last line is why a ledger matters. October’s payment matched October’s rent exactly, so a glance at the bank account says the tenant is current. The ledger shows $2,421.40 carried from August and September, which is the number to put on the statement and, if it isn’t paid, on a late rent notice.

Keeping a ledger that holds up.

The ledger is evidence. A few habits keep it that way.

  • Post charges when they are billed. Don’t wait until a tenant pays to record what they owed.
  • Correct with a new line. Once a statement has gone to the tenant, fix a wrong charge with a credit that explains it rather than changing or deleting the original line, so the statement they hold still ties out.
  • Record payments as received. Use the deposit date and reference, and post a returned payment as its own line when the bank reverses it.
  • Charge only what the lease allows. Late fees, interest, and admin fees need a lease section behind them; note it in the description.
  • Reconcile monthly. Payments on the ledger should match deposits in the bank, and the ledger balances should add up to what your books say tenants owe.

In TenantPoint, each tenant’s ledger builds itself: base rent and CAM from the lease each month, late fees and CAM true-ups once you confirm them, and payments as they’re recorded, with the balance after every line. Download it as a PDF or CSV, or email it to the tenant. See rent tracking in TenantPoint.

Free template

Get the rent roll template and tenant file checklists

The rent roll spreadsheet, the tenant information checklist, and a COI tracker for the insurance certificates every tenant owes you.

  • Commercial rent roll templateSpreadsheet template
  • Commercial Tenant Information ChecklistPrintable checklist
  • Tenant insurance certificate (COI) trackerSpreadsheet template

Free. We email you the links; no mailing list unless you tick the box. Privacy policy

How to use the Tenant ledger template

  1. Set up the tenant

    Name and premises, plus any balance carried over from before this ledger starts.

  2. Add each charge and payment

    Date, type, and amount. Payments and credits reduce the balance; everything else adds to it.

  3. Print or download

    Print the statement for the tenant, download a CSV for your records, or take the spreadsheet template.

What this template covers, and what it doesn’t.

Included

Charges, payments, and credits

Base rent, CAM estimates, CAM true-ups both ways, late fees, returned payments, and other charges, with each payment marked paid in full or partial.

Not included

Lease terms and accounting

It doesn't read a lease, apply rent steps or late-fee rules, or post to your books. Every line is one you enter or copy forward a month.

Best use

One ledger per tenant

Keep a ledger for each tenant, a rent roll for the whole property, and send a statement from the ledger each month.

How this is calculated.

Steps

  1. Lines are kept in date order; on the same date, charges come before payments and credits.
  2. Balance after a line = the balance before it + the charge − the payment or credit. The first line starts from the opening balance.
  3. Above zero the tenant owes; below zero the tenant has a credit, which carries forward.
  4. Totals: charges added up, payments and credits added up; closing balance = opening balance + charges − payments and credits. Amounts are added in whole cents.
  5. A statement can start from a date: earlier lines are carried into its opening balance, and the closing balance is the same.
  6. The spreadsheet template does the same in a formula: opening balance + every charge so far − every payment and credit so far.

What it leaves out

  • Lease terms: rent steps, CAM caps, and late-fee rules are not applied for you.
  • Payment application: a payment reduces the whole balance and isn't matched to one charge.
  • Interest on late balances.
  • Accounting: this is a record of one tenant's account, not your property's books.

Method checked . General information for commercial property owners, not legal, tax, or accounting advice. The signed lease controls.

Tenant ledger questions, answered.

What is a tenant ledger?

A tenant ledger is the running record of one tenant's account: every charge billed and every payment or credit received, in date order, with the balance after each line. It answers the questions a rent roll can't, such as which month a tenant fell behind, whether a late fee was billed, and how a partial payment was recorded. It is also what you hand an attorney, a buyer's due-diligence team, or the tenant when a balance is disputed.

What should a commercial tenant ledger include?

A date, a description, the charge or the payment, and the balance after each line. Commercial ledgers carry more kinds of charges than residential ones: base rent, monthly CAM, tax, or insurance estimates, the year-end CAM true-up (a charge or a credit), late fees, returned-payment fees, and one-off charges such as after-hours HVAC. Record payments on the date received with the check number or ACH reference, and keep credits as their own lines rather than shrinking a charge.

How do I record a partial payment?

Enter the amount actually received, on the date it arrived, as a payment. Leave the charges as billed: the ledger shows what the partial payment left owing, and that amount carries into the next month. Many commercial leases say that accepting a partial payment doesn't waive the rest of the balance, so it helps to note any written agreement about the shortfall in the description. This template applies payments to the whole balance; if your lease says how payments must be applied, follow the lease.

How do I record a CAM true-up on the ledger?

After the year's CAM reconciliation, post one line for the difference between the tenant's actual share and the CAM estimates they paid during the year. If the estimates came in low, it is a charge (CAM true-up, charge); if they paid too much, it is a credit (CAM true-up, credit) that reduces the balance. Name the year in the description, and keep the reconciliation statement that shows the figures.

Work out a true-up with the CAM reconciliation calculator
What is the difference between a tenant ledger and a rent roll?

A rent roll is a snapshot of the whole property: one row per suite with the tenant, square footage, lease dates, and current rent. A tenant ledger is the history of one tenant's account: what was billed, what was paid, and what is still owed. A lender or buyer usually reads the rent roll first and then asks for ledgers to check that tenants actually pay what the rent roll says.

Get the rent roll template
How often should I send a tenant statement?

Monthly works for most small commercial properties, sent a few days before rent is due so the tenant sees the full balance, including any late fee or credit, before paying. Send one whenever a tenant asks or disputes a charge, and before a late rent notice, so the notice and the statement show the same balance.

Write a late rent notice
Can I use this tenant ledger template in Excel or Google Sheets?

Yes. Download the template for a CSV file that opens in Excel, Google Sheets, or Numbers. Its Balance column is a formula: the opening balance plus every charge so far, less every payment and credit so far. A filled-in sample sits above a blank table with 40 rows. To add rows, insert them above the table's last row, so the totals still include them, and copy the Balance formula into them. Save it as a workbook or Google Sheet to keep your formatting.

Is a tenant ledger the same as accounts receivable?

It is the detail behind it. Each tenant ledger shows what that tenant owes, and the balances due on all of them added together should match the accounts receivable in your books for the property. Your general ledger, the property's full accounting record, holds the income and expense side; reconciling the two each month catches payments posted to the wrong tenant or never recorded.

Is my ledger saved?

Your lines are saved only in this browser's local storage so you can come back to them, and nothing you type is sent to TenantPoint. Clear saved data at any time with the link under the ledger. To keep a ledger permanently, download it as a CSV or print the statement as a PDF.

General information for commercial property owners, not legal, tax, or accounting advice. The signed lease controls.

Cite or link to this tool.

Free to use and to reference in a guide, newsletter, client email or lease review. Click a box to select it, then copy.

Citation

TenantPoint. Tenant ledger template [Online tool]. https://tenantpoint.co/tools/tenant-ledger-template

HTML link

<a href="https://tenantpoint.co/tools/tenant-ledger-template">Tenant ledger template</a> by TenantPoint

When the spreadsheet stops being enough

A ledger for every tenant, kept from the lease.

TenantPoint keeps each tenant's ledger from the lease and the payments recorded against it, with late fees and CAM true-ups added once you confirm them. Download it as a PDF or CSV, or email it to the tenant. Start a 21-day trial; no credit card required.