Skip to content

Rent ledger

Track rent charges, payments and cent-accurate running balances across a tenancy, then export a clean PDF, CSV or Excel ledger.

Tenancy details
Rent entries
Entry 1 Balance: USD 0.00
Total charged USD 0.00
Total paid USD 0.00
Closing balance USD 0.00

How to use Rent ledger

  1. Enter the tenancy header. Add the landlord name, tenant name, property address, currency, and any opening balance owed.
  2. Log chronological rent entries. Record each rent charge and tenant payment with the rental period, payment method, and reference.
  3. Export the final statement. Select Create PDF for an A4 or US Letter ledger, or choose Download CSV or Download Excel (.xlsx).

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

How are running rent balances and partial payments calculated?

Running balances update automatically in integer cents by adding each rent charge to the prior balance and subtracting each payment received. Storing amounts as whole cents prevents binary floating-point drift across multi-year leases. Positive totals represent rent arrears owed, whereas negative totals indicate advance credit.

Accurate rent tracking matters for both cash-flow reconciliation and tax reporting. Under IRS Publication 527 on Residential Rental Property, cash-method landlords must report rental income in the tax year it is actually or constructively received, including advance rent, while keeping refundable security deposits separate unless retained.

Integer-cent arithmetic prevents spreadsheet rounding drift

Standard spreadsheet formulas can introduce penny discrepancies when summing dozens of decimal rows across a rental payment schedule. By multiplying each charge and payment by 100 before summing, this landlord rent tracker guarantees exact cent-level totals across up to 500 entries. That precision keeps closing arrears aligned with bank deposit records.

Interpreting positive arrears versus negative credit balances

When a tenant makes a partial payment, the balance drops by the exact amount received and carries the unpaid remainder into the next period. If a tenant pays two months ahead, the closing balance turns negative to show credit on account. You can also issue numbered rent payment receipts for any paid row directly from the entry list without retyping tenancy details.

Structuring tenancy details, currencies, and payment rows

Clean lease records start with consistent header fields: Landlord, Tenant, Property address, and optional Unit or lease reference and Landlord contact details. Selecting the matching Currency updates locale formatting across the live summary strip and generated exports.

Under GOV.UK Private Renting Rights and Responsibilities, landlords collecting weekly residential rent are legally required to provide a written rent book or payment record. Even for monthly tenancies, logging the Payment method and Payment reference creates a clear audit trail for bank reconciliation.

Ledger field Purpose Supported values or limit
Opening balance owed Carry forward prior arrears or credit Positive, zero, or negative decimal
Date Chronological transaction date ISO date picker (YYYY-MM-DD)
Rental period Billing month or week covered Up to 100 characters
Charged Rent billed for the period Non-negative amount in cents
Paid Payment received from tenant Non-negative amount in cents
Payment method Settlement channel used 6 methods plus Not specified

Recording up to 500 chronological charge and payment entries

Click Add entry to append new dates as rent falls due or payments arrive. Each row displays a live Balance badge so you can verify arrears after every transaction. Removing an obsolete line with Delete entry recalculates all subsequent balances immediately.

Multi-currency support and payment method tracking

The currency selector covers 11 major currencies: USD, GBP, CAD, AUD, NZD, EUR, CHF, SEK, DKK, NOK, and PLN. When arrears remain unpaid past the lease grace period, you can escalate overdue rent balances with formal payment reminder letters to document collection steps.

Exporting rent arrears statements to PDF, CSV, and Excel

Once all rows are entered, choose Create PDF to build a printable A4 or US Letter statement showing Total charged, Total paid, and Closing balance. You can also add an optional Footer note or enable Include landlord signature line under Paper and output options.

For bookkeeping software or year-end tax preparation, Download CSV and Download Excel (.xlsx) export the full chronological table with formula-injection protection. According to IRS Recordkeeping Retention Guidelines, taxpayers should generally retain income and expense documentation for at least 3 years from the filing date or 2 years from tax payment.

Tip: Use the Load example button first to inspect how opening balances, partial payments, and bank transfer references appear in the PDF preview before entering your own lease data.

Landlords managing Scandinavian or European properties alongside local rentals can also create Danish invoices in DKK with 25% Moms when billing commercial tenants or management fees. Keeping PDF statements and spreadsheet exports together simplifies annual Schedule E or self-assessment preparation.

Every exported CSV and Excel file uses formula-injection neutralization so tenant-supplied text starting with =, +, or - cannot execute as a spreadsheet macro when opened by bookkeepers. Reviewing the closing balance alongside bank deposits at month-end catches missed standing orders early and keeps property accounting files consistent across multi-unit portfolios.

Local browser privacy and landlord recordkeeping compliance

Every calculation, PDF layout, CSV file, and Excel workbook is generated inside your browser tab using 0 bytes of server uploads. Tenant names, street addresses, and payment references never leave your device, which protects sensitive personal data during routine property management.

Zero-upload PDF and spreadsheet generation in your tab

Document rendering runs inside a dedicated local Web Worker after you enter your figures. Because no account sign-in or cloud database is involved, you can open the workspace, generate a statement for a tenant or property manager, and clear the form immediately with Clear.

Informational recordkeeping scope versus certified tax advice

This tool formats operational rent ledgers and payment summaries for convenience and does not provide certified tax, accounting, or legal advice. Statutory rent-book rules, late-fee caps, and tax retention periods vary by state and country, so consult a qualified accountant or local housing authority for compliance guidance. Cross-border Nordic landlords can also pair local records with a Swedish invoice generator for Nordic property billing when issuing formal commercial invoices.

Questions

How are partial payments and arrears calculated on a rent ledger?

Each row computes the running balance in integer cents by taking the opening balance, adding rent charged, and subtracting payments received. Because every figure is rounded to whole cents before summing, multi-month ledgers avoid floating-point rounding drift.

What does a negative running balance mean on a tenant ledger?

A negative closing balance indicates that total tenant payments exceed total rent charged plus any opening balance. This typically occurs when a tenant pays rent in advance or overpays an installment.

Does a rent ledger hold legal evidentiary weight in court or tax audits?

A chronological rent ledger serves as a supporting business record when paired with bank statements and signed leases, though courts and tax authorities weigh admissibility under local rules. Consult a qualified attorney or accountant for formal dispute or audit requirements.

Can I export a rent ledger to Excel or CSV for my accountant?

Yes. Select Download CSV or Download Excel (.xlsx) below the entry list to save every date, rental period, charge, payment, method, reference, and running balance into a spreadsheet.

How do I issue a receipt from a rent ledger row?

Select Make receipt on any row that has a positive payment amount, or switch the workspace toggle from Full rent ledger to Rent receipt. Tenancy details carry over automatically without retyping.

Are tenant names and payment records kept private in this tool?

Yes. Every calculation, PDF layout, CSV file, and Excel workbook is generated locally inside your browser tab with zero server uploads, so tenant names and payment histories never leave your device.

Updated