# Integrate QuickBooks with Databox

QuickBooks is accounting software that helps small and mid-size businesses manage their finances — tracking income, expenses, invoices, payroll, and financial reporting in one place. It is widely used to produce balance sheets, profit and loss statements, and cash flow reports that inform day-to-day and strategic decisions. Connecting QuickBooks to Databox makes your financial data available alongside metrics from your sales, marketing, and operations tools, so finance teams can monitor business health, track profitability, and report on financial performance in a unified view.

## Connection

### Before you begin

### Step 1: Add or choose a connection

To connect QuickBooks to your Databox account for the [first time](/add-a-connection) or with new credentials, log in using your Intuit email address, user ID, or phone number.

Intuit may prompt a human verification check during sign-in. Click **Begin** to complete the security step and continue.

intuit-sign-in
### Step 2: Select a company

If you manage multiple QuickBooks companies, you'll be prompted to select the specific company you want to connect to Databox. Click **Next** to authorize the connection.

quickbooks-company-selection
## Metric Builder

The QuickBooks integration allows you to create custom metrics using the metric builder.

quickbooks-metric-builder
To create a custom metric, select a **Report Type** and the specific **Metric** you want to track. Use the available options to configure the accounting method, add a dimension, and apply one or more filters.

The report types available for metric creation are listed below.

### Balance Sheet

The Balance Sheet report type provides a snapshot of financial position at a point in time, capturing the company's assets, liabilities, and equity. From this data, finance teams can assess solvency, monitor how total liabilities are shifting relative to assets, and track ownership equity across reporting periods.

 **In QuickBooks:** Go to **Reports** and open the **Balance Sheet** report to view the data this report type exposes.

### Profit and Loss

The Profit and Loss report type summarizes revenue, costs, and expenses over a selected period, showing how much the business earned or lost. From this data, finance teams can measure gross and net profitability, identify cost trends, and evaluate operational performance across different time frames.

 **In QuickBooks:** Go to **Reports** and open the **Profit and Loss** report to view the data this report type exposes.

## ![lock](/assets/lock.2fb1bbc208afcc03d15a0a45f22bdf7f830322016e038e5721965851130807af.419bb737.svg) Datasets

The QuickBooks integration supports the creation of [datasets](/understanding-datasets), which allow you to structure and format your QuickBooks data for more flexible reporting in Databox. By organizing your data into a tabular format, datasets make it easier to filter, segment, and visualize key metrics across projects, clients, and team members.

The entity relationship diagram (ERD) below illustrates how data is organized within the QuickBooks integration, displaying the available **views** and **columns**, as well as the relationships between them (primary and foreign keys). This diagram represents the **schema**, or structure, of the data and helps you understand the underlying data model. With this context, you can create datasets using the relevant views and columns to build custom metrics tailored to your reporting needs.

## Resources

For comprehensive details on metrics, data availability, templates, specifications, usage guidelines, and other key information, refer to the resources listed below.

No. The Databox integration is only compatible with QuickBooks Online.

Enabling this option includes unrealized gains and losses in the report data. Unrealized gains and losses arise from changes in the value of assets — such as foreign currency holdings or investments — that have not yet been sold or settled. Leave this disabled if you want to report on realized figures only.

Accrual accounting records income when it is earned and expenses when they are incurred, regardless of when cash is received or paid. Cash accounting records transactions only when cash actually changes hands. The same metric can return different values depending on the method selected, so use the method that matches how your business reports its financials.

 

Ask Genie
Get instant answers or help with your data using the in-app AI assistant.

Talk to an expert
For customers: Get help with your setup, strategy, or making the most of Databox.

Book a demo
New to Databox? See how it works and get guidance on getting started.

Send an email
Reach out to support for help with your account, data, or technical issues.