I am asking about the BS, but I’m also referring to the summary screen. One of the things I’d like to achieve is a “grouping” of Assets accounts under the main asset banner on the summary so that I can have it appear somewhat similar to the above and have something like what’s illustrated below
I have managed to get my P&L statement to the same format that my accountant uses by manipulating the COA, creating groups and subgroups and re-ordering the hierarchy, and I am quite happy with the results.
I’m wondering if it’s at all possible to do the same thing with the balance sheet?
I realise it has nothing to do with the COA but I can find no way to manipulate the Balance Sheet report to get anything like what she puts together from my paperwork.
The only formats available to us are:
- Assets - Liability = Equity
- Assets = Liabilities + Equity
- Assets = Equity + Liability
I’m not suggesting manager is wrong at all, I realise it’s probably quite arbitrary, but I’d like to replicate the balance sheet they submit, which is in this format:
I’m not concerned about
Equity = Assets - Liabilities vs Assets - Liabilities = Equity
but what I do like is the “grouping” of asset types, notably the “Cash at Bank” which is a combination of bank and cash accounts and the non-current assets and investments.
I’m hoping not to spark any debate on the subject (whether it be about how one accountant should or shouldn’t produce the output, or what the development team do or don’t do), but rather:
is it possible to generate any sort of organised output like the above whether it be through some existing mechanism of manager that I don’t know about? eg, is this what control accounts do, or capital sub-accounts? or some other tool.
If it is completely up to generating a custom report, has anyone done anything like this?