Deal economics
Data licensing payout reconciliation: from deal price to the amount you receive
By SourceX Editorial · Reviewed by Noah Loul ·
10 sections
Short answer
Reconcile a data deal price to what your company actually receives with a payout bridge: start from the signed price, subtract amounts not yet earned, contractual credits, open invoices, deductions taken at source such as withholding tax, intermediary shares and bank charges, and holdbacks, until the result equals bank deposits. Then subtract your own deal expenses. Every line needs a document; anything without one is an open item.
Value drivers
Data licensing payout
Key takeaways
- A payout bridge explains every difference between the signed deal price and the cash in the bank, one documented line at a time.
- Tie each payment three ways: to the agreement, to the invoice it settles and to the bank line where it landed.
- Withholding tax, intermediary shares, bank charges and holdbacks are deducted before the money arrives; each needs its own document.
- Conditional payments move the result most; they stay on the not-yet-earned line until the condition is met.
- Never net away an unexplained difference; carry it as an open item with an owner until a document clears it.
How do you reconcile a headline data deal price with net supplier proceeds?
Build a payout bridge: start from the price in the signed agreement, then subtract, one labeled line at a time, amounts not yet earned, contractual adjustments, amounts invoiced but unpaid, deductions taken before payment such as withholding tax, intermediary shares and bank charges, and amounts held back. The result must equal cash in the bank. Then subtract the company's own deal expenses to reach what it actually keeps.
Every line needs a document behind it: the agreement, an acceptance notice, an invoice, a remittance advice, a withholding certificate, a bank statement or a vendor bill. A line without a document is an unexplained difference, and unexplained differences are what the reconciliation exists to find.
This page gives the bridge as a template, an itemized expense checklist, a step-by-step tie-out for each payment, an illustrative worked example and the situations where the bridge will not close on its own. It deliberately uses no amounts: the method is the same whatever the size of the deal.
How is payout reconciliation different from estimating net proceeds?
Estimating net proceeds happens before signing and asks what the company expects to keep from an offer. Payout reconciliation happens after money starts to arrive and asks whether what arrived matches what the agreement and invoices say should have arrived, and where every difference went. The first is a forecast; the second is an audit trail.
Both use similar lines, but they answer different questions and use different evidence. The forecast uses offer terms and quotes. The reconciliation uses remittance advices, bank statements, tax certificates and paid bills. When the two disagree, the reconciliation is the record and the forecast is what you learn from for the next deal.
Run the reconciliation at every payment, not once at the end. Data license payments often arrive in parts tied to delivery, acceptance or later refreshes, and a difference that is obvious at the first payment is hard to trace after three.
The payout bridge: from deal price to cash the company keeps
The bridge runs top to bottom. Lines A to F explain the gap between the headline price and the cash received; lines G and H explain the gap between cash received and cash kept. Fill it in per payment and cumulatively for the deal.
| Line | Item | What moves it | Document that proves it |
|---|---|---|---|
| A | Headline deal price | The total stated in the signed agreement and any amendments | Signed agreement and amendments |
| B | Less amounts not yet earned | Milestones, refreshes or acceptance not yet reached | Payment schedule, acceptance notices |
| C | Less contractual adjustments | Credits for rejected records, scope reductions, rebates or penalties | Acceptance report, credit notes, amendment |
| D | Equals amounts invoiced to date, less amounts still open | Invoices issued but not yet paid, disputed or past due | Invoice register and aging report |
| E | Less deductions before payment | Tax withheld at source, intermediary share, bank and currency charges | Remittance advice, withholding certificate, bank advice |
| F | Less amounts held back | Holdbacks or escrow retained until a later date or condition | Agreement clause, escrow statement |
| G | Equals cash received | Must match bank deposits for the period exactly | Bank statement lines |
| H | Less company deal expenses | Preparation, review, legal, tax, storage, shipping and staff time | Paid bills, time records, card statements |
| I | Equals net retained before income tax | Calculated | Reconciliation workbook |
| J | Recoverable items to track | Over-withheld tax, released holdbacks, disputed credits | Refund claims, release notices, dispute log |
How do you tie each payment to the contract, the invoice and the bank?
Tie each payment three ways: to the agreement, to the invoice it settles and to the bank line where it landed. The steps below work in any accounting system, from QuickBooks or Xero to NetSuite.
When money passes through a payment processor or an intermediary, the bank deposit is a batch, not a single payment. Stripe's documentation, for example, describes a payout reconciliation report that matches each bank payout to the batch of payments, refunds, disputes and fees it settles, and a separate bank reconciliation feature that marks payouts as reconciled or unreconciled against bank deposits. Whatever the channel, ask for the equivalent statement and reconcile through it.
An intermediary that collects from the buyer and remits to the company should provide a statement per remittance showing the gross amount collected, each deduction under the agreement and the net remitted. Reconcile that statement to the agreement as well as to the bank.
- Record each bank deposit with its date, payer name, currency and amount exactly as the bank shows it, before matching anything.
- Match the deposit to the remittance advice or payment notice the payer sent. If none arrived, ask for one; a deposit without a remittance cannot be allocated reliably.
- Match the remittance to one or more invoices. Note partial payments, payments that settle several invoices and payments that reference no invoice.
- For each invoice, compare the amount invoiced with the amount paid and classify every difference as timing (will arrive later), deduction (taken at source with a document) or dispute (no agreement yet).
- Tie each invoice back to the payment schedule in the agreement and confirm the milestone or acceptance it depends on actually occurred.
- Post deductions to their own accounts rather than netting them against revenue silently, so tax certificates, intermediary statements and bank charges can be checked later.
- Carry open items to a dated list with an owner, and clear them only with a document.
Which deductions are taken before the money arrives?
Three deductions commonly reach the company before the money does, and each has its own evidence.
Withholding tax at source. When a buyer in one country pays a company in another, the payer may be required to withhold tax. In the United States, the IRS describes Form 1042-S as the information return a withholding agent uses to report certain income paid to foreign persons and the tax withheld. Ask for the certificate the payer's country issues, because without it the company may not be able to claim the tax it lost. The IRS also notes that where a treaty entitles a taxpayer to a reduced rate, only the treaty-rate tax qualifies for the U.S. foreign tax credit; tax withheld above that rate has to be recovered from the foreign country instead.
Bank and currency charges. Cross-border wires can arrive short because a correspondent or receiving bank deducted a charge. Within the EU, the Payment Services Directive provides that where both payment service providers are in the Union, the payee pays the charges levied by its own provider and the payer pays the charges levied by its provider. Outside that scope, who bears charges depends on the payment instruction and the agreement, so check both before treating a short wire as an underpayment.
Intermediary shares and the gross versus net question. If an intermediary collects the full price and remits net, the company must decide whether to record the gross price with a separate expense or only the net amount received. Under IFRS 15 that depends on whether the company is a principal or an agent for the arrangement, which turns on the specific facts and contract terms. Agree the treatment with your accountant before the first payment, because it changes what line A means in your books.
The itemized expense checklist
The company's own expenses are the second half of the bridge, and they are the half most often left incomplete. Use this checklist to make sure each cost has been captured with evidence before line I is reported.
| Category | Item | Evidence | Commonly missed because |
|---|---|---|---|
| Export and preparation | Contractor hours, scripts, export add-ons from the system vendor | Contractor invoices, vendor bills | Paid from an IT budget, not the deal |
| De-identification and review | Redaction tools, reviewer time, quality sampling | Tool invoices, reviewer time logs | Done by staff whose time is not tracked |
| Legal | Counsel for rights review, contract negotiation and amendments | Engagement letters, legal invoices | Billed months after the work |
| Tax and accounting | Advice on withholding, treaty forms, revenue treatment | Advisor invoices | Treated as general overhead |
| Storage and delivery | Cloud storage, transfer costs, encrypted drives, shipping | Cloud bills, courier receipts | Spread across monthly bills |
| Internal staff time | Hours from IT, operations, finance and leadership | Time records or a dated estimate by role | Not invoiced, so never counted |
| Ongoing obligations | Refreshes, deletion certificates, audits, reporting | Agreement clauses, time records | Fall after the first payment |
| Banking | Wire, currency conversion and account charges | Bank advices and statements | Netted inside a deposit |
| Disputes and credits | Time and credits from rejected records or late delivery | Acceptance reports, credit notes | Recorded as reduced revenue only |
Illustrative worked example: two milestones, one intermediary, one short wire
This example is illustrative and uses no amounts. The company, the parties and the sequence are invented to show how the bridge classifies differences.
A U.S. distributor signs a license for five years of order and returns history. The agreement pays in two parts, the first on delivery and the second on the buyer's acceptance of a quality sample, and the buyer pays through an intermediary that remits net of its share under a separate agreement with the company.
At the first payment, the deposit is lower than the first invoice. The intermediary's statement shows its share as a deduction, which goes to line E with the statement as evidence. A residual difference remains; the bank advice shows a correspondent charge on the incoming wire, which also goes to line E. The bridge now closes for the first payment.
At acceptance, the buyer rejects a batch of records with broken links between orders and returns. The agreement allows a credit for rejected records, so the second invoice is issued net of a credit note, recorded on line C. The company's time fixing the export and its counsel's review of the credit clause go to line H.
The exception: the buyer later asks for a refresh the agreement does not cover. Payment for it belongs in a new line A after an amendment is signed, not as an unexplained surplus in the original bridge.
Which line of the payout bridge moves the most?
Which payments are conditional usually has the largest effect. Amounts tied to acceptance, refreshes or later milestones sit on line B until they are earned, and if conditions are not met they never arrive. IFRS 15 treats such amounts as variable consideration and lists discounts, rebates, refunds, credits, incentives, performance bonuses and penalties among the things that make consideration vary, along with entitlement that depends on a future event.
After conditionality, tax withheld at source and the gross versus net treatment of intermediary shares move the reported result most. Neither changes the cash that arrived, but both change what the company reports and whether some of the gap can be recovered later.
For deals priced on usage or royalties rather than a fixed price, the largest assumption is the buyer's own count. The bridge then depends on buyer statements, and the company's protection is an audit or reporting clause in the agreement.
When does a payout difference need escalation?
Stop and escalate when a difference cannot be tied to any document after one request to the payer, when tax was withheld without a certificate, or when a deduction appears that the agreement does not mention. Do not net it away to make the bridge close.
Narrow the scope of the first reconciliation to one payment and one channel if the deal uses several, then extend it. A bridge that closes for the first payment is the template for the rest.
Request specialist review for cross-border withholding, treaty claims and foreign tax credits, for the principal versus agent judgment and for any dispute over credits or acceptance. This page is general information, not tax, accounting or legal advice; counsel and advisors review the specific facts.
Setting up a deal so its payments reconcile
Reconciliation is easier when the agreement names the payment schedule, the acceptance test and the deductions in advance, because each bridge line then points to a clause.
Under SourceX's process, payment is one defined stage of the work, next to qualification, rights review, contracting, preparation and delivery, and the company approves scope and terms before any records leave it. Because the agreement exists before the first export, every bridge line has a clause to point to from the start.
The bridge template can wait until terms exist; the opening step with SourceX is a short company assessment with nothing uploaded.
Frequently asked questions
Why is the amount we received lower than the invoice?
The usual causes are tax withheld at source, an intermediary's share, bank or currency charges, a holdback or a credit for rejected records. Each should appear on a remittance advice, certificate, statement or bank advice. If none explains the difference, ask the payer for a remittance before recording anything.
Is tax withheld by a foreign buyer lost?
Not necessarily. Depending on the countries involved, it may be creditable against home-country tax or partly recoverable from the foreign country, for example where more was withheld than a treaty rate allows. Keep the withholding certificate and ask a tax advisor before filing.
Who pays wire charges on an international payment?
It depends on the payment instruction, the banks involved and the agreement. Within the EU, the Payment Services Directive generally has each party pay its own provider's charges when both providers are in the Union. Outside that scope, check the agreement and the bank advice before treating a short wire as an underpayment.
Should we record the gross price or the net amount an intermediary remits?
That depends on whether your company is the principal or an agent in the arrangement under the accounting framework you report under, which turns on the contract terms and facts. Agree the treatment with your accountant before the first payment so the bridge and your books start from the same line A.
How long should we keep reconciliation records?
Keep them at least as long as your tax and accounting retention rules and the agreement's audit clause require, whichever is longer. Store the bridge, every document behind each line and the open-items log together.
Sources
- IFRS 15 lists discounts, rebates, refunds, credits, price concessions, incentives, performance bonuses and penalties as sources of variable consideration, and sets a principal versus agent framework in paragraphs B34 to B38. Source
- The Payment Services Directive provides that for payments within the Union where both providers are located there, the payee pays its provider's charges and the payer pays its provider's charges. Source
- The IRS describes Form 1042-S as the information return withholding agents use to report certain income paid to foreign persons and the tax withheld. Source
- The IRS states that where a treaty entitles a taxpayer to a reduced rate of foreign tax, only the treaty-rate tax qualifies for the foreign tax credit. Source
- Stripe's payout reconciliation report matches each bank payout to the batch of payments, refunds, disputes and fees it settles. Source
- Stripe's bank reconciliation feature matches payouts with bank deposits and labels each payout reconciled or unreconciled. Source
See if your company qualifies
A short company assessment. No data uploads are needed.