To match Flipkart settlements with your GST sales register, download both for the same period, match them order by order using the order or invoice ID, then bridge the gap through returns, commissions and fees, TCS, other deductions and timing differences. Whatever remains after these items is an exception to investigate with Flipkart or your accountant.
Why settlements and the sales register never match directly
The two documents measure different things. Your GST sales register is built on invoices: it shows the value you billed, the tax charged and the invoice date. A Flipkart settlement is built on payments: it shows what Flipkart paid you after deducting commission, fees, tax collected at source and return adjustments.
So a straight comparison of the register total against the bank credit will always show a gap. The job is not to force the two to equal each other but to explain every rupee of the difference. Typical reasons are:
- Returns and cancellations after the invoice date
- Commission, fixed fees, shipping and other charges
- TCS deducted by the marketplace
- Orders invoiced in one month but settled in the next
- Penalties, reversals or manual adjustments
Once you see it as a bridge with named items, the exercise becomes manageable.
Gather the right reports for the same period
Mismatches often start with pulling the wrong date range. Collect these for the same month, and note the date basis each one uses:
- GST sales register from your accounting or ERP system, with invoice number, invoice date, order ID, taxable value and tax.
- Flipkart settlement or payment reports from Seller Hub, showing order-level payments, deductions and settlement dates.
- Orders and returns reports for dispatch, delivery, return and cancellation status.
- Credit notes issued for returns in the period.
- Fee invoices from Flipkart for commission and other services.
- Bank statement showing the actual settlement credits.
Report names and column headings change from time to time, so check them against what your Seller Hub currently provides. Confirm TCS treatment and any rate or fee terms from your seller agreement, the current rate card and your tax adviser, not from memory.
Match order by order using a common key
Totals hide errors; order-level matching exposes them. Use the order ID (or order item ID) as the key, and make sure your register carries it. If it does not, add it from your order management export.
- Clean both files: remove duplicate rows, standardise ID formats and strip stray spaces.
- Put the sales register and settlement data in one sheet or use a lookup on the order ID.
- Flag orders present in the register but missing from settlements (unsettled, cancelled or disputed).
- Flag orders present in settlements but missing from the register (a missed invoice or an earlier-period sale).
- For matched orders, compare invoice value with the marketplace sale value. Differences point to price, discount or tax-treatment issues.
- Compare deductions per order against your agreed terms.
Work at item level if one order contains multiple SKUs, because returns and fees often apply per item.
Build the bridge from register to bank credit
Once orders are matched, summarise the month as a bridge:
- Start with the invoice value from the sales register.
- Subtract returns and credit notes for the period.
- Subtract commission, fees and GST on those fees as per Flipkart's statements.
- Subtract TCS deducted.
- Add or subtract other adjustments such as reimbursements, penalties or reversals.
- Adjust for timing: remove orders not yet settled and add settlements for earlier invoices.
The result is your expected bank credit. Compare it with the actual credits in your bank statement. A residual difference is your exception list. Keep the bridge in a fixed format every month so that changes are easy to spot.
Handle returns, TCS and timing carefully
Returns. A return may be settled in a different month from the original sale. Link each return to its original order ID and its credit note so that your register, credit notes and settlement all show the same reversal. Returned orders that Flipkart has not credited back, or has charged fees on, deserve a closer look against your agreement.
TCS. Tax collected at source is deducted from your payment and should be reflected in your GST portal records. Compare the TCS in settlement reports with what appears on the portal for the same period. Do not assume a rate; check the current provisions and how it applies to your case with your tax adviser.
Timing. Keep a running list of orders invoiced but not settled, and clear it as payments arrive. Carry-forward items should reduce every month. If an item stays open for long, raise it with Flipkart through the seller support route, with the order ID and your evidence.
Turn it into a monthly routine
Do this reconciliation before you finalise your GST return, not after, so that missing invoices or credit notes can be corrected in time. A simple routine is: download reports on a fixed date, match orders, prepare the bridge, list exceptions with owners, and file evidence for each resolved item.
If you sell high volumes, spreadsheets become slow and error-prone. Tools such as MarketplaceMetrics by Fundle are built to reconcile marketplace sales and settlements, check fees against agreed terms and track returns and recovery cases. Whether Flipkart specifically is covered is something to confirm with the team, as marketplace coverage beyond Myntra is under scope discussion.
Worked example
Illustrative example only. All figures are made up to show the method.
| Line | Amount (₹, illustrative) |
|---|---|
| Invoice value per GST sales register | 1,00,000 |
| Less: returns and credit notes | 12,000 |
| Less: commission and fees (incl. GST) | 14,000 |
| Less: TCS deducted | 800 |
| Less: other adjustments | 500 |
| Expected settlement | 72,700 |
| Actual bank credit | 71,200 |
| Difference | 1,500 |
On review, ₹1,000 is explained by unsettled orders invoiced late in the month (timing). The remaining ₹500 is traced to a fee line that does not match the agreed terms, so it goes on the exception list to raise with Flipkart.
Questions and answers
Which ID should I use to match Flipkart settlements with my sales register?
Use the order ID, or the order item ID where one order has several items. Make sure your sales register stores it alongside the invoice number. If it does not, add it from your order export before you start matching.
Why does my Flipkart settlement total differ from my GST sales register?
The register shows invoiced value, while the settlement shows cash paid after returns, commission, fees, TCS and other adjustments. Timing also differs, since an order invoiced in one month may be settled in the next. Bridge these items to find the true exceptions.
Should I reconcile before filing my GST return?
Yes, ideally. Reconciling first lets you correct missed invoices, credit notes or value mismatches before filing. Exact deadlines and amendment rules depend on current GST provisions, so confirm them with your tax adviser.
Can I do this reconciliation in Excel?
Yes, for modest volumes. Use lookups on the order ID, keep a standard monthly bridge and maintain an exceptions list. As order volumes, returns and fee lines grow, manual work becomes slow and error-prone, and dedicated reconciliation tools may help.