Updated on October 9, 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).

Example Excel file with the breakdown of a remittance
  1. 1

    Open the transactions editor

    Double-click the bank transaction of the remittance to open the Editor de Movimientos (Transactions editor).

  2. 2

    Click “Importar Excel N19, N34”

    At the top of the editor, click Importar Excel N19, N34 (Import Excel N19, N34).

    Import Excel N19, N34 button in the transactions editor
  3. 3

    Choose the remittance type

    Select the one that applies:

    Remesa estándar (Standard remittance)Remesa de efectos comerciales (Commercial bills remittance)
    Remittance types
  4. Review the breakdown

    Ubyquo breaks down the remittance automatically and assigns:

    DescriptionNIFAmountContra accounts (if the NIF is provided or they were entered beforehand)
    Remittance breakdown in the transactions editor

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:

Warning that the amount does not match

Option 1 You selected the wrong document

  1. 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. 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.

    Breakdown that does not reach the transaction amountAdd contra accounts button