Turning credit card allocation into a workflow
Every month, someone hand-coded a stack of credit card charges to a program, a function and a grant. At one three-school network that was 10 to 12 hours a month for the most senior person on the finance team, and month-end could not start until it was done.
I rebuilt it as a workflow. The card statement, the PO report, the Amazon recon and the Uber report go in. Each charge is matched and coded against the school's rules, and the file comes out ready to import into QuickBooks: vendor, account, class and location.
The charges the rules can't place come flagged with a reason, and a reviewer approves before anything posts. The job now takes about 30 minutes to review.
The short video below runs on a demo school's data.