Actual Cost Of Sales Report
Overview:
The Actual Cost of Sales Report enables you to report your inventory item, category, and department costs between count periods. Costs are shown in dollars and as a percentage of sales. This report can be summarized or include item detail.
The actual costs in the report are based on actual usage which is determined by beginning inventory + receiving, +/- transfers - ending inventory. The revenue figures in this report are based on the sales mix that is imported from your Point of Sale. An example of the report summary is shown below:
Things to know!
- A POS interface is required to capture the sales used in this report.
- Costs for this report are based on beginning inventory + receiving, +/- transfers - ending inventory.
- Revenue for this report is based on the sales mix imported from your POS system.
- This report runs for a date range to calculate your inventory usage cost and sales revenue between two Inventory Count dates.
- This report uses Sales and Cost Classes, Inventory Departments, and Inventory Categories configured during your initial setup. If you would like to make changes please use the links or contact support at support.cog-well.com and we will be happy to assist.
- The detailed version of this report shows item usage 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 an Actual Cost of Sales Report, use the Sidebar to navigate to the Cost of Sales Reports menu option and then select the Actual Cost of Sales Report from the submenu. Upon selection, a Report Parameters screen like the one below will display:
Site Group: If you are logged in at the company level, and if you have set up site groups, then you can use the drop-down to select a site group.
Site: If you are logged in at the company level and you have multiple sites, then you can use the drop-down to select a site. Leaving it blank will consolidate all sites.
Begin Count Date: From the drop-down calendar, select a date for the starting inventory count.
End Count Date: From the drop-down calendar, select a date for the ending inventory count.
Detail or Summary: The detail will include all Items in each Inventory Category. The summary will show Inventory Category and Department totals only.
Price Type: You can use the drop-down to select the average, retail, or model price for menu items on this report.
Include Average Company Cost Percent: If you have multiple Sites, then checking this box will provide an average for all Sites. If you have set up Site Groups, checking this box will allow you to select a Site Group to use for the average cost percentage.
Run Report: Once you have selected your report parameters, click the Run Report button to list the report.
Actual Cost of Sales Report - Detail:
Selecting to Run the Report with the detail selected will display a report similar to the one below:
The Actual Cost of Sales Report when Detail is selected, first reports total revenue for the first Sales & Cost Class. It then reports the usage quantity, cost, and percentage of sales for each item in an Inventory Category that is linked to the Sales and Cost Class. If multiple Categories are linked, there will be a subtotal after each Category.
After the first Sales and Cost Class is completed, the report will repeat itself for the next Class until all Classes and Inventory Categories have been reported:
Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.
Actual Cost of Sales Report - Summary:
Selecting to Run the Report with Summary selected will display a report similar to below:
The Actual Cost of Sales Report when Summary is selected, first reports total revenue for the first Sales & Cost Class. It then reports the usage cost and percentage of sales for each Inventory Category that is linked to the Sales and Cost Class. If multiple Categories are linked, there will be a summary after each Category (Dry Goods, Produce, Meat, etc).
After the first Sales and Cost Class is completed, the report will repeat itself for the next Class until all Classes and Inventory Categories have been reported. Jake's Cafe in the example below, does not serve alcohol. If they did, you would see Sales and Costs for Liquor, Beer, and Wine: