The ABCAUS Inventory Management Control Template is a free, automated Excel-based spreadsheet utility designed specifically to help small trading businesses and professional firms record, track, and value their stock. It utilizes embedded VBA macros to handle warehouse operations without requiring complex, standalone ERP software. Key Features of ABCAUS Inventory Management
Item Capacity: Supports tracking for up to 100 unique inventory items and their part numbers.
Multi-Store Tracking: Allows users to configure and track stock individually across three separate store locations.
Visual Reorder Alerts: Employs an automated threshold tracker that turns fields from green to red when stock drops below defined minimum safety levels.
Average Cost Valuation: Automates inventory accounting by using the weighted average cost basis per store location.
Custom Reporting: Generates immediate management reports grouped vendor-wise, store-wise, or item-wise. Step-by-Step Setup and Operating Guide Step 1: Configure Excel Environment & Security
Because the spreadsheet relies on background scripts, your local Excel environment must be configured properly before opening the file.
Open Microsoft Excel and navigate to the Trust Center via File > Options > Trust Center > Trust Center Settings. Select Macro Settings and check Enable All Macros.
Check the box for Trust access to the VBA project object model.
Adjust your computer’s system settings to ensure your Regional Date Format is set to English (UK) (DD/MM/YYYY).
Open the ABCAUS workbook and click Enable Content/Macros if prompted by the security bar. Step 2: Establish the Database
Before entering a transaction, you must map out your corporate data using the master setup wizard.
Navigate to the main dashboard (Gateway) and click Create Database.
Select Create Basic Data and fill out the name, address, and contact details of your firm.
Name your physical storage spots (up to 3 distinct store/warehouse locations).
Save the configuration and verify the parameters via View Basic Data. Step 3: Populate Items and Reorder Levels
Define the constraints for your parts and products to initialize the tracking engine. Head to the Item Master configuration tab.
Log your specific product names alongside their identifying Part Numbers or SKUs.
Manually set the Reorder Level Quantity for each item. This threshold dictates when the automatic red alert will trigger. Step 4: Record Stock Movements (Inflows & Outflows)
Keep your inventory live by logging daily activities as they occur.
Stock Inwards (Purchases/Receipts): Access the inward log tab, select the item using the dynamic drop-down menu, specify the target store location, and enter the quantity received alongside the vendor unit cost.
Stock Outwards (Sales/Usage): Log the quantities sold, shipped, or moved out. The spreadsheet will dynamically subtract these figures from your running balances. Step 5: Extract Management Reports
Utilize the reporting gateway to track your operational workflows.
Run periodic Store Location-wise reports to see exactly where stock is sitting.
Review Vendor-wise reports to audit incoming costs and procurement frequencies.
Review color-coded alerts on the main panel to spot low stock items instantly and place restock orders. If you want to move forward, please let me know:
Do you need help downloading the official spreadsheet template?
Are you looking to implement ABC analysis (sorting items by high/low financial value) alongside this software? What version of Microsoft Excel are you currently using?
I can tailor specific formulas or troubleshooting steps for your exact setup. ABCAUS Inventory Management Guide | PDF | Microsoft Excel