Cause of bank inconsistency: missing transaction lines (same day)

Basic rules

• Before you start to look for an inconsistency, first let Yuki always detect and calculate the inconsistency again. To do this, click on the red triangle with the exclamation mark.
• Always calculate the difference between the final balance check and the final balance of the bank. Use the search bar to look for this amount. This is an excellent tool to quickly track duplicate transactions. 
• Even if all the lines in the overview are coloured red, there is no inconsistency as long as the final balance of the bank is equal to the final balance check. Most of the time there where the final balances defer from each other lies the problem.
  
  

Action to be taken

Final balance check with final balance of the bank (missing transactions): difference between both final balances 9621,23 - 9519,76 = 101,47 euros.

Open statement 10601 related to the red line:

60F:D100415EUR9272,67

61:1004160416D30,N192NONREF.

The :60F: line shows the opening balance: 15-04-2010 9272,67 euros.

Open statement 10501 related to the grey line

:61:1004150415D613,33N422NONREF

:86:< vervangen tekst >

:62F:D100415EUR9171,2

The :62F: line shows 91471.20 euros as final balance on 15-04-2010.

The opening balance in statement 10601 should be equal to the final balance in statement 10501 on 15-04-2010. 

The last acion that you have to perform is to check the timestamp of the red coloured statement line 10501 that has been submitted last. Click the statement line starting with 10501. In the screen now opened the transaction lines of the statement are shown. Under the document properties you wil find that the file has been submitted on 15-04-2010 15:36.

The filename also shows the date that the file was generated by the bank: MT940 15-04-2010 15:35:24.