Skip to main content
Skip table of contents

Sandbox Connection

Overview

Follow this page to create a QuickBooks Online Sandbox company and connect it to your GoldFinch UAT org.

QuickBooks Developer Site

The QuickBooks Online sandbox can be connected to a GoldFinch sandbox for testing.  

Data from the QuickBooks Online sandbox cannot be transferred to a live QuickBooks instance.

Use your QuickBooks Online Username and Password to sign into the developer site. https://www.developer.intuit.com/

Select "Sandbox" under "API Docs & Tools".

Click "Add a sandbox company".

Add QuickBooks Online Sandbox Users

Add any client users who will be using the sandbox.

To do so, click on the sandbox from the Developer site to connect to the sandbox instance.

Open the "Manage users" page from the Settings icon.

Proceed to Add users - it is recommended to grant admin rights for testing purposes.

QuickBooks Online Sandbox Login

https://sandbox.qbo.intuit.com/app/login

Create QuickBooks App

The QuickBooks app is an application that connects QuickBooks Online to GoldFinch.

Click on "My Apps" from the developer site and click "+ Create an app".

Select "QuickBooks Online and Payments".

Name your app and select "Accounting" as the scope.

The app name should be the client company's name. For instance, you may name it GoldFinch UAT.

Click "Create app".

To look for the App that was just created, click Dashboard in the top right corner.

Install the Latest GoldFinch QuickBooks Integration Package

Contact a GoldFinch consultant to install the latest package to the client's Salesforce UAT instance.

Custom Settings - Salesforce Sandbox Instance

After the package is installed, go to Custom Settings under Salesforce Setup.

Click Manage on the Connection custom setting.

Click New to enter new connection data for the first time or Edit the existing Connection. Name the Connection "QuickBooks."

Enter the connection information and Save.

Field

Description

Name

QuickBooks

Access Token Endpoint

https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer

AccessToken Revoke Endpoints

https://developer.api.intuit.com/v2/oauth2/tokens/revoke

Authorization Code

This is populated by Salesforce after the connection is made.

Authorization Endpoint

https://appcenter.intuit.com/connect/oauth2

Client ID

*See below - copy from the QuickBooks App

Client Secret

*See below - copy from the QuickBooks App

Company Name

**See below - copy the Company ID for the sandbox from the QuickBooks Development site.

Endpoint Base Url

https://sandbox-quickbooks.api.intuit.com/v3/company/

Redirect URI

***See below

Refresh Token

This is populated by Salesforce after the connection is made.

Scope

com.intuit.quickbooks.accounting

*Client ID & Client Secret

Copy the Client ID and Client Secret from the QuickBooks App under the "Development" section in “Keys & OAuth”.

**Company Name

Copy the Company ID from the list of sandbox companies on the developer site. 

Find the Sandbox page from the menu that drops down under your login name on the Intuit Developer site.

***Redirect URI

Under Salesforce Setup, go to Company Information to find your Salesforce instance.

Replace "salesforceinstance" with the name of your instance.

https://gfqbo.salesforceinstance.visual.force.com/apex/INT_RedirectURI

Example: https://gfqbo.na124.visual.force.com/apex/INT_RedirectURI

Copy the Redirect URI to both "GoldFinch QuickBooks Custom Settings" and the QuickBooks app.

In the QuickBooks app, Development section, click Add URI, then Save.


Remote Site Settings

Remote Site Settings grant permission for your org to connect to QuickBooks sites.

Under Salesforce Setup, go to Remote Site Settings.

Click New Remote Site to create a new custom setting or Edit the existing ones.  

Remote Site Name: QBO

  1. Remote Site Name = QBO

  2. Remote Site URL = https://oauth.platform.intuit.com

  3. Active = True

Remote SiteName: QBO2:

  1. Remote Site Name = QBO2

  2. Remote Site URL =  https://sandbox-quickbooks.api.intuit.com

  3. Active = True

Make Connection in GoldFinch

In the GoldFinch QuickBooks Integration app, QuickBooks Connection tab, click Connect to QuickBooks.

Select the company, and click Next. Confirm and Connect.

Close the connection pages when you are finished, return to GoldFinch, and refresh the page.

Verify the connection was successful by checking the Refresh Token and dates.

Configure QuickBooks Online in Sandbox

Login to QuickBooks Online to make these configurations.

  • Accounts and Settings → Sales → Custom transaction numbers = On

    • Prevents duplicate sales invoice numbers.

  • Accounts and Settings → Advanced → Warn if duplicate bill number is used = On

    • Prevents duplicate bill numbers.

  • Add the “Memo” column to the Expense Transactions list. 

    • The GoldFinch Purchase Invoice Number is transferred here.

Configure GoldFinch in UAT Instance

Salesforce administrative permissions are required for this step and changes are made from the Object Manager.

Add Buttons

  • Add the Get QuickBooks Id button and "QuickBooks Id" field to the Payment Term "List View" search layout.

  • Add the Get Customer QuickBooks Id and "Get Vendor QuickBooks Id" to the Account "List View" search layout.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.