1. Grow
  2. Connecting to Data Sources
  3. Accounting and Financial

Quickbooks Online

Article last updated:

Quickbooks Online offers an easy way to manage your business finances and accounting. You can manage and pay bills, accept business payments, perform payroll functions, and more. The Quickbooks Online/Grow integration helps you track financial data and get improved insights into your business.

Connecting to Quickbooks Online

  1. Click on the Data tab at the top left of the global navigation. You will be brought to your Data Connections.
  2. Click on the blue Connect button, and search for QuickBooks Online.
  3. Click on the QuickBooks Online logo.
  4. A window will pop up to log in with your QuickBooks Online credentials. After entering your credentials you will see a green confirmation message that the connection has been made.
    If you didn't see a window to enter your credentials but you still got a green success message, then that means you were already logged in with your QuickBooks account, and Grow used that account to connect.

Add about Warehousing. Add the tables in the custom tables.

Data Warehousing

Quickbooks Online is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.

Custom Tables

Grow offers you the flexibility to configure your custom tables based on the dimensions, metrics, and date groupings that you see fit.

Following tables are part of the custom table templates:

  • Customer Income
  • Sales by Customer
  • Sales by Item
  • Profit and Loss
  • Balance Sheet
  • Cash Flow
  • Aged Receivables
  • Aged Payables

Building a Metric

To help get you started in using Quickbooks Online, here's a quick tutorial for building an "Accounts Receivable" metric:

Endpoints

Below are a list of the reports the Quickbooks Online/Grow integration offers, along with a short description of each. Most of these reports will include the specific custom fields for your clients.

  • Balance Sheet: Lists assets, liabilities, and equity (what you have invested in your company).
  • Profit And Loss: Also called an income statement. Compares money you earned against the money you spent, income and expenses respectively.
  • Profit And Loss Detail: Shows transaction details for both income and expenses.
  • Trial Balance: Summarizes debit and credit balances of each account on your chart of accounts during a specific time frame.
  • Cash Flow: Shows cash flow for operating activities, investments, and stock and dividends.
  • Inventory Valuation Summary: Shows SKU, quantity, and asset value and cost for your inventory items.
  • Customer Sales: Shows sales for each customer.
  • Item Sales: Summarizes sales for your items.
  • Customer Income: Shows your net income for each customer.
  • Customer Balance: Shows the total open balances of each customer.
  • Customer Balance Detail: Shows details (date, number, date due, open balance) unpaid invoices for each customer.
  • Aged Receivables: Shows unpaid invoices for the current period and up to 90 days back.
  • Aged Receivable Detail: Lists all unpaid invoices, grouped by number of days overdue, along with details (due dates, customer names, amounts, totals).
  • Vendor Balance: Shows you the amount you owe each vendor.
  • Vendor Balance Detail: Lists the details that constitute how much you owe each vendor
  • Aged Payables: Shows unpaid bills for the current period and back.
  • Aged Payable Detail: Lists all of the unpaid bills, grouped by aging period (when it was due).
  • Vendor Expenses: Shows total expenses for each vendor.
  • General Ledger: Shows transactions over a period of time for each of your accounts.
  • Budget Report: It allows you to retrieve the current state of budgets already set up in your company file.

FAQs + Tips and Tricks

Using the Budget Report

The query must be written as JSON. It's basically adding filter statements to the budget report. All properties are joined with ANDs, so you can't write any kind of OR statement. Strings (such as name) must be enclosed within single quotes.

In order to filter rows from the table in a query the user can enter the fields along with the corresponding values he wishes to filter by in the form of
{"column_name1" : value1, "column_name2" : value2 }

For example, when querying budgets by name and that are active, the user must write:
{"Active": true, "Name": 'Test Budget'}

What the above query example would do is filter the budget report to only show "Active" budgets with the name "Test Budget." It literally means Budget type = Active and Name = "Test Budget."

You can filter on the following properties: Id, Name, BudgetType and Active.

Connecting multiple instances of Quickbooks Online to Grow

Only administrators in Quickbooks Online can connect various company files to Grow. If you need to share the data, you can always share the data connection.

When you connect to Quickbooks Online, the admin will need to sign in. Once they have signed in, they can connect any one of your company files. If the admin connects one but not all, another person could use the admin login to connect other company files. However, multiple company files can be connected by one user.

For example, Grow has two company files: Grow-US and Grow-EMEA, for each of our offices. If I were the admin and was connecting for the first time, I would see both options.

At this point, I could choose to connect to the Grow, Inc. (US) file. After that file is connected, however, no one else will be able to connect that file, even if they are an admin.

Another admin could connect the Grow, Inc (EMEA) file, or I could go in and connect it at a later time. Once it has been connected, no one else will be able to connect it to Grow.

Sharing the data is easiest if an admin connects an organization's QBO instances to Grow, then shares the data connection for each company file with other company users within Grow.

Was this article helpful?