For companies that cannot obtain SIE4 files or SAF-T files, it is possible to upload the accounts via an Excel accounting template. This also applies if the company has a chart of accounts with more than four digits.
NOTE! It is not possible to include any business areas/result units via this method. It only works via SIE4 file, SAF-T file 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".
Press the button “Export accounting template”.
The box below will appear.
Select Swedish or English.
Choose the fiscal period, if the year does not exist, select “New fiscal period”, and you can create it.
Press Export to download the file.
NOTE! you must have allowed downloading of files 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".
Press the button “Export accounting template”.
The box below will appear.
Start by selecting the company to export the template for.
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 have allowed downloading of files 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 for each 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 4 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 normally 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).
- Fill in 0, if there is no value. The same 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 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), both the balance sheet and the profit and loss account should be summed up to zero.
- If the result for the period 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 result for the period. 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 result of the period is automatically recorded in the system through accounting adjustments. No manual entry is needed in the accounting template (only for foreign companies).
It is therefore expected that there will be a difference in each month's profit and loss account and balance sheet relating to the result of the period.
- Differences: If the value of the result for the period differs between the profit and loss account and the balance sheet, this difference will be recorded in the standard account #9001 in the consolidation. A further review of the accounting template is then necessary.
In the example below, there is a difference between RR and BR in the Excel file, which is then posted to account #9001.
Save the file so that it can be used month by month in the future. All periods to be imported for the financial year must be filled in for the import to be correct.
Importing the accounting template
The import is done in the same place where the accounting template was downloaded from, see above for guidance.
For further information on importing accounting records, see the guide Upload or delete accounting file or Part 1.2 Upload accounting files.