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.
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.