Intuit QuickBooks Online to ZUGFeRD 2.3 (EN 16931 / Extended) Integration & Schema Crosswalk
Why Native Intuit QuickBooks Online Exports Fail ZUGFeRD 2.3 (EN 16931 / Extended) Validation
1. QuickBooks Online's `Invoice` API lacks a dedicated field for the Leitweg-ID (BT-10), which is mandatory for German public sector invoices under BR-DE-15; the `CustomerMemo` field is free-text and cannot be reliably parsed to extract a structured Leitweg-ID, causing validation failures.
2. The `DocNumber` field is limited to 21 characters and does not enforce the required invoice number uniqueness or format (BT-1), and QuickBooks Online does not expose the seller's SIREN (BT-30) or VAT identifier (BT-31) in a structured format, leading to missing or invalid BR-FR-01 and BR-S-08 compliance.
3. Monetary amounts such as `TotalAmt` are returned as floating-point numbers with potential rounding errors, and QuickBooks Online does not provide line-level VAT category codes (BT-151) or exemption reasons (BT-120), causing BR-CO-10 and BR-CO-15 violations due to missing or inconsistent VAT breakdown.
Mandatory Intuit QuickBooks Online to ZUGFeRD 2.3 (EN 16931 / Extended) Field Crosswalk Matrix
Deterministic attribute mapping from Intuit QuickBooks Online payloads to EN 16931 Business Terms (BT) and CII-D16B XPaths.
| Intuit QuickBooks Online Source Field | EN 16931 Business Term | Target CII-D16B XPath | Card. | Transformation & Normalization Rule | Schematron Rule |
|---|---|---|---|---|---|
| DocNumber String, e.g., "INV-12345" | BT-1 | /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:ID | 1..1 | Trim whitespace, replace any non-alphanumeric characters with hyphens, and ensure the result is unique and non-empty. If empty, generate a UUID-based identifier. | BR-02 ↗ |
| CustomerMemo String, e.g., "Leitweg-ID: 123-456-789" | BT-10 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerReference | 0..1 | Extract the Leitweg-ID using a regex pattern (e.g., /Leitweg-ID:\s*([0-9-]+)/i). If not found, leave empty. The extracted value must match the Leitweg-ID format (digits and hyphens, max 50 chars). | BR-DE-15 ↗ |
| TotalAmt Number, e.g., 1234.56 | BT-106 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount | 1..1 | Convert to decimal with two fractional digits using round-half-up. Ensure the value equals the sum of line net amounts (BT-106 = sum of BT-131). If mismatch, recalculate from lines. | BR-CO-10 ↗ |
| CustomerRef String, e.g., "FR12345678901" | BT-48 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:SpecifiedTaxRegistration/ram:ID[@schemeID='VA'] | 0..1 | Extract the VAT identifier from CustomerRef if it matches the pattern for a French SIREN (9 digits) or VAT number (e.g., FR + 11 digits). Prefix with 'FR' if only SIREN is present. Validate against the French VAT format. | BR-FR-01 ↗ |
Test Your Intuit QuickBooks Online ZUGFeRD 2.3 (EN 16931 / Extended) XML Export Live
Validate your generated CII-D16B payload against EN 16931 & ZUGFeRD 2.3 (EN 16931 / Extended) 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