If a sie4 file or integration with an accounting system is missing, it is possible to upload an Excel file with accounting data monthly in Boardeaser instead.
If no sie4 file has been uploaded before, you start by going to "Financials - Data management". Under the "Accounting" tab is where you upload your accounting files.
Create Excel file(s)
The accounting data can be read from two or three tabs in the same Excel file or one tab per Excel file.
Columns
Boardeaser creates an analysis of the accounting data when it has been uploaded, the system tries to identify these columns:
- Account number
- Account name
- Account number + account name
- Result period
- Balance diff period
- Balance IB
- Balance UB
- IB financial year
The actual accounting data needs to be for one month. For a whole year, you can read everything in a column, but it will then be registered in December that year.
Rows
The rows can contain account numbers, account names, account groups, and summaries.
Minimum Requirements
The minimum requirement for the result report is the account number and annual numbers (however, these will be registered in the last month of the year, i.e. December in a normal case).
The minimum requirement for the balance sheet is account number, IB financial year, and diff.
Upload and define the content
Once one or more Excel files have been created, it is time to upload them. Start by clicking on "Upload Accounting files" and select the Excel file from your computer.
Once you click on the "Upload accounting files" There will pop up another tab (see below). Click or drag your excel file to upload.
Once you have uploaded your file, the system will analyze and make sure your file is correct. Under "Status" you will se when the file is OK. When the file is OK you click "Upload accounting files"
Now you have your accounting in Boardeaser and are ready to create dashboards, graphs or Tables.
Don't hesitate to contact us if you have any questions.