QuickBooks
QuickBooks
SourceUse Dataddo's QuickBooks connector to explore any data available via the official API of QuickBooks. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.
DATA FIELDS
Explore Data You Can Extract from QuickBooks
Data Category
- All Attributes (651)
- AP Aging Detail Report (13)
- AP Aging Detail Report V2 (13)
- AR Aging Detail Report (13)
- AR Aging Detail Report V2 (13)
- Accounts (19)
- Balance Sheets (10)
- Balance Sheets V2 (7)
- BillPayments (18)
- Bills (31)
- Budgets (16)
- Cash Flow (10)
- Cash Flow V2 (9)
- Classes (10)
- Credit Memos (21)
- Customers (41)
- Departments (10)
- Deposits (13)
- Employee (29)
- General Ledger Report (20)
- General Ledger Report V2 (16)
- Invoices (36)
- Invoices (19)
- Items (22)
- Journal Entries (23)
- Payments (14)
- Profit and Loss (6)
- Profit and Loss Detail (19)
- Profit and Loss V2 (7)
- Purchase Orders (42)
- Purchases (26)
- Terms (12)
- Time Activity (24)
- Transaction Lines Report (14)
- Transaction Lines Report V2 (15)
- Transfers (15)
- Vendors (25)
Need fields you don't see?
Let us know and we'll add them to the connector. Just send a request here..
Available Attributes (651)
| Attribute |
|---|
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
vend_name sensitive Vendor |
due_date Due date |
past_due Past due |
amount Amount |
open_balance Open balance |
category Category |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
vend_name sensitive Vendor |
due_date Due date |
past_due Past due |
amount Amount |
open_balance Open balance |
section Section |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
cust_name sensitive Customer name |
location Location |
due_date Due date |
amount Amount |
open_balance Open balance |
category Category |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
cust_name sensitive Customer name |
dept_name Location |
due_date Due date |
subt_amount Amount |
subt_open_balance Open balance |
section Section |
AccountSubType Account Sub Type |
AccountType Account Type |
Classification Classification |
AcctNum Account Number |
Active Active |
CurrencyName Currency Name |
Currency Currency |
CurrentBalance Current Balance |
CurrentBalanceWithSubAccounts Current Balance With Sub Accounts |
FullyQualifiedName Fully Qualified Name |
id ID |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
Name Name |
Parent Parent |
SubAccount Sub Account |
SyncToken Sync Token |
domain Domain |
sparse Sparse |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
account Account |
total total |
category Category |
subcategory Sub-category |
subsubcategory Sub-sub-category |
subsubsubcategory Sub-sub-sub-category |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
account Account |
total Total |
section Section |
BankAccountName Bank Account Name |
BankAccount Bank Account |
PrintStatus Print Status |
CurrencyName Currency Name |
Currency Currency |
Department Department |
id ID |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
PayType Pay Type |
PrivateNote Private Note |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
VendorName sensitive Vendor Name |
Vendor Vendor |
domain Domain |
sparse Sparse |
APAccountName AP Account Name |
APAccount AP Account |
Balance Balance |
CurrencyName Currency Name |
Currency Currency |
DepartmentName Department Name |
Department Department |
DocNumber Doc Number |
DueDate Due Date |
id ID |
LinkedTxnId Linked Transaction ID |
LinkedTxnType Linked Transaction Type |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
PrivateNote Private Note |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
VendorName sensitive Vendor Name |
Vendor Vendor |
domain Domain |
sparse Sparse |
Line_Id Line ID |
Line_LineNum Line Num |
Line_Description Line Description |
Line_Amount Line Amount |
Line_DetailType Line Detail Type |
Line_BillableStatus Line Billable Status |
Line_AccountRef_value Line AccountRef Value |
Line_TaxCodeRef_value Line Tax Code Ref |
Line_AccountRef_name Line Account Ref Name |
Active Active |
BudgetDetail_AccountRef_value Budget Detail - Account Reference - Value |
sparse Sparse |
BudgetDetail_BudgetDate Budget Detail - Budget Date |
CreateTime Create Time |
BudgetType Budget Type |
Id ID |
EndDate End Date |
BudgetEntryType Budget Entry Type |
SyncToken Sync Token |
BudgetDetail_Amount Budget Detail - Amount |
BudgetDetail_AccountRef_name Budget Detail - Account Reference - Name |
domain Domain |
LastUpdatedTime Last Updated Time |
StartDate Start Date |
Name Name |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
dateMacro Date Macro |
time Time |
account Account |
total total |
category Category |
subcategory Subcategory |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
date_macro Date Macro |
time Time |
account Account |
total total |
section Section |
Active Active |
FullyQualifiedName Fully Qualified Name |
Name Name |
SubClass Sub Class |
SyncToken Sync Token |
id ID |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
id Credit Memo ID |
txn_date Transaction Date |
doc_number Document Number |
customer_ref_name Customer Name |
customer_ref_value Customer ID |
bill_addr_id Billing Address ID |
total_amt Total Amount |
remaining_credit Remaining Credit |
sync_token Sync Token |
sparse Sparse |
line_id Line ID |
line_line_num Line Number |
line_amount Line Amount |
line_description Line Description |
line_detail_type Line Detail Type |
line_item_ref_name Item Name |
line_item_ref_value Item ID |
line_item_account_ref_name Item Account Name |
line_item_account_ref_value Item Account ID |
line_qty Line Quantity |
line_unit_price Line Unit Price |
Active Active |
Balance Balance |
BalanceWithJobs Balance With Jobs |
BillAddrCity Bill Address - City |
BillAddrCountrySubDivisionCode Bill Address - Country Sub Division Code |
BillAddrId Billing Address - ID |
BillAddrLine1 sensitive Billing Address - Line 1 |
BillAddrLine2 sensitive Billing Address - Line 2 |
BillAddrPostalCode sensitive Billing Address - Postal Code |
BillWithParent Billing With Parent |
CompanyName Company Name |
CurrencyName Currency Name |
Currency Currency |
DisplayName sensitive Display Name |
FullyQualifiedName sensitive Fully Qualified Name |
id ID |
Job Job |
Level Level |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
ParentRefValue Parent Ref Value |
ParentRefName Parent Ref Name |
Notes Notes |
PreferredDeliveryMethod Preferred Delivery Method |
FamilyName sensitive Family Name |
DefaultTaxCode Default Tax Code |
ResaleNum Resale Number |
PrimaryEmailAddr sensitive Primary Email Address |
GivenName sensitive Given Name |
PrimaryPhone sensitive Primary Phone |
MiddleName sensitive Middle Name |
Taxable Taxable |
SyncToken Sync Token |
ShipAddrCity Ship Address - City |
ShipAddrLine1 sensitive Shipping Address - Line 1 |
ShipAddrPostalCode sensitive Shipping Address - Postal Code |
ShipAddrCountrySubDivisionCode Shipping Address - Country Sub Division Code |
ShipAddrId Shipping Address - ID |
PrintOnCheckName sensitive Print On Check Name |
domain Domain |
sparse Sparse |
Active Active |
FullyQualifiedName Fully Qualified Name |
Name Name |
SubDepartment Sub Department |
SyncToken Sync Token |
id ID |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
id ID |
DepositToAccountName Deposit To Account Name |
DepositToAccountValue Deposit To Account Value |
CurrencyName Currency Name |
Currency Currency |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
PrivateNote Private Note |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
domain Domain |
sparse Sparse |
id ID |
Active Active |
BillRate Bill Rate |
BillableTime Billable Time |
DisplayName sensitive Display Name |
FamilyName sensitive Family Name |
GivenName sensitive Given Name |
Gender sensitive Gender |
HiredDate Hired Date |
MiddleName sensitive Middle Name |
MobileNumber sensitive Mobile Number |
PrimaryAddrCity Primary Address - City |
PrimaryAddrCountrySubDivisionCode Primary Address - Country Sub Division Code |
PrimaryAddrId Primary Address - ID |
PrimaryAddrLine1 sensitive Primary Address - Line 1 |
PrimaryAddrLine2 sensitive Primary Address - Line 2 |
PrimaryAddrPostalCode sensitive Primary Address - Postal Code |
PrimaryAddrCountry Primary Address - Country |
PrimaryEmailAddr sensitive Primary Email Address |
PrimaryPhone sensitive Primary Phone |
PrintOnCheckName sensitive Print On Check Name |
SSN sensitive SSN |
Title Title |
ReleasedDate Released Date |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
SyncToken Sync Token |
domain Domain |
sparse Sparse |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
name Name |
memo Memo |
account_name Account name |
split Split |
amount Amount |
balance Balance |
category Category |
subcategory Subcategory |
subsubcategory Subsubcategory |
subsubsubcategory Subsubsubcategory |
subsubsubsubcategory Subsubsubsubcategory |
class_name Class Name |
account_id Account ID |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
name Name |
memo Memo |
account_name Account name |
split_acc Split |
subt_nat_amount Amount |
rbal_nat_amount Balance |
section Section |
klass_name Class Name |
account_id Account ID |
id ID |
AllowOnlineACHPayment Allow Online ACH Payment |
AllowOnlineCreditCardPayment Allow Online Credit Card Payment |
ApplyTaxAfterDiscount Apply Tax After Discount |
CustomerMemo Customer Memo |
Balance Balance |
BillAddrCity Billing Address - City |
BillAddrCountrySubDivisionCode Billing Address - Country Sub Division Code |
BillAddrId Billing Address - ID |
BillAddrLine1 sensitive Billing Address - Address Line 1 |
BillAddrLine2 sensitive Billing Address - Address Line 2 |
BillAddrPostalCode sensitive Billing Address - Postal Code |
BillEmail sensitive Billing Address - Email |
CurrencyName Currency Name |
Currency Currency |
CustomerName sensitive Customer Name |
CustomerValue Customer ID |
DeliveryTime Delivery Time |
DeliveryType Delivery Type |
DepartmentName Department Name |
DepartmentValue Department ID |
DocNumber Doc Number |
DueDate Due Date |
EInvoiceStatus E-Invoice Status |
EmailStatus Email Status |
CreateTime Created Time |
LastUpdatedTime Last Updated Time |
PrintStatus Print Status |
SalesTerm Sales Term |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
domain Domain |
sparse Sparse |
LinkedTxnId Linked Transaction ID |
LinkedTxnType Linked Transaction Type |
invoice_id Invoice ID |
invoice_txn_date Transaction Date |
invoice_doc_number Document Number |
customer_ref_name sensitive Customer Name |
customer_ref_value Customer ID |
bill_addr_id Billing Address ID |
invoice_total_amt Total Amount |
invoice_sparse Sparse |
line_id Line ID |
line_line_num Line Number |
line_amount Line Amount |
line_description Line Description |
line_detail_type Line Detail Type |
line_item_ref_name Item Name |
line_item_ref_value Item ID |
line_item_account_ref_name Item Account Name |
line_item_account_ref_value Item Account ID |
line_qty Line Quantity |
line_unit_price Line Unit Price |
id ID |
Name Name |
Active Active |
FullyQualifiedName Fully Qualified Name |
IncomeAccountName Income Account Name |
IncomeAccountValue Income Account ID |
Level Level |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
ParentName Parent Name |
ParentValue Parent ID |
PurchaseCost Purchase Cost |
PurchaseTaxIncluded Purchase Tax Included |
SalesTaxIncluded Sales Tax Included |
SubItem Sub Item |
SyncToken Sync Token |
Taxable Taxable |
QtyOnHand Quantity On Hand |
Type Type |
UnitPrice Unit Price |
domain Domain |
sparse Sparse |
id ID |
Adjustment Adjustment |
CurrencyName Currency Name |
Currency Currency |
DocNumber Doc Number |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
SyncToken Sync Token |
TxnDate Transaction Date |
Line_Amount Line item - Amount |
Line_Description Line item - Description |
Line_Id Line item - ID |
Line_AccountName Line item - Account Name |
Line_AccountID Line item - Account ID |
Line_PostingType Line item - Posting Type |
Line_EntityName Line item - Entity Name |
Line_EntityValue Line Entity Value |
Line_EntityID Line item - Entity ID |
Line_TaxAmount Line item - Tax Amount |
Line_TaxApplicableOn Line item - Tax Applicable On |
Line_TaxCode Line item - Tax Code |
domain Domain |
sparse Sparse |
id ID |
CustomerID Customer ID |
CurrencyName Currency Name |
Currency Currency |
CustomerName Customer Name |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
ProcessPayment Process Payment |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
UnappliedAmt Unapplied Amount |
domain Domain |
sparse Sparse |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
item Item |
value Value |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
name Name |
dept_name Dept Name |
klass_name Klass Name |
memo Memo |
split Split |
amount Amount |
balance Balance |
category Category |
subcategory Subcategory |
subsubcategory Subsubcategory |
subsubsubcategory Subsubsubcategory |
subsubsubsubcategory Subsubsubsubcategory |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
account Account |
total Total |
section Section |
id ID |
DocNumber Doc Number |
SyncToken Sync Token |
VendorName Vendor Name |
VendorID Vendor ID |
TxnDate Transaction Date |
TotalAmt Total Amount |
APAccountName Ap Account Name |
APAccountID Ap Account ID |
CurrencyName Currency Name |
Currency Currency |
DepartmentName Department Name |
DepartmentID Department ID |
EmailStatus Email Status |
Line_Amount Line Amount |
Line_Id Line Id |
Line_Description Line Description |
Line_Expense_ItemName Line Expense Item Name |
Line_Expense_ItemID Line Expense Item ID |
Line_Expense_CustomerName sensitive Line Expense Customer Name |
Line_Expense_CustomerID Line Expense Customer ID |
Line_Expense_BillableStatus Line Expense Billable Status |
Line_Expense_TaxCode Line Expense Tax Code |
Line_Expense_Qty Line Expense Quantity |
Line_Expense_UnitPrice Line Expense Unit Price |
POStatus PO Status |
ShipAddrId Ship Address Id |
ShipAddrLine1 sensitive Shipping Address Line 1 |
ShipAddrLine2 sensitive Shipping Address Line 2 |
ShipAddrLine3 sensitive Shipping Address Line 3 |
VendorAddrCity Vendor Address City |
VendorAddrCountry Vendor Address Country |
VendorAddrCountrySubDivisionCode Vendor Address Country Subdivision Code |
VendorAddrId Vendor Address Id |
VendorAddrLine1 sensitive Vendor Address Line 1 |
VendorAddrPostalCode sensitive Vendor Address Postal Code |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
LinkedTxnId Linked Transaction Id |
LinkedTxnType Linked Transaction Type |
id ID |
Active Active |
AccountName Account Name |
AccountID Account ID |
CurrencyName Currency Name |
Currency Currency |
DocNumber Doc Number |
EntityName Entity Name |
EntityID Entity ID |
EntityType Entity Type |
GlobalTaxCalculation Global Tax Calculation |
Line_AccountName Line item - Account Name |
Line_AccountID Line item - Account ID |
Line_BillableStatus Line item - Billable Status |
Line_TaxCode Line item - Tax Code |
Line_Amount Line item - Amount |
Line_Description Line item - Description |
Line_Id Line item - ID |
PaymentType Payment Type |
SyncToken Sync Token |
TotalAmt Total Amount |
TxnDate Transaction Date |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
id ID |
Active Active |
DueDays Due Days |
DiscountDays Discount Days |
DiscountPercent Discount Percent |
Name Name |
SyncToken Sync Token |
Type Type |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
id ID |
BillableStatus Billable Status |
ClassName Class Name |
ClassId Class ID |
CustomerName sensitive Customer Name |
CustomerId Customer ID |
Description Description |
EmployeeName sensitive Employee Name |
EmployeeId Employee ID |
HourlyRate Hourly Rate |
Hours Hours |
ItemName Item Name |
ItemId Item ID |
Minutes Minutes |
NameOf Name Of |
SyncToken Sync Token |
Taxable Taxable |
TxnDate Transaction Date |
VendorName sensitive Vendor Name |
VendorId Vendor ID |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
reportName Report Name |
currency Currency |
startPeriod Start Period |
endPeriod End Period |
date Transaction date |
transaction_type Transaction type |
doc_num Document number |
posting Posting |
name Name |
store Store |
memo Memo |
account_name Account name |
split Split |
amount Amount |
report_name Report Name |
currency Currency |
start_period Start Period |
end_period End Period |
tx_date Transaction date |
txn_type Transaction type |
doc_num Document number |
is_no_post Posting |
name Name |
dept_name Location |
memo Memo |
account_name Account name |
other_account Split |
subt_nat_amount Amount |
section Section |
id ID |
Amount Amount |
CurrencyName Currency Name |
Currency Currency |
FromAccountName From Account Name |
FromAccountID From Account ID |
PrivateNote Private Note |
SyncToken Sync Token |
ToAccountName To Account Name |
ToAccountID To Account ID |
TxnDate Transaction Date |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
id ID |
Active Active |
Balance Balance |
CurrencyName Currency Name |
Currency Currency |
GivenName sensitive Given Name |
DisplayName sensitive Display Name |
FamilyName sensitive Family Name |
PrintOnCheckName sensitive Print On Check Name |
SyncToken Sync Token |
Vendor1099 Vendor 1099 |
PrimaryEmail sensitive Primary Email |
BillAddrCity Bill Address - City |
BillAddrLine1 sensitive Bill Address - Line 1 |
BillAddrPostalCode sensitive Bill Address - Postal Code |
BillAddrCountrySubDivisionCode Bill Address - Country Sub Division Code |
BillAddrId Bill Address - ID |
PrimaryPhone sensitive Primary Phone |
AcctNum Account Number |
CompanyName Company Name |
WebAddrURI Web Address URI |
CreateTime Create Time |
LastUpdatedTime Last Updated Time |
domain Domain |
sparse Sparse |
Pricing
See all Dataddo plans
Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.
View pricing
One Platform to Connect All Your Data
See All Platform Benefits
Why Dataddo?
One Ingestion Layer for SaaS, Databases, and Files
Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.
Built for Cloud and On-Premise Environments
Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.
Full API Control - No UI Required
Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.
Managed Ingestion Operations. We Own the Reliability.
Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.
Full Visibility Into Every Data Flow
Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.
The Data Foundation Your AI Needs
Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.
Case Studies
See What Other Organizations Have Achieved with Dataddo
3.5
man-hours
per week saved
on data collection
1
source of truth
for all marketing data:
AWS S3
1
FTE saved
full-time equivalent
saved
Testimonials
Our Customers Love Us
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”
Andrew Hart
Chief Operations Officer
Sat 7
“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo opens up gates and takes away the hurdles of working with data.”
Laurent Partouche
CPO
FoodChéri & Seazon
“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”
Natheer Maloon
Technology Solutions Manager
Boldr
“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”
Greg Senior
Business Operations Manager
Farm Focus
“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”
