There was a problem loading the comments.

Setting up Quickbooks Integration

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

This guide walks you through the process of integrating QuickBooks Online with your TrackMIS account. This involves creating a QuickBooks Developer account, setting up an app, obtaining production keys, and entering them into TrackMIS to enable the connection.

 

Prerequisites

  • You must be an admin user in your TrackMIS tenant.

  • You need access to a valid QuickBooks Online account (or plan to use one).

  • You must create or have access to a QuickBooks Developer account.

Step 1: Create a QuickBooks Developer Account

  1. Go to the Intuit Developer Portal:
    https://developer.intuit.com/

  2. Click Sign In (top right) and log in with your Intuit credentials.
    If you don’t have one, click Sign Up and follow the prompts to create an account.

  3. After signing in, you’ll land on the My Apps dashboard.

Step 2: Create a New App

  1. Click the + Create an App button.

  2. Choose QuickBooks Online and Payments as the platform.

    AD_4nXdQ4RarlyQH2KftfIoDBVh979WI2qntamKKE5Y8syXKH95fPjC7wLrcMWAOPbkzhc4r6ofRKPdPnW8AWNFXfUWZeDoBsh9oH_tfmfWPcmRe_BNomSGrwHOEAUwyW9nwEwbLIQCweg?key=YwWMaOyFUat2ip3irheDYA

  3. Give your app a name — e.g., TrackMIS Integration.

    AD_4nXdBrN8z914Aw_maR1JnV-nkySZ1eCI_obtjAbvRp45a4Eo1e6UABgWJWS6w-rGLg1k0aTFQR21iPGpEiXBPLt_1NF27xBkP8KObDeXlxC1St_1whBXRc46m-AFogjCa-zXqVe0cdA?key=YwWMaOyFUat2ip3irheDYA

  4. Select the accounting scope.

    AD_4nXe5YfGkefLTDa1ws5WgcOELOixnHZzQ_j2PTP_haEmL_Ny3EFtEsPCEeUUiL24taopSCrg6L0DXJEdF3ZxLD6fJ5OhhISCcMMkFAX7725QRrjfSpdQD8djFVcWOwMsQvPaSZky3qg?key=YwWMaOyFUat2ip3irheDYA

  5. Click Create App.

    AD_4nXeZTChiSPrxRk2ZQ4S0XXZ2n50O0s8Bj7hS2hlPjn4_ig58ymjVck_WqAxWVMlXO1kShuH4dDfGovqbB0ZiavIYgDrbt7N-le547-n03FQDrUj6FWEflMluDpNXR2w3AemUX8o0?key=YwWMaOyFUat2ip3irheDYA

  6. Click on the Open App button. 

 

Step 3: Configure the App

Once the app is created, configure the following:

1. Keys & OAuth

  1. Navigate to the Keys & Credentials tab in your app dashboard.

  2. Navigate to the Production tab.

    AD_4nXc3slG3yBCujkyG5VNKzUt4l5YG03KW4HGf4JbbKd65qVvM0Oc43uqqNe4ox7eWyxMz7s4QJTyn5j1oNzug6MKA1O72bBpxDh5xnmw5x8Bi4VfvFro_uXkWUWvPmYe2XY_f_t1Kvw?key=YwWMaOyFUat2ip3irheDYA

  3. Complete the tasks outlined by Quickbooks.

  4. Submit the questionnaire and navigate back to Keys & Credentials. You should now be able to get the following values from the Production Settings (not Sandbox):

    • Client ID

    • Client Secret

⚠️ These keys are required for connecting TrackMIS to QuickBooks. Keep them secure.

 

2. Set Redirect URI

  1. Navigate to Settings and switch to Redirect URIs tab. Add the TrackMIS redirect URI for the Production Environment. It will look something like:

    https://<tenant>.trackmis.com/integration/quickbooks/callback

  2. Click Save after entering the URI.

 

Step 4: Enter Keys into TrackMIS

  1. Login to your TrackMIS tenant.

  2. Go to Settings > Integrations > QuickBooks.

    AD_4nXcUIh68Rdqr0ZNaqXyX1yLzJ3GF1pc1B5OMcrIBpVllLrGqTDCuardWrvODLlwf5yNhyvWMAA9iL9NKJKqZ3YygUbjFehV2on_xUDg_kCWF5cHIFbzItGagwpEQfdfSgM8r4BbQ?key=YwWMaOyFUat2ip3irheDYA

  3. Select Integration Status as Enabled

  4. Select Environment as Production

  5. Enter Client ID

  6. Select the category for Purchase Order related costs

  7. Click Connect to QuickBooks.

  8. You’ll be redirected to QuickBooks and asked to authorize the connection.

  9. Select the QuickBooks company account you want to connect, then click Authorize.

 

Step 5: Configure Integration Settings in TrackMIS

After successful authorization:

  1. Configure the Quickbooks Integration across these available tabs mapping your data in TrackMIS and Quickbooks:
    AD_4nXeWVW4iDV9Px2z3oa_SvmAQemF39ewzSvaNJdZEYg1t3oBw1nelx8LRdH8KlaOsX0AkEGxV3IMrBTu2v5VM9VDzVAjcTzRIjUa_FcVaFNqCljyJPHtkrSgpJAacq3o_2-NnkSHqXA?key=YwWMaOyFUat2ip3irheDYA

    • Default

    • Cashbooks

    • Products & Services

    • Expense Categories

    • Taxes

  2. Save your configuration.

  3. Initial sync will begin, and you’ll be able to monitor sync logs under TrackMIS > Integrations > QuickBooks > Sync Logs.

 

FAQs

Q: Can I use a sandbox app instead of production?
A: Sandbox is for testing only and connects to a demo QuickBooks company. For real data sync, production mode is required.

Q: Can I connect to more than one QuickBooks company?
A: No. Each TrackMIS tenant can connect to one QuickBooks company per integration. If you have multiple tenants, each can connect independently.

Q: How often does TrackMIS sync with QuickBooks?
A: Sync is near real-time after setup but it is only for transactions that occur after integration is enabled. 

Q: How do I see what transactions are sent to QuickBooks?
A: You can navigate to Administration > Triggers to see each transaction sent to Quickbooks. You can also manage the triggers, such as manually resolving failed transactions.


Share via
Did you find this article useful?  

Comments

Add Comment

Replying to  

CAPTCHA

On-Premise Help Desk Software by SupportPal
© Data Converged