This will guide you on how to setup your bank statement in the Bank File Formats screen and import the Bank Statement based on that setup to mark transactions cleared by the bank.

  1. From Cash Management module > click on Bank File Formats menu.
  2. If this is the first record you are to create, it will open directly on new Bank File Formats screen where you can then add the bank file format record. Otherwise, it will open the Search Bank File Formats screen where existing bank file formats are displayed. Click the New toolbar button to open the new Bank File Formats screen.
  3. In the new Bank File Formats screen, 
    1. Type in the Name you would like to call that Bank File Formats record in the Name field. 
    2. In the Format combo box field select Bank Statement.
    3. In the File Type combo box field select CSV.
    4. In the grid area > Check Record tab, specify your bank statement setup. This is a sample of how your setup would be.
    5. Click Save toolbar button to save the bank file format record.
    6. Click Close toolbar button to close the screen.
  4. Open the bank account you will want to make a bank reconciliation.
    1. From Cash Management module > click on Bank Accounts menu.
    2. When Search Bank Accounts screen opens, select the bank account you will want to make a bank reconciliation and click Open Selected toolbar button.
    3. Bank Accounts screen opens displaying the selected record. In the Electronic Bank File Information panel > select the bank statement setup from the Bank File Formats screen. The one created on Step 3.
    4. Click Save toolbar button to save the changes made.
    5. Click Close toolbar button to close the screen.
  5. Open the Bank Reconciliation screen.
    1. From Cash Management module > Activities folder > double-click on Bank Reconciliation menu.
    2. Bank Reconciliation screen opens.
    3. In the Bank Account field select the bank account you will want to make a bank reconciliation.
    4. Say this is the bank reconciliation file to import.
    5. Click Import toolbar button and select the file mentioned on Step 5.d. Then click Open button on the lookup screen.
  • A progress bar will be shown to show the progress of selecting transactions to clear base on the imported file. Once it is done, all transactions that matched the Bank Statement file imported will show the Clear checkbox as checked.  

This will guide you on how to setup your bank statement in the Bank File Formats screen and import the Bank Statement based on that setup to mark transactions cleared by the bank.

  1. From Cash Management module > click on Bank File Formats menu.
  2. If this is the first record you are to create, it will open directly on new Bank File Formats screen where you can then add the bank file format record. Otherwise, it will open the Search Bank File Formats screen where existing bank file formats are displayed. Click the New toolbar button to open the new Bank File Formats screen.
  3. In the new Bank File Formats screen, 
    1. Type in the Name you would like to call that Bank File Formats record in the Name field. 
    2. In the Format combo box field select Bank Statement.
    3. In the File Type combo box field select CSV.
    4. In the grid area > Check Record tab, specify your bank statement setup. This is a sample of how your setup would be.
    5. Click Save toolbar button to save the bank file format record.
    6. Click Close toolbar button to close the screen.
  4. Open the bank account you will want to make a bank reconciliation.
    1. From Cash Management module > click on Bank Accounts menu.
    2. When Search Bank Accounts screen opens, select the bank account you will want to make a bank reconciliation and click Open Selected toolbar button.
    3. Bank Accounts screen opens displaying the selected record. In the Electronic Bank File Information panel > select the bank statement setup from the Bank File Formats screen. The one created on Step 3.
    4. Click Save toolbar button to save the changes made.
    5. Click Close toolbar button to close the screen.
  5. Open the Bank Reconciliation screen.
    1. From Cash Management module > Activities folder > double-click on Bank Reconciliation menu.
    2. Bank Reconciliation screen opens.
    3. In the Bank Account field select the bank account you will want to make a bank reconciliation.
    4. Say this is the bank reconciliation file to import.
    5. Click Import toolbar button and select the file mentioned on Step 5.d. Then click Open button on the lookup screen.

 

  • A progress bar will be shown to show the progress of selecting transactions to clear base on the imported file. Once it is done, all transactions that matched the Bank Statement file imported will show the Clear checkbox as checked.  
  1. From Cash Management module > click on Bank File Formats menu.
  2. If this is the first record you are to create, it will open directly on new Bank File Formats screen where you can then add the bank file format record. Otherwise, it will open the Search Bank File Formats screen where existing bank file formats are displayed. Click the New toolbar button to open the new Bank File Formats screen.
  3. In the new Bank File Formats screen, 
    1. Type in the Name you would like to call that Bank File Formats record in the Name field. 
    2. In the Format combo box field select Bank Statement.
    3. In the File Type combo box field select CSV.
    4. In the grid area > Check Record tab, specify your bank statement setup. This is a sample of how your setup would be.
    5. Click Save toolbar button to save the bank file format record.
    6. Click Close toolbar button to close the screen.
  4. Open the bank account you will want to make a bank reconciliation.
    1. From Cash Management module > click on Bank Accounts menu.
    2. When Search Bank Accounts screen opens, select the bank account you will want to make a bank reconciliation and click Open Selected toolbar button.
    3. Bank Accounts screen opens displaying the selected record. In the Electronic Bank File Information panel > select the bank statement setup from the Bank File Formats screen. The one created on Step 3.
    4. Click Save toolbar button to save the changes made.
    5. Click Close toolbar button to close the screen.
  5. Open the Bank Reconciliation screen.
    1. From Cash Management module > Activities folder > double-click on Bank Reconciliation menu.
    2. Bank Reconciliation screen opens.
    3. In the Bank Account field select the bank account you will want to make a bank reconciliation.
    4. Say this is the bank reconciliation file to import.
    5. Click Import toolbar button and select the file mentioned on Step 5.d. Then click Open button on the lookup screen.

 

  • A progress bar will be shown to show the progress of selecting transactions to clear base on the imported file. Once it is done, all transactions that matched the Bank Statement file imported will show the Clear checkbox as checked.  
  1. From Cash Management module > click on Bank File Formats menu.
  2. If this is the first record you are to create, it will open directly on new Bank File Formats screen where you can then add the bank file format record. Otherwise, it will open the Search Bank File Formats screen where existing bank file formats are displayed. Click the New toolbar button to open the new Bank File Formats screen.
  3. In the new Bank File Formats screen, 
    1. Type in the Name you would like to call that Bank File Formats record in the Name field. 
    2. In the Format combo box field select Bank Statement.
    3. In the File Type combo box field select CSV.
    4. In the grid area > Check Record tab, specify your bank statement setup. This is a sample of how your setup would be.
    5. Click Save toolbar button to save the bank file format record.
    6. Click Close toolbar button to close the screen.
  4. Open the bank account you will want to make a bank reconciliation.
    1. From Cash Management module > click on Bank Accounts menu.
    2. When Search Bank Accounts screen opens, select the bank account you will want to make a bank reconciliation and click Open Selected toolbar button.
    3. Bank Accounts screen opens displaying the selected record. In the Electronic Bank File Information panel > select the bank statement setup from the Bank File Formats screen. The one created on Step 3.
    4. Click Save toolbar button to save the changes made.
    5. Click Close toolbar button to close the screen.
  5. Open the Bank Reconciliation screen.
    1. From Cash Management module > Activities folder > double-click on Bank Reconciliation menu.
    2. Bank Reconciliation screen opens.
    3. In the Bank Account field select the bank account you will want to make a bank reconciliation.
    4. Say this is the bank reconciliation file to import.
    5. Click Import toolbar button and select the file mentioned on Step 5.d. Then click Open button on the lookup screen.

 

