Connecting To QuickBooks On-Prem using Web Connector

Step 1 - Log in to your BrightGauge Account  

If you have not created an account yet, go here to get started.

Once you have logged in:

  • For New Accounts

From the Account Overview page, click on the "Add a Datasource" button:

  • For Existing Accounts

From the Account Overview page (to access click on the BrightGauge logo on the top left-hand corner), click on the green "+" towards the bottom right of the page (next to the list of your existing datasources):

Or, click on the "Data" menu on the top right-hand corner of the screen, and select "Datasources" from the drop-down menu:

 

Now click on “Add a New Datasource” and then click on the "Quickbooks Web Connector" icon: 

Image_2018-08-23_at_2.30.42_PM.png

 

 Step 2 - Configure the Datasource Settings

Image_2018-08-23_at_2.35.57_PM.png

We'll need some information on your current setup to get started. Please be sure to fill this in EXACTLY as mentioned below, or you will run into issues with the connection process.


A) Name: This will be the name the datasource will have within BrightGauge. This is for your reference only.

B) File Path: Please enter the full file path to the Quickbooks company file as you would access it from the machine that has the Quickbooks Web Connector installed. This needs to match the file path that the Quickbooks client is already using. The easiest way to get this is by launching Quickbooks (without logging into the company file) and seeing the path it lists there:

qb_client.png

You will need to include the FULL file path including the file name (and extension). In the end, the path for the file pictured above would look like this format:

C:\Users\Public\Documents\Intuit\Quickbooks\Sample Company Files\Quickbooks 2015\sample_service-based business.qbw

Please be sure not to include any extra spaces, characters, symbols etc.

C) Password: Please create a password for the web connector integration to use. Please be sure to DOCUMENT THIS PASSWORD! This is NOT the password to your company file, nor your BrightGauge password; please do not use either of these. This is a new password that you are creating solely for the purpose of authenticating the datasource and the web connector. You will need this again in a few minutes.

 

Once filled in - click on save. 

 

Step 3 - Configure Web Connector

A) Click on the datasource again, there will now be a link to download an installation file:

Image_2018-08-23_at_2.42.30_PM.png

You will want to move this file to the machine where the web connector is installed, but please DO NOT OPEN IT YET. This machine must have the Quickbooks client installed on it, as well as the latest version of the web connector.

B) Open up Quickbooks and login to the company file as the "Admin" user within the desired company file and switch over to single user mode.

C) Once logged in to the client, go ahead and double click on the file you downloaded earlier. This will prompt the following authentication window to appear within the Quickbooks client:

auth.png

Please select the "Yes, always allow access even if Quickbooks is not running", Select the "Admin" user from the drop-down, and click continue.

D) The BrightGauge application will then appear within the Web Connector itself. 

unnamed.png

Check the box to the left to select the BrightGauge entry, and then click on ‘Update Selected’. You will then be prompted to enter the password you created earlier on the datasource page during STEP 2C above.

E) Click "save". Once it runs successfully, it should look like this:

Image_2018-08-23_at_2.59.20_PM.png

Note: Please do not edit the sync interval (titled “Every-Min”) on the web connector, as changing the interval from the original default setting WILL BREAK the integration.

F) You can switch the company file back to "multi-user" mode, log off from the company file and exit the Quickbooks client.

 

Step 4 - Kick-Off Initial Dataset Sync

For this last step, you'll need to go to your datasets page. You will see new datasets for the Quickbooks Web Connector integration:

Image_2018-10-25_at_9.07.28_AM.png

You will need to click on each of them and manually click the sync button within:

Image_2018-10-25_at_9.54.47_AM.png

This is only required for this initial setup, after that the datasets will sync automatically.

 

That's it! You're now connected to BrightGauge.

 

For additional information, please check out our support forums here.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments