Description

Time tracking & scheduling solution that makes payroll, invoicing, and job costing a breeze.

Connector Details

Name	Value
Platform	QuickBooks
Auth Type	OAuth
Direction	Bidirectional
Unified Schema	Supported in Accounting Unified Schema

Supported Data

See the table below for the list of data you can read with the QuickBooks connector.

Table Name	Fields
Invoice	AllowIPNPayment, AllowOnlinePayment, AllowOnlineCreditCardPayment, AllowOnlineACHPayment, Id, MetaData, CustomField, DocNumber, TxnDate, CurrencyRef, CustomerRef, Line, FreeFormAddress, ShipFromAddr, DueDate, TotalAmt, ApplyTaxAfterDiscount, PrintStatus, Balance
SalesReceipt	Id, MetaData, CustomField, DocNumber, TxnDate, CurrencyRef, CustomerRef, Line, FreeFormAddress, ShipFromAddr, TotalAmt, ApplyTaxAfterDiscount, PrintStatus, Balance
Account	Name, SubAccount, Description, FullyQualifiedName, Active, Classification, AccountType, AccountSubType, AcctNum, CurrentBalance, CurrentBalanceWithSubAccounts, CurrencyRef, Id, MetaData
Customer	Taxable, BillAddr, ShipAddr, Job, BillWithParent, Balance, BalanceWithJobs, CurrencyRef, PreferredDeliveryMethod, IsProject, Id, MetaData, FullyQualifiedName, CompanyName, DisplayName, PrintOnCheckName, Active, PrimaryEmailAddr
Item	Name, Active, FullyQualifiedName, Taxable, UnitPrice, Type, IncomeAccountRef, PurchaseCost, TrackQtyOnHand, Id, MetaData
CreditMemo	RemainingCredit, Id, MetaData, CustomField, DocNumber, TxnDate, CurrencyRef, CustomerRef, Line, CustomerMemo, TotalAmt, Balance
JournalEntry	Adjustment, TotalAmt, HomeTotalAmt, Id, MetaData, DocNumber, TxnDate, CurrencyRef, ExchangeRate, Line
Purchase	PrivateNote, PaymentType, MetaData, RemitToAddr, CurrencyRef, ExchangeRate, TotalAmt, PrintStatus, AccountRef, Id, EntityRef, TxnDate, domain, Credit, DocNumber, Line, PurchaseEx
TimeActivity	HourlyRate, CustomerRef, Taxable, Description, Minutes, MetaData, ItemRef, Id, domain, TxnDate, EmployeeRef, BillableStatus, NameOf, ClassRef, Hours
ProfitAndLossDetailReport	Date, TransactionType, Num, Name, Memo, Split, Class, Amount, Balance, Categories

Credentials Setup

Follow the steps below to get the credentials you need to use the QuickBooks connector.

To create a QuickBooks OAuth app, you will need to register for a free developer account on the Intuit Developer Portal.

Once you have registered for an Intuit Developer account, you should be able to access the Developer Dashboard which should look something like below:

From here, you can create an OAuth app by selecting Create an app. Select QuickBooks Online and Payments as the platform you want to develop for, as pictured below:

You will then need to provide an app name, scope, and select the teamt o access the app. hotglue integrations generally do not deal with QuickBooks Payments, so you can just select the com.intuit.quickbooks.accounting scope as pictured below:

Once done, select Create app. This will take you to the App settings page, where you can configure two separate sets of credentials:

Development Settings gives you credentials / settings for configuring an OAuth app to access QuickBooks Online Sandbox accounts. This is only for testing purposes.
Production Settings gives you credentials / settngs for configuring an OAuth app to access QuickBooks Online Production accounts.

For this example, I will walk through the Development Settings, as the process is the same for both. Click on Keys & credentials

You should then see a screen similar to below, where you can a Redirect URI:

From this screen, add <https://hotglue.xyz/callback> as a valid redirect URI. If you do not do this step, hotglue will not be able to make OAuth connections on your behalf. Once done, click Save

Now you can insert the client id and client secret pair from the Keys section into your hotglue QuickBooks source settings.