# Marketplace payout reconciliation (Amazon, Shopify)

> Marketplace payout reconciliation (Amazon, Shopify): Sales, fees, returns, reserves in each payout Checked: proven by code. Produces reconciled payouts, entries.

Source: https://www.sumarity.ai/library/marketplace-payout-reconciliation/

Retail, hospitality and consumer 

# Marketplace payout reconciliation (Amazon, Shopify)

Reads marketplace settlement reports, orders, refunds. Produces reconciled payouts, entries. Code works out every figure, the Judgement Engine answers the narrow questions, and whatever stays uncertain goes to a person.

Proven by codeReconciliation and matching
Start from this workflowMore for retail and hospitality  

What it decides

## Narrow questions, each with a check behind it.

Sales, fees, returns, reserves in each payout
Proven by code. Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

| Reads | Marketplace settlement reports, orders, refunds 
| Produces | Reconciled payouts, entries 
| Who signs | A person on your team, with every figure traced to its document and every call on record 
| Process | Reconciliation and matching 
| Industry | Retail, hospitality and consumer    

See it run

## Every line, decided where it's safest.

An example run. Each stage lights up as a line is decided there; pick a stage to see its lines.

ReadsMarketplace settlement reports, orders, refundsCodeReads, matches, ties out and works out every figure.JudgementSales, fees, returns, reserves in each payout. Settles only when it clears the cutoff and code proves it.A personGets whatever stays uncertain, with the evidence. Their ruling tunes the next run.ProducesReconciled payouts, entries  
Marketplace payout reconciliation (Amazon, Shopify) · example run Example run  

| Date | Settlement line | Amount | Decided by  
| 05.09 | Settlement 1121Sales less fees and refunds ties | 12,840.20 | Code · tied 
| 05.09 | Reserve heldRolling reserve per the account terms · 0.93 | −1,500.00 | Engine · proven 
| 05.09 | FBA storage feeMatches the storage report · 0.94 | −212.40 | Engine · proven 
| 05.09 | Reimbursement lost inventoryExpected 4 units, got 2 | 48.00 | To a person 
| 19.09 | Settlement 1122Ties | 11,402.70 | Code · tied  
|  

Settled 4 To a person 1 Settled wrong 0      Illustrative lines. Amber rows are the Judgement Engine's calls; each settles only above its cutoff and when its check agrees.    

What it could save

## Your volumes in. Your hours out.

In our tests, between 24% and 42% of items still went to a person after tuning. Set your own share; a pilot measures it on your data.

Items per run 
Runs per month 
Minutes per item by hand 
Cost per hour

Share of items that still need a person: 30%  

By hand today80 ha month 
With Sumarity24 ha month, for the items people decide 
Saved56 hCHF 53,760 a year    

Related

## Start from what's closest.

### Reconciliation and matching in other work

Finance

### Bank reconciliation

Which ledger entry a bank line is; why a line is unmatched

Proven by codeTestedFinance

### Card and payment-processor settlement reconciliation

Which sales a payout covers; fee and chargeback lines

Proven by codeFinance

### Intercompany reconciliation

Which entries are the two sides of one transaction

Proven by code

### More for retail and hospitality

### Daily takings reconciliation (tills, cards, cash, bank)

Which deposits cover which days and sites

Proven by code

### Delivery platform payout reconciliation

Orders, commissions, refunds in each payout

Proven by code

### Supplier rebates and promotional allowances

Rebate earned under which agreement

Proven by code  

Questions

## What buyers ask

What happens when Sumarity isn't sure?

Nothing settles below the cutoff, or when the check disagrees. The item goes to a person in the inbox with what the engine saw, its best answer and the runner-up. The person's ruling is kept and tunes the next run.

How are its judgements checked?

Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

Can we change it to fit how we work?

Yes. Start from this workflow and describe your differences in plain words. The design assistant revises it, the validator checks it, your expert reviews it on the canvas, and your admin publishes it.

Does it read our files as they are?

Yes: spreadsheets and CSV in any layout, PDFs, bank formats and e-mail attachments. Sumarity suggests how each column maps, proves the mapping on a sample and remembers it once a person confirms it.

Where does our data go?

Sumarity runs in Zurich. Your data, backups and logs are stored in Switzerland.

How does it get better?

Your team's rulings become an answer key. Better questions and cutoffs are proposed, tested on data they haven't seen, and published only when your admin approves. It improves itself, with permission.

## Start from this workflow. Run it on your data.

A pilot runs alongside your own process for a few weeks, at our cost, and ends in a line-by-line comparison.

Talk to usBack to the library