Finance & Reconciliation

The Marketplace Payment Reconciliation Checklist: Auditing Settlement Reports, Fees, and Deductions

A comprehensive operational guide providing finance and operations teams with a structured checklist to audit marketplace settlement disbursements, uncover hidden overcharges, and reconcile net bank payouts.

Estimated reading time: 10 min read
Last reviewed: October 2026

Platform Policy Notice

Marketplace policies and documentation requirements are subject to continuous revision by respective platform operators. Always cross-verify exact requirements on the official seller portal (Seller Central, Flipkart Seller Hub, etc.) before submitting legal documentation or filing disputes.

Operational Action Checklist

Key actionable checkpoints to execute and verify during this workflow:

1

Monthly Transaction & Settlement Report Extraction

Download full date-range financial transaction reports and disbursement summaries for the preceding month from each active seller portal.

2

Category Referral Commission Rate Audit

Calculate effective commission percentages across all SKU lines and cross-check against published category rate cards to catch misclassifications.

3

Logistics Volumetric Weight Slab Reconciliation

Compare billed shipping weight tiers against physical master SKU weights to identify and dispute inflated carrier dimensional charges.

4

Customer Return Commission Reversal Check

Verify that referral commissions were credited back on refunded customer returns and that RTO shipments were not billed customer return fees.

5

GST TCS Credit Ledger Claiming

Log into the government GST Portal, verify marketplace Form GSTR-8 filings, and claim accumulated TCS cash ledger credits to pay output tax.

6

Section 194-O Income Tax TDS 26AS Reconciliation

Download Form 16A certificates from seller portals and verify that 1% TDS deductions match credits reflected in Form 26AS and AIS.

Introduction: The Anatomy of an E-Commerce Marketplace Settlement

For many online sellers, looking at monthly marketplace financial statements is a bewildering experience. A business might record ₹15,00,000 in gross merchandise sales across Amazon and Flipkart, yet when looking at the actual bank remittances deposited across the month, the total payout amounts to only ₹8,50,000.

Where did the remaining ₹6,50,000 go? Between referral commissions, closing fees, pick-and-pack charges, national logistics shipping fees, return reverse freight, customer refund debits, advertising deductions, storage surcharges, Tax Collected at Source (TCS), and Tax Deducted at Source (TDS under Section 194-O), an individual order is subjected to over a dozen distinct transactional deductions.

While most deductions are legitimate contractual fees, automated billing systems across massive platforms frequently make errors: products get categorized under incorrect, higher commission rate cards; carrier scales misread package dimensions, triggering volumetric weight penalties; and referral fees fail to reverse when buyers return unopened orders. Without a rigorous, order-level payment reconciliation process, sellers leak 3% to 7% of their gross revenue in unrecovered overcharges.

Key Operational Takeaway

Dozens of fees are deducted per order. Without line-by-line reconciliation, sellers routinely lose 3% to 7% of revenue to billing errors.

1. Commission Audits & Category Rate Card Verification

Marketplaces charge a referral commission (a percentage fee of the product selling price) that varies drastically depending on the specific product category, sub-category, and price bracket.

For example, on Amazon India, a kitchen storage container might carry a 6% commission rate, while home decorative accessories carry a 12% rate, and gourmet specialty goods carry 10%. If a seller's kitchen storage box is mistakenly mapped by an automated catalog bot into the broader "Home Decor" category, the seller is quietly billed a 12% commission instead of 6% on every single order.

During your monthly payment audit, extract the Order Detail report and calculate the effective commission percentage charged per SKU: [Effective Commission % = (Referral Fee Charged / Item Gross Price) * 100]. Cross-reference this percentage against the official published rate card on the seller portal. Any variance represents a systemic fee error that must be challenged through a seller support dispute ticket for fee credit adjustments.

Key Operational Takeaway

Calculate the effective commission percentage per SKU and verify it against published category rate cards to catch misclassification creep.

2. Logistics & Volumetric Weight Overcharge Tracking

Logistics fee discrepancies represent the single largest source of accidental deductions in e-commerce fulfillment. Marketplaces bill shipping fees based on the higher of dead weight (actual physical weight on a scale) or volumetric weight (calculated as [Length x Width x Height in cm] / 5000).

