Advertising Expense Template

If you advertise on more than one platform, the end of the month becomes a detective job. You log into Google Ads, Meta, TikTok, LinkedIn, and maybe a few smaller networks, and copy numbers into a spreadsheet by hand. Receipts land in your inbox as PDF attachments. Invoice emails pile up. By the time you sit down to reconcile, you've lost an hour and you still don't trust the totals.

An advertising expense template fixes this. It's a single log that captures every ad dollar in the same row format, no matter where the spend came from. One column for the campaign, one for the platform, one for the date, one for the amount. Add a few extra columns for impressions, clicks, and notes, and you have a record your bookkeeper can read in seconds and your accountant can defend at audit.

What the template is

This template is a structured row format for logging every advertising charge a business pays. Each row is one transaction: one campaign charge, one invoice payment, one monthly subscription that ran through your ad account. The columns stay the same across rows, so a single SUM formula at the bottom gives you monthly or quarterly totals without manual math.

The format works whether you spend $200 a month on a single Google Ads campaign or $20,000 split across Meta, TikTok, and a print campaign with a local magazine. The trick is consistency: every entry follows the same shape, so the data is sortable, filterable, and exportable to QuickBooks, Xero, or your accountant's spreadsheet template.

Fields and columns

The core template has seven columns. You can rename them or add more, but this set covers what a bookkeeper needs to reconcile ad spend against your bank statement and what an accountant needs to defend the deduction at tax time.

• Campaign: the campaign name from the ad platform. Use the exact name as it appears in the platform's dashboard so reconciliation is fast.
• Platform: Google Ads, Meta, TikTok, LinkedIn, Microsoft Ads, print, radio, sponsorships, or any other vendor. Pick a consistent spelling so you can filter later.
• Date: the date the charge hit your card or bank account, not the date the campaign ran. Format as YYYY-MM-DD for clean sorting.
• Amount: the total spend in USD before any tax adjustments. If your card charged $512.40 for $500 of ads plus tax, log $512.40 unless you track tax separately.
• Impressions: the number of impressions the platform reported for that campaign on that date, or blank if the spend isn't impression-based.
• Clicks: the number of clicks, conversions, or engagements the platform reported, or blank if the charge isn't click-based.
• Notes: free text for context. Tag campaigns by season, product line, or objective (lead gen, brand awareness, retargeting).

For most small businesses, seven columns is enough. If you run paid social with UTM-tagged URLs and want to attribute spend to a specific landing page, add a landing_page column. If you have agency fees on top of platform spend, add a fee column so the agency markup stays visible without inflating the platform total.

How to use it

1. Create one row per charge. When Google charges your card on the 3rd of the month, log one row for that charge with the platform set to Google Ads and the campaign set to whatever name your dashboard shows.
2. Pull spend reports weekly. Most ad platforms let you export a CSV of campaign-level spend for any date range. Pull those reports every Monday and paste the rows into the template rather than waiting until month-end.
3. Match receipts to rows. For each platform charge, attach or link the receipt. SlipSheet reads the receipt and pulls the date, vendor, and total automatically, so you don't re-type numbers you've already been billed for.
4. Tag by objective. Use the Notes column to mark each row with its purpose: brand awareness, lead generation, retargeting, hiring, product launch. This pays off when you need to defend a deduction or answer "what did we get for that $4,000 last March?"
5. Run totals at month-end. A single SUMIFS formula over the Date column gives you the monthly total. Pivot by Platform to see where the spend went. Pivot by Objective to see what you got for it.
6. Export to your accountant. Send the finished template as a CSV or share a Google Sheets link at the end of each month. Your bookkeeper gets a clean reconciliation source instead of a folder of PDFs.

The biggest time savings comes from step 3. Manually typing every receipt total into a spreadsheet is the slowest part of reconciliation. SlipSheet scans a receipt in under three seconds and writes the row for you, so logging 30 monthly ad charges takes a few minutes instead of an hour.

Customization options

Seven columns is a starting point. Once you've used the template for a month, you'll know which extra columns earn their keep. A few common additions:

• Account or profile: useful if you run multiple Meta ad accounts or Google Ads MCCs. One column for the account ID keeps separate budgets separate.
• Tax: split out sales tax or VAT if your jurisdiction taxes ad spend. A separate column lets you SUM just the tax line at filing time.
• Invoice or receipt URL: link each row to the source document in Google Drive or Dropbox. Auditors love a clickable paper trail.
• PO number: required by some larger companies for procurement. One column for the PO keeps the spend tied to the approval.
• Status: paid, pending, disputed. Useful if you dispute a charge with a platform and want to track the resolution.

If you advertise on both paid social and traditional channels like print or radio, the same template covers both. The Impressions and Clicks columns will sit empty for print, but that's fine. The Date, Amount, and Notes columns do the heavy lifting, and you can filter them later to compare digital cost-per-click against print cost-per-thousand.

Getting started

Build the template in Google Sheets or Excel with the seven columns above, freeze the header row, and add a SUMIFS formula at the bottom of the Date column. Then log the last 30 days of ad charges from each platform's billing section. Most platforms let you download a CSV of recent charges directly, which pastes cleanly into the template.

If you want to skip the manual entry entirely, point SlipSheet at your inbox. It scans every receipt and invoice email, extracts the vendor, date, total, and tax, and writes the row for you. The template fills itself out as the month goes, and at month-end you already have a clean log ready for your bookkeeper.

Stop reconciling ad spend from screenshots. Build the template once, log every charge as it lands, and keep a 3-year audit trail that survives every platform's dashboard redesign. Try SlipSheet free for 14 days and see how fast the template fills itself.