Affiliate Reporting: Preserve Negative Adjustments When Calculating Net Commission

An affiliate commission export may contain positive earnings and negative adjustments. A spreadsheet that drops negative rows can produce an attractive total that no longer represents the exported net amount. For performance marketing media buying, the first task is to understand each row's meaning before using the report to judge a traffic source.

The workflow below is a proposed reconciliation method. The field names and examples are illustrative, and actual network or advertiser definitions must be checked separately.

Establish whether rows are events or current balances

Ask whether the export contains transactions that should be summed, the latest state of each order, or a mixture of both. An event report might contain an original commission and a later reversal. A current-state report might already replace the original amount with an adjusted value. Combining these models can subtract the same change twice.

Record the report type, export time, date filter and account currency. Keep the original file intact. Do not infer a row's meaning from its negative sign alone: inspect documented adjustment types and any reference to the original order.

Reconcile signed values before filtering

In a hypothetical event-based export, positive entries total 240 units of one currency and negative adjustments total -35. The signed net total is 205. Reporting 240 as net commission overstates that export by 35. These are arithmetic examples, not actual campaign results.

Present positive entries, negative adjustments and their signed total together. If the source uses parentheses or a separate debit column, convert the format deliberately and check sample rows against the source. A displayed minus sign should not disappear during numeric conversion.

Keep unresolved adjustments visible

Where an adjustment has a reliable order or campaign reference, use the documented mapping. Where it does not, retain an unallocated adjustment line instead of assigning it to the largest campaign or dropping it. The campaign breakdown should reconcile to the report total, including unresolved amounts.

An adjustment posted this week may relate to an older order. Separate the question “what changed in this reporting period?” from “what did this acquisition cohort ultimately earn?” Moving amounts between views requires a defined rule and evidence linking the adjustment to the original event.

Build a compact review record

• Report type and included transaction statuses.
• Positive amount, negative amount and signed net amount.
• Currency and reporting period.
• Mapped and unallocated adjustment totals.
• Any unresolved difference from the source report.

Do not describe the signed net as cash received unless payment evidence supports that statement. Pending approval, payment timing and other report definitions may still separate an operational commission total from settlement.

For media buyers comparing ecommerce CPS and virtual-product campaigns, this reconciliation is a prerequisite to interpreting profitability. It does not by itself establish why an adjustment occurred or whether a campaign should scale. Preserve the signed evidence first, resolve the reporting definitions, then assess performance using comparable amounts.