Free Rent Ledger Template

No signup required. Enter monthly rent charges, utility rebills, late fees, and tenant payments with automatic running balances, or download a blank Excel (.xlsx), printable PDF, or CSV template.

Prefer a blank template to fill by hand or in Excel?
Tenant Rent Statement Balance clear
Starting period
Period Status Rent due Other Late fee Amount paid Date paid Method Balance Memo / Ref
Schedule totals
0.00
0.00
0.00
0.00
0.00
Opening balance $0.00
Total billed $0.00
Total collected $0.00
Ending balance due $0.00
Tab memory only (never uploaded)

Recording real-world lease scenarios

How common lease exceptions are recorded so your running balance stays accurate and defensible.

Worked example: partial payment & arrears carryover

$1,850/mo lease, due on the 1st, $75 late fee after 5th
Period Charges Paid Date Balance
Jan 2026 $1,850.00 $1,850.00 Jan 01 $0.00
Feb 2026 $1,895.00 $1,895.00 Feb 02 $0.00
Mar 2026 $1,925.00 $900.00 Mar 09 $1,025.00
Apr 2026 $1,850.00 $1,025.00 Apr 03 $1,850.00

In February, a $45 water rebill raises charges to $1,895. In March, a $900 partial payment plus a $75 late fee leaves $1,025 unpaid. When $1,025 arrives on April 3, prior arrears clear, leaving April's $1,850 rent owed.

Split monthly installments

Add a second row for the same month with $0.00 rent due so each installment date and transfer ID stays separate.

Grace periods & fee caps

Post late fees only after the lease grace window closes, keeping them isolated from base rent for state cap checks.

Utilities & pass-throughs

Log water, trash, parking, or repair bill-backs under Other with an invoice note so base rent never fluctuates.

Prorated move-in months

Overwrite Rent due on the move-in or move-out row with the pro-rata amount while keeping standard months intact.

How to create a rent ledger online (free, no signup)

Rent Ledger Hub works as both a free online rent ledger generator and a downloadable template built for US landlords, property managers, and tenants. There is no account creation, no software to install, and no watermark on any exported file. All calculations and file exports run locally in your browser (desktop, iPhone, or Android), so entered tenant and payment details are never uploaded to or stored on our servers (see our Privacy Policy).

  1. Enter lease details: Add the tenant name, property address and unit, monthly rent, due day, and any opening balance at the top of the table (or click Clear to start from scratch).
  2. Log charges and payments: Record monthly rent due, pass-through items (Other), late fees, actual payment amounts, deposit dates, and payment methods (ACH, Zelle, Venmo, Check, Money Order, Cash, Card, or Portal).
  3. Verify the running balance: Every row calculates automatically using Previous balance + New charges - Payments = New balance and updates the row status (Paid, Partial, Unpaid, or Credit).
  4. Download your statement: Export a watermark-free US Letter PDF via PDF Studio (Classic Ledger, Formal Notice, or Modern Executive layout), a formula-driven Excel (.xlsx) workbook, or a CSV file.

Landlords use this schedule to track monthly rent collections, document overdue balances, and prepare IRS Schedule E totals. Tenants also use it to organize personal rent payment histories for rental applications or mortgage underwriting. Because an online generator formats the figures you enter rather than verifying bank deposits independently, always keep underlying bank statements, cancelled checks, or transfer confirmations for formal disputes.

What a rent ledger template needs to prove

When a rental balance comes under review in small claims court, housing mediation, or a year-end tax audit, summary totals carry very little weight. Reviewers look for a contemporaneous rent ledger template (also called a rental ledger template or rent payment ledger) that pairs every scheduled lease charge with the exact date, method, and dollar amount of each payment received.

Print blank PDF or fill online: enter charges in this simple monthly rent payment ledger to compute carrying balances automatically before exporting a formatted statement, or use the quick download bar above the table to save a blank 12-month Excel (.xlsx) workbook or fillable printable PDF worksheet for handwritten recordkeeping.

Unlike a folder of individual receipts or a bank export filtered by sender name, a complete payment schedule tracks both sides of the lease obligation. If a resident pays $1,200 toward $1,850 rent on the 3rd and sends the remaining $650 on the 18th, the table preserves both payment dates and shows how any contractual late fee entered the balance. For itemized pass-through charges and move-out deposit accounting, see our tenant ledger guide.

Ledger section Primary accounting purpose Common recordkeeping mistake
Billing period & rent due Establishes when the contractual obligation accrued under the lease. Recording rent only when cash arrives, hiding unpaid months.
Other charges & late fees Isolates utilities, pet rent, parking, and late penalties from base rent. Lumping fees into base rent, obscuring statutory fee caps.
Amount paid, date & method Ties each credit to a verifiable bank deposit, check number, or transfer ID. Marking a month simply "Paid" without the date or reference.
Running balance Carries arrears or prepayments forward automatically from period to period. Restarting each month at zero and losing prior shortfalls.

Tracking past due rent and overdue balances

When a resident falls behind on housing charges, landlords and property managers need an exact breakdown of past due rent and total rent owed across billing cycles. Guessing from bank deposits alone breaks down as soon as a partial payment arrives late or covers only part of an unpaid fee.

