Business · Reconciliation
TrueBalance
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.
Available now on the web and Google Play. Use TrueBalance in any browser, or install the Android app from Google Play. Access is provisioned for your business by JMWINC Developers; the iOS app is on the way to the App Store.
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 | On-screen dashboards, per-transaction drill-down, an executive summary, and CSV, Excel and PDF exports for every view plus a full audit trail |
| 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 (web, iOS, Android) with a Dart matching engine; Supabase backend on the shared JMW hub |
| 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.
Want access for your group? TrueBalance is provisioned per business by JMWINC Developers. Get in touch to be set up.