Skip to main content

CSV to FatturaPA Mapping Reference

This document describes how the standard Transfer CSV fields are mapped to the Italian FatturaPA XML invoice format.

DatiTrasmissione​

Fields below fatturaElettronicaHeader
FatturaPA FieldCSV Source
recipient_pec
recipient_code
Only when: the row is a self invoice, so seller and buyer swap source

CedentePrestatore​

Fields below fatturaElettronicaHeader.cedentePrestatore
FatturaPA FieldCSV Source
recipient_countryOnly when: the seller VAT number is present in the source that applies
recipient_vat_numberOnly when: the seller VAT number is present in the source that applies
recipient_fiscal_code
recipient_business_name
recipient_nameOnly when: the seller has no company name, first and last name are used instead
recipient_last_nameOnly when: the seller has no company name, first and last name are used instead
recipient_address
recipient_city
recipient_postal_code
recipient_country
recipient_province

CessionarioCommittente​

Fields below fatturaElettronicaHeader.cessionarioCommittente
FatturaPA FieldCSV Source
recipient_countryOnly when: the buyer VAT number is present in the source that applies
recipient_vat_numberOnly when: the buyer VAT number is present in the source that applies
recipient_fiscal_code
recipient_business_name
recipient_nameOnly when: the buyer has no company name, first and last name are used instead
recipient_last_nameOnly when: the buyer has no company name, first and last name are used instead
recipient_address
recipient_postal_code
recipient_country
recipient_city
recipient_province

DatiGeneraliDocumento​

Fields below fatturaElettronicaBody[0].datiGenerali.datiGeneraliDocumento
FatturaPA FieldCSV Source
document_type
invoice_date
invoice_number
invoice_subjectOnly when: the invoice subject column is filled

DettaglioLinee​

Fields below fatturaElettronicaBody[0].datiBeniServizi
FatturaPA FieldCSV Source

fatturaElettronicaBody[0].datiBeniServizi.dettaglioLinee​

FatturaPA FieldCSV Source
line_number
line_description
line_vat_rate
line_vat_natureOnly when: the line VAT rate is zero
line_quantity
line_unit_price
Fields below fatturaElettronicaBody[0]
FatturaPA FieldCSV Source

DatiPagamento​

Fields below fatturaElettronicaBody[0].datiPagamento[0]
FatturaPA FieldCSV Source
payment
payment_iban
payment_due_date