# QuickBooks datasets and fields

> The 22 datasets Maven lands from QuickBooks, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/quickbooks

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](https://mavendata.ai/integrations/quickbooks).

## 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 |
| email | 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 |
| email | 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 |
