Cause of bank inconsistency: combination of automatic and manually submitted transactions (ABN AMRO)

Disclaimer

All screenshots in the article were taken in the Dutch version of Yuki.

Example of bank inconsistency

Most customers assume that when the accounting link with ABN AMRO is activated, the automatic sending of bank files takes place from then on. However, ABN AMRO takes some time before the first bank file is automatically submitted in Yuki. 

The submisson of the transactions is not retroactive so the missing transaction lines have to be submitted by the customer themselves.

For an ABN AMRO account, if you see different statement numbers in terms of format at the location of the bank inconsistency in the first column, it was created by a combination of bank files automatically delivered by the ABN AMRO and bank files downloaded by the client themselves.

Search for bank inconsistency

Go through the following steps:

• Click on the line behind statement number 24401. On the right side of the screen you will see the name of the statement: MT940110902165107.STA
• Click on the line behind statement number 13. On the right side of the screen you will see the name of the statement: 'Bank mutations_YUKIMC1.asc.

'Bank mutations_YUKIMC1.asc' is a statement provided automatically by the bank. These statements are like MT940 files but differ in layout from an MT940 file. The descriptions are also different and since Yuki tracks duplicate transactions by the description, we encounter duplicate transaction lines at the transition from one type to another. At such a transition, more transaction lines are marked as duplicate than when importing statements of the same type.

Action to be taken

Open the statement lines and search from 01-09-2011 to 5-09-2011 for duplicate transaction lines and mark the lines not yet matched as duplicate.

ATTENTION!

Click on the red triangle with the exclamation mark at the top left of the screen to have the bank inconsistency recalculated. 

The bank inconsistency is now resolved!