Back to blog
Payment ReconciliationJul 31, 20262 min read

Payment Reconciliation for Marketing Teams: Net Sales and ROAS

Learn why ad platforms, storefronts, and finance show different revenue totals, and how refunds, discounts, and reporting dates affect retail ROAS.

Omnichannel Systems / Integration Foundation SprintPayment Reconciliationcommercialpayment reconciliation
B

Bilal Mehmood

Co-founder

Marketing teams use payment reconciliation when campaign revenue needs to agree with the sales and refunds finance reports. Start by agreeing which revenue measure belongs in your return on ad spend calculation. Attributed gross sales, retained net sales, and cash deposits answer different questions.

Decide which revenue number to use

Use attributed revenue to compare campaigns within the same attribution model. Use agreed net sales for contribution reporting when returns and discounts are material. Cash receipts are useful for treasury, but settlement delays and processor fees make them a poor substitute for daily campaign revenue.

Align reporting dates and identifiers

Keep the campaign identifier, commercial order ID, order date, refund date, currency, and channel. Agree on how to handle refunds that land in a later reporting period and when results are final enough to share. Use the same timezone and currency policy for spend and revenue.

Walk through an example

Suppose a campaign has $2,000 in order revenue after discounts, $300 in refunds attributed to those orders, and $500 in ad spend. Gross order revenue divided by spend is 4.0, while retained revenue divided by spend is 3.4 before taxes, fees, or other costs. Both calculations are useful when the dashboard names the numerator and exclusions.

Agree who resolves a mismatch

Marketing owns campaign mapping and attribution windows. Commerce operations owns order and return records. Finance owns the revenue definition and period-close treatment. Reconcile the records behind one campaign before revising how the entire dashboard calculates revenue.

When you need to trace provider payouts and bank deposits, start with the retail payment reconciliation controls. For exception aging and variance definitions, see the reconciliation KPI guide.

Next step

Need help applying this pattern?

Bring the bottleneck and the stack. We will map the first implementation path.