Fields

Bank Code

The Bank Account to perform the reconciliation for.

Last Statement Date

The closing date of the previous statement. On inserting a new statement the default will be the closing date of the last Closed statement, (can be edited, for example, if other statements are Open for the account). The Opening Balance must equal the Closing Balance for the statement with this date.

Opening Balance

The opening balance for the current statement must equal the closing balance of the last statement. If you are inserting a new statement, (defaults to the closing balance of the last Closed statement and can be edited, for example, if other statements are Open for the account). The Opening Balance must equal the Closing Balance for the Last Statement Date.

Reference

The statement number. If you are inserting a new statement, this is set to the number of the last Closed statement plus one. This can be edited, for example, if other statements are Open for the account.

Period

The period must be equal to or later than the period for all transactions on the statement.

Statement Date

The closing date for the statement. If you are inserting a new statement, enter or import this from the physical statement.

Closing Balance

The statement closing balance. If you are inserting a new statement, enter or import this from the physical statement. The Opening Balance plus the value of the reconciled transactions in the Statement grid must equal the Closing Balance before you can close the reconciliation. You can save the reconciliation without loss of data.

Reconciled Grid

If the statement is:

• Open - the Reconciled grid shows all items on the statement pending reconciliation, and shows an action type for each item. Available action types are:
  • Reconciled - one clear matching unreconciled transaction has been matched.
  • Ambiguous? - two or more unreconciled transactions match at the same level of confidence.
  • Amount? - One or more unreconciled transactions match on amount only, or amount and date only. Matching on Date depends on CB Settings.
  • Future? - One or more unreconciled transactions that match but are past the statement Period are found.
  • Withdrawal, Deposit, Transfer, Receipt or Payment - A rule has been matched to the line. The Rule Type is displayed.
  • Rules? - Conflicting rules have been found. Click Insert > Insert from Rule to select the matching Rule to insert from.
  • Unmatched - No transactions match and no rules apply.
• Closed - the Reconciled grid shows the reconciled statement.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

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

Edit (F11)

Edit the Bank Reconciliation.

Insert (F4)

Insert a new Bank Reconciliation.

Customise Toolbar

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

Reconciled Grid Toolbar

Expand Toolbar (Ctrl+F9)

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

Insert (F4)

When matching transactions on an imported statement, some items may not be on the Statement grid.

To manually add lines, if the selected line does not have a Rule matched, you can select to insert a:

• CB Transaction
• CB Transfer
• AR Receipt
• AP Payment
• AP Cash Purchase
• Unmatched line - Inserts a blank line in the Statement grid. You can type an amount and date, click Find Unmatched (Ctrl+F) to match the item in the Unreconciled grid.
• Split Line - Opens CB Split Line. Available for unmatched lines. Allows the transaction to be split into two transactions.

Once a selection is made the relevant transaction entry window will open with the Bank Account Code, Date, Amount, Reference, Particulars and Comment fields completed with information from the grid (where available). You can add additional information, and for CB Transactions you can analyse the amount to one or more Analysis codes. Tools and options are described in CB Transaction, CB Transfer, AR Transactions Receipt, and AP Transactions Payment.

If the selected line has a Rule matched, and the Action column shows a Rule Type (Withdrawal, Deposit, Receipt, Payment or Transfer) or Rules?, you will have the option to:

• Insert from Rule - Applies the matched rule to the line.
• Unmatched line - Inserts a blank line, see above.

If several matched rules exist and Rules? is shown in the Action column, you will be prompted to select from the list of matched Rules, see CB Select Rule.

Move (Shift+Up) (Shift+Down)

Select a line and move it higher or lower. You can match the physical bank statement with the running balance and the statement balance to find discrepancies.

Delete Unmatched Line (F3)

Select and delete an unmatched line. Unmatched lines have not been matched with a transaction in the Unreconciled grid and appear dimmed.

Open (F12)

Available for Reconciled lines. Opens the original transaction in the relevant form. This can be useful to identify correct transactions.

Sort (Ctrl+F2)

Sort transactions in the Statement grid based on selected fields. For example, you can sort in cheque number order. The ordering is saved and previous ordering cannot be restored.

Customise (Alt+F5)

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

Find Unmatched (Ctrl+F)

Find transactions in the Unreconciled grid with the same reference and/or amount as the selected line. If one exact match is found it will be automatically matched to the selected Statement row.

