Flipkart GST reconciliation means lining up three numbers that almost never arrive in the same shape: the order value shown in your Flipkart Seller Hub, the amount Flipkart actually pays into your bank account, and the taxable value you report in GSTR-1. When these three drift apart, most sellers notice a bank shortfall first and only trace it back to a GST reporting problem weeks later, usually while trying to close the month.
This guide walks through the three Flipkart reports you need, a worked reconciliation example with real-looking numbers, the mismatches that are specific to how Flipkart structures commission and returns, and a monthly routine you can repeat instead of starting from a blank spreadsheet every filing cycle.
Three Flipkart Reports That Rarely Agree
Every Flipkart seller reconciliation problem traces back to using the wrong report as the source of truth, or comparing two reports that were never meant to match line for line.
| Report | What it actually shows | Where sellers go wrong |
|---|---|---|
| Order/MIS Report | Every order placed in the period, including ones later cancelled or returned | Reporting GST on the full order count instead of only fulfilled, non-cancelled orders |
| Tax Invoice Report | Invoice-level taxable value and GST that Flipkart's system generated per order | Using the Order Report for GSTR-1 instead of this one, which is the correct base |
| Payment/Settlement Report | Net amount credited to your bank after commission, shipping fee, and GST on those fees | Comparing this net figure directly against GSTR-1 taxable value, which double-counts commission GST |
Step 1: Pull the Right Reports from Seller Hub
Before touching a spreadsheet, download three separate files for the same filing period: the Tax Invoice Report (not the Order Report), the Payment/Settlement Report, and the returns or RTO report on its own, since returns frequently settle in a different payment cycle than the original sale.
Step 2: Bring the Reports Into One View
Once you have the three files, the manual approach is to build a lookup by order ID across all three sheets, which gets unwieldy past a few hundred orders a month. Uploading the same marketplace files under Admin > Upload Files lets GSTR-1 automation handle the order-ID matching and the B2B/B2C split for you, and cash credits from Flipkart can be matched against individual settlement line items using the bank statement parser rather than eyeballing a bank statement PDF.
A Worked Example: Reconciling a Week of Flipkart Orders
Here is a simplified week of orders to illustrate the pattern. Values are illustrative, not tied to any specific GST rate slab.
| Order ID | Order Value (Rs.) | Taxable Value (Rs.) | GST (Rs.) | Commission + GST (Rs.) | Net Settlement (Rs.) | Status |
|---|---|---|---|---|---|---|
| FK1001 | 2,360 | 2,000 | 360 | 236 | 2,124 | Matched |
| FK1002 | 1,180 | 1,000 | 180 | 118 | 0 | RTO - exclude from GSTR-1 |
| FK1003 | 4,720 | 4,000 | 720 | 472 | 4,130 | Short-settled by Rs. 118 - investigate |
| FK1004 | 590 | 500 | 90 | 59 | 531 | Matched |
FK1002 was returned to origin before delivery was confirmed, so it should never enter your GSTR-1 taxable turnover even though it appears on the Order Report. FK1003 settled Rs. 118 short of the expected amount; tracing it against the settlement report's fee breakdown usually reveals an extra return-processing or reverse-pickup fee charged on a partially returned multi-item order, not a GST error at all.
Common Flipkart-Specific Mismatches
Commission GST shown net, invoice shows gross
Flipkart's settlement report often nets commission GST against the payout in a single line, while your tax invoice shows the gross sale value. If you reconcile the net settlement figure against gross GSTR-1 turnover without adding back commission and its GST, every single order will appear to be short-settled by roughly the same percentage.
RTO and re-attempted delivery orders counted as sales
An order that bounces between 'out for delivery' and 'return to origin' can appear twice in the Order Report but only once, or not at all, in the Tax Invoice Report. Always reconcile off the Tax Invoice Report for what actually became a taxable supply.
Exchange orders creating a sale and a return in the same cycle
Product exchanges generate a return of the original item and a fresh sale of the replacement, sometimes in the same settlement cycle. Treating this as a single 'net zero' transaction under-reports the new sale and over-reports the credit note value.
Multi-GSTIN dispatch across warehouse states
If you fulfil orders from more than one state, the same product line can carry different place-of-supply treatment depending on which warehouse dispatched it. Reconciliation has to be done per GSTIN, not pooled across your whole Flipkart account.
Building a Monthly Flipkart Reconciliation Checklist
- Download Tax Invoice Report, Settlement Report, and RTO/return report for the exact filing period, not calendar month if they differ.
- Confirm the count of taxable orders in the Tax Invoice Report against what you intend to report in GSTR-1.
- Add back commission and logistics GST to settlement figures before comparing to invoice-level GST.
- Flag any order settled zero or partial without a matching RTO or return record.
- Split classification by GSTIN if you dispatch from more than one state.
- Reconcile any residual variance against your bank credit for the same settlement cycle.
When the Gap Still Doesn't Explain Itself
If a variance survives all of the above checks, pull Admin > Detailed Reports for a line-item view before raising a ticket with Flipkart seller support, since most support queues ask for the specific order IDs in dispute. For a structured way to work through any leftover mismatch, see how to fix a GST mismatch. Sellers running both marketplaces may also find it useful to compare notes with the Amazon GST reconciliation guide, since the report names differ but the underlying logic is similar.
How Flipkart TCS Fits Into the Reconciliation
Flipkart, like every e-commerce operator, collects tax at source on the net taxable value of supplies made through its platform and reports it against your GSTIN. This TCS should show up as a credit you can use to offset your GST liability, but only once Flipkart has actually filed its own statement for the period, which can lag behind your own filing timeline. If your TCS credit for a period looks short, check whether the gap closes after Flipkart's next filing cycle before treating it as an error on your side; this is a similar timing pattern to the one that shows up in purchase-side input tax credit reconciliation. Keep the RTO orders you excluded in the sales layer excluded here too, since TCS should only apply to the value of supplies that actually went through, not gross order value.
A quick sanity check before you file
Before finalising GSTR-1 for a Flipkart-heavy filing period, add up the taxable value across all matched orders from the Tax Invoice Report and compare that single number against what your GSTR-1 draft shows. A gap at this stage almost always traces back to a report you forgot to include, most often orders fulfilled through Flipkart's own logistics network appearing under a separate report tab from seller-shipped orders.
Frequently Asked Questions
Which Flipkart report should I use as the base for GSTR-1?
Use the Tax Invoice Report, not the Order Report. The Order Report includes cancelled and RTO orders that never became a taxable supply.
Why does my Flipkart settlement never match my GSTR-1 taxable value?
Settlement is a net figure after commission, shipping, and GST on those fees are deducted. GSTR-1 taxable value is gross. You need to add fees back before comparing.
Should RTO orders be included in GSTR-1?
No. An order returned before delivery was never a completed supply and should not appear in your GSTR-1 taxable turnover for that period.
How do I handle Flipkart orders dispatched from two different states?
Reconcile and file separately per GSTIN. Pooling orders from multiple warehouse states into one GSTIN's GSTR-1 will misstate place of supply.
What if my settlement is short by a small, consistent amount every order?
Check whether a return-processing or reverse-pickup fee is being deducted uniformly. This is usually a fee difference, not a GST classification error.
Can OneBooks GST automate Flipkart reconciliation?
You can upload Flipkart sales files under Admin > Upload Files and use GSTR-1 automation to handle B2B/B2C classification; always verify current thresholds and rules on the official GST portal at www.gst.gov.in.
Where software takes over: OneBooks GST
OneBooks GST covers the same ground. It keeps imported marketplace data, returns and adjustments as separate reviewable figures so a mismatch can be traced to its source row.
Because OneBooks GST keeps each GSTIN in its own organisation context, a business registered in several states can work through one registration at a time.
