Sales & Costs Report
Overview:
The Sales & Costs Report enables you to report your inventory item, category, and department costs in dollars and as a percentage of sales. The costs are calculated using receiving, transfers, production, and inventory depletion. This report can be summarized or include item detail.
The difference between this report and the Actual Cost of Sales Report is it does not require a starting and ending inventory count date. It can, therefore, be run for any date range to provide you with a spot check on your cost of sales. An example of the report is shown below:
Things to know!
- A POS interface is required to capture the sales used in this report.
- The costs are calculated using receiving, transfers, production, and inventory depletion.
- Revenue for this report is based on the sales mix imported from your POS system.
- This report runs for a selected date range.
- 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 a Sales & Costs Report, use the Sidebar to navigate to the Cost of Sales Reports menu option and then select the Sales & Costs 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 Date: From the drop-down calendar, select a date.
End Date: From the drop-down calendar, select a date.
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.
Sales and Costs Report - Detail:
Selecting to Run the Report with the detail selected will display a report similar to the one below:
The Sales and Costs Report when Detail is selected, first reports the total revenue for the first Sales and 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.
Sales and Costs Report - Summary:
Selecting to Run the Report with Summary selected will display a report similar to below:
The Sales and Costs of Sales Report when Summary is selected, first reports the total revenue for the first Sales and 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: