Who actually does this work
Community association finance is run by a rotating cast: a volunteer treasurer with a day job, a management company that produces a monthly packet, and a board that has to approve things it did not prepare. Continuity is thin — the person who understood last year's numbers may have moved out.
The money itself is simple in structure and unforgiving in handling. Owners pay assessments; the association spends on running the community and saves for the roof. Two funds, two purposes, and a legal obligation to keep them apart in fact rather than just in the spreadsheet.
The bank statements are the only source everybody trusts, and they usually arrive as PDFs attached to a monthly packet. Getting them into data is what lets a treasurer answer a question at a meeting instead of promising to look into it.
Operating and reserve are two different worlds
The operating fund pays for the predictable: landscaping, utilities, insurance premiums, management fees, minor repairs, administration. It turns over every month and should be roughly flat across a year if the budget was honest.
The reserve fund pays for the infrequent and expensive: roof replacement, road resurfacing, elevator overhauls, pool equipment, exterior painting. It accumulates for years, is spent in lumps, and exists precisely so that a roof does not become a special assessment nobody can afford.
The guidance on this is consistent and worth following literally: hold them in physically separate bank accounts, not separate line items inside one account, because separate line items are how commingling starts. There is a tax dimension too — reserve money that is not genuinely segregated can be treated as taxable income to the association, which is an expensive way to discover a bookkeeping shortcut.
| Operating fund | Reserve fund | |
|---|---|---|
| Pays for | Landscaping, utilities, insurance, management, small repairs | Roofs, roads, elevators, painting, major systems |
| Rhythm | Every month | Every several years, in lumps |
| Funded by | The assessment's operating portion | The assessment's reserve portion, plus interest |
| Held in | Its own bank account | Its own bank account, ideally interest-bearing |
| Board question | Are we on budget? | Are we funded against the study? |
| Common failure | Overspending on 'urgent' repairs | Borrowing from it and calling it temporary |
The transfer that gets counted twice
Every month, a share of assessments moves from operating to reserve. It appears as an outflow in one account and an inflow in the other, and it is neither an expense nor income — it is the same money changing pockets. Count it as both and the association's reported spending and revenue are simultaneously overstated.
It is astonishingly common, because the two statements are usually looked at separately, sometimes by different people, and often at different times. The board sees a reserve contribution as income to the reserve fund and an expense in the operating fund, and the year's figures stop making sense in a way nobody can quite locate.
Working from both statements as data at the same time is what makes the pair visible: same date, same amount, opposite signs, two accounts. Tag them as transfers once and every downstream report — budget versus actual, annual figures, the treasurer's summary — stops double-counting them.
Assessments arrive as a wall of similar deposits
A 120-unit association receives 120 payments a month that are nearly identical: same amount, same window, different names and references. Some arrive by lockbox in a single batched deposit, some by bank transfer with a reference nobody standardised, some as cheques, some late, some in the wrong amount.
The bank side of that is where reconciliation gets tedious. One lockbox deposit of £24,600 covers forty-one owners; the breakdown is in a separate report; and the association's ledger needs the per-owner detail. Extraction gives you the deposit lines with dates and narratives; the allocation stays with your management system or your spreadsheet.
Where it saves the most time is the exception list. Convert the month, sum the receipts, compare to the expected assessment total, and the difference tells you exactly how much is missing before anybody opens a delinquency report.
Delinquency is a bank question before it is a legal one
Every association has owners who pay late and a few who stop. The consequences — late fees, liens, collection, legal costs — are governed by the association's documents and by state law, and they escalate quickly. Getting the underlying facts right therefore matters more than usual.
The facts are in the bank data: who paid, when, how much, and whether a partial payment landed. An owner marked delinquent because their payment arrived with an unrecognised reference is an owner about to receive a letter that will cost the association goodwill and possibly a legal argument.
Reconcile before you escalate. Filter the period's receipts, match them against the roll, and treat the unmatched remainder as a research list rather than a delinquency list. We do not decide anything about liens, fees or collection — those are questions for the association's counsel and its governing documents.
How this differs from our nonprofit and property-management pages
Bank statement converter for nonprofits deals with charities and grant-funded organisations: restricted versus unrestricted funds, donor conditions, grant reporting and charity regulators. The fund discipline rhymes, but the money comes from donors and funders rather than from the members who own the place.
Bank statement converter for property management is about an agent holding money that belongs to individual owners and tenants, with client accounts and three-way reconciliation. An association's money belongs to the association collectively, and the board is accountable to its own members rather than to a regulator's client-money rules.
This page is the association case: two funds, member assessments, a reserve plan measured in decades, and a board that changes composition faster than the roof wears out. If a management company runs your association, both pages apply — they do the property-management side, you still own the board's oversight.
Budget against actual is the board's only real dashboard
The board approves a budget once a year and then spends twelve months finding out whether it was right. The report that answers that question is budget against actual by category — and it depends entirely on transactions being categorised consistently, which depends on having them as data.
Categories should be few and stable. Landscaping, utilities, insurance, management, repairs, administration, legal, reserve contribution — eight lines a volunteer can read beats forty a bookkeeper prefers. Consistency across years matters more than granularity, because the useful comparison is against last year rather than against theory.
Once the statements are converted, this is a pivot table. Category by month, with a variance column, and a short note against anything more than ten per cent adrift — which is the entire treasurer's report that most boards actually need.
The reserve study is the number the fund is judged against
A reserve study inventories the components the association must eventually replace, estimates their remaining life and cost, and produces a funding plan. Common practice is a fresh study every three to five years, with updates every two years where FHA or agency requirements apply, and an annual review in between.
The board's job is to compare the reserve balance and contributions against that plan. That comparison needs one number the study cannot give you: what actually happened in the reserve account, month by month, including interest earned and any borrowing that was described at the time as temporary.
We do not produce reserve studies, do not model component life and do not tell you whether your funding level is adequate — that is a specialist discipline and, in several states, a regulated one. What we do is turn the reserve account's statements into the actuals the study gets compared against.
Special assessments and the scrutiny that follows
When reserves fall short of a major project, the association levies a special assessment, and nothing in community life generates more scrutiny. Owners who accepted the annual budget without reading it will read every line of this one.
The evidence therefore has to be immaculate: what was collected, when, into which account, and exactly what it was spent on. Keeping special-assessment money identifiable — ideally in its own account, at minimum tagged in every report — is what makes that provable a year later when somebody asks.
Extraction helps by making the trail continuous rather than reconstructed. Convert the account monthly through the project, tag the rows, and the final accounting is a filter rather than a forensic exercise carried out from a shoebox of statements.
Where association books usually go wrong
The failures are consistent across associations of every size, and none of them require bad intent — they are what happens when finance is a volunteer duty handed over every couple of years. Knowing the list is most of the defence.
Each has a cheap check attached, and all of them are easier when the statements are data. None of them require software beyond a spreadsheet and the habit of looking.
| Trap | What it looks like | The check |
|---|---|---|
| Double-counted transfer | Reserve contribution as both income and expense | Pair the two lines; tag as a movement |
| Commingled reserve | One account, two line items in the books | Confirm two separate bank accounts exist |
| Borrowing from reserves | A transfer out described as temporary | Track reserve balance against the plan monthly |
| Missing statement | A month nobody downloaded | Closing balance versus next opening balance |
| Duplicate vendor payment | Same amount to the same vendor twice | Sort by payee and amount across the year |
| Unallocated assessment | Owner marked delinquent though they paid | Match receipts to the roll before escalating |
| Special assessment blur | Project money mixed with operating cash | Separate account, or tagged in every report |
Vendor payments, and the invoices behind them
Most association spending goes to a small number of recurring vendors — landscaping, pool service, insurance, management, utilities — plus a long tail of one-off repairs. A payment line alone tells a board almost nothing; a payment line matched to an invoice tells them everything.
Extracting vendor invoices alongside the statements makes that pairing routine: supplier, date, net, tax, total and line detail as fields, matched to the payment on amount and date. The invoice PDF to Excel route covers the invoice half.
It also catches the thing associations are chronically vulnerable to: paying the same invoice twice. Small volunteer-run finance functions with rotating approvers are exactly the environment duplicates thrive in, and the check is described on duplicate payment detection.
Proving the listing is complete before the board sees it
A treasurer presenting numbers to a board is vouching for them, usually without having built them. The one assurance available without an audit is arithmetic: opening balance plus every transaction must equal the closing balance, for each account and each month.
We run that check on every statement automatically and flag the ones that fail. It is a proof of completeness rather than a confidence score, and it answers the only question a sceptical board member can meaningfully ask about a transaction listing: is anything missing.
There is a second check across months that costs nothing: each month's closing balance must equal the next month's opening balance. That is what catches a missing statement — the single most common gap in an association's records, because somebody was on holiday in August.
The monthly packet, and what to do with it
A managed association receives a packet: statements, a balance sheet, an income statement, a delinquency report, maybe invoices. It is usually a single PDF of thirty to eighty pages, produced by software the board cannot query, and reviewed by people who have twenty minutes.
Converting the statement pages turns the packet from something to skim into something to check. The board's oversight duty is not to re-do the bookkeeping; it is to verify that the reported figures reconcile to the bank and that nothing unusual moved. Data makes that a ten-minute exercise.
Ask the management company for statements as separate files if the packet is unwieldy. A per-account monthly PDF is easier to convert, easier to file and easier to hand to an auditor than page 41 of a bundle.
Audits, reviews and what they will ask for
Many states and many governing documents require an annual audit, review or compilation depending on the association's size and budget. Whichever applies, the requests are predictable: bank statements for the year, reconciliations, the general ledger, minutes approving major expenditures, and support for reserve movements.
The most common source of friction is not error but retrieval — a missing month, a statement nobody downloaded before the account was closed, a reserve transfer with no board minute behind it. A folder per year holding the original statements plus the converted workbook removes most of that in advance.
Bear in mind we delete originals immediately after extraction. The PDFs the auditor asks to see must live in the association's own storage, and retention periods come from state law and your governing documents rather than from us.
Board turnover is the real continuity risk
Treasurers change, management companies change, and the handover is often a shared drive and a conversation. What survives well is a consistent working file: one workbook per year, one sheet per account, the same categories, the same proof recorded each month.
What survives badly is knowledge in somebody's head — why that transfer happened, which vendor the £4,200 was for, what the board decided about the reserve borrowing. Write those notes in the file when they happen, not when they are asked about.
This is the single highest-value habit in association finance, and it costs nothing. It also makes changing management companies far less painful, because the association's records stop being whatever the outgoing company chooses to export.
Self-managed associations, where this matters most
Smaller associations often run without a management company: a treasurer, a spreadsheet, a bank login and goodwill. That works, and it works better with structure — the two accounts, a consistent category list, monthly conversion and the balance check.
The realistic aim is not sophistication but continuity. A self-managed association that can hand the next treasurer a folder with twelve months of statements, a converted workbook and a one-page summary is in better shape than a managed one whose board has never opened the packet.
Where a spreadsheet stops coping — usually past a hundred units or once a major project starts — that is the signal to look at association software rather than to build a bigger spreadsheet. We are the bank-side input either way.
Where this sits next to association software
Association management platforms hold the roll, the assessments, the delinquency workflow, the violation records and the owner portal. That is the right home for all of it, and this is not a replacement for any part of it.
The gap is the bank side of accounts the platform cannot pull: the reserve account at a different bank, the period before the platform was adopted, the account that was closed after a bank merger, the statements the outgoing management company sent as PDFs.
Where the bank offers a genuine feed into your platform, use the feed — it comes from the source. Converters exist for the gaps a feed does not cover, which in association finance is most often history and closed accounts.
The boundary, stated plainly
FlowParse is a document-extraction engine, not association management software and not an accounting system. There is no owner roll, no assessment billing, no delinquency workflow, no violation tracking, no owner portal and no ledger of its own.
It does not produce reserve studies, does not judge whether your reserve funding is adequate, does not decide fund allocations or categorisations, and does not advise on liens, late fees, collection or any other legal question. Those are matters for your reserve specialist, your accountant, your association's counsel and your governing documents — and the rules differ substantially by state.
It is also not an archive: originals are deleted immediately after extraction. The statements an audit or an owner-records request will ask for must live in the association's own storage, and retention obligations remain the association's.
A worked example: 96 units and a roof
A 96-unit condominium association had two accounts, a volunteer treasurer and a management company producing a sixty-page monthly packet. The annual figures had not tied to the bank for two years, and the board had stopped asking why.
The exercise took a weekend. Twenty-four months of both accounts converted, each statement proven against its own balances, one missing month found immediately by the closing-to-opening check, and all rows tagged with eight categories. The reserve transfers were paired and marked as movements rather than as income and expense.
Two findings came out of it. The double-counted transfers explained most of the discrepancy the board had been living with, and a duplicate payment to a landscaping contractor from eighteen months earlier turned up in the process — recovered as a credit. The roof project went ahead with figures the board could actually defend at the members' meeting.
Where to start
Do it once properly and the monthly version takes twenty minutes. The value is not in the workbook — it is that the treasurer can answer a question at the meeting instead of taking it away.
1. Two accounts, confirmed
Check that operating and reserve are genuinely separate bank accounts, not two lines in one.
2. One month, both accounts
Convert the most recent month for each and check the closing balances against the PDFs.
3. Pair the transfer
Find the operating outflow and the reserve inflow, tag both as a movement.
4. Eight categories
Agree a short, stable category list the board can read, and use it every month.
5. Extend backwards
Add the rest of the year, using the closing-to-opening check to find missing statements.
6. One page for the board
Budget against actual by category, reserve balance against the plan, and a note on anything unusual.
Where to go next
For the mechanics see bank statement to Excel, for a year at once see batch processing, and for merging both funds and several months into one workbook see consolidate bank statements.
For proving the listing is complete, bank statement validation. For the vendor side, invoice PDF to Excel and duplicate payment detection, which is a genuine risk in volunteer-run finance.
Adjacent situations: nonprofits for restricted-fund discipline, property management if a managing agent holds the money, and landlords for individually owned rentals.
Give the board numbers it can defend
Convert both funds for the year, prove every month against its own balances, and turn the packet into a page anyone can read.