It is the fourth business day of the month. Your registrar exports a spreadsheet from the registration system. The finance clerk exports another one from the bank. Somebody starts highlighting rows in yellow. Two hours later the two numbers are $312.40 apart, and the difference turns out to be one refunded soccer registration and a chargeback nobody told anyone about.
This happens every month in departments that own perfectly good software. The registration system knows what was sold. The general ledger knows what was deposited. Neither one knows about the other.
The registration system and the ledger count different things
Registration systems are built around people and programs. Accounting systems are built around funds and accounts. A single Saturday of camp signups can produce revenue that belongs to three different program codes, a refundable deposit, a scholarship offset, and a non-resident surcharge that your council directed to a separate pool. The bank sees one settlement. Your ledger needs six entries.
Manual reconciliation closes that gap with staff hours. It also introduces the one thing an auditor will find, which is a human deciding where money goes without a rule written down anywhere.
Public money raises the bar
Private clubs reconcile for management. You reconcile for accountability. Program revenue is public revenue, subject to fund accounting, an annual audit, and public records law. Texas State Library's local retention schedule keeps recreation program records for two years and liability waivers for three years from the end of the activity, longer if there was an accident. Retention rules vary by state, so check yours, but the pattern holds. The transaction record and the document behind it both have to survive.
Card acceptance adds another layer. Washington's MRSC guidance distinguishes a surcharge from a service fee and caps credit surcharges at 4 percent, with debit not surchargeable at all. Whatever your state allows, those fees have to land somewhere in the ledger, and "netted out of the deposit" is not an answer your auditor will love.
A CSV export is not an integration, whatever the proposal says
Vendors call both of these integration. They are not the same thing.
- A CSV export is a file someone downloads, reformats, and uploads. It works until the person who knows the format takes a vacation.
- A real integration posts entries automatically on a schedule, maps each program to a GL account you control, and fails loudly when something does not match.
Put these in the requirements, not the demo:
- Program-level and fund-level GL account mapping that your finance staff configures, not the vendor.
- A daily settlement record that ties gross revenue, processing fees, refunds, and chargebacks to a single bank deposit.
- Refunds, credits, and voids as their own journal entries with the original transaction referenced.
- An audit trail showing who changed a fee, when, and what it was before.
- An open API, so the connection survives your next accounting system.
Ask for pricing the way Rock Island's 2025 RFP did, with subscription, implementation, and data migration itemized separately. Integration work usually hides in the third line.
No software can automate a posting rule nobody wrote down
Write down how a single camp registration should hit your ledger today, start to finish. If nobody can produce that in one page, no software will fix month-end, because the rule you would automate does not exist yet. For departments on QuickBooks, RecreationHQ includes a QuickBooks integration on Professional and above.
Want the current cost of your manual close in hours and fees? Start with our free cost-recovery audit.
Find your leaks
See what your organization could recover.
A 20-minute audit, your numbers, no obligation.
Get my cost-recovery audit →Or get one practical playbook like this by email, every week.