How do I use automated Mapping Rules to dynamically assign large account populations in FDM?
The Financial Data Model (FDM) gives you two ways to assign GL accounts to your dimension hierarchy: Manual Mapping and Mapping Rules. The FDM Mapping Rules engine uses conditional logic to automate account assignments, removing the need for manual one-by-one mapping. This future-proof approach is recommended for large populations, as any new accounts added to your ERP will automatically inherit the correct configuration upon syncing to FloQast.
How to Create and Manage Mapping Rules
Inside your Dimension Grouping, click Mapping Rules in the top-right area above the accounts table to open the side panel.
Click + Add Rule to expand the mapping rule setup wizard .
Set Up Mapping Rules
Follow these steps to define your rule criteria and assign your matching accounts to the target hierarchy:
- Enter a descriptive name based on its specific destination (e.g., use 'Petty Cash' rather than a broad parent category like 'Cash').
- Choose the appropriate variable for your condition, such as FQ_NUMBER, FQ_TYPE, or FQ_NAME.
- Choose your conditional operator (e.g., Between, Starts with, or list-based operators like Includes).
- Enter the specific values you want to target (e.g., Account numbers Between 1000 AND 1099).
You can combine multiple rows of criteria using AND logic by clicking + Add Condition (1).
Under Assign to (2), select the target hierarchy node where these matching accounts should roll up for example: Balance Sheet or Petty Cash. Click Apply and Save Draft to execute your active rule library against your unmapped account list.
To ensure your data is accurately reflected and to enable FloQast Report Builder and AI Variance analysis, aim to reach 100% mapping progress (1). Check the Unassigned quick filter (2) before publishing to ensure all accounts are mapped.
With your accounts mapped via manual and/or automated rules, you can proceed to Adding Secondary Dimensions (coming soon) like Departments and Cost Centers to enable reporting and variance tracking.
If you have additional questions, contact support@floqast.com.
🎓 Master FDM: Complete the interactive Centralizing and Configuring Financial Data in FloQast FDM course on FloQademy. It is CPE-eligible through the FloQast AI Variance Analysis & Reporting program.