You can import accounting data from Fivaldi to Netvisor via the interface or as a csv file using data import.
CONTENT
Importing accounting data via the interface
Data import from Fivaldi via interfaces is now possible. The import can only be done once, so transfer all desired fiscal periods at the same time. The free import takes place via interfaces and the following conditions must be met for the import to succeed:
- Interfaces must be opened in Fivaldi before starting the import. Fivaldi's instructions for opening the interface can be found in the links below. Please note that all rights described below must be granted in Fivaldi for the connection between Netvisor and Fivaldi to open:
- The company's environment must be established in Netvisor.
- The user must have editing rights in the Accounting section's function-specific rights for "Basic information management" and "Basic information import".
Once the preparations are made, data import from Netvisor is successful from Company menu -> Data import -> Fivaldi accounting material import from the interface
Data can be imported from the last three fiscal periods. During the import, it is possible to select per fiscal period what data is imported.
Fiscal periods
Fiscal periods are automatically established during the import, and when importing data, it is indicated if the fiscal periods differ from those already in Netvisor. Fiscal periods must be named the same way in Fivaldi and Netvisor. Please note that Netvisor automatically retrieves the last three fiscal periods from Fivaldi, and they cannot be selected on the Netvisor side. Remove any empty fiscal periods from Fivaldi before the import.
Data to be imported
During the import, it is possible to select per fiscal period whether to import opening balances or vouchers to Netvisor. Opening balances are recommended for the first fiscal period to be imported. You can also choose not to import the fiscal period data at all.
Please note that all vouchers from the import period, including profit/loss entries, are transferred with the interface import. The system does this itself when the fiscal period is closed, so please cancel the profit/loss entries if necessary when importing data from multiple fiscal periods.
Calculation targets
Calculation targets are formed in the format they are imported with the material. You can create a calculation target header for the imported calculation targets during the import. Fivaldi's tracking targets are calculation targets in Netvisor.
Fivaldi's tracking targets can also be linked to existing calculation targets in Netvisor.
Account information linking
After pressing the "Fetch data from Fivaldi" button, the program moves to account information linking. You can link accounts to the accounts according to Netvisor's chart of accounts or establish new accounts in Netvisor. Account information linking instructions.
Frequently asked questions
What data can be imported from Fivaldi to Netvisor with the interface import?
Currently, only historical accounting data can be imported as opening balances or vouchers with the interface import.
In the fiscal periods to be imported, there is a fiscal period with no transactions in Fivaldi. How can I import older fiscal periods with transactions?
Netvisor automatically selects the last three fiscal periods from Fivaldi. Ensure that there is no next empty fiscal period established in Fivaldi, which has no transactions. You can remove empty fiscal periods from Fivaldi before the import.
Netvisor indicates that fiscal periods would be formed as duplicates (image), what does this mean?
Fiscal periods are likely named differently in Fivaldi and Netvisor. Check that the fiscal periods are named the same way in Netvisor.
Fivaldi's and Netvisor's charts of accounts do not match, how do I link the accounts?
You can select account correspondences from Netvisor's account list by pressing the red "Link". You can also remove the account from the transfer by selecting Remove or establish missing accounts in Netvisor's account list from the menu Financial management > Account list > New account.
How do I return to an incomplete data import?
You can return to data import from the company menu > data import. Incomplete imports in the linking phase are visible under the "Recently imported accounting batches" header. Completely unprocessed imports are visible under the "Unprocessed transfers" header.
Importing accounting data as a csv file
You can also import accounting data from Fivaldi to Netvisor as a csv file using Netvisor's data import.
Creating a journal file in Fivaldi
Accounting comparison data from previous fiscal periods is transferred to Netvisor from Fivaldi's journal file. The file can be created in Fivaldi under Accounting > Data export.
Select All exports by vouchers (journal).
Select the fiscal period to be transferred (or month, if transferring month by month). Click "Export data".
Model of the journal below:
Edit the file to remove empty rows: Select the entire workbook (Ctrl+A) > Add filters to the first row (Ctrl + shift + L) > filter empty rows visible from the first column filter by selecting "Blanks" > Ok > select one row > Delete. After this, only entry rows remain visible in the file. Remove filters. Save the file in .csv format in Excel. Import the file normally with Accounting data import to Netvisor.
With the journal, fiscal period events (changes) are transferred, so in addition to this, the opening balance sheet must be transferred to Netvisor.
Opening balance sheet from Fivaldi
Report > Opening balances > print to Excel. Add a date column to the report (e.g., 31.12.2023) and save in .csv format. Import normally with Data import to Netvisor.
Data import to Netvisor
Once you have taken the files from Fivaldi, import the data to Netvisor according to the following instructions: Accounting data import
Keywords: Accounting data, Fivaldi, Netvisor, Interface, CSV file, Fiscal period, Opening balance, Voucher, Calculation targets, Journal file
Did you find it helpful? Yes No
Send feedback