Why your affiliate marketing reporting dashboard disagrees with finance

What to take away

Start from the decisions, not the charts

A dashboard is a queue of decisions. Write the questions down before you choose a tool, because a panel nobody acts on is decoration.

Most English retail programmes ask the same questions. Which publishers bring new customers rather than repeat discount hunters? Where do returns erode commission?

The Affiliate Marketing Measurement and Reporting Guide maps the wider evidence cycle, so read it before you rebuild definitions that already exist elsewhere in your programme.

Agree what one row represents

One row should equal one settled transaction, not one click. State whether the row carries gross order value or net of VAT, and whether it includes delivery. For a like-for-like comparison with finance, show order value net of VAT where applicable, and show any VAT charged on commission separately from the commission itself. Agree the treatment of VAT on cross-border network invoices with finance.

Write the definition in the dashboard itself, because a tooltip or footnote is enough. If two teams export the same data and get different totals, nobody agreed the definition.

Name the owner and the refresh date

Every panel needs a named owner and a stated refresh time. A weekly report described as live is worse than an honest weekly one.

Show the last refresh date on the page. When a number looks wrong, ask when it was last rebuilt.

Build the path from click to settled commission

Commission is not the same as revenue. Reconcile the path in stages: click, order, validation, settlement, then payment; each stage can lose rows and each loss needs a reason code. For programmes using Awin, CJ, impact.com, Partnerize, Rakuten Advertising or Tradedoubler, use that network's transaction statuses, validation rules and reporting cut-offs: they vary by programme, and pending or validated transactions may not yet be locked for settlement. Late returns, cancellations, claim decisions and reporting cut-offs can therefore leave the dashboard, network report and finance ledger showing different totals or periods.

Reconciliation comes before presentation. If network totals and your own order data disagree, publish both and explain the gap, separating timing differences from missing, duplicated or reversed transactions.

Finance is not simply using the network's payment date. Under the retailer's applicable accounting framework, such as IFRS 15 or FRS 102, customer revenue is recorded under the relevant recognition policy; affiliate commission is a separate cost, and finance may accrue an incurred commission liability before cash settlement. Agree the cut-off and treatment with finance rather than treating pending, locked or paid network statuses as accounting entries.

Match platform data to your own orders

Use the network's transaction ID as the join key wherever it is provided. Where it is not, join on order reference and accept a small unmatched pile.

Count unmatched rows monthly and query anything above a threshold you set in advance, for example 2% of transactions.

Handle reversals and late claims

Returns, cancellations and failed payments all reverse commission. Decide how long a transaction can be reversed before it counts as settled, then publish that rule.

Give publishers a way to raise a query with evidence. A short form plus a dated log resolves more disputes than a longer contract.

Report channel by channel and keep the whole picture

Channel totals and publisher totals answer different questions, so keep both and label each one.

Blend them together and you cannot tell whether growth came from a new publisher or one large placement.

Add publisher-level evidence

Publisher rows show concentration. If three publishers generate most of the settled commission, the programme carries risk. Report your top ten publishers by settled commission beside the total.

Read affiliate marketing key metrics in England for the metric set behind these rows, then drop anything the team never acts on.

Keep email and social claims compliant

For email promotions sent to individuals, apply PECR: record consent where it is required, or document the applicable exception, such as the soft opt-in. Keep UK GDPR records for the personal data used, including the source and date of permission where relevant. The ICO's guidance on direct marketing using electronic mail explains the rules; store the evidence beside the campaign and transaction records.

Social placements carry their own rules. The ASA administers the CAP Code, which requires affiliate marketing to be clearly identifiable as advertising, so retain the publisher brief and a copy of the labelled placement. TikTok's advertising policies set out what commercial content may claim and when it must be labelled, so brief publishers before they post.

Common questions

How many metrics should a dashboard show?

Fewer than most teams start with. One headline figure, four or five supporting rows and a dispute count cover a normal retail programme.

How often should affiliate reporting be refreshed?

A weekly refresh can support routine monitoring, but network validation, locking and settlement schedules vary. State the dashboard cadence and mark figures provisional until transactions pass the programme's validation and settlement rules.

What belongs in a dispute log?

The date raised, the transaction reference, the reason and the outcome. The log turns recurring arguments into fixable causes.

Who signs off a change to a metric definition?

The programme owner, with the finance contact informed. Record the change and its effective date, then rebuild history where you can.