Advanced bank reconciliation MT940

(0) Share

Report

Posted on by Kyra Philipsen

Hi all,

I'm currently having trouble with the setup of the reconciliation part of MT940.

The setup for importing an MT940 file is done and importing a file is not a problem, but I can't reconcile the imported MT940 file.

Here is the setup I've already done for the reconciliation part:

- I created a bank transaction type

- Created a bank transaction code mapping

- Created a reconciliation rule

- Created a method of payement

- setup all the number sequences in the cash and bank parameters

When I run the matchin rules or the matching rule set, I get this error message:

"0 statement lines have been matched according to matching rule MWBD"

What is going wrong here?

Thank you.

Categories:

Other

All responses (9)

Answers (0)

Kyra Philipsen 10 on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

If I send you the information in tag 61 from the MT940 file, would it be possible to tell what needs te be filled in in the matching rule,...?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hello Kyra,

Please have a look at the following MS docs sites that describe the matching rules in more details

docs.microsoft.com/.../set-up-bank-reconciliation-matching-rules

Setting up those matching rules is not easy and if this is not correctly done, no matching will be found.

Best regards,

Ludwig
Suggested answer

SouravDam 11,723 on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi Kyra,

What is this bank transaction type value '00100' stands for in matching rule?

In your imported statement no such value is showing!

Best regards,
Sourav Dam
Kyra Philipsen 10 on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi Ludwig,

I've adjusted the Matching Rule, but I still get the same message.

Thank You

Kyra
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi Kyra,

Your allowed date difference is 0 days but the payments are posted 17 June while the bank statement is from 1st June...

Best regards,

Ludwig
Kyra Philipsen 10 on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi,

Thank you, now I get a list of payments:

But when I run the matching rule it keeps saying that there are no statement lines matched.

Is there something wrong with my matching rule or...?

Thank you,

Kyra
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi,

Many thanks for your screenprints.

If I look at your last one, then I can see that the section on the right-hand side is empty.

That must be because there is no payment against the bank posted.

Can you test posting a customer or vendor payment against this bank account and open the form again?

You should then see a line to reconcile.

Best regards,

Ludwig
Kyra Philipsen 10 on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Here are my screenprints

- Bank transaction type

- Bank transaction code mapping

- Reconciliation Rule

- Method of payment

-Number sequences

- The error message I receive

"Have you recorded customer and vendor payments in a customer/vendor payment journal against the bank account for which you imported your statement?"

is the necessary when I want to do the reconciliation with matching rules as automated as possible?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Advanced bank reconciliation MT940

Hi,

Unfortunately, we cannot see your screenprints.

Please save them as pictures and upload them via the 'use rich formatting' form.

About the advanced bank reconciliation function:

Have you recorded customer and vendor payments in a customer/vendor payment journal against the bank account for which you imported your statement?

About the setup:

Please have a look at the following sites that contain some sample file for testing purposes.

docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

Best regards,

Ludwig