Use cash and bank management workspaces
The Bank management workspace shows information that is related to company bank accounts. This workspace includes a Summary view and an Analytics page. The Summary view shows summary tiles, bank account information, a balance chart, and related information. The Analytics page uses the capabilities of Microsoft Power BI to show visuals that are related to bank account balances.
Summary view
The tiles in the Summary section provide an overview of your bank accounts and provide quick access to the pages that you most often use. The bank reconciliation information is specific to the Advanced bank reconciliation functionality. Information is included only for those bank accounts that have the Advanced bank reconciliation option set to Yes on the Bank accounts page.
In the Summary section, you can import electronic bank files for bank accounts across all legal entities.
Bank accounts
Each bank account in the legal entity is represented by a card in the Bank accounts section. The current balance is shown, and you can drill down to the transactions that make up that summary balance amount.
The Bridged transactions amount also lets you drill down to the transactions that make up that summary amount. Bridged transactions are any pending transactions that have been posted by using bridging functionality, but that haven't yet been cleared. The Pending balance amount is the current balance minus the bridged or pending transactions.
The card also shows when the bank account was last reconciled. This information is shown only if Advanced bank reconciliation is enabled for the bank account.
Balance
The Balance chart shows either historic balance information for the bank account that is selected in the Bank accounts section or a summary of historic balance information for all bank accounts in the legal entity. This information is available for various periods: current week, current month, current year, the last five years, and all periods (the full history of the bank account).
If you're viewing the Balance chart for a single bank account, the historic balances are shown in the bank account currency. If you're viewing the chart for all bank accounts in the legal entity, the historic balances are shown in the accounting currency.
Information about when the data was last updated appears at the top of the chart. You can update the data as needed.
Related information
In the Related information section, you can open the General journal page to complete bank transfers. You can also quickly open the Bank transactions and Bridged transactions pages.
Analytics view
The Analytics page provides important metrics about the bank accounts in the current company. The following visualizations are available on the page:
- Total bank balance in system currency.
- Balance by legal entity.
- Today’s actual versus forecasted balance in bank account currency.
- Balance by bank account.
- Balance by currency.
You can view bank analytics across all companies in the Cash overview – all companies workspace.
Watch this video to explore the Bank management workspace