Finance Utilities
Bank statement reconciliation processing - Bank reconciliation worksheet
Bank statement reconciliation processing - Bank reconciliation worksheet
The following is a summary of the prerequisites for using Finance utilities extensions to Modern bank reconciliation
** Important note: Ensure there are no Action Mark new transactions Reconciliation matching rules left before running Cash and bank management > Setup > Advanced bank reconciliation setup > Advanced bank reconciliation data upgrade, as this will delete these rules.
The following setup are prerequisites and is described in detail here when switching to Modern bank reconciliation:
Note: The following section describes the Bank reconciliation worksheet process specific to feature Modern bank reconciliation.
The Worksheet page on the Bank reconciliation is used to match the bank transactions within your D365 environment and the bank statement files according to the reconciliation matching rules that you have defined in the D365 environment. It also provides the ability to manually match the bank statement transactions not matched by your reconciliation matching rules.
With Modern bank reconciliation the FastTab New transactions is no longer applicable, and thus not available on the worksheet.
Posting Bank statements are also not available anymore.
Select Workheet on the Action Pane, by navigating to Cash and bank management > Bank statement reconciliation > Bank reconciliation
The Modern bank reconciliation version of Bank reconciliation worksheet page is split into:
Finance Utilities adds the following functionality to below in Unmatched transactions:
After selecting Payment type (Customer payment, or Vendor payment), additional input fields are provided.
Finance Utilities adds:
Finance Utilities adds:
Ability to manually enter a Correction amount on the Bank transaction where the manual matching Bank statement record amount is different.
The Correction amount will be posted to the Main account associated with the correction line’s Bank transaction type as found on Cash and bank management > Setup > Bank transaction types.
Applies to where the following Finance utilities parameter settings are Yes:
Applies to the following Document types:
Matched transactions displays all the matched bank statement transactions and their matching Bank transactions.
Finance Utilities adds the following functionality to below in Matched transactions:
Note: Modern bank reconciliation includes new field Matching ID, which replaces Finance Utilities Match Id.