This Simple Inventory and Sales Tracker Spreadsheet has a tab that shows your current inventory, sales and re-stocking transactions.
 |
| Click image to enlarge Inventory tab |
Tracking Inventory
The Inventory tab shows the current state of your inventory. This automatically calculated by considering your beginning inventory, re-stocking and sales made for the product. It also contains the unit sales price used for sales transactions.
Recording Sales
Sales are processed using the Sales tab. To facilitate recording, a drop-down lists are provided with one containing all of the products listed in the Inventory tab and another for the methods of payment accepted. The unit price is also dynamically determined from the Inventory tab and used to automatically calculate the sales price.
 |
| Click image to enlarge Sales tab |
Re-stocking transactions
Whenever you need to re-stock your inventory, every purchase should be recorded in the Stock Replenishment tab. This tab also contains the same drop-down feature found in the Sales tab. All transactions recorded in this tab will immediately be reflected in the Inventory tab.
Want to purchase this product?
This Simple Inventory and Sales Tracker Spreadsheet is an easy tool to use. If you are interested with this, this product is available for purchase for GBP 4.99 using the button below. Before you buy please ensure that you read the purchase and delivery process and our terms of use.
