API Connectors

users-love-us medal soc2
Send your Quickbooks data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Quickbooks Connector Reference

136 metrics529 dimensions
Fields

The Quickbooks connector exposes 665 fields (136 metrics, 529 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Quickbooks Fields

Quickbooks accounts fields

The accounts report of the Quickbooks connector includes 18 fields.

ID Type Name Description
accounts__accountsubtype TEXT accounts.AccountSubType accounts.AccountSubType
accounts__accounttype TEXT accounts.AccountType accounts.AccountType
accounts__acctnum TEXT accounts.AcctNum accounts.AcctNum
accounts__active BOOLEAN accounts.Active accounts.Active
accounts__airbyte_cursor TEXT accounts.airbyte_cursor accounts.airbyte_cursor
accounts__classification TEXT accounts.Classification accounts.Classification
accounts__currencyref OBJECT accounts.CurrencyRef accounts.CurrencyRef
accounts__currentbalance NUMERIC accounts.CurrentBalance accounts.CurrentBalance
accounts__currentbalancewithsubaccounts NUMERIC accounts.CurrentBalanceWithSubAccounts accounts.CurrentBalanceWithSubAccounts
accounts__domain TEXT accounts.domain accounts.domain
accounts__fullyqualifiedname TEXT accounts.FullyQualifiedName accounts.FullyQualifiedName
accounts__id TEXT accounts.Id accounts.Id
accounts__metadata OBJECT accounts.MetaData accounts.MetaData
accounts__name TEXT accounts.Name accounts.Name
accounts__parentref OBJECT accounts.ParentRef accounts.ParentRef
accounts__sparse BOOLEAN accounts.sparse accounts.sparse
accounts__subaccount BOOLEAN accounts.SubAccount accounts.SubAccount
accounts__synctoken TEXT accounts.SyncToken accounts.SyncToken

Quickbooks agedreceivables fields

The agedreceivables report of the Quickbooks connector includes 5 fields.

ID Type Name Description
agedreceivables__1_30 NUMERIC agedreceivables.1_30 1 - 30
agedreceivables__31_60 NUMERIC agedreceivables.31_60 31 - 60
agedreceivables__61_90 NUMERIC agedreceivables.61_90 61 - 90
agedreceivables__91andover NUMERIC agedreceivables.91andover 91 and over
agedreceivables__current NUMERIC agedreceivables.Current Current

Quickbooks balancesheet fields

The balancesheet report of the Quickbooks connector includes 14 fields.

ID Type Name Description
balancesheet__totalassets NUMERIC balancesheet.TotalAssets Total Assets
balancesheet__totalassets__currentassets NUMERIC balancesheet.TotalAssets.CurrentAssets Current Assets
balancesheet__totalassets__currentassets__ar NUMERIC balancesheet.TotalAssets.CurrentAssets.AR AR
balancesheet__totalassets__currentassets__bankaccounts NUMERIC balancesheet.TotalAssets.CurrentAssets.BankAccounts Bank Accounts
balancesheet__totalassets__currentassets__othercurrentassets NUMERIC balancesheet.TotalAssets.CurrentAssets.OtherCurrentAssets Other Current Assets
balancesheet__totalassets__fixedassets NUMERIC balancesheet.TotalAssets.FixedAssets Fixed Assets
balancesheet__totalliabilitiesandequity NUMERIC balancesheet.TotalLiabilitiesAndEquity Total Liabilities and Equity
balancesheet__totalliabilitiesandequity__equity NUMERIC balancesheet.TotalLiabilitiesAndEquity.Equity Equity
balancesheet__totalliabilitiesandequity__equity__netincome NUMERIC balancesheet.TotalLiabilitiesAndEquity.Equity.NetIncome Net Income
balancesheet__totalliabilitiesandequity__liabilities NUMERIC balancesheet.TotalLiabilitiesAndEquity.Liabilities Liabilities
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities NUMERIC balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities Current Liabilities
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__ap NUMERIC balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.AP AP
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__creditcards NUMERIC balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.CreditCards Credit Cards
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__OtherCurrentLiabilities NUMERIC balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.OtherCurrentLiabilities Other Current Liabilities

Quickbooks bill_payments fields

The bill_payments report of the Quickbooks connector includes 18 fields.

ID Type Name Description
bill_payments__airbyte_cursor TEXT bill_payments.airbyte_cursor bill_payments.airbyte_cursor
bill_payments__apaccountref OBJECT bill_payments.APAccountRef bill_payments.APAccountRef
bill_payments__checkpayment OBJECT bill_payments.CheckPayment bill_payments.CheckPayment
bill_payments__creditcardpayment OBJECT bill_payments.CreditCardPayment bill_payments.CreditCardPayment
bill_payments__currencyref OBJECT bill_payments.CurrencyRef bill_payments.CurrencyRef
bill_payments__departmentref OBJECT bill_payments.DepartmentRef bill_payments.DepartmentRef
bill_payments__docnumber TEXT bill_payments.DocNumber bill_payments.DocNumber
bill_payments__domain TEXT bill_payments.domain bill_payments.domain
bill_payments__exchangerate NUMERIC bill_payments.ExchangeRate bill_payments.ExchangeRate
bill_payments__id TEXT bill_payments.Id bill_payments.Id
bill_payments__line OBJECT bill_payments.Line bill_payments.Line
bill_payments__metadata OBJECT bill_payments.MetaData bill_payments.MetaData
bill_payments__paytype TEXT bill_payments.PayType bill_payments.PayType
bill_payments__sparse BOOLEAN bill_payments.sparse bill_payments.sparse
bill_payments__synctoken TEXT bill_payments.SyncToken bill_payments.SyncToken
bill_payments__totalamt NUMERIC bill_payments.TotalAmt bill_payments.TotalAmt
bill_payments__txndate TEXT bill_payments.TxnDate bill_payments.TxnDate
bill_payments__vendorref OBJECT bill_payments.VendorRef bill_payments.VendorRef

Quickbooks bills fields

The bills report of the Quickbooks connector includes 20 fields.

ID Type Name Description
bills__airbyte_cursor TEXT bills.airbyte_cursor bills.airbyte_cursor
bills__apaccountref OBJECT bills.APAccountRef bills.APAccountRef
bills__balance NUMERIC bills.Balance bills.Balance
bills__currencyref OBJECT bills.CurrencyRef bills.CurrencyRef
bills__departmentref OBJECT bills.DepartmentRef bills.DepartmentRef
bills__docnumber TEXT bills.DocNumber bills.DocNumber
bills__domain TEXT bills.domain bills.domain
bills__duedate TEXT bills.DueDate bills.DueDate
bills__exchangerate NUMERIC bills.ExchangeRate bills.ExchangeRate
bills__id TEXT bills.Id bills.Id
bills__line OBJECT bills.Line bills.Line
bills__linkedtxn OBJECT bills.LinkedTxn bills.LinkedTxn
bills__metadata OBJECT bills.MetaData bills.MetaData
bills__privatenote TEXT bills.PrivateNote bills.PrivateNote
bills__salestermref OBJECT bills.SalesTermRef bills.SalesTermRef
bills__sparse BOOLEAN bills.sparse bills.sparse
bills__synctoken TEXT bills.SyncToken bills.SyncToken
bills__totalamt NUMERIC bills.TotalAmt bills.TotalAmt
bills__txndate TEXT bills.TxnDate bills.TxnDate
bills__vendorref OBJECT bills.VendorRef bills.VendorRef

Quickbooks budgets fields

The budgets report of the Quickbooks connector includes 12 fields.

ID Type Name Description
budgets__active BOOLEAN budgets.Active budgets.Active
budgets__airbyte_cursor TEXT budgets.airbyte_cursor budgets.airbyte_cursor
budgets__budgetdetail OBJECT budgets.BudgetDetail budgets.BudgetDetail
budgets__budgetentrytype TEXT budgets.BudgetEntryType budgets.BudgetEntryType
budgets__budgettype TEXT budgets.BudgetType budgets.BudgetType
budgets__domain TEXT budgets.domain budgets.domain
budgets__enddate TEXT budgets.EndDate budgets.EndDate
budgets__id TEXT budgets.Id budgets.Id
budgets__metadata OBJECT budgets.MetaData budgets.MetaData
budgets__name TEXT budgets.Name budgets.Name
budgets__startdate TEXT budgets.StartDate budgets.StartDate
budgets__synctoken TEXT budgets.SyncToken budgets.SyncToken

Quickbooks cashflow fields

The cashflow report of the Quickbooks connector includes 8 fields.

ID Type Name Description
cashflow__beginningcash NUMERIC cashflow.BeginningCash Cash at beginning of period
cashflow__cashincrease NUMERIC cashflow.CashIncrease Net cash increase for period
cashflow__endingcash NUMERIC cashflow.EndingCash Cash at end of period
cashflow__financingactivities NUMERIC cashflow.FinancingActivities Net cash provided by financing activities (available only for US, CA, GB, IN, AU locales)
cashflow__investingactivities NUMERIC cashflow.InvestingActivities Net cash provided by investing activities (available only for GB, IN, AU locales)
cashflow__operatingactivities NUMERIC cashflow.OperatingActivities Net cash provided by operating activities
cashflow__operatingactivities__netincome NUMERIC cashflow.OperatingActivities.NetIncome Net Income
cashflow__operatingactivities__operatingadjustments NUMERIC cashflow.OperatingActivities.OperatingAdjustments Adjustments to reconcile Net Income to Net Cash provided by operations

Quickbooks classes fields

The classes report of the Quickbooks connector includes 10 fields.

ID Type Name Description
classes__active BOOLEAN classes.Active classes.Active
classes__airbyte_cursor TEXT classes.airbyte_cursor classes.airbyte_cursor
classes__domain TEXT classes.domain classes.domain
classes__fullyqualifiedname TEXT classes.FullyQualifiedName classes.FullyQualifiedName
classes__id TEXT classes.Id classes.Id
classes__metadata OBJECT classes.MetaData classes.MetaData
classes__name TEXT classes.Name classes.Name
classes__parentref OBJECT classes.ParentRef classes.ParentRef
classes__subclass BOOLEAN classes.SubClass classes.SubClass
classes__synctoken TEXT classes.SyncToken classes.SyncToken

Quickbooks credit_memos fields

The credit_memos report of the Quickbooks connector includes 27 fields.

ID Type Name Description
credit_memos__airbyte_cursor TEXT credit_memos.airbyte_cursor credit_memos.airbyte_cursor
credit_memos__applytaxafterdiscount BOOLEAN credit_memos.ApplyTaxAfterDiscount credit_memos.ApplyTaxAfterDiscount
credit_memos__balance NUMERIC credit_memos.Balance credit_memos.Balance
credit_memos__billaddr OBJECT credit_memos.BillAddr credit_memos.BillAddr
credit_memos__billemail OBJECT credit_memos.BillEmail credit_memos.BillEmail
credit_memos__classref OBJECT credit_memos.ClassRef credit_memos.ClassRef
credit_memos__currencyref OBJECT credit_memos.CurrencyRef credit_memos.CurrencyRef
credit_memos__customermemo OBJECT credit_memos.CustomerMemo credit_memos.CustomerMemo
credit_memos__customerref OBJECT credit_memos.CustomerRef credit_memos.CustomerRef
credit_memos__customfield OBJECT credit_memos.CustomField credit_memos.CustomField
credit_memos__docnumber TEXT credit_memos.DocNumber credit_memos.DocNumber
credit_memos__domain TEXT credit_memos.domain credit_memos.domain
credit_memos__emailstatus TEXT credit_memos.EmailStatus credit_memos.EmailStatus
credit_memos__exchangerate NUMERIC credit_memos.ExchangeRate credit_memos.ExchangeRate
credit_memos__hometotalamt NUMERIC credit_memos.HomeTotalAmt credit_memos.HomeTotalAmt
credit_memos__id TEXT credit_memos.Id credit_memos.Id
credit_memos__line OBJECT credit_memos.Line credit_memos.Line
credit_memos__metadata OBJECT credit_memos.MetaData credit_memos.MetaData
credit_memos__printstatus TEXT credit_memos.PrintStatus credit_memos.PrintStatus
credit_memos__remainingcredit NUMERIC credit_memos.RemainingCredit credit_memos.RemainingCredit
credit_memos__salestermref OBJECT credit_memos.SalesTermRef credit_memos.SalesTermRef
credit_memos__shipaddr OBJECT credit_memos.ShipAddr credit_memos.ShipAddr
credit_memos__sparse BOOLEAN credit_memos.sparse credit_memos.sparse
credit_memos__synctoken TEXT credit_memos.SyncToken credit_memos.SyncToken
credit_memos__totalamt NUMERIC credit_memos.TotalAmt credit_memos.TotalAmt
credit_memos__txndate TEXT credit_memos.TxnDate credit_memos.TxnDate
credit_memos__txntaxdetail OBJECT credit_memos.TxnTaxDetail credit_memos.TxnTaxDetail

Quickbooks customers fields

The customers report of the Quickbooks connector includes 34 fields.

ID Type Name Description
customers__active BOOLEAN customers.Active customers.Active
customers__airbyte_cursor TEXT customers.airbyte_cursor customers.airbyte_cursor
customers__balance NUMERIC customers.Balance customers.Balance
customers__balancewithjobs NUMERIC customers.BalanceWithJobs customers.BalanceWithJobs
customers__billaddr OBJECT customers.BillAddr customers.BillAddr
customers__billwithparent BOOLEAN customers.BillWithParent customers.BillWithParent
customers__companyname TEXT customers.CompanyName customers.CompanyName
customers__currencyref OBJECT customers.CurrencyRef customers.CurrencyRef
customers__defaulttaxcoderef OBJECT customers.DefaultTaxCodeRef customers.DefaultTaxCodeRef
customers__displayname TEXT customers.DisplayName customers.DisplayName
customers__domain TEXT customers.domain customers.domain
customers__familyname TEXT customers.FamilyName customers.FamilyName
customers__fax OBJECT customers.Fax customers.Fax
customers__fullyqualifiedname TEXT customers.FullyQualifiedName customers.FullyQualifiedName
customers__givenname TEXT customers.GivenName customers.GivenName
customers__id TEXT customers.Id customers.Id
customers__job BOOLEAN customers.Job customers.Job
customers__level NUMERIC customers.Level customers.Level
customers__metadata OBJECT customers.MetaData customers.MetaData
customers__middlename TEXT customers.MiddleName customers.MiddleName
customers__mobile OBJECT customers.Mobile customers.Mobile
customers__parentref OBJECT customers.ParentRef customers.ParentRef
customers__paymentmethodref OBJECT customers.PaymentMethodRef customers.PaymentMethodRef
customers__preferreddeliverymethod TEXT customers.PreferredDeliveryMethod customers.PreferredDeliveryMethod
customers__primaryemailaddr OBJECT customers.PrimaryEmailAddr customers.PrimaryEmailAddr
customers__primaryphone OBJECT customers.PrimaryPhone customers.PrimaryPhone
customers__printoncheckname TEXT customers.PrintOnCheckName customers.PrintOnCheckName
customers__resalenum TEXT customers.ResaleNum customers.ResaleNum
customers__salestermref OBJECT customers.SalesTermRef customers.SalesTermRef
customers__shipaddr OBJECT customers.ShipAddr customers.ShipAddr
customers__sparse BOOLEAN customers.sparse customers.sparse
customers__synctoken TEXT customers.SyncToken customers.SyncToken
customers__taxable BOOLEAN customers.Taxable customers.Taxable
customers__webaddr OBJECT customers.WebAddr customers.WebAddr

Quickbooks departments fields

The departments report of the Quickbooks connector includes 10 fields.

ID Type Name Description
departments__active BOOLEAN departments.Active departments.Active
departments__airbyte_cursor TEXT departments.airbyte_cursor departments.airbyte_cursor
departments__domain TEXT departments.domain departments.domain
departments__fullyqualifiedname TEXT departments.FullyQualifiedName departments.FullyQualifiedName
departments__id TEXT departments.Id departments.Id
departments__metadata OBJECT departments.MetaData departments.MetaData
departments__name TEXT departments.Name departments.Name
departments__parentref OBJECT departments.ParentRef departments.ParentRef
departments__subdepartment BOOLEAN departments.SubDepartment departments.SubDepartment
departments__synctoken TEXT departments.SyncToken departments.SyncToken

Quickbooks deposits fields

The deposits report of the Quickbooks connector includes 15 fields.

ID Type Name Description
deposits__airbyte_cursor TEXT deposits.airbyte_cursor deposits.airbyte_cursor
deposits__cashback OBJECT deposits.CashBack deposits.CashBack
deposits__currencyref OBJECT deposits.CurrencyRef deposits.CurrencyRef
deposits__departmentref OBJECT deposits.DepartmentRef deposits.DepartmentRef
deposits__deposittoaccountref OBJECT deposits.DepositToAccountRef deposits.DepositToAccountRef
deposits__domain TEXT deposits.domain deposits.domain
deposits__exchangerate NUMERIC deposits.ExchangeRate deposits.ExchangeRate
deposits__id TEXT deposits.Id deposits.Id
deposits__line OBJECT deposits.Line deposits.Line
deposits__metadata OBJECT deposits.MetaData deposits.MetaData
deposits__privatenote TEXT deposits.PrivateNote deposits.PrivateNote
deposits__sparse BOOLEAN deposits.sparse deposits.sparse
deposits__synctoken TEXT deposits.SyncToken deposits.SyncToken
deposits__totalamt NUMERIC deposits.TotalAmt deposits.TotalAmt
deposits__txndate TEXT deposits.TxnDate deposits.TxnDate

Quickbooks employees fields

The employees report of the Quickbooks connector includes 26 fields.

ID Type Name Description
employees__active BOOLEAN employees.Active employees.Active
employees__airbyte_cursor TEXT employees.airbyte_cursor employees.airbyte_cursor
employees__billabletime BOOLEAN employees.BillableTime employees.BillableTime
employees__billrate NUMERIC employees.BillRate employees.BillRate
employees__birthdate TEXT employees.BirthDate employees.BirthDate
employees__displayname TEXT employees.DisplayName employees.DisplayName
employees__domain TEXT employees.domain employees.domain
employees__employeenumber TEXT employees.EmployeeNumber employees.EmployeeNumber
employees__familyname TEXT employees.FamilyName employees.FamilyName
employees__gender TEXT employees.Gender employees.Gender
employees__givenname TEXT employees.GivenName employees.GivenName
employees__hireddate TEXT employees.HiredDate employees.HiredDate
employees__id TEXT employees.Id employees.Id
employees__metadata OBJECT employees.MetaData employees.MetaData
employees__middlename TEXT employees.MiddleName employees.MiddleName
employees__mobile OBJECT employees.Mobile employees.Mobile
employees__organization BOOLEAN employees.Organization employees.Organization
employees__primaryaddr OBJECT employees.PrimaryAddr employees.PrimaryAddr
employees__primaryemailaddr OBJECT employees.PrimaryEmailAddr employees.PrimaryEmailAddr
employees__primaryphone OBJECT employees.PrimaryPhone employees.PrimaryPhone
employees__printoncheckname TEXT employees.PrintOnCheckName employees.PrintOnCheckName
employees__releaseddate TEXT employees.ReleasedDate employees.ReleasedDate
employees__sparse BOOLEAN employees.sparse employees.sparse
employees__suffix TEXT employees.Suffix employees.Suffix
employees__synctoken TEXT employees.SyncToken employees.SyncToken
employees__title TEXT employees.Title employees.Title

Quickbooks estimates fields

The estimates report of the Quickbooks connector includes 26 fields.

ID Type Name Description
estimates__airbyte_cursor TEXT estimates.airbyte_cursor estimates.airbyte_cursor
estimates__applytaxafterdiscount BOOLEAN estimates.ApplyTaxAfterDiscount estimates.ApplyTaxAfterDiscount
estimates__billaddr OBJECT estimates.BillAddr estimates.BillAddr
estimates__billemail OBJECT estimates.BillEmail estimates.BillEmail
estimates__currencyref OBJECT estimates.CurrencyRef estimates.CurrencyRef
estimates__customermemo OBJECT estimates.CustomerMemo estimates.CustomerMemo
estimates__customerref OBJECT estimates.CustomerRef estimates.CustomerRef
estimates__customfield OBJECT estimates.CustomField estimates.CustomField
estimates__deliveryinfo OBJECT estimates.DeliveryInfo estimates.DeliveryInfo
estimates__docnumber TEXT estimates.DocNumber estimates.DocNumber
estimates__domain TEXT estimates.domain estimates.domain
estimates__emailstatus TEXT estimates.EmailStatus estimates.EmailStatus
estimates__exchangerate NUMERIC estimates.ExchangeRate estimates.ExchangeRate
estimates__hometotalamt NUMERIC estimates.HomeTotalAmt estimates.HomeTotalAmt
estimates__id TEXT estimates.Id estimates.Id
estimates__line OBJECT estimates.Line estimates.Line
estimates__linkedtxn OBJECT estimates.LinkedTxn estimates.LinkedTxn
estimates__metadata OBJECT estimates.MetaData estimates.MetaData
estimates__printstatus TEXT estimates.PrintStatus estimates.PrintStatus
estimates__shipaddr OBJECT estimates.ShipAddr estimates.ShipAddr
estimates__sparse BOOLEAN estimates.sparse estimates.sparse
estimates__synctoken TEXT estimates.SyncToken estimates.SyncToken
estimates__totalamt NUMERIC estimates.TotalAmt estimates.TotalAmt
estimates__txndate TEXT estimates.TxnDate estimates.TxnDate
estimates__txnstatus TEXT estimates.TxnStatus estimates.TxnStatus
estimates__txntaxdetail OBJECT estimates.TxnTaxDetail estimates.TxnTaxDetail

Quickbooks generalledger fields

The generalledger report of the Quickbooks connector includes 48 fields.

Quickbooks generalledger fields (generalledger__item__account_id to generalledger__item__subt_nat_amount)

ID Type Name Description
generalledger__item__account_id TEXT generalledger.Item.account_id Account
generalledger__item__account_name TEXT generalledger.Item.account_name Account
generalledger__item__chk_print_state TEXT generalledger.Item.chk_print_state Check Printed
generalledger__item__create_by TEXT generalledger.Item.create_by Created By
generalledger__item__create_date DATE generalledger.Item.create_date Create Date
generalledger__item__credit_amt NUMERIC generalledger.Item.credit_amt Credit Amount
generalledger__item__credit_home_amt NUMERIC generalledger.Item.credit_home_amt.Multicurrency Credit Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__currency NUMERIC generalledger.Item.currency.Multicurrency Currency (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__cust_name TEXT generalledger.Item.cust_name Customer
generalledger__item__debt_amt NUMERIC generalledger.Item.debt_amt Debit Amount
generalledger__item__debt_home_amt NUMERIC generalledger.Item.debt_home_amt.Multicurrency Debit Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__doc_num TEXT generalledger.Item.doc_num Num
generalledger__item__emp_name TEXT generalledger.Item.emp_name Employee
generalledger__item__exch_rate NUMERIC generalledger.Item.exch_rate.Multicurrency Exchange Rate (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__home_net_amount NUMERIC generalledger.Item.net_amount.Multicurrency Taxable Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__home_tax_amount NUMERIC generalledger.Item.tax_amount.Multicurrency Tax Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__inv_date DATE generalledger.Item.inv_date Invoice Date
generalledger__item__is_adj TEXT generalledger.Item.is_adj Adj
generalledger__item__is_ap_paid TEXT generalledger.Item.is_ap_paid A/P Paid
generalledger__item__is_ar_paid TEXT generalledger.Item.is_ar_paid A/R Paid
generalledger__item__is_cleared TEXT generalledger.Item.is_cleared Cleared
generalledger__item__item_name TEXT generalledger.Item.item_name Product/Service
generalledger__item__last_mod_by TEXT generalledger.Item.last_mod_by Last Modified By
generalledger__item__last_mod_date DATE generalledger.Item.last_mod_date Last Modified Date
generalledger__item__line_id TEXT generalledger.Item.line_id Deterministic key per ledger line; use as the only column to match when syncing to a destination
generalledger__item__memo TEXT generalledger.Item.memo Memo/Description
generalledger__item__name TEXT generalledger.Item.name Name
generalledger__item__nat_foreign_open_bal NUMERIC generalledger.Item.nat_foreign_open_bal.Multicurrency Open Balance Foreign (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__nat_home_open_bal NUMERIC generalledger.Item.nat_home_open_bal.Multicurrency Open Balance Home (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__nat_open_bal NUMERIC generalledger.Item.nat_open_bal Open Balance
generalledger__item__net_amount NUMERIC generalledger.Item.net_amount Taxable Amount
generalledger__item__quantity NUMERIC generalledger.Item.quantity Quantity
generalledger__item__rate NUMERIC generalledger.Item.rate Rate
generalledger__item__rbal_nat_amount NUMERIC generalledger.Item.rbal_nat_amount Balance use for NonTracking disabled comapanies
generalledger__item__rbal_nat_amount_home_nt NUMERIC generalledger.Item.rbal_nat_amount_home_nt.Multicurrency Balance use for NonTracking enabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__rbal_nat_amount_nt NUMERIC generalledger.Item.rbal_nat_amount_nt Balance use for NonTracking enabled comapanies
generalledger__item__rbal_nat_home_amount NUMERIC generalledger.Item.rbal_nat_home_amount.Multicurrency Balance use for NonTracking disabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__report_index TEXT generalledger.Item.report_index Position of the row within a single query; not stable across queries, never use as a column to match
generalledger__item__split_acc TEXT generalledger.Item.split_acc Split
generalledger__item__subt_nat_amount NUMERIC generalledger.Item.subt_nat_amount Amount use for NonTracking disabled comapanies

Quickbooks generalledger fields (generalledger__item__subt_nat_amount_home_nt to generalledger__item__vendor_name)

ID Type Name Description
generalledger__item__subt_nat_amount_home_nt NUMERIC generalledger.Item.subt_nat_amount_home_nt.Multicurrency Amount use for NonTracking enabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__subt_nat_amount_nt NUMERIC generalledger.Item.subt_nat_amount_nt Amount use for NonTracking enabled comapanies
generalledger__item__subt_nat_home_amount NUMERIC generalledger.Item.subt_nat_home_amount.Multicurrency Amount use for NonTracking disabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__tax_amount NUMERIC generalledger.Item.tax_amount Tax Amount
generalledger__item__tx_date DATE generalledger.Item.tx_date Transaction Date
generalledger__item__txn_id TEXT generalledger.Item.txn_id QuickBooks transaction id; shared by every line of the same transaction
generalledger__item__txn_type TEXT generalledger.Item.txn_type Transaction Type
generalledger__item__vendor_name TEXT generalledger.Item.vendor_name Vendor

Quickbooks invoices fields

The invoices report of the Quickbooks connector includes 33 fields.

ID Type Name Description
invoices__airbyte_cursor TEXT invoices.airbyte_cursor invoices.airbyte_cursor
invoices__allowipnpayment BOOLEAN invoices.AllowIPNPayment invoices.AllowIPNPayment
invoices__allowonlineachpayment BOOLEAN invoices.AllowOnlineACHPayment invoices.AllowOnlineACHPayment
invoices__allowonlinecreditcardpayment BOOLEAN invoices.AllowOnlineCreditCardPayment invoices.AllowOnlineCreditCardPayment
invoices__allowonlinepayment BOOLEAN invoices.AllowOnlinePayment invoices.AllowOnlinePayment
invoices__applytaxafterdiscount BOOLEAN invoices.ApplyTaxAfterDiscount invoices.ApplyTaxAfterDiscount
invoices__balance NUMERIC invoices.Balance invoices.Balance
invoices__billaddr OBJECT invoices.BillAddr invoices.BillAddr
invoices__billemail OBJECT invoices.BillEmail invoices.BillEmail
invoices__currencyref OBJECT invoices.CurrencyRef invoices.CurrencyRef
invoices__customermemo OBJECT invoices.CustomerMemo invoices.CustomerMemo
invoices__customerref OBJECT invoices.CustomerRef invoices.CustomerRef
invoices__customfield OBJECT invoices.CustomField invoices.CustomField
invoices__deliveryinfo OBJECT invoices.DeliveryInfo invoices.DeliveryInfo
invoices__docnumber TEXT invoices.DocNumber invoices.DocNumber
invoices__domain TEXT invoices.domain invoices.domain
invoices__duedate TEXT invoices.DueDate invoices.DueDate
invoices__emailstatus TEXT invoices.EmailStatus invoices.EmailStatus
invoices__exchangerate NUMERIC invoices.ExchangeRate invoices.ExchangeRate
invoices__hometotalamt NUMERIC invoices.HomeTotalAmt invoices.HomeTotalAmt
invoices__id TEXT invoices.Id invoices.Id
invoices__line OBJECT invoices.Line invoices.Line
invoices__linkedtxn OBJECT invoices.LinkedTxn invoices.LinkedTxn
invoices__metadata OBJECT invoices.MetaData invoices.MetaData
invoices__printstatus TEXT invoices.PrintStatus invoices.PrintStatus
invoices__privatenote TEXT invoices.PrivateNote invoices.PrivateNote
invoices__salestermref OBJECT invoices.SalesTermRef invoices.SalesTermRef
invoices__shipaddr OBJECT invoices.ShipAddr invoices.ShipAddr
invoices__sparse BOOLEAN invoices.sparse invoices.sparse
invoices__synctoken TEXT invoices.SyncToken invoices.SyncToken
invoices__totalamt NUMERIC invoices.TotalAmt invoices.TotalAmt
invoices__txndate TEXT invoices.TxnDate invoices.TxnDate
invoices__txntaxdetail OBJECT invoices.TxnTaxDetail invoices.TxnTaxDetail

Quickbooks items fields

The items report of the Quickbooks connector includes 21 fields.

ID Type Name Description
items__active BOOLEAN items.Active items.Active
items__airbyte_cursor TEXT items.airbyte_cursor items.airbyte_cursor
items__assetaccountref OBJECT items.AssetAccountRef items.AssetAccountRef
items__description TEXT items.Description items.Description
items__domain TEXT items.domain items.domain
items__expenseaccountref OBJECT items.ExpenseAccountRef items.ExpenseAccountRef
items__fullyqualifiedname TEXT items.FullyQualifiedName items.FullyQualifiedName
items__id TEXT items.Id items.Id
items__incomeaccountref OBJECT items.IncomeAccountRef items.IncomeAccountRef
items__invstartdate TEXT items.InvStartDate items.InvStartDate
items__metadata OBJECT items.MetaData items.MetaData
items__name TEXT items.Name items.Name
items__purchasecost NUMERIC items.PurchaseCost items.PurchaseCost
items__purchasedesc TEXT items.PurchaseDesc items.PurchaseDesc
items__qtyonhand NUMERIC items.QtyOnHand items.QtyOnHand
items__sparse BOOLEAN items.sparse items.sparse
items__synctoken TEXT items.SyncToken items.SyncToken
items__taxable BOOLEAN items.Taxable items.Taxable
items__trackqtyonhand BOOLEAN items.TrackQtyOnHand items.TrackQtyOnHand
items__type TEXT items.Type items.Type
items__unitprice NUMERIC items.UnitPrice items.UnitPrice

Quickbooks journal_entries fields

The journal_entries report of the Quickbooks connector includes 15 fields.

ID Type Name Description
journal_entries__adjustment BOOLEAN journal_entries.Adjustment journal_entries.Adjustment
journal_entries__airbyte_cursor TEXT journal_entries.airbyte_cursor journal_entries.airbyte_cursor
journal_entries__currencyref OBJECT journal_entries.CurrencyRef journal_entries.CurrencyRef
journal_entries__docnumber TEXT journal_entries.DocNumber journal_entries.DocNumber
journal_entries__domain TEXT journal_entries.domain journal_entries.domain
journal_entries__exchangerate NUMERIC journal_entries.ExchangeRate journal_entries.ExchangeRate
journal_entries__id TEXT journal_entries.Id journal_entries.Id
journal_entries__line OBJECT journal_entries.Line journal_entries.Line
journal_entries__metadata OBJECT journal_entries.MetaData journal_entries.MetaData
journal_entries__privatenote TEXT journal_entries.PrivateNote journal_entries.PrivateNote
journal_entries__sparse BOOLEAN journal_entries.sparse journal_entries.sparse
journal_entries__synctoken TEXT journal_entries.SyncToken journal_entries.SyncToken
journal_entries__taxrateref OBJECT journal_entries.TaxRateRef journal_entries.TaxRateRef
journal_entries__txndate TEXT journal_entries.TxnDate journal_entries.TxnDate
journal_entries__txntaxdetail OBJECT journal_entries.TxnTaxDetail journal_entries.TxnTaxDetail

Quickbooks payment_methods fields

The payment_methods report of the Quickbooks connector includes 9 fields.

ID Type Name Description
payment_methods__active BOOLEAN payment_methods.Active payment_methods.Active
payment_methods__airbyte_cursor TEXT payment_methods.airbyte_cursor payment_methods.airbyte_cursor
payment_methods__domain TEXT payment_methods.domain payment_methods.domain
payment_methods__id TEXT payment_methods.Id payment_methods.Id
payment_methods__metadata OBJECT payment_methods.MetaData payment_methods.MetaData
payment_methods__name TEXT payment_methods.Name payment_methods.Name
payment_methods__sparse BOOLEAN payment_methods.sparse payment_methods.sparse
payment_methods__synctoken TEXT payment_methods.SyncToken payment_methods.SyncToken
payment_methods__type TEXT payment_methods.Type payment_methods.Type

Quickbooks payments fields

The payments report of the Quickbooks connector includes 20 fields.

ID Type Name Description
payments__airbyte_cursor TEXT payments.airbyte_cursor payments.airbyte_cursor
payments__araccountref OBJECT payments.ARAccountRef payments.ARAccountRef
payments__currencyref OBJECT payments.CurrencyRef payments.CurrencyRef
payments__customerref OBJECT payments.CustomerRef payments.CustomerRef
payments__deposittoaccountref OBJECT payments.DepositToAccountRef payments.DepositToAccountRef
payments__domain TEXT payments.domain payments.domain
payments__exchangerate NUMERIC payments.ExchangeRate payments.ExchangeRate
payments__id TEXT payments.Id payments.Id
payments__line OBJECT payments.Line payments.Line
payments__linkedtxn OBJECT payments.LinkedTxn payments.LinkedTxn
payments__metadata OBJECT payments.MetaData payments.MetaData
payments__paymentmethodref OBJECT payments.PaymentMethodRef payments.PaymentMethodRef
payments__paymentrefnum TEXT payments.PaymentRefNum payments.PaymentRefNum
payments__privatenote TEXT payments.PrivateNote payments.PrivateNote
payments__processpayment BOOLEAN payments.ProcessPayment payments.ProcessPayment
payments__sparse BOOLEAN payments.sparse payments.sparse
payments__synctoken TEXT payments.SyncToken payments.SyncToken
payments__totalamt NUMERIC payments.TotalAmt payments.TotalAmt
payments__txndate TEXT payments.TxnDate payments.TxnDate
payments__unappliedamt NUMERIC payments.UnappliedAmt payments.UnappliedAmt

Quickbooks profitandloss fields

The profitandloss report of the Quickbooks connector includes 25 fields.

ID Type Name Description
profitandloss__cogs NUMERIC profitandloss.COGS Total Cost of Goods Sold (not available for FR locale)
profitandloss__depreciationandprovisions NUMERIC profitandloss.DepreciationAndProvisions Depreciation and Provisions (available only for FR locale)
profitandloss__employeeparticipationresults NUMERIC profitandloss.EmployeeParticipationResults Employee Participation Results (available only for FR locale)
profitandloss__exceptionalcharges NUMERIC profitandloss.ExceptionalCharges Exceptional Charges (available only for FR locale)
profitandloss__exceptionalitems NUMERIC profitandloss.ExceptionalItems Exceptional Items (available only for FR locale)
profitandloss__expenses NUMERIC profitandloss.Expenses Total Expenses (not available for FR locale)
profitandloss__export NUMERIC profitandloss.Export Export (available only for FR locale)
profitandloss__financialcharges NUMERIC profitandloss.FinancialCharges Financial Charges (available only for FR locale)
profitandloss__financialproducts NUMERIC profitandloss.FinancialProducts Financial Products (available only for FR locale)
profitandloss__grossprofit NUMERIC profitandloss.GrossProfit Gross Profit (not available for FR and CA locales)
profitandloss__including NUMERIC profitandloss.Including Including (available only for FR locale)
profitandloss__income NUMERIC profitandloss.Income Total Income (not available for FR locale)
profitandloss__incometaxexpenses NUMERIC profitandloss.IncomeTaxExpenses Income Tax Expenses (available only for FR locale)
profitandloss__jointoperations NUMERIC profitandloss.JointOperations Joint Operations (available only for FR locale)
profitandloss__netincome NUMERIC profitandloss.NetIncome Net Income (not available for FR locale)
profitandloss__netoperatingincome NUMERIC profitandloss.NetOperatingIncome Net Operating Income (available only for US and GB locales)
profitandloss__netotherincome NUMERIC profitandloss.NetOtherIncome Net Other Income (available only for US and GB locales)
profitandloss__operatingexpenses NUMERIC profitandloss.OperatingExpenses Operating Expenses (available only for FR locale)
profitandloss__otherexpenses NUMERIC profitandloss.OtherExpenses Total Other Expenses (not available for FR locale)
profitandloss__otherincome NUMERIC profitandloss.OtherIncome Total Other Income (not available for US and FR locales)
profitandloss__profitorloss NUMERIC profitandloss.ProfitOrLoss Profit or Loss (available only for FR locale)
profitandloss__quotasresultinjointoperations NUMERIC profitandloss.QuotasResultInJointOperations Quotas Result in Joint Operations (available only for FR locale)
profitandloss__revenue NUMERIC profitandloss.Revenue Revenue (available only for FR locale)
profitandloss__totalexpenses NUMERIC profitandloss.TotalExpenses Total Expenses (available only for FR locale)
profitandloss__totalincome NUMERIC profitandloss.TotalIncome Total Income (available only for FR locale)

Quickbooks purchase_orders fields

The purchase_orders report of the Quickbooks connector includes 28 fields.

ID Type Name Description
purchase_orders__airbyte_cursor TEXT purchase_orders.airbyte_cursor purchase_orders.airbyte_cursor
purchase_orders__apaccountref OBJECT purchase_orders.APAccountRef purchase_orders.APAccountRef
purchase_orders__classref OBJECT purchase_orders.ClassRef purchase_orders.ClassRef
purchase_orders__currencyref OBJECT purchase_orders.CurrencyRef purchase_orders.CurrencyRef
purchase_orders__customfield OBJECT purchase_orders.CustomField purchase_orders.CustomField
purchase_orders__departmentref OBJECT purchase_orders.DepartmentRef purchase_orders.DepartmentRef
purchase_orders__docnumber TEXT purchase_orders.DocNumber purchase_orders.DocNumber
purchase_orders__domain TEXT purchase_orders.domain purchase_orders.domain
purchase_orders__duedate TEXT purchase_orders.DueDate purchase_orders.DueDate
purchase_orders__emailstatus TEXT purchase_orders.EmailStatus purchase_orders.EmailStatus
purchase_orders__exchangerate NUMERIC purchase_orders.ExchangeRate purchase_orders.ExchangeRate
purchase_orders__id TEXT purchase_orders.Id purchase_orders.Id
purchase_orders__line OBJECT purchase_orders.Line purchase_orders.Line
purchase_orders__linkedtxn OBJECT purchase_orders.LinkedTxn purchase_orders.LinkedTxn
purchase_orders__memo TEXT purchase_orders.Memo purchase_orders.Memo
purchase_orders__metadata OBJECT purchase_orders.MetaData purchase_orders.MetaData
purchase_orders__postatus TEXT purchase_orders.POStatus purchase_orders.POStatus
purchase_orders__privatenote TEXT purchase_orders.PrivateNote purchase_orders.PrivateNote
purchase_orders__salestermref OBJECT purchase_orders.SalesTermRef purchase_orders.SalesTermRef
purchase_orders__shipaddr OBJECT purchase_orders.ShipAddr purchase_orders.ShipAddr
purchase_orders__shipto OBJECT purchase_orders.ShipTo purchase_orders.ShipTo
purchase_orders__sparse BOOLEAN purchase_orders.sparse purchase_orders.sparse
purchase_orders__synctoken TEXT purchase_orders.SyncToken purchase_orders.SyncToken
purchase_orders__totalamt NUMERIC purchase_orders.TotalAmt purchase_orders.TotalAmt
purchase_orders__txndate TEXT purchase_orders.TxnDate purchase_orders.TxnDate
purchase_orders__txntaxdetail OBJECT purchase_orders.TxnTaxDetail purchase_orders.TxnTaxDetail
purchase_orders__vendoraddr OBJECT purchase_orders.VendorAddr purchase_orders.VendorAddr
purchase_orders__vendorref OBJECT purchase_orders.VendorRef purchase_orders.VendorRef

Quickbooks purchases fields

The purchases report of the Quickbooks connector includes 20 fields.

ID Type Name Description
purchases__accountref OBJECT purchases.AccountRef purchases.AccountRef
purchases__airbyte_cursor TEXT purchases.airbyte_cursor purchases.airbyte_cursor
purchases__credit BOOLEAN purchases.Credit purchases.Credit
purchases__currencyref OBJECT purchases.CurrencyRef purchases.CurrencyRef
purchases__docnumber TEXT purchases.DocNumber purchases.DocNumber
purchases__domain TEXT purchases.domain purchases.domain
purchases__entityref OBJECT purchases.EntityRef purchases.EntityRef
purchases__exchangerate NUMERIC purchases.ExchangeRate purchases.ExchangeRate
purchases__id TEXT purchases.Id purchases.Id
purchases__line OBJECT purchases.Line purchases.Line
purchases__metadata OBJECT purchases.MetaData purchases.MetaData
purchases__paymenttype TEXT purchases.PaymentType purchases.PaymentType
purchases__printstatus TEXT purchases.PrintStatus purchases.PrintStatus
purchases__privatenote TEXT purchases.PrivateNote purchases.PrivateNote
purchases__purchaseex OBJECT purchases.PurchaseEx purchases.PurchaseEx
purchases__remittoaddr OBJECT purchases.RemitToAddr purchases.RemitToAddr
purchases__sparse BOOLEAN purchases.sparse purchases.sparse
purchases__synctoken TEXT purchases.SyncToken purchases.SyncToken
purchases__totalamt NUMERIC purchases.TotalAmt purchases.TotalAmt
purchases__txndate TEXT purchases.TxnDate purchases.TxnDate

Quickbooks refund_receipts fields

The refund_receipts report of the Quickbooks connector includes 24 fields.

ID Type Name Description
refund_receipts__airbyte_cursor TEXT refund_receipts.airbyte_cursor refund_receipts.airbyte_cursor
refund_receipts__applytaxafterdiscount BOOLEAN refund_receipts.ApplyTaxAfterDiscount refund_receipts.ApplyTaxAfterDiscount
refund_receipts__balance NUMERIC refund_receipts.Balance refund_receipts.Balance
refund_receipts__billaddr OBJECT refund_receipts.BillAddr refund_receipts.BillAddr
refund_receipts__billemail OBJECT refund_receipts.BillEmail refund_receipts.BillEmail
refund_receipts__currencyref OBJECT refund_receipts.CurrencyRef refund_receipts.CurrencyRef
refund_receipts__customermemo OBJECT refund_receipts.CustomerMemo refund_receipts.CustomerMemo
refund_receipts__customerref OBJECT refund_receipts.CustomerRef refund_receipts.CustomerRef
refund_receipts__customfield OBJECT refund_receipts.CustomField refund_receipts.CustomField
refund_receipts__deposittoaccountref OBJECT refund_receipts.DepositToAccountRef refund_receipts.DepositToAccountRef
refund_receipts__docnumber TEXT refund_receipts.DocNumber refund_receipts.DocNumber
refund_receipts__domain TEXT refund_receipts.domain refund_receipts.domain
refund_receipts__exchangerate NUMERIC refund_receipts.ExchangeRate refund_receipts.ExchangeRate
refund_receipts__hometotalamt NUMERIC refund_receipts.HomeTotalAmt refund_receipts.HomeTotalAmt
refund_receipts__id TEXT refund_receipts.Id refund_receipts.Id
refund_receipts__line OBJECT refund_receipts.Line refund_receipts.Line
refund_receipts__metadata OBJECT refund_receipts.MetaData refund_receipts.MetaData
refund_receipts__paymentmethodref OBJECT refund_receipts.PaymentMethodRef refund_receipts.PaymentMethodRef
refund_receipts__printstatus TEXT refund_receipts.PrintStatus refund_receipts.PrintStatus
refund_receipts__sparse BOOLEAN refund_receipts.sparse refund_receipts.sparse
refund_receipts__synctoken TEXT refund_receipts.SyncToken refund_receipts.SyncToken
refund_receipts__totalamt NUMERIC refund_receipts.TotalAmt refund_receipts.TotalAmt
refund_receipts__txndate TEXT refund_receipts.TxnDate refund_receipts.TxnDate
refund_receipts__txntaxdetail OBJECT refund_receipts.TxnTaxDetail refund_receipts.TxnTaxDetail

Quickbooks report fields

The report report of the Quickbooks connector includes 8 fields.

ID Type Name Description
account_id TEXT Account ID Identifier of the connected QuickBooks account
account_name TEXT Account Name Name of the connected QuickBooks account
report__accounts__id TEXT report.Accounts.Id Account ID used for supported fields of report
report__customers__id TEXT report.Customers.Id Customer ID used for supported fields of ARAging Summary report
report__summarize_by__classes__id TEXT report.SummarizeBy.Classes.Id Class ID; select it to break the report down per Class. Combine with report__accounts__id for an Account-by-Class breakdown (e.g. Profit and Loss by Class). Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__customers__id TEXT report.SummarizeBy.Customers.Id Customer ID; select it to break the report down per Customer. Combine with report__accounts__id for an Account-by-Customer breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__employees__id TEXT report.SummarizeBy.Employees.Id Employee ID; select it to break the report down per Employee. Combine with report__accounts__id for an Account-by-Employee breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__vendors__id TEXT report.SummarizeBy.Vendors.Id Vendor ID; select it to break the report down per Vendor. Combine with report__accounts__id for an Account-by-Vendor breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.

Quickbooks sales_receipts fields

The sales_receipts report of the Quickbooks connector includes 28 fields.

ID Type Name Description
sales_receipts__airbyte_cursor TEXT sales_receipts.airbyte_cursor sales_receipts.airbyte_cursor
sales_receipts__applytaxafterdiscount BOOLEAN sales_receipts.ApplyTaxAfterDiscount sales_receipts.ApplyTaxAfterDiscount
sales_receipts__balance NUMERIC sales_receipts.Balance sales_receipts.Balance
sales_receipts__billaddr OBJECT sales_receipts.BillAddr sales_receipts.BillAddr
sales_receipts__billemail OBJECT sales_receipts.BillEmail sales_receipts.BillEmail
sales_receipts__currencyref OBJECT sales_receipts.CurrencyRef sales_receipts.CurrencyRef
sales_receipts__customermemo OBJECT sales_receipts.CustomerMemo sales_receipts.CustomerMemo
sales_receipts__customerref OBJECT sales_receipts.CustomerRef sales_receipts.CustomerRef
sales_receipts__customfield OBJECT sales_receipts.CustomField sales_receipts.CustomField
sales_receipts__deposittoaccountref OBJECT sales_receipts.DepositToAccountRef sales_receipts.DepositToAccountRef
sales_receipts__docnumber TEXT sales_receipts.DocNumber sales_receipts.DocNumber
sales_receipts__domain TEXT sales_receipts.domain sales_receipts.domain
sales_receipts__emailstatus TEXT sales_receipts.EmailStatus sales_receipts.EmailStatus
sales_receipts__exchangerate NUMERIC sales_receipts.ExchangeRate sales_receipts.ExchangeRate
sales_receipts__hometotalamt NUMERIC sales_receipts.HomeTotalAmt sales_receipts.HomeTotalAmt
sales_receipts__id TEXT sales_receipts.Id sales_receipts.Id
sales_receipts__line OBJECT sales_receipts.Line sales_receipts.Line
sales_receipts__linkedtxn OBJECT sales_receipts.LinkedTxn sales_receipts.LinkedTxn
sales_receipts__metadata OBJECT sales_receipts.MetaData sales_receipts.MetaData
sales_receipts__paymentmethodref OBJECT sales_receipts.PaymentMethodRef sales_receipts.PaymentMethodRef
sales_receipts__paymentrefnum TEXT sales_receipts.PaymentRefNum sales_receipts.PaymentRefNum
sales_receipts__printstatus TEXT sales_receipts.PrintStatus sales_receipts.PrintStatus
sales_receipts__shipaddr OBJECT sales_receipts.ShipAddr sales_receipts.ShipAddr
sales_receipts__sparse BOOLEAN sales_receipts.sparse sales_receipts.sparse
sales_receipts__synctoken TEXT sales_receipts.SyncToken sales_receipts.SyncToken
sales_receipts__totalamt NUMERIC sales_receipts.TotalAmt sales_receipts.TotalAmt
sales_receipts__txndate TEXT sales_receipts.TxnDate sales_receipts.TxnDate
sales_receipts__txntaxdetail OBJECT sales_receipts.TxnTaxDetail sales_receipts.TxnTaxDetail

Quickbooks tax_agencies fields

The tax_agencies report of the Quickbooks connector includes 10 fields.

ID Type Name Description
tax_agencies__airbyte_cursor TEXT tax_agencies.airbyte_cursor tax_agencies.airbyte_cursor
tax_agencies__displayname TEXT tax_agencies.DisplayName tax_agencies.DisplayName
tax_agencies__domain TEXT tax_agencies.domain tax_agencies.domain
tax_agencies__id TEXT tax_agencies.Id tax_agencies.Id
tax_agencies__metadata OBJECT tax_agencies.MetaData tax_agencies.MetaData
tax_agencies__sparse BOOLEAN tax_agencies.sparse tax_agencies.sparse
tax_agencies__synctoken TEXT tax_agencies.SyncToken tax_agencies.SyncToken
tax_agencies__taxregistrationnumber TEXT tax_agencies.TaxRegistrationNumber tax_agencies.TaxRegistrationNumber
tax_agencies__taxtrackedonpurchases BOOLEAN tax_agencies.TaxTrackedOnPurchases tax_agencies.TaxTrackedOnPurchases
tax_agencies__taxtrackedonsales BOOLEAN tax_agencies.TaxTrackedOnSales tax_agencies.TaxTrackedOnSales

Quickbooks tax_codes fields

The tax_codes report of the Quickbooks connector includes 14 fields.

ID Type Name Description
tax_codes__active BOOLEAN tax_codes.Active tax_codes.Active
tax_codes__airbyte_cursor TEXT tax_codes.airbyte_cursor tax_codes.airbyte_cursor
tax_codes__description TEXT tax_codes.Description tax_codes.Description
tax_codes__domain TEXT tax_codes.domain tax_codes.domain
tax_codes__hidden BOOLEAN tax_codes.Hidden tax_codes.Hidden
tax_codes__id TEXT tax_codes.Id tax_codes.Id
tax_codes__metadata OBJECT tax_codes.MetaData tax_codes.MetaData
tax_codes__name TEXT tax_codes.Name tax_codes.Name
tax_codes__purchasetaxratelist OBJECT tax_codes.PurchaseTaxRateList tax_codes.PurchaseTaxRateList
tax_codes__salestaxratelist OBJECT tax_codes.SalesTaxRateList tax_codes.SalesTaxRateList
tax_codes__sparse BOOLEAN tax_codes.sparse tax_codes.sparse
tax_codes__synctoken TEXT tax_codes.SyncToken tax_codes.SyncToken
tax_codes__taxable BOOLEAN tax_codes.Taxable tax_codes.Taxable
tax_codes__taxgroup BOOLEAN tax_codes.TaxGroup tax_codes.TaxGroup

Quickbooks tax_rates fields

The tax_rates report of the Quickbooks connector includes 14 fields.

ID Type Name Description
tax_rates__active BOOLEAN tax_rates.Active tax_rates.Active
tax_rates__agencyref OBJECT tax_rates.AgencyRef tax_rates.AgencyRef
tax_rates__airbyte_cursor TEXT tax_rates.airbyte_cursor tax_rates.airbyte_cursor
tax_rates__description TEXT tax_rates.Description tax_rates.Description
tax_rates__displaytype TEXT tax_rates.DisplayType tax_rates.DisplayType
tax_rates__domain TEXT tax_rates.domain tax_rates.domain
tax_rates__effectivetaxrate TEXT tax_rates.EffectiveTaxRate tax_rates.EffectiveTaxRate
tax_rates__id TEXT tax_rates.Id tax_rates.Id
tax_rates__metadata OBJECT tax_rates.MetaData tax_rates.MetaData
tax_rates__name TEXT tax_rates.Name tax_rates.Name
tax_rates__ratevalue NUMERIC tax_rates.RateValue tax_rates.RateValue
tax_rates__sparse BOOLEAN tax_rates.sparse tax_rates.sparse
tax_rates__specialtaxtype TEXT tax_rates.SpecialTaxType tax_rates.SpecialTaxType
tax_rates__synctoken TEXT tax_rates.SyncToken tax_rates.SyncToken

Quickbooks terms fields

The terms report of the Quickbooks connector includes 15 fields.

ID Type Name Description
terms__active BOOLEAN terms.Active terms.Active
terms__airbyte_cursor TEXT terms.airbyte_cursor terms.airbyte_cursor
terms__dayofmonthdue NUMERIC terms.DayOfMonthDue terms.DayOfMonthDue
terms__discountdayofmonth NUMERIC terms.DiscountDayOfMonth terms.DiscountDayOfMonth
terms__discountdays NUMERIC terms.DiscountDays terms.DiscountDays
terms__discountpercent NUMERIC terms.DiscountPercent terms.DiscountPercent
terms__domain TEXT terms.domain terms.domain
terms__duedays NUMERIC terms.DueDays terms.DueDays
terms__duenextmonthdays NUMERIC terms.DueNextMonthDays terms.DueNextMonthDays
terms__id TEXT terms.Id terms.Id
terms__metadata OBJECT terms.MetaData terms.MetaData
terms__name TEXT terms.Name terms.Name
terms__sparse BOOLEAN terms.sparse terms.sparse
terms__synctoken TEXT terms.SyncToken terms.SyncToken
terms__type TEXT terms.Type terms.Type

Quickbooks time_activities fields

The time_activities report of the Quickbooks connector includes 17 fields.

ID Type Name Description
time_activities__airbyte_cursor TEXT time_activities.airbyte_cursor time_activities.airbyte_cursor
time_activities__billablestatus TEXT time_activities.BillableStatus time_activities.BillableStatus
time_activities__customerref OBJECT time_activities.CustomerRef time_activities.CustomerRef
time_activities__description TEXT time_activities.Description time_activities.Description
time_activities__domain TEXT time_activities.domain time_activities.domain
time_activities__employeeref OBJECT time_activities.EmployeeRef time_activities.EmployeeRef
time_activities__hourlyrate NUMERIC time_activities.HourlyRate time_activities.HourlyRate
time_activities__hours NUMERIC time_activities.Hours time_activities.Hours
time_activities__id TEXT time_activities.Id time_activities.Id
time_activities__itemref OBJECT time_activities.ItemRef time_activities.ItemRef
time_activities__metadata OBJECT time_activities.MetaData time_activities.MetaData
time_activities__minutes NUMERIC time_activities.Minutes time_activities.Minutes
time_activities__nameof TEXT time_activities.NameOf time_activities.NameOf
time_activities__sparse BOOLEAN time_activities.sparse time_activities.sparse
time_activities__synctoken TEXT time_activities.SyncToken time_activities.SyncToken
time_activities__taxable BOOLEAN time_activities.Taxable time_activities.Taxable
time_activities__txndate TEXT time_activities.TxnDate time_activities.TxnDate

Quickbooks transfers fields

The transfers report of the Quickbooks connector includes 12 fields.

ID Type Name Description
transfers__airbyte_cursor TEXT transfers.airbyte_cursor transfers.airbyte_cursor
transfers__amount NUMERIC transfers.Amount transfers.Amount
transfers__currencyref OBJECT transfers.CurrencyRef transfers.CurrencyRef
transfers__domain TEXT transfers.domain transfers.domain
transfers__exchangerate NUMERIC transfers.ExchangeRate transfers.ExchangeRate
transfers__fromaccountref OBJECT transfers.FromAccountRef transfers.FromAccountRef
transfers__id TEXT transfers.Id transfers.Id
transfers__metadata OBJECT transfers.MetaData transfers.MetaData
transfers__privatenote TEXT transfers.PrivateNote transfers.PrivateNote
transfers__synctoken TEXT transfers.SyncToken transfers.SyncToken
transfers__toaccountref OBJECT transfers.ToAccountRef transfers.ToAccountRef
transfers__txndate TEXT transfers.TxnDate transfers.TxnDate

Quickbooks vendor_credits fields

The vendor_credits report of the Quickbooks connector includes 14 fields.

ID Type Name Description
vendor_credits__airbyte_cursor TEXT vendor_credits.airbyte_cursor vendor_credits.airbyte_cursor
vendor_credits__apaccountref OBJECT vendor_credits.APAccountRef vendor_credits.APAccountRef
vendor_credits__currencyref OBJECT vendor_credits.CurrencyRef vendor_credits.CurrencyRef
vendor_credits__departmentref OBJECT vendor_credits.DepartmentRef vendor_credits.DepartmentRef
vendor_credits__docnumber TEXT vendor_credits.DocNumber vendor_credits.DocNumber
vendor_credits__domain TEXT vendor_credits.domain vendor_credits.domain
vendor_credits__exchangerate NUMERIC vendor_credits.ExchangeRate vendor_credits.ExchangeRate
vendor_credits__id TEXT vendor_credits.Id vendor_credits.Id
vendor_credits__line OBJECT vendor_credits.Line vendor_credits.Line
vendor_credits__metadata OBJECT vendor_credits.MetaData vendor_credits.MetaData
vendor_credits__synctoken TEXT vendor_credits.SyncToken vendor_credits.SyncToken
vendor_credits__totalamt NUMERIC vendor_credits.TotalAmt vendor_credits.TotalAmt
vendor_credits__txndate TEXT vendor_credits.TxnDate vendor_credits.TxnDate
vendor_credits__vendorref OBJECT vendor_credits.VendorRef vendor_credits.VendorRef

Quickbooks vendors fields

The vendors report of the Quickbooks connector includes 26 fields.

ID Type Name Description
vendors__acctnum TEXT vendors.AcctNum vendors.AcctNum
vendors__active BOOLEAN vendors.Active vendors.Active
vendors__airbyte_cursor TEXT vendors.airbyte_cursor vendors.airbyte_cursor
vendors__balance NUMERIC vendors.Balance vendors.Balance
vendors__billaddr OBJECT vendors.BillAddr vendors.BillAddr
vendors__companyname TEXT vendors.CompanyName vendors.CompanyName
vendors__currencyref OBJECT vendors.CurrencyRef vendors.CurrencyRef
vendors__displayname TEXT vendors.DisplayName vendors.DisplayName
vendors__domain TEXT vendors.domain vendors.domain
vendors__familyname TEXT vendors.FamilyName vendors.FamilyName
vendors__fax OBJECT vendors.Fax vendors.Fax
vendors__givenname TEXT vendors.GivenName vendors.GivenName
vendors__id TEXT vendors.Id vendors.Id
vendors__metadata OBJECT vendors.MetaData vendors.MetaData
vendors__middlename TEXT vendors.MiddleName vendors.MiddleName
vendors__mobile OBJECT vendors.Mobile vendors.Mobile
vendors__primaryemailaddr OBJECT vendors.PrimaryEmailAddr vendors.PrimaryEmailAddr
vendors__primaryphone OBJECT vendors.PrimaryPhone vendors.PrimaryPhone
vendors__printoncheckname TEXT vendors.PrintOnCheckName vendors.PrintOnCheckName
vendors__suffix TEXT vendors.Suffix vendors.Suffix
vendors__synctoken TEXT vendors.SyncToken vendors.SyncToken
vendors__taxidentifier TEXT vendors.TaxIdentifier vendors.TaxIdentifier
vendors__termref OBJECT vendors.TermRef vendors.TermRef
vendors__title TEXT vendors.Title vendors.Title
vendors__vendor1099 BOOLEAN vendors.Vendor1099 vendors.Vendor1099
vendors__webaddr OBJECT vendors.WebAddr vendors.WebAddr

Quickbooks other fields

The Quickbooks connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Report Date Date of the report data date
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
trialbalance__credit NUMERIC trialbalance.Credit Trial Balance Credit trialbalance
trialbalance__debit NUMERIC trialbalance.Debit Trial Balance Debit trialbalance
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20