# Oracle EBS Cycle Count Setup and Variance Worksheet > Source: https://netray.co/tools/oracle-ebs-cycle-count-setup-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable worksheet to plan ABC cycle counts, record counted quantities and see variance in units and value before you approve adjustments in EBS. ## Category oracle ## Erp Oracle E-Business Suite ## Industry Discrete Manufacturing ## Audience - EBS consultant - Inventory controller - Warehouse manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Item **Key:** item **Type:** text #### Subinventory **Key:** subinv **Type:** text #### ABC class **Key:** abc **Type:** select **Options:** - A - B - C #### System on-hand **Key:** system_qty **Type:** number **Unit:** units #### Counted qty **Key:** counted_qty **Type:** number **Unit:** units #### Unit cost **Key:** unit_cost **Type:** number **Format:** currency #### Variance qty **Key:** var_qty **Type:** number **Expr:** counted_qty - system_qty **Format:** number #### Variance % **Key:** var_pct **Type:** number **Expr:** if(gt(system_qty,0),(counted_qty - system_qty) / system_qty * 100,0) **Format:** percent #### Variance value **Key:** var_value **Type:** number **Expr:** (counted_qty - system_qty) * unit_cost **Format:** currency #### Count date **Key:** count_date **Type:** date **Rows:** **Item:** AS-10045 **Subinv:** STORES **Abc:** A **System qty:** 420 **Counted qty:** 418 **Unit cost:** 12.4 **Count date:** 2026-10-05 **Item:** AS-20310 **Subinv:** STORES **Abc:** A **System qty:** 96 **Counted qty:** 96 **Unit cost:** 148 **Count date:** 2026-10-05 **Item:** FG-77120 **Subinv:** FGI **Abc:** B **System qty:** 35 **Counted qty:** 33 **Unit cost:** 310.5 **Count date:** 2026-10-06 **Item:** RM-30221 **Subinv:** RAWMAT **Abc:** B **System qty:** 1800 **Counted qty:** 1812 **Unit cost:** 2.1 **Count date:** 2026-10-06 **Item:** HW-90012 **Subinv:** STORES **Abc:** C **System qty:** 5000 **Counted qty:** 4940 **Unit cost:** 0.08 **Count date:** 2026-10-07 **Totals:** #### Net variance value **Key:** var_value **Agg:** sum **Format:** currency #### Net variance units **Key:** var_qty **Agg:** sum **Format:** number **Summary:** #### Lines counted **Key:** lines **Expr:** count **Format:** integer #### Average variance per line **Key:** avg_abs **Expr:** sum_var_value / count **Format:** currency **Primary:** true **Notes:** Add one row per item and subinventory counted. Enter the system on-hand shown on the cycle count entry screen, then the physical count. Tolerances and approval routing are set on the cycle count definition in your EBS instance. ## Content **Intro:** Cycle counting in Oracle Inventory is configured in the cycle count header, but most teams still track counts, variances and recounts in a spreadsheet before they approve adjustments. This worksheet gives you that grid with variance maths built in. **Sections:** #### How to use the worksheet **Body:** Enter one row per item and subinventory scheduled for count. Type the system on-hand quantity from the count entry screen and the physical quantity from the count team. The sheet computes variance in units, percent and value using the unit cost. Use the ABC column to confirm that class A items are counted more often than class C, then export to Excel to attach to your adjustment approval or audit file. **Bullets:** - Fill system quantity before the count, to keep counters blind if your process requires it - Record the date so recounts are traceable - Sort by variance value to review the largest exposure first #### How cycle counting works in Oracle Inventory **Body:** A cycle count header defines the scope: subinventories, ABC classification, count frequency per class and tolerances for positive and negative adjustments. Counts are generated as requests, entered in the count entry window, and variances beyond tolerance go to approval before adjustments post as cycle count adjustment transactions. The ABC assignment is typically by on-hand value or usage. This worksheet mirrors that flow so you can prepare, review and document each cycle. #### Reading variance results **Body:** A small variance percentage on a high-value item can matter more than a large percentage on a low-cost fastener, so always read the value column. Repeated negative variances in one subinventory usually point to unrecorded issues, scrap not transacted, or a unit of measure mismatch. Repeated positive variances often come from unreceived or double-counted receipts. Use the net figure for a quick health check, not as a replacement for investigating the individual lines. #### Common mistakes **Body:** Most cycle count problems are process rather than system issues. Counting while transactions are in flight produces false variances, so freeze movement in the area or note open transactions. Mixed lot or serial controlled items need counts at lot or serial level, not only at item level. Costs also matter: if the unit cost is stale, the value variance misleads the approver. Confirm cost with your cost accountant before the adjustment is approved. **Cta:** If you want counts, variances and approvals pulled straight from your EBS data instead of re-keyed, Netray can build a read-only view over your ERP data. **Faq:** #### Does this connect to Oracle EBS? **Answer:** No. It runs fully in your browser and nothing is sent anywhere. You type or paste values from EBS, review the variance, and export to Excel or PDF. It is a preparation and documentation aid, not an integration. #### How often should class A items be counted? **Answer:** There is no fixed rule. Many sites count class A items several times per year, class B a couple of times and class C once. Choose frequencies that match your shrink risk and audit needs, and set them in the cycle count definition. #### Can I use this for physical inventory too? **Answer:** Yes for the variance arithmetic. A physical inventory covers all items at once and has its own tag generation and adjustment process in Oracle Inventory, but the same system versus counted comparison applies. #### What unit cost should I use? **Answer:** Use the item cost for the organization being counted, from your costing method such as standard or average. If cost is not current, tell the approver the value variance is indicative only. ## Search terms oracle ebs cycle count worksheet, oracle inventory cycle count excel, ebs cycle count setup, cycle count variance template, oracle ebs abc classification cycle count, cycle count adjustment approval, oracle inventory count variance --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json