Start with the sale, not the marketplace payout
Amazon and Flipkart sellers receive settlement amounts after several deductions. Those payouts are important for cash management, but they do not represent the value of sales for GST reporting. A settlement can include customer collections, refunds, platform charges, logistics deductions and tax collections relating to different orders. Building the sales register from the bank statement alone can therefore leave both turnover and tax figures incomplete.
A dependable workflow starts with order-level sales documents and connects them to returns, adjustment notes, platform invoices and settlement reports. This guide describes that reconciliation process. Registration eligibility, rates, filing obligations and credit conditions must be checked against the rules applicable to the seller and transaction before a return is filed.
Confirm the registration position before listing products
Do not assume that every marketplace seller has an identical GST registration obligation. The position can depend on what is sold, the seller's location, interstate activity and whether a specific exemption or conditional procedure applies. Check the current legal conditions and the marketplace's onboarding requirements separately. A platform accepting a listing does not establish that every tax condition has been satisfied.
Document the states from which goods will be supplied and where inventory will be stored. Moving stock into a fulfilment warehouse in another state can raise registration and stock-transfer questions. Resolve these before dispatching inventory. Keep a state-wise list of registrations, declared premises and responsible staff so that sales are mapped to the correct registration.
Create a controlled product and customer master
Maintain a product master containing the commercial description, HSN classification, unit of measurement and tax treatment. Classification should follow the actual goods and relevant rules; a competing seller's listing is not sufficient evidence. Review bundles, replacement parts and accessories individually rather than applying one rate to the entire catalogue without analysis.
Record customer registration details accurately where relevant. For each order, preserve the invoice number, date, taxable value, tax amount, delivery information and seller registration. Place-of-supply analysis determines the appropriate tax treatment; the marketplace's head-office address does not decide it. Investigate missing or inconsistent location data before finalising the outward-supply register.
Keep five records that can be reconciled
| Record | Purpose | Control |
|---|---|---|
| Order and invoice register | Establish sales and tax by document | Match order identifiers and invoice sequences |
| Returns and adjustment register | Track refunds and supplier notes | Link each adjustment to the original sale |
| Platform expense invoices | Separate charges from sales proceeds | Check recipient details and tax components |
| Settlement ledger | Explain amounts paid or retained | Reconcile each settlement to the bank |
| Tax reconciliation file | Support return preparation | Record differences, evidence and resolution |
Download reports for a consistent period and retain the original exports. Later platform adjustments can change a dashboard view. An archived source file, together with the date it was downloaded, makes it easier to explain why the accounting records differed from a later report.
Reconcile settlements without reducing gross sales
Suppose a settlement statement shows customer collections of INR 1,18,000, deductions of INR 12,000 and a bank payout of INR 1,06,000. The payout reconciles arithmetically, but the INR 12,000 still requires classification. It could include charges, refunds, tax collections or reserves. This example does not establish the taxable value or GST liability because the underlying invoices and adjustment details are still needed.
Post the sale from the sales document and post each deduction under its own ledger. Match platform fee invoices to the corresponding expenses instead of treating every deduction as a reduction in turnover. Carry unexplained differences in an identified reconciliation account with an owner and review date. Avoid forcing that account to zero through unsupported sales or tax entries.
Keep GST TCS separate from input tax credit
GST tax collected at source by an e-commerce operator and GST charged on a platform's service invoice are different items. Where the operator collects GST TCS, reconcile the operator's reported data and the relevant portal records to the seller's books. Do not combine that amount with purchase input tax credit merely because both affect the eventual cash outflow.
Marketplace statements may contain other statutory deductions as well. Identify the law and document supporting each line before posting it. A label such as tax deduction is not enough to establish whether the entry belongs in the GST records, income-tax records or a platform receivable ledger. Use separate control accounts to preserve this distinction.
Check purchase and platform expense credits
Prepare an inward-supply register from supplier invoices and platform expense documents. Check the recipient registration, business purpose, taxable value and tax amount. Reconcile the register with the relevant GST portal statements, including GSTR-2B where applicable, and investigate missing, duplicated or amended documents.
An invoice appearing in a statement does not by itself establish entitlement to input tax credit. Eligibility, receipt, restrictions and other applicable conditions still need examination. Keep a separate schedule for disputed, ineligible or deferred credits so that the amount claimed can be traced to a documented decision rather than a dashboard total.
Handle cancellations, returns and replacements individually
A cancelled order before invoicing, a post-invoice sales return and a replacement shipment are not necessarily the same accounting event. Identify what actually occurred, which documents were issued and whether goods moved. Preserve the customer refund reference and the warehouse receipt or delivery evidence where available.
A marketplace refund does not automatically justify reducing output tax. Review whether an appropriate supplier credit note and the applicable statutory conditions support that treatment. Record commercial adjustments separately where tax cannot be adjusted. Check that a return has not been deducted once in a platform sales report and again through a manual journal.
Prepare the reporting review before filing
- Reconcile invoice totals with order exports and the accounting sales register.
- Review tax treatment, customer details and state-wise allocation.
- Match adjustments to their original transactions and supporting documents.
- Reconcile platform expenses, GST TCS records and purchase credits separately.
- Explain settlement timing differences and outstanding marketplace balances.
- Compare the proposed return figures with the books and retain reviewer approval.
Determine the applicable return forms, filing frequency and annual obligations from the seller's actual registration profile and current requirements. Do not copy a filing calendar from another seller. Track the reporting period separately from the settlement date, since cash arriving next month may relate to invoices already recorded this month.
Use the reconciled records for financial planning
Accurate marketplace records support more than return preparation. They reveal the cash tied up in inventory, unpaid settlements, returns and platform reserves. Analyse contribution after product costs, fulfilment charges and refunds before increasing advertising or purchasing additional stock. Revenue growth can consume cash even when the sales dashboard looks healthy.
For supporting calculations, explore the financial tools. If the business later needs bank working capital finance, Finxora's CMA report software can help prepare the financial statement pack from reviewed inputs. These reporting resources do not replace GST registration advice, transaction classification or return review.
