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!

Morgan_B

QuickBooks Team

Thanks for joining this thread, WSEWS03.

I'm here to provide some additional info regarding the average cost in your QuickBooks Desktop reports.

The system does use the weighted average cost to determine the value of your inventory and the amount debited to COGS when you sell inventory. You may want to run the Inventory Valuation Summary Report to determine how the average was calculated. This can be done by:

1. Selecting Reports, then Inventory.
2. Choose Inventory Valuation Summary, then set the dates to All.
3. Double-click the item(s) in question.

The following article provides additional info about understanding inventory assets and cost of goods sold tracking in your QuickBooks Desktop account.

I also recommend submitting feedback to the Product Development Team to let them know you'd like to be able to view the actual costs in your reports. You can share your suggestion by clicking the Help tab and select Send Feedback Online.

Please know assistance is only a comment or post away if you have any other questions. I'll be here to help in any way that I can.

Sign up

Login with SSO

Let's get you signed in

Login with SSO