Forum

Cost of Goods Sold (COGS) is a critical figure for any business that deals with inventory, as it directly impacts gross profit and overall profitability. QuickBooks, being a leading accounting software, provides tools and features that help businesses manage and track their COGS. However, due to various complexities and common errors, users often need to review and correct their COGS entries to ensure accuracy in financial reporting. This guide will walk you through everything you need to know about correctly managing and adjusting COGS in QuickBooks.

Table of Contents

1. What is Cost of Goods Sold (COGS)?
2. Importance of Correctly Recording COGS in QuickBooks
3. How Does QuickBooks Calculate COGS?
4. Common Errors in COGS Reporting in QuickBooks
5. How to Correct COGS in QuickBooks Desktop
6. How to Adjust COGS in QuickBooks Online
7. Correcting COGS for Inventory Items
8. Recording and Adjusting COGS for Non-Inventory Items
9. FAQs About Correcting COGS in QuickBooks

1. What is Cost of Goods Sold (COGS)?

COGS refers to the direct costs associated with the production of goods sold by a business. This includes the cost of materials, labor directly tied to production, and any other expenses required to produce inventory. In other words, it represents the amount a business spends to manufacture or purchase goods that it eventually sells.

Formula for COGS

The basic formula for calculating COGS is as follows:

Understanding this formula is key to properly recording COGS in QuickBooks, as it ensures that the expense aligns with the inventory levels reported in your balance sheet.

2. Importance of Correctly Recording COGS in QuickBooks

Correctly recording COGS is crucial because it impacts the profitability of your business. Misreporting COGS can lead to inaccurate gross profit calculations, incorrect tax filings, and potential issues with cash flow management. Businesses need to get their COGS right to:

• Ensure Accurate Profit Margins: If COGS is overstated, it reduces profit margins; if understated, it inflates profitability.
• Optimize Inventory Management: Accurate COGS reflects the cost efficiency of inventory purchases and production processes.
• Comply with Tax Regulations: For businesses filing taxes, the correct COGS value is vital for reporting taxable income.

3. How Does QuickBooks Calculate COGS?

QuickBooks calculates COGS based on the inventory items you add to your sales forms, such as invoices and sales receipts. When you sell an item, QuickBooks deducts it from your inventory and records the corresponding COGS. The software uses the average cost method to value your inventory and calculate COGS:

• Average Cost Method: It calculates the average cost of each item in inventory and applies that cost to COGS when an item is sold.

For example, if you purchase 100 units of a product at $10 each, and then 50 units at $12 each, the average cost would be:

When you sell a unit, the cost recorded in COGS will be $10.67 per unit.

4. Common Errors in COGS Reporting in QuickBooks

Businesses often encounter COGS discrepancies in QuickBooks due to the following reasons:

1. Incorrect Item Setup: Setting up inventory items incorrectly can lead to inaccurate COGS entries.
2. Misclassification of Expenses: Misclassifying direct costs (such as materials and production labor) under other expense categories can skew COGS.
3. Inventory Count Errors: Inaccuracies in inventory counts can result in incorrect beginning and ending inventory values, affecting COGS.
4. Incorrect Purchase Costs: If purchase costs are not entered correctly, the average cost calculation in QuickBooks will be off.
5. Adjusting Inventory Without Adjusting COGS: Manually adjusting inventory levels without adjusting COGS leads to mismatches in the cost of goods sold.

5. How to Correct COGS in QuickBooks Desktop

If you notice discrepancies in your COGS values in QuickBooks Desktop, you can make adjustments through the following steps:

Step 1: Review the COGS Account

1. Go to Lists > Chart of Accounts.
2. Find the COGS account and double-click to view the register.
3. Review the entries to identify errors or discrepancies.

Step 2: Adjust Inventory Values

1. Go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand.
2. Choose the Adjustment Type as Quantity, Total Value, or Quantity and Total Value.
3. Enter the correct values based on your inventory count and the cost of items.
4. QuickBooks will automatically adjust the COGS based on these changes.

