Adding a Cost column in a sales report is essential to generate accurate data, Aar0n. I'm here to share the cause of why it's missing.
Based on your screenshot, you're running the Sales by Customer Detail report, which is why the Cost column doesn't appear. It's specifically used to view customers' transactions. While cost only shows when using inventory items.
At this time, adding a Cost column to any sales report is unavailable. With this, you don't have to configure anything in QuickBooks Desktop. Instead, I recommend running the correct report (Inventory Valuation Detail) to add the column.
Here's how:
- From Reports, select Inventory.
- Choose Inventory Valuation Detail report.
- Click Customize and type in the cost in the Columns section.
- Select Display and add the Invoice under the Transaction type.
- Personalize the other filters to customize your report.
- Once done, hit OK.
Aside from that, the program uses Sources and Targets to apply accounting principles and processes, like recording transactions and displaying reports. You can browse this article to learn more about how QuickBooks generates your data when running reports: Understand reports.
Additionally, you can memorize your reports in QuickBooks to ensure you can save the current customized settings to avoid personalizing them again. Or export your reports to Excel to generate the data needed.
I'm more than happy to help you again if you have more questions about running and personalizing reports. I'm with you every step of the way.
