Overview
Unmatched bank transactions are coded to 60400 (Bank) and 91000 (Bank Data Clearing Account).
The instructions below outline three options to view/download a list of these unmatched transactions.
Instructions
General Ledger Report
Changing the settings when generating the General Ledger report allows you to filter the report and only show specific accounts. This setting can be used to create a report that only shows transactions coded to 91000/Bank Data Clearing Account.
| Navigate to Reports. | |
| From Quick Access Reports, Select Add To Pack for General Ledger. | |
| From the Report Pack List select Settings | |
|
Next to Select Account(s), search for the account 91000/Bank Data Clearing Account. Select the account, then click Save |
|
| Select the PDF, Excel, Word or XML icon to generate the report. |
Account View
The Account View screen allows you to filter transactions by specific accounts.
This can be used to preview all transactions posted to 91000/Bank Data Clearing Account.
- Select the Fund that contains the unmatched transactions.
- If a fund is not selected, you will be redirected to the Analytical Insights screen instead.
- Select the Account View icon in the top toolbar:
- Input 91000 under CODE to search for the Bank Data Clearing Account:
- A list of all filtered transactions can be downloaded by selecting Download Excel:
Smart Reports
The General Ledger can also be accessed via the Smart Reports screen. Here you can generate a list of transactions from within the software without creating and downloading report files.
| Hover over Reports, then select Smart Reports. | |
| Select General Ledger |
- Select Filters, then search for 91000/Bank Data Clearing Account:
- The General Ledger displayed will filter by appropriate transactions.
Select Generate Report to download a list of these transactions if desired: