Every association account has to be reconciled every month, and the bank side almost always arrives as a PDF. BankXLSX turns the operating account, the reserve account, and every certificate of deposit statement into Excel or CSV with date, description, check number, amount, and running balance in their own columns, so the reconciliation becomes a lookup instead of a retyping job. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
An HOA bank reconciliation compares the association bank statement to the association general ledger for the same period and proves the two agree once outstanding checks and deposits in transit are accounted for. It is done separately for the operating account and each reserve account, because those funds cannot be commingled. Boards and managers run it monthly, and the reconciled balance is the figure that has to match the cash line on the balance sheet in the board financial package.
The arithmetic is simple. What burns the days is getting the bank side into a form you can sort, and doing it again for every account and every association in the portfolio.
A single association may run an operating account, a reserve account, one or more certificates of deposit, and a lockbox account. Each one produces its own PDF statement that has to be reconciled on its own.
A community association manager handling 20 associations is closing 40 to 60 bank accounts a month. At ten minutes of retyping per statement, that is an entire work week gone before any actual review starts.
The bank shows one lump deposit for the day. The ledger shows 40 individual homeowner payments. Matching a batch total back to its component receipts is the step that stalls most reconciliations.
A transfer from operating to reserve appears as a withdrawal on one statement and a deposit on the other. Reconciled separately without care, it inflates both income and expense.
A director who asks why a vendor check cleared for a different amount than the invoice deserves an answer in a minute, not after somebody scrolls twelve pages of PDF.
When an association changes management companies or the annual review starts, somebody has to reconstruct a year or more of activity from archived PDF statements, often for several accounts at once.
BankXLSX converts association statements into structured, sortable rows so the reconciliation, the board package, and the audit request all draw on the same clean data.
Dates parse as dates, amounts as signed numbers, and check numbers as their own field, so a lookup against the check register works the moment the file opens.
Every row keeps the printed running balance, so the converted sheet foots to the statement. That is the control proving the bank column came through complete.
Convert both accounts in the same pass and the output columns are identical, which makes spotting a reserve transfer on both sides straightforward.
Mailed and archived association statements are often image only. OCR tuned for statement layouts reads them, which matters during a management transition.
Upload every association, every account, and every month at once. Consistent output means the sheets stack for a portfolio level review.
256-bit encryption in transit, deletion on your schedule, and no reselling or sharing of uploaded data.
No software to install and no credit card to start.
Drag in the operating, reserve, and CD statements for the month. Add several associations or several months at once when you are catching up or preparing for a review.
Tip: Keep one file per account per month so each reconciliation stands on its own.
Check that the running balance on the last converted row equals the closing balance printed on the statement. That single check proves nothing was dropped.
Tip: Opening balance plus deposits minus disbursements should equal the closing balance.
Take the XLSX or CSV into your reconciliation workbook or management software, list outstanding checks and deposits in transit, and tie the adjusted balance to the ledger cash account.
Tip: A lookup on check number clears the vendor payments in one pass.
Anyone answering to a board for association money reconciles these accounts every single month.
Close operating and reserve accounts across a whole portfolio of associations on the same monthly calendar.
Self-managed associations where a volunteer treasurer reconciles the accounts and presents the financials at the board meeting.
Firms preparing association reviews, audits, and tax returns that need the year of bank activity as data rather than PDFs.
Back office teams producing dozens of board packages a month against a hard meeting deadline.
Monthly, without exception, and the reconciliation should be completed within about thirty days of receiving each statement. Several states put the cadence in statute. California Civil Code Section 5500 requires the board to review, on a monthly basis, a current reconciliation of the operating accounts, a current reconciliation of the reserve accounts, actual revenues and expenses against budget, the latest account statements prepared by the financial institutions holding the operating and reserve accounts, an income and expense statement for both, and the check register, monthly general ledger, and delinquent assessment receivable reports. Other states set their own review and reporting requirements through the condominium or nonprofit corporation act, and the governing documents can be stricter than the statute. Check the statute in your state and your own CC&Rs, since these are state level rules.
The monthly financial package is a small set of documents that only works if the bank side is reconciled first. Each one answers a different question.
| Report | What it shows | What the board checks |
|---|---|---|
| Bank reconciliation | Statement balance adjusted for outstanding checks and deposits in transit | That the reconciled figure equals the cash line on the balance sheet |
| Balance sheet | Operating cash, reserve cash, receivables, and fund balances | That reserve cash is separate and has not been borrowed against |
| Income and expense vs budget | Actual revenue and spend against the approved budget line by line | Which categories are running over and by how much |
| Delinquency report | Unpaid assessments by unit and how far past due they are | Whether collection policy is being followed consistently |
| Check register and general ledger | Every disbursement in the period with payee and amount | That each check has an approved invoice behind it |
Work one account at a time, using the statement closing date as the cut-off for everything.
Steps two through six are your management software or workbook doing its job. Step one is the part that stalls, and it is what BankXLSX removes. The mechanics of matching once both sides are data are covered on the bank reconciliation page, and the running balance extraction is what proves your converted bank column is complete.
Reserve funds are collected for the replacement of common area components: roofs, private roads, elevators, pool resurfacing. Operating funds pay this month's landscaping and insurance. Standard practice, and law in a number of states, is to hold them in separate accounts and never commingle them. Reconciling them separately is how the board proves the separation held. Two habits protect it. First, record every operating-to-reserve transfer as a transfer on both sides, never as income on the receiving side, or the reserve fund looks like it is earning revenue it did not earn. Second, watch for a reserve account funding an operating expense. If a vendor check cleared the reserve account, the board needs the minutes showing it was a reserve component and the reserve study supporting it.
Most associations bank assessments through a lockbox, which means the bank shows one deposit per processing day while the ledger shows every homeowner payment inside it. To reconcile, sort the converted bank rows by date, then match each bank deposit total against the sum of that day's receipts. When a batch is off by one payment, sorting the receipts by amount usually finds it immediately, because the difference equals a single unit's assessment. Returned payments are the other common break. A homeowner check that bounces is credited on one date and reversed on another, often in the following month, so both entries have to land in the ledger for the receivable to be correct.
Two events force a large reconstruction: an association changing management companies, and the annual audit or review. In both cases somebody needs a full year or more of bank activity for every account, and what exists is a folder of PDF statements. Converting the whole set in one batch produces a consistent workbook per account that an auditor can tie to the ledger, and it makes the opening balance handoff verifiable instead of asserted. The same batch approach is described on the bulk statement processing page. If you are also rebuilding books that fell behind, the catch-up bookkeeping converter covers the sequence, and grouping the year of spend by vendor type is quickest with the transaction categorization tool.
BankXLSX prepares the bank side. It does not maintain the assessment receivable ledger, it does not produce the board financial package, and it is not association management software or a substitute for advice on your state statute. What it removes is the transcription step: instead of reading a PDF and typing, you get an accurate, source-traceable spreadsheet of association activity in a couple of minutes, for every account and every association in the portfolio. Property managers running rentals rather than associations will find the account structure discussed on the property manager converter page, nonprofit boards facing a similar fund accounting split should read the nonprofit converter page, and the general bank statement converter reads statements from more than 90 US banks, so an association banking at a national bank and a local credit union still gets one consistent output.
It is a monthly comparison of the association bank statement to the association general ledger, adjusted for outstanding checks and deposits in transit, that proves the two agree. It is done separately for the operating account and each reserve account. The reconciled balance must equal the cash figure on the balance sheet in the board financial package.
Monthly, and typically within thirty days of receiving each statement. Some states require it by statute: California Civil Code Section 5500 makes the board review a current reconciliation of both the operating and reserve accounts every month. Governing documents can be stricter, so check your CC&Rs and your state association statute.
At minimum a bank reconciliation for each account, a balance sheet, an income and expense statement compared to budget, a delinquency report of unpaid assessments, and the check register and general ledger. California Civil Code Section 5500 lists effectively this set and adds the latest statements from the financial institutions holding the accounts.
They should not be. Reserve funds are collected for future replacement of common area components and are tracked separately from operating funds, with separate accounts and separate reconciliations. Several states restrict commingling and restrict borrowing from reserves without board action and disclosure. Reconciling each account on its own is how the separation is proven.
In a professionally managed association the management company accounting department prepares it and the board reviews it. In a self-managed association the treasurer usually prepares it. Either way the board carries the fiduciary duty to review the reconciliation each month, which is why it appears in the monthly financial package.
The usual causes are a bank fee or interest posted by the bank but never entered, a returned assessment payment recorded once instead of twice, a reserve transfer counted as income on the receiving side, a lockbox batch that does not match the day's receipts, or a check still outstanding from a prior month. Sorting the converted bank rows by amount finds most of them quickly.
Yes. Upload the operating, reserve, or CD statement PDF and BankXLSX returns every transaction as a row with date, description, check number, amount, and running balance in Excel or CSV. Scanned and mailed statements are read with OCR, and you can batch multiple accounts, months, and associations in one upload.
No. It converts association bank statements into accurate Excel or CSV so the bank side of the reconciliation is data instead of a document. Maintaining the assessment ledger, producing board financials, and meeting your state statute stay with your management software, your accountant, and your board.
Rental and owner account statement workflow.
Match bank activity to your ledger.
Fund accounting and board reporting.
Convert a whole portfolio in one pass.
Group association spend by vendor type.
From the same family of tools
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
