Connecting to QuickBooks Online

This document is a step-by-step guide for setting up the QuickBooks integration within BrightGauge.

 

Step 1 - Ensure Integration Requirements Are Met

  • You can only authorize access to a QuickBooks company if you are the Master Administrator or a Company Administrator.
  • There can only be one user at a time connected to a given company. Click here for more information on how to transfer to another user.

 

Step 2 - Log in to your BrightGauge Account

If you haven’t created an account yet, go here to get started.

Once logged in: 

  • New Accounts

On first login, click Add a Datasource.

  • Existing Accounts

From the account Overview page (to access click on the BrightGauge logo on the top left-hand corner), click on Add a new Datasource towards the bottom right of the page (next to the list of your existing datasources):

AddNewDatasourceBottomRight.gif

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

AddingANewDatasource.gif

Locate the datasource under either All or Finance

 

Step 3 - Authenticate with QuickBooks Online

Now we need to authenticate with QuickBooks Online.

  1. Click Connect to QuickBooks.

    Image_2018-11-19_at_1.47.35_PM.png

  2. If not currently logged into QuickBooks, a window opens asking you to log in. Please ensure you've logged in with a user that has view access for customer information, otherwise the integration may fail with inadequate permissions. If already logged in, please skip to step 4.
  3. Provide the code required with two-step verification.
  4. Authorize BrightGauge to speak with your QuickBooks company file. After authentication, the window closes and a successful test connection shows in BrightGauge.
  5. Name the datasource (by default it says QuickBooks Online).
  6. Click Save.

Dashboards, reports, datasets, and gauges will be added to your account after the datasource is saved. They will start syncing immediately and typically complete syncing after 20-30 minutes. 

 

Your Default Dashboards

  • BGS - COGS Detail
  • BGS - Expenses Detail
  • BGS - Financial Overview
  • BGS - Revenue Detail

Your Default Reports

  • BGS - Financial Performance
  • Monthly Expenses Review
  • Quarterly P&L Review
  • Weekly Account Review

Your Datasets

  • BillsInformation on bills within Quickbooks
  • Bills Line Item Detail - Information on line items within bills
  • CustomersA dataset to look at Customers and related details including their current balances
  • GL Accounts - This shows current information for all accounts displayed in the chart of accounts for your Quickbooks setup
  • Invoice Line Item Detail - Line Item Information on Invoices
  • Invoices Information on invoices from your Quickbooks setup. Invoices dated within the last 730 days
  • Journal Entries Last 365 Days All Journal Entries entered into Quickbooks with the transaction date in the last 365 days
  • Profit and Loss Detail Profit and Loss from the current and previous calendar years.

For a list of all default gauges, please visit the Gauges section of your account, sort by the Datasource you'd like to see, and select for Default.  

If you have any questions, please contact Support by selecting Help > Open a Ticket from the top menu bar.

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

Comments

0 comments