Upon further investigation I realized that my initial post contained incorrect information. I apologize. It seems like reports are sometimes working as expected and sometimes excluding expenses, and I'm not sure why.
The screenshot attached shows a report that is not working as expected. The project has two transactions. The first one in a single line item. The second transaction is split between multiple line items, all with the same project. The two transactions sum to 332,000. In this case, the correct P-L should also be -332,000, because all the line items in both expenses are related to the same project. However, the Profit Profitability Report is blank. ("This report contains no data.")
I have another project where the report is working correctly, despite the fact that transactions are split between projects. The project has 5 transactions. The first four are single line transactions, but the last one includes multiple line items for unrelated projects. In this case the transactions sum to 376,000 but the report correctly excludes the unrelated line items in the last transaction to give the correct P-L (-256,000). When I export the report, it looks correct / as expected. (I would add a second screenshot but for the upload limit)
Why is one project working as expected while the other report is blank?
