Inventory Control - Trade Based Template

Use this inventory control template to analyse the profitability of any trade-based business by calculating the gross profit margins of all inventory items. Control inventory by performing physical stock counts and analysing stock take variances; calculating stock valuations and measuring sales, cost of sales & gross profits based on any user defined date range. Uses average cost basis.

• Suitable for trade based businesses which buy & sell products
• Create stock codes for all inventory items
• Record purchases, sales and inventory adjustments
• Inventory valuation on an average cost basis
• Includes stock count feature & calculation of stock count variances
• Automated calculation of theoretical inventory balances
• Unique dashboard for analysis of inventory movements
• Analysis of sales, cost of sales and gross profit for any date range