I'm not sure I'm using the correct terminology but I have a number of "assets" which are sub-accounts of a checking account: Checking account - Designated funds 1 - Designated funds 2 ...
What I would like to do is create a report that has the "income" and "expenses" of each account (per account similar to the Account Balances report), something like
1/1/2018 to 12/31/2018
Account Income Expense Balance
Designated funds 1 100 50 150
Designated funds 2 21 5 16
In this example, Designated funds already had a balance of 100 before the start of the year. Ideally the ending balance would be there but I can get that from the Account Balances report. And of course each of these categories could have a starting balance.
The key part is the income/expense per account. The only way I know how to do that currently is through the cash flow and with that I have to run the report and look at the totals for each individual account...not ideal.
Is there a built-in way to do what I want to? Am I thinking about this wrong or have my account structure wrong?