Using this simple rent payment ledger, any unpaid portion of base rent, utility rebills, or late charges carries automatically into the next month's Balance cell and updates the top status badge (Unpaid, Partial, Paid, or Credit). When a catch-up transfer arrives mid-month, enter it alongside the actual deposit date in Date paid so the overdue rent owed drops immediately without erasing the chronological arrears trail.

Applying payments under lease and state allocation rules

How a partial payment reduces an overdue balance is governed by both your lease agreement and state landlord-tenant law. Many residential leases contain an application-of-funds clause stating that incoming payments apply to oldest unpaid balances or non-rent charges first, leaving any remaining shortfall categorized as unpaid current rent.

Several jurisdictions restrict that practice and require landlords to apply tenant payments to base rent before late fees or utility reimbursements. In states with strict eviction notice rules, a Three-Day or Five-Day Notice to Pay or Quit can be invalidated if the demand includes late fees or utility charges that state law bars from summary possession filings. Keeping base rent, ancillary charges, and late fees in separate columns allows you to calculate a rent-only arrears figure in seconds whenever a formal notice is required.

Handling returned payments, adjustments, and Schedule E totals

Real tenancies rarely follow twelve identical monthly transfers. Three accounting practices keep a rent payment ledger clean when exceptions happen:

  • Log bounced checks and reversals on their own line. If an ACH transfer or check is returned for insufficient funds, leave the original entry intact and add an adjustment row (or note the reversal and bank return fee) so your statement matches your bank activity line for line.
  • Keep refundable security deposits off the rent schedule. Security deposits are held in trust against lease performance, not earned rental income. Including a deposit in the opening balance makes every monthly figure appear as a tenant credit until move-out.
  • Reconcile column totals to IRS Schedule E at year-end. Independent landlords reporting on a cash basis generally match the annual Amount paid column (plus any forfeited deposits applied to unpaid rent at move-out) against bank deposits when preparing Schedule E figures.

If you manage properties primarily in spreadsheets, our Excel rent ledger template details every formula inside the two-tab .xlsx workbook and walks through clean Google Sheets imports. For multi-year tenancies, archive a dated PDF statement when a lease renews and carry the verified closing figure into the next schedule's Opening balance field using consistent unit naming (2026-418-oak-apt-2b-ledger.pdf).

Frequently asked questions

Practical answers on online PDF generation, browser privacy, lease accounting, and tax documentation.

How is a rent ledger different from a rental ledger or a rent receipt?

A rent ledger template and a rental ledger template refer to the same chronological tenancy schedule tracking every monthly charge, fee, and payment against a continuous balance. By contrast, a rent receipt confirms only a single payment on a specific date without showing prior arrears or total rent accrued.

How does a rent ledger support IRS Schedule E tax filing?

Cash-basis landlords report total rent and fee payments actually received during the calendar year on IRS Schedule E. Keeping a monthly payment ledger provides itemized backup connecting individual tenant transfers to your annual gross rents total, and the Summary & Tax Prep tab in our Excel export groups collections by payment method automatically.

How long should landlords retain closed rent ledgers?

The IRS generally recommends retaining records that support income entries for at least three years from the tax filing date. Because lease disputes follow state statutes of limitations on written contracts, many landlords retain closed schedules for four to six years after move-out.

Should multi-unit landlords keep one ledger per property or per tenant?

Maintain a separate schedule for each tenancy and unit rather than combining a multi-unit building into one running balance. Unit-specific schedules prevent a departing resident's unpaid balance from carrying into a new tenant's account after mid-year turnover. Landlords managing multiple properties can export our Excel (.xlsx) workbook and keep one tab per unit.

How should I record a bounced check or failed ACH payment?

Keep the original payment entry if it hit your bank statement, then record the reversal and any contractual returned-payment fee with the bank return date in the memo. That preserves a clear audit trail matching your monthly bank statements.

Does this online rent ledger generator upload or store my data on servers?

No. All balance calculations and PDF, Excel (.xlsx), and CSV exports run locally inside your browser with no account required. Tenant names, property addresses, and payment entries are never uploaded to or stored on our servers. By default, entries stay in tab memory until you export; you can also turn on Save draft locally in the builder footer to keep a recoverable draft in your browser's localStorage on your own device and clear it anytime.

Is it safe to enter tenant details, and what information should I leave out?

Entering tenant names, property addresses, rent amounts, due dates, payment dates, and check or transfer references is standard in a browser-local rent ledger. Never enter Social Security numbers, bank account numbers, routing numbers, or payment card details into an ordinary rent ledger template.

Should I use an online rent ledger generator or an Excel template?

Use an online rent ledger generator when you want a formatted, watermark-free PDF statement quickly with zero setup. Use an Excel (.xlsx) or Google Sheets template when you maintain a multi-month or multi-unit payment history over time and want editable formulas, custom tabs, and year-end Schedule E totals. Rent Ledger Hub gives you both in one workflow.

Can I create and download a rent ledger on an iPhone or Android phone without installing software?

Yes. The builder runs directly in Safari, Chrome, and other mobile browsers on iPhone and Android with no app or software installation required. You can enter monthly charges and payments on your phone and download a PDF, Excel (.xlsx), or CSV file directly to your device.