A spreadsheet here
A notebook there
maybe a platform or two
From my experience, owning a small business, inventory was the most challenging part of tax time – every year!
Make it easy on yourself by having a system in place to keep track of your inventory as you go:
Track raw materials, supplies, and components used to create products. Perfect for handmade sellers and makers who need to know what’s being used and when to reorder.
A dedicated tool to for those who do physical, end of year inventory counts. Plus an automation that resets and rolls inventory forward into the next year.
Track completed products, inventory on hand, and sales - including sales across multiple venues if needed.
A flexible inventory tracker that automatically calculates inventory on hand as items are added or used. Great for purchased inventory, Supplies, and Simple stock tracking
Designed for food-based businesses to track ingredient inventory, calculate recipe costs, and easily convert different food measurements (cups to TBSP's, etc).
Track inventory placed in stores, record sales, and automatically calculate commissions. Includes: Simple consignment tracking – if you are consigning your items to a store, and Store-level consignment tracking – for store owners tracking multiple consignors .
Now you can easily make any edits - for those who want to, but it's not necessary.
Tracking Inventory can get chaotic – I wanted to bring an organized approach to this challenge!
Time Saving Templates began over 10 years ago as a practical, DIY resource for small business spreadsheets and templates.
The inventory tools in this bundle were originally built for a real jewelry business – then refined and expanded over time based on customer requests and real-world use. As new inventory scenarios came up, the templates evolved to support them.
What you get today isn’t a single one-size-fits-all spreadsheet, but a library of inventory templates designed to handle a wide range of inventory situations – from raw materials and finished goods to food inventory and consignment tracking.
We’ve grown into a small but mighty team, and we’re here to support you as you use these templates for your specific business.
1. Raw Materials Inventory Management + Pricing and COGS
2. Finished Goods Inventory & Sales Management System
4. End-of-Year Inventory Template
4. Running Inventory Tally Spreadsheet
BONUS #1: Food Inventory & Recipe Costing Spreadsheet
Designed for food-based businesses to track ingredient inventory, calculate recipe costs and understand specific food product costs.
BONUS #2: Consignment Tracking Templates
Made just for a small boutique or store that accepts items on consignment, this template is a great way to organize your consignment inventory, sales and payouts due to consignors.
Simple consignment tracking – if you are consigning your items to a store, this template is included too.
BONUS #3: Get Started with Excel Video Guide
If you are new to using excel spreadsheets, this 6 part video series will cover all the basics you need to know.
The templates will be emailed to you within 24 hours of purchase, but usually it’s within a few hours during the daytime.
All orders are sent from [email protected] or [email protected]
Sometimes the emails can get stuck in the junk or promotions folders, so don’t forget to check there for it.
Yes! The templates are designed in MS Excel and are compatible with all versions of Excel.
With a Mac computer, you will need ‘Excel for Macs’ or Google Sheets. Templates do not work with Numbers program on the Mac.
Most templates work well with Google Sheets, which is a free program, as well as One Drive online Excel.
When purchasing the templates as-is, you agree to the licensing terms which allow the template to be used by the buyer only, and to not share the templates with others who haven’t paid for the product.
All templates come personalized with your name or business name, and that cell remains protected.
You may purchase the license upgrade to use the templates for your own clients, when it is part of a service you provide. See the Commercial license option at checkout for more details.
Most of the templates come with the cells with formulas protected, to provide a fool-proof experience and prevent someone from accidentally deleting or writing over a formula, which could cause the template to not work as described.
There is usually an extra fee to receive the editable formulas version of each template. When you purchase from this page, you will receive the editable versions as a BONUS for free.