How to reconcile an HOA bank account, step by step
Reconciling the association’s bank account means proving, once a month, that your books and the bank agree on how much money the HOA has. It is the single most useful thing a treasurer does. It catches missed dues payments, bank fees nobody recorded, checks that never cleared, and mistakes that would otherwise surface at the annual meeting, or in an audit.
This guide walks through a reconciliation from start to finish, with a worked example. It assumes you keep the books in a spreadsheet, accounting software, or a check register. The method is the same in all three.
What you need
- The bank statement for the month, with the ending balance and every transaction.
- Your books for the same account: the register or ledger showing every deposit and payment you recorded.
- Last month’s reconciliation, so you know which items were still outstanding when it ended.
- Payment processor reports, if homeowners pay online. One bank deposit from a processor often bundles many homeowner payments, minus fees.
Reconcile each bank account separately. Most associations have at least an operating account and a reserve account, and each one needs its own reconciliation every month.
Step 1: Start from the statement’s ending balance
Write down the ending balance on the bank statement. This is the bank’s side of the reconciliation. Don’t adjust the statement itself; you’ll account for timing differences in the next steps.
Step 2: Match every transaction
Go through the statement line by line and find each transaction in your books. Check off both sides as you go.
- Deposits: match each one to the dues payments or other income you recorded. If homeowners pay through a processor, match the deposit to the processor’s payout report, which lists the individual payments and the fees taken out.
- Withdrawals and checks: match each one to a payment you recorded, by check number and amount.
When you finish, two lists remain: items on the statement that aren’t in your books, and items in your books that aren’t on the statement.
Step 3: List what the bank hasn’t seen yet
Items in your books but not on the statement are usually timing differences:
- Deposits in transit: money you deposited near the end of the month that the bank posted the next month.
- Outstanding checks: checks you wrote that the payee hasn’t cashed yet.
Carry these forward. Next month, most of them should clear. A check that stays outstanding for months deserves a phone call to the payee.
Now calculate the adjusted bank balance:
Adjusted bank balance = statement ending balance + deposits in transit − outstanding checks
Step 4: Record what only the bank knows about
Items on the statement but not in your books belong in your books. The usual ones:
- Bank fees: record them as an expense.
- Interest earned: record it as income. Reserve accounts often earn interest.
- Returned payments: a homeowner’s check bounced or an ACH payment was reversed. Record the reversal, and put the amount back on that owner’s balance so they’re billed again. Your governing documents may allow a returned-payment fee.
- Automatic payments you forgot to enter, such as a utility or insurance draft.
- Processor fees, if the deposit was smaller than the payments inside it.
After recording these, your book balance is the adjusted book balance.
Step 5: Compare the two balances
The adjusted bank balance and the adjusted book balance must be exactly equal, to the penny. If they are, the account is reconciled.
A worked example
Here is March for a small association’s operating account.
The statement’s ending balance on March 31 is $18,240.00. A $1,150.00 deposit of dues checks made on March 31 isn’t on the statement yet. Two checks haven’t cleared: #1042 to the landscaper for $860.00 and #1045 for insurance for $1,275.00.
| Bank side | Amount |
|---|---|
| Statement ending balance | $18,240.00 |
| Plus: deposit in transit | $1,150.00 |
| Less: check #1042 (landscaping) | −$860.00 |
| Less: check #1045 (insurance) | −$1,275.00 |
| Adjusted bank balance | $17,255.00 |
The books show $17,567.50. The statement also shows three things the books don’t: a $15.00 service fee, $2.50 of interest, and a $300.00 dues payment from one unit that was returned.
| Book side | Amount |
|---|---|
| Balance in the books | $17,567.50 |
| Less: bank service fee | −$15.00 |
| Plus: interest earned | $2.50 |
| Less: returned dues payment | −$300.00 |
| Adjusted book balance | $17,255.00 |
Both sides are $17,255.00, so March is reconciled. The treasurer still has one follow-up: the owner whose payment was returned now owes $300.00 again.
When the balances don’t match
Don’t force it. A difference always has a cause, and finding it is the point of the exercise. Start with the most common ones:
- A transaction entered twice, or not at all. Look for an amount equal to the difference.
- A transaction entered with the wrong sign, such as a payment recorded as a deposit. The difference will be exactly twice the amount.
- Transposed digits. If the difference divides evenly by 9, look for swapped digits. Entering $1,290 instead of $1,920 creates a $630 difference, and 630 ÷ 9 = 70.
- An item from last month’s list that cleared, but that you counted again this month.
- A transaction recorded in the wrong account, such as a reserve transfer posted to operating.
- An error in last month’s reconciliation. If last month’s adjusted balances didn’t truly match, the difference carries forward.
If you still can’t find it, walk the register from the last month that reconciled cleanly and re-add each running balance.
Finish the month properly
- Save the reconciliation with the statement, the list of outstanding items, and the adjustments you recorded.
- Have someone other than the treasurer review it. A second board member signing off each month protects the association, and it protects the treasurer too. Some states require boards to review reconciliations regularly (California, for example, requires the board to review the operating and reserve account reconciliations every month), and many governing documents do as well. Check yours.
- Reconcile every month, soon after the statement arrives. A single month takes minutes. Six months at once takes an afternoon, and errors are much harder to trace.
- Don’t skip the reserve account. It moves less often, but interest, transfers from operating, and large project payments all need to tie out too.
A reconciled account means the numbers you give the board, and the homeowners, are real. It’s what lets you answer “how much money do we have?” with confidence.