E Commerce Reconciliation

E Commerce Reconciliation

WHY ANALYSIS & RECONCILIATION

Each & Every Business Organization wants to grow its sale on a rapid ratio, at this point of view it fails to understand, reconcile/Analysis his actual margin/actual received, the actual margin, receipt may vary a sector to sector , as per our knowledge E-commerce sector now facing a lot of discrepancy now a days for Actual receipt. As per my working at an analysis job: I found below mistakes the accounts section did for ecommerce sector.

  • Sales Booked Not matched with channels (Market place) sale, & same organization is paying sales tax & vat for same, & booked a fake sale on its books off accounts, hence it would be liable to pay income tax more too.

  • Return management is another vital part for ecommerce sector to know net sale.

  • At the time of receipt it should match with booked sale, after that it can reconcile through receivable amount after deducting commission & other charges.

At the time of sale

 

Article name

sale as per Company

sp as per market place

Variation

GST paid @12% tax paid to Govt

Tax to be paid actual

Excess tax paid

Effects at the time of balance sheet final

#1234-Dress

1299

1199

100

140

128

12

>>>>>for excess booking too

At the time of receipt

 

Article name

sale as per Company

sp as per market place

Variation

Commission Percentage

Commission amount

Net payable by market place

Variation

Effects at the time of balance sheet final

#1234-Dress

1299

1199

100

33%

395.67

803.33

100

for excess booking too

Brief Glance about “E-Commerce Reconciliation & Analysis

  • ERA will help an e-commerce organization for B2B/B2C both module.

  • Return management & Find out the miss return would possible very smarter method.

  • By when your sale & return is correct its very easy to find out the net receivable from market place.

  • Also era is defining at its best for Commission/Shipping/Other charges after it we can find our actual receipt post deduction !

  • Tech error may happen at the time of pay out too, so ERA can easily find out the same discrepancy, seller can claim for same & find its actual receipt.

  • It has also option to find out that pay out amount actually received or not to bank. Finally ERA Can make correct Sale/Return/Receipt & Bank/Commission/ Other charges,

 

E COMMERCE RECONCILIATION SERVICES

 Keeping track of how much money sellers should receive from multiple marketplaces is the main object of Reconciliation. We also get the correct data of deduction, charges, Penalty etc on regular basic.

Due to the sheer volume of transactions in an e-commerce business, reconciliation processes with an unstandardized and manual approach inevitably lead to risky data entry, regulatory and compliance issues, among others.

We are providing E commerce reconciliation of Leading brand like Myntra, Flipkart, Amazon, Ajio etc .

We are providing reports to understand  your financial condition/ cash flow ,  past, present and future forecasting of your business.

Basic reconciliation reports are:

  • Order wise settlement, Return and unsettled reconciliation. It is a Micro level reconciliation to understand the amount received against order, It will help to find out the pricing of the product is profitable or we need to revise the price to get profit and what are the deduction, deducted against one particular order , is there any penalty or additional amount charged by the ecommerce portal or not 
  • SKU Wise Sales and return report.-By the help of this report you can forecast your production and it help to manage the warehouse stock.

  • Summary sheet to understand deduction and exact amount receipt

Rate Chart

Sl No

Portal

Rate Started From

1

Myntra

2500 per month**

2

Amaozn

1500 Per Month**

3

Flipkart

1500 Per Month**

4

Ajio

1500 Per Month**

5

Paytm/Meesho/Jio Mart and other site

1000 Per Month**

** Term and Condition as applicable