How to Track Advertising Expenses by Platform in QuickBooks Online
One line called "Advertising" won't tell you if your Meta budget is working. Here's how to set up QBO sub-accounts so you can see exactly where your ad spend is going, by platform, every month.
How to Track Advertising Expenses by Platform in QuickBooks Online
Most business owners can tell me roughly what they spend on advertising. What they can't tell me is where it went, or whether it did anything. I hear "we spend a lot on ads" more than almost anything else. A lot compared to what? Compared to what it's bringing in? That's not a judgment. It's a bookkeeping problem, and it's a fixable one.
Here's what a typical P&L looks like when ad spend hasn't been set up properly: one line. "Advertising." A number. Maybe a big one. That's it. Helpful for your tax preparer when they're submitting clean figures to the CRA. Completely useless if you're trying to figure out whether your Meta budget is pulling its weight or quietly draining your account every month.
Ad platforms are not going to volunteer that information. Google, Meta, Pinterest, TikTok, they all have dashboards full of metrics designed to make your spend look productive. Impressions. Reach. Clicks. What they don't tell you is whether any of that turned into revenue. And if your books aren't set up to tell you either, you're flying blind in both directions.
How to set up advertising sub-accounts in QBO
Your P&L needs to show you more than a bulk number before ROI is even a conversation. Not as one bulk number. Broken down by platform, by campaign type, however your business runs ads.
In QBO, this means setting up your advertising expenses as sub-accounts, one per platform. Think of sub-accounts like a folder with files inside. Your tax preparer gets the clean total on the outside — tidy figures, nothing to trip over at filing time. You and I crack it open and see exactly where the money went. Same books. Two different conversations, depending on who's in the room. Every transaction gets coded to the right platform when it comes in, and from there you can pull a custom report that filters your P&L to show only your advertising activity, by month, side by side.
Suddenly you can see that you spent $22,000 on ads in four months. You can see that Meta was your biggest spend. You can see it crept up month over month. You have a starting point.
That's step one. Know where the money is going.
Building a system to track what comes back
Once your ad spend is categorized properly and you're pulling a monthly advertising report, you can start layering in your revenue data. Which months did spend spike? Did revenue follow? Which platform did you scale back, and did revenue hold steady? That's the conversation we have with advisory clients, and it's only possible because the books are set up to support it.
Ad companies have a financial interest in you not knowing how to measure this. The harder it is to attribute results, the easier it is to justify the invoice. Proper bookkeeping doesn't solve your ad strategy, but it removes the excuse for not having one.
What this looks like in practice
The screenshot above is a custom QBO report filtered to advertising only. Four platforms, four months, one clear picture. That took about three minutes to generate once the books were set up correctly. It's now a report that runs every month and takes thirty seconds to review.
If your current P&L has one line called "Advertising" and a number that makes you vaguely uncomfortable, that's where we start. Not with your ad strategy. Not with a new platform. With your books, because you cannot fix what you cannot see. Get the story first. Then figure out if the money is working. Turns out your bookkeeper and your marketing budget have more to talk about than you'd think.
QuickBooks Error 185
Error 185 means your QBO bank feed got booted. Here's why it keeps happening and three ways to handle it without losing a Tuesday morning.
Why your bank feed keeps disconnecting
If you log into QBO and see a red error box telling you your bank feed is disconnected, nothing is wrong with your file. Your bank is doing its job. QBO is not loving the new rules.
If your screen looks like this, you're looking at Error 185.
What is Error 185?
Error 185 is QBO's way of saying your bank now requires additional security verification, usually multi-factor authentication, and QBO can't connect until you re-prove permission to pull transactions. It doesn't damage your file. It doesn't lose any data. It just stops the feed until you fix it.
What's actually happening
By now we're all running on 2FA fumes. Your bank, your email, your Air Miles, the loyalty program at the place you bought a sandwich once in 2019. Half the day is spent toggling to your texts trying to type a six-digit code in before it expires.
Banking 2FA is the one we actually want. It's also the one breaking your QBO feed.
Most banks now require multi-factor authentication for any third-party connection, including QBO. Every so often, your bank decides QBO needs to re-prove it has permission to pull transactions. The feed drops. The red error box appears. New transactions stop syncing.
If nobody catches it, transactions pile up in your bank account that never make it into QBO. You find out at month-end when the bookkeeper opens the file and goes very quiet.
This is happening more often. Plan accordingly.
Three ways to handle it
Some clients want to fix it themselves in five minutes. Some want us to do all of it. Some want to bypass the whole thing. All three are fine.
Option A: Fix it yourself in QBO
About five minutes once you've done it once. You'll need to be at your computer with your phone within arm's reach, because here comes another 2FA code.
Log in to QBO. Go to Transactions, then Bank Transactions.
In the red error box, click "Fix now" beside the disconnected account.
Request your security code. Your bank texts it to you.
Type it in within two minutes before it expires.
QBO usually refreshes everything connected to that bank in one go.
Good fit if you don't mind a short screen sit and want to stay hands-on with your books.
Option B: We reconnect, you send the code
About five minutes once we're synced up. The catch is the security code. It's single-use and expires fast, so we have to do this in real time.
You message us when you're free with your phone in hand. We trigger the reconnect from our end. Your bank texts you a code. You forward it to us right away. We plug it in.
Miss the window and we start over with a second appointment. So: actually be by your phone when we start. We are begging.
Good fit if you want to hand off the technical side without giving us your banking credentials.
Option C: Skip the feed entirely
Most clients don't know this is on the menu. For a lot of small businesses, it's the smarter long-term call.
You download transactions directly from your bank's online portal as a CSV or Excel file. Drop it in our shared folder. We upload it to QBO and reconcile from there. No codes. No coordination. No two-minute panic windows.
The trade-off is the live feed. Transactions land in QBO when you send the file, not in real time. If you're not making decisions off your QBO data day-to-day, the live feed isn't doing much for you anyway. It's mostly just a recurring task you didn't ask for.
If the monthly reconnect dance is wearing thin, this is the answer. Worth a conversation.
Depends on how your week actually runs.
If you're at your desk most days and a quick screen task isn't a big ask, A is your option. If you'd rather hand it off and stay loosely in the loop, B. If you've already mentally checked out of the bank feed conversation, C.
If none of those land, send us a message. Two questions and we'll point you at the right one.
And if you're tired of sorting QBO yourself entirely, that's what we do.
Full service bookkeeping means the bank feed becomes our problem, not yours.
Introducing Loud&Clear.
Let’s make sense of the numbers: together
Let’s make sense of the numbers: together
Hi there! I’m Camille, founder of Loud & Clear Finance, loud laugher, mama to Otto and Jakub, and enthusiastic user of far too many exclamation marks (what can I say, I’m a geriatric millennial at heart).
After more than a decade helping small businesses and entrepreneurs clean up books, decode reports, and make sense of their numbers, I realized something: most people don’t struggle with math; they struggle with clarity.
That’s what Loud & Clear is all about.
I wanted to build a place where financial conversations feel approachable, honest, and fun. Because when you actually understand your numbers, you make decisions with confidence, not confusion.
A Bit About Me
When I’m not colour-coding spreadsheets or reconciling bank accounts, you’ll usually find me outside. I love to hike the trails around Bragg Creek and Canmore with my family. (I tackled the 75 km West Coast Trail once; still not sure what was harder: the 13 km beach day or the four-month sleep regression.)
I used to work as a primary care paramedic, which taught me to stay calm and think fast under pressure...skills that come in surprisingly handy during tax season.
These days, I’m big into Pilates for counteracting all my computer time and slow, meandering walks for ice cream around Bridgeland (no season too cold). The real debate? Is melted chocolate from Village the winner, or does Made by Marcus’ chocolate honeycomb take the prize?
What You Can Expect Here
This blog is where I’ll share practical finance tips, behind-the-scenes stories, and tools to help your business grow with confidence. Think of it as a mix of straightforward advice, real talk, and maybe a little humour along the way.
Thanks for being here. I can’t wait to share more and help you make your money talk loud and clear.
And forgive me for all the branding puns & references, when your team absolutely nails it, you can’t help but come back to it again and again. A huge shoutout and thank you to Jill @ Nice One and Brian @ Special Forces for their incredible work in helping me bring this vision to life.
Camille