TTallystick
Pricing Sign in

Convert a UBL invoice to Excel

Drop a UBL 2.1 Invoice or CreditNote, whatever the sending country. The document is mapped onto the same columns as every other format here, so a UBL file and a CII file end up looking alike.

Drop your invoice files here
or choose them from your computer. Several files at once is fine.
XRechnung · ZUGFeRD · Factur-X · UBL · CII · Peppol · FatturaPA · Facturae · KSeF FA · X12 · EDIFACT · OFX · IIF · CSV
Files stay in your browser, nothing is uploaded No account, no daily limit No file at hand?
0 files uploaded, ever Test corpus comes from the official XRechnung, ZUGFeRD, Peppol and OASIS test suites.
Export Totals not checked Format
Invoice
Seller and buyer
Line items
#Description QtyUnit Unit priceVAT %Net amount
Tax breakdown and totals
CategoryRateTaxable baseVAT amount
Payment and references

One syntax under many national names

UBL 2.1 is the OASIS document standard that XRechnung, Peppol BIS Billing 3.0 and several national formats all sit on top of. That is why an invoice can be called four things and still be the same XML underneath. Credit notes are a separate document type in UBL rather than an invoice with a minus sign, and they are read here as such.

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.

  • Invoice or CreditNote, detected and labelled, not assumed
  • Header: number, type code, issue and due date, currency, references
  • AccountingSupplierParty and AccountingCustomerParty in full
  • InvoiceLine detail with quantity, unit code, price and VAT category
  • TaxSubtotal per rate and the LegalMonetaryTotal block

Questions

Does the namespace prefix matter?

No. The parser matches on local element names, so cbc, cac, ubl or no prefix at all are all read the same way.

Which UBL document types are supported?

Invoice and CreditNote, plus the SelfBilledInvoice and DebitNote variants. Orders and despatch advices are not invoices and are not read.

My file is Peppol BIS. Is that different?

Peppol BIS Billing 3.0 is UBL with extra rules, so it reads here without anything special. There is a Peppol page if that is the wording you were looking for.