Skip to content

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

This page covers data licensing payout reconciliation: from deal price to the amount you receive.Illustrative

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.

The payout bridge: from deal price to cash the company keeps
LineItemWhat moves itDocument that proves it
AHeadline deal priceThe total stated in the signed agreement and any amendmentsSigned agreement and amendments
BLess amounts not yet earnedMilestones, refreshes or acceptance not yet reachedPayment schedule, acceptance notices
CLess contractual adjustmentsCredits for rejected records, scope reductions, rebates or penaltiesAcceptance report, credit notes, amendment
DEquals amounts invoiced to date, less amounts still openInvoices issued but not yet paid, disputed or past dueInvoice register and aging report
ELess deductions before paymentTax withheld at source, intermediary share, bank and currency chargesRemittance advice, withholding certificate, bank advice
FLess amounts held backHoldbacks or escrow retained until a later date or conditionAgreement clause, escrow statement
GEquals cash receivedMust match bank deposits for the period exactlyBank statement lines
HLess company deal expensesPreparation, review, legal, tax, storage, shipping and staff timePaid bills, time records, card statements
IEquals net retained before income taxCalculatedReconciliation workbook
JRecoverable items to trackOver-withheld tax, released holdbacks, disputed creditsRefund 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.

The itemized expense checklist
CategoryItemEvidenceCommonly missed because
Export and preparationContractor hours, scripts, export add-ons from the system vendorContractor invoices, vendor billsPaid from an IT budget, not the deal
De-identification and reviewRedaction tools, reviewer time, quality samplingTool invoices, reviewer time logsDone by staff whose time is not tracked
LegalCounsel for rights review, contract negotiation and amendmentsEngagement letters, legal invoicesBilled months after the work
Tax and accountingAdvice on withholding, treaty forms, revenue treatmentAdvisor invoicesTreated as general overhead
Storage and deliveryCloud storage, transfer costs, encrypted drives, shippingCloud bills, courier receiptsSpread across monthly bills
Internal staff timeHours from IT, operations, finance and leadershipTime records or a dated estimate by roleNot invoiced, so never counted
Ongoing obligationsRefreshes, deletion certificates, audits, reportingAgreement clauses, time recordsFall after the first payment
BankingWire, currency conversion and account chargesBank advices and statementsNetted inside a deposit
Disputes and creditsTime and credits from rejected records or late deliveryAcceptance reports, credit notesRecorded 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.

See if your company qualifies