It's not easy to reconcile bank statements with business transactions especially if you have hundreds or even thousands of transactions a month.
It's tedious, time-consuming, and straining to the eye, spending hours mapping one transaction to another.
However, with the power of automation, you can set specific bank rules in Deskera Books+ and let the automation do the work for you.
Follow the steps below to set the bank rules:
- Login to your Books+ account.
- Click on Bank via the sidebar menu.
3. On the bank page, click on the Rules button.
4. Next, in the rules page, click on the "+ Add Rule" button.
5. A pop-up box will appear. Fill in the details below:
- Name - Enter the rule's name.
- Type - Apply the rules to either Credit or Debit entry
- Bank Account - Choose from the list of bank accounts you have saved in the Bank Module.
- Conditions - Select the conditions available; in the event in which the Description, Payee, Transaction Date, or Amount is exactly, contains, or doesn't contain specific values. You can add multiple conditions here. Also, you get to decide whether all conditions have to be fulfilled or only certain conditions to be fulfilled for the rule to works
- Action- Enter the values for the contact, account, tax component, payment method, reference number, transactions type, and memo fields
- Choose either to review and create or auto-create the transactions in your organization
6. Click on the view matching transactions. If there is no matching transactions, no record will appear in the following page. You can click on the save button to save this bank rule.
7. You can view the bank rules created in the Bank Rule page.
How does the bank automation works?
Once you have created the bank rule as per the conditions configured, the data will be auto-populated when the conditions are met.
For instance, when you are reconciling a bank feed to Deskera transaction, the data will be auto-populated for the fields configured earlier.
How does the bank rules help auto-categorize my expense transactions?
Set the bank rules as per the configuration above for expense transactions
Once you have imported your bank statement to the system, the system will trigger the expense transactions rule if all the conditions are fulfilled.
For example, if your bank feeds match the conditions above, payee name matches to John Doe, the system will auto-populate the fields configured.
Click on the create button.
The bank record will be reflected as matched.
How can I edit, delete, or deactivate the bank rules?
Click on the edit button under the action column.
A pop-up box will appear.
You can edit the bank rules configured earlier.
The changes will reflect only to new records created in the system.
Click on the delete button to remove the bank rule completely from the system.
If you wish to deactivate the bank rule, click on the active button and select the inactive button.
You can use the drag-and-drop feature to change the rules' priorities.