Case studies — BluCat Consulting
Case studies

Ten problems we were handed, and what we did about them.

Every one of these started with somebody typing the same number twice, or a file nobody trusted. Clients are anonymized; the work is not.

Nonprofits, churches & schools

Five builds
Accounts payable

A 58-vendor bill run, from hours to minutes

232 manual entries a month, read by eye off one small-print page — replaced with parsed data and a real approval workflow.

Docparser · Bill.com · QuickBooks Online
Cleanup & rescue

When the cleanup has already failed once

A school whose board could not rely on the numbers, after outside consultants had tried and not finished. Three years later we are still their consultant.

QuickBooks Online
Payroll accounting

Your payroll sync isn’t wrong. It’s just not detailed enough.

Allocation across programs and grants, rebuilt automatically every pay period — balanced, with rounding handled and real variances escalated to a person.

Gusto · Make.com · QuickBooks Online
Revenue recognition

Two systems, one set of books

Andar campaign revenue reconciled to QuickBooks across three concurrent campaign years, with the trial balance attached to every entry.

Andar · Docparser · Zapier · QuickBooks Online
Deposits

From scanned check to recorded deposit

The bank already sends the check number and amount digitally. It was being read off one screen and typed into another.

Mailparser · Zapier · QuickBooks Online

Contractors & trades

Two builds
Job costing

Job costing without the data entry

Consigned inventory pulls, returns, and counter purchases across multiple suppliers — landing on the right project the day they happen.

Docparser · Zapier · QuickBooks Online Projects
Time & billing

When one project generates fourteen time entries

Fragmented timesheets consolidated by employee and project — with every original archived before anything is deleted.

QuickBooks Time · Make.com

Retail, restaurant & e-commerce

Two builds
Revenue reconciliation

Why Shopify and Square never match QuickBooks

Daily syncs create timing differences and someone fixes them monthly. We built the books from the POS system’s own report instead.

Clover · Shopify · Mailparser · Docparser · Zapier
Revenue reconciliation

We turned off the Square integration on purpose

One monthly journal entry per client, built from the Square report, with the source document attached to the entry.

Square · Docparser · Zapier · QuickBooks Online

Professional services

One build
Operational systems · Airtable

“I’m flying through this effortlessly with what used to take hours”

Hundreds of projects out of Excel, reports and invoices out of Word, and lab data loading straight into the record both are generated from.

Airtable · Laboratory data integration
The signature of this problem

Your project tracker is a spreadsheet, your deliverables are Word documents, and the same information gets typed into both.

Also built, write-ups pending

Class registration to invoice and payment

A new registration creates the customer, the invoice and the payment in QuickBooks, with a lookup supplying pricing and revenue category.

Booking Guru · Google Sheets · QuickBooks Online

Online course sales, with the processing fee booked separately

A Stripe charge creates the invoice, records the payment, and books the Stripe fee as its own expense — the step most people miss.

Stripe · Google Sheets · QuickBooks Online

Airtable project management bases

Operational bases beyond the environmental consulting build. Several are live; we are choosing which to write up.

Airtable

If the same number is being typed twice, there is an automation waiting there.

Book a free consult