Heeros Accounting allows the import of accounting transactions from other systems as well.
The import of events is done from the Events – Open view, using the Import Events button.
Type of interface - Select the interface based on which system the data is being imported from. By choosing HeerosCSV, information in accordance with the template file can be imported into the program. The column headers are mandatory, even if not all the information specified in them is being imported. An example CSV file can be found at the end of this article.
- Columns must not be removed from the file.
- The date format must be dd.mm.yyyy or d.m.yyyy. NOTE! The date information is mandatory on each line if it is not specified during the import (there is an option to specify the date with the summary voucher).
- Voucher types, account information, and VAT codes must be consistent with the accounting settings.
- The voucher number information does not have to be the next open number from the accounting; during the import, the event can be renumbered.
- The description must not contain special characters such as ; or ´ or " or < or > characters, as these break the structure of the csv file.
- The amount information must be marked with a precision of no more than two decimal places.
Import file – section for browsing the input file to be retrieved.
VAT can be processed either according to the VAT code coming in the data (As in import file) or alternatively, if no VAT code comes in the data, the VAT code of the account coming in the data will be considered from Heeros Accounting (Calculate VAT).
Receipt numbering - if As in import file is selected, at which point Heeros Accounting will take the voucher type and voucher number from the import data. Selecting Generate new note numbers will assign new voucher numbers to the transactions in Heeros Accounting. The voucher number will be taken from the selected voucher type. Importing the material will update the accounting voucher number counters only if the vouchers are renumbered.
Bundling of entries
No bundling - With this option, the program creates entries in Heeros Accounting exactly as they are in the input material, each entry will have its own entry in the accounting as well.
Bundle by invoice - By selecting this option, the program creates entry batches by invoice; if the same invoice has entries for the same account and the same accounting object, these entries are combined into a single entry line in the accounting.
Bundle to single note - By selecting this option, the program reviews the entire input data, and if there are entries for the same account and accounting object, these entries are combined into a single entry line in the accounting. A voucher type is selected for the summary voucher, from which the next voucher number is retrieved. One voucher is formed from the entries, dated to the selected voucher date during import.
Creation of accounting objects
Check objects - the program checks that the cost units and other accounting objects included in the data must be established in Heeros Accounting beforehand before transfer. If there are transactions in the import data that use an accounting object not found in Heeros Accounting, the transfer will not succeed until the specified accounting object has been established in the accounting system or the data has been switched to another accounting object.
Create missing objects - the program creates the missing cost units and other accounting objects in Heeros Accounting. The identifier will be based on the identifier from the material and the name will be based on the name at the accounting object level, for example, the term cost unit. The accounting object should then be renamed in the accounting settings with the desired name.
Create missing accounts
No selection, the accounts to be transferred must be established in the accounting for the transfer to be successful.
Yes option creates the missing accounts coming in the transfer as separate accounts in the accounting. In the Account – Accounts view, the user must complete the information for the created accounts.
Note unbalance
Is not allowed – with the selection, the entries of the imported material must balance in order for the transfer to succeed.
Allow -with this option, the program will ask to specify the accounting account to which any possible difference will be recorded during the transfer.
Load - The actual entry of events begins with the Load button.
At the end of the import, the program will notify you of the success of the import or any possible errors at the top of the screen.
A pdf-format transfer report is automatically generated from the feedback, which is saved in the Archive's document archive. The main classification is retrieved from the general settings of Accounting, just like with other accounting reports, with the sub-classification being Transfer Reports.
Description of the CSV file and example file: