The Bank Balance Less Dedicated report helps provide you with a clear picture of the "undedicated" money within asset accounts. Since dedicated accounts are considered a reserved portion of your assets, set aside for a specific purpose, it's helpful to know what portion of your assets are not included in this reserved money. The Bank Balance Less Dedicated report does this by showing you the beginning balance on each of your asset and dedicated accounts, provides you with the net activity through the chosen time period, and then, shows you the balance at the end of your selected time period for each of these accounts. The dedicated balances are then subtracted from your asset balances, and the report shows you what's left over in these accounts.
- To access the Bank Balance Less Dedicated report, click on "Other Reports" and choose "Bank balance less dedicated".
- Select the finance year you want to run the report for in the "Finance year" field, and the month you want to run this report through in the "As of" field.
- Select which books/funds you want to include on your report in the "Book/Fund" field
- The "Options" section contains several checkboxes which modify your report in different ways. Each option is detailed below:
- Show monthly totals - This option will show, for each account, the monthly activity for that account in the "Activity as of "X"" field, where is X the month you selected in the "As of" field
- Include inactive accounts - This option will make it so the report shows inactive accounts alongside your active accounts on the report.
- Exclude accounts with a zero balance - This option will hide any accounts on your report that are carrying a 0 dollar balance.
- Page brake when Type changes - This option will create a page break between assets and dedicated accounts on the report,
- Sort accounts by name - This option will sort your accounts alphabetically by name within their account type, instead of by account number.
- Click "Print" to generate your report.