Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Affiliate Marketing › Affiliate Measurement

Closing the Month on Affiliate Commissions

How to close each month on affiliate commissions: validate pending sales, approve, estimate what is owed, match the invoice and report cost to finance clearly.
Tutorialintermediate10 min readUpdated

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 period and any partner-specific, promotional or bonus arrangements.
  • Finance's calendar and codes: the month-end deadline for accruals, 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

  1. 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.

  2. 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 Deduplication 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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

StatusMeaningWhere it is recordedWho acts
TrackedThe platform recorded a conversion against a partnerAffiliate platformNobody yet; it is a claim, not a cost
PendingAwaiting validation within the validation periodAffiliate platformProgramme team validates against the order system
ApprovedValidated; commission is owedAffiliate platform; month-end tableProgramme team approves; finance is told the value
Rejected or adjustedNot payable, or payable at a different rate, under the termsAffiliate platform, with the reasonProgramme team; the partner can see the reason
EstimatedCommission expected on conversions still pending at month endMonth-end note to financeProgramme team estimates; finance books as it decides
InvoicedBilled by the network, or set out in the platform's payout statementInvoice or statement; finance's recordsBudget owner matches and approves
PaidSettled with the network or the partnersFinance's recordsFinance

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)

Illustrative example — not a real result

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

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 Rate 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 Margin per order keep the cost of the month in proportion to what it earned.

Frequently asked questions

Is affiliate commission a marketing cost or a cost of sales?

That is finance's decision. The marketing P&L guide records that costs varying directly with each sale, such as affiliate commission, may be treated as cost of sales or as a reduction of revenue, while most marketing spend is usually operating expense, and that the treatment is a company accounting policy. Ask finance how the business treats it, then make sure marketing's own reports label commission the same way and do not count it twice.

How do we estimate commission on sales still pending at month end?

From your own history. Take the commission value of conversions still pending and apply the share that has typically been approved in past months, separately for partner types that behave differently, such as content and voucher partners. The accruals tutorial covers how to write the estimate and check it against what arrives. This site gives no typical approval rate, because it depends on your products, returns and partners.

What if the network's invoice does not match our approvals?

Do not approve it until the difference is explained. Compare the invoice line by line with the approvals the platform recorded: conversions approved after the cut-off, adjustments, bonuses, placement fees and the network's own fee are the usual causes. Query anything you cannot explain before approving, as the purchase orders and invoice approval tutorial describes, and record the explanation so next month's match is faster.

Terms used on this page

Tools to try

Frameworks

Where this page is used

Related