How do I create a new custom structure to organize my financial accounts in the Financial Data Model?
Once your ERP connection is initialized, your raw data tables are available within FloQast. However, this raw data needs to be converted into a rollup structure to create your Balance Sheet and Income Statement reports in Report Builder.
A Dimension Grouping bridges this gap by serving as the master structural skeleton for your data.
Follow these steps to create a Dimension Grouping:
- Navigate to Admin Settings (1) → Financial Data Model (2).
- In the left panel, locate the Dimension Grouping (3) section and click + Create (4).
On the onboarding screen, enter a logical Name (1) for your grouping (e.g., Financial Reporting) and select your Data Source (2), the initialized ERP connection, then click Next.
The next step of the set up wizard is to upload your hierarchy (roll up structure). You can download FloQast's default Roll-up Structure template (1) if you don't already have one.
The template defines your hierarchy, Level 1 is your top-level category (e.g., Balance Sheet), Level 2 is a subsection (e.g., Current Assets), Level 3 is your account grouping (e.g., Cash and Cash Equivalents), and so on. Note: Account mapping does not happen on this sheet; you are only designing the category labels and hierarchy here.
Once you’ve updated the template, or have an existing file, you will upload it (1) and click Process File (2)
Your new Dimension Grouping will appear in the left panel as a Draft (1), indicating the hierarchy is built but accounts have not been mapped
With your Dimension Grouping created and your hierarchy uploaded, the next step is assigning your GL accounts to it. Up next: Financial Data Model: Manual Mapping vs. Mapping Rules.
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.