Free agents + LAUNCH30: 30% off paid agents until 31 Dec 2026 (one-time purchases only) See free agents
Oarsman AI Sign in

Marketplace Settlement Reconciler Pro / Docs

Marketplace Settlement Reconciler Pro: setup guide

Orders and settlement reports from several marketplaces become one per-order status list, with rate-card fee breaches, every payout found (or not) in your bank statement, and profit per SKU.

Who it is for: Seller or accountant for an Indian brand selling on Meesho, Flipkart, Amazon.in or Myntra, who checks every month whether each order was paid and what was deducted.

Format: Claude skill pack · Version: 1.0.1 · Tested on: Python 3.13.5 (standard library only)

What it does

Each marketplace's orders and settlement files are read (common Meesho, Flipkart, Amazon.in and Myntra column names, wide fee columns or one row per amount type), lines are summed per order and each order gets a status: paid, unpaid and overdue, charged on cancellation, paid nothing, high deductions, money on a returned order, duplicate line or unknown order. With a rate card, commission % and shipping per order are checked against your agreed numbers, with the exact prefix rule that applies. With a bank statement, payouts are grouped by UTR or settlement id and found in the bank by that reference and amount, or by amount within 3 days. With unit costs, profit per SKU counts cost only for delivered, paid orders.

What you need

  • Claude.ai with code execution switched on (or Claude Code, or just Python 3.10+)
  • Orders and settlement reports downloaded from each seller panel
  • Optional: your bank statement CSV and a unit cost list

5-minute setup

  1. Claude.ai: open Settings → Capabilities → Skills, click Upload skill and pick claude-ai-upload/marketplace-settlement-reconciler-pro.zip.
  2. Claude Code: copy the folder skills/marketplace-settlement-reconciler-pro into ~/.claude/skills/.
  3. Start a new chat. Attach your file and say: "Use marketplace-settlement-reconciler-pro. Reconcile my Meesho and Amazon reports for October with my rate card, bank statement and SKU costs".
  4. Claude runs the script and gives you the files listed under Outputs. Check them before you act on them.

Try it with the sample

Run the sample (fictional Meesho and Amazon October 2026 reports):

python3 skills/marketplace-settlement-reconciler-pro/scripts/core.py --marketplace "Meesho=samples/meesho-orders-oct-2026.csv,samples/meesho-payments-oct-2026.csv" --marketplace "Amazon=samples/amazon-orders-oct-2026.csv,samples/amazon-settlement-oct-2026.csv" --rate-card samples/rate-card.csv --bank samples/bank-statement-oct-2026.csv --costs samples/sku-costs.csv --out out

You should see 19 orders across 2 marketplaces, 1 commission above the rate card, 3 payouts of which 1 is not in the bank, and profit per SKU in sku-summary.csv. In Claude, attach the files and use the prompt above.

Settings you can change

Option Default What it is
--marketplace (required, repeat) NAME=orders.csv,settlement.csv[,settlement2.csv...] for each marketplace
--rate-card (none) CSV: sku or prefix*, max commission %, max shipping per order
--bank (none) Bank statement CSV/XLSX; each payout is found by UTR/settlement id or by amount within 3 days
--costs (none) CSV: sku,unit_cost for profit per SKU
--as-of (latest date in files) Date used to judge overdue payments, YYYY-MM-DD
--pending-days 15 Days after the order date before a missing payment counts as overdue (1-90)
--max-deduction 0.40 Share of order value deducted above which an order is flagged (0.05-0.95)
--out out Output folder

What goes in and what comes out

Inputs: Orders report and one or more settlement reports per marketplace (CSV/XLSX); Optional rate card CSV: sku or prefix*, max commission %, max shipping; Optional bank statement CSV/XLSX and unit cost CSV

Outputs: report.md with results per marketplace and a to-do list; recon.csv with one row per order; payouts.csv (each payout and where it is in your bank); sku-summary.csv (orders, returns, settled, profit and margin per SKU)

AI disclosure and limits

This product does not call an AI model at run time. It was built by Oarsman AI's AI agents and checked by the automated tests shipped with it.

Limits: - Reads CSV/XLSX downloads, not PDF invoices or payment advice. - Rate-card check covers commission % and shipping per order only. - Does not raise tickets or claims; you raise them in your seller panel. - Profit per SKU uses your unit cost and the settled amount; it ignores ads, packaging and overheads unless they are in the settlement. - Reconciliation help, not accounting or tax advice.

Not tested by us: - real downloads from each marketplace (the samples follow common column names) - XLSX reports in the shipped tests (CSV only) - Myntra and Flipkart layouts specifically

Files

  • oarsman-marketplace-settlement-reconciler-pro-v1.0.1.zip
  • CHANGELOG.md
  • QA-REPORT.json
  • README.md
  • SPEC.md
  • SUPPORT.md
  • TROUBLESHOOTING.md
  • VERSION
  • VIDEO-SCRIPT.md
  • claude-ai-upload
  • diagram.mmd
  • diagram.png
  • preview.png
  • samples
  • skills
  • tests

Help

Self-serve: see TROUBLESHOOTING.md (fixes and FAQ). There is no call, chat or email support. Fixes ship as new versions at your download link. Refund: 14 days, works as described, through the checkout platform.