Cash Management
Improve bank transaction matching with more precise rules
Over time, banks have made additional bank data available from the banking cloud. You can now use even more fields from incoming bank transactions to tailor your matching and creation rules, or assignment rules. Use the wider range of fields to increase matching accuracy during reconciliations, and when automatically assigning customers to bank transactions.
In addition, when viewing bank transactions or creating new views, select from the expanded range of fields to customize how you view bank transaction lists.
Details
The following new fields are now available for you to select when the selected data source is Bank transactions. These fields are available when you’re creating matching and creation rules or assignment rules. They’re also available when viewing bank transaction and creating new views.
- Payee ID
- Payee
- Payee address
- Payee city
- Payee state
- Payee postal code
- Payee account
- Category
- Subcategory
- Category ID
- Short description 1
- Short description 2
- Extended description
- Bank reference number
The new fields are available in addition to the existing fields if the bank has included them in their bank feeds.
How it works
Reconciliation rules
-
Go to either matching and creation rules or assignment rules.
-
For matching and creation rules, go to Cash Management > Setup > Reconciliation rules > Matching and creation rules.
-
For assignment rules, go to Cash Management > Setup > Assignment rules.
-
- To add a new rule, select Create, or to edit an existing rule, find the rule in the list and select More actions > Edit at the end of the row.
-
When the selected data source is Bank transactions, the new fields are available.
- Adjust the filters as required.
Bank transaction views
- Go to Cash Management > All > Transactions > Bank transactions.
-
From Manage views, select Create new view.
-
In Step 1 of the wizard, select the fields you want to use as column headings in your new view.
This example shows all fields selected. Adjust the selection as required.
-
Complete the remaining steps of the wizard and select Save.
-
In the All menu select your newly created view.
The selected fields are used as column headings on the Bank transactions page. You can use them to filter the information in the Advanced filters dialog.
Permissions and other requirements
| Subscription |
Cash Management Sage Cloud Services |
|---|---|
| Regional availability |
All regions |
| User type |
Business |
| Permissions |
Cash Management
|
