Skip to content
Robnu
Live for Ajio

Every payout, every line item, in your tenant.

MarketplacePayout is a first-class long-lived domain object — not batch metadata. Every settlement run lands as a payout row with line items, statuses (PENDING | RECONCILED | DISPUTED), and the source settlement file preserved as a StorageObject.

Free during early access · Forever free under 25 orders/day
app.robnu.com/reconciliation/2026-04Payment reconciliationPayouts ↔ Orders ↔ Adjustments — line by linePayoutsAJIO settlement fileOrdersshipped + deliveredAdjustmentsdeductions + claimsMatch enginededup_key + amount + AWBOR-7782 · ₹1,249 · ✓OR-7783 · −₹47 · ΔOR-7784 · ₹890 · ✓ReconciliationBatch · BATCH-2026-04-26218 matched · 7 deltas · ₹1,348 recoverable₹+1,348
TL;DR
  • Marketplace payouts ingest into MarketplacePayout + PayoutLineItem with full source preservation.
  • Per-seller, per-marketplace-account scoping. Multi-account sellers get separate payout streams per account.
  • Status field (PENDING | RECONCILED | DISPUTED) flows from the reconciliation engine.

What you get.

Settlement-file preservation

The original settlement PDF and XLSX are kept as StorageObject in your S3 bucket with SSE-KMS. The MarketplacePayout row carries storage_key + sha256, so the source is always one click away.

Line-item drilldown

Each PayoutLineItem maps to a real Order. Open a payout, see the line items, click a line, jump to the order. Two clicks from a settlement to the slip you printed for it.

Status flows automatically

Reconciliation flips a payout to RECONCILED when its lines are clean, DISPUTED when an Adjustment is filed and a claim is open. No manual status hygiene.

What's tracked per payout

PayoutLineItem fields.

  • marketplace_payout_id — parent payout row.
  • order_id — joined to Order via dedup_key.
  • gross_amount, net_amount, deductions, fees, taxes — all Decimal(14,4).
  • deduction_reason — taxonomy entry from the deduction catalog.
  • matched_at — timestamp the reconciliation engine joined this line.
  • adjustment_id — set when the line spawned an Adjustment.
FAQ

Practical answers.

Re-ingest writes a new MarketplacePayout version. The diff vs the previous version is preserved. ReconciliationBatch can replay against the new version and show you what changed.

Each payout carries the marketplace's settlement currency. Cross-currency reconciliation isn't needed for the India-first scope; the schema supports it for future markets.

On the AWS SQS Standard queue 'payout-sync', driven by the per-account schedule. The cadence is yours — daily by default for AJIO sellers.

Related

More inside this pillar.

Try it inside your own dashboard.

Free during early access. No card. Forever free under 25 orders/day.

build 547000c1ac5d3ea9cb039864711ed788f9948b69 · 2026-06-12T02:03:58+05:30