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

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

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


Part 2 Set up the template
- 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
- 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.
- 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
- 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.
- 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.
- 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
- 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
- 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.
- 12
Refresh and save
Refresh the template data according to the header of the Excel file you are importing and save the changes.
| Field | Options |
|---|---|
| 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
- 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.

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

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

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


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

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

