Set up a new source
Connect to your accounting software
Use the “Add source” button in the top-right corner to initiate the connection wizard.
On your first visit, you’ll be prompted to accept the terms and conditions. Review and understand the access you’re providing to Finstack.
Select the accounting software you want to connect from the list (e.g., Exact, QuickBooks, Xero).
You will be redirected to your accounting software’s login page to enter credentials and authorize Finstack.
Once authorization is complete, the connection will be set up.
Transactions will automatically load in the background. Depending on the number of transactions, this process may take some time.
🚨 Warning: Ensure you are logged into the correct account in your accounting software. This is especially important if you manage multiple accounts, as importing incorrect data can lead to errors. We recommend logging out of your accounting software before connecting Finstack.
Upload a static file
Use the “+ Add source” button in the top-right corner of the Sources page.
Select "Excel file" or "CSV file" from the available options.
For Excel uploads:
Select “Excel-file” from the options.
Provide the following details:
Entity Name: Assign a name for reporting purposes.
Currency: Choose the currency (e.g., EUR, USD).
Use the provided template to input your data.
Excel template:
Note: the template includes columns for 12 months and an additional end-year column if you want to upload multiple years. A check at the top of the file ensures all values sum up to zero.
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, contact support@finstack.io.
For CSV upload:
Select “CSV file” from the options.
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, email us at support@finstack.io.
Click “Upload CSV file” and select the file from your computer.
Confirm the upload, and the system will process the file for reporting use.
Pro Tips
Ensure your CSV data matches the required format for seamless uploads.
For unsupported formats, contact support@finstack.io to explore adding compatibility.
Properly name and categorize entities to simplify reporting and improve clarity.
Next Steps
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.
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.
Status of a connection
The status of the connection is indicated top center and should be green and “Available”. If otherwise, the connection is facing problems. You can try to reconnect using the dropdown on the right and selecting “Reconnect”. ****If issues persist, please reach out to Finstack support.
Manually trigger synchronisation of data (refresh)
We will sync your data with your accounting software every 3 hours. It is possible to trigger a manual refresh by pressing the “Start import” button top right. This will retrieve the newest transactions (most real-time).
Add new company / remove existing company [Exact Online]
When you have already set up your connection to Exact Online, but you want to add additional entities or revisit which entities are currently synced, do the following:
In Exact Online:
Go to your username in the top right corner. Select “My Exact Online”
Navigate to “Security Centre” in the menu. Select “Show all” next to “My app’s permissions”
Select “Finstack” in the “Application name” column
Select “Manage companies” bottom right
Use the arrows in the center, to include or exclude companies to sync. Everything in the panel on the right will be synced to Finstack. Press “Save and Close”
In Finstack:
Go to Setup > Administrations. Press the “Start import”-button top right to trigger the synchronisation of data.