User-defined Bank File Import

View - Accounting - User-defined bank file import

The program allows you to define your own bank file formats, which is made easy with the help of a wizard. After you have defined your own file formats, you can import your files into the journal entry for further processing. This is useful if you receive your bank statements on file or if you export your bank statements from your Internet bank to Excel, for example. Importing bank files can simplify your journal entry and you avoid having to register all your transactions manually.

Note! Please be aware that the first time you import your user-defined bank files, you will need to link each transaction to the desired N/C, customer or supplier ledger. The next time you import bank files, the system will automatically suggest the N/Cs and/or ledgers, based on your selections from the previous import. You can, of course, overwrite these suggestions for each item in the bank file.

Before you can import bank files, you need to define your own format. This is done in the wizard by clicking on the search button next to the File type-field.

How to import bank files

Go to View - Accounting - User-defined bank file import.
Select the File type from the drop-down list.
If you create a user-defined file format you will find more information in User-defined File Formats.
Click on the search button and find the file you wish to import.
Click on Next.
Select the relevant Bank/Petty cash account.
Select the Suspense account you want to use. The system will suggest an account for items where it cannot find a N/C and/or customer/supplier ledger to link to based on previous imports. However, this can be overwritten for each item later on in the wizard.
Click on Close Preview when you have checked the preview for report Bank file import.
Highlight any items you may want to change the N/C for and click on Edit.
Click on Next when you have made your changes.
Check the Bank file import report again once you have made your adjustments.
Click on Close Preview to exit the preview screen.
Click Complete to approve and transfer the items to the Journal Entry.
Print the report, which shows a summary of which journals have been created and then exit the preview.

To post the journals you have imported you need to open the Journal Entry and click on Update ledgers.

Having problems importing user-defined bank files?

Check that the date format you have defined matches the date format in the file you want to import.
Check that the file from your bank has been saved in Excel-format (.xls or .csv).
Format the date column in Excel to a date column starting with * (E.g. *14/03/2009)
If you get an error message when importing Excel files, try saving the file in the format Microsoft Excel 5.0/95 Workbook (*xls) before importing again.