How to Create a Rent Ledger

Build a rent ledger that shows charges, payments, balances, and methods by period—with a worked example you can copy for one unit or many.

By RentalNoodle Editorial Team · Updated 2026-09-13 · Published 2026-09-13

A rent ledger is a chronological list of amounts charged and amounts received for a tenancy, always tied to a period (usually a calendar month). If you can answer “what does this tenant owe for September, and what proves it?” in under a minute, you have a working ledger.

Fee types you may record and notice requirements before collection vary by state and local jurisdiction. This guide is educational — not legal advice. Confirm requirements with local counsel or your housing authority before relying on any deadline, notice form, or deposit rule.

Columns that earn their keep

Opening the ledger for a new or existing tenant

1. Enter tenant name, unit, rent amount, due date, and grace period at the top.
2. Record security deposit separately (or clearly labeled)—do not hide it inside monthly rent.
3. If the tenant already lives there, set an opening balance: unpaid prior rent or $0 if current.
4. Create the first period charge on or before the due date.
5. Post payments as they arrive; never overwrite charges.

Existing tenant backfill — Unit B, rent $1,275, due the 1st. Today is Sep 13. August is paid. September unpaid. Opening: Charge Aug $1,275 / Payment Aug $1,275 / Charge Sep $1,275 / Balance $1,275. You are honest from day one of digitizing.

Worked ledger: three months, messy middle

Copy this pattern. Figures are illustrative.

Note August kept one charge and two payments. September shows a deliberately assessed late fee—not an automatic ACH add-on. If ACH had been Processing on Sep 8, the balance would remain until Paid.

Rules that prevent ledger lies

• One running balance per tenancy (or per unit if single-tenant).
• Period labels on every line.
• Payments never delete history—failures get reversing clarity.
• Prepaid rent labeled with the future period.
• Deposits and last month’s rent called out as their own categories.

Multi-unit: one ledger per tenancy

Do not mash four units into one undivided tab without a unit column. Either separate sheets/records per tenancy or a master file filtered by unit. Month-end, sum Paid charges by property for income totals.

ACH lines vs manual lines

When online ACH is enabled (Stripe Connect complete), settled ACH payments still belong on the ledger with method ACH and the processor reference. Manual checks sit beside them. Card columns are unnecessary—cards are not supported for RentalNoodle rent collection. RentalNoodle adds no ACH platform fee; processor fees may appear on payouts and should be tracked as expenses if your CPA directs, not as a silent reduction of tenant rent.

Tax rules change and depend on your situation. RentalNoodle organizes income and expenses you record and can export Schedule E preparation summaries — it does not file taxes or give tax advice. Confirm treatment with a CPA or enrolled agent.

Month-end close for the ledger

Exports that feed Schedule E preparation work only if period income is trustworthy. RentalNoodle organizes recorded income and expenses and can export Schedule E preparation summaries—it does not file taxes.

Spreadsheet vs software

Spreadsheets work until shared editing breaks formulas. Software ledgers help when payments, statuses, and properties multiply. Either way, the accounting ideas stay identical: charge, pay, balance, period, proof.

If migrating from paper, enter the current year in full if you can; at minimum enter YTD charges/payments and an opening balance sworn to your bank deposits.

Common ledger mistakes

• Recording deposits as rent income.
• Netting processor fees into a lower rent charge.
• Using memo fields instead of period columns.
• Resetting balance to zero without payments (hiding unpaid rent).
• Duplicate charges after a tenant message “did you post September?”

Printable starter header

Tenant: ________ Unit: ________ Rent: $______ Due: ___ Grace: ___ days Deposit held: $______ Lease end: ________ Opening balance on ____: $______

Fill the header once, then never invent rent terms mid-year. The ledger’s job is to mirror the lease and the bank—not to renegotiate them quietly in a cell.

Credits, waivers, and adjustments

When you waive a late fee or credit a day of rent for an outage, post a credit line with a reason—do not edit the original charge downward in silence. Silent edits destroy auditability. A visible credit (“habitability credit 2 days @ $50 = $100”) explains itself a year later.

Owner draws are not rent

If you transfer money from the property account to your personal account, that is an owner draw—not a rent payment and not an expense. Keep draws off the tenant rent ledger entirely. Mixing them is a classic way to think a tenant underpaid when you simply withdrew funds.

• Tenant ledger = charges and receipts for that tenancy.
• Property cash ledger (optional) = bank movements including draws and CapEx.
• Tax packet = income and expenses categorized for Schedule E prep with your CPA.

Once a quarter, pick one tenant at random and rebuild their balance from raw bank evidence. If you cannot, fix the process before tax season.

Sample year-to-date rollup

At any time you should be able to sum charges and payments for the calendar year without re-typing bank statements. A simple rollup table per property keeps insurance, lending, and tax prep conversations short.

If YTD collected and your bank deposits disagree by more than processor fees and known timing lags, stop and reconcile before adding more automation.

Educational content for independent landlords. RentalNoodle is property management software — not a law firm, CPA firm, or government agency. Rules vary by state and locality. Confirm legal and tax questions with qualified professionals.