Nonprofit county billing
The month-end file that builds itself
Court-referred parenting classes · private tool
What was in the way
Every month, Parentz@Work has to hand the county an invoice listing every class held, every person who attended, and a price that changes with attendance. The source documents are PDF sign-in sheets.
A person retyped them by hand, one row at a time. The last hand-built version had a wrong grand total, one class priced at the wrong tier, and an attendee count that didn't match its own sheet.
What we built
Upload the sign-in sheets. They get read and turned into rows. A human reviews and fixes anything the parse got wrong — because a human should always be the one who approves a bill.
Then the county's spreadsheet generates itself, priced correctly by attendance, every time.
Why it works
We didn't build error-checking. We built the errors out.
The month-end total is no longer something a person can get wrong by a hundred and forty dollars, because no person is typing it.
Where it is now
In use. The tool itself is private — it holds real families' names — so there's no demo link. Happy to walk you through it live.
You have no idea how much time you saved me. This is amazing.