Excel Inventory Template for Tracking Stock

This free Excel template is available here:

https://www.beginner-bookkeeping.com/excel-inventory.html

Use it to track all the stock items for your small business.

There are now 3 versions available, one for up to 100 items, one for up to 300 items and one for up to 1,000 items.

Enter your Vendor|Supplier and Customer details.
Enter your Stock Details
Enter your stock purchases and sales, returns, damaged stock, missing or stolen stock
View an Inventory Report
Move stock around - when you take a portion of some stock items to manufacture new stock items
Take the total from this Excel inventory system and enter it into your bookkeeping software.

Use this in conjunction with the Excel Cash Book with Balance Sheet:
https://youtu.be/CDPv4UM7zhI

Видео Excel Inventory Template for Tracking Stock канала Beginner Bookkeeping