Updated on 9 October 2026
Import the breakdown of a remittance from Excel
Break a remittance down into its individual operations from an Excel file with description, NIF and amount.
Before you start
You need the Excel file of the bank remittance with the data for each operation: Concepto (Description), NIF, Importe (Amount) and, optionally, Contrapartida (Contra account).

- 1
Open the transactions editor
Double-click the bank transaction of the remittance to open the Editor de Movimientos (Transactions editor).
- 2
Click “Importar Excel N19, N34”
At the top of the editor, click Importar Excel N19, N34 (Import Excel N19, N34).

- 3
Choose the remittance type
Select the one that applies:
Remesa estándar (Standard remittance)Remesa de efectos comerciales (Commercial bills remittance)
Review the breakdown
Ubyquo breaks down the remittance automatically and assigns:
DescriptionNIFAmountContra accounts (if the NIF is provided or they were entered beforehand)
What happens if the amount does not match?
If the total amount in the Excel file does not match the amount of the bank transaction, Ubyquo shows a warning. There are two possible situations:

Option 1 You selected the wrong document
- 1
Check the file
Make sure the Excel file corresponds to the remittance of the bank transaction you are working on.
Option 2 The document is correct, but contra accounts are missing
- 1
Click “Añadir contrapartidas”
If the breakdown does not reach the total amount of the transaction because contra accounts are missing, complete it by hand: at the top of the editor, click Añadir contrapartidas (Add contra accounts) and adjust the total amount of the transaction.


