Mapping Unassigned Accounts in Catalyst

Understanding Unassigned Accounts

Sometimes you may notice that data from your ERP system isn’t showing up in your Catalyst Excel cube. One of the most common reasons is unassigned accounts. Any amounts tied to these accounts remain hidden until they are mapped into the proper hierarchy buckets.

This guide walks you through how to find and map unassigned accounts in Catalyst. Whether your data is loaded through overnight automation or manual uploads, mapping ensures that your reports remain accurate and complete.

For more context on staying ahead of unassigned accounts, see our related guide: Business Owners and Unassigned Account Notifications.

Requirements

To map accounts, you must either:

• Be a Business Owner for the hierarchy you’re working in, or

• Be a Client Admin with full rights.

Step 1: Locate Unassigned Accounts

1. In Catalyst, go to Administration > Site Management > Hierarchy > Edit Account Hierarchy.

2. Switch to the Export/Upload tab.

3. Filter to the company you want to review.

4. Under Options, choose Unassigned and click Apply.

You can also view unassigned accounts in the Tree View tab if you prefer a hierarchical display.

Step 2: Export the List

1. From the Export/Upload tab, export the unassigned account list.

2. Open the exported file in Excel.

Step 3: Fill in the Hierarchy Levels

1. In Excel, complete the blank hierarchy levels for each unassigned account.

   • Example:
     Income Statement > Net Sales > Online Sales > Department > Account Name > Account ID

2. Use existing hierarchy names when possible to keep structure consistent.

Step 4: Upload Back into Catalyst

1. Once you’ve mapped all accounts, save the file.

2. In Excel, use the EBM Office Bridge ribbon > Upload button to push the changes back into Catalyst.

Your unassigned accounts will now appear in the proper hierarchy positions, ensuring data is visible in your Catalyst Excel cubes and reports.

Why It Matters

If your source shows data but your Catalyst cube doesn’t, unassigned accounts are often the culprit. Leaving accounts unmapped can cause:

• Missing amounts in your cubes and reports

• Inaccurate P&L or Balance Sheet rollups

• Extra cleanup work during close or review cycles

By mapping unassigned accounts regularly, you’ll keep Catalyst aligned with your ERP and maintain reliable financial reporting.

Mapping unassigned accounts is a routine maintenance task that ensures your Catalyst cubes reflect the full picture of your ERP data. If you ever notice that numbers aren’t matching up between your source and Catalyst, checking for unassigned accounts should be your first step. With just a few exports, updates, and an upload back into Catalyst, you can resolve visibility issues and keep your reporting accurate.

✅ Next Step: To get proactive alerts about new unassigned accounts, see Business Owner Notifications.