Banking rules & Import bank transaction in Tagrit ERP

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 banking rule to your organization, follow these steps:

• 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. 
   1. Name: enter a meaningful name for the rule.
   2. Apply this to transactions that are: select either Money In (incoming funds) or Money Out (outgoing payments)
   3.Condition type : choose whether Any or All of the conditions must be met
   4. Filter Field: choose between Description or Amount for the field to be checked
   5. Condition: Choose one of the following:
   Contains
   Doesn't Containt
   Is exactly 
   6. Value: eter the keyword, amount or value to be matched based on the condition above. 
   7. Then: Choose one of the following action: Assign or Exclude. If you choose Assign, you will continue to select the fields in section 8, 9. If you choose Exclude, skip mapping if matched. 
   8. Mapping Type: If you selected Assign, choose hơ to allocate the 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, allocate specifix amounts to each account

9.  Auto-add (optional):  when this is enabled, any transaction that matches the rule's conditions will be automatically mapped to the selected Payment account and Deposit to account. 

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.