Feature · Bulk labelling
Categorize bank transactions in bulk, deliberately
Select the rows that belong together, label them in one action, and export. Nothing is categorised automatically: no rules, no guesses, no memory between statements, because a wrong category is much harder to find than a missing one.
- Label many rows in one action
- Filter by description, amount or reconciled status
- Unlabelled rows stay visibly uncategorised
- No automatic guessing, by design
The short answer
How to categorize bank transactions here
You categorize bank transactions in VouchRow by selecting rows in the review grid and applying a label to all of them at once. Filter first by description, amount or reconciled status, select what is left, and set the category. The label is shown against each row in the grid; exported files do not include labels yet, so final categories are assigned in your accounting software.
If you were looking for a tool to categorize bank transactions automatically, this is deliberately not one. There are no rules, no model assigning categories, and nothing remembered from one statement to the next. Automatic categorisation works best inside your accounting software, next to your chart of accounts and the bank rules you have already built. What follows covers how bulk labelling works, when it is the right tool, and how to finish the job in QuickBooks, Xero or Excel.
Step by step
How to label a statement’s transactions in bulk
- 1Convert and reconcile firstLabel after the amounts are settled. Deal with any running-balance breaks so the rows you label are the rows that will be imported.
- 2Filter to one groupNarrow the grid to rows that belong together: a description containing the merchant’s name, amounts above a threshold, or only rows that reconciled.
- 3Select them and check the totalThe selection bar shows how many rows you have picked and what they sum to. Twelve rent payments should add up to twelve months of rent; if they do not, a row is missing or extra.
- 4Set the categoryType the label once and it is applied to every selected row. If the export will take it into your books, use the account’s exact name as it appears in your chart of accounts.
- 5Repeat, then leave the rest aloneWork through the groups you are sure of. Rows you are not sure of stay unlabelled, which keeps them visible in your software’s review screen instead of hidden in an account.
- 6Export and finish in your softwareImport the file and let your accounting software’s review screen and bank rules handle what is left.
What you can do
Select any set of rows in the review grid and apply a category to all of them at once. Sort or filter first — by description, by amount, by whether the row reconciled — and the selection follows, so labelling every row from one merchant is two clicks rather than forty.
The label is shown against the row in the grid while you review. Exported files do not carry labels yet; final categories are assigned in your accounting software.
Why automatic categorisation is not here
Because a wrong category is silent, and a missing one is not. A transaction posted to the wrong account looks completely normal in your books, is found weeks later during a review if it is found at all, and has to be traced back through a chart of accounts to fix. A transaction sitting in Uncategorised is visible in one report and reassigned in a single pass.
The same reasoning shows up in the exports themselves. An IIF file writes uncategorised rows to QuickBooks’ own holding accounts, and a Tally voucher posts to Suspense, precisely so nothing lands somewhere plausible and wrong.
This is a defensible position rather than a universal one. If your statements are repetitive and your tolerance for occasional misposting is high, a tool that guesses will save you time — and the closest competitors list auto-categorisation as coming soon rather than shipped, so the honest state of the art here is thinner than the marketing suggests.
Where categorisation belongs anyway
QuickBooks, Xero and Sage all have rule engines that categorise on import, learn from what you accept, and keep those rules in the place your chart of accounts already lives. That is a better home for the logic than a converter, which sees one statement and knows nothing about your accounts.
The useful thing a converter can do is get clean, verified rows into that engine. That is what this one tries to do.
No rules, no learning, no memory between statements
Why it works
What bulk labelling is good for
Bulk, not row by row
Every payment to one supplier across a statement takes a filter, a select-all and one label, not forty separate edits.
Filter, then label
Description, amount and reconciled status narrow the grid to exactly the rows you mean, so the label lands where you intend.
Gaps stay visible
An unlabelled row is plainly unlabelled. In IIF it goes to Uncategorized Income or Expense; in Tally XML to Suspense A/c.
Nothing posted on a guess
Every label on every row was put there by a person who chose it, which is what a reviewer wants to know.
Labels for the job in hand
Not only ledger accounts: transfers between a client’s own accounts, payroll deposits for a lender, cash withdrawals for a disclosure schedule.
Totals as you go
The running count and sum of the selection give a quick check that a group is complete before you label it.
Mechanics
What a label is, and what happens to it
A label is free text attached to a row. It is shown in the grid against every row it was applied to; it is not written into exported files yet. It does not change the amount, the date, the description or the reconciliation result, and it applies to this statement only. The next statement starts unlabelled.
What happens to unlabelled rows depends on the format. Formats that import as a statement waiting to be categorised, such as QBO, CSV and OFX, simply arrive uncategorised and appear in your software’s review list. Formats that import as finished double-entry transactions need a second side, so IIF posts it to QuickBooks Desktop’s Uncategorized Income or Uncategorized Expense and Tally XML posts it to Suspense A/c. In both cases the unassigned rows sit together in one place, ready to be reassigned.
The trade-off
A wrong category against a missing one
A converter sees one statement. It does not know your chart of accounts, whether an Amazon order was stock, office supplies or a personal purchase, whether a transfer went to an account the business owns, or how your jurisdiction treats sales tax on a given supplier. Any automatic category it assigns is a guess about facts it does not have. The table shows what that guess costs when it is wrong, compared with leaving the row for you.
| Guessed category, wrong | No category, left for you | |
|---|---|---|
| Where the row lands | A real expense or income account that looks plausible | Uncategorised, a holding account, or the review list |
| How it is found | In a later review, if anyone looks closely | Immediately: one report or one list |
| Effect meanwhile | Misstates profit and any tax figure built on it | Shows as an obvious open item |
| Cost to fix | Trace it, reclassify it, check what was reported from it | Assign it, often in bulk |
Beyond bookkeeping
Labels that are useful outside the ledger
Because a label is free text, it does not have to be an account name. Several kinds of work use it to group rows for a purpose that has nothing to do with a chart of accounts.
- Lenders and brokers: mark the deposits that are payroll, the transfers in from the applicant’s own savings, and fees for overdrafts or returned items.
- Family-law teams: mark transfers to particular accounts, cash withdrawals and payments to a named counterparty for a disclosure schedule.
- Forensic accountants: group every payment to and from one counterparty across a statement before building the analysis.
- Small business owners: separate personal spending on a mixed account before handing the year to an accountant.
- Bookkeepers: pre-label the rows you are certain of, such as owner drawings, loan repayments and transfers between the client’s accounts, so the import arrives partly done.
After import
Categorising in QuickBooks, Xero and other software
This is where automatic categorisation belongs. QuickBooks Online lists imported transactions for review and lets you build bank rules that categorise by description and amount. Xero has bank rules too, and cash coding for reconciling many lines at once. Zoho Books, Wave and FreshBooks have their own rule and categorisation screens. Rules there learn from your choices and apply to every future import, whether the transactions came from a bank feed or a converted statement.
A converted statement helps those rules work. Wrapped description lines are joined into one description per transaction, so a rule matching on "contains" sees the merchant name rather than half of it. Transactions that reconcile against the statement mean the rules are categorising the right amounts.
In a spreadsheet
How to categorize bank transactions in Excel
If the statement is going into a spreadsheet rather than accounting software, keyword matching in Excel does most of the work. Export the statement to Excel, then build a small two-column table elsewhere in the workbook: a keyword (part of a description, such as "UBER" or "PAYROLL") and the category it should map to. Name the ranges Keywords and Categories.
In a new column beside the transactions, enter =IFERROR(LOOKUP(2^15,SEARCH(Keywords,B2),Categories),"Uncategorised"), where B2 is the description, and fill it down. SEARCH looks for every keyword in the description and LOOKUP returns the category of the last one that matched, so put general keywords near the top of the table and specific ones below them. Anything without a match reads "Uncategorised", which keeps the same principle as everything above: an empty category is better than a wrong one. A pivot table on that column then gives totals by category.
Side by side
Bulk labelling vs automatic guessing vs bank rules
Three ways to get categories onto transactions, and what each one is good at.
| Bulk labelling here | Automatic guessing in a converter | Bank rules in your accounting software | |
|---|---|---|---|
| Who decides | You, per group of rows | A model or keyword list | Rules you wrote or approved |
| Knows your chart of accounts | Yes, you type the names | No | Yes |
| Remembered next month | No | Varies | Yes |
| When it is unsure | The row stays unlabelled | It still assigns something | The row waits for review |
| Best for | Pre-labelling what you are sure of; non-ledger labels | High-volume, low-stakes, repetitive statements | Ongoing categorisation of every import |
Who uses it
When bulk labelling is the right tool
Catch-up bookkeeping
Label the obvious groups, such as rent, payroll and transfers between accounts, across a year of statements before import, and leave the rest for the software’s rules.
A one-off year for a tax return
A sole trader’s mixed account, labelled into business and personal groups so the accountant starts from a sorted list.
Income review for a loan
Deposits labelled by source, so recurring income and one-off transfers are separated before any figures are worked out.
Disclosure and tracing schedules
Transfers, cash withdrawals and payments to named parties grouped and labelled, with every row still linked to its source line.
FAQ
Categorising transactions, and why we will not guess for you: questions
Can VouchRow categorize bank transactions automatically?
No, by design. You can label any set of rows in one action, but nothing is categorised by a model or by rules, and nothing carries over between statements. A wrong automatic category is hard to find; an uncategorised row is not.
What is the fastest way to categorize bank transactions?
Group them. Filter to one merchant or one kind of payment, select every row, and label them together. Then let your accounting software’s bank rules handle repeat transactions on future imports.
How do I categorize bank transactions in Excel?
Export to Excel, build a table of keywords and categories, and use =IFERROR(LOOKUP(2^15,SEARCH(Keywords,B2),Categories),"Uncategorised") beside each description. A pivot table on the result gives totals by category.
How do I categorize bank transactions in QuickBooks Online?
Import the statement as QBO or CSV, then work through the imported transactions in QuickBooks’ review list, choosing a category for each or matching them to existing entries. Bank rules can categorise repeat transactions on future imports.
How do I categorize bank transactions in Xero?
Import the statement using the Xero CSV preset or OFX, then reconcile the lines in Xero, using bank rules for repeat transactions and cash coding to deal with many lines at once.
What happens to rows I do not label?
They are exported uncategorised. In IIF they post to Uncategorized Income or Uncategorized Expense, and in Tally XML to Suspense A/c, so they are easy to find and reassign.
Are my labels saved for the next statement?
No. Labels apply to the statement you are reviewing. There are no saved rules and no memory between statements; rules that remember belong in your accounting software.
Can I use my own chart of accounts names?
Yes. A label is free text, so type the account name exactly as it appears in your books if the export will carry it there.
Keep going
Related guides and converters
Related features
Finish categorising in your software
Who labels rows before export
Related
Other features
Convert, label what you are sure of, and export
Create an account, convert a statement and label rows in bulk before you export. Plans start at $15 a month for 300 pages, and only pages with transactions count.