To fix uncategorized transactions, group the lines by vendor, code the ones you recognize, send the client one short list of the rest, and turn every answer into a rule. Fixing lines one at a time clears this month's pile. Writing the rule is what stops the same lines returning next month.
Why do uncategorized transactions pile up?
Uncategorized transactions pile up because a line reaches the books before anyone knows what it was for. The bookkeeper cannot guess, the client has not been asked, and the line waits in a holding account such as "Uncategorized Expense" or "Ask My Accountant". The pile grows when asking is slow.
The usual sources
Most piles come from a handful of causes:
- Cryptic descriptions. Card processors print prefixes, codes and city names, so "SQ *" or "AMZN Mktp" says little about what was bought.
- Lines no rule covers yet. A new vendor, a one-off purchase or a changed payee name has no rule to match.
- Client activity you cannot see. Cash withdrawals, transfers to a spouse, or a payment for a project you were not told about.
- Bank feed or import defaults. Many tools post unmatched lines to a default account, which looks like progress but only moves the problem.
- A backlog. When statements arrive months late, every vendor is unknown at once, and the pile is large because no monthly pass ever happened.
Why a pile is a problem
An uncategorized balance is not a category. It sits inside expenses or income on the report and hides what the client spent. Taxes, budgets and any lender review read the wrong numbers. The pile also gets harder with age, because the client remembers a purchase from last week better than one from last spring. That is the strongest argument for clearing it every month rather than at year end.
If the pile is the result of a client who is months behind, start with the plan in the guide to catching up months of client statements, then come back here for the clean-up.
Should you sort uncategorized lines by vendor or amount?
Sort by vendor first, then by amount inside each vendor. Grouping by vendor lets you code many lines in one decision, and it shows which vendors are worth a rule. Sorting by amount first is useful only to find the few large lines that deserve the client's attention.
Why vendor first
Suppose a client has 140 uncategorized lines. Sorted by date, that is 140 decisions. Sorted by vendor, those lines might come from 35 payees, and 20 of them appear more than once. Coding a repeating vendor once covers every line. One decision handles many lines, and the same decision becomes a rule.
When amount comes first
Use amount as a second pass. After vendor grouping, take the lines still unresolved and sort them by size. Large unknowns can be capital purchases, loan payments, owner draws or personal spending, and a wrong guess costs more. Small unknowns, like a 4.50 parking charge, can wait or be coded to a general account by a standing rule you agree with the client.
A triage table
Sort every line into one of three outcomes. The lines below are made up for illustration.
| Example line | Amount | Outcome | Why |
|---|---|---|---|
| SQ *FLOUR SUPPLY CO, seen every month | 412.80 | Make a rule | Recurring vendor, clear category |
| Office supply store, first time | 63.19 | Fix now | The vendor name tells you the category |
| CHECK 1042 | 2,400.00 | Ask client | No description, large amount |
| TRANSFER TO SAV 8821 | 1,000.00 | Fix now | Matches the client's own savings account |
| ATM WITHDRAWAL | 200.00 | Ask client | Purpose is unknown |
| VENMO PAYMENT | 85.00 | Ask client | Could be a supplier or a personal payment |
| Monthly bank fee | 12.00 | Make a rule | Same fee every month |
Fix now means you can decide yourself. Ask client means only the client knows. Make a rule means the vendor will come back and should be coded once for good. A single line can be both fix now and make a rule, and most recurring vendors are.
Questions to ask a client about unknown transactions
Ask the client for facts, not categories. A client who is asked "what category is this?" usually guesses or does not answer. A client who is asked "what did you buy, and for whom?" can answer in a few words, and you pick the category from the answer.
Keep the list short
Send one message per month, with a numbered list, each line showing date, payee and amount. A list of fifty items rarely gets answered. A list of eight often does. Put the largest and the oldest first, and leave out anything you can settle from the description or from last year's coding. A screenshot or a spreadsheet the client can type next to is easier than a long email thread.
The questions that work
- What was it for? A purpose in the client's own words.
- Business or personal? A yes or no, with a note if mixed.
- Is there a receipt or an invoice? If yes, ask for a photo; if not, note that.
- For which project, property or customer? Only if the client tracks that.
- Does this repeat? If yes, you can write a rule.
A client question email template
Use this as a starting point and change the wording to suit your client. The values are examples.
Subject: 8 transactions I need your help with, March
Hi Sam,
I'm finishing March for Example Bakery LLC and have 8 transactions I cannot categorize from the bank description alone. For each one, please reply with what it was for, and whether it was for the business or personal. If you have a receipt, a photo is enough.
- Mar 4, CHECK 1042, 2,400.00
- Mar 9, ATM WITHDRAWAL, 200.00
- Mar 14, VENMO PAYMENT, 85.00
- Mar 21, ONLINE TRANSFER REF 5530, 600.00
(…the rest of the list…)
If you can reply by Friday, March will be done by Monday.
Thanks, Alex
A line like "Friday" and "Monday" tells the client what their answer buys. It also gives you a reason to follow up on a set day.
What to do with no reply
If a line stays unanswered after a second request, code it to an agreed holding account such as owner's draw, or leave it flagged, and say so in your handover note. Do not invent a business category for money you cannot trace. At year end, any remaining unknowns go to the client's CPA with a note; the year end bookkeeping checklist lists what else to pass along.
Turning a fixed uncategorized line into a rule
A fixed line becomes a rule when you record the vendor text and the category together, so the next matching line is coded automatically. Write the rule while the answer is fresh, because the question you just asked the client is the one you would have to ask again.
What makes a good rule
A good rule matches the stable part of the description and ignores the part that changes. "FLOUR SUPPLY" is stable. "03/13" and a store number are not. Match on the shortest text that is still specific, and avoid text so short that it catches other vendors. A rule for "AMAZON" can be wrong for a client who buys both supplies and personal items there, so it may need an amount range or a review step.
Rules per client, not across clients
A rule belongs to one client's books. The same vendor can be office supplies for one client and cost of goods for another. In AutoBankConvert, each client workspace keeps its own rules and history, and approving a suggestion in the review queue teaches that client's rules, so the same vendor is categorized automatically the next month. For how rules are matched to lines, see how categorization rules match a transaction.
Rule or one-off?
Not every answer deserves a rule. Use this test:
- Has the vendor appeared before, or will it clearly appear again?
- Is the category the same each time?
- Is the line safe to code without a human glance?
If all three are yes, write the rule. If the category varies, route the vendor to review instead. If it is truly one-off, code the single line and move on.
Check the rule once
After saving a rule, run it over the past few months and look at what it would have changed. A rule that recodes ten lines correctly is working. A rule that recodes lines you did not mean to touch is too broad. A minute of checking saves a cleanup later.
Uncategorized transfers between a client's own accounts
A transfer between a client's own accounts is not income or an expense, so it should never sit in an expense category or stay uncategorized. It moves money from one balance sheet account to another, and it appears on two statements, once as money out and once as money in.
How they end up uncategorized
Transfers look like ordinary lines. "ONLINE TRANSFER TO CHK 4417" or "PAYMENT THANK YOU" has no vendor. When only one side of a transfer is imported, the other side has nothing to pair with, and the tool leaves the line uncategorized or posts it as an expense.
How to fix them
- Find the matching line in the other account, same amount, same day or within a few days.
- Code both lines to the same transfer or clearing account, one as money out and one as money in.
- If the other account is not in the books yet, ask the client whether it exists. A missing account is a missing set of statements.
- Check that the transfer account nets to zero over the period. A balance left over means one side is missing or the amounts differ.
Credit card payments
A payment to a credit card from checking is the most frequent transfer. The purchases are the expenses, recorded from the card statement; the payment only moves cash to pay down the card. Coding it as an expense counts the same money twice. The post on credit card statement bookkeeping shows the treatment in a worked example.
A transfer rule
Because transfer descriptions repeat, they make good rules. Write one rule per account pair, such as the client's checking to savings transfer, and the lines code themselves from then on. If you want to see a batch of statements converted, categorized and flagged for review in one pass, the AutoBankConvert homepage shows how it works.