Bank Master

The Bank Master view enables you to maintain Bank Account Codes that are designed for use with the bank reconciliation feature. Bank Account Codes are used to associate your financial institution’s Banking details with the GL Account from PointForce Enterprise (PFE) that represents your bank. You must identify the correct PFE Bank GL Account in this view as the bank reconciliation logic uses this GL Account to build all AP/AR/GL/IN transactions in the reconciliation process.

Note: It is the assignment of the Bank GL Account in the Bank Master view that starts the process of accumulating bank transactions (in the GL Transaction view) for use in the reconciliation process.

The following fields are available on the Bank Master view and are based on the order in which they appear in the grid on the search page:

• Company - every record in the PointForce iTopia SQL database includes the Company Number. When reviewing the results from your search, the Company Number will display for all Bank Master records.

• Bank Account Code - displays the Bank Account Code assigned to the Bank Master record. You cannot modify this field in the grid. If you create a Bank Master record in error, you must delete the entire record and create a new record with the correct Bank Account Code.

• Bank Account Description - displays the description of the Bank Account entered for the Bank Master record. You can enter a maximum of 40 alpha numeric characters in this field. You can edit this field as required.

• Transit No. - displays the Transit number associated with the Bank Account Code. You can edit this field as required.
  1. In Canada, transit numbers are regulated by the Canadian Payments Association. A Canadian Transit Number has the following format:

     XXXXX-YYY

     where XXXXX is the Branch Number, and YYY is the Institution Number. The dash between the branch number and the institution number is an integral part of the transit number.

     Examples:

     • XXXXX-001 Bank of Montreal (BMo)
     • XXXXX-002 Bank of Nova Scotia (BNS)
     • XXXXX-003 Royal Bank of Canada (RBC)
     • ... and so on ...

  2. In the United States, the routing Transit Number is a nine digit bank code. The routing number format is:

     XXXXYYYYC

     where XXXX is the Federal Reserve Routing Symbol, YYYY is the American Bankers Association (ABA) Institution Identifier, and C is the Check Digit.

• Account Number - displays the Account Number to be debited or credited. You can edit this field as required.

• GL Account-Bank - displays the GL Account associated with the Bank Account Code. You can edit this field as required.

  In the following PointForce Enterprise (PFE) programs, transactions associated with this GL Account are automatically copied to the bank reconciliation transaction table (GL Transactions view):

  • Invoice Audit Trail Report (AP31)
  • Computer Chq Register (AP43)
  • Manual Chq Register (AP51)
  • Cancelled Cheque Register (AP81)
  • Cash Receipts/Adjustments (AR31)
  • Post Journal Vouchers (GL31)
  • Post Standard Journals (GL81)
  • Print Invoice Register (IN44) (*only for EFT transactions that hit the bank directly)

• Contact - displays the Contact name associated with the Bank Account Code. You can enter a maximum of 61 characters in this field. You can edit this field as required.

• Address 1 - displays the street and number associated with the Bank Account Code. You can enter a maximum of 30 alpha numeric characters in this field. You can edit this field as required.

• Address 2 - displays any additional Address information such as Rural Route or Unit/Suite number. You can enter a maximum of 30 alpha numeric characters in this field. You can edit this field as required.

• City - displays the City or town. You can enter a maximum of 30 alpha numeric characters in this field. You can edit this field as required.

• Province/State - displays the Province or State. The Province/State list is maintained in Maintain Province Codes (CC14). You can edit this field as required.

• Country - displays the Country associated with the Province or State. You can edit this field as required.

• Telephone 1 - displays the Telephone number associated with the Bank Account Code. You can edit this field as required.

• Address Map - when you click on this link, an Internet Explorer window (or new folder) automatically launches a link to the "Google Maps" website for the current address.

For information on the functionality of each button on the Bank Master Search Criteria Results/Grid page, click here.