Why the affiliate line surprises finance
Most marketing costs are known when the work is delivered: media ran, an agency did the work, an event happened. The tutorial on estimating marketing accruals shows how a line owner estimates delivered work that has not been invoiced. The affiliate line is harder because the amount owed is still changing after the month ends. A sale tracked on the last day of the month may be returned next month and earn nothing. A conversion approved late may land in the next invoice. Bonuses and placement fees arrive on their own schedule.
The tracking guide explains the step in the middle: a tracked conversion is not yet a commission. The advertiser reviews pending conversions and approves, adjusts or rejects them before the platform invoices and pays, against grounds the terms set out, such as returns, duplicates, breaches and suspected fraud. The attribution and deduplication guide covers how returns and chargebacks affect credit.
Finance sees the result as surprises: a month that looked cheap followed by a large invoice, or a commission figure in marketing's report that does not match the ledger. The guide to tracking spend against budget separates committed, spent and invoiced money for the same reason, and explains that finance accepts estimates but not silence followed by a surprise. A routine that ends with one table, the same every month, removes most of the surprise.
When the surprise is a line that keeps growing faster than the sales it brings, the diagnosis of affiliate commission costs rising separates approvals made before the returns window closed from the other causes.
Before you start
- Platform access to pending, approved and rejected conversions with order references, partner, value, status and commission.
- Order system access to order status, cancellations, returns, customer flags and payment outcome by order reference.
- The terms, especially the validation grounds, the validation periodHow long the business has to review an affiliate conversion before approving its commission, long enough to cover returns and cancellations. and any partner-specific, promotional or bonus arrangements.
- Finance's calendar and codes: the month-end deadline for accrualsAn estimate of what was received in a month but not yet invoiced, booked so the cost lands in the month that benefited rather than whenever the invoice arrives., the cost codes for commission, platform fees and placement fees, as the tutorial on mapping marketing spend to finance codes agrees them, and how finance classifies commission.
- History: past months' pending values and how much of each was finally approved, by partner type.
- Owners. Who validates, who approves in the platform, who signs off the invoice and who sends the report. A RACI matrix settles it; the affiliate programme launch checklist asks for a named commission approver before the programme opens.
The steps
Pull the month's conversions by status
At the same point each month, export every conversion the platform recorded for the month, with its status: pending, approved, rejected. Include the order reference, partner, order value, customer flag and commission. Export the conversions from earlier months still pending too, because they will be decided in this one.
Validate pending conversions against the order system
Match each pending conversion to the order system by reference. Mark conversions whose orders were cancelled or returned within the validation period, duplicates the DeduplicationRemoving double counts when one conversion is reported by more than one source. rule should have removed, test orders, staff orders, orders using a code issued to another partner, and anything else the terms exclude. Check customer flags where new and returning customers earn different rates, as the commission structures guide recommends paying them. The tracking guide lists the usual grounds for rejection; apply only the grounds the terms state. Where a partner's pattern looks wrong rather than a single order, open a case through the tutorial on investigating suspected affiliate fraud rather than rejecting in bulk.
Approve, adjust or reject inside the platform's window
Record the decisions in the platform before its approval date passes: approve the valid conversions, adjust those paid at a different rate, reject the rest with the reason. Conversions whose returns window is still open stay pending until it closes, as the terms allow. Commission approved by default because nobody acted is the most expensive mistake in the routine. Keep a note of the counts and values in each status.
Check the totals against the order system and analytics
Reconcile the month: approved conversions in the platform, qualifying orders in the order system and affiliate traffic in analytics should tell a consistent story, as the tracking guide describes. Where partners say sales are missing, or the platform shows far fewer conversions than orders with affiliate clicks, the tutorial on tracing missing affiliate conversions finds the cause. Record any gap you cannot yet explain.
Estimate commission still owed on pending conversions
For the conversions still pending at month end, estimate how much commission will finally be approved. Use the business's own history: the share of pending commission approved in past months, separately for partner types whose returns and rejections differ. Add bonuses earned in the month and placement fees for placements that ran but have not been invoiced. The accruals tutorial covers how to write the figure with its evidence, and finance decides how to book it.
Match the invoice or payout to the approvals
When the network's invoice or the platform's payout statement arrives, compare it line by line with the approvals you recorded: commission by partner, adjustments, bonuses, placement fees and the network's or platform's own fee. Follow the tutorial on purchase orders and invoice approval: match each line to the order and the evidence, query differences before approving, and file the evidence.
Check the coding of commission, fees and placements
Commission, platform or network fees and placement fees are different kinds of cost, and finance may code them differently. The marketing P&L guide records that affiliate commission may sit in cost of sales or as a reduction of revenue rather than in operating expense, and that the treatment is a company accounting policy. Check each line carries the code finance has agreed, and that placement fees, which are paid whether or not sales follow, are not mixed into commission.
Report the month in one consistent view
Send finance and the programme owner the same table each month: tracked, pending, approved, rejected, invoiced and paid, with the estimate for pending commission and the explanation of any difference from last month. Add the measures the programme owner needs from the reporting and incrementality guide, such as cost of sale after returns and fees, so both audiences read the same numbers. Make the table agree with the ledger line, using the monthly reconciliation the spend tracking guide describes.
Compare last month's estimate with what arrived
When last month's pending conversions are decided and the invoice is matched, compare the estimate with the result. If it keeps missing in one direction, adjust the method: split partner types differently, change the history period, or treat a partner with unusual returns on its own. The accruals tutorial ends with the same habit, and it is what makes the estimate trustworthy over time.
Tracked, pending, approved, invoiced, paid
| Status | Meaning | Where it is recorded | Who acts |
|---|---|---|---|
| Tracked | The platform recorded a conversion against a partner | Affiliate platform | Nobody yet; it is a claim, not a cost |
| Pending | Awaiting validation within the validation period | Affiliate platform | Programme team validates against the order system |
| Approved | Validated; commission is owed | Affiliate platform; month-end table | Programme team approves; finance is told the value |
| Rejected or adjusted | Not payable, or payable at a different rate, under the terms | Affiliate platform, with the reason | Programme team; the partner can see the reason |
| Estimated | Commission expected on conversions still pending at month end | Month-end note to finance | Programme team estimates; finance books as it decides |
| Invoiced | Billed by the network, or set out in the platform's payout statement | Invoice or statement; finance's records | Budget owner matches and approves |
| Paid | Settled with the network or the partners | Finance's records | Finance |
The labels differ between platforms; the stages do not. Keeping the same columns in the monthly report means anyone can see how much of the month's cost is still an estimate.
A camera retailer closes March (illustrative)
Lenzwick Cameras closes a month's affiliate line
Lenzwick Cameras, an invented camera equipment retailer, pays 5% on returning customers and 8% on new customers, with a 30-day returns window and a validation period of 35 days in its terms. On 3 April it exports March: 1,860 conversions, £612,000 in order value and £41,300 in commission, all pending.
Matching against the order system, it rejects 48 duplicates and test orders and 97 orders returned or cancelled so far, adjusts 64 orders flagged as new customers that the order system shows as returning, and approves 1,120 orders whose returns window has closed. That leaves 531 conversions, worth £11,900 in commission, still inside the returns window. Over the past six months Lenzwick has finally approved 86% of commission pending at month end for content partners and 74% for voucher partners. Applying those shares by partner type, it estimates £9,700 still owed, and adds a £1,500 bonus earned by one review site and a £2,000 placement fee for a March newsletter feature.
When the network's invoice arrives, it shows £27,900 of approved commission against Lenzwick's record of £28,350. The difference is 21 conversions it approved after the network's cut-off for the March invoice, which fall into April's. The network's fee appears as a separate line. Lenzwick sends finance one table: approved £28,350, estimated £9,700, bonus £1,500, placement £2,000, network fee on its own line, coded as finance agreed, with commission in cost of sales as finance's policy places it. The table agrees with the ledger. In May, when March's pending conversions are decided, £9,400 is approved against the £9,700 estimate.
Verify it worked
- Check the status counts. The pending, approved and rejected counts and values should account for every conversion in the export.
- Compare approved conversions, qualifying orders and affiliate traffic. They should tell a consistent story, with any unexplained gap recorded.
- Match the invoice to your approvals line by line. Every difference should have an explanation, as with the Lenzwick difference in the example.
- Check the coding. Commission, fees and placement fees each carry the code finance agreed, and placement fees sit apart from commission.
- Compare the month-end table with the ledger line. They should agree, and the table should show how much of the cost is still an estimate.
If it goes wrong
- The invoice differs from your approvals. Likely causes are conversions approved after the cut-off, adjustments, bonuses, placement fees or the network's fee. Query the difference before approving.
- The platform shows far fewer conversions than orders with affiliate clicks. Tracking may be losing conversions. Record the gap and trace it before reporting.
- Commission was approved by default. The approval date passed with nobody acting. Check what was paid on returns, duplicates and fraud, then name the approver.
- The estimate keeps missing in one direction. The method is too blunt. Split partner types differently, change the history period or treat an unusual partner on its own.
- The table will not agree with the ledger. Commission may be classified differently or counted twice. Ask finance how it books commission and label it the same way.
Next steps
- Read the accruals tutorial to rework the pending-commission estimate when it keeps missing.
- Read the attribution and deduplication guide when duplicates and returns keep arriving in validation, to see how credit is set.
- Read the reporting and incrementality guide to choose the measures that sit beside the month-end table for the programme owner.
Common mistakes
- Letting the approval date pass. Commission approved by default before anyone validated it is paid on returns, duplicates and fraud.
- Approving before the returns window closes. A partner's Return RateShare of orders or units sold that customers sent back. only shows once returns are in. Validate after the window closes, or accept that some commission will be paid on returned orders.
- Reporting tracked commission as cost. Tracked is a claim; report approved, estimated and invoiced separately.
- Estimating from a generic rate. Use the business's own history by partner type, not a figure from elsewhere.
- Mixing placement fees and commission. A placement fee is paid whether or not sales follow; code and report it separately.
- Deciding the accounting in marketing. Whether commission sits in cost of sales or marketing expense is finance's policy.
- Counting commission twice. Where commission sits in cost of sales, it is already inside gross margin; do not subtract it again in marketing's contribution view, as the marketing P&L template warns.
- Never checking the estimate. Compare each month's estimate with what was finally approved, and adjust the method when it keeps missing. The break-even calculator and the Contribution MarginRevenue left after every cost that varies with each sale. per order keep the cost of the month in proportion to what it earned.