Automated scanning tunnels in courier hubs frequently capture inaccurate dimensions—for example, measuring an unsealed carton flap or scanner sensor reflection—recording a package as 2.4 kg instead of its true 600 grams. Because courier weight slabs increase in 500-gram increments, this single scanning glitch can instantly jump shipping costs from ₹55 to ₹180 on a single order.

To catch weight discrepancies, audit your shipping fee deductions against your physical product packaging master database. Identify orders where the billed weight slab exceeds the true packaged dimensions of the SKU. When filing weight dispute tickets, attach clear photographs of the packaged product placed on a calibrated digital scale alongside a measuring tape displaying length, width, and height.

Key Operational Takeaway

Audit billed shipping weight slabs against true SKU dimensions. Dispute courier overcharges with photos of packaged products on digital scales.

3. Return Fee Reversals & Uncredited Refund Debits

When a customer returns a product or an order is marked Return to Origin (RTO), marketplace accounting rules dictate specific fee adjustments.

When a customer return occurs, the marketplace debits the customer's refund from the seller's balance, but is contractually obligated to credit back the referral commission previously charged (subject to a minor administrative refund processing fee). In an RTO scenario (where delivery was never completed), the seller should generally not be billed customer return processing fees.

However, automated settlement engines occasionally glitch: the refund is debited from the seller, but the original commission fee reversal fails to post, or customer return handling charges are improperly applied to an unopened RTO package. Reconcile your return order IDs against settlement credits to verify that every refunded order received its mandatory fee reversals.

Key Operational Takeaway

Verify that referral commissions are properly reversed on customer returns, and check that RTO packages are not billed return handling fees.

4. Statutory Tax Withholdings: Reconciling TCS and TDS Credits

Under Indian GST and Income Tax laws, e-commerce operators are mandated to deduct statutory taxes before releasing payouts to sellers.

TCS (Tax Collected at Source under GST): Marketplaces deduct 1% TCS (0.5% CGST + 0.5% SGST, or 1% IGST) on the net value of taxable supplies. Marketplaces file monthly Form GSTR-8 with the government, which populates in the seller's GSTR-2A/2B and TCS Cash Ledger on the GST Portal. Sellers must claim this TCS credit monthly to offset their regular GST cash liabilities.

TDS (Section 194-O of the Income Tax Act): Marketplaces deduct 1% TDS on the gross sales amount. Marketplaces issue quarterly Form 16A certificates reflecting these deductions, which populate into the seller's Annual Information Statement (AIS) and Form 26AS with the Income Tax Department. Reconciling settlement report tax deductions against actual Form 26AS credits ensures your advance tax liabilities are accurately credited.

Key Operational Takeaway

Reconcile 1% TCS against your GST Portal Cash Ledger, and cross-reference 1% Section 194-O TDS against your Form 26AS quarterly.

5. Building an Order-Level Monthly Reconciliation Workflow

To maintain financial control, operations and accounts teams must institute a monthly payment reconciliation cadence by the 10th of every month for the preceding calendar month.

Download three core files from each seller portal: (1) Date Range Transaction Report (captures order-level sales, fees, and refunds); (2) Monthly Settlement / Disbursement Report (matches bank deposits against transaction batches); and (3) Marketplace GST Tax Invoices (details commission and logistics GST charged for input tax credit claims).

Load the files into your financial reconciliation template or automated audit software. Tag every order with its final net contribution, flag any fee rate variances, compile all identified weight overcharge candidates into a dispute dossier, and file platform tickets before the 60-to-90 day dispute statute expires.

Key Operational Takeaway

Reconcile previous-month payments by the 10th of each month. File all fee disputes before platform 60-90 day claim windows close.

Operational Assistance

Need Help Implementing These Steps?

AA2Z assists sellers with day-to-day catalog creation, dispute filing, SEO audits, and account health reviews. Let our team handle execution so you can focus on inventory and manufacturing.

Actionable Marketplace Support

Need Assistance Resolving Dashboard Issues?

Connect with our specialists for hands-on catalog remediation, claim filings, and account management.