I am using the Smart Profit and Loss report to consolidate 3 companies. All data is extracting correctly, except for items in Type “EXPENSE” in one of the companies. This is causing the modified Group value to switch the sign and also displays the wrong Net Profit in the Profit and Loss report, but because it is not consistent across all companies, I cannot change this to reconcile back to the Net Profit per the system.
In the screenshots, you can see for example, Direct Costs are extracting correctly as a net debit for the Feb 21 period, but Bank Fees are extracting as a net credit in one company. However, Bank fees in another company are extracting correctly as a net debit, and in the same way as Direct costs.
Please help me resolve this so I can start using the tool and look at purchasing it.