NetSuite already has robust support for multi-entities, typically this works out of the box with our Income Statement & Balance Sheet templates as the Subsidiary is already included.

​
How it works in Runway

Runway allows you to connect multiple instances of most integrations—including duplicate QuickBooks or Xero accounts. Once the connections are established, our CX team will work with you to label each entity appropriately and combine the data into a single database on your behalf.

Runway currently supports connecting to only one HRIS account at a time. For example, if you have two Rippling accounts, we can connect to just one of them per Runway account. If this limitation affects you, please contact us directly.

​
The SQL behind multi-entity

Our team is happy to handle this setup for you—especially if you’re not comfortable with SQL. But if you’re curious how it works or want to do it yourself, read on.

In this example, we’ll walk through combining multiple QuickBooks Online entities using SQL. The same approach applies for Xero.

  1. Follow the Fivetran setup guide for QuickBooks and install the standard QuickBooks Template to set up your first entity.

  2. Install the integration for each additional entity, but don’t apply the template again. When prompted for a schema name, use a unique identifier for each entity (e.g., quickbooks_us, quickbooks_ltd).

  3. After completing the setup, locate the Income Statement Data query from the template installed in the first step.

  4. We will need to edit this query to combine each Quickbooks Online data source and insert the matching subsidiary as a new column. Here’s an example code snippet of how to accomplish this. The key pieces to note are:

    • You’re writing one SELECT per schema.
    • You’re tagging each row with a subsidiary name.
    • You’re combining them with UNION ALL.
    WITH main_query AS (
  SELECT
    TRANSACTION_DATE AS "Transaction Date",
    ADJUSTED_CONVERTED_AMOUNT AS "Income Statement Amount",

    -- Account Info
    COALESCE(gl.account_number || ' ', '') || COALESCE(ACCOUNT_NAME, 'No Account Name') AS "GL Account Name",
    gl.ACCOUNT_NUMBER AS "GL Account Number",
    ACCOUNT_NAME AS "GL Account Name (no number)",
    ACCOUNT_TYPE AS "Account Type",
    ACCOUNT_SUB_TYPE AS "Account Subtype",
    ACCOUNT_CLASS AS "GL Category",
    FINANCIAL_STATEMENT_HELPER AS "Financial Statement Helper",

    -- Drill-in Detail 
    cu.display_name AS "Customer",
    v.display_name AS "Vendor",  
    cl.name AS "Class",
    d.name AS "Department",

    -- Parent Account
    PARENT_ACCOUNT_NUMBER AS "Parent GL Account Number",
    COALESCE(parent_account_number || ' ', '') || COALESCE(parent_ACCOUNT_NAME, 'No Account Name') AS "Parent GL Account Name",
    PARENT_ACCOUNT_NAME AS "Parent GL Name (no number)",

    'Main' AS Subsidiary

  FROM quickbooks_quickbooks.quickbooks__general_ledger gl
  LEFT JOIN quickbooks.customer cu ON gl.customer_id = cu.id
  LEFT JOIN quickbooks.vendor v ON gl.vendor_id = v.id
  LEFT JOIN quickbooks.class cl ON gl.class_id = cl.id
  LEFT JOIN quickbooks.department d ON gl.department_id = d.id

  WHERE transaction_date > '2022-12-31'
    AND financial_statement_helper LIKE '%income_statement%'
),
llc_query AS (
  SELECT
    TRANSACTION_DATE AS "Transaction Date",
    ADJUSTED_CONVERTED_AMOUNT AS "Income Statement Amount",

    -- Account Info
    COALESCE(gl.account_number || ' ', '') || COALESCE(ACCOUNT_NAME, 'No Account Name') AS "GL Account Name",
    gl.ACCOUNT_NUMBER AS "GL Account Number",
    ACCOUNT_NAME AS "GL Account Name (no number)",
    ACCOUNT_TYPE AS "Account Type",
    ACCOUNT_SUB_TYPE AS "Account Subtype",
    ACCOUNT_CLASS AS "GL Category",
    FINANCIAL_STATEMENT_HELPER AS "Financial Statement Helper",

    -- Drill-in Detail 
    cu.display_name AS "Customer",
    v.display_name AS "Vendor",  
    cl.name AS "Class",
    d.name AS "Department",

    -- Parent Account
    PARENT_ACCOUNT_NUMBER AS "Parent GL Account Number",
    COALESCE(parent_account_number || ' ', '') || COALESCE(parent_ACCOUNT_NAME, 'No Account Name') AS "Parent GL Account Name",
    PARENT_ACCOUNT_NAME AS "Parent GL Name (no number)",

    'LLC' AS Subsidiary

  FROM quickbooks_llc_quickbooks.quickbooks__general_ledger gl
  LEFT JOIN quickbooks_llc.customer cu ON gl.customer_id = cu.id
  LEFT JOIN quickbooks_llc.vendor v ON gl.vendor_id = v.id
  LEFT JOIN quickbooks_llc.class cl ON gl.class_id = cl.id
  LEFT JOIN quickbooks_llc.department d ON gl.department_id = d.id

  WHERE transaction_date > '2022-12-31'
    AND financial_statement_helper LIKE '%income_statement%'
)

SELECT * FROM main_query
UNION ALL
SELECT * FROM llc_query;

  5. Paste your updated SQL into Runway’s SQL editor and click Run query to make sure everything runs as expected.

  6. The final step is to add the new Subsidiary field to the shaped database. Navigate to the database connected to your Income Statement (labeled IS data if you used the template), click Edit, select the dropdown next to Segment by, and check Subsidiary > Confirm.

  7. That’s it! You can apply the same process to consolidate your Balance Sheet and Cash Flow databases.

​
Intercompany eliminations

When you combine multiple entities into a single dataset, what you’re really creating is a combined view—not a fully consolidated one. To build a true consolidated P&L, you’ll often want to exclude intercompany eliminations so those transactions don’t artificially inflate your totals.

The simplest way to handle this in Runway is by:

  1. Creating a lookup table that maps each GL account to a new dimension—something like Elimination Type or Is Intercompany.
  2. In that dimension, flag whether each account should be treated as an intercompany elimination.
  3. When building your consolidated P&L, just add a filter to exclude any rows where the account is flagged as an intercompany elimination.
  4. When building subsidiary-level P&Ls, you can ignore that flag entirely—this gives you the flexibility to report both combined and entity-level.

​
Multi-entity FAQ