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

This configuration is intended for importing bank transactions published by the Excel functionality.

Create a bank rule #

To add a new type of account details to your organization:

• Step 1. Go to the Settings menu under the Accounting module on the left sidebar -> Select the Banking Rules menu.
• Step 2. Click the button ADD 

• Step 3. In page Banking rule , fill in the following details

1. Enter the name 
2. Select Apply this to transactions that are: Money in or Money out 
3. Select and include the following: All or All
4. Select Description or Amount 
5. Select Contains or Does not contain or Is exactly 
6. Enter the content in the following box
7. Select Then: Assign or Exclude. If you choose Assign, you will continue to select fields in section 8, 9
8. Select payment account and deposit on 
9. Enable auto-add: Any transaction that meets the conditions of the rule will be automatically mapped to the payment account. account and deposit to be pre-selected in the rule.

• For example:
  Step 1: There is a ruler as picture

– in there. Apply it to transactions that are: Money in
– Two conditions: 
+ Description – contains – “Rule 1”,
+ Amount – Is greater than – “100”
– Payment account: Bank charges
– Deposit on: ACB Banking
Step 2: Go to Banking -> Saved Bank Transactions → import Excel into account 123456-ACB with the file as shown below

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

Management of recorded banking transactions #

To view bank account transactions taken from the bank. To get the data in this screen, you can either get the transaction from the bank (by clicking the IMPORT NEW BANK TRANSACTIONS button in  Set up your bank account ) or import the transaction (by clicking on IMPORT EXCEL in  Published banking transactions ).

– First you need to choose a bank account. The data will be obtained based on this bank account.