Troubleshooting: COGS Numbers
COGS accounts are not mapped in the POS Item Map.
Items do not have COGS accounts assigned.
Invoices were not entered in Yellow Dog.
Physical inventories were not committed.
More than one physical inventory was performed for the same period.
Physical inventory counts are inaccurate.
Waste or spoilage adjustments were not recorded.
Sales were not pulled into Yellow Dog or were not fully processed.
All items must have COGS accounts assigned to ensure accurate reporting.
Use the following reports:
Inventory Items with No COGS Account — Identify inventory items missing COGS assignments.
POS Items with No COGS Account — Identify POS items missing mapped COGS accounts.
Accurate purchasing records are essential for accurate COGS. Use a three-way match:
Yellow Dog invoice → Vendor invoice → Accounts Payable entry.
Keeping related documents together (stapled or scanned) simplifies month-end audits.
Helpful reports:
Purchase Order to Receipt to Invoice — Identifies purchasing documents that are not fully invoiced.
Detailed Invoice Report — Useful for clients using only invoices in their purchasing workflow.
Yellow Dog recommends performing one physical inventory per period (week, month, etc.). COGS compares one period’s physical count to the next, so consistency is essential.
Best practices:
Use separate count sessions for each area (for example, kitchen, liquor, wine, snack bar).
Ensure all active items are included in the physical inventory.
Helpful tools and reports:
Show Only Items with Variances (in the Physical Inventory Editor) — Quickly identify items needing recounts.
Item History — Investigate the source of variances for specific items.
Record waste and spoilage adjustments regularly to avoid large corrections at month-end.
Reports:
Adjustment Detail and Adjustment Summary — Verify that all adjustments were entered.
Confirm that all sales have been imported and processed in Yellow Dog.
Report:
All Sales Captured — Validate that all sales data has been pulled in.
Inventory Detailed Usage by COGS Account
-
Provides a detailed breakdown of COGS, including physical inventory impact, sales, purchasing, and manual adjustments.
-
Useful for analyzing how each factor contributes to overall COGS.
- Phone: 757-663-7514
- Email: support@yellowdogsoftware.com
- Chat: Click here to Chat with a YD Support Guide
Related Articles
Reporting Explained: Food Cost by COGS Department/Category
Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see their cost of goods sold percentage to better manage purchasing habits. For more information on setting up COGS please see How to ...Reporting Explained: Cost Reporting- Inventory Items with No COGS Account
Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see which inventory items are not mapped to a COGS account. This is useful for troubleshooting variances in COGS cost reporting and ...Reporting Explained: Cost Reporting- COGS Detail
Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see a detailed breakdown of their COGS accounts in relation to sales, purchasing, physical inventories, and manual adjustments. How it ...Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account
Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see a detailed breakdown of their COGS accounts in relation to sales, purchasing, physical inventories, and manual adjustments. How it ...Reporting Explained: F&B :Food Cost: Actual By Item
Business Need: This report is helpful for users who want a report to show the cost of goods for items sold between two dates. How it Works: A F&B>Food Cost>Actual By Item report shows the actual usage cost for items sold between two dates based on a ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...How do I use Par & Re-Order Points?
What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...What are Bins and how can I use them?
Bins are supplemental location markers. Unlike flags they do not have to be created prior to assigning them to items and are primarily used in in the stores tab to identify more precisely where an item is located. They can also be used in Physicals ...