
DO YOU SELL ON MULTIPLE PLATFORMS and have difficulty tracking your daily, weekly, or monthly sales totals? Welcome to your new favorite tool, The Reseller Sales Tracker. A spreadsheet designed for use in Microsoft Excel (can also be uploaded to Google Sheets) to monitor your business profits.
CREATED BY A RESELLER FOR RESELLERS so you know that your business needs are understood. It’s time to put the calculator down because this spreadsheet is crafted with powerful formulas to do the work for you. Simply enter in your sales on the sales page and watch the calculations begin. Track important metrics such as: running daily sales total, # of items sold per day/platform/month/year, monthly & annual asp (average sale price), PLUS monthly goal tracking & so much more.
FULLY CUSTOMIZABLE LAYOUT to fit your individual needs. The spreadsheet comes in a neutral coffee theme, but all style aspects can be adjusted to your preference. Edit the font style & size, change the coloring to match your business, or add columns for additional platforms you sell on. Not tech savvy? Don't worry, I have a guide that can walk you through making these minor changes.
SHOULD I USE MICROSOFT EXCEL OR GOOGLE SHEETS? Each program has their own pros & cons, so here’s a run-down of the most important features to assist with making that choice. For Microsoft Excel, an active license is required to edit this spreadsheet. If you do not have an active license, you will need to purchase it from the Microsoft online store. Excel offers the capability to bulk edit pages (incredibly easy to change fonts, colors, text sizes, etc.) To access the spreadsheet across multiple devices, you will need to save the spreadsheet to your OneDrive or iCloud account. Saving in these locations will allow you to access this spreadsheet on any device where you have access to your OneDrive or iCloud account. Additionally, the spreadsheet will auto-save after any change when saved to a OneDrive or iCloud account. You will need to manually save the changes if it is only saved to your computer. Excel is my personal preference as it offers more functions than Google Sheets. For Google Sheets, you will simply need a Gmail account to access & edit this spreadsheet. The downloadable file will come in an excel format which you will need to upload into your Google Drive account. To access google sheets, navigate to drive.google.com in your browser’s address bar. A google sheets spreadsheet can be accessed from any device where you access your Google account. Any changes made to the spreadsheet in google sheets will auto-save. There is no bulk edit option, so changing colors, fonts or text styles is not as efficient as Excel.
Let's get down to the nitty gritty.
The pages included in this spreadsheet are as follows:
Summary page
Quick glance header
Year to date sales total
Annual sales goal
Goal progress tracker
Highest & lowest sales day
Summary table provides easy access to monthly statistics
Gross sales
Total # of items sold
Average sale price
Average profit margin
Net profit
YTD totals
Monthly averages
Visual sales chart featuring YTD sales & goal tracking
Visual chart displaying 25 highest grossing brands for the year
Sales page
You will log each sale on this page
Required fields: date, price & platform
Optional fields: fees, listing title, sku, brand, size, category, cog, inventory
Automated fields: earnings, profit & pm(profit margin)
Monthly pages
Quick glance header
Month to date sales total
Monthly sales goal
Goal progress tracker
Total # of items sold
Highest & lowest sales day
Total sales featuring detailed breakdown # of items sold per platform per day
Visual sales chart featuring day by day sales trends & goal tracking
Visual chart displaying 10 highest grossing brands for the month