Bank reconciliation best practices

Reconciling your bank accounts is the single most important financial habit in property management. It is the monthly check that proves the money you’ve recorded in TenantLedger actually matches what the bank says you have — catching missed deposits, duplicate entries, bank fees, typos, and even fraud before they snowball. This article covers how to keep reconciliation fast, clean, and never let it pile up to a painful year-end scramble.

The core idea is simple: reconcile every account, every month, to a $0.00 difference. Everything below is about making that easy and trustworthy.

Reconcile every account, every month

Recommendation: Reconcile each active bank account once per statement period, as soon as the statement arrives.

Why it matters: Errors are cheap to fix when they’re a few weeks old and expensive when they’re a year old. A monthly cadence means you’re only ever matching 20–40 transactions against fresh memory, not hundreds against a faded one. It also means your reports, owner statements, and tax numbers are built on books you’ve already verified.

In TenantLedger:

Open Banking in the left sidebar and click Reconcile.
Choose the Account, enter the Statement Ending Date and the Ending Balance from your bank statement, then Save.
On the worksheet, check off every deposit and payment that appears on the statement (the items that cleared the bank).
Watch the Difference at the top drop toward 0.00 as you check items. When it hits zero, save.

See Reconcile a bank account for the full walkthrough.

Don’t reconcile only the operating account. Trust accounts, security-deposit accounts, and savings accounts all need the same monthly treatment. A security-deposit account holds money you’re legally accountable to return (a liability, not your income), so an un-reconciled deposit account is exactly where shortfalls hide.

Batch deposits to match the bank statement

Recommendation: Group payments into deposit batches that mirror the actual lump sums you take to the bank.

Why it matters: This is the highest-leverage thing you can do to make reconciliation effortless. If you walk five rent checks into the bank as one deposit, the bank statement shows one line for the total. If you recorded those five payments individually in TenantLedger without batching, your books show five lines that don’t match the one bank line — and you’ll fight that mismatch every month. Batch them, and one checkbox clears the whole deposit.

In TenantLedger:

When you record a tenant payment, owner contribution, or miscellaneous income item, it sits as undeposited funds until you batch it.
Go to Banking → + Deposit, choose the bank, set the deposit date, and check the items that went in together. The running Total should equal the single amount on your deposit slip.
See Create a deposit batch.

What the bank shows	What your books should show
One deposit line: $4,500 (5 rent checks)	One deposit batch: $4,500 (5 payments grouped)
One deposit line: $1,200 (2 checks)	One deposit batch: $1,200 (2 payments grouped)

Tip: Make your batch date and total match the deposit slip exactly. If the bank combined two trips into one credit, combine the matching payments into one batch.

Record statement-only items before you reconcile

Recommendation: Enter bank interest, service charges, NSF/returned-item fees, and any other statement-only items before you start checking off transactions.

Why it matters: These items never originate in TenantLedger — they appear out of nowhere on the statement. If they aren’t recorded first, your difference will never reach zero and you’ll waste time hunting for a phantom mismatch that’s really just a $12 service fee.

In TenantLedger: Record them as miscellaneous transactions against the bank account first, then reconcile. They’ll be available to check off on the worksheet like any other item.

Drive the difference to zero — and investigate when it won’t go

Recommendation: Treat a non-zero Difference as a signal to investigate, never as something to “force” or save around.

Why it matters: The whole value of reconciliation is the zero. A balanced reconciliation with the wrong items checked is worse than no reconciliation, because it gives false confidence. The difference is your built-in error detector — respect it.

When the difference won’t reach zero, walk this checklist:

Deposits in transit. A deposit you recorded that hasn’t posted at the bank yet. Leave it unchecked — it’s legitimately outstanding and will clear next month.
Outstanding checks. A bill payment you recorded that the vendor hasn’t cashed. Leave it unchecked.
Missing statement-only item. A bank fee or interest you haven’t entered yet. Record it, then continue.
Typo in the ending balance. Re-read the statement’s ending balance and date against what you entered.
Duplicate entry. The same payment or deposit recorded twice. One of them shouldn’t be there.
Wrong account. A payment deposited to the wrong bank account in TenantLedger.
Unbatched deposits. Individual payments that should have been grouped into one batch to match a single bank line.

Outstanding items are normal — leaving them unchecked is correct. A deposit in transit or an uncashed check should stay unchecked. They carry forward and show up again next month, which is exactly how reconciliation tracks the timing gap between your books and the bank.

Keep a clean audit trail — fix forward, don’t paper over

Recommendation: Correct mistakes by editing the underlying record, not by fudging the statement balance or checking the wrong items to “make it work.”

Why it matters: Reconciliation is your audit trail. Every shortcut you take to force a zero is a lie your future self (or your accountant, or an owner) will have to untangle.

If you cleared the wrong item, use Edit Reconcile, fix the checkboxes, and save.
If you need to back out a single deposit or payment — for example because it was locked from deletion while reconciled — open the reconciliation, choose Edit Reconcile, uncheck the item, and Save. That detaches it (there is no button literally named “Unreconcile”). See Undo or delete a reconciliation.
Only delete an entire reconciliation when the whole period was done wrong. Remember that the next reconciliation’s Beginning Balance comes from the prior one — so if you delete a period, re-do it.

Never let it pile up to year-end

Recommendation: Build reconciliation into a fixed monthly close routine and finish it within a week or two of the statement date.

Why it matters: Reconciling twelve months at once isn’t twelve times harder — it’s far worse, because errors compound and you’ve lost the context to explain them. A clean monthly trail also means year-end and tax prep are a download, not an investigation.

Monthly reconciliation routine

Record all income. Make sure every tenant payment, owner contribution, and miscellaneous deposit for the period is entered.
Batch deposits. Group payments so each TenantLedger deposit matches one line on the statement. See Create a deposit batch.
Record all bill payments. Confirm checks and electronic payments are entered.
Enter statement-only items. Add bank fees, interest, and returned-item fees.
Reconcile each account. Match to the statement, drive the difference to 0.00, and save. See Reconcile a bank account.
Review outstanding items. Sanity-check the uncleared list — old, never-clearing checks may need follow-up.
Glance at the dashboard and a report. Reconciled books make your income and cash-flow numbers trustworthy.

Year-end

Reconcile all bank accounts through December 31 before running year-end reports.
If you’ve kept the monthly cadence, this is just one more month — not a twelve-month rescue.

Common mistakes to avoid

Don’t skip a month. “I’ll catch up later” turns a 20-minute task into a multi-day reconstruction.
Don’t reconcile only your main account. Deposit, trust, and savings accounts need it too.
Don’t record individual payments without batching them. Unbatched deposits are the #1 cause of mismatches against a bank statement’s lump-sum lines.
Don’t force the difference to zero. A wrong zero hides a real error. Find the cause instead.
Don’t check off items that haven’t actually cleared. Deposits in transit and uncashed checks stay unchecked on purpose.
Don’t forget bank fees and interest. Record statement-only items first or your difference will never balance.
Don’t delete a reconciliation to fix one item. Use Edit Reconcile and uncheck the single item instead.
Don’t ignore stale outstanding checks. A check that’s been uncleared for months may be lost — investigate rather than carrying it forever.