Updated on October 9, 2026
How to create balance adjustment transactions for a bank account
Calculate the amount of the transaction that adjusts the Excel balance to the one recorded in Ubyquo.
Balance adjustment transactions (movimientos de cuadre) adjust the differences between the bank balances in the Excel file and those recorded in Ubyquo. This is how you calculate the amount of the transaction you need to create.
- 1
Gather the data
Before calculating, you need these values:
Initial amount in the Excel fileInitial balance in the Excel fileUbyquo balance - 2
Calculate the balance to create
Subtract the initial amount in the Excel file from the initial balance in the Excel file:
Balance to create = Initial balance in the Excel file - Initial amount in the Excel file - 3
Calculate the transaction amount
Subtract the balance to create from the Ubyquo balance:
Amount to create = Ubyquo balance - Balance to create. The result is the amount of the balance adjustment transaction. - 4
Ask for the Excel template
We have a specific Excel template for creating balance adjustment transactions: ask our support team for it and we will send it to you.
Done! Once the balance adjustment transaction is created, the bank balances match those recorded in Ubyquo.
