Marketing Spend Reconciliation Checklist: Close the Month with Confidence

Why marketing reconciliation needs its own workflow

Marketing spend crosses systems and teams. A campaign may begin in a planning sheet, become a purchase order in procurement, produce invoices in an accounts payable system, post to the general ledger, and appear under a different name in campaign reporting. Reconciliation connects those records so marketing and finance can agree on what has actually been spent, what is still expected, and what remains available.

The objective is not to make the marketing plan replace the ledger. The ledger remains the accounting record. The marketing view adds operational context such as owner, channel, campaign, timing, and expected future spend. A strong close preserves that distinction while making discrepancies visible and actionable.

1. Set the scope and cutoff

Start every close with a written scope: organization, currency, fiscal period, included entities, and the exact transaction cutoff. Confirm which source is authoritative for posted actuals and who can answer questions about procurement, invoices, and accounting treatment. Use the same cutoff across extracts so a late file does not make one system appear incomplete.

Retain a copy or immutable export of each source used for the close. File names should include the system, period, and extraction time. This creates a reproducible baseline and prevents reviewers from comparing the reconciliation with live data that changed after work began.

• General ledger or finance-approved actuals extract
• Accounts payable invoice and credit memo detail
• Open purchase orders and remaining balances
• Corporate card or expense records in scope
• Marketing plan and latest forecast
• Vendor, campaign, channel, cost center, and owner mappings
• Prior-period exception and accrual log

2. Normalize before matching

Different systems rarely describe the same purchase in the same way. Normalize dates, currencies, signs, vendor aliases, document numbers, cost centers, and campaign identifiers before attempting to match. Preserve every original value alongside the normalized value; normalization should make comparison possible, not erase source evidence.

Define a stable matching key where the data permits it, such as invoice number plus vendor and amount. When no shared identifier exists, use a documented fallback that combines fields and tolerances. Avoid matching on amount alone because recurring retainers, platform fees, and split invoices can produce legitimate duplicates.

3. Match posted actuals to marketing lines

Assign each posted transaction to the correct budget line using the strongest available evidence. Exact matches can move through automatically, but ambiguous records should enter an exception queue rather than inherit a guess. The owner of the relevant program is often best positioned to distinguish similarly named vendors or determine which campaign received the work.

Check for duplicates, reversals, credits, tax, currency conversion, and invoices split across departments or periods. Confirm that the full accounting amount is represented even when marketing reporting allocates it across several campaigns. The campaign allocation is an analytical view; it should reconcile back to the unsplit source total.

• Every transaction maps to one accountable budget owner.
• Mapped values sum back to the finance-approved actual total.
• Credits and reversals point to the original charge where possible.
• Split allocations add to the complete transaction amount.
• Unmapped and partially mapped items remain visible as exceptions.

4. Separate timing items from true errors

Not every mismatch is a mistake. A service may have been delivered before its invoice posts, an invoice may cover several months, or finance may post an accrual that marketing did not include. Classify each exception before correcting it: timing difference, missing record, mapping issue, duplicate, amount discrepancy, currency issue, ownership question, or accounting-policy question.

For a genuine error, document the correction owner and where the fix must occur. Do not silently overwrite a ledger value in the marketing view. For a timing difference, record the expected resolution period. This prevents the same item from being rediscovered and debated in every close.

5. Review commitments and accrual candidates

Actuals show what has posted, not the full economic obligation. Review open purchase orders, signed agreements, media authorizations, and confirmed work not yet invoiced. Determine whether each item is a commitment, a potential accrual under the company's accounting policy, or simply a forecast assumption. Finance should own the accounting decision; marketing should provide delivery evidence and expected timing.

Keep these states separate. A commitment protects budget capacity, an accrual estimates an expense for accounting, and a forecast represents the latest operational expectation. Combining them into one actual-spend number makes both close and planning less reliable.

6. Update the forecast after actuals are settled

Once actuals and known timing items are understood, compare the remaining forecast with current expectations. Replace forecast with actuals only for closed periods and preserve a record of the prior forecast for variance analysis. For future periods, ask owners to confirm timing, scope, commitments, and any newly available amount.

Explain material changes with a short reason code and note. Useful categories include timing shift, scope change, rate change, cancelled activity, incremental request, and correction. Consistent reasons make future forecasting reviews faster and reveal recurring process problems.

7. Validate campaign and management reporting

After the financial totals reconcile, test the management dimensions that leaders use. Look for spend assigned to inactive campaigns, missing regions or channels, unexpected owner changes, and campaign allocations that no longer equal their source transactions. A financially balanced file can still be operationally misleading if its context is wrong.

Run a few end-to-end samples from ledger entry to vendor document, budget line, campaign allocation, and report. Sampling does not replace total checks, but it confirms that the mapping logic creates an understandable trail.

8. Close exceptions and sign off

Summarize unresolved items by amount, type, owner, and expected resolution date. Decide which items prevent close and which can carry forward transparently. Marketing and finance should sign off on the reconciled actual total, open exceptions, accrual inputs, and refreshed forecast rather than approving separate versions.

Archive the source extracts, mapping version, exception log, approvals, and final report together. Then open the next period with carried exceptions already assigned. The close becomes progressively easier when each month begins with the prior month's decisions intact.

• Totals tie to the approved source by entity and currency.
• Unmapped, duplicate, credit, and timing items are resolved or assigned.
• Commitments and accrual candidates are documented separately.
• Closed-period actuals and future forecast are clearly distinguished.
• Campaign and ownership mappings pass validation.
• Marketing and finance approve one final close package.