Sales Tracking & Product Pricing Toolkit, Excel Worksheet Templates + How To buying Booklet for Creatives, Made by a Creative
Check our our awesome Toolkit for Creative Businesses these Excel.
Check our our awesome Toolkit for Creative Businesses, these Excel worksheets track your sales in multiple sales channels & help you to wisely create your prices for your buying products!
Testimonials:
"I would recommend this to anyone with a small business. Tippy provided some really practical and attainable skills to be able to track sales and price products. I feel like I now have the tools to build my business and grow as an entrepreneur."
"Tippy's done the leg work to create a system that we can all benefit from. I'm so happy to have this new tool for tracking sales in a more holistic and visual way."
"This toolkit is awesome and helped us expedite our launch."
The sales tracking sheet will tally:
- Your monthly & annual revenue, margins, and number of items sold
- Track sales per product by style, color, or other variants
- Expenses per product, via Cost of Goods Sold (COGS). This info is brought in from the Product Pricing sheet included in this toolkit
- % of Sales by Product and by Sales Channel
- Overall quantities sold per product both individually and by sales channel
- Cost of Markets/Events
- Transaction Fees & Sales Tax Paid, there are drop down menus to select your taxes & transaction fee types per sales channel. Making this SO easy to manage!
- Total Discounts given
- The average price that you are selling your products for (across all sales channels)
The Product Pricing sheet will:
- Calculate the total cost of labor and materials per product
- Recommend the retail and wholesale price
- Show your profit per unit
- A second pricing sheet also calculates the donation amount per product, if you are interested in giving back to a partner cause. You can change the donation amount & the donation and profit totals are adjusted.
I've been in business for seven years and as a designer with a creative background, I never had to use Excel before. Over the years Excel and I have become better friends and I have developed these sales tracking and product pricing sheets to track my monthly and annual sales.
These worksheets now help me to make solid business decisions via easy to comprehend vital information per product and sales channel. I realized that these tools would also be helpful to my fellow makers and designers, these will help save you headaches and time, as I've already done the work! Organize your sales and pricing data & easily tell which products and sales channels you are doing the best in and highlight where you might need to make adjustments. We have unique information needs as product makers, designers, and seller and I've done my best to include these in our sales tracking sheets.
*Biggest thanks to the amazing team of MBAs from Ross Business School in Michigan. They came to New Orleans to work with me for a week as part of their summer road trip, Ross Open Road (formerly MBASxUSA), they helped me really finesse these worksheets to become a powerful tool for our small businesses!
Check out our intro video on youtube: https://www.youtube.com/watch?v=REgvjQEWhWQ