Look Who it Was Random video

Ecommerce Tracker Spreadsheet Intro Video

2,103 views · Published 15 December 2017 · 9:05 · Indexed 21 September 2026

Channel: PROF SALES · 2017 · Education

Watch on YouTube

PROF SALES SPREADSHEET (Track your Ebay/Amazon results plus your Inventory) 

https://gum.co/vCrNy EXCEL VERSION

https://gum.co/dkKgY GOOGLE SHEETS VERSION

Intro: Thank you for purchasing the Ecommerce Tracker Spreadsheet

Video Purpose:
Brief Overview of the Workbook. Its pretty simple
Other videos in this playlist will describe individual tabs in more detail

Profit Summary Tab
Rows and Columns
Designed to Show your Sales, Expenses and Profits. Never Need to enter ANYTHING here...it’s all formulated
Collapsible years

Item Summary Tab
Also Formulated. Never need to enter ANYTHING here
Broken out by year and month
Shows summations of your selling activity Explain the various columns
Balances makes sure your totals are accurate across the Sales and Inventory tabs

Charts
Show Year Option tab at top
Explain Line Graph
Pie Chart at bottom with %s
As you add Platforms they will automatically add to the Pie Chart

Inventory
Has Formulated and Manual entry Columns
Allows you to enter all details about your Inventory
Form Creation is ONLY available for Windows users
More on this tab in the Inventory Video

Sales
Formulated and Manual Entry Columns
All your sales get entered here and the workbook uses this to produce Sales and Cost numbers
More on this tab in the Sales Video

Expenses
Formulated and Manual Entry Columns
All expenses for your business gets entered here including Inventory
More on this tab in the Expenses Video



Locations
Formulated and Manual Entry Columns
Allows you to Enter all the places where you keep your inventory
More on this tab in the Locations Video

Control Tab
Allows you to set up the platforms, expense types, Inventory locations
More on this Tab in the Control Video

Some Basics
Tabs can be moved to any order you wish
Once you have your copy of the sheet, it is HIGHLY recommended you save a blank copy separately
You should save your workbook in two different places in case something happens to one of your books
Save your work often
If you move columns or rows the workbook may not work properly. If you wish to do this I recommend you make a test copy of your workbook and experiment with it while leaving your master copy untouched
Please leave any questions, comments or suggestions below this video or any video in the playlist. I will respond to you here so that others who might have the same question can see the answer

Thank you so much for purchasing the Tracker. I hope you enjoy it as much as I enjoyed creating it! Be sure to check out the other videos in this playlist for detailed instructions on each tab

More from this channel