QuickBooks integration summary

Stitch’s QuickBooks integration replicates data from a QuickBooks Online instance using the QuickBooks Online API. Refer to the Schema section for a list of objects available for replication.

Note: Currently, replicating data from QuickBooks Desktop apps isn’t supported.

QuickBooks feature snapshot

A high-level look at Stitch's QuickBooks (v21-12-2015) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Deprecated on September 3, 2020

 Supported by

[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport)
Stitch plan

Standard

 API availability

Not available
Singer GitHub repository

Not applicable
REPLICATION SETTINGS
Anchor Scheduling

Supported

 Advanced Scheduling

Unsupported
Table-level reset

Unsupported

 Configurable Replication Methods

Unsupported
DATA SELECTION
Table selection

Unsupported

 Column selection

Unsupported
Select all

Unsupported
TRANSPARENCY
Extraction Logs

Unsupported

 Loading Reports

Supported

Connecting QuickBooks

QuickBooks setup requirements

To set up QuickBooks in Stitch, you need:

  • An online QuickBooks instance. Support for replicating data from desktop QuickBooks instances isn’t currently supported.

Step 1: Add QuickBooks as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the QuickBooks icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch QuickBooks” would create a schema called stitch_quickbooks in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your QuickBooks integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond QuickBooks’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

QuickBooks integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access QuickBooks

Lastly, you’ll be directed to QuickBooks’ website to complete the setup.

  1. If you’re not already signed into your QuickBooks account, enter your credentials and click Login.
  2. A screen asking for authorization to QuickBooks will display. Note that Stitch will only ever read your data.
  3. Click Authorize.
  4. After the authorization process successfully completes, you’ll be redirected back to Stitch.
  5. Click All Done.

Initial and historical replication jobs

After you finish setting up QuickBooks, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

QuickBooks table reference


quickbooks_accounts

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_accounts table contains info about the various account types in your QuickBooks account. An account can be one of five types: asset, liability, revenue (income), expenses, or equity.

Table Info & Attributes

Deleted Accounts

To account for deleted accounts, look for false values in the active column. False indicates that an account has been archived/soft-deleted but its attributes and references are intact.

quickbooks_accounts Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Account ID (id)

  • accountssubtype

  • accounttype

  • active

  • classification

  • currencyref__name

  • currencyref__value

  • currentbalance

  • currentbalancewithsubaccounts

  • domain

  • fullyqualifiedname

  • subaccount

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_bills

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_bills table contains info about AP transactions, or a request-for-payment from a third-party.

Table Info & Attributes

quickbooks_bills & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_bills Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Bill ID (id)

  • salestermref

  • duedate

  • balance

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

  • txndate

  • currencyref__value

  • currencyref__name

  • linkedtxn*

  • line*

  • vendorref__value

  • vendorref__name

  • apaccountref__value

  • apaccountref__name

  • totalamt

quickbooks_billpayments

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_billpayments table contains info about the final transaction in the payment of bills received from a vendor.

Table Info & Attributes

quickbooks_billpayments & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_billpayments Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Bill Payment ID (id)

  • billpayment__vendorref__value

  • billpayment__vendorrref__name

  • paytime

  • checkpayment__bankaccountref__value

  • checkpayment__bankaccountref__name

  • printstatus

  • totalamt

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

  • txndate

  • privatenote

  • line*

quickbooks_budgets

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_budgets table contains info about company budgets.

Table Info & Attributes

quickbooks_budgets & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Budget & Budget Details

If the above is true and you see a quickbooks_budgets__budgetdetail subtable in your data warehouse, you can tie the budget details to the top level table using a composite key. This composite key is made up of the budget ID and the row ID: _sdc_source_key_id (budget ID) : _sdc_level_0_id (row ID)

quickbooks_budgets Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Budget ID (id)

  • name

  • startdate

  • enddate

  • budgettype

  • budgetentrytype

  • active

  • budgetdetail*: This array contains budgetdate, amount, accountref__value, accountref__name.

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_classes

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_classes table contains info about the classes that are applied to the detail lines of transactions. Classes allow you to track segments that aren't tied to a client or project.

Table Info & Attributes

quickbooks_classes Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Class ID (id)

  • name

  • subclass

  • fullyqualifiedname

  • active

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_creditmemos

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_creditmemos table contains info about transactions that are refunds or credits of both full and partial payments.

Table Info & Attributes

quickbooks_creditmemos & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_creditmemos Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Credit Memo ID (id)

  • remainingcredit

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

  • docnumber

  • txndate

  • line*

  • txntaxdetail__totaltax

  • customerref__value

  • customerref__name

  • customermemo__value

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__line3

  • billaddr__line4

  • shipaddr__id

  • shipaddr__line1

  • shipaddr__line2

  • shipaddr__line3

  • shipaddr__line4

  • totalamt

  • applytaxafterdiscount

  • printstatus

  • emailstatus

  • billemail__address

  • balance

quickbooks_customers

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_customers table contains info about the people that consume the products or services offered by your business.

Table Info & Attributes

