Skip to main content

Mapping

Assign the chart of accounts to the structure of the P&L, Balance sheet and Cash flow statement. We call this ‘mapping’.

Updated over 2 months ago

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.

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’

  1. Identify the relevant Cash Flow class on the left (e.g., Earnings, Working Capital, Investments).

  2. Click the “+” button next to the class to open a dropdown menu of Balance Sheet or Profit & Loss options.
    ​
    ​

  3. Select the items that correspond to the chosen class (e.g., “VAT receivables” under Current Assets or “Product 1 - Revenue” under PL).

  4. Repeat for all applicable classes.
    ​
    ​

Step 3: Monitor Progress with Class Indicators

  1. As you map items, indicators (e.g., “13/13” mapped) will appear on the right to show your progress.
    ​

  2. Check these indicators to ensure all classes are properly assigned before finalizing.

Step 4: Save Your Mapping

  1. Once your mappings are complete, click “Save Mapping” in the top-right corner of the page.

  2. 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

  1. After saving your mappings, Finstack creates a complete and accurate Cash Flow Statement, accessible in the Reporting section.

  2. 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).
      ​

  3. Analyze & Export:

    1. Use the statement to analyze cash inflows/outflows, track trends, and make informed decisions.

    2. 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.

Did this answer your question?