Arun is one of our customer eCommerce managers; his role is to keep running the operations on different channels like their website, Amazon, Flipkart, PayTM, and such 12 other portals.
One of the vital problems Arun faces is to collect all the sales data from across the channels to look at one unified sum at the end of the month or quarter with the company bosses.
We realized this is a concern that many eCommerce vendors face in their daily operations. Such data is necessary to evaluate the company efforts, how they are performing as detailed datasheets from different platforms is overwhelming and does not give a precise business progress numbers at the end of the month.
We have come up with a simple tool, that helped capture just the monthly numbers in a simple easy to use excel format, and you have the essential analytics - the sales analytics at your fingertips.
If you, too, have been searching for a free simple & easy to use sales tracking tool, we might be able to help. You can use the template we created using google sheet.
Using the tracking sheet, you can now track the sales numbers of your store from multiple channels and compare month by month or quarterly.
How to use the sheet
Click on the free eCommerce sales tracking sheet, open in a new window. Then go to the File menu and click on create a copy.
Once the copy is created, you can edit the names of the channel on the left column and then start inserting monthly sales figures for the last months. The objective is to share with you a preformatted tool that you can pick and start using.
Tips: Enter the monthly data for last year and current year to enable the team to quickly see compare current month progress with the same month the previous year.
Benefits of using the template: