Quickbooks Online

Overview

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.

How to Connect

1. Log in to Grow and select ‘Settings’ under your name in the top-right corner
2. Select ‘Data Sources’ from the menu on the left and click on ‘+ Connect Data Sources`
3. Search for Quickbooks Online, and select ‘+ Connect’
4. On the new pop-up screen, you’ll need to enter your QuickBooks-Intuit credentials, then click Sign In.
5. And that’s it! Ready, Set, Build!

Building a Metric

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

Here is another example that shows how to build a "Financial Overview" metric using one of our dataset playbooks:

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’ve 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 each customer’s total open balances.
• 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. (We recommend doing this.)

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.