One thing I’d like to be able to do from time to time, is create a GL report with the balances of a sub-set of GL accounts.
The three seeded custom GL reports are good but they are all or nothing. Sometimes I’d like to get those for a specific sub-set of GL accounts.
Custom reports are fantastic too but here again I can get to the gl_transaction level but the group by isn’t quite a SQL group by that sums by the group by column so you can’t really get to an ‘account balance’ in custom reports, nor is there an ‘OR’ in the select criteria to allow a group of accounts to be selected.
Here is an example of the type of report where I’d like to be able to pick specific accounts - e.g. “Available funds for an LLC”
Cash at bank
less: accounts payable
less: accrued liabilities
less: engine reserve
= “Available Funds”