Top Up Credits β†’
InvoiceSpec / ERP Crosswalks / zoho-books-to-peppol-bis-3
SOURCE: ZOHO BOOKS β†’ TARGET: PEPPOL BIS BILLING 3.0 (UBL-2.1) Mandate: 2026-01-01 (EU)

Zoho Books to Peppol BIS Billing 3.0 Schema Crosswalk & XML Compiler

01. Architectural Gap Analysis

Why Native Zoho Books Exports Fail Peppol BIS Billing 3.0 Validation

1. Zoho Books API v3 `/invoices` does not expose a dedicated field for the buyer's electronic address (BT-49) or the seller's electronic address (BT-34); the `tax_reg_no` field is a tax identifier, not an EAS/electronic address, so Peppol requires a separate mapping to construct the `cbc:EndpointID` with a schemeID (e.g., EAS code) that Zoho does not provide.

2. Zoho Books returns monetary amounts as JSON numbers (e.g., `sub_total`: 100.00) without explicit decimal precision or currency scale; Peppol BIS Billing 3.0 mandates amounts to be formatted with exactly two decimal places and rounded using the 'round half to even' rule, which native exports do not enforce, leading to BR-CO-10 and BR-CO-15 violations.

3. Zoho Books does not capture the Leitweg-ID (BT-10) or SIREN (BT-30) required for German and French domestic mandates; the `customer_name` and `tax_reg_no` fields cannot be reliably transformed into these identifiers without additional external data, causing BR-DE-15 and BR-FR-01 failures.

02. Zoho Books to UBL-2.1 Field Crosswalk Table
Zoho Books API Field EN 16931 Business Term Target UBL-2.1 XPath Card. Normalization Rule Assertion
invoice_number String, e.g., "INV-2024-001" BT-1 /Invoice/cbc:ID 1..1 Trim whitespace and replace any characters outside the allowed set [A-Za-z0-9\-._] with a hyphen; ensure the resulting string is non-empty and does not exceed 50 characters. BR-02 β†—
date String (ISO 8601 date), e.g., "2024-05-15" BT-2 /Invoice/cbc:IssueDate 1..1 Parse the date string using the format YYYY-MM-DD and reformat to YYYY-MM-DD (no change if already correct); reject if the date is invalid or missing. BR-01 β†—
tax_reg_no String, e.g., "DE123456789" BT-31 /Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyTaxScheme/cbc:CompanyID 0..1 Remove any spaces or punctuation; if the value starts with a country code (e.g., 'DE'), strip it and use the remainder as the tax identifier; otherwise use the value as-is. Set the schemeID attribute to 'VA' for VAT numbers or 'FC' for fiscal codes based on the country context. BR-CO-10 β†—
line_items[].item_total Number, e.g., 100.00 BT-131 /Invoice/cac:InvoiceLine/cbc:LineExtensionAmount 1..n For each line item, convert the numeric value to a string with exactly two decimal places using round-half-to-even; ensure the currencyID attribute is set to the invoice currency (default 'EUR' if not provided). BR-CO-15 β†—
03. Live Zoho Books β†’ Peppol BIS Billing 3.0 Workbench
1 CREDITS
invoice.xmlUBL-2.1
DETECTED SOURCEShopify
BT-131 LINE SUM199.95 EUR
BT-106 HEADER200.00 EUR
SCHEMATRON: 7 FATAL, 1 WARNΒ· 1ms
Peppol BIS Billing 3.0
BR-01An Invoice shall have a valid EN 16931 Specification identifier (BT-24)
Spec & Diff
xpath: /ubl:Invoice/cbc:CustomizationID

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>.

BR-CL-01Document currency code (BT-5) MUST belong to ISO 4217 uppercase code list
Spec & Diff
xpath: /ubl:Invoice/cbc:DocumentCurrencyCode

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-EN16931-R008Document MUST NOT contain empty XML elements (found 1: <cbc:AdditionalStreetName>)
Spec & Diff
xpath: //cbc:AdditionalStreetName[not(node())]

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.

PEPPOL-EN16931-R020Seller electronic address (BT-34) MUST be provided with a valid EAS @schemeID
Spec & Diff
xpath: /ubl:Invoice/cac:AccountingSupplierParty/cac:Party/cbc:EndpointID

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>.

PEPPOL-EN16931-R010Buyer electronic address (BT-49) MUST include a valid EAS @schemeID attribute
Spec & Diff
xpath: /ubl:Invoice/cac:AccountingCustomerParty/cac:Party/cbc:EndpointID

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>.

BR-DE-15Buyer reference / Leitweg-ID (BT-10) is missing
Spec & Diff
xpath: /ubl:Invoice/cbc:BuyerReference

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.

BR-CO-10Sum of Invoice line net amount (BT-106 = 200.00) != sum of lines (BT-131 = 199.95)
Spec & Diff
xpath: /ubl:Invoice/cac:LegalMonetaryTotal/cbc:LineExtensionAmount

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.

BR-S-08Standard rate VAT TaxableAmount (BT-116 = 200.00) does not match S-rated lines (199.95)
Spec & Diff
xpath: /ubl:Invoice/cac:TaxTotal/cac:TaxSubtotal/cbc:TaxableAmount

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.

Automate Zoho Books β†’ Peppol BIS Billing 3.0 AP Delivery

Deploy certified Peppol Access Point & ZUGFeRD ERP connector

04. Other ERP Compliance Matrices