For companies that cannot obtain SIE4 files or SAF-T files, uploading the accounts via an Excel accounting template is possible. This also applies if the company has a chart of accounts with more than four digits.
NOTE! This method does not allow you to include any business areas/result units. It only works via the SIE4, SAF-T, or some of the integrations with accounting systems. See the guide Which integrations can be used in Boardeaser.
A separate template needs to be exported for each company and financial year to be imported.
Exporting a template for an individual company
To download the accounting template for an individual company, go to "Financials" > "Data management" and click the “Export accounting template” button.
Select Swedish or English.
Choose the fiscal period. If the year does not exist, select “New fiscal period”, and you can create it.
Click Export to download the file.
NOTE! You must allow file downloading in the browser. Otherwise, it is not possible to download a file.
Export template for group companies
To download the accounting template for a group company, go to Group Financials > Group Consolidation > Legal Accounting > Accounting data.
Click the button “Export accounting template”.
The box below will appear.
Start by selecting the company for which to export the template.
Then, choose Swedish or English.
Enter the fiscal period. If the year does not exist, select “New fiscal year”, and it will be created.
Press Export to download the file.
NOTE! You must allow file downloading in the browser. Otherwise, it is not possible to download a file.
Managing the accounting template
The accounting template is in Excel format and contains three tabs.
A cover page, a tab for balance sheet accounts and a tab for profit and loss accounts.
Use the predefined Excel template generated for each fiscal year and company.
Format and filling requirements
- Avoid changing or deleting information in the template tabs or cells.
- Account numbers must contain 4-9 digits (for charts of accounts with more than four digits, contact us via the support form above to activate multi-digit charts of accounts on the company)
- Accounting figures should be in number format.
- Assets should typically be positive, while liabilities should be negative. If necessary, some accounts can have reverse signs.
- Enter and import accounting data monthly. Data can also be supplemented later.
- Always use local currency and leave months not started blank.
Fill in the Balance Sheet and Profit and Loss tabs
- Opening balance is mandatory for all balance sheet accounts (column C).
- If there is no value, fill in 0. This applies to accounts in BR/RR that you want to include even if there are no values in the accounts, i.e., fill in 0 in all months.
- Closing balance is required for all accounts every month.
- Column C of the balance sheet refers to the opening balance and should always sum to 0.
- Column C of the profit and loss account sums up all months automatically and should not be changed.
Posting the result of the period (only companies not to be converted)
- If the result for the period is booked (8999-2099), the balance sheet and the profit and loss account should be summed up to zero.
- If the period's result is not booked in the Excel file, check that the difference between the balance sheet and the profit and loss account consists only of the period's result. Otherwise, the amounts must be corrected before loading.
- Alternatively, rebooking can be done directly in Boardeaser under “Accounting adjustments”, then it does not need to be posted in the Excel file.
Automatic Posting of Profit for the Period (only companies to be converted into a group):
- Opening Balance: should sum to zero (see column C) in the “Balance” tab.
- In the remaining periods of the year, the results are automatically recorded in the system through accounting adjustments. No manual entry is needed in the accounting template (only for foreign companies).
Therefore, it is expected that each month's profit and loss account and balance sheet will differ in relation to the period's results.
- Differences: If the value of the period's result differs between the profit and loss account and the balance sheet, this difference will be recorded in standard account #9001 in the consolidation. A further review of the accounting template is then necessary.
In the example below, the Excel file shows a difference between RR and BR, which is then posted to account #9001.
Save the file so that it can be used month by month. For the import to be correct, all periods for the financial year must be filled in.
Importing the accounting template
The import is done in the same place where the accounting template was downloaded from, see above for guidance.
If you would like more information on importing accounting records, you can see the guide Upload or delete accounting file or Part 1.2 Upload accounting files.