# Excel to FatturaPA

Fill the template, drop the workbook, download a FatturaPA v1.2.2 XML file per invoice.

Source: https://tally-stick.com/excel-to-fatturapa

## How it works

Download the template from the page, fill it in, and drop it back onto the same page. You get one FatturaPA XML file per invoice row, named after the invoice number. Nothing is uploaded.

The seller section requires Partita IVA and Regime Fiscale. The buyer section requires either a CodiceDestinatario (7 characters) or a PEC address.

AliquotaIVA and Natura codes work together: when the VAT rate is 0, Natura explains why (N4 exempt, N2.1 reverse charge, etc.).

The file is ready to submit to SDI via the FatturaPA channel. Tallystick does not submit to SDI.

## What is checked before anything is written

The file is refused when: invoice number absent, issue date missing, TipoDocumento missing, RegimeFiscale missing, seller Partita IVA missing, CodiceDestinatario not 7 characters, or no lines entered. Zero-rate lines require a Natura code.

## Common questions

### Which FatturaPA version?

v1.2.2, the format SDI has accepted since October 2020.

### Can I go the other way?

Yes. [FatturaPA to Excel](https://tally-stick.com/fatturapa-to-excel) reads a finished file back into a spreadsheet.

### I would rather type the invoice.

[Create FatturaPA](https://tally-stick.com/create-fatturapa) is a form, and it writes the same file.

## Related tools

- [FatturaPA to Excel](https://tally-stick.com/fatturapa-to-excel)
- [Create FatturaPA](https://tally-stick.com/create-fatturapa)
- [FatturaPA to PDF](https://tally-stick.com/fatturapa-to-pdf)