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.