Import Bank Transactions

Use the Bank Reconciliation application to import transactions from your bank statement.

You can import bank transactions from a text file, such as a .txt or .csv file.

Prerequisites: Before you can import transactions, you must:

• Set up a bank in Settings > Accounting > Banks.

  This includes completing the configuration on the Import tab of the Bank Codes form. You specify the data (fields) to import from the file and the formatting of data.

• Obtain the file that contains bank transaction data from your bank. Many banks allow you to download the information from a secure bank website. You must convert it to a file format that matches the import file configuration that you set up.
• Remove data from the import file that you do not want to import. If there is data in the import file that does not match pre-defined fields, define these fields on the Import tab of the Bank Codes form.
• Create a bank statement in Accounting > Bank Reconciliation in which to import bank transactions.

To import transactions from a bank statement:

1. On the Navigation menu, click Accounting > Bank Reconciliation.
2. On the Bank Statement Selection dialog box, enter the information needed to create a new statement, or select an in-progress statement that you previously started. Click Select.
3. On the toolbar of the Bank Statement Reconciliation form, click Import > Import Bank Transactions.
4. If you previously imported transactions for a statement and a dialog box asks you to confirm the overwriting, click Yes to proceed.
5. On the Import New Bank Transactions dialog box, click Browse beside the File field.
6. On the Open dialog box, select the text file to import and click Open.
7. On the Import Bank Transactions dialog box, click OK. The import process begins immediately. The Import New Bank Transactions dialog box identifies the number of valid records in the text file to import.
8. Click Import.
9. On the dialog box that informs you that the records were imported, click OK. The imported bank transactions display on the Import tab of the Bank Statement Reconciliation form.