How Bank Rule Conditions Work

How Bank Rule Conditions Work

  • 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 

Text field 

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.  

Comparison 

Option Description 
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 

Values 

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]. 

Share this post

Leave a Reply

Your email address will not be published.