Overview
The Bank Balance Report displays global information on accounts, their balances and any borrowing limits that have been set up. This guide informs the user how to set up an overdraft and how to report on and filter client accounts.
Setting up an overdraft
Access the Administration and Compliance module and select the Client tab. Select the client on the right hand drop down box and then the menu option Client Details – Edit.
Click on the Registers/Lists tab and select Bankers from the menu, and click the Edit button next to this to edit the register.
Either an existing bank can be selected or a new one can be added using the Add New Entry button.
Details can be edited on the right hand side to set up an overdraft. Enter the amount into the ‘Borrowing Limit’ field and use the ‘Nominal A/C’ field to select which account it will affect.
Click the Close button to save any changes.
Reporting on accounts with overdrafts
To access the Bank Balance Report, go to the Wealth Management module and select the Global tab. Choose the menu option Reports and select 'Bank Balance Report' from the menu and click OK.
NB This can also be accessed via the Client tab if the report is only needed on one client.
A window will open displaying the report options:
Global reports, the information can be narrowed by selecting one of more Security Groups.
The ‘Advanced’ button allows the user to report on any combination of clients without being limited to already established groupings.
The three tick boxes can be used to further focus the report:
- Suppress zero balances – when ticked will not show accounts with a balance of zero or with no data entered.
- Suppress positive balances – when ticked will show only accounts with either a zero or negative balance.
- Borrowing limit set - when ticked will display only accounts with a borrowing limit.
For example, with all the boxes ticked, the report will display only accounts with both a negative value and a borrowing limit.
Click ‘Preview’ to generate the report.