A progress bar will be shown to show the progress of selecting transactions to clear base on the imported file. Once it is done, all transactions that matched the Bank Statement file imported will show the Clear checkbox as checked.

This will guide you on how to setup your bank statement in the Bank File Formats screen and import the Bank Statement based on that setup to mark transactions cleared by the bank.

  1. From Cash Management module > Maintenance folder > double-click on Bank File Formats menu.
  2. If this is the first record you are to create, it will open directly on new Bank File Formats screen where you can then add the bank file format record. Otherwise, it will open the Search Bank File Formats screen where existing bank file formats are displayed. Click the New toolbar button to open the new Bank File Formats screen.
  3. In the new Bank File Formats screen, 
    1. Type in the Name you would like to call that Bank File Formats record in the Name field. 
    2. In the Format combo box field select Bank Statement.
    3. In the File Type combo box field select CSV.
    4. In the grid area > Check Record tab, specify your bank statement setup. This is a sample of how your setup would be.
    5. Click Save toolbar button to save the bank file format record.
    6. Click Close toolbar button to close the screen.
  4. Open the bank account you will want to make a bank reconciliation.
    1. From Cash Management module > Maintenance folder > double-click on Bank Accounts menu.
    2. When Search Bank Accounts screen opens, select the bank account you will want to make a bank reconciliation and click Open Selected toolbar button.
    3. Bank Accounts screen opens displaying the selected record. In the Electronic Bank File Information panel > select the bank statement setup from the Bank File Formats screen. The one created on Step 3.
    4. Click Save toolbar button to save the changes made.
    5. Click Close toolbar button to close the screen.
  5. Open the Bank Reconciliation screen.
    1. From Cash Management module > Activities folder > double-click on Bank Reconciliation menu.
    2. Bank Reconciliation screen opens.
    3. In the Bank Account field select the bank account you will want to make a bank reconciliation.
    4. Say this is the bank reconciliation file to import.
    5. Click Import toolbar button and select the file mentioned on Step 5.d. Then click Open button on the lookup screen.
    6. A progress bar will be shown to show the progress of selecting transactions to clear base on the imported file. Once it is done, all transactions that matched the Bank Statement file imported will show the Clear checkbox as checked.
  • No labels