5 min read

Your Controller Isn't Your Human API

Your Controller Isn't Your Human API
Manual Data Work in Agency Finance: The Controller Audit
8:46

By Craig S. Cody, CPA, Certified Tax Coach.

If your controller spends half the week moving numbers from one system to another, the problem isn't the controller. It's the way your agency moves data.

A new survey put a name on it. In the Financial Education and Research Foundation's 2026 Finance Architecture Survey, 36% of organizations said their directors, controllers and senior managers spend between 31% and 50% of their time firefighting and manually fixing data. The report calls those people "human middleware": the layer of humans sitting between systems that don't talk to each other.

That's a warning for marketing and PR agencies, not a benchmark. Here's how to find out whether it describes yours, and what to do about it.

Who Did the Survey Actually Ask?

CPA Practice Advisor reported the findings on October 9. The survey asked 116 senior finance and accounting executives, mostly at U.S. organizations: CFOs, controllers, chief accounting officers and finance VPs.

That's not a survey of agencies, and I wouldn't hold your agency up against its numbers. Most agencies don't have a CFO, a controller and a VP of finance. Many have one controller or one bookkeeper doing all of it.

Which is exactly why it matters. If larger finance teams with more people are losing up to half their senior staff's week to moving data by hand, a smaller agency team with one person in the middle has even less room to absorb it.

The survey had two more numbers worth your attention:

  • 40% run a monthly close of seven days or longer.
  • Half named the talent and skills gap as the single greatest threat to their finance function.

What Does "Human Middleware" Look Like in an Agency?

Agencies run on more systems than most owners realize, and the data has to get from one to the next:

  • Payroll has to land in the general ledger, split the way you track people costs.
  • Time tracking and project management have to turn into invoices and project margins.
  • Media billing has to match insertion orders, vendor invoices and client invoices, and the pass-through has to land in the right place.
  • Invoicing has to flow into receivables and then match cash when it comes in.
  • The bank has to reconcile to the books every month.

When those systems don't connect, somebody connects them by hand. Exports, spreadsheets, re-keying, "let me just fix that." That somebody is usually your controller or your bookkeeper, and the hours never show up anywhere you'd look.

Why Isn't the Answer Just More Automation?

Because automating a bad handoff gives you a faster bad handoff.

I've watched a lot of agency owners switch on the automation of their books. The hard part was making sure the right items were automated correctly. Connecting two systems is the easy part. Deciding what each field means, where each number lands, and who checks it is the work.

So the fix starts with knowing where the manual hours actually go. Then you decide which handoffs to automate, which to redesign, and which to leave alone.

How Do You Audit the Manual Work in Your Agency?

Sit down with your controller or bookkeeper for an hour and walk through every handoff between systems. For each one, write down five things:

  1. What moves. Payroll to the ledger, time to invoices, media to client billing, invoices to receivables, bank to books.
  2. How it moves. An integration, an import file, or a person typing it in.
  3. Hours a month. The honest number, including the time spent fixing it afterward.
  4. What breaks. How often it's wrong, and how you find out.
  5. What it delays. Whether the close waits on this one.

Then score the agency on two numbers:

  • Close delay. How many business days after month end until you have final numbers? Write it down every month. If it's getting longer, a handoff is getting worse.
  • Project-margin visibility. How many days after month end until you can see margin by project and by client? This is the number that tells you which work is actually making you money. If it takes weeks, you're pricing next month's work on last quarter's information.

At my firm, we show our clients the accrual-to-cash adjustment every month for the same reason. A number you only see once a year can't change a decision during the year.

What Do You Fix First?

Start with the handoff that delays the close the most, not the one that annoys people the most. Usually that's one of three:

  • Time to billing. If project time has to be cleaned up before it can be invoiced, both the invoice and the project margin wait.
  • Media billing. Matching insertion orders, vendor invoices and client invoices by hand is slow and error-prone, and errors there move your revenue and your margin at the same time.
  • Payroll to the ledger. If people costs land in one lump, you can't see margin by client or by account manager at all.

For each one, the choice is the same: connect the systems properly, change the process so the data is entered once in the right place, or accept the manual step and give it a clear owner and a deadline. All three are fine. Leaving it to whoever has time isn't.

Once the data moves on its own, your controller gets their week back for the work you hired them for: checking the numbers, explaining them, and defending them when a lender, a partner or a buyer asks.

What About AI?

The same survey found that 53% of organizations plan to put a significant share of their technology budget into AI over the next year or two. Only 3% describe AI as a core, integrated part of how they work, and 39% are deploying AI tools with no formal way to measure the impact.

AI sitting on top of disconnected systems is still human middleware, just faster. Fix the handoffs first. Then decide where AI actually saves hours, and measure it. I wrote about the real cost behind "free" AI labor separately.

Who Is This Not For?

If you're a solo owner doing your own books with one bank account and a handful of clients, you probably don't have handoffs to audit yet.

And if your close is done in a few days and you can see margin by project before the next month's decisions, you're ahead of a lot of larger organizations. Keep scoring both numbers so you notice if they slip.

Frequently Asked Questions

What is "human middleware" in finance?

It's the survey's term for people who spend their time moving and fixing data between systems that don't talk to each other. In an agency, it's usually the controller or bookkeeper re-keying payroll, time, media and invoicing data by hand.

How much time do finance teams spend on manual data work?

In the 2026 Finance Architecture Survey of 116 senior finance executives, 36% of organizations said directors, controllers and senior managers spend between 31% and 50% of their time firefighting and manually fixing data. That's a survey of mostly larger U.S. organizations, so treat it as a warning, not an agency benchmark.

How long should a monthly close take for an agency?

There's no single right number, but it should be short enough that you see final numbers before the next month's decisions. In the same survey, 40% of organizations take seven days or longer. Track your own close every month and fix whatever handoff makes it longer.

What should an agency automate first?

The handoff that delays the close the most. For most agencies that's time-to-billing, media billing, or payroll landing in the ledger. Decide what each number means and where it lands before you connect anything, or you'll automate the mistakes too.

Will AI fix manual data work?

Not on its own. AI sitting on top of disconnected systems still needs someone to check and move the data. Fix the handoffs first, then use AI where it measurably saves hours.

Give Your Controller Their Week Back

Your controller isn't your human API. Find the handoffs, count the hours, score your close and your margin visibility, and fix the worst one first.

If you want more on running your agency by the numbers, I wrote a book for agency owners. You can request a free copy at the link below.

Request your free copy

Nobody's looking out for your money but you. Let's go look together.

Craig S. Cody is a CPA, Certified Tax Coach, and retired NYPD Lieutenant. His firm works with more than 70 marketing and advertising agency owners every month, helping them keep more of what they make through proactive tax planning.

This article is general education, not advice for your specific situation. Confirm your own facts with your advisor before acting.

Your Controller Isn't Your Human API

Your Controller Isn't Your Human API

If your controller spends half the week moving numbers between systems, the problem isn't the controller. How to audit your agency's handoffs.

Read More
Who Decided That Invoice Was Never Getting Paid? Why Your Agency Needs a Written Policy for Credit Memos and Write-Offs

Who Decided That Invoice Was Never Getting Paid? Why Your Agency Needs a Written Policy for Credit Memos and Write-Offs

An overdue invoice doesn't disappear on its own. Somebody makes it disappear. Why your agency needs a written policy before anyone touches AR.

Read More