Discover how our inventory spreadsheet can help you take control of your inventory.
We developed InventoryMagic Spreadsheet to be easy to learn and fun to use.
InventoryMagic Spreadsheet is an Excel workbook on steroids. Leverage your Excel skills!
Explore the features of InventoryMagic by watching our 3 Quick Tour videos below.
(Audio is set on mute by default)
Inventory Magic Spreadsheet Video #1 - INTRODUCTION
This video reviews the following 4 items
- The Item Summary Sheet: A quick overview of your current inventory levels
- The Inventory In Sheet: Add items to your inventory
- The Inventory Out Sheet: Subtract items from your inventory
- The Inventory Report: Review your data quickly and easily
Inventory Magic Spreadsheet Video #2 - TIME-SAVING FEATURES
These features are designed to save you time.
- The Item Setup Sheet: Transfer your existing data into InventoryMagic Spreadsheet.
Get data from your Vendors.
- The Transfer In Sheet: Manage cases with different item quantities easily.
For example you get Coke cans in 6 packs, 12 packs & 24 packs.
- The Transfer Out Sheet: Manage kits of products or individual items with ease.
- The Order Report: Know when to reorder stock and how much it will cost.
Set your minimum and maximum levels and InventoryMagic will do the rest.
Inventory Magic Spreadsheet Video #3 - POWER USER FEATURES

These 'power features' will make you an inventory pro!
The Count Sheet: Make quantity adjustments in seconds
The Lists & Rules Sheet: Provides data validation, automatic backup, and more
The PJC Report: Calculate the inventory cost for projects, jobs, and clients
The Item History Report: Keep track of all inventory changes and keep your stock secure
The Physical Inventory Count Sheet: Handouts for the inventory takers
Time Tracker Video: 1
Audio on Mute by Default
TimeTracker was developed to calculate
and record time used or projected.
Tracking Employee Time, Department Time,
Project Time, and Customer Time are
some of it's uses.
You can watch the video below on
your PC or scan the QR Code to
view it on your smartphone.


TimeTracker provides pre-formatted fields to track the start-and-stop times of each day...by-project, by-employee, etc. TimeTracker then automatically tabulates the time spent—down to the minute—and provides a summary of that time that is always current.
Easy as 1, 2, 3.
QR Codes Video: 1
QR Codes are great tools for businesses.
They provide a quick and simple way for
your customers to access information that
you want them to see. All they need to do is
scan your QR code with their iPhone.
Our QR codes are Dynamic.
This means that you can change the site
or document that they connect to without
having to re-purchase a different QR code.
Extremely flexible!
You can watch the QR Code video on your
PC or scan the QR Code to watch it on
your smartphone.
Please note: There is NO audio in the
QR Code video.
