This article shows users how to make changes to the Cost of Goods Sold report from an administrative perspective.
Overview
The COGS maintenance page serves as the single template for all stores' Cost of Goods reporting in Decision Logic. This page is set up during the implementation of your site. Users who are on Decision Logic’s newest V6 platform can view how to access and read their Cost of Goods Sold Report by following this link.
Cost of Goods Sold Report - V5
Users who are currently on Decision Logic’s V5 system can view the Cost of Goods Sold Report by navigating to:
Reports > Cost and Variance > Cost of Goods Sold
Select the Region, Group, and Store.
Select the Year, Period, and Week.
Click Next.
View Detail
Category as Accounting Category
Category Section Totals
Cost of Goods Dollars
Beginning Inventory $ by Accounting Category
Purchases $ by Accounting Category
Ending Inventory % by Accounting Category
Usage $ = (Bi + P - Ei)
Percentage of Sales = Usage / Sales
COGS Maintenance Accounting Categories
Users can create "Accounting Categories" that will be used for each ingredient or inventoried items Account. Users will begin by navigating to:
Maintenance > Product > COGS Maintenance
Click the Accounting Categories tab.
Click New to add a new Accounting Category.
Click on an existingcategory and then Edit to edit that category.
Enable Display Prices on Order Guides for each Accounting Category.
Users can Enable Sort to move categories Up or Down in the list.
COGS Maintenance Category Sections
Users can create a Cost of Goods Sold report template by navigating to:
Maintenance > Product > COGS Maintenance
Click the Category Sections tab.
Click New to add a new Category Section.
Click on an existingcategory section and then Edit to edit that category.
Enter the information requested or made edits.
Click Save.
Category Sections Details
Create Category Sections.
Enable or Disable Show Category Section on Report.
Define sections Parent Sections.
Define the Sales Departments the report will use as a divisor when calculating Usage on the Cost of Goods Report.
Define the Accounting Categories that each section will use when pulling in purchases.
The COGS Rollup view will only show COGS Categories that include at least one COGS Account which has been given a Department assignment in COGS Maintenance.
COGS Maintenance Prerequisites
Before setting up COGS Maintenance, it is best to ensure the following references are complete.
This will ensure you have all the required Accounts and Sales Departments configured for reporting on your Cost of Goods Sold Report.
If you are unsure how to re-design your Cost of Goods sold report, consult with Decision Logic.
Moving PPC Accounts to new accounting categories requires a historical COGS and TvA update.
When to Make Changes in COGS Maintenance
Below are some common reasons for changing COGS Maintenance.
Reason 1 Example
An Accounting Category needs to be moved out of 1 primary section into another.
Example:
You have set up the Accounting Category 'Grocery' under Food, but all ingredients in the grocery section should be moved to the 'Bar Supplies' Accounting category.
All Ingredients using Grocery need to be reassigned.
TvA and COGS Update.
Reason 2 Example
An Accounting category is not being divided by the correct sales totals.
Modify under Sections > Departments by adding or removing sales departments.
A historical COGS and TvA update may be required.
Reason 3 Example
E-Invoices are not importing correctly.
Some vendors' e-invoices may fail to import if you have set the vendor up to use a PPC Account that is not assigned to an Accounting Category in COGS Maintenance.
To resolve:
Assign the PPC Account to an Accounting Category in COGS Maintenance.