Knowledge

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

This configuration is for import transaction and Download transactions in Banking Feeds

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. Select the Description or Amount 
  5. Select the Contains or Doesn't Containt or Is exactly 
  6. Enter the content in the next box
  7. Select the Then: Assign or Exclude. If you choose Assign, you will continue to select the fields in section 8, 9
  8. At Mapping Type: choose 1 of 3 options: Full Amount, Split by Percentage, Split by Amount
  If you choose Full Amount, the entire amount will be mapped into 1 account
  
  If you choose Split by Percentage, the amount will be divided by percentage and mapped to each account
  
  If you choose Split by Amount, map a fixed amount to each account.
  
  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
  
  
• Step 2: Go to Banking -> Banking Feeds→ Click on the gear icon in the right corner and select Import transactions--> then  import excel into ACB Bank  with the file as shown below
  
  
  
  
  
  
  

Result: only the 1st line in the file meets the rule and automatically maps to the corresponding accounts. 


The amount is divided into parts and mapped to each account selected in the banking rule


You can edit or delete the transaction you just imported.