Step 3: Correct COGS Entries Manually

If COGS was recorded incorrectly, create a journal entry to adjust it:

1. Go to Company > Make General Journal Entries.
2. Select the appropriate date and enter the COGS account.
3. Debit or credit the COGS account to increase or decrease the balance.
4. Include an offsetting entry, such as Inventory Asset, to balance the journal.

Step 4: Check for Sales Without Inventory Assignment

1. Go to Reports > Sales > Sales by Item Detail.
2. Look for any sales transactions where no inventory item is assigned.
3. Correct these sales by assigning the correct inventory items.

6. How to Adjust COGS in QuickBooks Online

In QuickBooks Online, correcting COGS involves a similar process but with a few variations in navigation:

Step 1: Review COGS Transactions

1. Go to Reports > Profit and Loss Report.
2. Click on the COGS account to view the transaction details.
3. Identify and note down any incorrect entries.

Step 2: Adjust Inventory Quantities

1. Go to Settings > Products and Services.
2. Select the inventory item you want to adjust.
3. Click Edit and adjust the Quantity on Hand and Reorder Point as needed.
4. Save the changes and note the new inventory levels.

Step 3: Create a Journal Entry

If you need to make direct COGS adjustments, create a journal entry:

1. Go to + New > Journal Entry.
2. Enter the date and add COGS as the account in the first line.
3. Debit or credit the account based on the adjustment needed.
4. Use an offset account, such as Inventory Asset, to balance the entry.

7. Correcting COGS for Inventory Items

If you realize that the cost of inventory items was entered incorrectly, follow these steps:

1. Locate the Item: Go to Lists > Item List (for QuickBooks Desktop) or Products and Services (for QuickBooks Online).
2. Edit the Item: Double-click the item and review the purchase cost field.
3. Update the Cost: Enter the correct cost and save the item.
4. Revalue Inventory: If you have several items, consider using an inventory revaluation tool to update costs across the board.

8. Recording and Adjusting COGS for Non-Inventory Items

For service-based or non-inventory items, the COGS account may not be linked by default. To adjust COGS for such items:

1. Create a New COGS Account (if needed):

   • Go to Lists > Chart of Accounts.
   • Click New > Expense > Cost of Goods Sold.
   • Name the account appropriately (e.g., "COGS - Service Items").

2. Link Non-Inventory Items to COGS:

   • Go to the item list and select the service or non-inventory item.
   • In the Expense Account field, select your new COGS account.
   • Save and close.

3. Adjust Transactions:

   • Review past transactions and update the expense account field to the new COGS account where applicable.

9. FAQs About Correcting COGS in QuickBooks

Q1. What should I do if my COGS is not matching my inventory levels?

• Answer: Review your inventory reports to ensure that the starting and ending inventory values are accurate. Reconcile your inventory counts with the COGS values and make adjustments where necessary.

Q2. How do I correct COGS for returned items?

• Answer: When a customer returns an item, use a credit memo in QuickBooks to reflect the returned inventory. This will update the COGS value and inventory levels accordingly.

Q3. Why is my COGS account showing a negative balance?

• Answer: A negative COGS usually indicates that items were sold before being added to inventory. Review your purchase and sales timelines to ensure inventory is entered before sales transactions.

Q4. Can I manually adjust COGS in QuickBooks?

Answer: Yes, through journal entries. However, be cautious when making manual adjustments, as it can lead to inconsistencies in your financial reports if not done correctly.

Q5. Does QuickBooks automatically update COGS when inventory is adjusted?

• Answer: QuickBooks will update COGS automatically when inventory adjustments are made, but this applies only if the adjustment is recorded through the proper channels (e.g., Adjust Quantity/Value on Hand feature).

Conclusion

Accurately recording and managing COGS is essential for maintaining reliable financial records in QuickBooks. By understanding how QuickBooks calculates COGS, identifying common errors, and knowing how to correct them, businesses can ensure that their profit margins and inventory reports reflect true financial performance. Always review your COGS values periodically and make adjustments as needed to keep your records accurate and up-to-date.