Bank reconciliation

Primary references on this page:

Reconcile the bank statement, processor activity, and property ledger for the same account and cutoff. Add deposits in transit, subtract outstanding payments, resolve bank-only items, and independently prove ledger cash.

Example: the statement ends at $18,420. A $1,200 deposit settles next day and a $75 check is outstanding, so adjusted bank cash is $19,545. Ledger cash of $19,495 leaves a $50 fee, posting, duplicate, cutoff, or error to resolve rather than plug.

Separate timing, error, and unknown items. For multi-property cash, reconcile the bank first and prove property subledgers sum to the control balance. Processor batches need gross payments, fees, refunds, and net settlement.

Preserving the existing three-way method, consider a statement ending balance of $42,000. Add a supported $3,200 deposit in transit and subtract a $1,150 outstanding vendor payment to reach adjusted bank cash of $44,050. The ledger begins at $44,100 before two bank-only items: a $75 fee and $25 of interest. After posting both, adjusted ledger cash is also $44,050. The reconciliation closes because the same account, entity, currency, and cutoff agree after identified timing items and supported entries.

The formula does not authorize stale items. The $3,200 deposit needs a processor or deposit record, expected settlement date, and subsequent bank evidence. The $1,150 payment needs a valid payee, approval, and clearing follow-up. If either item remains unresolved beyond the stated policy, move it to an exception review; do not keep rolling it merely because it makes the equation balance.

“Settled” is a state asserted by the processor, not automatic proof that the bank posted the net deposit by the reconciliation cutoff. First compare the processor batch date, expected arrival, bank account, gross payments, fees, refunds, reserves, and net settlement. If the batch is supported and still within its expected clearing window, carry it as a named deposit in transit or processor-clearing item. If the expected date passed, the amount differs, or the destination account is uncertain, classify it as an investigation exception rather than inventing a clearing date.

A clearing account can show the sequence without prematurely asserting cash: gross resident receipts enter the payment subledger; fees, refunds, and reversals explain the batch; the net amount sits in processor clearing; the bank deposit clears that balance. The tenant ledger, processor activity, general ledger, and bank each reconcile to their own scope. Another accounting architecture may be valid, but it must still expose gross-to-net differences and preserve the event trail.

A transfer between bank accounts needs both sides, the same amount, entity, and effective date, plus any timing difference. A transfer between properties or legal entities also needs authority and a due-to/due-from or other adopted accounting treatment; matching bank withdrawals and deposits do not prove ownership. In a shared operating account, complete the total-bank reconciliation first, then prove that property and entity cash subledgers sum to the reconciled control balance.

Close evidence includes the statement, book balance, reconciling-item register, processor batch detail, adjusting entries, subsequent-clearance review, preparer, reviewer, and version. Investigate returned payments, bank fees, interest, duplicate settlements, and old outstanding checks by source. A zero difference is necessary but insufficient: offsetting errors can still produce zero, and a three-way reconciliation does not prove lease validity, owner entitlement, or compliance with deposit law.

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.