Toolbar

Expand Toolbar (Alt+F9)

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

Edit (F11)

Edit the saved rule.

Insert (F4)

Open the drop down menu. You can add another rule.

Duplicate (Shift+F4)

Create a duplicate of this rule.

Delete (F3)

Delete the rule.

Customise Toolbar

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

Rules Fields

Rule Type

The transaction type to apply the rule to, select from:

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

Bank Code

Select the bank account to apply the rule to.

For Withdrawal and Deposit Rules, if no Bank Code is selected, the rule will be applied to all bank accounts.

For Receipt, Payment and Transfer Rules, if no Bank Code is selected, the rule will be applied to all bank accounts that match the Customer, Creditor or Transfer Code currency.

If a Bank Code is selected, the Customer, Creditor or Transfer Code currency must match the Bank Code currency.

Match 1 - 4

Enter the text to be used to match to the statement. You can use the * and ? wildcard characters. The text will be used in a "contains" match, so if the statement contains the Match 1-4 text, it will be matched.

Note: On Save Match 1 through 4 and the related Match Exact fields are updated preferentially into Match 1 then Match 2 etc. e.g If you have a Match value in Match 3 and nothing in Match 1 or 2 it will move to Match 1 On Save. This makes it easier when reviewing rules to filter and/or sort them.

Exact Match 1 - 4

Selected, matching looks for an equals rather than a contains match for that value. When selected, wild card characters are treated literally, rather than as wild-cards.

Match Amount

An amount in the Bank Account currency code, used for matching. If the Match Amount is entered, it must be matched exactly.

If this is not entered, at least one Analysis line must also have a blank amount for analysis.

Transfer Code /

Customer Code /

Creditor Code

Select the Code to apply to the matched transaction. Required for CB Transfer, AR Receipt, AP Payment and AP Cash Purchase rules.

Regime

The tax regime to apply the rule to. For Withdrawals, Deposits and Transfers, this defaults to the Base regime. For Receipts, Payments and Cash Purchases, this defaults to the Regime of the Customer or Creditor. Tax regimes of the Bank Account are available.

Branch Code

The branch the rule is to be applied to.

Department Code

The department the rule is to be applied to.

Last Used

Displays the date the rule was last applied. (Read-only)

Analysis Fields - Withdrawal, Deposit and Cash Purchase Rules

The Analysis Grid is used to enter the analysis breakdown of the matched transaction. You can enter one or many lines of analysis.

Analysis Code

Select an Analysis code to analyse the matched transaction to. (Required)

Analysis Name

Name of the Analysis Code. (Read-only)

GST Code

The GST Code. Defaults from the Analysis Code, but can be changed.

Percentage

Available when a Match Amount is not specified. Apportion between multiple analysis lines by percentage.

Any lines where Amount is specified are first deducted from the transaction amount and the remaining transaction amount is apportioned by percentage, e.g. a fixed fee portion of a transaction specified as an Amount, and remaining analysis split by Percentage.

If percentages are used they must add to 100%.

Amount

The GST exclusive amount of the dissection line. This can only be entered if a Bank Code is selected.

If there is only one dissection line with no Amount, and the Match Amount is also not entered, all dissections will be added to the matched transaction, and transaction will be balanced to the line with no Amount.

If there is more than one dissection line with no Amount, and the Match Amount is also not entered, you will be prompted for the analysis.

GST

The GST to be applied. Calculated from the GST Code and the Amount.

Inclusive

The GST inclusive amount of the dissection line. If the Match Amount is entered, lines must add up to the Match Amount.

Branch

The Branch to analyse the amount on the line to.

Dept

The Department to analyse the amount on the line to.

Narration

Narration for the transaction. If you perform detailed transfers to General Ledger, the narration will be carried through to General Ledger Batch lines.

Currency

The Currency of the Bank Code. For Cash Purchases, for a match to occur, the Creditor must have the same currency as the bank account.

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)

Insert a new analysis at the selected line.

Move (Shift+Up) (Shift+Down)

Select an analysis and move it higher or lower on the grid.

Delete (F3)

Delete the selected analysis.

Customise (Alt+F5)

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

Balance Analysis (Ctrl+=)

Highlight an analysis and use this to adjust the selected grid line and make the total analyses add up to the figure in the Balance To Analyse field below.

Summary Fields

GST Fields

The GST content of the amount analysed in the grid.

Balance to Analyse

The amount yet to be analysed to an Analysis Code.

Buttons

Rules List (Alt+L)

Open the CB Rules List, with the current rule selected.

Save (F9)

Save changes to the rule.

Cancel (Esc)

Close the form and do not make any changes.