What is the problem you need to solve?
We have a number of different companies (c. 20) and I’d like to create a consolidated “Account Transactions” table so I can search for entries or contacts across multiple companies (i.e. filter by contact to find a list of all the payments to a plumber that’s worked on properties across multiple companies).
I’ve managed to create a basic / clunky version of the sheet I’m looking for using “Account Transactions” it’s ruined by all the noise created when there are reversed journals creating multiple entries for single invoices. Is there a custom solution for this?
What accounting software are you using?