Daily claims, compiled and reconciled automatically.
Daily claims files were compiled by hand into billing. I built a workflow that reads each day's files and builds the full workbook, reconciliation included.
Languages
Tools & platforms
AI & LLM
Skills
The thinking behind it
- 01 · What I noticed
The same daily file was copied, pasted and reconciled by hand, every single day.
- 02 · What I decided
Let the file trigger everything: build the daily tab, the summary and the reconciliation automatically.
- 03 · What I delivered
A billing workbook that builds and checks itself, working end to end.
Old system vs new system
- Download today's file
- Paste into the master sheet
- Rebuild the pivot
- Reconcile at month end
- File lands in Drive
- Daily tab built automatically
- Summary updates
- Reconciliation checked
Watch it run
Click through the four steps. In step 3, click any box to see what it does.
A workbook that builds and checks itself.
The same file arrived every day and was handled by hand every day. Now the file itself starts the work: daily tabs, a combined view, a summary and a reconciliation against the books, plus a troubleshooting tab for anything odd.
Why it's built this way
Let the file be the trigger
Nobody has to remember to run anything.
Reconciliation built in
Totals are checked against the accounting system automatically.
A troubleshooting tab
Odd rows are surfaced instead of hidden.
What made it work
- 01
Daily chores are the best automation targets
Small, frequent tasks add up fastest.
- 02
Check your own output
A workbook that reconciles itself catches mistakes early.
- 03
Make problems visible
A troubleshooting view saves hours of hunting.
Have a similar mess? Tell me the step you hate.