Convert Facturae to Excel
Drop the Facturae XML, signed or not. The Spanish structure is read and laid out with the same column names the rest of the tool uses.
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
| Category | Rate | Taxable base | VAT amount |
|---|
| # | Qualifier | Reference | Amount | Paid |
|---|
| Segment | Element | Value |
|---|
Signed XML that still reads
Facturae is Spain's national invoice format, used for FACe public-sector submissions and widely between companies. Files are normally XAdES-signed, but the signature is an element inside the XML rather than a wrapper around it, so a signed Facturae still parses here. What the tool does not do is verify that signature, and it says so rather than implying a check that never happened.
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.
- InvoiceHeader with number, series, document and class type
- SellerParty and BuyerParty, including NIF and full address
- InvoiceLine detail with quantity, unit price and tax rate
- TaxesOutputs per rate, with taxable base and amount
- InvoiceTotals: gross, total outstanding and executable amounts
Questions
Does it verify the digital signature?
No. It reads the invoice data. Signature validation is a different job with different consequences, and claiming it would be worse than not doing it.
Which Facturae versions are supported?
The 3.2 family, including 3.2.1 and 3.2.2, which covers what FACe accepts today.
Are several invoices in one file handled?
A Facturae batch with multiple invoices is read, and each invoice appears with its own header and lines.