CB Bank Reconciliation

Navigator > Tasks > Cash Book > Bank Reconciliation (see CB Bank Statements) > Select Reconciliation - OR -

Navigator > Tasks > Cash Book > Bank Reconciliation (see CB Bank Statements) > Insert button

Use CB Bank Reconciliation to reconcile bank statements against transactions. Statement lines can come from a bank feed, which imports them overnight (see Importing Bank Feeds below), from a statement file exported from online banking, or from a paper bank statement by entering details (see Reconciling from Paper Statements below). Statement details are matched against unreconciled transactions (shown in the Unreconciled grid) and against CB Rules.

Ensure the Last Statement Date and Opening Balance fields correspond with the opening date and opening balance of the bank statement you are reconciling. The defaults for the fields are the Closing Date and Closing Balance of the last closed statement. Enter the current statement Reference, Period, Statement Date and Closing Balance in the fields. For a statement the overnight bank feed import creates, Period and Statement Date are set from the statement cadence, and Closing Balance from the bank where it supplies a balance.

Importing Bank Feeds

A bank feed is the preferred way to bring statement lines in: there is no file to export from online banking or to import. For a bank account with Bank Feeds Enabled selected on CB Bank Account - Details tab, statement lines are imported from the bank feed every night, and can be imported for a date range with Import Bank Feed. Imported lines carry the provider's transaction id in the Bank Feed ID column, so a transaction is never imported twice. Where the bank supplies a balance, the Closing Balance is set from the balance after the last imported transaction, so a missing transaction shows as a statement that does not balance. If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions. See Bank Feeds.

Importing Statements

Click Import (Alt+I) to import a statement you have exported from online banking into the Statement grid. (See CB Statement Import.) If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions (see the Match All button below). Any unmatched lines appear dimmed with an Action Unmatched on the Statement grid.

Reconciling from Paper Statements

You can double-click transactions in the Unreconciled grid, or click the Match button above to move transactions from the Unreconciled grid to the Statement grid. You can also enter details such as Particulars, Reference, Debit/Withdrawal or Credit/Deposit, and match with Unreconciled transactions (see the Match and Match All buttons below). You can key in transactions that are not yet entered in the data but appear on the paper statement, such as bank fees.


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 bank statement. For a statement the bank feed import creates, the last day of the statement span set by the statement cadence on CB Bank Account - Details tab.
Closing Balance			The statement closing balance. If you are inserting a new statement, enter or import this from the bank 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. For a statement imported from a bank feed, set from the bank's balance after the latest imported transaction where the bank supplies one, so a missing transaction shows as a statement that does not balance. Where the bank supplies no balance it is calculated from the statement lines.
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. Lines imported from a bank feed carry the provider's transaction id in the Bank Feed ID column, which you can show with Customise. It is read-only, and is what stops a transaction being imported twice.
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, after a bank feed import, and on Edit.
		Apply Rules `(Ctrl+A)`		Apply matching rules from the CB Rules List to the statement. The bank feed import matches lines to rules but never applies them, so click Apply Rules to create the transactions.
		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. For a statement imported from a bank feed with the bank's closing balance, a difference usually means a transaction has not yet come through from the bank. Import again with Import Bank Feed, or wait for the next overnight import.
		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. For a bank account with Bank Feeds Enabled selected, available only when File Import Enabled is also selected.
		Import Bank Feed		Open CB Import Bank Feed to import transactions from the bank feed for a date range into the Statement grid. Available when Bank Feeds Enabled is selected and an Account is set on CB Bank Account - Details tab. Transactions already on a statement are skipped. If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions after Import.
		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.