HOA Bank Reconciliation: A Treasurer's Monthly Guide

TL;DR An HOA bank reconciliation proves that the association's records agree with the bank, account by account, every month. For each account (usually at least an operating account and a reserve account), start with the bank statement's ending balance, add deposits in transit, subtract outstanding checks, and compare the result with the balance in the association's books. They should match to the cent. Then check that dues deposits agree with the owner ledger, that every payment has an approved invoice behind it, and that transfers between operating and reserve accounts appear on both sides. Give the board a one-page summary with the reconciliation, and keep the statements and workpapers for the association's records.

Disclaimer: This article is general information about bookkeeping practice for volunteer treasurers. It is not legal, tax or accounting advice. Requirements for homeowners and condominium associations vary by state or province, by the association's governing documents, and by any management agreement. Follow your governing documents and get advice from a qualified accountant or attorney where needed.

Being an HOA treasurer is usually a volunteer job, often taken on by whoever on the board seemed least likely to say no. Even when a management company handles day-to-day bookkeeping, the treasurer is generally expected to understand the numbers and to spot if something is wrong. The single most useful habit for that is a monthly bank reconciliation.

A reconciliation answers a simple question: does the money the bank says we have agree with what our books say we have? If it does, the board can trust the financial reports. If it doesn't, you want to know now, not at the annual meeting or during a review.

This guide walks through a practical monthly routine: what you need, the reconciliation itself, the extra checks that matter for associations, a worked example, and how to report to the board.

Why reconciliation matters more for associations

Associations handle other people's money. Owners pay dues on the understanding that the board will look after them, and boards generally owe duties to the association that include reasonable oversight of its finances. A few features of HOAs make reconciliation especially important:

• Several accounts. Most associations have at least an operating account for day-to-day costs and a reserve account for long-term repairs and replacement. Some have more.
• Many small deposits. Dues come in from dozens or hundreds of owners, sometimes by check, sometimes electronically, sometimes through a lockbox.
• Volunteers come and go. Board members change. A clear monthly record makes handovers far easier.
• Separation of duties is hard. In a small association, the same person may approve, pay and record transactions. A monthly reconciliation reviewed by another board member is one of the few practical controls available.
• Reserves must be protected. Money set aside for a roof or a repaving project shouldn't quietly drift into paying for landscaping.

What you need each month

For each bank account:

• The bank statement for the month, as a PDF.
• The association's general ledger or register for that account for the same period. If a management company keeps the books, this is usually part of their monthly financial package.
• Last month's reconciliation, so you know which items were outstanding.
• The owner ledger or dues receipts report for the month, if you're checking dues deposits.
• Invoices and approvals for payments made.

It's much easier to work with the statement in a spreadsheet than on paper. Convert the PDF so every transaction is a row with date, description, amount and balance. SheetStatement does this and checks that the opening balance plus activity equals the closing balance before export. The free plan includes 3 pages a month, which covers a typical small association's statements; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

The reconciliation, step by step

Do this separately for each bank account. Never combine operating and reserve accounts into one reconciliation.

Step 1: start with the bank's ending balance

Take the ending balance from the bank statement for the last day of the month. This is the bank's side.

Step 2: list deposits in transit

Deposits in transit are amounts recorded in the association's books in this month that the bank hadn't yet credited by the statement date. A common example is a batch of dues checks deposited on the last business day of the month. Add them to the bank balance.

Step 3: list outstanding checks

Outstanding checks are checks the association has written and recorded but that haven't yet cleared the bank. Subtract them from the bank balance. Electronic payments recorded in the books but not yet processed by the bank count here too.

For more on both, see our guide to outstanding checks and deposits in transit.

Step 4: calculate the adjusted bank balance

Adjusted bank balance = Bank ending balance + Deposits in transit - Outstanding checks

Step 5: compare with the book balance

Take the balance for this bank account from the association's ledger as of the same date. The adjusted bank balance and the book balance should be identical.

Step 6: if they don't match, find out why

Common causes:

