Skip to main content

Excel & CSV uploads

How to upload a static file to Finstack

Updated over 2 weeks ago

1. Introduction

Finstack supports uploading a static file (from Excel or CSV) as a data source. This method is suitable for ERPs that do not have a direct integration with Finstack yet. Excel uploads are on trial-balance level: per GLA, per month. CSV uploads are lower level: having the granularity of transactions.
​

2. Step-by-Step Guide

To upload a static file:

  1. Use the “+ Add source” button in the top-right corner of the Sources page.

  2. Select "Excel file" or "CSV file" from the available options.

Excel uploads

Excel uploads are on trial-balance level: per GLA, per month. As these values are totals (roll-ups) there will not be a drill-down in Reporting. This method is relatively easy to construct, as almost all ERPs support an export on this level.

Select “Excel-file” from the options.

  1. Use the provided template to input your data.

    • Find the template next to "Need a template?"

    • The granularity is per month, per General Ledger Account (GLA)

    • Provide the following details (top-left):

      • Entity Name: Assign a name for reporting purposes.

      • Currency: Choose the currency (e.g., EUR, USD).

      • First reporting month: Select which month the sheet should start. If you want to apply an opening balance for the BS, use the month before the Actuals start (eg. Dec-25 before starting 2026).
        ​

  2. Start filling in the values. Make sure to:

    1. Apply the correct sign. For the PL, we expect negative values for income and positive values for costs. For the BS, we expect negative values for liabilities and positive for assets.

    2. Use mutations for BS accounts.

    3. The PL needs to align with the BS and tour sheet needs to have a zero-sum.
      See the Check at the top of the file to ensure all values sum up to zero. Make sure the Result is processed or use current year earnings on the BS.

      1. You can use the end-year column (eg. Eoy-25) to equalise the PL rows at the end of the year. Apply a -SUM of the row to 'empty' the GLA. Next, apply a SUM of the end-year column to a GLA corresponding to the processing of last year's result on the BS.

  3. If you want to upload multiple entities at once: just add a new tab with the same format, while populating the entity name and currency top left.

  4. Upload the File: Press "Confirm" to upload your completed file.

    • Note: If the upload fails, the warning message will indicate potential issues. For further assistance, use the support chat interface within Finstack.

Adding new values by Excel

Select "Upload new file" on the right. You will see an overview of earlier files and can upload a new file top right. For Excel uploads, we expect the full history. This means for every new month you will need to reupload all values.

Removing an Excel upload

You can delete an earlier Excel upload by using the "garbage"-icon on the right. Be warned that all data will be removed, including an earlier mapping.

CSV uploads

CSV uploads are on transaction level. This means they have more granularity (eg. multiple rows per date, including fields like Supplier) and drill-downs in Reporting are supported.

💡 For CSV uploads, you can upload files side-by-side, meaning you can add new values for a new month next to existing data. The challenge here is not to have overlap (duplicate values). There is currently a max of 20MB per upload.

  1. Select “CSV file” from the options.
    ​

  2. Provide the following details:

    • Entity Name: Assign a name for reporting purposes.

    • Currency: Choose the currency (e.g., EUR, USD).

    • CSV Format: Select the required format (currently, we support a limited amount of formats). To request support for other formats, use the chat interface within Finstack.

  3. Click “Upload CSV file” and select the file from your computer.

  4. Confirm the upload, and the system will process the file for reporting use. If an error occurs, a message will show what happened. This is usually an issue with the format of the file.

  5. When you want to upload multiple files with different timeframes, select "Upload new file" and subsequently "Add file" on the right hand side.

Adding new values by CSV

Select "Upload new file" on the right. You will see an overview of earlier files. Choose between:

  • "Add-file" (on the right) to add a file next to existing files

  • "Upload new version" (top right) to replace all earlier data

Removing an CSV upload

You can delete a set of CSV uploads by using the "garbage"-icon on the right. Be warned that all data will be removed, including an earlier mapping. Within the overview behind "Upload new file" you can also remove individual CSV files.

Pro Tips

  • Ensure your CSV data matches the required format for seamless uploads.

  • Properly name and categorize entities to simplify reporting and improve clarity.

3. Next Steps

  1. Configure Your Structure

    Navigate to Setup > Structure to organize your Profit & Loss, Balance Sheet, and Cash Flow statements. Customize classes or formulas as needed to fit your financial reporting needs. For more details, see Structure Help Page.

  2. Map Your Data

    Go to Setup > Mapping to assign your GLAs to the correct financial classes. Ensure all GLAs are mapped for balanced reports. For step-by-step instructions, see Mapping Help Page.

Once completed, your data will be fully integrated into your reports.

Did this answer your question?