Marketplace and Partner Payout Reconciliation Agent
Reconciles marketplace, buy-now-pay-later and gift card partner payouts to receivables.
- Industry
- Retail
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Finance Controller
- Code
- FIN-19
It reconciles the payout files from online marketplaces, buy-now-pay-later providers and third-party gift card sellers to the receivables they should settle, and explains every difference, such as a marketplace commission above the agreed rate, a return deducted before the item came back or a gift card batch not activated. It proposes the entries and the claims back to each partner. **The problem it solves:** Why the partner's payout differs from the receivables it should settle, difference by difference.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the marketplace seller portal: the partner's payout file and order-level fees, with the matching receivables and returns from the order management system..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Finance Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's accounts receivable: it records the matches, posts the approved entries and logs the claims to each partner. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The partner settlement guide: each marketplace's commission and fee schedule, payout timings, return and refund deduction rules, buy-now-pay-later merchant fees, gift card partner commission and activation rules, and the matching rules.
Reads from
the marketplace seller portal: the partner's payout file and order-level fees, with the matching receivables and returns from the order management system.
Acts in
the ERP's accounts receivable: it records the matches, posts the approved entries and logs the claims to each partner.
Hands back
An object with matched_total, differences (a list of order_ref, amount, likely_cause, evidence and action), claims (a list of partner, reason, amount and deadline) and proposed_entries (a list).
Asks a person when
A difference is written off, or a claim to a partner exceeds the materiality limit.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Tolerance per order (USD) | 0.5 | Differences within this match. |
| Commission above the agreed rate that counts (percentage points) | 0.25 | Commission this far above the agreed rate is claimed back. |
| Partner claim window (days) | 60 | Claims must be raised within this after the payout. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Match each order line within 0.5 between the payout file and receivables.
- Explain each difference by weighing commission, fees, returns deducted early, cancelled orders, timing and missing orders.
- Claim back commission more than 0.25 points above the agreed rate, and returns deducted before the item was received.
- Raise every claim within 60 days of the payout.
- Never write off a difference without approval.
See the Marketplace and Partner Payout Reconciliation Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.