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
