Release Status Released Availability Premium
Status Page QuickBooks Status Page Default Historical Sync 1/1/2010
Whitelist Tables/Columns Unsupported/Unsupported Default Replication Frequency 30 minutes
Full Table Endpoints 0 Incremental Endpoints 28
Destination Incompatibilities None

Connecting QuickBooks

Connecting your QuickBooks data to Stitch is a four-step process:

  1. Add QuickBooks as a Stitch data source
  2. Define the Historical Sync
  3. Define the Replication Frequency
  4. Authorize Stitch to access QuickBooks

Add QuickBooks as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.

  2. Click the QuickBooks icon.

  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch QuickBooks” would create a schema called stitch_quickbooks in the data warehouse. This schema is where all the tables for this integration will be stored.

Defining the Historical Sync

The Sync Historical Data setting will define 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 sync data beyond QuickBooks’s default setting of 1/1/2010. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Define the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your QuickBooks integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Before setting the Replication Frequency, note that:

  • The more often QuickBooks is set to replicate, the higher the number of replicated rows.

  • The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.

  • If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.

To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.

After selecting a Replication Frequency, click Save Integration.

Authorizing 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.

QuickBooks’s Intial Sync

After you finish setting up QuickBooks, you might see its Sync Status 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 sync for the integration. This may take some time to complete.

QuickBooks Schema

Stitch's QuickBooks integration includes these tables:


quickbooks_accounts

Replication Method: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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, please reach out to us.

Tags: saas integrations