Extension Report

Overview:

The Extension Report calculates and reports the extended value of the Item quantities recorded for an inventory count. The report can be run in detail or summary. An example is shown below:

Things to know!

This report will only be accessible and visible to users who are given access to this report function.
The Extension report will include all Items that were recorded for a selected Count date.
The Extension report can be listed in detail or summary. Summary lists valuations by Inventory Category and Inventory Department only (no Item detail). The summary view is often utilized to view GL (General Ledger) Account values.
COGS-Well provides multiple valuations and costing methods such as Effective or Weighted Average Cost. For more information please click this link for Valuation Methods - FAQs.
The Valuation Method (Effective Cost or Weighted Average Cost) for an Extension Report is determined by the selection made in Company Settings (Company > Setup > Company Settings).
Inventory Items, Recipe Items, and Combined Items can be counted in an Inventory Count.
For more information on entering inventory counts, please click this link: Inventory Counts.
This report defaults to print item values by Pack Size. Items can be configured, however, to report by Count Unit for this report. For more information on changing the "Reporting Unit", please see this link: Report Units - FAQs.

Report Parameters

To Run the Extension Report, use the Sidebar to navigate to the "Count" menu option and select the Extension Report from the submenu. Upon selection, a Report Parameters screen like the one below will display:

Site: This filter only displays if you are logged into your company (versus a specific Site). The drop-down enables a search and selection of your desired Site.

Count date: From the drop-down menu select the Count Date to be listed.

Detail or Summary: Select if the report will be printed in detail (All items) or in Summary (Inventory Department and Inventory Category only). Sample reports for Detail and Summary versions are shown below.

Explode Recipe Items into Ingredients: This is best explained via an example. Let's say we have a Recipe Item for Chicken Salad - Prep and we have flagged it to be counted when we enter inventory counts. If we counted 5 pounds of Chicken Salad, the Inventory Extension Report will report a count of 5 pounds and an extended value using the cost of the combined ingredients.

If you check the box for the "explode" option, then instead of reporting a count and value for Chicken Salad, it will add the quantity and value to each ingredient (the chicken, the celery, the mayonnaise, etc). Please keep in mind that if you are entering Production for a Recipe Item, then this feature will not apply because the ingredients are depleted when you enter Production.

Inventory Department: If you want to run the report for a specific Inventory Department (an example might be the Food Department), you can use the drop-down to select your desired Department. If you do not select a specific Department then all Departments will be included.

Inventory Category: If you want to run the report for a specific Inventory Category (an example might be White Wines), you can use the drop-down to select your desired Category. If you do not select a specific Category then all Categories will be included.

Inventory Item Group: If you want to run the report for a specific Inventory Group (an example might be Dairy), you can use the drop-down to select your desired Group. If you do not select a specific Group then all Groups will be included.

By Storage Location: If you want to run the report for a specific Storage Location (an example might be the Walk-In Cooler), you can use the drop-down to select your desired Storage Location.

Storage Location: If you select to report by Storage Location, then the option to select a specific storage location will display. Use the drop-down to select a specific storage location. If you leave this field blank, then all storage locations will be reported.

Include Items with Zero Counts: In inventory Count Entry, you can enter a "0" as the count for an item to indicate the item is no longer in stock. An item with a 0 count will then not show up on the next inventory count entry or count worksheet unless you receive it again before the count. Check this box if you want to include items with a 0-count entry in the extension report.

Display Individual Reports by Site: Check this box if you have multiple sites and you would like an extension report to run for each site. Each site will report individually.

Run Report: Once you have selected your report parameters, click the Run Report button to list the report.

Extension Report - Detail Selected:

Selecting to Run the Extension Report in detail will display a report similar to below:

The detailed extension report is first sorted by the inventory department and then by the inventory category within that department. Each item within a category is listed along with its count, pack cost, and extension value. An extension value for each category is subtotaled and the value for each category within a department is added to provide an extension for the department.

Drill-Down Option: The values in the count column are in light blue. You can click on a count value to see the count detail for packs and count units. In the example below, we have drilled down on the count for the item "Deli Roll, Sweet French". The drill-down enables us to see both the pack and count unit quantity that was entered:

Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.

Extension Report - Summary Selected:

Selecting to Run the Extension Report, in summary, will display a report similar to the below:

The summary extension report provides an extension for each inventory category within a department. An extension value for each category is subtotaled and the value for each category within a department is added to provide an extension for the department. The extension value for each department is added for a total.

Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.