Where the work stalled
Each pay period, billing totals were re-keyed by hand from PDF reports into a separate payroll workbook for each doctor.
What we built
The workflow runs as a hosted application on AWS.
- Read the billing report and extract each doctor's items.
- Map billing codes to payroll lines using a maintained table.
- Write figures into each workbook's input cells while preserving its formulas.
- Produce a log of every placement and anything that could not be matched.
- Send each workbook to the practice manager for checking before payroll approval.
Where people stay responsible
Every workbook is checked before anyone is paid. Unknown codes are flagged rather than guessed.
- The practice manager checks every workbook before payroll is approved.
- Unknown billing codes are flagged for a person rather than guessed.
Limitations
- A change to the billing report layout can interrupt extraction.
- The workflow does not determine whether the underlying billing is correct.
Measuring it
Compare run time, checking time and corrections per pay period with the manual baseline.
No outcome figures are published because a measured baseline and comparison period are not being claimed for this example.
Our evidence and corrections policy ↗