The Spreadsheet I Use to Track Marketing Spend Across Five Channels
This is for anyone running paid spend across more than two channels who has ever looked at their bank balance and thought "that doesn't match what the dashboards say." If that's you, you need a marketing spend tracking spreadsheet that pulls from platforms and reconciles against your bank, not just a reporting dashboard that trusts the platforms blindly. The single decision that matters: are you tracking spend to measure performance, or tracking spend to catch errors. You need both, but they are not the same sheet.
Decide this first
Decide whether your spreadsheet's job is reconciliation or reporting. Most people build a reporting sheet and call it done. That's a mistake.
Reporting tells you what you spent and what you got back. Reconciliation tells you whether the number you think you spent is the number that actually left your account. These diverge more than people expect. I've seen a 7% gap between what a Meta dashboard reported mid-month and what actually cleared the bank, because of refunds, failed charges that retried, and currency conversion on a card billed in a different currency than the business runs on.
Build the sheet around reconciliation first. Reporting is easy once the numbers are trustworthy. Reporting on numbers you can't trust is worse than not reporting at all, because it gives you false confidence.
What to look for
One row per transaction, not per platform summary
Don't pull "Meta spend: $14,200 for the month" into one cell. Pull daily spend per platform instead, even if it's tedious. Daily rows let you spot the exact day something broke; a failed payment method, a campaign left running after you paused it, a currency rate shift. Monthly totals hide all of that until it's too late to fix cheaply.
My sheet has five tabs, one per channel (I run Google, Meta, TikTok, LinkedIn, and affiliate/influencer spend), each with columns for date, platform-reported spend, currency, converted USD amount, and a note field. A sixth tab rolls everything up and compares it to the bank statement line by line.
A bank reconciliation column, every single time
This is the part most tracking templates skip entirely. Next to your platform-reported spend, you need a column for "amount that hit the bank/card statement." Then a variance column that auto-calculates the difference. If variance is anything other than zero, you investigate before the month closes, not three months later when finance asks why Q2 is off by $4,000.
On the $2.2B infrastructure project I ran marketing budget for, we reconciled weekly, not monthly, because the budget had six funding sources and three approval layers. Weekly reconciliation caught a vendor double-billing issue in 11 days instead of the 60 it would have taken on a monthly cycle. The habit scales down fine to a $20K/month DTC budget too. Weekly beats monthly every time, even if monthly is what you report externally.
A blended CAC tab that uses the reconciled number, not the platform number
Once your five channels reconcile against the bank, add one more tab that divides total reconciled spend by total orders (or leads, or whatever your conversion event is) for the period. This is your real blended CAC. Compare it against each platform's self-reported CAC and you'll usually find the platforms are optimistic by 10-20%, because they're counting view-through conversions or extending attribution windows past what you'd choose yourself.
On the DTC brand I scaled from $100K to $3M+ in revenue, Meta's reported CAC ran about 18% lower than our blended, bank-reconciled CAC for most of year two. That gap is the difference between a profitable channel and a break-even one. You can't see it without this tab.
What to ignore
Ignore any tracking template that promises automatic API pulls from all five platforms with zero manual entry. These exist, they're sold as time-savers, and they break constantly. API rate limits change, platforms deprecate endpoints, and you end up debugging a Zapier integration instead of debugging your actual spend. A spreadsheet with 15 minutes of manual entry per platform per week, done by a human who notices when a number looks wrong, catches more errors than a fully automated pull that nobody looks at until the dashboard breaks.
Ignore multi-currency auto-conversion features baked into fancy templates. Just use a single formula referencing a manually updated exchange rate cell, updated weekly. You don't need live FX rates for marketing spend tracking. You need consistency, and consistency is easier to get from a static weekly rate than from a live API that shifts your historical numbers retroactively every time you open the file.
Ignore forecasting and pacing features unless you're already nailing reconciliation. A sheet that projects your month-end spend based on current pace is useless if the current pace number is wrong. Fix the foundation before you build the prediction layer on top of it.
Common mistakes
The biggest mistake is trusting the platform dashboard as the source of truth instead of the bank statement. Platforms report spend in real time, which means the number you see on Tuesday for Monday's spend can still change by Thursday, because of delayed conversion attribution adjustments or billing corrections. I've watched teams close their books on a number that moved by $2,000 two days later. The bank statement is the only number that doesn't move. Build your reconciliation habit around that fact.
The second mistake is letting one person own the spreadsheet with no second set of eyes. Spend tracking errors are usually small and boring, a typo in a cell, a formula that didn't copy down correctly, a row that got deleted during a cleanup. These sit invisible for months in a single-owner sheet. Even a 10-minute monthly review by someone else catches most of these before they compound.
The third, and the one I see most often with founders managing their own spend: mixing ad spend with platform fees, agency fees, and software costs in the same column. When a founder tells me their Meta spend was "$18,000 last month," half the time that number includes a $2,500 agency management fee billed through the same card. That's not ad spend, that's a service cost, and blending them wrecks your CAC math. Keep a separate column, always, for fees versus media spend. It's one extra column and it saves you from a wrong conclusion about which channel is actually working.
FAQ
How often should I reconcile marketing spend against the bank?
Weekly if you're spending more than $10K/month across channels, or if more than one card or funding source is involved. Monthly is fine for very small, single-channel budgets, but even then, do a mid-month spot check. Waiting until month-end to discover a problem means you've already made decisions on bad data for three or four weeks.
What columns does the spreadsheet actually need, minimum?
Date, platform, platform-reported spend, currency, converted amount, bank-confirmed amount, variance, and a notes field for anything unusual. That's eight columns per channel tab. Add a ninth, "reconciled by," if more than one person touches the sheet. Anything beyond that is nice-to-have, not need-to-have.
Should I use a tool instead of a spreadsheet once spend gets big enough?
Eventually, yes, somewhere north of $500K/month across channels, a dedicated spend management tool earns its cost. Below that, a well-built spreadsheet with a disciplined weekly habit outperforms most tools, because the tools still require someone to check their output against the bank anyway. The spreadsheet forces that check by design.
What's the single most common gap between platform spend and bank spend?
Refunds and credits. Platforms issue ad credits for disapproved ads, billing errors, or service outages, and those show up as negative line items on your statement days or weeks after the original charge. If your tracking sheet doesn't have a line for credits, your reconciled total will look wrong forever, chasing a discrepancy that isn't actually an error, it's just an unlogged refund.
Build the sheet this week if you don't have one. Start with five tabs, one per channel, add the bank reconciliation column before anything else, and check it every Friday. The spreadsheet doesn't need to be clever. It needs to tell you the truth about where your money actually went.