Add a Bank Reconciliation

1. Access the Reconciliations area.

   1. To access the General Ledger from the Home screen, do one of the following:

   1. • Click General Ledger on the navigation panel.
      • Click Areas > General Ledger on the menubar.
      • Click the down arrow next to Home on the options bar and select General Ledger.

   To access the General Ledger from another area of the program, do one of the following:

   • Click Home > General Ledger on the menubar.
   • Click the down arrow next to Home on the options bar and select General Ledger.

   2. Click Reconciliations on the navigation panel or Areas > Reconciliations on the menubar.

2. Click Bank under Reconciliations on the navigation panel.

3. Do one of the following:

   • Click the Add button to the left of the list.

   • Click New on the options bar and select Reconciliation > Bank.

   • Click File > New > Reconciliation > Bank on the menubar.

   • With focus on the list, press [Insert] on your keyboard.

   • Press [Ctrl]+ N.

4. Choose a Bank account in the dropdown menu.

5. Select the Include subaccounts checkbox if applicable.

6. The current system date defaults in the Date field but can be changed if necessary.
   
   Note: For your first reconciliation, the date must be equal to or after the GL Effective Date to include your beginning balances. Once the first reconciliation is complete, the system requires all subsequent reconciliations to have statement dates later than the statement date of the previous reconciliation. This means that beginning balances are not an issue for subsequent reconciliations. You can run a General Ledger Register report on these dates using these criteria.

   Following the instructions in the Edit a Report article, use the following criteria to view the dates for your beginning balances:

   • Region: All

   • Agency: All

   • Branch: All

   • Department: All

   • Profit Center: All

   • Accounting Month: All

   • GL Effective Date: All

   • GL Entry Type: O - Opening Balance

   • GL Account: All

   • GL Schedule: All

   • Offsetting Detail: Include

7. Optionally select the Include future void offsets checkbox.

8. Enter a Description of the bank statement.

9. Enter the Ending balance.

10. In the Record line, select the Fees and/or Interest checkboxes. These checkboxes are not available if you selected Include subaccounts in step 5.
    If the Journal Entry Approval Process is enabled and you select Fees or Interest, the journal entries will be created with the System Approved status.

• If you select the Fees checkbox, perform the following steps in the Fees section:

1. Enter the Amount.

2. Enter the GL account #. To look up the account, click the lookup button . Type at least the first digit of the account in the first field, or the first digit of the subaccount in the second field, and then click Locate. Highlight the appropriate GL account and click Finish.

3. Select the appropriate Agency. Select the Branch, Department, and Profit Center if applicable.

• If you select the Interest checkbox, perform the following steps in the Interest section:

1. Enter the Amount.

2. Enter the GL account #. To look up the account, click the lookup button . Type at least the first digit of the account in the first field, or the first digit of the subaccount in the second field, and then click Locate. Highlight the appropriate GL account and click Finish.

3. Select the appropriate Agency. Select the Branch, Department, and Profit Center if applicable.

11. Click Continue or press [Enter].

12. The lists of deposits and withdrawals display. Use the filter above each list to narrow the items that display if necessary.

    

    These are the choices in the first dropdown menu:

    • Accounting Month
    • Amount
    • Reconciliation Status
    • Effective Date
    • Voids

    The choices available in the second dropdown menu vary, depending on the selection you made in the first dropdown.

    • Equals: Enter the search criterion (e.g., the full description or folder name) in the field to the right, or select the correct date from the dropdown calendar (if applicable). Click Find.
    • Within Range: Search between two calendar dates. Click the down arrow to the right of each field to choose dates from the dropdown calendars. Click Find.
    • Greater Than: Enter an amount in the field on the right and click Find to display all items greater than that amount.
    • Less Than: Enter an amount in the field on the right and click Find to display all items less than that amount.
    • Cleared: Click Find to display all items with a Reconciliation Status of Cleared.
    • Outstanding: Click Find to display all items with a Reconciliation Status of Outstanding.
    • Only Voids: Click Find to display only voided items.
    • Exclude: Click Find to exclude voided items.

    You can apply multiple filters if necessary.

    1. To apply multiple filters to the list, do one of the following:
    • Click the Edit Filter button . 
    • Press [Ctrl] + E.
    2. The Edit Filter pop-up window displays. 
       
       Note: You can also use the Edit Filter button, rather than the search bar, to apply a single filter to the list if you prefer.

    

    3. Select and/or enter your desired search criteria using the dropdown menus and fields, and then click the Add button. The Name, Compare Type, and Criteria for your filter display in the list. Click one of these column headings to sort the list by that column. To reverse the sort order, click the column heading again.
    4. To apply additional filters, enter additional search criteria and continue clicking Add. To remove a filter from the list, select it and click the Delete button.
    5. Click Finish when you have applied all of your desired filters.
       
       To exit the dialog without applying any filters, click Cancel.
13. In the Deposits and Additions list, click the checkbox in the Refer # column for each deposit that has cleared the bank. To select all of the checkboxes, click the Select All link label.
14. In the Cheques and Withdrawals list, click the checkbox in the Cheque # column for each withdrawal that has cleared the bank. To select all of the checkboxes, click the Select All link label.
    Note: If the Journal Entry Approval Process is enabled, cheques and withdrawals only display for Approved and System Approved journal entries, not journal entries in Working, Submitted, or Rejected status (as these have not yet been applied to general ledger balances).

15. Click Finish to complete the workflow.

Click Cancel to exit the screen without entering the reconciliation. If fees/interest were added to the reconciliation, you are prompted, "Canceling the statement will not void the fees/interest journal entry record." Click OK. You are then prompted, "Do you wish to discard changes?" Click Yes.