Updated on 24 September 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) let you adjust the differences between the bank balances in the Excel file and those recorded in Ubyquo.
To calculate the amount of the transaction you need to create, follow these steps.
Identify the required data
Before doing the calculation, you need to know the following values:
- Initial amount in the Excel file
- Initial balance in the Excel file
- Ubyquo balance
Calculate the balance to create
Subtract the initial amount in the Excel file from the initial balance in the Excel file.
Formula:
Balance to create = Initial balance in the Excel file - Initial amount in the Excel file
Calculate the transaction amount
Subtract the balance to create from the Ubyquo balance.
Formula:
Amount to create = Ubyquo balance - Balance to create
The result is the amount you must use to create the balance adjustment transaction.
Get the Excel file
We have a specific Excel template for creating balance adjustment transactions.
To get it, ask our support team for the file.
Result
Once you have calculated the amount and created the balance adjustment transaction, you will be able to adjust the bank balances so that they match those recorded in Ubyquo.
Calculating the balance to create:
To make a correct adjustment, you need to know this data:
- Initial amount (Excel)
- Initial balance (Excel)
- Ubyquo balance
Calculate the balance to create:
Subtract the initial amount in the Excel file from the initial balance in the Excel file.
Formula: Balance to create = Initial balance in the Excel file - Initial amount in the Excel file
Calculate the amount to create:
Subtract the Balance to create from the Ubyquo balance.
Formula: Amount to create = Ubyquo balance - Balance to create
Get the Excel file:
We have a specific Excel file for creating balance adjustment transactions.
Ask our team for it and we will send it to you.
With these steps, you will be able to enter the balance adjustment transactions correctly so that the bank balances match those in Ubyquo.