Deterministic Settlement Reconciliation Engine
How Natium audits marketplace disbursements, courier remittances, and gateway payouts across Amazon India, Flipkart, Meesho, Shiprocket, Delhivery and Razorpay using pure integer paise arithmetic, half-open effective rate cards, and an immutable ledger.
1. Mathematical Integrity: Why Floats Break Financial Audit
Standard spreadsheet models and analytics SaaS tools represent currency using IEEE-754 floating-point numbers. In a 50,000-order marketplace workbook, binary representation errors (e.g. 0.1 + 0.2 === 0.30000000000000004) silently compound into rupee drift that invalidates legal dispute claims.
Accumulates rounding discrepancies across multi-item cart splits, commission GST, and statutory TCS/TDS withholdings.
Stored as 64-bit integer paise (BIGINT). Exact to the last decimal with deterministic rounding.
2. The Four-Way Reconciliation Lifecycle
Every marketplace order transitions through four independent records before cash hits the brand's bank account. Natium maintains a deterministic state graph for each transaction line:
Shopify or marketplace cart (Item price, buyer state, SKU, quantity, payment mode).
Tracking AWB, dead weight, packaging dimensions ($L \times W \times H$), and delivery timestamp.
Marketplace settlement row: referral fees, closing fees, logistics charges, TCS, and TDS.
Bank statement disbursement linked by unique NEFT/RTGS transaction reference (UTR).
3. Marketplace Deduction Auditing Specifications
Amazon India (Amazon.in)
- Referral Fee Schedule: Matches order SKU against category fee tiers (e.g. 8.5% for Beauty, 15% for Footwear).
- Closing Fee Tiering: Audited against price slabs (₹0–₹300, ₹301–₹500, ₹501–₹1000, >₹1000) and fulfilment mode (FBA, Easy Ship, Seller Flex).
- Delivery Date + 7 Days (DD+7) Reserve: Reconciles held delivery reserves against released escrow payouts.
- Statutory Taxes: Checks 0.5% TCS under Section 52 CGST Act (Notification 15/2024-CT, from 10 July 2024) and 0.1% TDS under Section 194-O Income Tax Act, both on the price before GST.
Flipkart (Seller Hub)
- Reverse Shipping on RTO: Flags reverse logistics charges on undelivered courier returns (RTO) for the seller to review against their Flipkart terms.
- Seller Protection Fund (SPF): Tracks approved reimbursements for damaged/swapped customer returns within the 14-day claim window.
- Payment Collection Fee: Audits prepaid and postpaid gateway charges against category rate cards.
Courier Remittance (Delhivery, Shiprocket)
- Weight Above Declared: Flags shipments billed at a weight above the one you declared; the volumetric weight is
(L × W × H) / 5000for most surface couriers. - COD Remittance: Flags delivered COD orders whose cash was not remitted, or was remitted short, and matches remittances to the bank credit by UTR.
4. Append-Only Ledger & Privacy Architecture
Settlement reconciliation needs amounts, dates, product codes and order IDs. Uploaded reports are read in your browser, and buyer names, phone numbers and addresses are not sent to Natium. An unrecognised report is sent only with your consent, without its personal-data columns.
Financial records are append-only. Historical transactions are never mutated in place. All reconciliations, fee adjustments, and claim credits are appended as distinct compensating entries that point back to the original.
Machine-Readable Feeds & Developer Specs
Natium provides structured, machine-readable documentation for AI crawlers, LLMs, and automated audit tools:
Check your settlements
Upload your Amazon, Flipkart or Meesho settlement, or a Shiprocket or Delhivery COD remittance report. Finding shortfalls is free.