Connect AI Squared to Intuit QuickBooks

This guide will help you configure the Intuit QuickBooks Connector in AI Squared to access and transfer data from your Intuit QuickBooks database.

Prerequisites

Before proceeding, ensure you have the required client id, client secret, realm id, and refresh token from your Intuit QuickBooks database.

Step-by-Step Guide to Connect to your Intuit QuickBooks Database

Step 1: Navigate to Intuit QuickBooks Database

Start by logging into your Intuit QuickBooks Console.

  1. Sign in to your Intuit QuickBooks account at Intuit QuickBooks Console.

Step 2: Locate Intuit QuickBooks Configuration Details

Once you’re in the Intuit QuickBooks console, you’ll find the necessary configuration details:

  1. Client ID, Client Secret, Realm ID, and Refresh Token:
    • Click the My Hub dropdown menu on the top-right of the Intuit QuickBooks Console then click Playground.
    • Once in Playground follow the steps to retrive your Client ID, Client Secret, Realm ID, and Refresh Token and note them down.

Step 3: Configure Intuit QuickBooks Connector in Your Application

Now that you have gathered all the necessary details, enter the following information in your application:

  • Client ID: The unique identifier for your QuickBooks application. This is issued by Intuit when you register your app in the QuickBooks Developer Portal.

  • Client Secret: A secure secret key associated with your Client ID. Used together with the Client ID to authenticate your app when requesting OAuth tokens.

  • Realm ID: A unique identifier for a QuickBooks company (also known as the Company ID). Required to make API requests specific to that company account.

  • Refresh Token: A long-lived token used to obtain a new access token when the current one expires. This is essential for maintaining a persistent connection without requiring the user to re-authenticate.

Step 4: Test the Intuit QuickBooks Connection

After configuring the connector in your application:

  1. Save the configuration settings.
  2. Test the connection to Intuit QuickBooks database from your application to ensure everything is set up correctly.
  3. Run a test query or check the connection status to verify successful connectivity.

Your Intuit QuickBooks connector is now configured and ready to query data from your Intuit QuickBooks database.

Supported sync modes

ModeSupported (Yes/No/Coming soon)
Incremental syncYES
Full refreshComing soon

This guide will help you seamlessly connect your AI Squared application to Intuit QuickBooks Database, enabling you to leverage your database’s full potential.