QuickBooks (Private App)
Q
QuickBooks (Private App)

tap-quickbooks-privateapp (matatika variant)

QuickBooks Online is cloud accounting software for small businesses: income and expenses, invoices, bills and payments, and financial reports.

This connector authenticates with your own Intuit OAuth app (client ID and client secret) instead of the managed Connect to QuickBooks flow. Use it when your organisation already has an Intuit app, or needs data access to go through an app it controls.

Prerequisites

  1. Sign in at developer.intuit.com and open (or create) your app. It needs the QuickBooks Online Accounting (com.intuit.quickbooks.accounting) scope.
  2. Under Keys and credentials → Production, copy the Client ID and Client Secret. Development keys only work with sandbox companies.
  3. Open the OAuth 2.0 Playground, select your app and the com.intuit.quickbooks.accounting scope, then authorise. Add the redirect URI the Playground shows to your app's Production redirect URIs if Intuit asks for it.
  4. Sign in as a Primary admin or Company admin of the QuickBooks Online company you want to extract, and select that company. If Intuit offers a free trial instead of listing your company, that login has no access to the company - use a different login rather than starting the trial.
  5. Exchange the authorisation code for tokens, then copy the Refresh Token and the Realm ID (Company ID) into the settings here.

Notes:

  • Refresh tokens rotate. Intuit issues a new refresh token roughly every 24 hours and the previous one then stops working. The connector saves the latest refresh token automatically after each refresh, so you only enter it once.
  • Generate a refresh token just for this connector. Do not reuse a refresh token that another tool (for example an Airbyte connection) is also using - whichever tool refreshes first invalidates the other's copy.
  • If a sync fails with invalid_grant, the refresh token has expired or been revoked. Generate a new one in the Playground and update Refresh Token.

Data recovery / backfill

Incremental streams replicate on MetaData.LastUpdatedTime, bookmarked against start_date. To backfill or re-sync historical data, lower Start Date, or reset the pipeline state so the next sync restarts from Start Date. Full-table streams (company_info, preferences, tax_code, tax_rate) always re-sync completely.

These streams emit the current state of each record, not a change history. If you need history, snapshot the tables in the warehouse (for example with dbt snapshots).

Available Streams

StreamDescriptionReplicationReplication Key
accountChart of accountsIncrementalMetaData.LastUpdatedTime
billVendor billsIncrementalMetaData.LastUpdatedTime
bill_paymentVendor paymentsIncrementalMetaData.LastUpdatedTime
budgetBudget planningIncrementalMetaData.LastUpdatedTime
classCost allocation categoriesIncrementalMetaData.LastUpdatedTime
company_currencyMulti-currency supportIncrementalMetaData.LastUpdatedTime
company_infoBusiness details and settingsFull Table—
credit_memoCustomer creditsIncrementalMetaData.LastUpdatedTime
customerCustomer master dataIncrementalMetaData.LastUpdatedTime
customer_typeCustomer classificationsIncrementalMetaData.LastUpdatedTime
departmentOrganizational divisionsIncrementalMetaData.LastUpdatedTime
employeeStaff recordsIncrementalMetaData.LastUpdatedTime
estimateSales proposalsIncrementalMetaData.LastUpdatedTime
invoiceSales invoicesIncrementalMetaData.LastUpdatedTime
itemProduct/service inventoryIncrementalMetaData.LastUpdatedTime
journal_entryAccounting entriesIncrementalMetaData.LastUpdatedTime
paymentCustomer paymentsIncrementalMetaData.LastUpdatedTime
payment_methodPayment type definitionsIncrementalMetaData.LastUpdatedTime
preferencesSystem settingsFull Table—
purchasePurchase transactionsIncrementalMetaData.LastUpdatedTime
purchase_orderProcurement ordersIncrementalMetaData.LastUpdatedTime
sales_receiptPoint-of-sale transactionsIncrementalMetaData.LastUpdatedTime
tax_codeTax code groupingsFull Table—
tax_rateTax rate definitionsFull Table—
termPayment termsIncrementalMetaData.LastUpdatedTime
time_activityEmployee time trackingIncrementalMetaData.LastUpdatedTime
transferAccount transfersIncrementalMetaData.LastUpdatedTime
vendorVendor master dataIncrementalMetaData.LastUpdatedTime
vendor_creditVendor creditsIncrementalMetaData.LastUpdatedTime

account

Chart of accounts.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Namestring
SubAccountboolean
Descriptionstring
FullyQualifiedNamestring
Activeboolean
Classificationstring
AccountTypestring
AccountSubTypestring
AcctNumstring
CurrentBalancenumber
CurrentBalanceWithSubAccountsnumber
CurrencyRefstring
ParentRefstring
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

