How do I get rid of a bank inconsistency? (Beta)

Disclaimer

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

In the bank account overview, the Consistency check column indicates with an icon whether there is a bank inconsistency in the transactions of a bank account.

TIP!

Before you start looking for the cause of a bank inconsistency, Yuki always has the inconsistency redefined first. To do this, click on the red triangle with the exclamation mark in the top left corner of the screen.

Types of bank inconsistencies

Yuki knows two inconsistencies at the bank:

Yuki cannot check the balance because the bank does not include balance information in the bank files you provided. Check your balance regularly using the paper statements you still receive from the bank. Contact Yuki if there are missing transactions.

Yuki has found that transactions are missing. The balance likely differs from the actual balance.

Check if you are missing transactions from certain days and re-export them from your bank's website.

View bank inconsistency

Hover your mouse over the Bank icon in the navigation bar and click on Bank accounts. In the now-opened screen, click on the name of the relevant bank account and open the Statements view.

If all the statement lines are white, there is no bank inconsistency present. This is in contrast to the example shown below.

The columns Check opening balance from Yuki and Check closing balance from Yuki are only visible to a user with a 'Back pffice' role in the domain.

Color usage

If the opening and/or closing balance of the statement differs from the balances on the GL account number on the same day, the statement lines will be colored red:

• White: the opening and closing balances calculated by Yuki are equal to the balance provided by the bank.
• Red: The opening balance calculated by Yuki does not match the closing balance of the line below, or the closing balance calculated by Yuki does not match the opening balance of the line above.

Even though all the transaction lines in the overview are red, there is no bank inconsistency as long as the bank's closing balance matches Yuki's control closing balance. The problem usually lies where the final balances differ.

TIPS!

To detect possible duplicate transactions, you can follow these steps:

• Calculate the difference between Yuki's latest check closing balance and the bank's latest closing balance.
• Search for this amount using the search bar.
• Hover your mouse over the Bank icon in the navigation bar, then click on Electronic statements. In the now-opened screen,  click on the Duplicate lines button. See if you can find the amount there.

Possible causes of bank inconsistencies

• Unsubmitted statements
• Duplicate transaction lines on statement
• Inconsistency that isn't an inconsistency
• Missing transaction lines (on the same day)
• Transaction lines incorrectly marked as duplicates
• Import skips transaction line
• Combination of transactions provided in CSV and MT940 format
• Combination of automatically and manually provided transactions (ABN AMRO).