This documentation is designed to guide you through creating and managing a Consolidated Organization in Kordis. This feature allows you to merge multiple Kordis organizations (each with their own connected QuickBooks accounts) into a single, unified view for streamlined financial analytics and reporting. Video walkthrough below
Consolidated Organizations
The Consolidated Organization feature is ideal for franchises, multi-entity businesses, or holding companies that need to see the "big picture" across several QuickBooks files while maintaining the ability to drill down into specific entities.
Prerequisites
Before you begin the consolidation process, ensure that:
You have already created Single Entity organizations for each business unit.
Each of those single entities has a linked QuickBooks integration.
Creating a Consolidated Organization
Follow these steps to group your entities:
Navigate to Business Center: Head to the Business Center in the left-hand sidebar and select Manage Organizations.
Start New Org: Click the + Create Organization button in the top right.
Select Type: Choose Consolidated Organization from the pop-up menu.
Configure the Group:
Name: Give your consolidated group a name (e.g., "Average Franchise").
Add Entities: From the "Available Organizations" list, click + Add next to each single-entity organization you wish to include.
Finalize: Click Next to begin configuring your Consolidated Organization's Chart of Accounts
Managing Your Consolidated Chart of Accounts
Once the organization is created, you are taken to the Chart of Accounts (COA) configuration screen. This allows you to map how different accounts from different QuickBooks files should appear together on both the Income Statement and Balance Sheet.
Customizing the Hierarchy
Drag & Drop: You can move accounts between categories (e.g., from Expenses to COGS) simply by dragging them.
Reclassify Menu: You can also use the Reclassify dropdown on the right side of any account row to move it to a different system-level category.
Parent-Child Relationships: Create sub-accounts by dragging one account directly underneath another. To remove the relationship, drag the child account to the left.
Handling Duplicate or Shared Accounts
If multiple entities share the same bank account or a specific account that should only be counted once:
Navigate to either the Income Statement or Balance Sheet tab within the COA manager.
Identify the duplicate account.
Click Exclude by hovering over one of the accounts.
If you change your mind, you can always click Add Back to restore it to the consolidated view.
Creating Custom Groups
You can create your own custom groupings for more tailored reporting in Financial Statements:
Click + Add Group at the top of a section (e.g., Revenue).
Name the group (e.g., "Gross Receipts").
Drag relevant accounts into this new User Generated Group.
Finalizing
Once you have your desired Chart of Accounts hierarchy, click finalize in the top right. After doing this, Kordis will begin processing your new consolidated organization. This process could take up to 10 minutes but often only takes a few minutes. We will notify you once the process is complete.
Updating
After finalizing you still have the ability to adjust your Chart of Accounts for your Consolidated Organization. Navigate to Financial Settings in the Side Bar at the bottom. You'll be able to make adjustments and then select Finalize once complete.
Note: Financial Settings are only available for Consolidated Organization.
Reporting on Consolidated Data
After clicking Finalize and completing the sync, your consolidated data is available in the Financial Statements module.
Breakdown by Organization
To see how each individual entity contributes to the total:
Navigate to Financial Statements.
Open the Breakdown menu in the top right.
Select Organization.
You will now see columns for each entity, or rows expanded to show the entity logo next to specific account values.