All insightsAutomation / CC allocation

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.

Credit card allocation workflow, demo school data

See how every build goes

Bring one process your team is tired of doing.

A free call. We'll look at how it runs today, and I'll show you what I'd build. The hours go back to the work that never gets time: the forecasting, the program analysis, the questions your board actually asks.