An affiliate dashboard can show clicks, orders and estimated commission without telling you what will actually reach your bank account. Transactions may still be pending, waiting for validation, adjusted, held below a payment threshold or included in a later payout. If you compare only the headline earnings figure with the deposit, an ordinary timing difference can look like a missing payment.
Affiliate commission reconciliation is the practical process of matching the programme's transaction records, current statuses, applicable terms and payout evidence. The aim is not to prove that every click produced a sale. It is to explain, row by row, how eligible commission moved from tracked activity to an actual payment.
This guide gives a small publisher a repeatable evidence log, a five-step monthly workflow and a calm way to escalate a genuine mismatch. Platform labels and payment rules vary, so confirm the current documentation and your own agreement. This is an operational framework, not accounting, tax or legal advice. For the wider strategy, start with the Prodify Digital affiliate marketing framework.
What affiliate commission reconciliation actually checks
A reconciliation compares records that answer different questions. Your content analytics may show that a visitor clicked a link. The affiliate platform may show that an order or other qualifying action was tracked. A transaction report shows its current status. A payment report shows what was included in a payout. Your bank or payment account confirms what arrived.
Those records should not be treated as interchangeable. A click is not a commission. A tracked transaction is not necessarily approved. An approved amount may not yet be payable. A processed withdrawal may take time to appear in a bank account. The platform's own terminology determines what each state means.
Current primary documentation illustrates that variation. Awin's Publisher Transaction Report separates pending, approved and declined transactions, and lets publishers filter for the next payment or payment history. Amazon Associates publishes a separate payment schedule and history help area. impact.com provides pending-action, balance and withdrawal reports, including a withdrawal details report that breaks a withdrawal down by programme and activity month. These pages were checked on 7 October 2026.
Start with one normalised reconciliation row
You do not need to copy an entire network dashboard into a spreadsheet. Keep the original export or statement as evidence, then create one normalised row for each programme, payout period or material discrepancy. The purpose is to make unlike platforms comparable without pretending that their statuses are identical.
Reconciliation ID: [unique reference]
Programme or network: [name]
Account and currency: [publisher ID / currency]
Reporting period: [start and end dates]
Source export: [filename and export time]
Applicable terms: [version/date or saved link]
Tracked amount: [if the platform provides it]
Pending amount: [not yet validated or locked]
Approved amount: [validated under the platform's definition]
Adjustments: [declines, reversals, fees, tax or other movements]
Payable amount: [currently scheduled or available]
Payout reference: [invoice, paystub or payment ID]
Payout date and amount: [platform record]
Amount received: [bank or payment account]
Difference: [expected minus received]
Reason or status: [timing / threshold / adjustment / fee / unknown]
Evidence links: [exports, statements and support case]
Owner and next review date: [person / date]
Resolution: [open / explained / corrected / escalated]Keep amounts in their original currency until you have matched the source records. If a bank or intermediary converts the payment or charges a fee, record that as a separate movement. Otherwise, an exchange-rate difference can be mistaken for a commission error.
Use a five-step monthly workflow
1. Freeze the period and collect the source records
Choose a clear reporting period and record the timezone. Download the transaction export, the payment or withdrawal statement, any invoice or paystub, and the applicable programme terms. Save the export time because dashboards can change after validation, reversals or late adjustments.
Use a stable filename such as network-programme-2026-09-transactions.csv. Do not overwrite the original file with a cleaned version. Keep the source intact, then work from a copy or from the normalised log.
2. Separate statuses before adding amounts
Group transactions by the platform's real states before calculating a total. Pending activity belongs in a pending group; approved or locked activity belongs in its own group; declined or reversed entries belong in adjustments; only the platform-defined payable or paid group should be matched to a payout.
This prevents a common false alarm: comparing every tracked transaction with a payment that includes only validated activity. Awin explicitly notes that pending transactions have not yet been validated. impact.com's pending-actions guidance similarly distinguishes actions waiting for their locking date from later payout stages.
3. Rebuild the expected payout
Start with the amount the programme says is eligible for the payout, not the amount you hoped to earn. Then apply only documented movements: declined transactions, refunds or reversals shown in the report, bonuses, fees, tax entries, thresholds, currency conversion, prior balance and other clearly identified adjustments.
If the programme rules are unclear, return to the saved terms rather than guessing. The affiliate terms review guide explains how to capture qualification, reversal and payment rules before a promotion starts. Your reconciliation should point to the exact rule or report field used for each adjustment.
4. Match the payout reference to the deposit
Use the invoice, payment ID, paystub or withdrawal reference as the bridge between the affiliate platform and your bank or payment account. Match the date, currency and amount, then record any separately visible bank or intermediary fee.
Do not rely on the deposit description alone when one payment bundles several programmes or activity months. For example, impact.com's withdrawal report can show earnings by programme and activity month. The platform-level breakdown is more useful than trying to infer the contents of a combined deposit.
5. Classify the difference before escalating
Give every difference one of four working labels:
- Timing: the amount is pending, below a threshold, outside the payment cycle or processed but not yet received.
- Explained adjustment: the report shows a decline, reversal, fee, tax entry, currency movement or other documented change.
- Source mismatch: the periods, currencies, programme accounts or exports do not line up.
- Unexplained discrepancy: the source records align, the expected payment date has passed, and the difference still has no documented cause.
Only the last category is ready for a support case. This classification keeps the message precise and avoids asking a network to investigate a payment that is simply not due yet.
A worked hypothetical reconciliation
Suppose a publisher sees £640 in total tracked commission for September. The October payment is £485. The £155 difference looks serious until the records are separated by status.
The transaction export shows £95 still pending validation, £40 declined with a documented reason and £20 approved after the payout cut-off. The payment statement includes the remaining £485 and carries the same payout reference as the bank deposit.
The reconciliation is therefore:
- Tracked commission: £640
- Less pending validation: £95
- Less documented declines: £40
- Less approved after the cut-off: £20
- Expected current payout: £485
- Amount received: £485
- Unexplained difference: £0
This example does not imply that those status labels, dates or amounts apply to a particular network. It shows why the sequence matters: status first, arithmetic second, escalation last. The £20 still needs a next-review date so it is not forgotten during the following cycle.
Send a support message that can be investigated
When a genuine discrepancy remains, send the smallest complete evidence pack. Remove customer personal data and secrets. Include identifiers that the programme already exposes to you, but do not attach unrelated account information.
Subject: Payout discrepancy — [publisher ID] — [period] — [payout reference]
Hello,
I am reconciling the payout for [period] in [currency].
Publisher/account ID: [ID]
Programme/advertiser: [name]
Payout or invoice reference: [reference]
Platform payout date: [date]
Expected payable amount: [amount]
Amount received: [amount]
Unexplained difference: [amount]
I matched the same reporting period, currency and account. I separated pending, declined/reversed and post-cut-off transactions. The remaining difference is shown in the attached redacted evidence log and source export.
Please confirm which transaction or adjustment explains the difference, or advise the next investigation step.
Thank you.Record the case number, submission date, response and resolution in the same reconciliation row. If support identifies a changed offer, link destination or programme status, route that finding into the affiliate content maintenance system so the public content and the financial record do not drift apart.
Do not use the log for claims it cannot support
A reconciliation log can confirm how reported amounts moved through a programme's payment process. It cannot prove that every sale was attributed correctly, that a cookie or link worked for every visitor, or that one page caused a revenue change. Those questions require different evidence.
Use the affiliate link QA checklist to test destinations, redirects and tracking parameters before publication. Use the commission log later to match the programme's own transaction and payment records. Keeping those controls separate makes both of them clearer.
The log is also not your accounting ledger. Give your accountant or bookkeeper the official statements and bank records they require, and follow the rules that apply to your business and location. The reconciliation can organise evidence, but it should not invent tax, invoicing or revenue-recognition treatment.
Review exceptions, not every click
For a small publisher, a monthly review is usually more useful than watching estimates every day. Reconcile each material payout, carry forward pending items with a next-review date, and focus attention on unexplained differences or repeated adjustments.
After several cycles, look for patterns. If one programme repeatedly changes payment timing, record the current rule in the evidence pack. If one content source creates frequent attribution questions, improve its tracking IDs and link checks. If the same product produces reversals or becomes unavailable, review whether the recommendation should stay live. Do not turn one unexplained row into a claim about the whole programme without stronger evidence.
After reconciling a comparable baseline, use the affiliate commission stress test to model a rate change or payment delay. Keep those scenarios separate from the amounts your evidence log confirms.
The reconciliation log records what actually appeared; its companion affiliate attribution assumptions log records how the programme says attribution, validation and payment should work, so differences have a clear baseline.
Reader Q&A
What is affiliate commission reconciliation?
Affiliate commission reconciliation is the process of matching transaction statuses, applicable programme rules, payout records and the amount received so each difference is either explained, carried forward or escalated with evidence.
Why does tracked commission differ from the amount paid?
Tracked activity may still be pending, declined, reversed, below a threshold, outside the payout cut-off or affected by documented fees, tax or currency movements. Use the platform's current definitions and reports rather than assuming every tracked amount is payable.
How often should a small publisher reconcile affiliate payments?
Reconcile each material payout and run a short monthly review of open items. Low-volume programmes can be reviewed when a payout is due, while higher-volume accounts may need a more frequent exception check.
What evidence should I save for a payout query?
Save the original transaction export, payment or withdrawal statement, invoice or paystub, applicable terms, payout reference, bank or payment-account record, calculation and support case. Redact personal data and secrets before sharing evidence.
When should I contact the affiliate network or merchant?
Contact support when the same account, period and currency have been matched, the expected payment date has passed, known pending items and documented adjustments have been separated, and an unexplained difference remains.
Does reconciliation prove that affiliate tracking is accurate?
No. Reconciliation explains how the platform's recorded transactions became a payout. It does not prove that every eligible visitor or sale was tracked, so link QA and attribution testing remain separate controls.
Turn the next payout into an explainable record
Start with the next affiliate payment, not your entire history. Save the source export, separate the statuses, rebuild the expected payout and match it to one payment reference. Carry timing differences forward, document real adjustments and escalate only what remains unexplained.
A compact evidence log will not make every platform transparent. It will give you a dependable answer to the question that matters: what was expected, what was paid, and what evidence explains the difference?
Sources checked
- Amazon Associates payment schedule and history help.
- Awin Publisher Transaction Report.
- impact.com pending actions guidance.
- impact.com Withdrawal Details Report for Partners.
[…] payment-side exceptions, keep a separate affiliate commission reconciliation log that connects transaction status, applicable terms, payout evidence and the amount […]
[…] the figures together can count it more than once. If your records do not reconcile, first use the affiliate commission evidence log to establish what each figure […]
[…] If you also earn affiliate commissions, the same habit works there too. See How to Reconcile Affiliate Commissions With a Simple Evidence Log. […]