Knowledge

The banking rules page is used to create and manage data for automatic classification of common recurring transactions.

This configuration is for import Posted Bank Transaction by excel feature

Create banking rule

To add a new account detail type to your organization:

• Step 1. Go to the Setting menu under the Accounting module in the left sidebar -> Select the Banking rules menu. 
• Step 2. Click on the Add button
  
  
• Step 3.  In the Banking rule page, fill in the following details
  
  1. Enter the Name 
  2. Select the Apply this to transactions that are: Money in or Money out 
  3. Select the and include the following : Any or All
  4. Delect the Description or Amount 
  5. Select the Contains or Doesn't Containt or Is exactly 
  6. Enter the content in the next box
  NOTE: The keyword in the rule must exactly match the transaction content and is case-sensitive. For example, if the transaction description is “CREDIT”, the keyword in the rule must also be “CREDIT”
  7. Selec the Then: Assign or Exclude. If you choose Assign, you will continue to select the fields in section 8, 9
  8. Selec the Payment account and Deposit to 
  9. Enable the Auto-add: Any transaction that meets the conditions of the rule will automatically be mapped to the Payment account and Deposit to preselected in the rule.
• For example:
  Step 1: there is a rule like the picture

- in there Apply this to transactions that are: Money in
- Two conditions: 
+ Description - contains - “Rule 1”,
+ Amount - Is greater than - “100”
- Payment account: Bank charges
- Deposit to: Bank ACB
Step 2: Go to Banking -> Posted Bank Transactions → click Import excel -> import excel into Bank ACB account with the file as shown below

Result: only the 3rd line in the file meets the rule and automatically maps to the corresponding accounts