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 clicking at "Import from Excel".
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 "Select files" and select the Excel file from your computer.
Then set the fiscal year and period (month) to which the data refers (create a new fiscal year if it is missing).
Once the file has been loaded, the system needs help interpreting the information. Define what each column contains by selecting one of the options above each column in the preview.
When all data has been defined, you finish by clicking at "Complete import".
Finally, click on "Data Management" to get an overview of the transaction distribution of files.
Example
Upload accounting data for January 2021
Click here to download an example for January 2021. The file has two tabs:
- Result: Account number, account name, and result
- Balance: Account number, account name, IB financial year, and diff
Watch the video below with this example: