QuickBooks (v21-12-2015)
Last updated: 9/15/2026This integration is certified by Stitch. For support, contact Support.
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
Indicates if the integration is supported by Stitch or the Singer community. |
|
|
Stitch plan
The type of Stitch plan required to use the integration. |
Standard |
API availability
Indicates if the integration is available as a source in Stitch Connect. |
This version of the integration isn't available via the API. |
| Singer GitHub repository |
Not applicable |
||
| REPLICATION SETTINGS | |||
|
Anchor Scheduling
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. |
This feature is supported for this version of the integration. |
Advanced Scheduling
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. |
Advanced Scheduling is not supported for this integration. |
|
Table-level reset
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. |
Table-level resets are not supported for this integration. Resets are only supported at the integration level. |
Configurable Replication Methods
Indicates if Replication Methods can be defined by you for tables in the integration. |
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate. |
| DATA SELECTION | |||
|
Table selection
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. |
Table selection is not supported for this integration. All available table and fields will be automatically selected for replication. |
Column selection
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. |
Column selection is not supported for this integration. All available columns in tables set to replicate will be selected. |
|
Select all
Indicates if the integration supports selecting all available tables and columns. |
As this integration doesn't support table or column selection, all available tables and columns are automatically replicated. |
||
| TRANSPARENCY | |||
|
Extraction Logs
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. |
This feature is not supported for this version of the integration. |
Loading Reports
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. |
This feature is supported for this version of the integration. |
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
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the QuickBooks icon.
-
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_quickbooksin 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.
- If you’re not already signed into your QuickBooks account, enter your credentials and click Login.
- A screen asking for authorization to QuickBooks will display. Note that Stitch will only ever read your data.
- Click Authorize.
- After the authorization process successfully completes, you’ll be redirected back to Stitch.
- 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.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
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
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 21-12-2015 of this integration.
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
quickbooks_billpayments table contains info about the final transaction in the payment of bills received from a vendor.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
quickbooks_budgets table contains info about company budgets.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 containsbudgetdate, 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
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.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
quickbooks_creditmemos table contains info about transactions that are refunds or credits of both full and partial payments.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
quickbooks_customers table contains info about the people that consume the products or services offered by your business.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
quickbooks_departments table contains info about the departments - stores, sales regions, countries, and so on - in your company.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
quickbooks_deposits table contains info about direct deposits and customer payments moved into the Asset Account after being held in the Undeposited Funds account.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
quickbooks_employees table contains info about the people who work for your company.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
quickbooks_estimates table contains info about proposals given to customers about pricing for a good or service.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
quickbooks_invoices table contains info about invoices, or sales forms that customers pay later.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
quickbooks_items table contains info about the goods and/or services your company sells.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
quickbooks_journalentries table contains info about Accounts Receivable and Accounts Payable accounts.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
quickbooks_paymentmethods table contains info about the methods used to pay for goods and services.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
quickbooks_payments table contains info about the payments received for goods and services.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
quickbooks_purchaseorders table contains info about purchase orders, or the requests for goods that are sent to vendors.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
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.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
quickbooks_refundreceipts table contains info about refunds given to customers.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
quickbooks_salesreceipts table contains info about the sales receipts given to customers.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
quickbooks_taxagencies table contains info about tax agencies, which are associated withy a tax rate. This object identifies the entity that collects those taxes.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
quickbooks_taxcodes table contains info about tax codes.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
quickbooks_taxrates table contains info about tax rates, which are used to calculate tax liability.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
quickbooks_terms table contains info about the terms applied to sales.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
quickbooks_timeactivites table contains info about employee time records.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
quickbooks_tranfsers table contains info about transfers, or transactions where funds are moved between two accounts from the company's chart of accounts.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
quickbooks_vendorcredits table contains info about AP transactions that are refunds or credits given to vendors.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
quickbooks_vendors table contains info about the vendors you purchase goods and/or services from.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
quickbooks_accounts
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
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.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
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!