Your files never leave your device. All processing happens locally in your browser.
How do I reconcile a marketplace settlement / payout report against my orders?
Upload your marketplace settlement / payout report CSV (and optionally your orders export), map the order-id, transaction-type and amount columns, and the tool groups every line by order to show gross sales, fees, refunds and net payout, then flags unpaid and mismatched orders. It runs 100% in your browser — your financials are never uploaded.
Groups settlement lines by order → sales, fees, refunds, adjustments & NET payout
Optional orders file flags UNPAID, UNKNOWN and short-/over-paid orders
Exports a per-order + totals reconciliation report CSV
100% client-side — financials never uploaded; verify totals against your statement & bank
What is
Marketplace Settlement Reconciliation
Settlement reconciliation is grouping a marketplace payout report’s line items by order to confirm that gross sales minus fees, refunds and adjustments equals the net payout, and matching those orders against your own records to find unpaid or mismatched orders.
How to Reconcile a Marketplace Settlement / Payout Report in the Browser
Upload a marketplace settlement / payout report CSV (and optionally your orders export), map the order-id, transaction-type and amount columns, review the per-order dashboard and discrepancies, and export a reconciliation report — entirely in your browser.
4 minWeb browser
1
Upload the settlement report
Export your marketplace settlement / payout report (CSV) and drop it in, or paste the text. Add your own orders export (order id + total) to also catch unpaid and mismatched orders. Nothing is uploaded.
2
Map the columns
The tool auto-detects the Order ID, transaction type / amount-description and amount columns (plus an optional fee column). Adjust any mapping if needed. Without a type column, positive amounts are treated as sales and negatives as fees.
3
Review & export
Read the dashboard (gross sales, fees + breakdown, refunds, NET payout, fee %) and the discrepancies panel (unpaid, unknown, short/over-paid, negative-net, high-fee), then export the per-order + totals report CSV. Verify the totals against your statement and bank — this is not accounting advice.
Result:A per-order reconciliation report with net payout, fee breakdown and unpaid / mismatch flags
Frequently Asked Questions
A settlement report lists every transaction behind a payout — sales, fees, refunds and adjustments. Reconciliation groups them by order so the totals add up to your net deposit.
A settlement or payout report (Amazon Flat-File V2, Flipkart, eBay, Etsy, etc.) is a flat list of LINE ITEMS, each with a transaction type (Order, Refund, Fee, Adjustment, Service fee, Shipping, Tax), an amount (credits positive, fees and refunds negative) and usually an order ID. One order spans several lines — item principal, shipping credit, referral / commission fee, FBA / fulfilment fee, closing fee, tax and any refund. Reconciliation groups the lines by order to compute gross sales, total fees, refunds, adjustments and the NET payout, then rolls those up so the sum of every line equals the disbursement that hits your bank. This tool does that entirely in your browser and never uploads your data.
Add your own orders export (order id + total). Orders with no settlement line are unpaid; settlement orders not in your file are unknown; and each order’s net is compared to its expected total.
When you also upload your orders file, the tool matches it to the settlement on order ID. An order that appears in your file but has NO settlement line is flagged UNPAID / pending (it sold but the marketplace hasn’t paid out yet). A settlement order that is NOT in your file is flagged UNKNOWN (it isn’t in your books). For matched orders it compares the settled net against the order’s expected total and flags short-paid or over-paid orders beyond a small tolerance. It also flags negative-net orders and orders whose effective fee percentage is unusually high — the kind that point to ad spend, returns or fee errors worth investigating.
No. Both files are parsed and reconciled entirely in your browser. Nothing is uploaded, logged or stored, so it is safe for confidential financials.
Everything happens on your device. The settlement and orders CSVs are parsed with a real RFC-4180 parser and reconciled locally — there is no upload, no server, no CDN and no tracking, and the page works offline once cached. Because these reports reveal your real revenue, fees, payouts and customer order data, that matters: nothing you load ever leaves the page, and only the report you choose to export is saved. That is a genuine privacy win over cloud reconciliation tools that upload your whole financial report to a server just to total a few columns.
Treat it as a helper. Always verify the totals against your actual settlement statement and bank deposit. Fee labels vary by marketplace, and this is not accounting or tax advice.
This is a reconciliation HELPER that summarises and matches the report you provide — it does not connect to any marketplace. Always verify the net payout and fee breakdown against your actual marketplace settlement statement and your bank deposit before relying on them. How fees are categorised depends entirely on the report’s columns and labels, which differ by marketplace (Amazon, Flipkart, eBay, Etsy…) and change over time, so map the columns carefully and sanity-check the breakdown. The tool gives no accounting or tax advice; confirm classifications and figures with your accountant.
Detailed Explanation
📖How It Works
Seller Reconciliation — Reconcile a Marketplace Settlement / Payout Report in the Browser
Seller Reconciliation is a 100% client-side tool that takes a marketplace SETTLEMENT / payout report (CSV — Amazon Flat-File V2, Flipkart, eBay, Etsy, etc.) and, optionally, the seller’s own ORDERS export, and reconciles them entirely in the browser. A settlement report is a flat list of LINE ITEMS: each has a transaction TYPE (Order, Refund, Fee, Adjustment, Service fee, Shipping, Tax, Reserve), an AMOUNT (credits positive, fees and refunds negative) and usually an ORDER ID, and a single order spans several lines — item principal, shipping credit, referral / commission fee, FBA / fulfilment fee, closing fee, advertising, tax and any refund. PapaParse reads the file (so quoted fields and embedded commas survive) and the tool auto-detects the order-id, transaction-type / amount-description and amount columns (plus an optional explicit fee column and date). It then GROUPS the lines by order to compute gross sales, total fees, refunds, adjustments, tax and the NET payout per order, and rolls those up to portfolio totals whose sum equals the disbursement. The result is a dashboard (gross sales, fees + breakdown, refunds, net payout, effective fee %), a per-order table and a discrepancies panel, all exportable as a CSV.
Groups settlement lines by order → gross sales, fees, refunds, adjustments, tax, NET payout & effective fee %
Classifies transaction types and breaks fees down by label (referral/commission, FBA/fulfilment, closing, advertising…)
Sum of every line equals the disbursement that hits the bank — the core reconciliation check
Per-order table + fee breakdown + discrepancies panel, exportable as a per-order + totals report CSV
⚙️Methodology
How Per-Order Grouping and Order Matching Work
For each settlement line the engine reads the order id and amount, classifies the line by its transaction-type / description text (refund, fee, adjustment, tax or sale), and accumulates per order: positive sale / principal / shipping amounts into gross SALES, negative fee / commission / FBA / closing / advertising lines into FEES (as a positive magnitude, also tallied by label for the breakdown), refunds and adjustments separately, and every amount into NET — so the per-order net is the literal sum of that order’s lines. When there is no transaction-type column, sign decides: positive amounts are treated as sales and negatives as fees. An optional explicit fee column is added to fees and subtracted from net. Money parsing is robust: it handles currency symbols, thousands separators, parentheses-as-negative “(12.50)” and accounting DR/CR markers, and decides the decimal separator when both “.” and “,” appear. When the seller also uploads their own orders file (order id + order total), the tool MATCHES on order id: an order in the orders file with NO settlement line is flagged UNPAID / pending; a settlement order NOT in the orders file is flagged UNKNOWN; and for matched orders the settled net is compared to the expected total to flag short-paid or over-paid beyond a small tolerance. It also flags negative-net orders and orders whose effective fee percentage exceeds a threshold (default 35%).
Each order’s NET = the sum of its settlement lines; totals roll up to the disbursement
Transaction type classified from labels; sign-based fallback (positive = sale, negative = fee) with no type column
Optional orders file → UNPAID (no settlement), UNKNOWN (not in orders), short-/over-paid vs expected total
Flags negative-net orders and unusually high effective fee % (default > 35%)
🔒Privacy & Security
Privacy vs Cloud Reconciliation Tools
A seller’s settlement and order exports are among their most sensitive data: they reveal real revenue, every fee, the net payout and customer order details. Many cloud reconciliation and seller-analytics tools require uploading the report or connecting a marketplace login so a third party can pull and total the data. Seller Reconciliation does neither — it never uploads anything and never connects an account. The settlement and orders CSVs are parsed, grouped, matched and summarised entirely in the browser; nothing is sent to a server, logged or stored; there is no row cap; and the page works offline once cached. That makes it safe for confidential financials. Only the per-order reconciliation report the user chooses to export ever leaves the page.
⚠️Limitations
Honest Limits: a Helper, Not Accounting — Verify Against Your Statement & Bank
The tool is explicit about what it is. It is a reconciliation HELPER that summarises and matches the report you provide; it does not connect to any marketplace and does not pull live data. The user must always VERIFY the net payout and fee breakdown against their actual marketplace settlement statement and their bank deposit before relying on them. How fees are CATEGORISED depends entirely on the report’s columns and labels, which differ by marketplace (Amazon, Flipkart, eBay, Etsy…) and change over time — without a transaction-type column the tool falls back to sign, which can misclassify; lines with an unreadable amount or a blank order id are skipped and counted. Order matching is exact on order id (case-insensitive by default), so inconsistent id formatting can read as unpaid or unknown. This is NOT accounting or tax advice; the user should confirm classifications and figures with their accountant.
A HELPER that summarises/matches the report — it does not connect to any marketplace or pull live data
Always verify the net payout and fee breakdown against your settlement statement AND bank deposit
Fee categorisation depends on the report’s columns/labels, which vary by marketplace and change
No type column → sign-based fallback can misclassify; unreadable / blank lines are skipped and counted
Exact order-id matching (case-insensitive); NOT accounting or tax advice — confirm with an accountant
Uploads the report or connects a marketplace login
Confidential-financials safety
Stays on your device
Sent to a third-party server
Per-order grouping
Yes — sales, fees, refunds, net per order
Yes (account / paid tiers)
Fee breakdown
By label (referral, FBA, closing, ads…)
Sometimes (paid)
Match your own orders
Yes — flags unpaid / unknown / mismatched
Often requires an integration
Negative-net / high-fee flags
Yes
Varies
Export report CSV
Yes, free, no row cap
Often paywalled / capped
Honest about scope
Yes — verify vs statement & bank, not accounting advice
Often implies authoritative totals
Cost / signup
Free, no signup
Usually subscription / account
AnyTool is a privacy-first client-side settlement reconciler — your financials never leave the browser. It is a helper that summarises and matches the report you provide; fee categorisation depends on the report’s labels (which vary by marketplace and change), so always verify the totals against your settlement statement and bank deposit. Not accounting or tax advice.
