QuickBooks
Bank rules: how to automate coding without creating a mess
How to build QuickBooks Online bank rules that stay accurate, when auto-add is safe, and the rules that quietly corrupt a file.
The short answer
- Bank rules should match on vendor plus amount patterns, not on loose text fragments.
- Auto-add is safe only for fixed, recurring, single-category charges.
- Never write a rule that codes a whole payment processor or a whole card to one account.
- Review rules quarterly; vendors change their descriptors.
Rules that are safe to automate
Recurring, identical charges — internet, software subscriptions, insurance drafts — are ideal. The vendor is constant, the category never changes and the amount rarely moves.
Rules that cause damage
Broad text matches catch the wrong transactions. A rule matching 'AMZ' will code Amazon Web Services, office supplies and a personal purchase to the same account. Payment processors are worse, because one descriptor covers dozens of unrelated purchases.
- Avoid single-word matches shorter than five characters
- Do not auto-add anything with variable categorization
- Never auto-add transfers — they are not expenses
- Keep loan payments manual so principal and interest stay split
Maintenance
Descriptors change when vendors switch processors. Quarterly, review which rules fired and which transactions still land uncategorized, then adjust.
What you see inside LedgerDude
One page with your money in and money out, your cash on hand, and a short list of questions when we need your help.
Questions people ask
Should I turn on auto-add?
Only for fixed recurring charges with one category. For everything else, let the rule suggest and confirm manually.
Why do my rules stop working?
Vendors change their bank descriptors. Rules matching exact old text quietly stop firing.
Can rules split a transaction?
Yes, rules can split by percentage or amount, but loan payments still change over time and should be handled from the amortization schedule.
Keep reading
Reconciling accounts so your books can be trusted
Step-by-step reconciliation in QuickBooks Online, what to do when the difference will not go to zero, and how to repair a bad prior reconciliation.
Connecting QuickBooks Online safely
How the QuickBooks Online connection works, what read-only access means, what data is imported and how write-back approval protects your file.
Fixing an Undeposited Funds balance that never clears
Why Undeposited Funds builds up, how to clear it without double-counting income, and how to stop it from filling up again.
All quickbooks guide library guides
Every guide in this library.
All guide libraries
Accounting, QuickBooks and catch-up.
Our services
Hand the whole thing to us instead.
Want your books handled for you?
We read your receipts, match your bank activity, and close your books every month. You get one short list of questions and a dashboard that always tells the truth.