How Bank Rule Conditions Workadmin
- Clickentry applies bank rules to statement lines depend on the conditions you’ve set.
- The rule you want to create can be simple with only one or two conditions or it can be a complex one with multiple conditions that evaluate several pieces of information.
About Bank Rule Conditions
For every bank rule, there must have at least one condition, but you can add as many as you want to create the rule.
When you want to create a bank rule while you are reconciling or cash coding, Clickentry will automatically add conditions depends on the statement line, using an equal comparison.
Bank rules and titles are not supposed to include any punctuation or special characters. It should use only letters and numbers.
The Difference Between Any and All
All – When you select the option All while setting conditions then the rule will be applied only if all the conditions are met. If any of the conditions don’t match then the rule will not run. This way it is quite restrictive.
Any – When you select the option Any while setting conditions, the rule will be applied if any of the conditions are met. If one or more conditions don’t match then the rule won’t fail. This way it is less restrictive.
Condition Fields Explained
You can select any text field, such as Payee, and Clickentry will apply the rule if that particular field meets the condition.
When you select Any text field then Clickentry will search the Payee, Description, Reference and Amount fields on the bank statement line. Clickentry will apply the rule if one of the fields meets the condition.
|equals||The value in the field in the bank statement line should match exactly|
|contains||The value in the field in the bank statement line must contain the value|
|starts with||The value in the field in the bank statement line must start with exactly the same value|
|is blank||The value in the field in the bank statement line must be blank|
Enter the appropriate value to meet the condition for the comparison options like equals, contains or starts with.
Allocate Fixed Value Line Items and the Remainder
Clickentry allows you to create your bank rule to allocate one or more fixed-value portions of the transaction to an account in your chart of accounts.
Once you set up any fixed value allocations, you need to tell Clickentry what to do with the balance of the transaction. Either you can allocate the remainder or you can split it between two or more. Besides this, you assign a tracking category to these lines if you require.
- Enter the amount of a fixed value allocation as either a positive or negative number. You can enter the amount value with up to two decimal places.
- Enter the percent value of a remainder allocation as either a positive or negative number. It can be with up to two decimal places
Add a Comments Placeholder
You can use the text from a comment added to a bank statement line by adding the comment placeholder to your bank rule. For this, you have to place the placeholder in the Description field of a fixed or remainder. Syntax for placeholder is square brackets around it, for example [Comments].