Mapping: assigning GLAs to the reporting structure
After we have configured the reports in Setup > Structure, we are ready to assign the chart of accounts to the right classes (categories). This is done by first selecting the type of report top left and subsequently selecting one or multiple accounts on your left hand side. Selected accounts will be highlighted in blue. Deselect an account by using the “X” button that appears on mouse hover. On your right hand side, select the correct class in the structure and press the “Save mapping” button top right to store this configuration.
Note: it is only possible to map to main classes without children, or to subclasses (not derived classes, such as formulas). Some classes, such as “Result”, “Retained earnings” and “Current year earnings” are reserved by the system, so it is not possible to include these in mapping.
💡 Tip: Use the “Unmapped” tab on top to navigate to the accounts that are not mapped yet. Use the “Search” function on top center to quickly find specific accounts. The indicator top right will show how many accounts are not mapped and the size of your current selection.
💡 Tip: Note that new unmapped accounts can occur when new GLAs are added to your accounting software. We will show when you have unmapped accounts by an orange indicator in the left hand menu.
💡 Tip: It might happen that GLAs do not show transactions in recent months. You can drill-down on the value and change the calendar to look back in time. Alternatively, you can map these GLAs to a general row in your statement and diagnose from Reporting what happend in the past.
Exploration: account drill-down
For every account, the values of the current and last month are displayed. Click either of those cells to drill-down to the underlying entries. In this next screen, you are able to see the entries, including details in a side panel, when you select on of them. Use the search bar and calendar to narrow down your results. Go back using the “< Mapping” button.
Mapping: Cash flow statement
For the Cash flow statement, it is not necessary to map individual GLAs. In this exercise you reference classes to either the Balance sheet or Profit & Loss statement. This lets you:
Break Down Earnings: Assign P&L classes to Cash Flow Statement sections for clarity.
Maintain Consistency: Align mappings automatically across reports.
Spot Issues Fast: Use the ‘Difference’ indicator to resolve imbalances instantly.
Getting started with Cash Flow References
Step 1: Access the Cash Flow References Page
Navigate to Setup > Mapping from the left-hand menu.
Select the Cash Flow tab at the top of the screen.
You’ll see a structured layout of your Cash Flow Statement classes (on the left) and a mapping area (on the right).
Step 2: Map Classes to ‘Balance Sheet’ or ‘Profit & Loss Data’
Identify the relevant Cash Flow class on the left (e.g., Earnings, Working Capital, Investments).
Click the “+” button next to the class to open a dropdown menu of Balance Sheet or Profit & Loss options.
Select the items that correspond to the chosen class (e.g., “VAT receivables” under Current Assets or “Product 1 - Revenue” under PL).
Repeat for all applicable classes.
Step 3: Monitor Progress with Class Indicators
As you map items, indicators (e.g., “13/13” mapped) will appear on the right to show your progress.
Check these indicators to ensure all classes are properly assigned before finalizing.
Step 4: Save Your Mapping
Once your mappings are complete, click “Save Mapping” in the top-right corner of the page.
Need to adjust? Use the “X” button to remove any incorrectly mapped items and reassign them.
Step 5: Export or Review Your Cash Flow Statement
After saving your mappings, Finstack creates a complete and accurate Cash Flow Statement, accessible in the Reporting section.
Verify the Statement: Ensure it balances to zero. If it doesn’t, check for:
Incomplete Mappings: Confirm all classes are mapped (e.g., 13/13).
Incorrect Settings: Go to Structure > Cash Flow > Mapping Details (pencil icon) to verify "Is cash mapping" selections (e.g., ensure your bank account is correctly specified).
Analyze & Export:
Use the statement to analyze cash inflows/outflows, track trends, and make informed decisions.
Click Export (top-right) to download your statement with all mapped data.
Here is an example of what it looks like:
Pro Tips
Focus on subsets: Break down specific subsets of your PL results (e.g., operating income only) for detailed insights.
Iterate when needed: You can easily adjust or refine mappings as your reporting needs evolve.
FAQ
I can not see my mapped GLAs
Note that the filter top right by default is set to "Unmapped". You can change it to "All" (or one of the mappings) to see GLAs.
I am missing (new) GLAs
In Setup > Mapping, by default the Filter (top right) will exclude empty ledgers. Please use the toggle to also show empty (or new) GLAs.
Can I import my mapping?
No, but in case you have a mapping available in, for example, Excel, you can put the Excel sheet with the mapping side-by-side to the Finstack, so it's easy to cross-reference.
I get a warning I have unmapped accounts
In Setup > Mapping, please hover on the icon left to the structure to see what statement has an incomplete mapping. Note that unmapped accounts will usually lead to a balance sheet that does not balance, thus it is important to always map any unmapped accounts.
I changed the numbers of some accounts, or moved them from balance sheet to P&L or vice versa. Why are those changes not reflected correctly?
Most ERPs do not indicate when such changes have happened. Please request a full import via chat support to load the latest configuration. When a GLA has a new number (account_id) or it has moved from PL to BS or vice versa, it will be reflected as a new GLA and the 'old' number can still be there, yet without transactions. Therefore the new one needs to be mapped again. Be aware that all changes also have to be manually corrected in the configuration of Intercompany eliminations.