How to add the cost of sold products to a custom report?
If you want both the income and cost of goods, you will need to add filters to exclude all other accounts besides Inventory - sales and Inventory - cost. Where filters function as Boolean AND operators. And you will then get the two posted amounts as separate entries. Remember, custom reports only report postings to the general ledger. They are not sweeping summaries of information related to a topic.
Your fourth selection criterion is also incomplete.
1 Like
Yes, but I want them as separate columns, even if I excluded all other accounts it doesn’t seem possible.
True, I was trying to add something like item cost but now I understand how it works thanks for explaining.
If sales quantity can be added to this report it would be awesome.
For, now I will create two custom reports and combine them in Excel