Updated on October 9, 2026

Manual for importing invoices from Excel

Import invoice lists from Excel with reusable templates, even with several VAT rates.

Import a list of invoices in Excel into Ubyquo to post them. No specific column format is required: you create templates and reuse them.

One invoice per row

Each row of the Excel file is one invoice. Compound invoices can span up to four rows (four VAT rates).

Templates

The first time you will need to create a template; after that, you just choose it.

Result

The imported invoices appear in the Por contabilizar (To post) folder.

Part 1 Open the Excel file

  1. 1

    Choose the company and fiscal year

    In the Facturas (Invoices) tab, go to the company and fiscal year of the invoices you want to import.

    Invoices tab with the company and fiscal year selected
  2. 2

    Click “Importar listado Excel”

    Click Importar listado Excel (Import Excel list), choose the file in the Windows window and click Abrir (Open).

    Choosing the Excel file in the Windows window
  3. 3

    Choose or create the template

    The Gestión de plantillas (Template management) window opens. If you already have templates, select the one you want; if this is your first time, click Nueva plantilla (New template) to open the Editor de plantillas (Template editor).

    Template management windowTemplate editor

Part 2 Set up the template

  1. 4

    Get to know the editor

    There are text fields, where you type the value, and combos, with windows and drop-down lists. Each row has three parts:

    Campo (Field): the data you are going to fill inOpción (Option): drop-down list where you choose the optionValor (Value): text or drop-down list, depending on the option chosen
    Field, Option and Value columns of the editor
  2. 5

    Name it

    In Nombre de plantilla (Template name), enter a descriptive name that identifies the type of invoices and the company.

    Mandatory fields are marked with an asterisk.

  3. 6

    Choose the sheet

    In Hoja (Sheet), indicate which sheets of the Excel workbook are read. With Nombre (Name) or Posición (Position), the sheet is chosen in the Valor drop-down list.

    Nombre: by the sheet namePosición: by its position in the workbookTodas (All): all the sheets in the workbook
    Options of the Sheet field
  4. 7

    Enter the header row

    In Fila cabecera (Header row), enter the number of the row that contains the header. Ubyquo will try to fill in the rest of the fields automatically; you can change them and add any that are missing.

  5. 8

    Flag multi-row invoices

    Turn on Tiene facturas con varias filas (Has invoices with several rows) if the Excel file has invoices with more than one line.

  6. 9

    Indicate the company

    In Código Empresa (Company code), choose where the company of the invoices comes from:

    Columna (Column): a column of the Excel fileCódigo Empresa Seleccionado (Selected company code): the company you are on in Ubyquo (recommended)Valor Fijo (Fixed value): you type the company name
    Options of the Company code field
  7. 10

    Indicate the fiscal year

    In Ejercicio (Fiscal year), choose where the fiscal year of the invoices comes from:

    Columna: a column of the Excel fileEjercicio Seleccionado (Selected fiscal year): the fiscal year you are on in Ubyquo (recommended)Valor Fijo: you type the year of the fiscal year
    Options of the Fiscal year field
  8. 11

    Fill in the remaining fields

    For each piece of invoice data, choose where it comes from. With Columna you choose the Excel column in the Valor drop-down list; with Valor Fijo you type or choose the data directly. The options for each field are in the table below.

  9. 12

    Refresh and save

    Refresh the template data according to the header of the Excel file you are importing and save the changes.

FieldOptions
Emitida | Recibida (Issued | Received)Columna · Valor Fijo (you choose Emitida or Recibida in the combo)
Serie (Series)Columna · Valor Fijo (you type the series)
Número de factura (Invoice number)Columna · Valor Fijo (you type the invoice number)
Num Documento (Document number)Columna · Valor Fijo (you type the document number)
Fecha Factura (Invoice date)Columna · Valor Fijo (you type the date)
Concepto (Description)Columna · Valor Fijo (you type a description)
NIF Tercero (Third-party NIF)Columna · Valor Fijo (you type the third party's NIF)
Tercero (Third party)Columna · Valor Fijo (you type the third party's NIF)
Base Imp. (Taxable base)Columna · Calculado (Calculated, from the %IVA and IVA fields)
%IVA (VAT %)Columna · Calculado (from the Base and IVA fields) · Valor Fijo (you choose the percentage in the combo)
IVA (VAT)Columna · Calculado (from the Base and %IVA fields)
%R. Eq. (Equivalence surcharge %)Columna · Calculado (calculates the value of the R. Equivalencia field) · Valor Fijo (you choose the equivalence surcharge percentage)
R. Equiv. (Equivalence surcharge)Columna · Calculado (calculates the value of the % Recargo Equivalencia field)
%Ret. (Withholding %)Columna · Calculado (calculates the value of the Retención field) · Valor Fijo (you choose the withholding percentage)
Retención (Withholding)Columna · Calculado (calculates the value of the % Retención field)
Total Factura (Invoice total)Columna (recommended, to check the amounts better) · Calculado (from the previous accounting fields; not recommended, because it does not let you check that the values are correct)
Fichero (File)Columna (the column with the folder/file_name path of each invoice image) · Autogenerado (Auto-generated: creates a generic image of the invoice)

Part 3 Review and import

  1. 13

    Review the columns

    The mandatory fields are Base Imponible (Taxable base), %IVA and IVA. The rest appear if they come in the Excel file, and you can add or remove them with the two options at the top.

    Template view with the columns
  2. 14

    Add the columns you need

    Click Añadir columnas (Add columns) and choose the one you need:

    Recargo Equivalencia (Equivalence surcharge)Retención (Withholding)Canal (Channel)Delegación (Branch)Proyecto Analítica (Analytical project)Sección (Section)Departamento (Department)
    List of columns that can be added
  3. 15

    Remove the ones you don't need

    With Eliminar columnas (Remove columns) you remove the ones you don't need. Only the ones you have added appear.

    List of columns that can be removed
  4. 16

    Check with “Ver Datos”

    Click Ver Datos (View data) to see how the invoices in the Excel file will be handled; with Ver edición (View edit) you go back to the template to change a field. At the bottom right you can browse the invoices and review a specific one.

    View data screen with the invoices from the Excel file
  5. 17

    Import the invoices

    If everything is correct, click Importar Facturas (Import invoices). A window opens with the available balance, the invoices that will be added and the balance to be deducted.

    Window with the available balance and the balance to be deductedImported invoices
  6. 18

    Handle them like the rest

    The invoices appear in the Por contabilizar folder and go through the same stages as the rest: Edit, Verify and Export.

    If errors appear, there may be a problem with the template: check in Ver Datos how the fields are filled in.

Running the same Excel file again

To change the template or any field in the Excel file, always use the same file. The first time it is processed, two columns are added at the end so that you can run it again and modify the invoices in Ubyquo at no extra cost.

Columns added at the end of the Excel file

If you process that Excel file again, Ubyquo tells you that no balance will be deducted, and the changes are reflected in Ubyquo.

Message saying that no balance will be deducted