Miami, Florida, United States - 701 Brickell Ave. Miami, FL 33131
+1 (800) 501-3631

How to set up Advanced Bank Reconciliation Process

The advanced bank reconciliation process in Microsoft Dynamics 365 Finance and Operations is an easy feature that allows us to import electronic banks statements and make an automatic reconciliation with bank transactions.

To access this feature, we need to setup a service, an advanced integration framework inbound port, and link it to a bank format resource.  Dynamics 365 Finance and Operations comes with three standard formats: MT940 from SWIFT, the Society for Worldwide Interbank Financial Transactions (BAI2), and ISO20022 (or SEPA, the Single Euro Payments Area).

In this article I am going to explain how you can setup an advanced bank reconciliation in Microsoft Dynamics 365 Finance and Operations using the BAI2 format. From my experience, the BAI2 format is widely used in the US and it is globally supported by most of the major global banks.

1.    Setup

To start the matching process, it is necessary to setup some basic parameters first:

  • Setup Transaction types

Follow this path: Cash and bank management > Setup > Bank transaction types:

advanced bank reconciliation 2

Select the main account for the type. Then we can create the Bank transaction type.

  • advanced bank reconciliation 3
  • Transaction codes

Click on Cash and bank management > Setup > Bank reconciliation > Transaction code mapping.

advanced bank reconciliation 4

Now, the statement transaction code that we received is mapping accordingly to the bank transaction type we setup on Dynamics 365 Finance and Operations.

advanced bank reconciliation 5

  • Reconciliation matching rules

Matching rules are a set of criteria used to filter bank statement lines and bank document lines during the reconciliation process. We can setup more than one matching rule and create a reconciliation matching rule set that we can then tie to our bank account.

To set them up, click on Cash and bank management > Setup > Advanced Bank reconciliation setup > Reconciliation matching rules

advanced bank reconciliation 6

advanced bank reconciliation 7

  • Method of payment

Now, configure the method of payment that is going to be used in the transaction.

The path is Accounts payable > Setup > Payment > Methods of payment.

advanced bank reconciliation 8

There we will be able to assign a bank transaction type to each kind of payment method.

advanced bank reconciliation 9

  • Import statement

After that we can import the file. To import a BAI File, go to Cash and bank management > Bank statement reconciliation > Bank account

advanced bank reconciliation 10

From the top menu we click on Reconcile > Bank statements > Import statement, and select the parameters.

advanced bank reconciliation 11

Once in the system, we need to validate it, post it, create a new reconciliation journal and match all the lines within.

1.    Advanced Bank Reconciliation process

After this configuration, we can start the reconciliation process.

  • Trial Balance

First, run a trial balance at the day we want to reconcile the bank statement, just for comparative purposes to check the balance showing as the closing balance in the bank. Run it in General ledger > Inquiries and reports > Trial balance.

advanced bank reconciliation 13

 

advanced bank reconciliation 16

Now, to reconcile the bank statement, go to Cash and bank management > Bank accounts > Bank accounts and select the bank we want to reconcile with.

advanced bank reconciliation 18

advanced bank reconciliation 19

  • Bank statement

Then, we click on Bank statements, and select the one we just imported. It should appear as open in the status field.

advanced bank reconciliation 20

Next, we click on the bank statement. There we can see the lines of transactions and edit or delete them.

After that validate and post the bank statement. The status is going to change from Open to Validated.

  • Match

Next, create a new journal entry.  go to the Bank accounts sheet and click on Reconcile > Bank reconciliation > New, and that’s going to pull it in with a draft status.

The next step is the matching part. Since we are not making a manual reconciliation process, we do not have to select all the transactions to manually match them. In this order, we are going to use our matching rules.  Click on Worksheet > Run matching rules and select the parameters.

advanced bank reconciliation 23

The reconciled transactions will now appear at the bottom part under the Matched transactions description.

advanced bank reconciliation 24

Finally, click on Mark as reconciled to declare the entire journal as a reconciled journal.

advanced bank reconciliation 25

I hope this article was useful in setting up the advanced bank reconciliation process within Microsoft Dynamics 365 Finance and Operations. If you require specialized advice for bank reconciliation or more details about all Microsoft Dynamics 365 solutions, please contact us.

Andrea Gomez

Microsoft Dynamics 365 Finance and Operations Junior Consultant at Pangea Group
Andrea is an industrial engineer. She has one year of experience working as Microsoft Dynamics 365 Finance and Operations Junior consultant, focused on implementation of the ERP systems and processes consultancy.
Andrea Gomez

Latest posts by Andrea Gomez (see all)

Related Posts

Contact Us