bill

Vendor bills.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
VendorRefstring
Linestring
CurrencyRefstring
TxnDatedatetime
APAccountRefstring
SalesTermRefstring
LinkedTxnstring
TotalAmtstring
DueDatedatetime
MetaDataobjectContains LastUpdatedTime — replication key
DocNumberstring
PrivateNotestring
ExchangeRatenumber
DepartmentRefstring
HomeBalancenumber
RecurDataRefdatetime
Balancenumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

bill_payment

Vendor payments.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
VendorRefstring
Linestring
TotalAmtnumber
PayTypestring
SyncTokenstring
CurrencyRefstring
DocNumberstring
PrivateNotestring
TxnDatestring
ExchangeRatenumber
APAccountRefstring
DepartmentRefstring
ProcessBillPaymentboolean
MetaDataobjectContains LastUpdatedTime — replication key
CheckPaymentstring
CreditCardPaymentstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

budget

Budget planning.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
Namestring
BudgetTypestring
BudgetEntryTypestring
StartDatestring
EndDatestring
SyncTokenstring
MetaDataobjectContains LastUpdatedTime — replication key
Activeboolean
BudgetDetailarray
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

class

Cost allocation categories.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
FullyQualifiedNamestring
domainstring
Namestring
SyncTokenstring
SubClassboolean
ParentRefstring
sparseboolean
Activeboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

company_currency

Multi-currency support.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
Namestring
Codestring
Activeboolean
domainstring
sparseboolean
SyncTokenstring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

company_info

Business details and settings.

FieldTypeDescription
Idstring
SyncTokenstring
CompanyNamestring
CompanyAddrstring
LegalAddrstring
SupportedLanguagesstring
Countrystring
Emailstring
WebAddrstring
NameValuestring
FiscalYearStartMonthstring
CustomerCommunicationAddrstring
PrimaryPhonestring
LegalNamestring
MetaDataobject
CompanyStartDatestring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetime

credit_memo

Customer credits.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
RemainingCreditnumber
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
CustomFieldarray
DocNumberstring
TxnDatedatetime
CurrencyRefstring
CustomerRefstring
ClassRefstring
Linearray
CustomerMemostring
TotalAmtnumber
Balancenumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

customer

Customer master data.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Taxableboolean
BillAddrstring
ShipAddrstring
Jobboolean
BillWithParentboolean
GivenNamestring
MiddleNamestring
FamilyNamestring
Suffixstring
Titlestring
WebAddrstring
ParentRefstring
Mobilestring
Notesstring
PaymentMethodRefstring
OpenBalanceDatedatetime
CustomerTypeRefstring
SalesTermRefstring
DefaultTaxCodeRefstring
Balancenumber
BalanceWithJobsnumber
CurrencyRefstring
PreferredDeliveryMethodstring
IsProjectboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
FullyQualifiedNamestring
CompanyNamestring
DisplayNamestring
PrintOnCheckNamestring
Activeboolean
PrimaryEmailAddrstring
PrimaryPhonestring
AlternatePhonestring
Faxstring
PrimaryTaxIdentifierstring
TaxExemptionReasonIdstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

customer_type

Customer classifications.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Namestring
SyncTokenstring
Activeboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

department

Organizational divisions.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Namestring
SyncTokenstring
Typestring
ParentRefstring
Activeboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
FullyQualifiedNamestring
SubDepartmentboolean
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

employee

Staff records.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
DisplayNamestring
PrintOnCheckNamestring
MetaDataobjectContains LastUpdatedTime — replication key
BillableTimeboolean
HiredDatestring
domainstring
sparseboolean
PrimaryAddrstring
GivenNamestring
FamilyNamestring
Activeboolean
V4IDPseudonymstring
PrimaryPhonestring
SyncTokenstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

estimate

Sales proposals.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
DocNumberstring
SyncTokenstring
domainstring
TxnStatusstring
BillEmailstring
TxnDatestring
TotalAmtstring
CustomerRefstring
ShipAddrstring
ProjectRefstring
PrintStatusstring
BillAddrstring
sparseboolean
EmailStatusstring
Linestring
ApplyTaxAfterDiscountboolean
CustomFieldarray
Idstring
TxnTaxDetailstring
MetaDataobjectContains LastUpdatedTime — replication key
timestring
LinkedTxnstring
ShipFromAddrstring
CurrencyRefstring
ShipDatestring
ClassRefstring
SalesTermRefstring
TxnIdstring
TxnTypestring
TxnLineIdstring
GlobalTaxCalculationstring
AcceptedDatestring
ExpirationDatestring
TransactionLocationTypestring
DueDatestring
PrivateNotestring
CustomerMemostring
AcceptedBystring
ExchangeRatestring
DepartmentRefstring
ShipMethodRefstring
RecurDataRefstring
TaxExemptionRefstring
HomeTotalAmtstring
FreeFormAddressboolean
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