quickbooks_customers Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Customer ID (id)

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__line3

  • billaddr__line4

  • taxable

  • job

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

  • billwithparent

  • balance

  • balancewithjobs

  • preferreddeliverymethod

  • givenname

  • familyname

  • fullyqualifiedname

  • companyname

  • displayname

  • printoncheckname

  • active

  • primaryphone__freeformnumber

  • primaryemailaddr__address

quickbooks_departments

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_departments table contains info about the departments - stores, sales regions, countries, and so on - in your company.

Table Info & Attributes

quickbooks_departments Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Department ID (id)

  • name

  • subdepartment

  • fullyqualifiedname

  • active

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_deposits

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_deposits table contains info about direct deposits and customer payments moved into the Asset Account after being held in the Undeposited Funds account.

Table Info & Attributes

quickbooks_deposits & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_deposits Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Deposit ID (id)

  • deposittoaccountref__value

  • deposittoaccountref__name

  • totalamt

  • txndate

  • line*

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_employees

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_employees table contains info about the people who work for your company.

Table Info & Attributes

quickbooks_employees Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Employee ID (id)

  • ssn: Note that when this attribute is retrieved via the QuickBooks API, it will always appear as masked.

  • primaryaddr__id

  • primaryaddr__line1

  • primaryaddr__city

  • primaryaddr__countrysubdivisioncode

  • primaryaddr__postalcode

  • billabletime

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

  • primaryphone__freeformnumber

  • primaryemailaddr__address

  • givenname

  • familyname

  • displayname

  • printoncheckname

quickbooks_estimates

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_estimates table contains info about proposals given to customers about pricing for a good or service.

Table Info & Attributes

quickbooks_estimates & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_estimates Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Estimate ID (id)

  • docnumber

  • txndate

  • txnstatus

  • line*

  • txntaxdetail__totaltax

  • customerref__value

  • customerref__name

  • customermemo__value

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__line3

  • billaddr__line4

  • shipaddr__id

  • shipaddr__line1

  • shipaddr__line2

  • shipaddr__line3

  • shipaddr__line4

  • totalamt

  • applytaxafterdiscount

  • printstatus

  • emailstatus

  • billemail__address

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_invoices

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_invoices table contains info about invoices, or sales forms that customers pay later.

Table Info & Attributes

quickbooks_invoices & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_invoices Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Invoice ID (id)

  • docnumber

  • txndate

  • customfield*

  • linkedtxn*

  • line*

  • txntaxdetail__txntaxcoderef__value

  • txntaxdetail__totaltax

  • txntaxdetail__taxline*

  • customerref__value

  • customerref__name

  • customermemo__value

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__line3

  • billaddr__line4

  • shipaddr__id

  • shipaddr__line1

  • shipaddr__line2

  • shipaddr__line3

  • shipaddr__line4

  • salestermref__value

  • duedate

  • totalamt

  • applytaxafterdiscount

  • printstatus

  • emailstatus

  • billemail__address

  • balance

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_items

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_items table contains info about the goods and/or services your company sells.

Table Info & Attributes

quickbooks_items Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Item ID (id)

  • name

  • description

  • active

  • fullyqualifiedname

  • taxable

  • unitprice

  • type

  • incomeaccountref__value

  • incomeaccountref__name

  • purchasedesc

  • purchasecost

  • expenseaccountref__value

  • expenseaccountref__name

  • assetaccountref__value

  • assetaccountref__name

  • trackqtyonhand

  • qtyonhand

  • invstartdate

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_journalentries

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_journalentries table contains info about Accounts Receivable and Accounts Payable accounts.

Table Info & Attributes

quickbooks_journalentries & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Journal Entries & Line Item Details

If the above is true and you see a quickbooks_journalentries__line subtable in your data warehouse, you can tie the line item details to the top level table using a composite key. This composite key is made up of the journal entry ID and the row ID: _sdc_source_key_id (journal entry ID) : _sdc_level_0_id (row ID).

quickbooks_journalentries Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Journal Entry ID (id)

  • adjustment

  • txndate

  • txntaxdetail

  • line*

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_paymentmethods

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_paymentmethods table contains info about the methods used to pay for goods and services.

Table Info & Attributes

quickbooks_paymentmethods Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Payment Method ID (id)

  • name

  • active

  • type

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_payments

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_payments table contains info about the payments received for goods and services.

Table Info & Attributes

quickbooks_payments & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_payments Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Payment ID (id)

  • deposittoaccountref__value

  • totalamt

  • unappliedamt

  • processpayment

  • txndate

  • line*

  • customerref__value

  • customerref__name

  • customermemo__value

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_purchaseorders

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_purchaseorders table contains info about purchase orders, or the requests for goods that are sent to vendors.

Table Info & Attributes

quickbooks_purchaseorders & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_purchaseorders Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Purchase Order ID (id)

  • docnumber

  • txndate

  • line*

  • currencyref__value

  • currencyref__name

  • vendoraddr__id

  • vendoraddr__line1

  • vendoraddr__line2

  • vendoraddr__line3

  • vendoraddr__line4

  • shipaddr__id

  • shipaddr__line1

  • shipaddr__line2

  • shipaddr__line3

  • shipaddr__line4

  • vendorref__value

  • vendorref__name

  • apaccountref__value

  • apaccountref__name

  • totalamt

  • postatus

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_purchases

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_purchases table contains info about your company's expenses, such as a purchase made from a vendor. There are three types of purchases: cash, check, and credit card.

