1. Payment Reconciliation

An online seller ships hundreds of orders daily and depending upon category anywhere between 20% – 30% are returned. At these volumes, it is difficult to keep track of payments for all orders successfully delivered and returned. And big question that did I receive the actual payment for the items sold remains unanswered.

Our Payment Reconciliation is the right way to do the task as it features a full break-up of payments received from the marketplace in a clear and simple format. It tracks payments for each order that a seller has shipped. It features 4 tabs which separates unpaid, incorrectly charged orders –

(a) Reconciled

List all orders for which marketplace has initiated payment or made deduction for all eligible returns. Provides –

  • Details of all orders shipped (Order id, Order date, SKU, Quantity)
  • Order type ( Selling Price, Shipping price, Order type, weight, shipping)
  • Break-up of Marketplace fees (commission, fixed fees, collection fees, shipping fees, GST and TCS)


(b) Payment Awaited

List of orders for which marketplace is yet to make payment.

Total of orders under reconciled tab and Payment Awaited tab will match with total number of order shipped by seller, thus ensuring that every orders shipped is tracked for the payment.

(c) Disputes

Reconciled and payment awaited will have number of records making it hard for seller to identify unpaid or overcharged orders, to make the job easy for sellers Ecom Books identifies all the orders for which payment is not yet received even after due date provided by marketplace or there are deduction by marketplace even in case of orders that are not returned.

(d) Dispute Raised

Disputes raised tab is for convenience of seller to identify all orders for which disputes has already been raised with marketplace and disputed transaction for which disputes are yet to be raised.

2. Return Reconciliation

Returns are integral part of e-commerce business and since more than three parties are involved in returns, it is difficult for marketplace or seller to keep things in check.

Returns not received by seller accounts for highest losses in e-commerce business. It has double impact on losses, first seller is penalized for return and second return is also not delivered to seller. Our return reconciliation tool helps seller identify returns that are not delivered within promised time and also returns that are marked as delivered by marketplace but not received by seller. There is only one action seller is required to take in Ecom Books system that is mark all returns that are received by seller and system will provide return reconciliation is simple format, It features three tabs –

(a) All Returns

List of all returns, as seller marks the return as received that return is removed from the list and newly created returns are added in the list.

(b) Disputes Returns

Disputes returns lists all returns that are either marked as delivered by marketplace but not received by seller or returns are not delivered by marketplace within promised delivery date.

(c) Claim Raised

Once all disputed returns are raised with marketplace, seller can select all returns under disputes and mark them as claim raised. Claim raised tab is for convenience of seller to identify all returns for which disputes has already been raised.

3. Missing Return Claim Management

Raising disputes for missing returns in timely manner and keeping track of the same can be exhausting task, We at Ecom Books have in house claim management team which raises all disputes identified by Ecom Books system on sellers behalf and keep track till issue is resolved.

Our team at Ecom Books works relentlessly to make sure your online business thrives in the ever-evolving market and help you claim your missing products. Our back-end staff constantly interacts with the marketplaces regarding lost/missing returns while keeping you in the loop.

4. Unpaid or overcharged orders claim management

In house claim management team identifies unpaid or overcharged orders by working closely with sellers. Type of disputes that team identifies are weight overcharge, incorrectly charged returns and unpaid orders.

5. Profit Analysis

Despite keeping track of what is going out and coming in, calculating profit from ecommerce operations is not easy. Since returns are integral part of online business and returns are penalized by marketplaces, arriving at exact profit from ecommerce operations remain tedious job.

Our profit analysis provides SKU level profitability after factoring in cost incurred on returns. For e.g. a seller ships 100 orders of SKU – A, out of which 30 are returned. On the face of it assuming gross margin of 100 per order, seller has made 7,000 of profit, but this assumption is wrong since all returns carry certain cost. Assuming cost per return to be 100, seller’s margin shrinks to 4000. On the same basis our profit analysis provides sku level profitability by factoring in cost incurred on returns.

Profit analysis is further divided under two section

(a) Without GST

Profit analysis is done basis of actual bank settlement and does not consider GST input or output for the transactions – this is recommended for sellers with surplus GST input.

(b) With GST

Profit analysis is done basis of actual bank settlement plus Input GST on marketplace charges plus TCS minus output GST on sale. Recommended for sellers who have GST liability at the end of each month.

6. Data Analysis and Report

Informative dashboard gives you snapshot of your last 30 days orders, returns for respective marketplaces. Top selling products, SKU level returns % to identify high returned products. Disputes reports and reports with all claims that were approved by Ecom Books.

7. State Wise Monthly GST Reports

Upload your marketplace GST reports and get state wise, tax rate wise report at single click.

8. Tally Integration

Get all your sales orders, return orders recorded in your tally, and manage stock masters, your tally inventory via our seamless integration with tally.

9. Live Chat/Support

If you face any difficulty understanding the feature, or face any issue related to functionality, our Live Chat support is available between Mondays to Saturday between 10 A.M. to 7 P.M.