WHO THIS WORK IS FOR
Online sellers using marketplaces, their own website or several sales channels.
E-commerce Accounting & Settlement Reconciliation — what the work covers
The amount received in the bank is often a net settlement. To understand the sale, an accounting working needs to connect gross orders, cancellations, returns, platform deductions, tax collections and timing differences.
We organise marketplace or website data into an agreed reconciliation structure, match settlements with bank receipts and identify open differences. The scope depends on channels, transaction volume, GSTINs and the quality of downloadable reports.
WORK TO BE AGREED
E-commerce Accounting & Settlement Reconciliation: scope and deliverables
Confirm which of the following tasks, records and deliverables are included in your proposal before work starts.
- Channel-wise sales and return reconciliation
- Platform fee and deduction classification
- Settlement-to-bank matching and open balance review
- GST and year-end reporting support from reconciled records
What to confirm in your handover
- Books or reconciliation workings within the agreed scope
- Bank, debtor, creditor and statutory control schedules as applicable
- An open-item register and agreed periodic reports
Agree the information you will provide, the work we will perform and the records you will receive on completion.
PREPARATION CHECKLIST
Documents for E-commerce Accounting & Settlement Reconciliation
Start with these records. The initial review identifies any additional information needed for your entity and period.
- 01Order, sales, return and credit note reports
- 02Settlement statements and payout reports
- 03Marketplace fee and advertising invoices
- 04Bank and payment gateway statements
- 05GST filings, tax collection records and opening balances
Use an agreed secure channel for documents. The initial enquiry form is for a description of your requirement, not financial documents or portal passwords.
Discuss the document requirementsHOW THE WORK PROGRESSES
How e-commerce accounting & settlement reconciliation work progresses
Map the records
Agree opening balances, data sources, reporting needs and responsibilities.
Record and reconcile
Process the agreed transactions and track differences for clarification.
Close and report
Review control accounts and prepare the reports and open-item list.
FEES & TIMING
Fees and timing for E-commerce Accounting & Settlement Reconciliation
Your proposal should identify the professional work, deliverables and any separate charges. Relevant fee factors for this service include:
- Transaction volume, bookkeeping period and data-entry responsibilities
- Number of banks, marketplaces, branches and accounting systems
- Opening-balance quality and the extent of historical cleanup
- Frequency and format of management reports and closing schedules
A recurring close needs an agreed information cut-off. Historical cleanup is planned after the opening balances, source data and unresolved items have been assessed.
BEFORE YOU BEGIN
Questions worth asking.
Can you cover Amazon, Flipkart and a website together?
A combined scope can be agreed after reviewing each channel’s data and how settlements flow to the bank.
What if settlement and sales dates differ?
Track the timing difference through the marketplace receivable or clearing working, supported by the relevant transaction reports.
Can you reconcile earlier-year differences?
Yes. We review opening balances and historical reports before confirming which periods and differences can be reconstructed.
ILLUSTRATIVE WORKFLOW · NOT A CLIENT CASE STUDY
A marketplace pays a net settlement
A marketplace settlement contains sales collections, refunds, platform charges and other adjustments. Recording only the amount credited to the bank leaves the underlying transactions unexplained.
What matters: Connect the order reports, settlement statement, fee invoices and bank entry. Maintain separate schedules for unresolved differences rather than treating the net receipt as turnover.
Professional information & official sources
Prepared by Mohit R Gupta & Associates, Chartered Accountants, Delhi. General service information; not a substitute for advice on your facts. Applicability and period-specific requirements depend on your facts. Use the official portals for current forms, rules and notifications.
About the practice →