What am I spending on advertising?

Why ad spend is the easiest expense to waste without knowing it

You spend $4,800 a month on Google Ads. Your agency tells you the campaign generated 240 clicks and 18 leads. That sounds reasonable. But how many of those leads became paying customers? What was the revenue from those customers? If two of them closed at $3,500 each, you spent $4,800 to generate $7,000 in revenue. After your cost of goods, you might have broken even or lost money.

The problem with advertising is that the spending is easy to see but the return is hard to measure. Your accounting software knows you spent $4,800 on Google Ads. It does not know that only 2 of the 18 leads converted, or that your cost per acquisition is $2,400. That gap between spend data and outcome data is where ad budgets get wasted.

And ad spend has a way of creeping up. You increase the Google budget by $500 because it “seems to be working.” You try a LinkedIn campaign for $1,200 “just to test.” You sponsor a local event for $800. Each decision feels small. Together, they push your marketing spend from 12% to 18% of revenue over six months.

What counts as advertising and where it hides in your books

• Digital advertising: Google Ads, Meta Ads, LinkedIn Ads, TikTok Ads, Bing Ads, programmatic display, sponsored content.
• Traditional advertising: Print ads, radio, direct mail, billboards, vehicle wraps.
• Agency and freelancer fees:Marketing agency retainers, freelance ad management, graphic design for ads. These are sometimes booked to “Professional Services” instead of “Advertising.”
• Sponsorships and events:Trade show booths, local event sponsorships, industry conference fees. These may be in “Events” or “Miscellaneous” accounts.

How to find your advertising spend in QuickBooks Online (5 steps)

1. 1
   Open the Profit and Loss report

   From the left sidebar, click Reports. Search for “Profit and Loss” and set the date range to the current month.

2. 2
   Find the Advertising account

   In the Expenses section, look for “Advertising & Promotion,” “Advertising,” or “Marketing Expense.” QuickBooks includes a default “Advertising” account. Click into it to see the individual transactions.

3. 3
   Check for ad costs in other accounts

   Agency fees often end up in “Professional Services.” Sponsored events in “Meals & Entertainment” or “Other Expenses.” Check these for marketing-related transactions.

4. 4
   Review credit card charges from ad platforms

   Go to Banking (or Transactions) and filter by your business credit card. Look for charges from Google, Meta, LinkedIn, or other ad platforms. These should all be in your Advertising account. If they are not, recategorize them.

5. 5
   Calculate ad spend as a percentage of revenue

   Divide total advertising by Total Income. Example: $14,800 ad spend / $92,000 revenue = 16.1%. Track this monthly. Most small businesses target 5-15% of revenue on marketing, depending on growth stage.

How to find your advertising spend in Xero (4 steps)

1. 1
   Go to Accounting → Reports → Profit and Loss

   Set the date range to the current month and click Update.

2. 2
   Find Advertising under Operating Expenses

   Xero's default Chart of Accounts includes an “Advertising” account. Click into it to see individual charges. If you do not see it, check “Marketing” or “Promotion” accounts.

3. 3
   Check for hidden ad costs

   Review “Consulting & Accounting” and “General Expenses” for marketing agency retainers or freelancer invoices that were miscategorized.

4. 4
   Calculate ratio and add comparison

   Divide total advertising by Total Revenue for your ad spend ratio. Use “Compare with: Previous Period” to see if the ratio is climbing. A rising ad spend ratio with flat revenue is a red flag.

What it takes to track advertising ROI every month

• 5-6 minutes per month to pull the total from your P&L and calculate the ratio.
• Another 15-30 minutes to log into each ad platform (Google, Meta, LinkedIn) and pull performance data to calculate cost per lead and cost per acquisition.
• A CRM cross-reference to know which leads from ads actually became customers. Without this, you know your spend but not your return. This is the step most small businesses skip entirely.

Or track your ad spend and returns automatically

Bottomline connects to your accounting software, ad platforms, and CRM. It pulls the spend from your books, the performance from your ad accounts, and the conversion data from your CRM, then shows you the full picture:

The real value is the cross-reference. Instead of just knowing you spent $14,800 on ads, you see that Google Ads generated 6 new customers at $1,200 each while Meta generated 1 at $3,600. That kind of insight requires connecting your accounting, ads, and CRM data, which Bottomline does automatically.