Your agency is leaking money between three systems. We find it.

Payroll hours. Hours worked in HHAeXchange against hours paid in ADP. The 5,628-hour gap here is the same number behind the Payroll Gap page — labor delivered that never came through payroll.

Revenue. Billed in HHAeXchange against booked in QuickBooks. When QBO trails, services have been delivered that nobody has recognized yet.

A/R and collections. What the schedule says you are owed against what the books say, and what actually arrived. A spread here is a bookkeeping problem long before it is a collections problem.

A leg is TIED only when both systems agree to within a hundredth of an hour or a cent. There is no tolerance band and no rounding bucket.

Where a number is missing because of an internal booking gap, the row says so rather than hiding it. Revenue sitting unrecognized in QuickBooks is a finding about the close, not a failure of the reconciliation — and the owner sees it on the same page as everything else.

This is the page an auditor would build first. It is also the one that tells you which of your own teams is behind.

Manual and late entries are the two buckets auditors sample first. Both are flagged nightly with caregiver, patient, and date so a coordinator can cure them before claims go out.

Only the last row is a collections conversation. The other two are data fixes — and they were hiding it.

This is not recovered cash. It is ~$90K of receivables whose aging cannot be trusted because the underlying records are incomplete. Until due dates and payment applications are corrected, no one can tell a real collections problem from a clerical one.

The reconciliation names every affected invoice, so the fix is a work list — not a project.

A payer variance of $1,480 every two weeks doesn't feel like much — until it compounds to ~$38,000 a year of services delivered but never recognized. The weekly recon catches drift while the visits are still fresh enough to re-bill or correct.

Each variance row expands to the exact visit list behind it, so your biller starts from evidence, not a hunch.

+ 10 more · Each idle patient is authorized care you're not delivering — and census that quietly walks away.

9 caregivers submitted after the payroll cutoff last week. 3 of them also appear on the payroll gap list — chronically late paperwork is the leading indicator for the payroll exposure that follows.

HHACFO tracks submission timing on every visit, so the pattern surfaces weeks before it becomes a dollar problem.

Visits with no authorization behind them. Care is delivered, the claim is denied, and the write-off lands a month later when the schedule has already moved on.

Authorizations that quietly run out. Units exhaust or the window closes mid-plan-of-care, and nobody notices until billing bounces.

Both are arithmetic once the schedule and the authorization file live in the same warehouse — which is the whole point.