Prepare Inventory Records Before Counting
Before starting, confirm which warehouse, product categories, and storage locations are included. Review recent receipts, shipments, transfers, returns, and inventory adjustments so transactions are recorded consistently. If possible, pause movement of the items being counted during the count window or establish a clear cutoff procedure for transactions that must continue.
In Sage 100, use the Physical Count and Physical Count Entry functions available in your installed version and configuration. Menu names and available options can vary by release, security permissions, and enabled modules, so confirm the workflow in your system before beginning.
- Verify item numbers, descriptions, units of measure, and warehouse locations.
- Record the count date and define the inventory cutoff time.
- Assign counters and independent reviewers where appropriate.
- Prepare count sheets or supported counting records that do not reveal expected quantities when blind counting is required.
- Identify items such as damaged goods, stock in transit, and inventory held in separate locations for consistent treatment.
Enter and Record the Physical Count
Start by creating or selecting the physical inventory count record using the workflow supported by your Sage 100 installation. Specify the relevant warehouse and inventory scope, then generate the count information according to the system's available options. Check that the items included match the intended count area before distributing count instructions.
Count each item using its correct unit of measure. For example, if a product is stored in cartons but tracked in individual units, confirm the conversion before entering the quantity. Record the actual physical quantity rather than copying the expected on-hand balance. Keep notes for damaged, obsolete, unidentified, or unlabelled stock so a reviewer can investigate differences.
Enter the observed quantities into the appropriate physical count entry screen or supported import process. Review item numbers, warehouse codes, and quantities carefully before proceeding. If a count sheet is used, retain it as supporting documentation for review and reconciliation.
Review Variances and Reconcile Quantities
After entering the count, compare physical quantities with the recorded on-hand balances. A variance is the difference between the actual counted quantity and the system quantity.
Variance formula: Count variance = Physical quantity counted − System quantity on hand.
For example, Sage 100 shows 125 units of an item, but the team counts 118 units. The variance is 118 − 125 = −7 units, meaning the records show 7 more units than were physically found. If the item's inventory cost is $20 per unit, the potential inventory value difference is 7 × $20 = $140, subject to the applicable costing method and review.
Investigate significant differences before posting adjustments. Check recent transactions, unit conversions, warehouse transfers, receiving records, shipping documents, and duplicate or omitted entries. Document the reason for each material variance and obtain approval according to company policy.
Post Adjustments and Protect Financial Accuracy
Once variances have been reviewed and approved, follow the physical count update or adjustment process available in your Sage 100 version. Review the final quantities and the inventory adjustment details before posting. Depending on the configuration and accounting setup, inventory adjustments may affect inventory valuation and related general ledger accounts.
Retain count reports, variance explanations, approvals, and adjustment records. These documents provide an audit trail and help finance teams explain changes in inventory balances. A broader Physical Asset Count can also help a business verify equipment and other tangible assets, although inventory stock and fixed assets may follow different accounting and system procedures.
Inventory records can also intersect with tax compliance when inventory values, taxable transactions, or jurisdiction-specific reporting require supporting evidence. Physical counts do not independently determine tax treatment, so apply the relevant tax rules and retain documentation needed for review.
Improve the Process with Clear Controls
Repeatable counting procedures help teams maintain dependable stock records between full counts. Set count schedules according to item value, transaction volume, demand, and historical variance patterns. High-movement or high-value items may warrant more frequent checks than slow-moving stock.
For businesses extending finance workflows beyond Sage 100, the Hyperbots Platform supports company-specific configuration of ERP integrations, workflows, user roles, and general ledger structures. Its Process Specific Capabilities support AI-driven workflows for defined business processes, while Ready to Deploy Capabilities include pre-trained agents and ERP connectors. Self Learning Capabilities use human actions to refine workflow behavior, and Human in the Loop controls allow exceptions and approvals to remain under human oversight.
These capabilities may support connected finance operations, but the physical count itself must still follow the inventory functions and controls available in the organization's Sage 100 environment. For readers comparing related Sage workflows, AI Copilots for Sage 300 provides a separate overview of AI-supported finance operations in Sage 300; Sage 300 and Sage 100 are distinct products.
For tax-related inventory questions, the Arizona TPT Nexus Guide: Physical vs Economic Rules explains how physical presence and economic activity can affect Arizona transaction privilege tax obligations. Such rules are separate from the inventory counting procedure and should be reviewed when relevant to the business.
Summary
To do a physical count in Sage 100, prepare the count scope, control inventory movements, record actual quantities, investigate variances, and post approved adjustments using the workflow supported by your installed version. Keep count sheets and approvals for audit purposes, and use recurring checks to improve inventory accuracy. Reliable stock records help purchasing teams plan replenishment and help finance teams maintain credible inventory values and financial reports.