Rent ledger

Primary references on this page:

Each line should carry a transaction date, effective date when different, description, charge, payment or credit, and the resulting running balance. Keep the property, unit, tenancy, and source record attached so a payment cannot drift onto the wrong resident account.

Use separate lines for rent, recurring charges, approved fees, concessions, payments, returns, refunds, and corrections. Netting several events into one unexplained number may produce the right ending balance while destroying the history needed to understand it.

Suppose the ledger opens with a $1,500 monthly rent charge. A $1,000 ACH payment posts, leaving $500. The ACH is then returned, so a separate $1,000 reversal restores the balance to $1,500. After the landlord approves a documented $100 repair credit, another line reduces the balance to $1,400.

The correct ledger shows all four events rather than replacing the first payment with “failed” or editing the original rent charge. That sequence explains why the balance changed and prevents the returned payment or approved credit from being counted twice.

At a fixed cutoff date, compare charges to the executed lease and approved changes, then compare payments and returns to the payment processor and bank activity. Investigate unapplied receipts, duplicate charges, old credits, and balances that changed without a source record.

When a correction is necessary, post a dated adjusting line with an explanation instead of rewriting history. Then rerun the rent roll or receivables report so the property-level summary agrees with the corrected tenant account.

Record charges, payments, credits, reversals, refunds, write-offs, and adjustments as separate dated events. The running balance reproduces under the allocation policy.

Example: $1,200 rent plus a $50 fee less a $1,000 payment applied to rent leaves $200 rent and $50 fee. A vague $250 loses composition; reallocation needs reason and authority.

Bank settlement proves movement, not correct tenancy or allocation. A charge does not prove legal enforceability.

The ledger should preserve each event and its effective date rather than showing only a current balance. The example below uses a stated allocation policy and is illustrative; lease terms, local law, and approved payment-allocation rules may require another result.

A payment can appear as initiated, authorized, pending, settled, returned, reversed, or refunded at the processor or bank. The rent ledger separately records how a verified receipt affects tenant charges. If the Jun 14 payment is pending, showing it as settled can understate the receivable; if it later reverses, the ledger needs a linked reversal rather than deletion of the original receipt.

A concession changes what is charged or credited under an approved agreement. A write-off changes accounting treatment under authority but does not erase the underlying history or decide legal enforceability. An adjustment should identify the error, source, approver, and prior communication affected.

The rent ledger answers which tenancy charges, payments, credits, and allocations make up a resident balance. The general ledger answers how transactions affect financial accounts, entities, properties, periods, liabilities, income, and cash. One tenant payment can reduce the rent-ledger balance, clear rent receivable in the general ledger, and later appear inside a net processor deposit at the bank.

Aptoria runs the routine work behind these terms — rent, books, and screening — inside limits you set. Starts at $19/mo for up to 5 units.