You can import a transaction file directly into the ledger journal.
Here's an example of a transaction file:
Debitor;Momskode;konto;Kunde nummer;Faktura;Fakturadato;Navn;Fakturabeløb;Valuta;
Debitor;U25;1010;1;4217;29-06-2017;Kunde1;2.061,25;dkk;
Debitor;U25;1010;2;4218;29-06-2017;Kunde2;1.323,75;dkk;
Debitor;U25;1010;3;4219;29-06-2017;Kunde3;1.333,75;dkk;
Column 1 contains Account Type. (This one should fit Uniconta). Look under chart of accounts
Column 2 contains the VAT code. (This one should fit Uniconta). See under VAT codes
Column 3 contains Customer number. (This one should fit Uniconta). Look under Customers
To get the transaction file into Uniconta, an import setup must be made.
Tap 'Import from File'
Add the numbers in the correct fields. For example:
Date = 6
Account type = 1
Account = 3
Field delimiter character: Uniconta finds the field delimiter itself. It can be entered.
Note! In the Text field, 50 characters can be imported. If the text in the file is longer, only the first 50 characters are loaded.
Via Template , the definition can be saved so that you can retrieve it again. The definition is stored on the user ID and thus works across companies. So a Univisor user only needs to save a definition for e.g. salary import once.
NOTE: It is possible to load amounts into the currency columns. The DKK column is not updated. It will be the first during posting. Check on the 'Simulation' of the journal to see the exchange rates being used.
Here's an example of a transaction file:
Debitor;Momskode;konto;Kunde nummer;Faktura;Fakturadato;Navn;Fakturabeløb;Valuta;
Debitor;U25;1010;1;4217;29-06-2017;Kunde1;2.061,25;dkk;
Debitor;U25;1010;2;4218;29-06-2017;Kunde2;1.323,75;dkk;
Debitor;U25;1010;3;4219;29-06-2017;Kunde3;1.333,75;dkk;
Column 1 contains Account Type. (This one should fit Uniconta). Look under chart of accounts
Column 2 contains the VAT code. (This one should fit Uniconta). See under VAT codes
Column 3 contains Customer number. (This one should fit Uniconta). Look under Customers
To get the transaction file into Uniconta, an import setup must be made.
Tap 'Import from File'
Add the numbers in the correct fields. For example:
Date = 6
Account type = 1
Account = 3
Field delimiter character: Uniconta finds the field delimiter itself. It can be entered.
Note! In the Text field, 50 characters can be imported. If the text in the file is longer, only the first 50 characters are loaded.
Via Template , the definition can be saved so that you can retrieve it again. The definition is stored on the user ID and thus works across companies. So a Univisor user only needs to save a definition for e.g. salary import once.
After setup
Tap "Load File". The file is imported into a preview of the file before the entries land in the journal. The purpose is to see and check whether the imports look as expected. If it does, press the Save function button.
NOTE: It is possible to load amounts into the currency columns. The DKK column is not updated. It will be the first during posting. Check on the 'Simulation' of the journal to see the exchange rates being used.