DataContractGate

Cloud Free needs no credit card

Sign inSign up
← Catalog
Accounting

Intuit QuickBooks Online — data contract (compatible with Intuit QuickBooks Online’s documented schema; not affiliated with Intuit QuickBooks Online)

QuickBooks Online Invoice entity — core fields from the Accounting API. Compatible with Intuit's documented Invoice entity; not affiliated with Intuit or QuickBooks.

Validate a client's Intuit QuickBooks Online export at ingest into your warehouse, or with POST /egress before sending the same shape to a partner, reverse ETL, or an AI agent.

Download YAML

Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.

Fields

NameTypeRequiredRuleDescription
Idstringrequiredpattern /^[0-9]+$/Unique identifier for the invoice within the QuickBooks company.
SyncTokenstringoptionalpattern /^[0-9]+$/—
DocNumberstringoptional——
TxnDatedateoptional——
DueDatedateoptional——
CustomerRefobjectrequired—Reference to the customer the invoice is for.
CurrencyRefobjectoptional——
TotalAmtnumberrequired≥ 0Total amount of the transaction, including tax.
Balancenumberoptional≥ 0—

Sample rows

Three synthetic rows we wrote. They validate against this contract with zero violations. No real customer data.

[
  {
    "Balance": 1250,
    "CurrencyRef": {
      "name": "United States Dollar",
      "value": "USD"
    },
    "CustomerRef": {
      "name": "Sample Client Co",
      "value": "24"
    },
    "DocNumber": "1070",
    "DueDate": "2026-02-09",
    "Id": "130",
    "SyncToken": "0",
    "TotalAmt": 1250,
    "TxnDate": "2026-01-10"
  },
  {
    "Balance": 0,
    "CustomerRef": {
      "name": "Example Retail LLC",
      "value": "25"
    },
    "DocNumber": "1071",
    "DueDate": "2026-01-26",
    "Id": "131",
    "SyncToken": "2",
    "TotalAmt": 480.5,
    "TxnDate": "2026-01-12"
  },
  {
    "Balance": 99.99,
    "CurrencyRef": {
      "value": "CAD"
    },
    "CustomerRef": {
      "value": "26"
    },
    "DocNumber": "1072",
    "Id": "132",
    "TotalAmt": 99.99,
    "TxnDate": "2026-01-15"
  }
]

Provenance

Checked
2026-11-05
Version
v1.0
Author
DataContractGate
License
MIT

Spotted a mismatch with the vendor’s current schema? Report an issue.

Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.