How to Import Bank Transaction

1. From Cash Management module click Bank Transactions
2. If this is the first record you are to create, it will open directly on new Bank Transaction screen where you can then add the transaction. Otherwise, it will open the Search Bank Transactions screen where existing bank transactions are displayed. Click the New toolbar button to open the new Bank Transaction screen.
   

3. In the Bank Account field, click the dropdown combo box button to open the combo box list and select the bank account you want to take the amount of the charge from. 
   

   Make sure that the bank account you want to use for the bank transaction had been added in the Bank Accounts screen. If not, see How to Add new Bank Account to guide you on how to add it.

4. Click import toolbar button

   

    

5.  

6. The CSV import screen will open to allow user to import bank transaction.  

   Click the browse button. Select a valid and complete csv file to import. For more information about the format see Bank Transactions 

   import file format: 

   
   

   banktransactionimport.csv

   12152015,2016-04-30 00:00:00.000,Bank Transaction,,N,0001-Fort Wayne,61500-0101-000,,,Fee Expense,100.000000,0.000000,,,,,,

    

7. Click import. Once the importing is done, an import log screen will appear showing the result. 
   
   a. sample successful Transaction
   
   
   b. sample failed Transaction
   
   
   Note: Importing will not be successful when one transaction has an error.

7. When  the importing is successful, you can click on the drillable column value to open the details in the Bank Transaction screen.