Question

average cost in P/L

Forum|Forum|4 years ago
May 19, 2022
11 replies
34 views

my P/L report shows me always the average cost. this one is sometimes, or many times, below the actual cost. how can I change it to user defined cost?

QuickBooks Desktop

R

Rasa-LilaM

QuickBooks Team

Hello there, hongkonghelmut.

I’d be glad to help change the arrangement of the information shown in your Profit and Loss report. However, I just need more information on what you’re experiencing to ensure the best solution.

What specific account did you select in the Filters tab? May I know if you run the Transaction Detail by Account for a specific category in the Profit and Loss report?

I also appreciate it if you can provide a screenshot of the report. This is to give a clearer view of what’s happening to the statement.

Thank you in advance. I look forward to hearing back from you hongkonghelmut.

H

hongkonghelmutAuthor

I just go to the standard report center and select profit/loss and voila, it is using the average cost

R

Rea_M

Level 10

Hello there, @hongkonghelmut.

I'm glad you're able to figure out the resolution of your reporting concern and for sharing it here in the Community. If there's anything else that you need or if you have any other questions feel free to post here anytime.

Thanks for being the best part of QuickBooks, and have a lovely day!

Rainflurry

Level 11

@hongkonghelmut

Average cost is calculated by taking the average of the actual cost you paid for your inventory. Are you saying that it is many times below the current cost? You can't change it to a user-defined cost. The IRS only allows specific methods for valuing your inventory (See IRS Publication 538).

W

WSEWS03

I am having the same issue as hongkonghelmut. I need QuickBooks to use the actual cost not the average cost. No matter what the IRS regulation is, I need to know exactly what I am making as far as the gross margin is concerned. In my case, I am using Enterprise 2023 for manufacturing. Are you saying there is no way to have QuickBooks use the actual cost for the reports? In my case, the average cost is well above or well below the actual cost and thus it is greatly overstating gross margin and also understaing gross margin in a major way.

Can this be changed? Any ideas would be great!

M

mphoebus

@WSEWS03

"I am using Enterprise 2023 for manufacturing. Are you saying there is no way to have QuickBooks use the actual cost for the reports? In my case, the average cost is well above or well below the actual cost and thus it is greatly overstating gross margin and also understaing gross margin in a major way."

QB Enterprise doesn't know the actual cost when you have more than one of a particular item in stock. If you have a quantity of 5 in stock and a customer buys one, QB doesn't know the cost of that one specific item being sold. All QB can use for cost is either: 1) the average of the 5 (if you use average cost), or 2) the cost of the first item manufactured/purchased/assembled (if you use FIFO). However, if you only ever have one of an item in stock, the COGS for that item will be its actual cost.

If you want QB to the have the ability to know the cost of the exact item going out the door when you have two or more of an item in stock, you can set up a separate inventory item for each item in stock, even if they are the same, and a unique identifier for each item being sold. QB Enterprise, although good, is more of a one-size-fits most/over-the-counter product. It isn't at the level of an ERP system which allows you to track inventory cost and COGS using the specific identification method, which I think is what you're asking for?

"If you want QB to the have the ability to know the cost of the exact item going out the door when you have two or more of an item in stock, you can set up a separate inventory item for each item in stock, even if they are the same, and a unique identifier for each item being sold. QB Enterprise, although good, is more of a one-size-fits most/over-the-counter product. It isn't at the level of an ERP system which allows you to track inventory cost and COGS using the specific identification method, which I think is what you're asking for? "

You must not be in manufacturing. I have thousands of the same item and creating a new item with a unique identifier is crazy. No one mentioned that if you do an inventory adjustment that too will change the average cost. There is no way in QB to report correctly on the true profitability on an item if you use average cost.

Sign up

Login with SSO

Let's get you signed in

Login with SSO