Intuit QuickBooks Online to Peppol BIS Billing 3.0 Integration & Schema Crosswalk
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.
Mandatory Intuit QuickBooks Online to Peppol BIS Billing 3.0 Field Crosswalk Matrix
Deterministic attribute mapping from Intuit QuickBooks Online payloads to EN 16931 Business Terms (BT) and UBL-2.1 XPaths.
| Intuit QuickBooks Online Source Field | EN 16931 Business Term | Target UBL-2.1 XPath | Card. | Transformation & Normalization Rule | Schematron Rule |
|---|---|---|---|---|---|
| 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 ↗ |
Test Your Intuit QuickBooks Online Peppol BIS Billing 3.0 XML Export Live
Validate your generated UBL-2.1 payload against EN 16931 & Peppol BIS Billing 3.0 rules directly in your browser.
Missing <cbc:CustomizationID> or value does not declare EN 16931 CIUS compliance.
Remediation: 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").
Remediation: 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.
Remediation: Strip empty <cbc:AdditionalStreetName> nodes prior to XML serialization.
Missing <cbc:EndpointID schemeID="..."> inside <cac:AccountingSupplierParty>/<cac:Party>.
Remediation: 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.
Remediation: 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.
Remediation: 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).
Remediation: Set cbc:LineExtensionAmount and cbc:TaxExclusiveAmount to 199.95.
TaxSubtotal/TaxableAmount reports 200.00, but Standard rated ("S") lines total 199.95.
Remediation: Recalculate BT-116 = 199.95, VAT BT-117 = 37.99, and PayableAmount BT-115 = 237.94.
Other ERP to E-Invoicing Compliance Bridges
Unlock Pro Batch XML / PDF Converter ($29/mo) →4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings