|Uniconta has developed a free conversion tool that enables users to easily and securely convert to Uniconta from other financial management systems, such as Microsoft Dynamics C5, e-conomic, NAV and eCtrl/Axapta.
A conversion module is now included in the Uniconta application for Windows. However, the conversion tool can also be obtained as a separate application here.
The following data is automatically included upon conversion
Account numbers are left aligned
All account numbers in Uniconta are left aligned, since characters may also be included in account numbers. The account number field is a text field and is therefore sorted in the same way as a text field.
Account numbers in C5 are right aligned and will therefore appear in a different order after conversion.
Changing account numbers
Account numbers are easy to change in Uniconta. If the user wishes, for example, to delete the extra ‘0’s inserted in front of the account numbers once conversion is complete, then this can easily be done. All transactions and references will be automatically updated to reflect any changes made. So either the user keeps the extra ‘0’s or they re-number the Chart of Accounts.
Re-numbering is made quick and easy with the use of the ‘Edit all’ tab under General Ledger/Chart of Accounts, as shown in the screenshot below. The ‘Edit all’ tab allows the user to go through the whole Chart of Accounts row by row (like in a spreadsheet) and replace the old account number with a new one.
In C5 it is possible to delete values/codes (departments, VAT codes, payment code etc.) even if they are used in accounts or transactions. It is not possible to do this while ‘live’ in C5, but the data can be manipulated.
In Uniconta it is not possible to delete values/codes that are include in an account or transaction. Uniconta does not allow a field to contain a code that does not exist. The conversion program checks that all of these codes exist upon conversion, before allocating them to a transaction or account. If they do not exist then the field is left empty.
General ledger, customer and vendor transactions
Uniconta and C5 work in a similar way when posting transactions. If the day book is used to post transactions for a customer or a vendor, then the transaction also appears in the customer or vendor account as well as in the master account in the general ledger. In Uniconta, there is a field in the list of posted transactions in the general ledger, that shows which customer/vendor is on the original post.
Upon conversion, everything is posted in Uniconta again from start to finish, to ensure that each entry balances. All general ledger transactions from C5 are imported into Uniconta’s posting journal and a day book is created for each accounting year.
The next step is to import the customer and vendor transactions. Once imported, these are stored and each transaction is taken, one at a time, and matched to the original transaction in the posting journal that was just imported. The transactions are traced to their master account, which is then replaced with the customer/vendor account to create the ‘original’ transaction.
When searching for the ‘original’ customer/vendor transaction in the posting journal, the system searches only for master accounts. This ensures that the posting can always be traced back a master account. During this procedure, the system therefore only replaces account numbers on a journal that have a master account.
Note! C5’s master accounts are found by searching in the customer/vendor groups. If the C5 user has ever used a different master account for a customer/vendor group than is currently used, then we will not find the relevant account number and can therefore not replace the account number in the journal.
If we find a customer/vendor posting that cannot be traced to the original posting, then we will need to make two extra journal entries. We will make an entry on the customer/vendor account and a the counter entry on the customer/vendor master account, so that these balance out upon posting.
Once imported, the conversion program posts the journals. Once all journals are posted, the conversion program creates the opening balances for each accounting year.
Uniconta’s conversion tool supports: