cancel
Showing results for 
Search instead for 
Did you mean: 
jenason
Level 1

Tracking COGS in QB Online

We are a Motorcycle parts retail shop. "Motorcycle" is categorized as an Inventory Asset in Chart of Accounts.  We do not itemize the inventory, we just purchase and sell Motorcycle inventory.

When we purchase parts, it is entered as a new Expense and the Product/Service is Motorcycle.

When something is sold, it is entered as a new Sales Receipt and the Product/Service is Motorcycle.

I ran a Cost of Goods Sold for the year-to-date, and there are 100+ consecutive lines showing the same amount in the last couple months. The Sales receipts they are all tied to in the report are all different sales amounts. Previous to the last couple months, this occurred just a couple of times but only 4 consecutive same amounts. I referred back to my Sales & Expenses tabs and tried to find something that stood out as a reason, but I'm unable to figure it out.

4 Comments 4
Tori B
QuickBooks Team

Tracking COGS in QB Online

Hey there, @jenason

 

Thanks for reaching out to the Community for support, and sharing a screenshot of your report. I can see how frustrating it can be when your reports aren't showing the correct data that you need. 

 

To clarify, if you click one of the $318.72 amounts, the transaction that opens doesn't contain that number whatsoever? If so, I recommend clearing the cache from your web browser. Web browsers collect cache to save time when loading repetitive data and images. These files can often become outdated and corrupted, causing issues like the one with your report. I've included the links for all supported browsers that contain the steps to clear the cache below. 

 

Alternatively, you can use a different web browser or the App

 

Please know I'll be here every step of the way if you have questions or concerns. You can reach out to the Community or me at any time. Take care and have a wonderful week!

jenason
Level 1

Tracking COGS in QB Online

Correct, when I click on one of the consecutive amounts, that number is nowhere. Clearing the cache helped change the numbers, but now the repeated amount is $159.38. I'm attaching that new report here.

Currently I'm using a desktop at the office. I haven't tried downloading another browser yet. 

jenason
Level 1

Tracking COGS in QB Online

There are also 2 to 3 repeated amounts of $3,800 here and there.  I'm attaching one view of when I click into a $159.38 amount (10/22)... It's the same scenario when I open a $3,800 entry. I would attach that also but I can only attach one file at a time.

Ryan_M
Moderator

Tracking COGS in QB Online

Hi @jenason,

 

Thank you for your prompt reply, as well as sharing those PDF files for additional information. 

 

At this point, I suggest you contact our Technical Support team for further assistance. They have the tools to remotely access your computer with your permission. Then they can investigate the root cause of the issue, along with providing a solution for it. 

 

Here's how:

 

  1. Log in to your QuickBooks Online (QBO) company.
  2. Click the Help menu.
  3. Select Contact us.

I'll also share this article with you: What is FIFO and how is it used for inventory cost accounting? It has a detailed description of how COGS work in QBO, as well as the steps on how you can edit the cost and initial quantity of an item. 

 

If you have other questions, direct them to the comments below. I'll get back to you as soon as I can. 

Need to get in touch?

Contact us