invoice

Sales invoices.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
AllowIPNPaymentboolean
AllowOnlinePaymentboolean
AllowOnlineCreditCardPaymentboolean
AllowOnlineACHPaymentboolean
Idstring
BillEmailstring
BillEmailCcstring
BillEmailBccstring
SalesTermRefstring
ShipMethodRefstring
ShipDatedatetime
TrackingNumstring
Depositnumber
PrintStatusstring
MetaDataobjectContains LastUpdatedTime — replication key
CustomFieldarray
DocNumberstring
TxnDatedatetime
CurrencyRefstring
CustomerRefstring
CustomerMemostring
ClassRefstring
Linearray
PrivateNotestring
BillAddrstring
ShipAddrstring
TxnTaxDetailstring
FreeFormAddressboolean
ShipFromAddrstring
TotalAmtnumber
DueDatedatetime
ApplyTaxAfterDiscountboolean
Balancenumber
ExchangeRatenumber
HomeBalancenumber
HomeTotalAmtnumber
LinkedTxnstring
DepartmentRefstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

item

Product/service inventory.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Namestring
Activeboolean
FullyQualifiedNamestring
ReorderPointnumber
SubItemboolean
ParentRefstring
QtyOnHandnumber
Taxableboolean
UnitPricenumber
Typestring
IncomeAccountRefstring
PurchaseCostnumber
PurchaseTaxCodeRefstring
InvStartDatedatetime
TrackQtyOnHandboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
PrefVendorRefstring
Skustring
Barcodestring
Descriptionstring
PurchaseDescstring
ExpenseAccountRefstring
ClassRefstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

journal_entry

Accounting entries.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Adjustmentboolean
TotalAmtnumber
HomeTotalAmtnumber
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
DocNumberstring
TxnDatedatetime
CurrencyRefstring
ExchangeRatenumber
Linearray
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

payment

Customer payments.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
TotalAmtnumber
CustomerRefstring
SyncTokenstring
CurrencyRefstring
PrivateNotestring
PaymentMethodRefstring
UnappliedAmtnumber
DepositToAccountRefstring
ExchangeRatenumber
Linearray
TxnSourcestring
ARAccountRefstring
TxnDatestring
CreditCardPaymentstring
MetaDataobjectContains LastUpdatedTime — replication key
TaxExemptionRefstring
PaymentRefNumstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

payment_method

Payment type definitions.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Namestring
SyncTokenstring
Typestring
Activeboolean
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

preferences

System settings.

FieldTypeDescription
EmailMessagesPrefsstring
ProductAndServicesPrefsstring
AccountingInfoPrefsstring
SalesFormsPrefsstring
VendorAndPurchasesPrefsstring
TaxPrefsstring
OtherPrefsstring
sparseboolean
CurrencyPrefsstring
Idstring
MetaDataobject
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetime

purchase

Purchase transactions.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
PrivateNotestring
PaymentTypestring
MetaDataobjectContains LastUpdatedTime — replication key
RemitToAddrstring
CurrencyRefstring
ExchangeRatenumber
TotalAmtnumber
PrintStatusstring
AccountRefstring
Idstring
EntityRefstring
TxnDatedatetime
domainstring
Creditboolean
DocNumberstring
Linestring
PurchaseExstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

purchase_order

Procurement orders.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
EmailStatusstring
POStatusstring
domainstring
sparseboolean
SyncTokenstring
MetaDataobjectContains LastUpdatedTime — replication key
CustomFieldarray
DocNumberstring
TxnDatestring
CurrencyRefstring
ExchangeRatestring
LinkedTxnarray
Linearray
VendorRefstring
APAccountRefstring
TotalAmtstring
Memostring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

sales_receipt

Point-of-sale transactions.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
MetaDataobjectContains LastUpdatedTime — replication key
CustomFieldarray
DocNumberstring
TxnDatedatetime
CurrencyRefstring
CustomerRefstring
Linearray
FreeFormAddressboolean
ShipFromAddrstring
TotalAmtnumber
ApplyTaxAfterDiscountboolean
PrintStatusstring
Balancenumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

tax_code

Tax code groupings.