Table Info & Attributes

quickbooks_purchases & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_purchases Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Purchase ID (id)

  • paymenttype

  • purchaseex*

  • txndate

  • line*

  • accountref__value

  • accountref__name

  • totalamt

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_refundreceipts

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_refundreceipts table contains info about refunds given to customers.

Table Info & Attributes

quickbooks_refundreceipts & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_refundreceipts Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Refund Recept ID (id)

  • docname

  • txndate

  • txntaxdetail__totaltax

  • customerref__value

  • customerref__name

  • customermemo__value

  • line*

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__line3

  • billaddr__line4

  • billaddr__lat

  • billaddr__long

  • shipaddr__id

  • shipaddr__line1

  • shipaddr__line2

  • shipaddr__line3

  • shipaddr__line4

  • shipaddr__lat

  • shipaddr__long

  • totalamt

  • applytaxafterdiscount

  • printstatus

  • billemail__address

  • balance

  • paymentmethodref__value

  • paymentmethodref__name

  • deposittoaccountref__value

  • deposittoaccountref__name

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_salesreceipts

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_salesreceipts table contains info about the sales receipts given to customers.

Table Info & Attributes

quickbooks_salesreceipts & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Also: in addition to the attributes listed below, our QuickBooks integration will replicate any custom fields.

quickbooks_salesreceipts Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Sales Receipt ID (id)

  • docname

  • txndate

  • txntaxdetail__totaltax

  • customerref__value

  • customerref__name

  • customermemo__value

  • line*

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__lat

  • billaddr__long

  • totalamt

  • applytaxafterdiscount

  • printstatus

  • emailstatus

  • balance

  • paymentrefnum

  • deposittoaccountref__value

  • deposittoaccountref__name

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_taxagencies

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_taxagencies table contains info about tax agencies, which are associated withy a tax rate. This object identifies the entity that collects those taxes.

Table Info & Attributes

quickbooks_taxagencies Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Tax Agency ID (id)

  • taxtrackedonpremises

  • taxtrackedonsales

  • displayname

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_taxcodes

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_taxcodes table contains info about tax codes.

Table Info & Attributes

quickbooks_taxcodes & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_taxcodes Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Tax Code ID (id)

  • name

  • description

  • active

  • taxable

  • taxgroup

  • salestaxratelist*

  • purchasetaxratelist*

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_taxrates

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_taxrates table contains info about tax rates, which are used to calculate tax liability.

Table Info & Attributes

quickbooks_taxrates Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Tax Rate ID (id)

  • name

  • description

  • active

  • ratevalue

  • agencyref

  • specialtaxtype

  • displaytype

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_terms

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_terms table contains info about the terms applied to sales.

Table Info & Attributes

quickbooks_terms Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Term ID (id)

  • name

  • active

  • type

  • discountpercent

  • duedays

  • discountdays

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_timeactivites

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_timeactivites table contains info about employee time records.

Table Info & Attributes

quickbooks_timeactivites Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Time Activity ID (id)

  • txndate

  • nameof

  • billablestatus

  • taxable

  • hourlyrate

  • hours

  • minutes

  • description

  • customerref__value

  • customerref__name

  • itemref__value

  • itemref__name

  • employeeref__value

  • employeeref__name

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_tranfsers

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_tranfsers table contains info about transfers, or transactions where funds are moved between two accounts from the company's chart of accounts.

Table Info & Attributes

quickbooks_tranfsers Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Transfer ID (id)

  • amount

  • txndate

  • fromaccountref__value

  • fromaccountref__name

  • toaccountref__value

  • toaccountref__name

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_vendorcredits

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: Yes

The quickbooks_vendorcredits table contains info about AP transactions that are refunds or credits given to vendors.

Table Info & Attributes

quickbooks_vendorcredits & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

quickbooks_vendorcredits Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Vendor Credit ID (id)

  • txndate

  • line*

  • totalamt

  • vendorref__value

  • vendorref__name

  • apaccountref__value

  • apaccountref__name

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

quickbooks_vendors

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The quickbooks_vendors table contains info about the vendors you purchase goods and/or services from.

Table Info & Attributes

quickbooks_vendors Attributes

While we try to include everything QuickBooks has here, this may not be a full list of attributes. Refer to QuickBooks's documentation for a full list and description of each attribute.

  • Vendor ID (id)

  • balance

  • acctnum

  • vendor1099

  • givenname

  • famiilyname

  • displayname

  • printoncheckname

  • active

  • primaryphone__freeformnumber

  • primaryemailaddr__address

  • webaddr__uri

  • billaddr__id

  • billaddr__line1

  • billaddr__line2

  • billaddr__lat

  • billaddr__long

  • domain

  • sparse

  • synctoken

  • metadata__createtime

  • metadata__lastupdatedtime

Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.