Previous Topic

Next Topic

Book Contents

Book Index

CB Bank Statements

Navigator > Tasks > Cash Book > Bank Reconciliation

You can view and access current and previous bank statements, select a statement from the list, continue reconciling, or add a new statement and reconcile transactions against the Cash Book. The fields in the header allow you to define the statements to view in the grid. The Show all button (Ctrl+A) shows statements for all bank accounts.

  1. To add a new statement and reconcile transactions against the CB, click Insert (F4). To view a closed statement or open an open statement, select the Bank Account, Period and statement Type, select the statement in the grid, double-click or click Open Details (F12).
  2. If there are Automatic Payments due for posting, CB Post Automatic Payments opens, see Post Automatic Payments.
  3. CB Bank Reconciliation will open.

Select Bank Account

Select the bank account from the Select Bank Account Lookup control.

Period Selection

Select a period to view for:

  • Period - Select a single period in the From selection.
  • Year - Displays statements for the current year.
  • All Periods - All document are displayed.
  • Range of Periods - Select the From and To periods to display a range.

Period lookup has a year selection. Press Ctrl+Up and Ctrl+Down or Ctrl++ and Ctrl+- (numeric keypad) to move through a year at a time. Press + or - (numeric keypad) to move forward or backward a period.

Default is Range of Periods with From Period set to First Available period for CB or period of first Open Statement whichever is earlier, and To Period set to Last Available period for CB.

Selection

Select the Statement type. you can select different bank accounts while retaining the Period selection.

Open

Show only statements which are open to be reconciled.

Closed

Show only statements that have been reconciled and closed.

All Statements

Show all statements (that is, all the above selections).

 

Grid Toolbar

ToolbarExpand

Expand Toolbar (Alt+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert a new statement. CB Bank Reconciliation opens with the Statement grid empty and the Unreconciled grid containing unreconciled transactions.

Delete (F3)

You can delete open bank statements.

Open (F12)

Opens CB Bank Reconciliation. You can view details for the statement including,

  • Open statements can be viewed, edited and closed.
  • Closed statements can be viewed.

Closed statements can be re-opened, but only if all later statements are also open. Statements must be closed from oldest to most recent.

Print (Ctrl+P)

Print the Statement List, save as an Excel worksheet or PDF file and send as an email attachment.

RecordFilterSort_Hot

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Refresh (F5)

Reloads changes other Users may have made.

Find (Ctrl+F)

Find a statement using the Statement ID.

 

Customise Toolbar

ToolbarExpand Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

In This Section

CB Find Statement