Skip to main content

KPIs

Configure and populate KPIs that you can use elsewhere in Reporting.

Updated over a week ago

💡Find the Sheet integration section here.

Overview

Finstack’s KPI feature enables you to configure and track KPIs at both the group and entity levels. Manage KPI data across entities to streamline performance monitoring.

Key Benefits

  • Entity-Specific KPIs: Tailor KPIs to specific entities or groups of entities.

  • Efficient Configuration: Populate data manually or via Excel import.

  • Dynamic Reporting: Filter KPIs by entities for clear insights.

Getting started

Step 1: Access KPI Configuration

  1. Navigate to Setup > KPIs.

  2. View and manage existing KPIs or create new ones.

Step 2: Create or Modify KPIs

  1. Click Create new KPI to add a KPI.


    ​

  2. Update the KPI’s:

    • Name: Click the text field to edit.

    • Type: Select Currency, Number, or Percentage.

    • Reposition/Delete: Use the arrow or trash icon.
      ​


      ​

Step 3: Assign KPIs to the entire group or specific entities

  1. Apply KPIs to the Entire Group

    • Leave the entity filter at the default: Filtered Entities.

      Note: This setting integrates with the entity filter in Reporting, ensuring that formulas are filtered accordingly for consistency.
      ​

  2. Assign KPIs to Specific Entities

    To organize KPIs for individual entities, group them under a KPI Group using the “Title” type:

  • Create a KPI Group Title:

    • Click Create new KPI.

    • Name it (e.g., “KPIs for Entity 1”).

    • Select “Title” from the KPI type dropdown.

    • Assign the Title to the relevant entity (e.g., FinStack X1)
      ​

  • Add specific KPIs under the Title:

    • Click Create new KPI.

    • Name the KPI (e.g., “FTE Entity 1”).

    • Assign it to the same entity (e.g., FinStack X1).

    • Populate KPI values for each month.
      ​

Step 4: Populate KPI Values

  • Manual Entry:

    • Enter values directly or paste data row-by-row using Ctrl+C and Ctrl+V.
      ​

  • Import Values via Excel:

    1. Download the Excel template, by clicking “Import”, then “Export current KPIs”
      ​

    2. Update the values within the template (note: instructions are provided at the top of the sheet).
      ​

    3. Upload the completed file back into Finstack.
      ​

Note: Working with formulas

  1. Import behaviour

    • Imported data only overrides static values.

    • Formulas are preserved and remain unaffected by the import process.

    • Formula cells in the template are greyed out to indicate they should not be edited.
      ​

  2. Adding formulas

  • Click on a cell to access the Fx field and input your formula.

  • Start typing to reference a class (e.g., mapped data from PL, BS, CFS, or another KPI). The field will auto-suggest relevant options.
    ​

  • Use the blue dropdown to filter by entity, if applicable.
    ​

  • Add arithmetic symbols (+, ***** ****, /) as needed, then press Enter to confirm.

  • Remember, formulas apply to the entire row and may overwrite existing values.

  • Once complete, click Save to apply the changes.

Selecting Another Timeframe

  • Use the calendar icon in the top-right corner to limit the display to specific months, quarters, or years.
    ​

Step 5: View KPIs in Reporting

  1. Navigate to Finance > Reporting > KPIs.

  2. Use the Entity Filter to focus on KPIs for specific entities.

  3. Dynamically display populated KPI values based on the selected entity or group.
    ​

Tips

  • Combine Manual and Imported Data: Use manual entry for quick updates and Excel for bulk uploads.

  • Efficient Filtering: Toggle between entities for a consolidated or granular view.

Connecting a Google Sheet

💡This functionality is in beta. If you face issues, please reach out to support.

Besides the options to manually populate the KPIs or import them through an Excel upload, you can also decide to connect a Google sheet. This will allow you to maintain all values in a sheet and publish them to Finstack. You can use the full flexibility of a sheet, for example by using multiple tabs for calculations and collaborating with your team by sharing the sheet.

Step 1: Connecting the sheet

  1. In Setup > KPIs select Link Google Sheet on the top right

  2. Make sure you have a Google sheet available. You can create a new sheet by the shortcut "sheets.new" in your browser.

    1. Copy the service account email from Finstack and add it to your sheet (Share top right) as Editor. Select Done.

    2. Copy the URL of the sheet

  3. Back in Finstack

    1. Fill in a sheet Name

    2. Paste the copied Spreadsheet URL

    3. Select Confirm.

  4. The sheet will be linked. This will create a new tab in the sheet [Finstack] KPIs. The badge will show Active when the sheet is connected.

Step 2: Updating your values

  1. By selecting Open, you can open the sheet in Finstack.

  2. Navigate to the [Finstack] KPIs tab.

  3. You can now update the values in the cells with the white background. The cells with the grey background contain formulas. You can only upload these in Finstack.

  4. When you have updated the values, you can Publish to Finstack with the button top right.

  5. When you have made changes to your KPI structure in Finstack, you can always Reset sheet top right. This will recreate the tab.

🚨Make sure to sync changes on either side (Finstack or sheet) back to the other side, otherwise values will get out of sync.

Did this answer your question?