Transaction Rules

Using Transaction Rules, you can automate the categorization of the bank feeds. Transaction rules in the banking module will help you to identify and categorize bank transactions based on criteria you’ve set.

Add a New Transaction Rule

To create a new transaction rule:

Banking Banking Banking

Now you can enter the criteria for which you are looking to categorize transactions. For both deposits and withdrawals, you can select from,

Fields Descriptions
Payee The name of the person or organisation with whom the transaction would happen. This should match with the name that appears in the feeds.
Description Description can be a note or info about the transaction that is to be recorded.
Reference Number The number with which a transaction is referred. It can either be an automatically generated sequence or manually recorded.
Amount The amount you wish to have in the transaction.

For types such as Payee, Description, Reference Number, the matching criteria will be given in the next box as is, contains, starts with, is empty.

Options Description
Is The payee name, description or the reference number should be exactly matched with the same name as what is given in the criteria to the transaction.
contains The payee name, description or the reference number can contain any part of the criteria in the transaction.
starts with The payee name, description or the reference number in the transaction should start with the entry given in the criteria.
is empty The payee name, description or the reference number should be empty.

For the Amount type, the matching criteria will be,

Fields Description
Record As For Deposits: On selecting the Apply To option as Deposits, you can record your transactions as per the options given under Record As drop down.

For Withdrawals: On selecting the Apply To option as Withdrawals, you can record your transactions as per the options given under Record As drop down.
Account The account in which the transactions need to be routed.
Paid Via You can select the payment mode from the drop down.
Reference Number Select Use Value from Bank Statement to detect the reference number automatically from your bank statement. If you want to enter the reference numbers manually, select Enter Manually.
Add Transactions in This Rule To Recognized Transactions: Select this option if you want to categorize your bank statements manually.

Categorized Transactions: Select this option if you want Zoho Books to categorize your transactions based on this rule.

Check the Allow Zoho Books to categorize my bank statements option if you selected Categorized Transactions. Select who should categorize your bank statements.

Edit a Transaction Rule

To edit a transaction rule:

Banking

Delete a Transaction Rule

To delete a transaction rule,

Banking

Note: You cannot delete transaction rules created for Categorized Transactions. To delete them, edit the rule and select Recognized Transactions under Add Transactions in This Rule To field.

Warning: Once deleted, the rule details will be removed from Zoho Books permanently and cannot be retrieved. However, the transactions that were categorized based on the transaction rule will not be affected.

Next >

Related >

Was this document helpful?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial

Books

VAT ready accounting
software for small
businesses.