QuickBooks

Get started with the QuickBooks connector!

Description

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

Connector Details

NameValue
PlatformQuickBooks
Auth TypeOAuth
DirectionBidirectional
Unified SchemaSupported in Accounting Unified Schema

Supported Data

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

Table NameFields
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.