9.2 Review Bank Balances

Purpose: Use this document as a reference for reviewing bank balances in ctcLink.

Audience: Settlement Manager, GL Accountant

Navigation: NavBar > Navigator > Banking > Bank Statements > Review Bank Balances

Review Bank Balances

  1. On the Review Bank Balances page, enter appropriate information in the Search Criteria section:
    1. Use the Search By drop-down button to select whether to summarize data by a single business unit or by group ID for a group of business units.
    2. Use the Sum By drop-down button to select bank or currency to summarize the data, if the search parameters return multiple results.
    3. Use the Select Balance to Graph drop-down button to select the information to appear in a chart: CLOSING AVAILABLE, CLOSING LEDGER, or OPENING LEDGER.
  2. If you want to generate a graph, select the Generate Graph button.

Note: Depending on the search parameters, a circle or stacked bar chart appears. Hover the cursor over a chart segment to display the balance total for that segment. You must hold the cursor within the graph segment boundaries to view the balance information.

The charting functionality derives data from the bank balances specified as favorite balances on the Balance Codes page. To chart bank balance data, two conditions must exist:

  1. The Bank Codes page must be configured with three favorite bank balances.  However, you can specify new favorite bank balances at any time—the charting functionality derives data from the most recently specified three favorite bank balances.
  2. There must be data in a favorite bank balance for you to chart the balance.  Without data in the system, you cannot create a chart.

The bank balance graph appears at the page bottom.

If the search parameters return a single bank account (only one row of results), the graphed balance appears in a bar chart.

If the search parameters return multiple bank accounts (multiple rows of results) of a single currency, the graphed balances appear as a stacked bar chart, organized per account by bank ID. The individual bar segments are color-coded to a specific account number.

  1. Enter Stmt Date.
  2. Select Search.
Review Bank Balances page
  1. Process complete.