When you download your invoices, you receive a compressed file containing 4 CSV files. Each one captures a different part of the information, and all of them are linked to each other through the invoice number.
You can open any of these files with Excel, Google Sheets, or any spreadsheet programme.
1. Invoices: general summary of each invoice
This is the main file: one row per invoice issued, with its general details.
Column | What it means |
Serie ID | Identifier of the series the invoice belongs to |
Invoice Number | Unique invoice number |
Shopify Order ID | The Shopify order number it corresponds to |
Regime | Tax regime under which it was generated (for example, TicketBAI) |
Is Test | Indicates whether the invoice was generated in test mode (true) or is a real invoice (false) |
Invoice type | Type of invoice (see table below) |
Issued At | Exact date and time of issue |
Total Tax Amount | Total tax on the invoice |
Grand Total Amount | Total invoice amount, taxes included |
Invoice types you may find:
Code | Meaning |
F1 | Full invoice |
F2 | Simplified invoice |
F3 | Corrective invoice by substitution |
R1 | Corrective invoice for error or correction |
R5 | Simplified corrective invoice |
Important: the same order can have multiple rows in this file. For example, the original sale, a partial return, and a subsequent correction are 3 separate invoices, all linked to the same Shopify Order ID.
2. Taxes: tax breakdown per invoice
This file details, line by line, how the tax for each invoice has been calculated. The same invoice can have multiple rows if more than one tax rate applies — for example, products with different VAT rates in the same order.
Column | What it means |
Serie ID | Series identifier, to link this line to its invoice |
Invoice Number | Number of the invoice this line belongs to |
Shopify Order ID | The Shopify order number it corresponds to |
Base Amount | Base amount on which the tax is calculated, excluding tax |
Taxed Amount | The tax amount already calculated |
Currency | Currency (usually EUR) |
Rate | Tax rate applied (for example, 0.21 means 21%) |
If you add up all the Taxed Amount lines for the same invoice, you get the Total Tax Amount shown in the invoices file.
3. Payments: how each invoice was collected
This file captures the payment method and amount associated with each invoice.
Column | What it means |
Serie ID | Series identifier, to link this payment to its invoice |
Invoice Number | Number of the invoice this payment belongs to |
Shopify Order ID | The Shopify order number it corresponds to |
Amount | Amount collected, or returned if negative |
Currency | Payment currency |
Type | Payment method: Cash for cash or standard card payments, Custom for personalised payment methods configured in the store |
A negative amount in this file corresponds to a return or refund.
4. Products: detail of the items on each invoice
This file lists each product or sales line included in the invoice, one per row.
Column | What it means |
Serie ID | Series identifier, to link this line to its invoice |
Invoice Number | Number of the invoice this line belongs to |
Shopify Order ID | The Shopify order number it corresponds to |
Product ID | Shopify product identifier |
Variant ID | Identifier of the specific product variant (size, colour, etc.) |
Title | Product name as it appears on the invoice |
Quantity | Quantity sold, or returned if negative |
Price | Unit price of the product |
Taxable | Indicates whether the product is subject to tax (true) or exempt (false) |
Total Tax Amount | Tax corresponding to that product line |
The Product ID field may appear empty on return lines. This is expected: returns reference the original sale and do not generate a new product identifier.
How the 4 files relate to each other
All files share the same identification columns (Serie ID, Invoice Number, and Shopify Order ID), so you can cross-reference them to see all the information for a specific invoice:
Look it up in invoices.csv to see the summary: total amount, type, and date.
Look it up in taxes.csv to see the exact tax breakdown applied.
Look it up in payments.csv to see how it was collected.
Look it up in products.csv to see the specific items it included.