Bookkeeping
Bank Reconciliation for Agencies: The Process and What It Catches
Categorizing a transaction correctly and confirming it actually happened are two different jobs. Here's the formula, the six-step monthly process, and what bank reconciliation for agencies catches that software alone misses.
7 min read
By Joshua Barnett · Founder, ThinkProfit · Digits Partner · Certified QuickBooks ProAdvisor
November 16, 2026
Bank reconciliation for agencies means confirming that every transaction your books show for an account matches, line for line, what the bank's own statement says actually happened, every month, without exception. For most small businesses that's routine housekeeping. For a Marketing and Advertising Agency running client ad spend through its own bank and card accounts, it's the control that catches a duplicate five-figure platform charge, a contractor payment that cleared twice, and a cash position that looks fine on the P&L but isn't actually sitting in the account. Here's what the process involves, the formula behind it, and the six steps that catch what categorization software alone can't.
Reconciliation is not the same job as categorization
Categorization software assigns a transaction to an account, ad spend to cost of delivery, a SaaS subscription to overhead. It does that well. What it doesn't do is confirm that the transaction it categorized actually matches a real, singular event at the bank. A platform can bill twice for the same campaign in a billing glitch, and software will happily categorize both charges correctly, it has no way to know one of them shouldn't exist. Reconciliation is the separate, manual-adjacent check that catches that: it compares the books' ending balance against the bank's statement balance for the same date range and forces every difference to be explained, not just coded.
Why this matters more for agencies than most small businesses
A retail business with one bank account and no pass-through spend can get away with a loose reconciliation habit for a while. An agency usually can't, for three reasons specific to how agencies bill and pay. First, ad spend float: money moves through agency-controlled accounts before it's the agency's own revenue, which we cover in ad spend pass-through accounting, and an unreconciled float account is the fastest way to misstate both revenue and cash. Second, contractor-heavy delivery means payment timing is lumpy, several contractor payments can clear in the same three-day window and look like duplicates when they aren't, or look fine when one actually is. Third, retainer deposits sitting as unearned revenue need their own paper trail against the bank, since a deposit that hits the account but never gets matched to an invoice is easy to lose track of by month three.
The reconciliation formula and a worked example
The formula is: Book balance + outstanding deposits (money recorded in the books but not yet cleared the bank) − outstanding payments (checks or transfers issued but not yet cleared) ± bank-only adjustments (fees, interest, errors) = Bank statement balance. Say an agency's books show a $142,300 ending balance in its operating account for October, but the bank statement shows $138,900, a $3,400 gap. Working through outstanding items turns up $5,200 in contractor payments issued October 29 that hadn't cleared yet, and a $1,800 ad platform refund that hit the bank October 31 but hadn't been entered in the books. $138,900 + $5,200 − $1,800 = $142,300. The books and the bank agree, and the $3,400 gap is now explained by two specific, named items instead of sitting as an unresolved difference carried into November.
The six-step monthly reconciliation process
First, pull the bank statement and the book register for the identical date range, mismatched periods are the most common self-inflicted error. Second, match every transaction that cleared the bank to a corresponding book entry, one by one, not in bulk. Third, list every item that's in the books but hasn't cleared the bank yet, outstanding checks, pending transfers, deposits in transit. Fourth, flag and investigate any bank-side item older than five business days that has no matching book entry, that's where duplicate charges and missed entries turn up. Fifth, post adjusting entries for bank fees, interest earned, and anything the investigation in step four surfaced. Sixth, produce a reconciliation report showing the adjusted balances matching, and file it with the month's close package, the same close process this plugs into is covered in month-end close process for agencies.
What reconciliation catches that categorization never will
The value shows up in specific dollar amounts, not theory. One pattern we see often: a platform's billing system double-fires a charge during a campaign budget change, and both charges get categorized correctly as ad spend, nothing in the categorization looks wrong. It's only the reconciliation, matching bank-cleared items one for one against book entries, that surfaces the duplicate, sometimes four figures, occasionally five, sitting unnoticed for months because every individual charge was coded right. The same process catches contractor checks that sit uncashed for 60-90 days (a real escheatment and cash-planning risk), bank fees that quietly accumulate on accounts no one checks closely, and retainer deposits that landed in the bank but never got matched to an invoice, so the client gets billed again or the revenue never gets recognized at all.
How often to reconcile, and when it's a cash problem, not a bookkeeping one
Monthly is the floor for every account. Agencies moving more than roughly $50,000 a month in pass-through ad spend, or running campaigns across three or more platforms, should reconcile those specific accounts weekly or biweekly, since a platform's own dispute window for a duplicate charge often closes well before a monthly cycle would catch it. If reconciliation keeps surfacing gaps that trace back to genuine cash unpredictability, not bookkeeping error, late client payments, uneven ad spend timing, payroll outrunning collections, that's no longer a once-a-month housekeeping question. It's the kind of recurring cash visibility problem a fractional CFO for marketing agencies is built to get ahead of before it turns into a missed payroll run.
Not sure your accounts actually reconcile? Let's check.
We'll reconcile every account against the bank, flag what's actually wrong versus just timing, and put a monthly process in place so it doesn't drift again.
Frequently asked questions
How often should a marketing agency reconcile its bank accounts?
Monthly at minimum, as part of month-end close. Agencies running more than roughly $50,000 a month in pass-through ad spend across multiple platforms should reconcile those specific accounts weekly or biweekly, since a duplicate or missing charge sits undetected for a full month otherwise, and by the time the statement arrives the platform's own dispute window may already be closing.
What's the difference between reconciling and categorizing transactions?
Categorization assigns a transaction to an account on the P&L or balance sheet. Reconciliation is a separate check that confirms every transaction the books show for a period actually matches what the bank's statement says happened, and that nothing is missing or duplicated. A transaction can be perfectly categorized and still be wrong, booked twice, booked to the wrong month, or never booked at all, and categorization software has no way to catch that on its own.
What does an unreconciled ad spend account usually mean?
Most often it's a timing mismatch: the agency billed the client for ad spend in one month but the platform charged the card in another, which is normal and just needs an outstanding-item note. Less often it's a real problem, a duplicate platform charge, a refund that was never recorded, or a client's deposit sitting uninvoiced. The reconciliation is what tells you which one you're looking at.
About the author
Joshua Barnett is the founder of ThinkProfit, a bookkeeping and fractional CFO firm for marketing agencies, SaaS companies, and digital businesses. He is an official Digits Partner, a certified QuickBooks ProAdvisor, and previously ran the financial side of an M&A firm that acquired and operated digital marketing agencies.
ThinkProfit keeps every account reconciled every month, so your cash position is never a guess. Get a free quote to see what it would cost for your business.