How to Reconcile Flipkart Seller Settlements in Tally Prime

Selling on Flipkart involves a multi-tier fee structure (Bronze, Silver, Gold, and Platinum tiers) and dedicated logistics partners like Ekart. For finance teams, matching the bank deposit from Flipkart against shipped orders is complex due to these dynamic deductions.

This guide provides the SOP to record Flipkart sales, return reversals, platform fees, and statutory tax deductions in Tally Prime.

1. Flipkart Seller Fee & Commission Structure

Unlike other marketplaces, Flipkart determines your commission rate based on your seller tier (Bronze, Silver, Gold, Platinum). The deductions on each settlement cycle include:

• Commission Fee: A percentage of the order value based on vertical and tier.
• Fixed Fee: A flat charge per order based on item price slabs.
• Collection Fee: A percentage charge for processing payments (prepaid/COD).
• Shipping Fee: Charged by Ekart based on product weight and delivery zone.
• GST TCS (1%): Deducted under Section 52 of the CGST Act. Learn more about TCS configurations in our GST TCS & TDS 194-O guide.
• TDS u/s 194-O (0.1%): Income tax withheld by Flipkart on gross sales.

2. Handling Flipkart Customer Returns

Flipkart returns require careful accounting because Flipkart charges reverse shipping fees and returns processing fees, while reversing the referral commission.

In Tally Prime, record returns using a Credit Note (Alt + F6):

Ensure you book the reverse shipping fee as an indirect expense under "Flipkart Return Shipping Charges", matching the GST invoice details from Flipkart.

3. Configuring Tally Prime Ledgers

• "Flipkart Settlement Clearing" under Current Assets (used to track gross sales vs. payouts).
• "Flipkart Marketplace Fees" under Indirect Expenses (to book commission, fixed, collection, and shipping fees).
• "GST TCS Receivable" under Duties & Taxes. Compare this with reports on the Official GST Portal.
• "TDS Receivable u/s 194-O" under Current Assets. Cross-check this with your Form 26AS on the Income Tax Portal.

4. Booking the Settlement Voucher

When Flipkart releases a payout, record a Journal Voucher (F7) to clear the marketplace fees and tax deductions:

Finally, book the bank receipt: Debit your corporate bank account and credit **Flipkart Settlement Clearing**. For a complete view of how this compares to Amazon and multi-channel setups, check our E-commerce Bank Reconciliation guide.