Sample commission validation report
A sample AffCheck report: pending Awin transactions matched to Shopify refunds, with declines, amends, evidence and the batch file to upload.
By The AffCheck team · Updated
Sample report: 412 Awin transactions, checked. This is what an AffCheck validation report looks like for one month of pending Awin commission at a mid-sized Shopify apparel store. Every order, publisher and amount on this page is sample data, made up to show the format. Your own report comes from your network export and your Shopify orders.
Summary
Sample data · Awin pending transactions for January, matched on 10 February, five days before auto-approval.
| Line | Transactions | Commission |
|---|---|---|
| Pending in the Awin export | 412 | $4,812.60 |
| Matched to a Shopify order | 406 | |
| Suggested decline | 19 | $327.90 |
| Suggested amend (partial refund) | 4 | $84.40 → $42.20 |
| Not found in Shopify (check) | 6 | $61.40 |
| Approve as reported | 383 | |
| Commission not paid if you confirm | $370.10 |
The $370.10 is the declined commission ($327.90) plus the difference on the amends ($42.20). Nothing is declined until you confirm it; the report only suggests.
Declines, with evidence
Each suggested decline carries its reason code and the proof from Shopify, so a publisher query takes one click to answer.
| Order | Publisher | Reason | Evidence | Commission |
|---|---|---|---|---|
| #10482 | Content site | R01 Full refund | Refund #8812 · 12 Jan | $38.40 |
| #10503 | Content site | R03 Cancelled | Cancelled 8 Jan | $19.90 |
| #10530 | Voucher site | R05 Code owned by another publisher | JANE10 · owner Jane | $15.75 |
| … | 16 more | $253.85 |
Sample data. The receipt for the first line, as it appears in the app's evidence drawer:
The reason line under the receipt is the text that goes into the batch file, written for the publisher: "Order fully refunded on 12 Jan (refund #8812)."
Amends
A partial refund isn't a decline. On Awin you amend the sale amount and the commission is recalculated. Sample data:
| Order | Sale | Refunded | Kept | Commission before | Commission after |
|---|---|---|---|---|---|
| #10497 | $184.00 | $92.00 | $92.00 | $14.40 | $7.20 |
| … 3 more | $70.00 | $35.00 | |||
| Total | $84.40 | $42.20 |
Claimed twice
Order #10511 was reported by an Awin content site and by a CJ coupon site. Each network de-duplicates within its own platform, so both would be paid. Under a last-click policy the report keeps the earlier Awin claim here and puts the CJ claim on the CJ side of the report as a suggested decline, with the reason "Sale already credited to another channel". Sample data.
Voucher misuse
The code JANE10 belongs to Jane, a creator. It turned up on order #10530, claimed by a voucher site. Because the code-owner table says JANE10 is Jane's, the sale is flagged as unauthorised voucher use: a decline reason Awin lists among legitimate ones. Sample data.
Six transactions need a look
Six rows (sample data) had an order reference that doesn't exist in Shopify. They are marked Check, not Decline: often a test order, a typo in the tracking, or an order from another store.
The file to upload
On Awin Classic the confirmed decisions go in through Commission > Validate > Batch Process Commission > Manual Upload. Awin provides three templates on that page, and the report fills the matching file for each decision.
Accepted and declined file, per Awin's help centre:
| Order Reference | Transaction Date | Status | Status Note |
|---|---|---|---|
| 10482 | 01/03/2026 | Declined | Order fully refunded on 12 Jan (refund #8812) |
| 10530 | 01/06/2026 | Declined | Unauthorised voucher use: code JANE10 |
Amended file:
| Order Reference | Transaction Date | Status Type | Status Note | Sale Amount | Sale Breakdown | Currency |
|---|---|---|---|---|---|---|
| 10497 | 01/04/2026 | AMENDED | Part Return | 92.00 | DEFAULT:92.00 | USD |
Sample data, with US dates for a USD programme. Awin says the file must follow its template exactly and dates must use your programme's locale format, so download the template from your own programme and compare the header row before uploading. When you upload, tick "Contains column headings" and "Remove duplicates".
Get this for your own store
The report above took two exports: pending transactions from the network and orders from Shopify. Read how refund matching works, or follow the manual method for declining Awin commissions if you'd rather do it in a spreadsheet.
FAQ
Questions, answered
Is this real data?
No. Every order, publisher and amount in this report is sample data, made up to show the format. Your own report comes from your network export and your Shopify orders.
Does AffCheck decline these transactions for me?
No. The report suggests a decision and shows the evidence. You confirm each one and upload the file to the network yourself.
Related
- Refund matching Every pending transaction matched to its Shopify order. Full refunds and cancellations become declines, partial refunds become amends.
- Decline files Download the network’s batch file with your declines, amends and reasons filled in. Upload it in two minutes.
- Awin batch validation file builder (free CSV) Build Awin batch validation CSVs in your browser: add transaction IDs, choose accept, decline or amend, add reasons and download. Nothing is uploaded.
- How to decline Awin commissions for returns Step by step: export pending Awin transactions, match them to Shopify refunds, decline or amend, and upload the batch file before auto-approval.
See what you paid for last month.
Two exports, five minutes, a dollar figure for your store. Files never leave your browser.