Build a Monthly Marketing Spend Reconciliation for a Small Business

A monthly marketing report can show one amount in an advertising dashboard, another on a vendor invoice and a third in the accounting system. Those figures may all be valid because they describe different things: delivery activity, billed charges, agency fees, tax, credits or payment timing. Treating them as interchangeable creates avoidable disputes and can make a campaign look more or less expensive than it really was.

A reconciliation process does not force every source to display the same number. It explains the difference between each number and identifies whether the variance is expected, unresolved or an error. The goal is a defensible monthly record, not a dashboard that appears tidy by hiding mismatches.

Separate the financial concepts

Create distinct columns for approved budget, platform-reported spend, invoice amount, tax and fees where applicable, credits or adjustments, amount paid, and accounting-period allocation. Do not combine these into a single “marketing cost” field without defining what it includes. A prepaid balance may be consumed in a different month from the payment; an agency may invoice for management separately from media delivery.

Record the currency and reporting period for every source. If a business uses more than one currency or time zone, a period boundary can cause differences. Do not silently convert or shift values to make a report reconcile. Preserve the original figure and record the conversion method or timing explanation when needed.

Gather evidence from the right systems

Use the advertising platform’s billing or transaction records for platform charges, supplier invoices for contracted fees, payment records for cash movement, and the accounting system for the organisation’s booked expense. These sources answer different questions. A platform campaign performance report is not necessarily a tax invoice, and a bank debit does not prove which campaign consumed the amount.

For each line, retain the source identifier, period, amount, currency, business entity or branch, and reviewer. Keep access limited to people who need the financial details. Avoid sharing payment credentials or full bank information in a marketing spreadsheet.

Evidence	What it can establish	What it cannot establish alone
Platform billing record	Charges or balance activity recorded by the platform	Whether the business booked it correctly in accounting
Supplier invoice	Amount billed under the supplier’s terms	Whether every billed item was delivered as expected
Payment record	Money transferred or settled	Which campaign produced the charge without a matching reference
Accounting entry	How the expense was recorded	Whether the original supplier charge was accurate
Campaign report	Performance measures and delivery context	Final financial liability by itself

Use a variance queue

Set a reconciliation tolerance based on the business’s own materiality and accounting policy. Do not invent a universal percentage. A small rounding difference may be acceptable under a documented rule; an unexplained duplicate invoice or wrong-currency charge requires investigation even if it is not large relative to the monthly budget.

For each variance, assign a category: timing, tax or fee, credit, currency, duplicate, missing invoice, scope mismatch, or unknown. Name an owner and due date. “Timing” should include evidence of the expected later posting; it must not become a catch-all label for differences nobody wants to investigate.

Hypothetical example: a local retailer

A retailer’s advertising dashboard shows media delivery during the last week of the month. The supplier invoice includes that media plus a separately agreed management fee. The payment occurs in the following month. A poor report might label the invoice as overspend because it is larger than the dashboard figure.

The example is hypothetical. Real accounting treatment depends on contracts, tax rules and the business’s accounting policy; a qualified accountant should resolve material or uncertain treatment.

Close the month without erasing open issues

At close, classify each item as matched, explained timing difference, or unresolved. Do not mark the entire month complete merely because the spreadsheet has no blank cells. An unresolved variance should carry forward with its original month, owner, evidence requested and next review date. When it is resolved, preserve the explanation so the same issue does not need to be rediscovered.

Compare budget to actual using a consistent definition. If the approved budget excludes agency fees but the report includes them, show both the media-only view and the total marketing-cost view. That prevents the team from changing definitions from month to month to make results appear favourable.

Controls that prevent repeat errors

Require a purchase or campaign reference on supplier invoices where practical. Keep a current list of approved vendors and contracted fee structures. Separate the person requesting work from the person approving payment when the business has enough staff to do so. For a solo operator, use a documented second review for unusually large or unfamiliar charges, even if that reviewer is an accountant rather than an employee.

Monthly close checklist

• Each figure has a defined meaning, period and currency.
• Platform charges, supplier fees, payments and accounting entries remain distinct.
• Variances have evidence, an owner and a resolution date.
• Material discrepancies receive finance review.
• The report uses a stable budget definition.
• Open items carry forward rather than disappearing at month-end.
• The final report avoids unsupported claims about return or customer acquisition.