Home › Blog › Cleanup & Catch-Up Bookkeeping › Categorizing a Year of Transactions
Categorize a full year of bank transactions consistently: build rules from recurring vendors, separate owner transfers from income, and review in passes.
By StatementVerified Editorial · November 4, 2026 · 6 min read · Filed under Cleanup & Catch-Up Bookkeeping
Categorizing twelve months of transactions is where catch-up bookkeeping either becomes systematic or becomes a slog. Done transaction by transaction with no plan, it is slow, inconsistent, and exhausting: the same vendor lands in three categories depending on the day, and the resulting reports cannot be trusted even where individual choices were reasonable. Done with rules, passes, and a short list of genuine questions for the client, the same year organizes itself in a fraction of the time and reads as one coherent set of books.
The method has three layers. First, let patterns do the heavy lifting: recurring vendors, fixed payments, and transfers follow rules you set once and apply everywhere. Second, work in review passes, each with a different question, instead of trying to perfect every line in one viewing. Third, separate what only the client can answer into a tight question list, so their attention lands on the twenty transactions that need it rather than the two thousand that do not.
Sort or group the year by description and the structure reveals itself: payroll runs, rent, utilities, software subscriptions, fuel, regular suppliers, and bank fees repeat month after month in recognizable forms. Create a rule for each recurring pattern, vendor text to category, and apply it across the whole year in one action. This handles the large majority of lines in most small business accounts and, crucially, handles them identically, so March and November describe the same kind of spending the same way.
Treat rule creation as a decision worth a moment of care, because a rule applied two hundred times multiplies any error in it. Check the odd instances of each pattern before committing: the supplier payment that was unusually large may be equipment, the familiar card payment in December may include a personal purchase. Sample the largest and smallest occurrences of each recurring vendor, confirm they belong in the same category, and only then let the rule run. Rules with exceptions noted are still rules; you simply peel the exceptions off first.
The most damaging categorization errors in a cleanup are not wrong expense accounts; they are movements of money recorded as if they were earnings or spending. A transfer from the owner personal account is not revenue. A transfer between two business accounts is not revenue in one and an expense in the other. A loan draw is not income, and the principal portion of a loan payment is not an expense. Credit card payments from the bank account are transfers against a liability whose expenses were already recorded at the card level, so expensing the payment as well double-counts everything bought on the card.
Hunt these deliberately as their own pass. Filter for descriptions containing transfer, payment, loan, and owner-related terms, and pair movements between accounts: every transfer out of one account should have a matching transfer into another, in the same period, for the same amount. Unmatched transfers are a diagnostic gift; they point at missing accounts, missing months, or personal activity running through the business, each of which the cleanup needs to know about anyway. Getting this pass right transforms the profit figure more than any expense reclassification ever will.
After rules and transfers, what remains is the genuinely individual residue: one-off purchases, unfamiliar vendors, mixed receipts. Work this residue in passes by size first. Large transactions deserve individual attention regardless of category, because a handful of them usually drives most of the year totals and any error among them is material. Read each large item against any supporting document the client provided, and put the truly unknowable ones onto the client question list with the date, amount, and description copied exactly, so the client can answer from the statement line itself.
Then pass by theme: anything that might be equipment or an asset rather than a current expense, anything that might be personal, anything tax-sensitive your preparer will ask about, such as meals, vehicles, and home-related costs for a home-based business. The point of themed passes is that one question held in mind across many rows produces consistent judgments. Asking every question of every row produces fatigue, and fatigue produces the random categorization that cleanup clients are paying you to eliminate.
Consolidate everything you cannot determine into one list, grouped by theme, each item showing date, amount, and bank description verbatim. Clients answer bank text they recognize far faster than paraphrases. Keep the list as short as your passes have made it, and ask for answers in a form you can apply directly: a category choice, a business or personal marker, a note of what was bought. Offer the common answers as options where you can; a client choosing between vehicle repair and equipment is giving you a usable answer, while a client facing a blank line often gives you a guess or nothing.
While answers are pending, park those transactions in a clearly named suspense or ask account rather than forcing guesses into real categories to make the file look finished. A visible, shrinking suspense balance is honest work in progress. When the answers arrive, apply them, rerun the categorization checks, and aim to empty the suspense account entirely by the end of the engagement, or to hand over the handful that remain with a written explanation of why they could not be resolved.
Finish with reports designed to expose inconsistency: expenses by vendor across the year, expenses by category by month, and a scan for the same vendor appearing under multiple categories. Legitimate splits exist, a supplier that sells both materials and equipment, but each should be explainable in a sentence. Check also that no income category contains transfers or loan proceeds, that owner draws and contributions sit in equity where they belong, and that monthly patterns make sense; a category that appears in eleven months and vanishes in one usually marks a rule that missed a variant spelling of a vendor name.
Document the rules and decisions you built: the vendor mapping list, how transfers were identified, which categories the client confirmed, and any judgment calls a future bookkeeper should repeat rather than reinvent. That document is part of the deliverable. It turns a one-time cleanup into the operating standard for monthly work, so next year is categorized as it happens, consistently, by whoever holds the file.
In most small business accounts the recurring patterns, subscriptions, regular suppliers, payroll, rent, and transfers, make up the clear majority of lines. The exact share varies, but the method matters more than the figure: rules first, then focused passes, then a short client list.
Categorize by what was bought, not by vendor alone. Sample that vendor transactions, split them by evidence such as amount patterns or client confirmation, and note the split logic in your rules document so the same judgment is applied consistently next time.
Into a clearly named suspense or ask-my-accountant account, listed on a question sheet with dates, amounts, and exact bank descriptions. Never guess them into real categories to make reports look finished; move them when the answers arrive.
Cleanup & Catch-Up Bookkeeping · November 5, 2026
When to repair an existing bookkeeping file and when to start a new one, how to protect filed years either way, and what a fresh start still requires.
Cleanup & Catch-Up Bookkeeping · November 5, 2026
Scope a bookkeeping cleanup before you start: the period, the last filed year, every account, transaction volume, and a snapshot of the file as found.
Cleanup & Catch-Up Bookkeeping · November 2, 2026
Why a bookkeeping rebuild must run in chronological order: solid ground, balance continuity, and reconciling each month before the next one starts.
Convert a statement now and watch the reconciliation check verify it against the statement itself.
Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.