Integrations
QuickBooks datasets and fields
The 22 datasets Maven lands from QuickBooks, every field in them, and how the connection syncs.
Maven lands 22 datasets from QuickBooks in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the QuickBooks integration page.
Connection and sync#
You connect QuickBooks by signing in to it and approving access, so nobody shares a password.
The first QuickBooks sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Datasets#
Invoices#
Invoices — amounts, dates, customer refs.
| Field | Type |
|---|---|
| invoice ID | Text |
| doc number | Text |
| customer ID | Text |
| customer name | Text |
| email status | Text |
| print status | Text |
| date | Date |
| txn date | Date |
| due date | Date |
| total amount | Number |
| balance | Number |
| status | Text |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Payments#
Payments received.
| Field | Type |
|---|---|
| payment ID | Text |
| customer ID | Text |
| customer name | Text |
| date | Date |
| txn date | Date |
| total amount | Number |
| payment method | Text |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Payment links#
| Field | Type |
|---|---|
| payment ID | Text |
| line index | Integer |
| linked txn index | Integer |
| linked txn ID | Text |
| linked txn type | Text |
| amount | Number |
| payment updated at | Text |
| realm ID | Text |
Expenses#
Purchases and expenses.
| Field | Type |
|---|---|
| expense ID | Text |
| vendor ID | Text |
| vendor name | Text |
| date | Date |
| txn date | Date |
| total amount | Number |
| payment type | Text |
| account name | Text |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Invoice lines#
Versioned sales-item lines at invoice × line index grain.
| Field | Type |
|---|---|
| invoice ID | Text |
| line index | Integer |
| line ID | Text |
| detail type | Text |
| description | Text |
| amount | Number |
| quantity | Number |
| unit price | Number |
| item ID | Text |
| item name | Text |
| service date | Date |
| class ID | Text |
| class name | Text |
| tax code | Text |
| invoice updated at | Text |
| realm ID | Text |
Customers#
Active and inactive customer hierarchy, lifecycle, balance, and geography.
| Field | Type |
|---|---|
| customer ID | Text |
| display name | Text |
| company name | Text |
| given name | Text |
| family name | Text |
| Text | |
| phone | Text |
| parent customer ID | Text |
| is sub customer | True/false |
| is active | True/false |
| balance | Number |
| open balance with jobs | Number |
| currency | Text |
| billing city | Text |
| billing state | Text |
| billing country | Text |
| billing postal code | Text |
| shipping city | Text |
| shipping state | Text |
| shipping country | Text |
| shipping postal code | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Vendors#
Active and inactive vendor identity, terms, balance, and geography.
| Field | Type |
|---|---|
| vendor ID | Text |
| display name | Text |
| company name | Text |
| given name | Text |
| family name | Text |
| Text | |
| phone | Text |
| term ID | Text |
| term name | Text |
| is 1099 vendor | True/false |
| is active | True/false |
| balance | Number |
| currency | Text |
| billing city | Text |
| billing state | Text |
| billing country | Text |
| billing postal code | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Items#
Active and inactive product/service catalog with hierarchy and inventory economics.
| Field | Type |
|---|---|
| item ID | Text |
| name | Text |
| description | Text |
| purchase description | Text |
| sku | Text |
| item type | Text |
| parent item ID | Text |
| is active | True/false |
| is taxable | True/false |
| unit price | Number |
| purchase cost | Number |
| quantity on hand | Number |
| inventory start date | Date |
| income account ID | Text |
| income account name | Text |
| expense account ID | Text |
| expense account name | Text |
| asset account ID | Text |
| asset account name | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Bills#
Accounts-payable bill headers with vendor, due date, balance, and terms.
| Field | Type |
|---|---|
| bill ID | Text |
| doc number | Text |
| vendor ID | Text |
| vendor name | Text |
| date | Date |
| txn date | Date |
| due date | Date |
| total amount | Number |
| balance | Number |
| status | Text |
| currency | Text |
| ap account ID | Text |
| ap account name | Text |
| sales term ID | Text |
| sales term name | Text |
| private note | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Bill lines#
Versioned bill item/account lines at bill × line index grain.
| Field | Type |
|---|---|
| bill ID | Text |
| line index | Integer |
| line ID | Text |
| detail type | Text |
| description | Text |
| amount | Number |
| quantity | Number |
| unit price | Number |
| item ID | Text |
| item name | Text |
| account ID | Text |
| account name | Text |
| customer ID | Text |
| customer name | Text |
| class ID | Text |
| class name | Text |
| department ID | Text |
| department name | Text |
| billable status | Text |
| tax code | Text |
| bill updated at | Text |
| realm ID | Text |
Bill payments#
Bill payment headers.
| Field | Type |
|---|---|
| bill payment ID | Text |
| doc number | Text |
| vendor ID | Text |
| vendor name | Text |
| date | Date |
| txn date | Date |
| total amount | Number |
| payment type | Text |
| payment account ID | Text |
| payment account name | Text |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Bill payment links#
Bill-payment allocations at payment × bill link grain.
| Field | Type |
|---|---|
| bill payment ID | Text |
| line index | Integer |
| linked txn index | Integer |
| linked txn ID | Text |
| linked txn type | Text |
| amount | Number |
| bill payment updated at | Text |
| realm ID | Text |
Deletions#
Change Data Capture tombstones retained separately from last-known entity rows.
| Field | Type |
|---|---|
| entity type | Text |
| entity ID | Text |
| deleted at | Text |
| realm ID | Text |
Company info#
| Field | Type |
|---|---|
| realm ID | Text |
| company name | Text |
| legal name | Text |
| country | Text |
| fiscal year start month | Text |
| home currency | Text |
Preferences#
Company preferences — class/department tracking + multicurrency flags.
| Field | Type |
|---|---|
| realm ID | Text |
| class tracking | Text |
| department tracking | Text |
| department terminology | Text |
| multicurrency enabled | Text |
Accounts#
Chart of accounts — the P&L account-type classifier + hierarchy.
| Field | Type |
|---|---|
| account ID | Text |
| account number | Text |
| name | Text |
| fully qualified name | Text |
| account type | Text |
| account sub type | Text |
| classification | Text |
| parent account ID | Text |
| is active | True/false |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Classes#
QBO Classes — a candidate business-entity axis.
| Field | Type |
|---|---|
| class ID | Text |
| name | Text |
| fully qualified name | Text |
| parent class ID | Text |
| is active | True/false |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Departments#
QBO Departments/Locations — a candidate business-entity axis.
| Field | Type |
|---|---|
| department ID | Text |
| name | Text |
| fully qualified name | Text |
| parent department ID | Text |
| is active | True/false |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Journal entries#
Journal entry headers (adjustment lineage; not summed into P&L).
| Field | Type |
|---|---|
| journal entry ID | Text |
| doc number | Text |
| date | Date |
| txn date | Date |
| is adjustment | True/false |
| private note | Text |
| total amount | Number |
| currency | Text |
| created at | Text |
| updated at | Text |
| realm ID | Text |
Journal entry lines#
Journal entry lines.
| Field | Type |
|---|---|
| journal entry ID | Text |
| line index | Integer |
| line ID | Text |
| description | Text |
| amount | Number |
| posting type | Text |
| account ID | Text |
| account name | Text |
| class ID | Text |
| class name | Text |
| department ID | Text |
| department name | Text |
| entity type | Text |
| entity name | Text |
| journal entry updated at | Text |
| realm ID | Text |
Profit and loss#
QBO ProfitAndLoss summary (per account × month/class column).
| Field | Type |
|---|---|
| report basis | Text |
| entity axis | Text |
| date | Date |
| period start | Date |
| period end | Date |
| column key | Text |
| column title | Text |
| section path | Text |
| row type | Text |
| ledger account ID | Text |
| ledger account name | Text |
| amount | Number |
| currency | Text |
| account ID | Text |
| realm ID | Text |
Profit and loss detail#
QBO ProfitAndLossDetail.
| Field | Type |
|---|---|
| posting line ID | Text |
| report basis | Text |
| date | Date |
| txn date | Date |
| transaction type | Text |
| doc number | Text |
| counterparty name | Text |
| class name | Text |
| department name | Text |
| memo | Text |
| split account | Text |
| ledger account ID | Text |
| ledger account name | Text |
| section path | Text |
| amount | Number |
| currency | Text |
| account ID | Text |
| realm ID | Text |