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).
- 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).
- 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, orPortal). - Verify the running balance: Every row calculates automatically using
Previous balance + New charges - Payments = New balanceand updates the row status (Paid,Partial,Unpaid, orCredit). - 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).