• Bank fees or interest not yet recorded in the books. Record them.
• A returned check (NSF) from an owner that the bank reversed but the books haven't. Record the reversal and update the owner's account.
• A transaction recorded at the wrong amount, such as a transposition error where 1,250 was entered as 1,520.
• A transaction posted to the wrong account, such as a reserve contribution recorded in the operating account.
• A missing transaction, in either the books or the bank.

The size of the difference gives clues. If it's divisible by 9, a transposition is likely. If it equals one transaction, look for that amount. If it's twice one transaction, look for a sign error. Our guide to finding bank reconciliation discrepancies has a fuller checklist.

An Excel layout for the reconciliation

A simple one-sheet layout per account works well:

The figures are illustrative.

Underneath, list each deposit in transit and each outstanding check with date, payee or payer, check number and amount. The totals feed lines B and C.

To identify outstanding items quickly, match the bank statement against the ledger in Excel. With the bank data in a table called Bank and the ledger in a table called Books, flag ledger items with no match on the bank statement:

=IF(COUNTIFS(Bank[Amount], [@Amount], Bank[Date], ">=" & [@Date]-5) = 0, "Outstanding", "")

Our bank reconciliation template for Excel has a complete version you can adapt, and reconciling a bank statement in Excel explains the matching approach in detail.

Checks that matter for associations

A reconciliation that balances is necessary, but for an HOA it's not the whole story. These extra checks take a few minutes and catch the problems that matter most.

Dues deposits against the owner ledger

Total the dues deposits on the bank statement for the month and compare with the dues receipts recorded in the owner ledger. They should agree, allowing for timing differences such as a lockbox deposit that posts a day later. If they don't, payments may have been applied to the wrong owner, or not applied at all, which leads to owners being chased for dues they've paid.

Every payment has an invoice and approval

Scan the payments on the statement. Each should have an invoice and, depending on your association's rules, an approval. Pay attention to:

• Payees you don't recognize.
• Round-number payments without a clear purpose.
• Payments to board members or their relatives, which may need disclosure and approval under your governing documents.
• Duplicate payments of the same invoice.

Operating-reserve transfers

Transfers between operating and reserve accounts should appear on both statements, for the same amount, close in date. Check that each scheduled reserve contribution actually happened. If the budget calls for a monthly transfer to reserves and it didn't happen, the board should know.

Also check the other direction. Withdrawals from reserves should match board-approved projects. Using reserves for operating expenses may be restricted by your governing documents or local law, so any reserve withdrawal without a clear approved purpose is worth raising.

Returned checks and fees

Returned owner checks usually come with a bank fee. Make sure both the reversal and the fee are recorded, and that the owner's account reflects the returned payment and any charge your governing documents allow.

Interest on reserves

Reserve accounts often earn interest. Make sure it's recorded in the reserve fund, not swept into operating income, unless your board has decided otherwise.

A worked example

A 60-unit association has an operating account and a reserve account. A management company keeps the books and sends the monthly package; the treasurer reviews it.

Operating account, May:

