Bank accounts
Import rules
How statement imports learn your vendors and categories, and how to add, change and delete the rules.
Open in EscBooksWhat a rule does
A rule says: when a statement line's text contains these words, bring it in as this vendor and category, or mark it personal, or leave it out. Rules apply to every statement line as it arrives, whether you upload the statement, your bank feed brings it, or your assistant sends it, and they outrank any guess, your assistant's included.
- What it matches: words, nothing else. Not the amount, not the date. Case and punctuation don't matter, and any word with a number in it is dropped, so SQ *BLUE BOTTLE 8812 AUSTIN TX and SQ *BLUE BOTTLE 0417 AUSTIN TX both read as "sq blue bottle austin tx" and match the same rule.
- The rule's words have to appear whole and in the same order: BLUE BOTTLE matches "SQ *BLUE BOTTLE COFFEE", but not "BLUEBOTTLE" or "BOTTLE BLUE".
- Rules are for charges. Credits, refunds and deposits aren't matched.
- The order: when more than one rule matches, the most specific wins, the one with the longest words. AMAZON WEB SERVICES beats AMAZON. Two of the same length: the older one.
What it can do, under Then:
- Bring it in, as a Vendor, a Category, or both. With the category left on The vendor's usual, the rule sets only the vendor, and the category is chosen as it would be without a rule: the one that came with the line, the vendor's usual one, what you've filed that vendor under most, or a guess from the merchant's name. The category can be one of your custom categories (see Expenses): the rule then sets both, and a rule that names a standard category alone leaves the custom one off. A Bring it in rule brings a line in even when your assistant thought it was personal. It's still checked against what's in your books, so a charge you've already recorded stays out as Already recorded.
- Personal: it stays out, as Personal, by your rule. For your own spending on a business card.
- Leave it out: it stays out, as Left out by your rule. For lines that are never an expense.
Try it: switch the rules on and off, and watch the lines.
Your rules
- BLUE BOTTLEBlue Bottle Coffee · Meals
- AMAZONAmazon · Supplies
- AMAZON WEB SERVICESAmazon Web Services · Computer & IT
- WHOLE FOODSPersonal
- PAYPAL INST XFERLeave it out
The statement's lines
SQ *BLUE BOTTLE 8812 AUSTIN TX$6.75
Read as “sq blue bottle austin tx”
Blue Bottle · OtherEscBooks' own guessSQ *BLUE BOTTLE 0417 AUSTIN TX$5.25
Read as “sq blue bottle austin tx”
Blue Bottle · OtherEscBooks' own guessAMAZON MKTPL*2K4LM1 AMZN.COM/BILL WA$23.49
Read as “amazon mktpl amzn com bill wa”
Amazon · OtherEscBooks' own guessAMAZON WEB SERVICES AWS.AMAZON.CO WA$41.20
Read as “amazon web services aws amazon co wa”
Amazon Web Services · SoftwareEscBooks' own guessWHOLE FOODS MKT #10234 AUSTIN TX$84.16
Read as “whole foods mkt austin tx”
Whole Foods Mkt · OtherEscBooks' own guessPAYPAL *INST XFER 4029357733$200.00
Read as “paypal inst xfer”
Inst Xfer · OtherEscBooks' own guessAMAZON.COM REFUND-$23.49
Read as “amazon com refund”
A credit: rules don't apply
How rules are learned
You don't have to write rules. When you review a statement:
- Change a line's vendor or category, and Remember for next time appears under it, ticked.
- Untick a line, and Always leave out appears, unticked, since leaving one line out is often a one-off. Tick it to make it a rule.
- The bar at the bottom counts them: 2 rules for next time.
The rules are saved when you add the statement's expenses with the button at the bottom (Add 4 Expenses, say, or Approve). A learned rule matches on the vendor's name the line first came in with, when the statement text holds it ("SQ *BLUE BOTTLE COFFEE AUSTIN TX", which came in as Blue Bottle Coffee, makes BLUE BOTTLE COFFEE), and otherwise on the line's whole text, numbers left out. Change a line that a rule brought in, with Remember ticked, and that rule is updated instead of a new one made.
Some lines never teach a rule: ones left out because they're already recorded (that's about your books, not the merchant), credits, and lines you explained as something else, like a client's payment.
Adding a rule from a statement line
- On a statement waiting for review, find a charge no rule caught and click the wand, Add a Rule.
- It starts from the line: Statement text contains holds the vendor's name when the statement says it, or the line's words; Then follows its tick; the vendor and category are the line's. Shorten the words to catch more (BLUE BOTTLE rather than BLUE BOTTLE COFFEE), and change what it does.
- Click Add Rule. Every charge on this statement with those words follows it at once, and so will every statement after.
The words need at least two letters, and each set of words can have only one rule: "There's already a rule for those words" means it's time to edit that one instead.
Changing a rule from its line
A line a rule caught shows Your rule, whether the rule added it or left it out, and so do the lines a rule you just added here caught. Hover it to see the words it matched. Click it to open Edit Rule, change it, and Save Rule. While the statement waits for review, the lines on it that the rule caught follow the change. Expenses already in your books stay as they are.
A line a rule caught has no Remember for next time: the rule already remembers it.
All your rules
Settings → Import Rules lists every rule, A to Z: its words, what it does, and how many times it's been used, and when last.
- Add Rule writes one from scratch. Type the words as they read on the statement.
- The pencil edits a rule; the trash deletes it.
- Deleting a rule changes nothing already in your books: lines with those words just go back to EscBooks' own guess.
Your assistant reads your rules before it prepares a statement, and is asked to follow them in its own choices too. See Your AI assistant.
Still need help?
A person reads every message and replies by email. Contact support