I can't add bank transactions: what to check

• If the balance does not match, the transactions will not be allowed to be brought in.
• You can bring in earlier transactions, later transactions or both, as long as the balance matches that of the transactions already imported.

• Banks: the balance column is mandatory. Balances must match with no gaps.
• Cash accounts and cards: the balance column is not mandatory, as Ubyquo calculates it automatically.

Transactions with the same date as the last transaction already imported are not allowed.

For example, if the last transaction recorded in Ubyquo is dated 05/05, the next transaction must be dated 06/05 or later.

We recommend not duplicating columns during the import, to avoid errors when bringing in transactions.

Balance adjustment transactions are transactions that Ubyquo creates automatically when it detects gaps or differences between the balances of the imported transactions.

They are generated when the balance recorded in Ubyquo does not match the balance of the transactions to be brought in.

Recommendation: it is advisable to have at most 1 to 3 mismatches. If more are detected, stop the import and review the transactions before continuing.

Imagine that the last transaction brought into Ubyquo has the following data:

Next, you try to bring in an Excel file with the following transactions:

In this case, Ubyquo detects a gap in the balance between the transactions of 06/05 and 07/05.

To adjust the difference, Ubyquo automatically creates balance adjustment transactions.