SMB's Features

1. Payment Reconciliation

An online seller ships hundreds of orders daily, and depending upon the 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 the big question that did I receive the actual payment for the items sold remains unanswered.

Our Payment Reconciliation is the right way to do this 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 four tabs that separate unpaid, incorrectly charged orders –

(a) Reconciled

List all orders for which the marketplace has initiated payment or made a deduction. 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.

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

(c) Disputes

Reconciled and payment awaited will have a large number of records making it hard for the 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 the due date provided by the marketplace, or there are deductions by marketplace even in case of orders that are not returned.

(d) Dispute Raised

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

2. Return Reconciliation

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

Returns not received by seller accounts for the highest losses in the e-commerce business. It has a double impact on losses, the first seller is penalized for return, and the second return is also not delivered to the seller. Our return reconciliation tool helps sellers identify returns that are not delivered within promised time and also returns that are reported as delivered by the marketplace but not received by the seller. The seller is required to scan all returns that are received by the seller and Ecom Books will provide return reconciliation in a simple format; it features three tabs –

(a) All Returns

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

(b) Disputes Returns

Disputes returns list all returns that are reported as delivered by the marketplace but not received by the seller. Or returns are not delivered by the marketplace by promised delivery date.

(c) Claim Raised

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

3. Missing Return Claim Management

Raising disputes for missing returns in a timely manner and keeping track of the same can be an exhausting task; we at Ecom Books understand this and offer claim management services that raise all disputes identified by the Ecom Books system on the seller's behalf and keep track till the issue is resolved.

Our team at Ecom Books works relentlessly to make sure your online business thrives in the ever-evolving market and helps 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

Our claim management team identifies unpaid or overcharged orders by working closely with sellers. Type of disputes that the team identifies is 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 e-commerce operations is not easy. Since returns are an integral part of online business and returns are penalized by marketplaces, arriving at exact profit from e-commerce operations remains a difficult task.

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 a gross margin of 100 per order, the seller makes 7,000 of profit, but this assumption is wrong since all returns carry a certain cost. The seller's margin shrinks to 4,000 if we assume a cost of 100 for each return.

Profit analysis is further divided under two section

(a) Without GST

Profit analysis is done basis on 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 on actual bank settlement plus Input GST on marketplace charges plus TCS minus output GST on sale and recommended for sellers who have GST liability at the end of each month.

6. Data Analysis and Report

An informative dashboard gives you a snapshot of your last 30 days' orders and returns for respective marketplaces.

Top selling products, SKU level returns % to identify high returned products.

Disputes reports and reports with all claims details that were raised by Ecom Books and approved by the marketplace.

7. State Wise Monthly GST Reports

Upload your marketplace GST reports and get a state-wise, tax-rate-wise report with a 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 Monday to Saturday between 10 A.M. to 7 P.M.

Large Enterprises Features

E-commerce Payment Reconciliation and Accounting Solution for Large Enterprises

Often enterprises struggle to reconcile their payments from e-commerce channels, leaving them with endless accounting adjustments at the end of the financial year.

On top of this, the sheer volume of b2c sales invoices, credit notes, and order level payments makes even the world's best ERPs struggle with performance.

With seamless integration with all the leading ERPs and Marketplaces, Ecom Books is helping enterprises manage their e-commerce payment reconciliation and accounting effortlessly.

Here is how we can help you with e-commerce accounting and invoice level reconciliation -

  • Post a few aggregated invoices each day to ERP instead of thousands
  • Complete invoice knockoff with settlements and credit notes
  • Net payment against each order/invoice
  • Marketplace deductions at the order/invoice level
  • Reconcile deductions with Marketplace commission invoice
  • Reconcile TCS and TDS credits from Marketplace
  • Reconcile credit notes/returns
  • Data insights and advanced analytics for decision making

If you are a large enterprise and want to streamline your e-commerce accounting and reconciliation, please drop a message.

1. Ecombooks


2. Integrations and Process Flow