How do I upload accounting via Excel? – Boardeaser

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.