How to Prepare for a Cycle Count in Epicor
Before starting a count, establish which items, warehouses, bins, and inventory locations are included. Review recent inventory transactions and confirm that the counting team understands the units of measure and counting instructions.
- Select inventory items: Choose items based on value, movement frequency, production importance, or previous discrepancies.
- Confirm locations: Identify the warehouse, bin, lot, or other tracking dimensions relevant to each item.
- Review open transactions: Check receipts, shipments, transfers, material issues, and returns that could affect quantities during the count.
- Assign count responsibilities: Identify who will perform the count, review variances, and approve adjustments.
- Prepare count records: Ensure the selected items and locations are clearly identified before physical counting begins.
A well-defined Cycle Count program schedules regular checks according to inventory importance and movement patterns. High-value or frequently used components may require more frequent counts than stable, low-value items.
Step-by-Step Cycle Counting Process
Use the following general workflow to conduct a cycle count in Epicor. Menu names and transaction options may vary by version, so confirm the relevant procedure in your organization's Epicor configuration.
- Step 1: Open the inventory counting function. Navigate to the applicable inventory management or physical inventory area and locate the cycle counting functionality available in your system.
- Step 2: Select items and locations. Generate or select the count population according to the approved schedule, warehouse, bin, and item criteria.
- Step 3: Record physical quantities. Count the actual stock and enter the quantity using the correct unit of measure. Follow lot, serial number, and location requirements where applicable.
- Step 4: Compare counted and recorded quantities. Review the difference between the physical count and the system quantity for each item.
- Step 5: Investigate variances. Check recent receipts, material issues, transfers, returns, and other transactions to determine why the quantities differ.
- Step 6: Approve and post adjustments. Follow company approval rules and use the appropriate Epicor count-processing or inventory-adjustment function to update inventory records.
- Step 7: Verify the result. Confirm that the updated on-hand quantity, transaction history, and relevant inventory reports reflect the approved adjustment.
When working with Epicor ERP, distinguish between entering a count and posting an adjustment. A recorded physical quantity does not necessarily mean the inventory balance has been updated; verify the transaction status before closing the count.
How to Calculate and Investigate Inventory Variances
Inventory variance measures the difference between the physical quantity counted and the quantity recorded in the system.
Inventory Variance = Physical Count Quantity − System Quantity
Variance Percentage = (Inventory Variance ÷ System Quantity) × 100
For example, assume Epicor records 250 units of a component, but the physical count finds 238 units. The variance is 238 − 250 = −12 units. The variance percentage is (−12 ÷ 250) × 100 = −4.8%.
This result indicates that physical stock is 12 units below the recorded balance. Before posting an adjustment, review recent material issues, unprocessed receipts, incorrect bin transfers, and unit-of-measure conversions. If the system quantity is zero, calculate the unit difference and investigate the discrepancy separately because the percentage formula requires a nonzero denominator.
Document the reason for each material variance and apply the organization's approval thresholds. This creates a clear audit trail and helps identify recurring transaction or process issues.
Count Frequency, Thresholds, and Inventory Controls
Count frequency should reflect the value, movement, and operational importance of each inventory item. An ABC classification can help prioritize items: high-value or production-critical materials receive closer attention, while lower-priority items follow a suitable periodic schedule.
A Transaction Count Threshold can be used as a control parameter to determine when activity levels trigger additional review or counting attention. Organizations should define the threshold according to their own inventory policy rather than assuming a universal Epicor default.
For stronger control, separate counting responsibilities from adjustment approval where practical, maintain transaction references, and investigate repeated discrepancies. Inventory accuracy can be monitored using the percentage of counted items that match the recorded quantities.
Inventory Accuracy Formula: Inventory Accuracy = (Number of Items With Matching Counts ÷ Total Items Counted) × 100.
If 96 of 100 counted items match the system records, inventory accuracy is (96 ÷ 100) × 100 = 96%. Reviewing this measure over time helps managers evaluate whether count scheduling and inventory transaction controls are improving record reliability.
Connecting Cycle Counts to Purchasing and Finance
Cycle count results influence purchasing, production scheduling, inventory valuation, and working capital. If physical quantities are lower than expected, planners may need to reassess replenishment requirements or confirm that materials are available for scheduled production.
Purchase orders and receiving records should be reviewed when investigating inventory differences. A properly controlled procurement process connects purchase approvals, expected deliveries, goods receipts, and supplier invoices. For a broader view of purchasing workflows, PO in Sales: Purchase Orders in the Sales Cycle Guide explains purchase orders and their role in transaction management.
Finance teams should also understand how inventory adjustments affect financial reporting. The adjustment's accounting treatment depends on the transaction type, item valuation method, and configured posting rules. Consistent transaction records support reconciliation between inventory subledgers and the general ledger.
For invoice-related controls, Invoice Processing in 2025: Benchmarks, Bottlenecks, Fixes provides context on invoice capture, validation, matching, approval, and posting. These processes complement cycle counting by helping maintain accurate records of supplier purchases and receipts.
Reliable inventory data also supports working capital planning. Better visibility into available stock and future purchasing needs helps finance teams forecast cash requirements and assess liquidity. Optimize Cash Flow with AI: Insights from a CFO explores how cash visibility, forecasting, and payment timing contribute to financial decisions.
Automation and Best Practices for Cycle Counting
Businesses can strengthen inventory and finance workflows by standardizing count procedures, maintaining accurate item data, and using system records to prioritize reviews. When extending epicor through ERP integration, organizations should preserve inventory identifiers, transaction references, and approval controls so connected workflows use consistent information.
The Hyperbots Platform supports company-specific configurations for ERP integrations, workflows, roles, and general ledger structures through a no-code framework. Its Process Specific Capabilities support finance automation across defined workflows, while Ready to Deploy Capabilities include pre-trained agents, pre-built ERP connectors, and no-code configurability.
Self Learning Capabilities allow Hyperbots co-pilots to learn from human actions and refine workflows or general ledger coding. A Human in the Loop approach supports human review of exceptions and approval decisions. These capabilities can complement established inventory controls by supporting related finance processes and transaction review.
For consistent results, maintain a documented count calendar, investigate significant variances before adjustment, review accuracy trends, and reconcile inventory-related postings regularly. Use count results to update replenishment assumptions and improve coordination between warehouse, procurement, production, and finance teams.
Summary
To do a cycle count in Epicor, prepare the item and location list, count physical stock, compare the results with system quantities, investigate variances, and process approved adjustments. Verify the posted inventory balance and retain supporting records for audit and reconciliation. Regular counting, clear approval controls, and accurate transaction data improve inventory accuracy, operational continuity, and financial reporting.