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.

FieldType
invoice IDText
doc numberText
customer IDText
customer nameText
email statusText
print statusText
dateDate
txn dateDate
due dateDate
total amountNumber
balanceNumber
statusText
currencyText
created atText
updated atText
realm IDText

Payments#

Payments received.

FieldType
payment IDText
customer IDText
customer nameText
dateDate
txn dateDate
total amountNumber
payment methodText
currencyText
created atText
updated atText
realm IDText
FieldType
payment IDText
line indexInteger
linked txn indexInteger
linked txn IDText
linked txn typeText
amountNumber
payment updated atText
realm IDText

Expenses#

Purchases and expenses.

FieldType
expense IDText
vendor IDText
vendor nameText
dateDate
txn dateDate
total amountNumber
payment typeText
account nameText
currencyText
created atText
updated atText
realm IDText

Invoice lines#

Versioned sales-item lines at invoice × line index grain.

FieldType
invoice IDText
line indexInteger
line IDText
detail typeText
descriptionText
amountNumber
quantityNumber
unit priceNumber
item IDText
item nameText
service dateDate
class IDText
class nameText
tax codeText
invoice updated atText
realm IDText

Customers#

Active and inactive customer hierarchy, lifecycle, balance, and geography.

FieldType
customer IDText
display nameText
company nameText
given nameText
family nameText
emailText
phoneText
parent customer IDText
is sub customerTrue/false
is activeTrue/false
balanceNumber
open balance with jobsNumber
currencyText
billing cityText
billing stateText
billing countryText
billing postal codeText
shipping cityText
shipping stateText
shipping countryText
shipping postal codeText
created atText
updated atText
realm IDText

Vendors#

Active and inactive vendor identity, terms, balance, and geography.

FieldType
vendor IDText
display nameText
company nameText
given nameText
family nameText
emailText
phoneText
term IDText
term nameText
is 1099 vendorTrue/false
is activeTrue/false
balanceNumber
currencyText
billing cityText
billing stateText
billing countryText
billing postal codeText
created atText
updated atText
realm IDText

Items#

Active and inactive product/service catalog with hierarchy and inventory economics.

FieldType
item IDText
nameText
descriptionText
purchase descriptionText
skuText
item typeText
parent item IDText
is activeTrue/false
is taxableTrue/false
unit priceNumber
purchase costNumber
quantity on handNumber
inventory start dateDate
income account IDText
income account nameText
expense account IDText
expense account nameText
asset account IDText
asset account nameText
created atText
updated atText
realm IDText

Bills#

Accounts-payable bill headers with vendor, due date, balance, and terms.

FieldType
bill IDText
doc numberText
vendor IDText
vendor nameText
dateDate
txn dateDate
due dateDate
total amountNumber
balanceNumber
statusText
currencyText
ap account IDText
ap account nameText
sales term IDText
sales term nameText
private noteText
created atText
updated atText
realm IDText

Bill lines#

Versioned bill item/account lines at bill × line index grain.

FieldType
bill IDText
line indexInteger
line IDText
detail typeText
descriptionText
amountNumber
quantityNumber
unit priceNumber
item IDText
item nameText
account IDText
account nameText
customer IDText
customer nameText
class IDText
class nameText
department IDText
department nameText
billable statusText
tax codeText
bill updated atText
realm IDText

Bill payments#

Bill payment headers.

FieldType
bill payment IDText
doc numberText
vendor IDText
vendor nameText
dateDate
txn dateDate
total amountNumber
payment typeText
payment account IDText
payment account nameText
currencyText
created atText
updated atText
realm IDText

Bill-payment allocations at payment × bill link grain.

FieldType
bill payment IDText
line indexInteger
linked txn indexInteger
linked txn IDText
linked txn typeText
amountNumber
bill payment updated atText
realm IDText

Deletions#

Change Data Capture tombstones retained separately from last-known entity rows.

FieldType
entity typeText
entity IDText
deleted atText
realm IDText

Company info#

FieldType
realm IDText
company nameText
legal nameText
countryText
fiscal year start monthText
home currencyText

Preferences#

Company preferences — class/department tracking + multicurrency flags.

FieldType
realm IDText
class trackingText
department trackingText
department terminologyText
multicurrency enabledText

Accounts#

Chart of accounts — the P&L account-type classifier + hierarchy.

FieldType
account IDText
account numberText
nameText
fully qualified nameText
account typeText
account sub typeText
classificationText
parent account IDText
is activeTrue/false
currencyText
created atText
updated atText
realm IDText

Classes#

QBO Classes — a candidate business-entity axis.

FieldType
class IDText
nameText
fully qualified nameText
parent class IDText
is activeTrue/false
created atText
updated atText
realm IDText

Departments#

QBO Departments/Locations — a candidate business-entity axis.

FieldType
department IDText
nameText
fully qualified nameText
parent department IDText
is activeTrue/false
created atText
updated atText
realm IDText

Journal entries#

Journal entry headers (adjustment lineage; not summed into P&L).

FieldType
journal entry IDText
doc numberText
dateDate
txn dateDate
is adjustmentTrue/false
private noteText
total amountNumber
currencyText
created atText
updated atText
realm IDText

Journal entry lines#

Journal entry lines.

FieldType
journal entry IDText
line indexInteger
line IDText
descriptionText
amountNumber
posting typeText
account IDText
account nameText
class IDText
class nameText
department IDText
department nameText
entity typeText
entity nameText
journal entry updated atText
realm IDText

Profit and loss#

QBO ProfitAndLoss summary (per account × month/class column).

FieldType
report basisText
entity axisText
dateDate
period startDate
period endDate
column keyText
column titleText
section pathText
row typeText
ledger account IDText
ledger account nameText
amountNumber
currencyText
account IDText
realm IDText

Profit and loss detail#

QBO ProfitAndLossDetail.

FieldType
posting line IDText
report basisText
dateDate
txn dateDate
transaction typeText
doc numberText
counterparty nameText
class nameText
department nameText
memoText
split accountText
ledger account IDText
ledger account nameText
section pathText
amountNumber
currencyText
account IDText
realm IDText