Course overview
Inventory plays a critical role in the financial health of any business, whether in trading, manufacturing, contracting, or service industries. Its impact extends across the income statement and balance sheet. This course provides a step-by-step guide to best practices in managing inventory, from the purchasing process to cost allocation, while exploring cost flow assumptions like FIFO, LIFO, and weighted average. Participants will also learn how to ensure accurate inventory valuations, reflect net realizable value, and use tools such as Excel and pivot tables for analysis and calculations.
Training methodology
This interactive course combines brief expert-led presentations, group exercises, and practical case studies. Participants will apply their learning using Excel and present their results to enhance understanding and collaboration.
Target competencies
- Accounting for inventory transactions.
- Financial reporting of inventory balances.
- Applying professional judgment for special cases.
- Analyzing inventory movements.
- Utilizing Excel and pivot tables for data analysis.
Course objectives
By the end of the course, participants will be able to:
- Identify different inventory types and construct a complete inventory cycle, from purchasing to sales.
- Differentiate between perpetual and periodic inventory methods and evaluate various cost allocation techniques.
- Accurately measure and account for inventory in line with IFRS and GAAP standards.
- Understand the impact of inventory accounting policies on financial statements, including write-downs and write-backs.
- Apply professional judgment in accounting for inventory not physically on hand.
- Analyze the effects of different cost flow assumptions on financial statements and income.
- Utilize Excel and pivot tables to analyze inventory balances and calculate weighted average costs.
Course outline
1. Introduction to Inventory
- Role of inventory within current assets.
- The four primary reasons for maintaining inventory.
- Inventory cycle overview:
- Ordering and receiving.
- Sales and delivery.
- Best practices for inventory counting.
- Inventory types across industries: merchandise, manufacturing, construction, and real estate.
- Distinguishing inventory from fixed assets and investment properties.
- Analyzing and understanding inventory ratios.
2. Accounting for Inventory
- Comparing perpetual and periodic inventory systems.
- Differences between cost accounting and financial accounting.
- Cost allocation techniques:
- Direct material, direct labor, and manufacturing overhead.
- Initial recognition of inventory:
- Costs of purchase and conversion, including rebates and discounts.
- Post-recognition measurement:
- Calculating net realizable value (IFRS).
- Market price determination under the Lower of Cost or Market (LCM) method (GAAP).
- Handling slow-moving and obsolete inventory: write-downs and write-backs.
- Accounting for errors during physical inventory counts.
3. Special Topics in Inventory Accounting
- Accounting for inventory not physically on hand:
- Consigned goods.
- Goods in transit (understanding Incoterms).
- Inventory sold with rights of return or subject to installation and inspection.
- 'Bill and hold' sales.
- Inventory as collateral (inventory credit).
- Impact of inventory accounting policy changes on financial statements.
- Key inventory disclosures required by IFRS and GAAP.
4. Inventory Cost Flow Assumptions
- First-In, First-Out (FIFO) vs. Last-In, First-Out (LIFO).
- Weighted average and moving average methods.
- Specific identification of inventory costs.
5. Inventory Estimation and Cost Accounting Approaches
- Inventory estimation techniques:
- Gross profit method.
- Retail method.
- Cost accounting methodologies:
- Traditional costing vs. activity-based costing.
- Target costing vs. cost-plus pricing.
- Standard cost accounting.
- Throughput accounting.
6. Using Excel for Inventory Analysis
- Consolidating inventory data for analysis.
- Validating data accuracy.
- Identifying slow-moving and obsolete inventory.
- Recalculating weighted and moving average costs.
- Leveraging pivot tables for efficient inventory analysis and reporting.