Skip to main content
B
BrendaFTS
October 15, 2024
Question

Why does the cost amount line on the Active Estimates by Detail Line report return a zero even though costs have been entered in the item/product list.

  • October 15, 2024
  • 1 reply
  • 0 views
We need to see the cost per item as well as the sales price in our reporting and estimates.  The cost amount line is available to add as a column.  There is a cost associated with the item in the item list but it does not show on the report and we can't see on the estimate.

1 reply

Clark_B
Clark_B
October 15, 2024

Hello there, @BrendaFTS. Allow me to explain why the cost amount line reverts to zero, even though the cost has been entered in the item/product list.
 

To start, can you provide steps on how you generate the Active Estimates by Detail Line report? So I can further check this in my end since this specific report is unavailable in QBO. However, if you're referring to the Transaction List by Customer report, please know that the cost amount may show as zero on the transaction list report due to zero dollar balance sales not appearing on cash basis sales by customer reports in QuickBooks Online. This is by design to prevent confusion

 

For future reference, you can check these articles to help you get the most out of your financial reports and memorize it:

 

 

Please inform me of any developments, @BrendaFTS. If you have questions, feedback, or concerns about the cost amount line on the report, or if you're referring to something else, please don't hesitate to reach out to the Community. I'll assist you in any way possible.

B
BrendaFTSAuthor
October 15, 2024

I made a custom report with these parameters:

Accrual Basis

Date: Range This fiscal year

Transaction Type = Estimate

Estimate = Active, Converted

Product Service = not empty

Open Balance does not equal 0

 

Columns:

Transaction Num

Transaction Date

Transaction Line Items

Estimate Status

Transaction Line Items: Customer

Transaction Line Items: Product/Service

Transaction Line Items Qty

Transaction Line Items Sales Price

Transaction Line Items Net Amount Line

Transaction Line Items Cost Amount Line this is the field/column that is blank

Transaction Line Items Open Balance

 

All the other columns are pulling data correctly.

Thanks

Brenda

M
MirriamM
October 15, 2024

Hi, Brenda. Thanks for getting back to us and providing additional detailed information.

 

When generating a Transaction list report in QuickBooks Online (QBO), the system is designed not to display the item cost, which is why it appears as blank.

 

If you require a report that includes the item cost, you can generate the Inventory Valuation Summary report. This report will display your transactions for each inventory item and illustrate how they impact quantity on hand, value, and cost. 

 

To access the report, follow these steps:
 

  1. In the left menu, choose Reports.
  2. Go to the Sales and customer section, and select Inventory Valuation Summary. 
  3. Set the necessary filters. 
  4. Click Run report. 

Once the report is generated, you can view the item cost under the Calc. AVG column.

 

If you need further assistance in managing your account, leave me a comment below. It's always a pleasure to help you, Brenda.

Terms & ConditionsAccessibility statement