FieldTypeDescription
Idstring
Namestring
PurchaseTaxRateListstring
SalesTaxRateListstring
TaxGroupstring
Taxablestring
Activestring
Descriptionstring
Hiddenstring
MetaDataobject
TaxCodeConfigTypestring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetime

tax_rate

Tax rate definitions.

FieldTypeDescription
Namestring
SyncTokenstring
RateValuestring
AgencyRefstring
SpecialTaxTypestring
EffectiveTaxRatestring
DisplayTypestring
TaxReturnLineRefstring
Activeboolean
OriginalTaxRatestring
Descriptionstring
Idstring
MetaDataobject
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetime

term

Payment terms.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
Namestring
SyncTokenstring
DiscountPercentnumber
DiscountDaysnumber
Activeboolean
Typestring
MetaDataobjectContains LastUpdatedTime — replication key
DayOfMonthDuenumber
DiscountDayOfMonthnumber
DueNextMonthDaysnumber
DueDaysnumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

time_activity

Employee time tracking.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
HourlyRatenumber
CustomerRefstring
Taxableboolean
Descriptionstring
Minutesnumber
MetaDataobjectContains LastUpdatedTime — replication key
ItemRefstring
Idstring
domainstring
TxnDatedatetime
EmployeeRefstring
BillableStatusstring
NameOfstring
ClassRefstring
Hoursnumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

transfer

Account transfers.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
ToAccountRefstring
Amountnumber
FromAccountRefstring
SyncTokenstring
PrivateNotestring
TxnDatestring
TransactionLocationTypestring
MetaDataobjectContains LastUpdatedTime — replication key
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

vendor

Vendor master data.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
SyncTokenstring
Titlestring
GivenNamestring
MiddleNamestring
Suffixstring
FamilyNamestring
PrimaryEmailAddrstring
DisplayNamestring
OtherContactInfoarray
APAccountRefstring
TermRefstring
Sourcestring
GSTINstring
T4AEligibleboolean
Faxstring
BusinessNumberstring
CurrencyRefstring
HasTPARstring
TaxReportingBasisstring
Mobilestring
PrimaryPhonestring
Activeboolean
AlternatePhonestring
MetaDataobjectContains LastUpdatedTime — replication key
sparseboolean
Vendor1099boolean
CostRatestring
BillRatestring
WebAddrstring
T5018Eligibleboolean
CompanyNamestring
VendorPaymentBankDetailstring
TaxIdentifierstring
AcctNumstring
GSTRegistrationTypestring
PrintOnCheckNamestring
BillAddrstring
Balancenumber
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

vendor_credit

Vendor credits.

Supports incremental replication using MetaData.LastUpdatedTime.

FieldTypeDescription
Idstring
Balancestring
domainstring
sparseboolean
SyncTokenstring
MetaDataobjectContains LastUpdatedTime — replication key
DocNumberstring
TxnDatestring
DepartmentRefstring
CurrencyRefstring
ExchangeRatestring
PrivateNotestring
Linearray
VendorRefstring
APAccountRefstring
TotalAmtstring
MetaData.CreateTimedatetime
MetaData.LastUpdatedTimedatetimeReplication key

Settings

Client ID

The Production Client ID of your Intuit OAuth app.

Client Secret

The Production Client Secret of your Intuit OAuth app.

Refresh Token

A refresh token issued to your Intuit OAuth app, for example from the Intuit OAuth 2.0 Playground. Intuit rotates it roughly every 24 hours; the connector saves the latest value automatically.

Realm ID

The Company ID of the QuickBooks Online company to extract.

Start Date

The earliest record date to sync, in ISO-8601 format (e.g. 2024-01-01T00:00:00Z).

Sandbox

Enable to extract from a QuickBooks sandbox company (requires your app's Development keys).

Include Inactive

Include records made inactive in QuickBooks (Active is false) for entities such as Customer, Vendor, Item and Account. Deleting one of these in QuickBooks makes it inactive. Turning this on for an existing pipeline only picks up records that change afterwards, so run a full refresh to load records that were already inactive.

Capture Deletes

Capture records deleted in QuickBooks (such as invoices, bills and payments) using the Change Data Capture endpoint. Deleted records are loaded with only Id, MetaData and _sdc_deleted_at set, so use a store that deletes rows with _sdc_deleted_at set; otherwise the row is kept with its other columns emptied. Starts from the second sync, and QuickBooks only keeps 30 days of changes, so sync at least that often.

Meltano Cloud Connector

QuickBooks (Private App) connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano Cloud?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Ingest & transform data with AIConnect Claude or any MCP-compatible assistant to Meltano Cloud. Add connectors, run pipelines, build dbt models and diagnose failed runs in plain English, against the same Git-backed project your team works in.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.