Simple and accurate payroll processing.
Accurate, up to date financial records.
Strategic financial guidance on demand.
Controlled and timely payments.
Smarter accounting with cloud tools.
Timely and compliant tax filings.
Faster and consistent collections.
Business accounting management.
Accurate business valuation support.
Remote assistance as per your need.
Accounting support for QuickBooks users.
Cloud bookkeeping and reporting with Xero.
Streamlined accounting with Zoho Books.
Reliable records, reconciliation and reporting.
Integrated accounting and finance workflows.
Practical accounting support for BUSY users.
Cloud ERP accounting and financial reporting.
Bookkeeping and invoicing support for FreshBooks.
Accounting support for Dynamics finance systems.
Enterprise accounting and reporting support.
Accurate bookkeeping and reconciliations.
Flexible accounting support from anywhere.
Dedicated accounting support for QuickBooks.
Bookkeeping and reporting with Xero.
Expert support for Zoho Books.
Reliable day-to-day accounting support.
Remote accounting support for your business.
Flexible online accounting assistance.
Accounting support for Odoo workflows.
Accounting expertise for Sage software.
Specialist support for NetSuite finance.
Bookkeeping and invoicing support.
MYOB bookkeeping and reconciliations.
Enterprise accounting support for SAP.
Finance-system expertise for Dynamics.
Professional accounting and compliance support.
GST returns, reconciliations and compliance.
Learn more about Lekhakar and our team.
Insights, guides and accounting resources.
Talk to our team about your requirements.
If you sell products through Amazon, Flipkart, Meesho, Shopify, or other online platforms, managing your sales, payouts, expenses, and financial records can quickly become complicated. Our E-commerce Accounting Services help online sellers manage their bookkeeping, reconciliations, and financial reporting more efficiently.
For example, your marketplace may show Rs. 1,00,000 in sales, but you may receive only Rs. 82,000 in your bank account.
So, where did the remaining Rs. 18,000 go?
The marketplace may have deducted its commission, shipping charges, payment fees, refunds, taxes, advertising costs, or other adjustments. This is where marketplace payout reconciliation becomes important. You need to match your sales with the marketplace settlement and then match that settlement with your bank statement.
In simple terms, reconciliation means checking whether the numbers in your marketplace account, books, and bank statement match.
Suppose you made Rs. 1,00,000 in sales. Before paying you, the marketplace deducted Rs. 12,000 in fees and Rs. 3,000 for refunds. It then paid Rs. 85,000 into your bank account.
Your books should show all of these transactions. You should not simply record Rs. 85,000 as your sales.
A proper reconciliation connects the entire transaction:
Sales โ Marketplace deductions โ Net settlement โ Bank deposit
Accurate bookkeeping gives you a clear picture of how much you sold, how much you spent, and how much money you actually received.
Marketplaces do not always make one simple payment for your sales. A single settlement can include several different transactions. You may have:
These transactions can also belong to different orders or settlement periods. That is why you need to look at the settlement report instead of matching only the final bank amount.
Let’s say you sell Rs. 1,00,000 worth of products during a month. Your marketplace settlement looks something like this:
Your bank statement will show a credit of Rs. 81,000.
But your sales were Rs. 1,00,000.
The difference of Rs. 19,000 represents various deductions and adjustments. Your bookkeeping should capture these separately. This is why bank deposits and sales should not be treated as the same thing.
You do not need a complicated process to start. You just need to follow the same steps regularly.
Download the relevant reports for the period you want to reconcile. Depending on the marketplace, you may need sales, settlement, fee, refund, tax, shipping, or advertising reports. These reports give you the details behind the final payout.
Compare the sales in the marketplace report with the sales recorded in your accounting system. Look for cancelled orders, missing orders, duplicate entries, discounts, and other differences. If your marketplace shows Rs. 1,00,000 in sales but your books show Rs. 96,000, find out why before moving forward.
Next, look at the charges deducted from your settlement.
For example, the marketplace may charge commission based on your product category. You may also pay shipping, fulfilment, payment processing, listing, or advertising charges. Record these expenses properly instead of treating them as a reduction in sales. This helps you understand how much it actually costs to sell your products.
Returns can create confusion in e-commerce bookkeeping.
A customer may place an order in one period and request a refund later. The marketplace may adjust that refund against a future settlement. You need to connect the refund with the original order and make sure your sales and accounting records reflect the change. If you also manage inventory, check that the returned product comes back into your inventory records where applicable.
Your marketplace settlement may include tax-related deductions. Businesses should also maintain proper GST compliance and reconcile relevant tax records before filing returns.Review these amounts and make sure you record them correctly in your books and reconcile them with the relevant tax records. Do not guess what a deduction represents. Check the settlement report and supporting documents.
Once you have checked the sales, fees, refunds, and other deductions, compare the final settlement amount with your bank statement. If the marketplace says it paid Rs. 81,000 and your bank shows Rs. 81,000, that part of the reconciliation is complete. If the amounts differ, investigate the difference. Regular bank reconciliation can help identify unmatched transactions, double postings, and unrecorded entries.
Good bookkeeping does more than keep your accounts organised. It tells you whether your business is actually making money. You may have Rs. 10 lakh in monthly sales, but that does not mean you are making Rs. 10 lakh in profit. You need to consider marketplace commissions, shipping costs, advertising, refunds, product costs, taxes, and other business expenses.
If you record your books properly, you can easily detect your real profit, and know where your money is spent. Financial reports can also assist you in making choices on whether to add stock, cut back on some costs, alter the pricing strategy, or put more money into a specific sales channel.
Managing your own books can work when your business is small. But as your sales grow, the number of transactions grows with them. You may need professional bookkeeping support if you:
A professional bookkeeping team can take care of the day-to-day accounting work and marketplace reconciliation while you focus on running your business.
Marketplace bookkeeping becomes much easier when you stop looking at the bank deposit as the complete picture. Your bank tells you how much money you received. Your marketplace reports tell you how you earned and spent that money.
You need to connect the two.
Monitor sales, market place fees, refunds, taxes, settlements and bank deposits. Compare them regularly and work out and solve differences rather than ignore them. Bookkeeping that is accurate will allow you to have a better understanding of your e-commerce business, and make decisions based on your real numbers.
What is marketplace payout reconciliation? Marketplace payout reconciliation means matching your marketplace sales and settlement transactions with your accounting records and bank deposits.
Why is my marketplace payout lower than my sales? Your marketplace may deduct commissions, shipping charges, payment fees, refunds, advertising costs, taxes, and other adjustments before transferring the payout.
Should I record my marketplace payout as sales? No. The payout usually represents the net amount after deductions. You should record the underlying sales and the applicable expenses separately.
How often should I be reconciling my marketplace payouts? The reconciliation should be done on the frequency required based on your orders volume. For smaller sellers, monthly reconciliation might be sufficient, but for high-volume sellers, it may be necessary to hold monthly or weekly reconciliation.
What impact do refunds have on E-commerce bookkeeping? Refunds are deductions on the sale amount that you receive in the end. You need to correspond each refund to the related order and adjust your accounting records.
Is it possible to make marketplaces reconcile via accounting software? There are a few automation options like import transactions and match bank entries that can be done with accounting software and integrations. It is still advisable to check the unmatched transactions and any unusual adjustments.
Why is it that I should use a professional e-commerce bookkeeper? A professional bookkeeper will be able to handle marketplace transactions, reconcile payouts, keep up with expenses and refunds, keep records right, and create helpful financial reports.
CA Sanjana Garg (FCA) is a Chartered Accountant with hands-on experience across direct and indirect taxation, audits, Virtual CFO services, fund raising, and investor reporting. She also holds FAFD and DISA qualifications. Her articles turn complex tax, compliance, and finance topics into clear, practical guidance businesses can act on.
Managing cash flow is one of the biggest challenges for any business. While making sales is important, getting paid on...
Choosing the wrong outsourcing accounting company is an expensive mistake that goes beyond dollars and cents. It includes delays in...
In todayโs time, running a business means managing expenses, tracking profits, and planning for growth and in this, the right...
Our team is here to help you. Call us now for quick support.