Creating bank rules helps you to automate more of your bookkeeping. Tell Pandle what to do, and Pandle will categorise transactions, match payments, and assign tax codes. You can also use bank rules to auto-confirm transactions.

Important: Bank rules only apply to transactions entered into Pandle using a bank feed or file import. They will not apply to transactions entered manually.

How to create a bank rule in Pandle

Edit a Bank Rule

How do I know which Bank Rule was used to confirm a transaction?

Related articles

How to create a bank rule in Pandle

Click Banking in the navigation menu, and select 'Bank Rules'.

This will take you to the Bank Rules screen, where you can manage and create rules to help you take care of your bookkeeping.

Click 'New Rule'.

This will open the 'New Bank Rule' screen.

Enter a name and a description

It's useful to add a detailed description to help you identify your Bank Rule more easily in the future.

Set the rule conditions

Use the dropdown menus to select conditions for your rule.

In this example, we want to create a rule to help a fictional marketing agency manage transactions from customers paying their monthly retainer of £600.

  • Using the menus, we selected 'Description' to tell Pandle to look for information in a transaction's description.

  • Then we selected 'Includes', so that Pandle will look for descriptions which include our keyword, rather than matching it exactly.

  • Then we entered the words 'Consultancy Retainer' so that Pandle can use this as the keyword to look for in transactions.

The marketing agency offers customers different levels of monthly retainer, so we'll need to add more conditions to the rule. Click 'Add condition'.

This adds another row of options to help you create conditions for the rule.

In this example, we only want to process transactions for retainers charged at £600 per month. In the new line:

  • We selected 'Money In', because we want Pandle to apply this rule to incoming transactions.

  • Then 'Equal To', so that only transactions matching this exact amount are selected

  • Then we entered '£600' so that Pandle knows what amounts to search for.

Confirm the bank account

Tell Pandle where to look for these transactions. Click the dropdown menu under 'Bank account', and select which accounts you want Pandle to check for transactions meeting these criteria.

To select more than one, click a menu item, and then open the dropdown menu again to select another.

What the rule does

Setting the rule conditions tells Pandle which conditions must be met before taking action. Now it's time to tell Pandle what action to take.

Assign a category

Confirm the category that transactions should be assigned to when they meet the rule conditions.

Click the dropdown menu under 'Assign to this category'. Then scroll through the list, or enter a category name, or add a new category.

Assign to tax code

Confirm the tax code that transactions should be assigned to when they meet the rule conditions.

To minimise mistakes, Pandle will hide the option to select a tax code when you are creating and editing banks rules for customer receipts, if your previously VAT-registered business is no longer covered by a VAT scheme.

Pandle will also hide the tax code when you are entering transactions linked to an invoice, just to avoid any confusion.

Click the dropdown menu under 'Assign to tax code'. Then scroll through the list, or enter a tax code name.

Assign to project

If you use Projects, you can select a project for transactions to be linked to if they meet the rule conditions.

Click the dropdown menu under 'Assign to project'. Then scroll through the list, or enter a project name.

Auto-confirm

You can tell Pandle to auto-confirm or auto-ignore transactions if they meet the rule conditions. This means that Pandle can automatically confirm transactions for you, or ignore them.

If you leave these options blank, Pandle will still categorise and assign tax codes to relevant transactions, and you can confirm them manually.

Save your changes

Once you're ready, click 'Apply This Rule' to save your new Bank Rule, and start applying it to new draft transactions.

Edit Bank Rules

You can view, edit, and manage the Bank Rules you create from the Bank Rules summary page.

Click Banking in the navigation menu, and select 'Bank Rules' to view the summary page.

Click the 'Edit' button next to a rule you want to change.

Make your changes, and click 'Update This Rule' to save them.

How do I know which Bank Rule was used to confirm a transaction?

Select ‘View Transactions’ from the Accounting menu.

To see which transactions have been auto-confirmed by a bank rule, click the ‘More Actions’ button next to a transaction.

If a bank rule was used, the pop-up menu box will confirm which one it was.

To make any changes to the rule, click the rule name (like the example above), and Pandle will take you to the editing screen for that particular rule.

Related articles

Banking

Bank Rules

Did this answer your question?