Bank rules¶
Some lines turn up on your statement every month: the bank's service fee, your phone bill, a software subscription. A bank rule says what such a line is, so that when you reconcile it, everything is filled in and you only click OK.
A rule only ever suggests. Nothing is created or posted until you reconcile the line.
Open the Bank rules tab on any bank account, next to Reconcile, so you can add a rule while you reconcile. The same list is under Bank rules on Accounting › Bank accounts. Back on Reconcile, lines are filled in with your new rules.
Add a rule¶
Click New bank rule.
A rule is set up in four steps.
- 1. Apply the rule to
-
Pick the money it's for (Money out, Money in, or Money in or out), and whether Any condition matches or All conditions match. Then fill in the conditions, one row each: the Field, the Condition and the Value. Add condition adds a row (up to 10); a row left empty is left out.
Field Conditions Any text field (the description, payee or reference), Description, Payee, Reference contains, doesn't contain, is, starts with, in any capitals Amount is, is at least, is at most, money in or out, to the cent Any text field doesn't contain holds when none of the three contains the words.
- 2. Set the contact
- Optional, the client or supplier it's with. Left empty, the line's payee is used as the name.
- 3. Record it as
- Receive money or spend money for the whole amount, tax included: the Description (the line's, when left empty), the Account the money goes to (Bank Fees, Telephone & Internet…) and the Tax rate (No tax when there's none).
- 4. Add rule details
- Run this rule on all bank accounts or just one, and Name the rule (left empty, it's named after its first condition).
Click Save rule. A new rule goes to the bottom of the list.
A rule can't put money into Accounts Receivable, which changes only through invoices, credit notes and payments, or into another bank account: use a transfer for that. Its tax rate must suit the money's direction: a purchase rate for money out, a sales rate for money in. On a US chart a rule for money out takes no sales tax.
From a bank line. While you reconcile, tick Make a bank rule on Create: BaseCloud makes a rule for lines in the same direction with the same payee (or, with no payee, the start of the same description), recording them the way you filled this one in. See Bank reconciliation.
Many lines at once. On the reconcile screen, OK all … rule lines OKs every line a rule fills in. See Reconcile many lines at once.
Examples¶
| Rule | When a statement line… | Then record it as |
|---|---|---|
| Monthly bank fee | money out, description contains service fee |
Bank Fees, no tax |
| Phone bill | money out, payee is Verizon |
Telephone & Internet, contact Verizon |
| Interest | money in, description contains interest |
Interest Income, no tax |
| Calls | money out, any of: payee is Telnyx, description starts with TELNYX |
Telephone & Internet |
| Small card fees | money out, description contains fee, amount is at most 10 |
Bank Fees, no tax |
In South Africa, a VAT-registered business can give a bank fee rule your 15% VAT rate when the fee carries VAT, so the VAT is claimed back. In the US, leave the tax rate on No tax for fees and purchases.
Change or delete a rule¶
The Bank rules list shows each rule's name and bank account, When a line it applies, and what it's Record it as.
Which rule wins. When a line meets more than one rule, the highest in the list is used. Drag a rule by its handle to move it up or down; the new order is saved straight away. Click Edit to change one, or Delete to remove it. Rules are settings, not entries in your books, so changing or deleting one changes nothing you've already reconciled. To stop using a rule, delete it.