I have an income account with group 400 and item 410 likewise and expense code of 1400 and items of 1410-1419
Is it possible to get a report showing all income and all expense for only these accounts.
if I select account code = 141 I can report expenses in the range but not the income. It also selects other expenses such as 2141
Is it possible to achieve such a report another way?
Why don’t you export the General Ledger Transactions report to a spreadsheet and just delete the entries for accounts you don’t want? That would be very quick.
If your group 400 & 1400 are actual Chart of Accounts “Group Heading” accounts then under Reports for Balance Sheet & Profit and Loss you can use the feature
Then clicking inside the panel will display a list, which 400 and 1400 will be displayed.
@Gally, the utility of collapsing groups depends on what you meant by this:
Collased groups on financial statements show only the net of account balances for the group, as though they made up a single account. See the Guide:https://www.manager.io/guides/23790.
However, if you are trying to produce a list of transactions posted to the accounts you mentioned, that technique will not work.
The best approach for me is the workaround. I can have a separateor change a report for each accouning group I want to see and copy the report to a spreadsheet for getting a net income figure. Ieally what I would like is a report where you can specify an income and expense accounting group that lists the line items calculationg a total, which the workaround does. Then to calculate a net figure income/expense figure for the groups selected.
I can achieve this by copying the workaround report to a spreadsheet and just add the net calculation.