You ran a campaign. You saw the clicks roll in. Then you checked your affiliate network and the commission count looks nothing like what you expected — or worse, it looked right for a week, then shrank. You're not imagining it. Affiliate commission discrepancies are one of the most frustrating and least-explained problems in affiliate marketing.
This guide breaks down exactly why the numbers don't match — and gives you a step-by-step reconciliation process to find the gaps, understand them, and prevent them from compounding.
The 6 Most Common Reasons for Commission Mismatches
Most affiliate commission discrepancies come from one of six root causes. None of them are random — once you know what to look for, most are immediately diagnosable.
When a user clicks your affiliate link, a cookie is set in their browser. That cookie has a fixed expiration — 30 days, 60 days, 90 days depending on the program. If the user converts after the cookie expires, you get nothing. If they clear their cookies, use a different browser, or switch devices between click and purchase, the attribution is lost. Your click count stays up. The commission never appears.
Your personal analytics tool (Google Analytics, your tracker) records a conversion the moment it happens. The affiliate network waits for the merchant's return/refund window to close before confirming the commission. This creates a timing gap — sometimes 30 to 90 days — where a sale exists in your data but the commission is still "pending" on the network. The counts look different because they're measuring different things at different points in time.
A commission can appear, look confirmed, and then disappear. This happens when the customer returns the product or initiates a chargeback with their bank. Merchants typically have 30–90 day return windows. Commissions approved during that window are subject to reversal. Networks process these as negative adjustments — so your balance drops without a new transaction being visible at first glance.
You're in one timezone. The affiliate network's servers run in another. A conversion that happens at 11:45 PM in your local time may be recorded at 4:45 AM the next calendar day in UTC. This creates date-level mismatches when you're comparing your reports to the network's reports — same conversion, different date bucket. Run weekly summaries rather than daily to minimize this noise.
Affiliate networks don't always show commission data in real time. Some networks batch-process conversions once or twice per day. Others have known delays of 24–72 hours between when a sale occurs and when it appears in your affiliate dashboard. If you're checking your dashboard within hours of a campaign going live, the numbers will naturally be lower than your internal tracking — they just haven't synced yet.
Networks filter traffic. If they detect suspicious click patterns — high volume from a single IP, bot-like behavior, or invalid referrer sources — those clicks get flagged and stripped from your commission count. Separately, some merchants run multi-channel attribution and apply deduplication rules: if the customer touched a paid ad and your affiliate link, the merchant may credit the last touch or the paid channel, not you. The network may not always communicate this clearly.
The key insight: Commission discrepancies are almost never random. Each one has a traceable cause. The reconciliation process below is designed to surface that cause systematically — not just help you accept the number that's lower.
Step-by-Step Reconciliation Process
Run this process monthly at minimum — weekly if you're running paid traffic campaigns where reconciliation speed directly affects budget decisions.
Export two data sets for the same time period: (1) your internal click and conversion data from your tracking tool or analytics platform, and (2) your affiliate network's commission report. Use the same date range, and note each network's timezone — CJ Affiliate and Awin both run on UTC, while some smaller networks use local time. Export as CSV so you can compare row by row.
Before comparing numbers, normalize the time windows. Convert all timestamps to the same timezone. If you're comparing weekly totals, make sure both datasets use Monday-to-Sunday weeks or Sunday-to-Saturday — mixing the two introduces phantom discrepancies. Strip the last 3 days from your comparison window to account for reporting delays: numbers from the last 72 hours are unreliable on most networks.
Never compare your total click count against confirmed commissions — they measure different stages of the funnel. Pending commissions are real but not locked. Confirmed commissions are finalized and payable. Run your reconciliation in two passes: first compare your expected commissions against pending (to catch attribution failures), then compare pending against confirmed (to understand reversals and delays).
Once you have both datasets aligned, calculate the gap: (your expected commissions) minus (network-reported commissions). A gap under 5% is normal and usually attributable to timezone offsets and reporting delays. A gap of 5–15% warrants investigation — look at cookie window coverage and check whether your tracking links are properly formatted. A gap over 15% is a signal that something is structurally broken: invalid traffic flags, deduplication conflicts, or a tracking integration issue.
Every major affiliate network (CJ, Awin, Impact, PartnerStack) provides a raw click log — not just commission totals, but individual click events with timestamps, sub-IDs, and status flags. Pull this for the same period. Compare it against your internal click data. If clicks appear in your system but not in the network's log, the tracking pixel or redirect isn't firing correctly. If clicks appear in the network's log but not your system, you have a tagging gap in your campaigns.
Create a separate line in your reconciliation for commission reversals. Don't let reversals muddy your conversion rate calculation — a reversal is a business event (return, chargeback), not a tracking failure. Track your reversal rate per network and per merchant over time. If one merchant consistently reverses 20%+ of commissions, that's a relationship issue, not a tracking issue. Commission reversals that exceed 10% on a network are worth surfacing to your affiliate manager directly.
How a Dashboard Tool Changes the Reconciliation Game
Manual reconciliation from spreadsheets is slow by design: you have to export from each network, normalize the data, and compare. With four or five networks, a single reconciliation pass takes 45–90 minutes.
A unified affiliate dashboard like CommPilot compresses this to minutes. When all your networks feed into one view, you can see the pending-vs-confirmed split across every program simultaneously. Anomalies surface immediately — if one network's pending-to-confirmed ratio drops suddenly, you'll catch it in real time rather than discovering it a month later during a manual audit.
Dashboards also give you a consistent timeline across networks. Instead of each network's report using its own timezone and date conventions, CommPilot normalizes the data into a single view so you're comparing apples to apples. That alone eliminates the timezone mismatch category of discrepancy entirely.
See how to set up unified commission tracking: How to Track Affiliate Commissions: A Step-by-Step Guide.
Reconciliation Prevention Checklist
The best reconciliation is the one you don't need to do. These practices prevent discrepancies from accumulating in the first place.
Weekly Prevention Checklist
- Check that all tracking links are resolving correctly — broken redirects silently drop commissions
- Confirm your sub-ID tagging is consistent across campaigns so you can attribute conversions at the campaign level
- Review the pending commission count compared to last week — a sudden drop signals reversals worth investigating
- Verify that each network's click log shows activity for your active campaigns
- Note any network-side maintenance windows or data delays in your reconciliation log
Monthly Reconciliation Checklist
- Run the full 6-step reconciliation process above for each active network
- Calculate your reversal rate per network and compare to prior months
- Check cookie expiration dates for your highest-traffic programs — are they matching your typical sales cycle?
- Audit for any new deduplication rules or attribution policy changes from merchants
- Update your expected commission baseline using the last 90 days of confirmed data (not pending)
- Cross-link your top articles or landing pages to confirm they're using current tracking links
When to Escalate to the Affiliate Network
Not every discrepancy is something you can resolve yourself. Escalate directly to your affiliate manager or network support when:
- Your click log shows clicks recorded by the network, but zero conversions for a period where you have confirmed sales in your own analytics
- Your reversal rate spikes suddenly — especially if it happens across multiple merchants on the same network, which suggests a platform-side issue
- You see commissions disappear from the confirmed column without a corresponding reversal explanation
- The network's click log shows a gap (zero clicks) during a period where your internal analytics confirms normal traffic
When escalating, bring three things: the date range, the specific discrepancy amount, and your click log export showing the gap. Affiliate managers can resolve tracking issues faster when they don't have to start from scratch.
Frequently Asked Questions
Why do my affiliate commission counts differ between my tracking tool and the network?
The most common cause is a difference in attribution windows. Your tracking tool may count a click-to-conversion immediately, while the affiliate network waits until the merchant's cookie window closes (often 30–90 days) before confirming the commission. Additionally, timezone offsets mean a conversion at 11 PM in your timezone might be attributed to a different calendar day by the network's servers.
What causes affiliate commissions to disappear or reverse after they're shown as pending?
Three things cause commission reversals: returns and refunds (the merchant reverses the commission when a customer returns a product within the return window), chargebacks (the customer disputes the payment with their bank), and invalid traffic flags (the network determines the referring click violated their terms, such as coupon stacking or self-referral). These show as negative adjustments in your earnings report.
How long should I wait before investigating a missing affiliate commission?
Wait at least 7 days after a confirmed sale before investigating. Most networks confirm commissions within 30–60 days, but initial recording typically happens within 48–72 hours. If a commission that should have been recorded doesn't appear after 7 days, that's worth investigating — check your tracking link, the network's click log, and whether the conversion happened within the cookie window.
What's the difference between click count discrepancies and commission count discrepancies?
Click count discrepancies happen before conversion — your analytics shows more clicks than the network recorded, usually due to bot filtering or JavaScript blocking. Commission count discrepancies happen after a conversion is recorded but the commission amount or count differs — these are usually caused by deduplication rules, last-click attribution conflicts, or delayed reporting windows.
Can a dashboard tool help prevent affiliate commission discrepancies?
Yes, in two ways. First, a unified dashboard like CommPilot shows all networks' pending and confirmed commissions in one view, making it easy to spot anomalies the moment they appear. Second, having a single source of truth for all commission data means you can run a consistent reconciliation process on a weekly schedule rather than doing it ad hoc when something looks wrong.
Start Reconciling With a Clear Picture
Affiliate commission discrepancies are normal — but they shouldn't be invisible. The six root causes in this guide cover the vast majority of real-world mismatches. Run the reconciliation process once, and you'll immediately know which category your gap falls into.
The fastest way to make this process sustainable is to stop doing it manually across five separate network portals. CommPilot pulls all your commission data into one view — pending and confirmed, across every network — so discrepancies surface the day they happen, not the week you find time to audit. Start free and see your full commission picture in one place.
Once your reconciliation process is running smoothly, the next step is automating the data pulls themselves so you're not exporting CSVs from each network every week. See how in our guide: How to Automate Affiliate Reporting Across Multiple Networks.