If you have unmatched transactions on an imported statement, you can use this to locate existing transactions that match the selected item on the statement.

Next Unmatched (Alt+Down)

Move from the selected line to the next unmatched or ambiguous item in the Statement grid.

Add/Edit Rule (Ctrl+R)

If no rule is applied to the currently selected statement line, CB Rules allows you to add a new rule for statement matching. Select the type of rule to add from:

• CB Withdrawal
• CB Deposit
• CB Transfer
• AR Receipt
• AP Payment

If the selected line has a Rule applied, the Rule will open in CB Rules.

If several matched rules exist and Rules? is shown in the Action column, you will be prompted to select from the list of matched Rules in CB Select Rule.

When you add or edit a CB Rule, Match All will be automatically applied (see below).

Customise Toolbar

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

Reconcile Panel

You can match transactions from the Unreconciled grid to items on the Statement grid. You can change the size of the Statement grid by dragging the splitter bar.

Match (Ctrl+Up)

Move the selected transaction on the Unreconciled grid to the Statement grid, and match with selected Statement line if amounts match. You can also double-click the Unreconciled transaction to match the transaction.

Unmatch (Ctrl+Down)

Unmatch the selected transaction in the Statement grid, and move the transaction to the Unreconciled grid. You can also double-click in the Balance field to unmatch the transaction.

Match All (Ctrl+M)

Match unreconciled transactions and Rules with lines on the Statement grid. If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions after Import and on Edit.

Apply Rules (Ctrl+A)

Apply matching rules from the CB Rules List to the statement.

Hide Reconciled

Show Reconciled

Toggle on and off to hide and show reconcile lines in the Statement grid.

To Reconcile

Calculated as Closing Balance less Opening Balance, plus the total value of the reconciled transactions in the Statement grid.

Rules to Apply

Shows the number of lines in the Statement Grid that are matched to a rule.

Unmatched

Shows the number of Unmatched items in the Statement grid. This can be useful if you have matched most items and a few remain for you to find and select the correct transaction. Click Next Unmatched (Alt+Down) on the Statement grid to locate unmatched items.

Unreconciled grid

Shows unreconciled transactions. Transactions from periods later than the statement period are dimmed as they are unavailable. Move transactions from the Unreconciled grid to the Statement grid. Once reconciled and closed, the grid will be unavailable.

Expand Toolbar (Ctrl+F9)

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

Open (F12)

View transaction details in a separate window (useful to ensure you have the correct transaction). If Edit (F11) is available, you can edit the transaction.

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)

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

Refresh (F5)

Transactions reload to reflect changes other Users may have made.

Customise Toolbar

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

Lower Buttons

Print (Ctrl+P)

Click the button to view options:

• Statement - print a copy of the statement.
• Unmatched for Statement - print all unmatched items on the Statement.
• Unreconciled for Statement - print unreconciled transactions as at the Statement Date (for closed statements).
• Reconciliation for Statement - print a reconciliation summary (for closed statements). Deposits, Withdrawals and Closing Balance are calculated up to the Statement Date.
• Print All - Print all available reports for the statement.

Close

Mark transactions in the Statement grid as reconciled, and update the totals of unreconciled withdrawals and deposits. You can only close a reconciliation if the:

• Closing Balance entered is the same as the balance of the statement constructed.
• Opening Balance is the same as the Closing Balance of the previous statement (chronologically), and all previous statements are closed. For example, if the statement for May is open and you try to close the statement for June, messages will appear relating to the Last Statement Date, Opening Balance.

The Print (Ctrl+P) button becomes available, so you can print a Reconciliation Report. You can re-open statements if all later statements are open.

Hint: If the reconciliation does not balance, view pending reconciled items in the Statement grid, compare the Balance field with the bank statement, if they match view the fields to find where they start to differ.

Re-open

Re-open a closed statement. Available if all later statements are open. For example, to re-open the May statement where the June statement is closed, first re-open the June statement.

Import

Open CB Statement Import to import data (for example, a statement from online banking) into the Statement grid. If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions after Import. Accredo provides sample import definition files for major New Zealand banks. You can setup a statement import definition. Setup default Definition and Import files in CB Bank Account - Details tab.

Save (F9)

Mark the Statement as Open in CB Bank Statements. When you select the statement, you will be returned to the current reconciled position.

Cancel (Esc)

Cancels work since the last save. Transactions entered and edited will be retained.