You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

The following will guide you on how to import CSV file of 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. The CSV import screen will open to allow user to import bank transaction.  

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

  7. Click import. In the grid area, transaction in the csv file should be added correctly.

    1. In the GL Account field, GL account in the csv file should appear.
    2. Enter the amount for the interest gained in the Debit field. As soon as amount is entered, the field that follows the Type field in the header part of the screen is automatically captioned Debit. This tells that the bank account entry has a debit value, thus resulting to increasing the bank account balance when the transaction is posted. See  How to Post Bank Transaction - Misc Credits .
    3. At the bottom of the grid, a Total of all debits and/or credits added in the grid is shown. The difference of the Total Debits and Total Credits will automatically appear on Debit field, header section of the screen.

  8. Click Save toolbar button to save the bank transaction.

    The Record No field will then show the bank transaction number assigned for this transaction.

    If the transaction is to be posted right away, you may skip saving it. Instead, click Post toolbar button and it will save and post the transaction. See How to Post Bank Transaction - Misc Credits.

  9. Click Close toolbar button to close the screen.

 

  • No labels