Start with the period and agreed charge
Write the property or unit, tenant identifier, rental period, due date and charge from the signed lease or a later documented agreement. Record a security deposit, utility reimbursement, fee or credit separately; do not fold those into rent merely to make a balance look tidy. A ledger is a record of events, not a legal determination that someone is late or owes a penalty.
Keep a reference to the governing document and to any correction. The IRS explains why rental income and expenses need supporting records for US tax reporting; this article is a general organizing method, not a tax rule for every country. If a payment could apply to more than one month, confirm and record its allocation instead of guessing.
Work through two partial transfers
Imagine October rent of $900. A $500 transfer appears in the account on October 3 with bank reference A31; another $250 arrives on October 8 with reference A42. Record both as received, keep the dates and references, and compute $900 − $500 − $250 = $150. The balance is an arithmetic ledger amount for this illustrative period. It does not by itself establish a legal default, interest, eviction notice or the right to apply a deposit.
| Date | Entry | Amount | Proof or allocation | Running balance |
|---|---|---|---|---|
| Oct 1 | Agreed October rent | +$900 | Lease term | $900 |
| Oct 3 | Received transfer | −$500 | Bank A31 → October | $400 |
| Oct 8 | Received transfer | −$250 | Bank A42 → October | $150 |
Do not overwrite the first payment when the second arrives. An adjustment should be a dated, explained entry so the earlier record remains understandable. Reconcile the ledger against actual bank deposits before sending a statement or using a figure in a report.
Reconcile before you communicate a balance
Compare every entry with its bank, cash receipt or payment-service confirmation. Check that the amount, currency, date and period match. If a transfer is pending, label it pending rather than received. If it is reversed, record the reversal as a new event. Keep private tenant details out of shared screenshots and public worksheets.
If you send a balance to a tenant, explain the period and payments included so they can spot a misallocation. Local laws and lease terms govern receipts, notices, deposits and disputes; seek local professional guidance for those questions. A useful ledger makes a disagreement easier to inspect, not automatically resolved.
When a small-landlord app helps
LeaseCue’s current US App Store listing describes a local rent ledger with paid, unpaid, overdue and partial states, tenant notes, maintenance requests and renewal dates. It also describes premium renewal reminders and PDF landlord reports. It has no account requirement and is aimed at small landlords rather than a full property-management workflow. Check current in-app terms before relying on a paid feature.
Start with the free CSV if one period is all you need. Use the app when multiple properties, partial receipts and follow-up tasks become hard to keep consistent. The app cannot verify a bank deposit or replace a lease, accountant or local legal advice.
If the method fits your task, LeaseCue can keep the steps together on an iPhone. Check current features and plans before downloading.
See LeaseCue for iOSDownload the free worksheet
Use the CSV in Numbers, Excel or a spreadsheet editor. The three rows use invented amounts and references, not a tenant record. Balances are fixed examples, not spreadsheet formulas. Replace it with your own observations. The CSV is separate from the app and no email is required.
Questions answered
Should I mark the month paid after one partial payment?
No. Record the amount actually received and retain the remaining arithmetic balance until further payments or documented adjustments are reconciled.
Can I count a pending transfer as received?
Keep it pending until the payment source confirms it, then record the received date and reference.
Does a ledger decide late fees or legal notice?
No. Lease terms and local law control those questions. The worksheet is for accurate records, not legal conclusions.
Continue with LeaseCue on iOS
Use the App Store listing to check compatibility, privacy information and current plan terms. A free download may offer paid features.
Download LeaseCue for iOSSources and product details
- IRS: rental income and recordkeepingUS-specific explanation of keeping supporting rental records.
- LeaseCue on the App StoreCurrent US App Store product description; checked October 9, 2026.
Editorial method: primary guidance, a current Apple listing, an original worked example and an independent critique. No search ranking, install or outcome result is claimed.