Bank statement D365

(0) Share

Report

Posted on by Hermann Schonfeldt

We import bank statements (ISO 20022 Camt.053) daily for a number of bank account. The bank statements are validated and we run the advanced reconciliation process. However, the bank statement status does not change from Validated to Reconciled if the statement does not have any transactions. Is there any way we can change the status to reconciled?

All responses (4)

Answers (0)

Tina Gao 42 on at

Like (0)

Report

RE: Bank statement D365

Hi Hermann，

How can you mark this statment as reconciled? I have this issue now. An error pops when doing this kind of statement reconciliation: Bank reconciliation should have at least one matching entry.
Jeremy Driscoll on at

Like (0)

Report

RE: Bank statement D365

Hi Hermann,

I think I can help answer these questions.

Reconciliation is done on a line level. The lines in the statement are reconciled with bank transactions. As there are no lines in the statement, the statement itself will never show as reconciled, but will always be Validated. When you are marking as reconciled in the Bank Reconciliation screen, you are marking the bank reconciliation as reconciled, not necessarily the statement as that is done on a line by line basis.

The Draft status is slightly misleading here. That status refers to the workflow status. If you do not submit bank reconiliations to a workflow, that column will always be in Draft status.

I hope that helps.

Jeremy Driscoll
Hermann Schonfeldt 10 on at

Like (2)

Report

RE: Bank statement D365

Hi Ludwig

Bank statements are imported on daily basis. We receive one single file for all bank accounts (five) from the bank. Often, the bank statement for an account only contains the opening and closing balances, with no transaktions for that particular date. (The EUR-account opening and closing balances are always zero, regardless of the number of transacations).

Though the empty statements are marked as reconciled, Bank statement status remains "Validated".

Another question is why the Bank reconciliation status always is "Draft".

Best regards,
Hermann
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bank statement D365

Hello Hermann,

Can you explain what you mean exactly when you say that the bank statement does not have any transactions?

Does this mean that you imported a 'blank' bank statement or do I misunderstand something?

Would be great if you could elaborate and possibly provide some supporting screenprints.

Many thanks and best regards,

Ludwig