1. Bank ending balance: 21,480.15.
2. Deposits in transit: one batch of dues checks totalling 1,350.00, deposited on 31 May and credited by the bank on 1 June.
3. Outstanding checks: the landscaper (#2041, 1,600.00) and the insurance broker (#2043, 410.00). Check #2042 cleared.
4. Adjusted bank balance: 21,480.15 + 1,350.00 - 2,010.00 = 20,820.15.
5. Book balance: 20,832.15.
6. Difference: -12.00.

The treasurer looks at the statement and finds a monthly service fee of 12.00 that the management company hadn't recorded. She asks them to record it, and the difference clears.

Dues check: Electronic dues on the statement total 8,940.00 plus 1,350.00 in transit. The owner ledger shows 10,290.00 received in May. That agrees.

Reserve account, May:

1. Bank ending balance: 142,615.40, including a transfer in of 3,500.00 from operating and interest of 118.22.
2. No outstanding items.
3. Book balance: 142,615.40. Difference: 0.00.
4. Transfer check: The operating statement shows the 3,500.00 transfer out on the same day. The budget calls for 3,500.00 a month. Good.
5. Interest: Recorded in the reserve fund. Good.

Her one-page summary to the board shows both reconciliations, the fee correction, the dues check and the reserve contribution.

Reporting to the board

Board members don't need every line, but they do need confidence that someone checked. A simple monthly treasurer's report might include:

• For each account: bank ending balance, adjusted bank balance, book balance and difference (which should be zero).
• Reconciling items: a short list of outstanding checks and deposits in transit, with anything older than 60 or 90 days highlighted.
• Exceptions: anything that needed correcting, such as an unrecorded fee, a misposted payment or a returned check.
• Reserve activity: contributions made, withdrawals and what they were for, interest.
• Dues: total received, and whether it agreed to the owner ledger.

Attach the reconciliation sheets and keep the statements. A second board member, perhaps the president, can initial or sign off each month's reconciliation; many associations find that simple step a useful control.

Stale items and unclaimed checks

An outstanding check that hasn't cleared after several months needs attention. Contact the payee: the check may have been lost, or the vendor may not realize it's outstanding. If a check remains uncashed for a long time, there may be rules in your jurisdiction about unclaimed property. Ask your accountant how to handle it rather than simply voiding it.

Deposits in transit should clear within a day or two. One that's still outstanding the following month is a red flag. The deposit may never have reached the bank.

When a management company keeps the books

Many associations use a management company. The reconciliation is often part of the monthly package they provide. As treasurer, you can still:

• Compare their reconciliation with the actual bank statement. Make sure the bank ending balance on their reconciliation matches the statement you received directly from the bank, if you have access.
• Look at the outstanding items list. Old items deserve questions.
• Spot-check payments against invoices.
• Check reserve transfers against the budget.

If you can, get read-only access to the association's bank accounts or have statements sent directly to a board member. Reviewing statements that come from the bank, not only from the management company, is a sensible control.

Handing over to the next treasurer

Board terms end, and the handover is where associations most often lose track of their finances. A good monthly routine makes it painless. Before you step down, put together:

• A list of every bank account, with the bank, the account's purpose (operating, reserve, special assessment) and who the authorized signers are.
• The last twelve reconciliations, each with its outstanding items list.
• The current budget and reserve contribution schedule.
• Contacts at the bank and the management company.
• A short note on anything unusual or unresolved: an old outstanding check, an owner in a payment plan, a pending project funded from reserves.

Bank signers usually need to be updated when officers change, which can take some time, so start that process early. The new treasurer should be able to pick up the next month's reconciliation without guessing.

Year-end and reviews

Twelve clean monthly reconciliations make year-end much easier, whether the association has an audit, a review, a compilation or just a tax return prepared. The accountant will typically want the December (or fiscal year-end) reconciliation, the bank statements and the outstanding items list. Our guide to preparing bank statements for an audit covers what's commonly requested. A month-end close checklist can also be adapted into a monthly treasurer's routine.

Similar work for other volunteer treasurers

The same routine works for other volunteer-run organizations: churches, clubs, PTAs and small charities. See our guide to church bank reconciliation for a version with designated funds.

Get your statements ready

Upload the month's statement PDFs to SheetStatement, check the rows and the balance check, and download Excel or CSV for your reconciliation. The free plan includes 3 pages a month, enough for many small associations.

FAQ

How often should an HOA reconcile its bank accounts?

Monthly is the common practice, and it's when problems are easiest to fix. Check your governing documents and any applicable rules for specific requirements.

Should operating and reserve accounts be reconciled together?

No. Reconcile each bank account separately, and check that transfers between them appear on both sides.

What if the reconciliation doesn't balance?

Look for unrecorded bank fees or interest, returned checks, transposition errors, transactions posted to the wrong account, or missing items. The size of the difference often points to the cause.

Who should review the treasurer's reconciliation?

Many associations have a second board member review and sign off each month's reconciliation. It's a practical control where separation of duties is difficult.

What should I do about old outstanding checks?

Contact the payee. If a check remains uncashed for a long time, ask your accountant about unclaimed property rules before voiding it.

Our management company does the reconciliation. Do I still need to check it?

It's sensible to review it. Compare it with the bank statement, look at old outstanding items, spot-check payments and confirm reserve transfers.

Is this legal or accounting advice?

No. It's general information. Follow your governing documents and get advice from a qualified accountant or attorney.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.