Convert FatturaPA to Excel
Drop the FatturaPA XML as the Sistema di Interscambio delivered it. The Italian element names are mapped onto the same columns as every other format here.
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
| Category | Rate | Taxable base | VAT amount |
|---|
| # | Qualifier | Reference | Amount | Paid |
|---|
| Segment | Element | Value |
|---|
The Italian file and its signature
Italy has run mandatory e-invoicing through the SdI longer than anyone else in the EU, which means a lot of these files sit in archives waiting to be read back. One practical catch: invoices are often delivered as .xml.p7m, a CAdES container wrapping the XML. Unwrap it first and the XML inside opens here; the signed container itself is not read, and pretending otherwise would just fail later.
What you get out
Every field below is read from the file itself. Nothing is inferred, and a field the invoice does not carry is left empty rather than filled in with a plausible guess.
- DatiGeneraliDocumento: number, TipoDocumento, date and currency
- CedentePrestatore and CessionarioCommittente with partita IVA and codice fiscale
- DettaglioLinee line by line, with quantity, unit price and aliquota IVA
- DatiRiepilogo per VAT rate, including natura where the rate is zero
- Payment data: IBAN, terms and the ImportoTotaleDocumento
Questions
My file ends in .p7m and will not open.
That is the signed container, not the invoice. Strip the CAdES signature with any tool that handles p7m and drop the XML that comes out.
Which FatturaPA versions are read?
The 1.2 family, which is what the SdI has been carrying for years, including the ordinary and simplified layouts.
Is natura kept when the VAT rate is zero?
Yes. A zero rate with no reason is an invoice you cannot defend, so the exemption code comes along with the tax rows.