Business · Reconciliation
TrueBalance Coming soon
Cash receipts reconciliation across EMR systems and bank statements. Built for groups running money through several entities at once, where the daily posting report and the bank deposit never quite agree and someone has to find out why.
Not released yet. TrueBalance is the engine behind our reconciliation work and is being packaged into a product. It isn't publicly available yet and we haven't committed to a launch date. If multi-entity reconciliation is your problem too, tell us what your close looks like — it shapes what we build next.
The problem it solves
A practice posts $14,208.63 in receipts on Tuesday. The bank shows three deposits totalling $14,208.63 on Thursday. Which payments make up which deposit? Multiply that by several entities and a month of days, and reconciliation stops being arithmetic and becomes archaeology. TrueBalance does the matching so the exceptions are the only thing left to look at.
The matching engine
Three passes, in order, each one only looking at what the previous pass couldn't resolve:
1 — Exact
One receipt, one deposit, same amount. The easy majority, cleared immediately so nothing else has to consider them.
2 — Subset-sum
Finds which combination of individual receipts adds up to a single lump deposit. This is the pass that replaces an afternoon with a calculator.
3 — Fuzzy
Catches near-misses across dates and small variances, and surfaces them as suggestions for a human to accept or reject rather than silently matching them.
Specifications
| Purpose | Cash receipts reconciliation across EMR/practice-management systems and bank statements |
|---|---|
| Entities | Multi-entity by design — reconcile several companies in one pass, each tying to its own control total |
| Matching | Three-pass engine: exact, subset-sum, fuzzy. Unmatched items are reported, never quietly absorbed. |
| Input | CSV from your EMR or practice-management export and from the bank |
| Output | Excel and PDF reconciliation reports, plus an exception list |
| GL hand-off | Reconciled output feeds a file-based journal-entry import layer, including Sage Intacct dimension mapping for Location and Department |
| Built with | Flutter front end; matching engine implemented in Python, with a JavaScript prototype |
| Who it's for | Multi-location dental, medical and specialty groups, and the finance teams that close their books |
Why we built it
Because we had to do this by hand, monthly, across multiple entities, and no off-the-shelf tool handled the case where one deposit covers many receipts across several days. The subset-sum pass exists because that specific problem cost real evenings.
Interested in an early look? We're talking to a small number of multi-location groups while we shape the product. Get in touch.