Curious what Dynamic People can do for you?

+ 31 (0) 20 303 24 70
Logo
Tech Blogs 08 June 2020 Ana Marques

How to save time with Advanced Bank Reconciliation in Dynamics 365 Finance

Blog picture

I love the Advanced Bank Reconciliation feature in Microsoft Dynamics 365 Finance and do you know why? With out of the box functionality we can quickly import bank statements, automatically match the banking transactions, post bank fees and be done with it in just a couple of minutes.

What does this mean?

This means that by simplifying and automatizing these processes you will find that this solution will clear almost all of your banking transactions, leaving just a small amount for user intervention.

Example:

Step 1: You import your bank statement

Go to: Bank Management Workspace  > Import Bank Statements . Make sure you have Reconcile After Import set to Yes.

Import your bank statement

Step 2: Wait a couple of seconds and voilá:

a) the Bank Statement is automatically created and validated (if there were any errors we would see it in the notification bar)

Screenshot Bank Statement

b) The Bank Reconciliation is automatically created

Screenshot Bank Reconciliation

c) The Matching Rules set have run automatically so no need to manually reconcile these transactions

Screenshot Matching Rules

 

Next steps would be:

1) Check if there are any transactions that still needs manual reconciliation

2) Post the bank fees via the Bank Statement form

3) Click in Mark as Reconcile and you are done!

 

What about the setup, is it complex?

Even though we can add more complexity to the setup, I would like to show you in this document that with very simple setup you can have this functionally up and running while keeping all the benefits.

 

Configuring Bank Statement Formats

The setup for bank statement import varies, depending on the format of your electronic bank statement. Dynamics 365 supports three bank statement formats out of the box: ISO20022, MT940, and BAI2. More often than not, we use MT940 and BAI2.

Screenshot Bank Statement Formats

Configuring Cash & Bank Parameters

In Cash & Bank Parameters you will find some basic settings. Personally, I like to activate Show Statement Line in Debit/Credit. This setting will allow the bank statement transactions to be shown in two separate Debit and Credit columns. If not selected, the amounts will be shown in the same column with the appropriate sign.

Nevertheless, all these settings are optional.

Screenshot Bank Parameters

Reconciliation Matching Rules

Now we have reached my favorite part of the setup, where the magic happens!

A reconciliation matching rule is a set of criteria that is used to filter bank statement lines and bank transaction lines during the reconciliation process.

In this case we have set up two simple matching rules:

1. Bank Fees – By running this rule Dynamics 365 will identify all transactions in the Bank Statement with Bank Transaction Code equal to N788 and “mark them as new”. This means that these transactions are new to the system so we can now directly post these transactions to a cost ledger account.

Screenshot Bank Fees

2. Match Documents – Based on criteria such as amount, document number and payment reference, Dynamics 365 will automatically find and match bank statement transactions.

Screenshot Match Documents

We can have as many matching rules as we like. The more complex they are, the greater the advantages.

We can also combine these rules into a Reconciliation Matching Rule Set, which allows us to use them in combination:

Screenshot Reconciliation Matching Rule Set

Configuring Bank Accounts

Finally the piece that glues the setup together: the Reconciliation tab on the Bank Accounts.

Important setup to do:

1. Advanced Bank Reconciliation: Yes

2. Statement Format: Choose the appropriate format for your bank

3. Reconcile After Import: because of this setting the system will automatically:

    • Validate the bank statement,
    • Create a new bank reconciliation and worksheet, and
    • Run the Default matching rule set

​​​​​​4. Default Matching Rule Set: pick the matching rule set that you would like to use by default.​​​​​​​

 

Screenshot SetUp

Useful Links:

https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-bank-reconciliation-matching-rules

https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/reconcile-bank-statements-advanced-bank-reconciliation

 

What’s next?

If you are interested in knowing more about the advantages that this feature will bring to your company, please get in touch! I will be happy to help. Contact me via: ana.marques@dynamicpeople.com or call 020-3032470.