Intuit QuickBooks Online to Peppol BIS Billing 3.0 Schema Crosswalk & XML Compiler
Why Native Intuit QuickBooks Online Exports Fail Peppol BIS Billing 3.0 Validation
1. QuickBooks Online's `Invoice` entity lacks mandatory Peppol identifiers: `CustomerRef` only provides a display name and internal ID, not the required EAS scheme and endpoint (BT-34/BT-49), and there is no field for Leitweg-ID (BT-10) or SIREN (BT-30), causing BR-01/BR-02 failures.
2. Tax amounts from `TxnTaxDetail` are calculated per line with QuickBooks' proprietary rounding, which often differs from Peppol's required document-level rounding (BR-CO-15), leading to sum mismatches and validation errors like BR-CO-10.
3. QuickBooks does not enforce or export the mandatory invoice type code (BT-3) or specification identifier (BT-24), and `DocNumber` may contain characters invalid for Peppol (PEPPOL-EN16931-R008), while `TxnDate` lacks timezone context required for proper date formatting.
| Intuit QuickBooks Online API Field | EN 16931 Business Term | Target UBL-2.1 XPath | Card. | Normalization Rule | Assertion |
|---|---|---|---|---|---|
| DocNumber String, e.g., "INV-2024-001" | BT-1 | /Invoice/cbc:ID | 1..1 | Trim whitespace, replace any characters outside [A-Za-z0-9\-._] with '-', and truncate to 50 characters. If empty, generate a UUID. | PEPPOL-EN16931-R008 β |
| TxnDate Date, e.g., "2024-01-15" | BT-2 | /Invoice/cbc:IssueDate | 1..1 | Format as YYYY-MM-DD. If TxnDate is missing, use current date in UTC. | BR-01 β |
| TxnTaxDetail.TotalTax Decimal, e.g., 123.45 | BT-110 | /Invoice/cac:TaxTotal/cbc:TaxAmount | 1..1 | Round to 2 decimal places using half-up rounding. Ensure currencyID attribute matches invoice currency (default EUR). | BR-CO-15 β |
| Line[].SalesItemLineDetail Object, e.g., { "ItemRef": { "value": "1", "name": "Service" }, "Qty": 2, "UnitPrice": 100.00 } | BT-131 | /Invoice/cac:InvoiceLine/cbc:ID | 1..n | For each line, generate a sequential line ID starting from 1. Map Qty to BT-129 and UnitPrice to BT-146. Calculate line extension amount as Qty * UnitPrice rounded to 2 decimals. | BR-CO-10 β |
Missing <cbc:CustomizationID> or value does not declare EN 16931 CIUS compliance.
fix: Insert <cbc:CustomizationID>urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0</cbc:CustomizationID>.
Found invalid or lowercase currency code "eur". Expected uppercase ISO 4217 (e.g. "EUR").
fix: Replace <cbc:DocumentCurrencyCode>eur</cbc:DocumentCurrencyCode> with uppercase "EUR".
Peppol Schematron forbids empty elements such as <cbc:AdditionalStreetName></cbc:AdditionalStreetName> serialized from null ERP fields.
fix: Strip empty <cbc:AdditionalStreetName> nodes prior to XML serialization.
Missing <cbc:EndpointID schemeID="..."> inside <cac:AccountingSupplierParty>/<cac:Party>.
fix: Add <cbc:EndpointID schemeID="9930">DE123456789</cbc:EndpointID> as the first child of Seller <cac:Party>.
Buyer <cbc:EndpointID> is either missing or lacks the mandatory EAS @schemeID attribute.
fix: Add schemeID="9930" (or "0088" for GLN / "0204" for Leitweg-ID) to Buyer <cbc:EndpointID>.
No <cbc:BuyerReference> (BT-10) found. Mandatory in XRechnung 3.0 (BR-DE-15) and required in Peppol BIS 3.0 (PEPPOL-EN16931-R003) when OrderReference is absent.
fix: Insert <cbc:BuyerReference>991-12849-74</cbc:BuyerReference> in the document header.
Mathematical discrepancy of 0.05 EUR between InvoiceLine sum (199.95) and LegalMonetaryTotal/LineExtensionAmount (200.00).
fix: Set cbc:LineExtensionAmount and cbc:TaxExclusiveAmount to 199.95.
TaxSubtotal/TaxableAmount reports 200.00, but Standard rated ("S") lines total 199.95.
fix: Recalculate BT-116 = 199.95, VAT BT-117 = 37.99, and PayableAmount BT-115 = 237.94.