Introduction

The DXC Finance Utilities module provides enhanced functionalities to Microsoft Dynamics 365 for the following:

Bank statement import and reconciliation

The Cash and Bank Management department can build bank statement format matching with the bank account statement files generated by Bank(s). The finance utilities provide a simplified platform to define the bank statement format definition for various file types. DXC Finance Utilities supports the following formats:

• Flat file
• NAI
• BAI2
• Custom
• BRS
• GHS

The Custom format provides some flexibility on configuring additional formats.

The Bank account statements can then be imported into Dynamics 365 based on the statement format definitions.

Matching rules can be executed either during or after the import, to automatically match the bank statement transactions to Dynamics 365 bank transactions. Also, bank transactions can be automatically created, posted and reconciled based on configured matching rules.

Finance utilities minimises the manual actions required for reconciling bank account statement(s) with bank transactions processed in Dynamics 365FO.

Setup

• Financial utilities parameters
• Bank statement format
• Populate accounts payable document number
• Bank reconciliation matching rules
• Customer payment and settle of one invoice via bank reconciliation
• Modern bank reconciliation

Processing

• Bank statement import
• Bank reconciliation worksheet
• Reports
• Modern bank reconciliation

Setup for automatic import of bank statement

• Encryption/decryption - where the import file should be decrypted
• Financial utilities connections
• Bank accounts
• Periodic task Import bank statements via financial utilities connection