Skip to the guide
IQ Booksby ReconcileIQ

Banking · Guide 31 of 53

Advanced coding: telling CodeIQ how to read a bank line

Coding rules change what CodeIQ reads on a bank line before it codes it: who really paid, which noise to strip, and which lines must never be matched to an invoice. Each rule reads as a sentence.

Bank rules decide the category. Coding rules work one step earlier: they change what CodeIQ reads on the line, so it can match the right invoice and pick the right category by itself. Most books need none. They earn their place when a bank line is misleading as it stands.

Where to find them

Banking → Advanced coding. The list shows each rule as a sentence, for example When the bank text contains BINGLEY, the payer is Bingley Motors Ltd, remove BGC, with how often it has been used, an on/off switch and a delete button. Click a rule to edit it.

When a rule helps

  • Nobody is named. A customer pays from an account that shows only a reference such as ACC 388833. Name the payer and CodeIQ matches their invoices.
  • Someone else pays. A parent company or a finance house pays on a customer’s behalf. Say who the payment is really for.
  • Noise. Bank codes such as BGC, FPI or card numbers get in the way. Remove them or drop reference numbers.
  • Never an invoice. HMRC, payroll or loan repayments look like payments but are never against an invoice. Keep them off invoice matching.

Making a rule

  1. Start from a common case (Name the payer, Someone else pays, Strip noise, Keep off invoices) or click New rule. A drawer opens on the right; the list behind it stays put.
  2. Give it a name at the top.
  3. Say which lines it applies to. The drawer starts with Contains any of, one phrase per line. Add condition brings in anything else you need, one row each: must also contain, must not contain, starts with, is exactly, a pattern, whole words only, money in or out, an exact amount (with give or take), at least or at most, particular banks, a date range, days of the month and days of the week.
  4. Say how CodeIQ should read them. Choose the payer (nobody named, a customer, a supplier or someone else). Add action adds the rest: drop reference numbers, remove words, replace a pattern, add words before or after, read the whole line as something else, never match invoices or bills, never hold as part payments, and a note for whoever reviews these lines.
  5. Watch the preview. As you type, the drawer shows how many of your recent bank lines match and, for each, the bank’s text next to what CodeIQ will now read.
  6. Add the rule. It applies to lines CodeIQ codes from now on.

Remove a row with its cross. Priority and order sets which rule wins when two match, and Stop here makes lower-priority rules ignore a line this rule has handled.

Related guides

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.