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

  1. Go to View - Accounting - User-defined bank file import.

  2. Select the File type from the drop-down list.

  3. Click on the search button and find the file you wish to import.

  4. Click on Next.

  5. Select the relevant Bank/Petty cash account.

  6. 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.

  7. Click on Close Preview when you have checked the preview for report Bank file import.

  8. Highlight any items you may want to change the N/C for and click on Edit.

  9. Click on Next when you have made your changes.

  10. Check the Bank file import report again once you have made your adjustments.

  11. Click on Close Preview to exit the preview screen.

  12. Click Complete to approve and transfer the items to the Journal Entry.

  13. 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?


Read more about:

User-defined bank file formats

Journal Entry

How to update the ledgers