Bank feed & categorising

How long does it take to categorise 500 bank transactions? We timed it

Updated 16 October 20268 min readLedgers Team

On this page
Quick answer

We timed a real review: 486 bank transactions in 2 hours 32 minutes, about 19 seconds each. How that compares with Xero, QuickBooks and a bookkeeper.

How long does it take to categorise a few hundred bank transactions? Most answers you'll find online are estimates. We had the chance to measure one.

In October 2026, a small UK limited company on Ledgers had about ten weeks of bank transactions waiting for review. They were cleared over two evenings: 486 transactions in 2 hours 32 minutes, from the first approval to the last. That's about 19 seconds a transaction.

Published estimates for coding transactions by hand in Xero or QuickBooks run from about 30 seconds to 3 minutes each. For the same 486 transactions, that's roughly 4 to 24 hours. This article shows where the 2 hours 32 minutes went, and what the comparison figures are based on.

Note:Our figures come from Ledgers' activity log for one business's review. They're a real measurement, not a controlled study. The Xero and QuickBooks figures are published estimates. Where a source sells bookkeeping software itself, we say so. Everything here is as at 15 October 2026.

What we measured

MeasureResult
Transactions reviewed486
Bank dates covered31 July to 13 October 2026 (about ten weeks)
Evening 1184 transactions in 58 minutes
Evening 2302 transactions in 93 minutes, including 34 minutes of breaks
Total, first approval to last2 hours 32 minutes
Average per transactionabout 19 seconds

Each of the 486 was approved by a person, one at a time. Nothing was bulk-approved. The second evening also included entering two supplier bills, setting up two fixed assets and a few breaks. We've left all of it in the total.

Spread over the ten weeks the transactions covered, that's about 15 minutes a week.

Where the time went

Each transaction arrived in the review queue with a suggested category, or, in 14 cases, a note saying the AI wasn't sure. Some suggestions came from rules, which Ledgers learns as you approve things. The rest came from the AI, which suggests a category for anything no rule covers, including suppliers it hasn't seen before.

What happenedTransactionsTypical time each
Rule suggestion accepted325 (67%)3 seconds
AI suggestion accepted69 (14%)5 seconds
Suggestion changed92 (19%)16 seconds

"Typical" here is the median: the time from one approval to the next, which includes reading the next transaction. Three in four changes took under 30 seconds.

A few other details from the log:

  • Of the 325 rule matches, 296 came from rules built up in Ledgers since June. The other 29 came from rules carried over from the company's old Xero history.
  • The 14 where the AI wasn't sure are among the 92 changes. Rather than guess, it asked for a category.
  • 390 of the 486 came with a VAT treatment already suggested, alongside the category.

The pattern is the point. Accepting a good suggestion takes seconds. The time goes on the transactions that need thought, and there the job is to choose an answer, not to type one.

How long would this take in Xero or QuickBooks?

No one has published a measured, independent figure for time per transaction in Xero or QuickBooks. What exists are estimates from bookkeepers and from software companies. Here are the ones we could trace to a named source:

EstimateSourceFor 486 transactions
30 seconds for a simple transaction, a minute or more for an unclear one, 45 seconds on averageJack Whitehead AATQB, ReconcileIQ, October 2026about 4 to 6 hours
2 to 3 minutes each when done carefully, including the VAT and a noteSame author, QuickBooks Online guide, July 2026about 16 to 24 hours
2.5 to 3.5 hours a month for 180 to 220 transactions in QuickBooks Online (about 40 to 70 seconds each)Bobby Huang, SDO CPA and Growthy, May 2026about 5½ to 9½ hours

Two of these sources, ReconcileIQ and Growthy, sell AI bookkeeping software, so they have a reason to stress how slow manual work is. ReconcileIQ's own figures also differ widely between its two articles: 45 seconds on average in one, 2 to 3 minutes in the other. Read them as a range, not a verdict.

Transactions that a bank rule already matches are much quicker everywhere. Xero is testing an automatic bank reconciliation feature, still in beta, and its blog quotes a user who did "300 transactions in about five minutes" with it. That fits our own numbers: a rule match took us about 3 seconds too.

So the honest comparison is this:

  • Against an experienced bookkeeper with mature bank rules, 19 seconds is still quicker than the fastest published estimate of 30 seconds for a simple transaction, and our figure covers every transaction, simple or not.
  • Against careful manual coding, or a first year with no rules, the gap is large: hours rather than minutes.
  • The difference is the transactions no rule covers. In Xero or QuickBooks, a supplier with no rule or history often means working out the category and VAT yourself, though both now offer AI suggestions too. Here, 69 transactions that no rule covered arrived with a suggestion that was accepted, in about 5 seconds each.

What about Xero's and Intuit's own claims?

Both companies publish headline savings. Xero's UK site says "Win back 22+ hours a month" and quotes "97% reconciliation accuracy", without saying how either was measured. Intuit's UK press release for QuickBooks says businesses "can save up to 12 hours a month". Its footnote explains that 45% of customers saved 12 hours, in a survey Intuit commissioned of US QuickBooks Online customers. Neither figure tells you how long a given number of transactions takes, so we haven't used them in the comparison.

What it would cost in a bookkeeper's time

The best recent UK source on rates we found is a survey of 131 UK bookkeepers in summer 2025, published by The 6 Figure Bookkeeper with GoProposal by Sage. It found a median hourly rate of £33.36. At that rate:

TimeCost at £33.36 an hour
2 hours 32 minutes (our review)about £84
4 hours (30 seconds each)about £135
6 hours (45 seconds each)about £203
16 to 24 hours (2 to 3 minutes each)about £540 to £811

The survey doesn't say whether its rates include VAT, and many bookkeepers charge a monthly fee instead. The median monthly fee was £150.50 for routine bookkeeping.

You stay in control

Speed doesn't come from handing the books over. Every one of the 486 transactions was approved by a person, and 92 of them were given a different category, typically in about 16 seconds each. The AI does the typing and the first answer; you make the decision. Every approval is recorded in Ledgers' activity log, which is where the figures in this article come from.

What makes the difference

Looking at the log, three things saved most of the time:

  1. Most transactions arrived with an answer. 81% were accepted as suggested, in seconds.
  2. The suggestions improve as you approve. Each approval feeds the rules, so the next batch has more rule matches and fewer questions. 296 of the matches here came from rules built up in Ledgers over the previous four months.
  3. The AI says when it isn't sure. Fourteen times it asked rather than guessed, so it was clear exactly where to slow down.

If you want to see how this works on your own books, our guide to categorising bank transactions automatically explains the rules and the review queue. How Ledgers compares with Xero covers prices and features side by side.

On the Free plan you can connect one bank account and see how many of your own transactions arrive already categorised, up to 15 a month. Start free.

Our figures come from Ledgers' activity log for one business's review on 13 and 14 October 2026. Sources for the comparison, as at 15 October 2026: ReconcileIQ, auto-categorising bank transactions and categorising transactions in QuickBooks Online; Growthy, the cost of manual bookkeeping; Xero, auto bank reconciliation updates and AI in accounting; Intuit, UK press release of 20 November 2025; The 6 Figure Bookkeeper, UK bookkeeping pricing report.

Frequently asked questions

How long does it take to categorise a bank transaction?

Published estimates for coding a transaction by hand in Xero or QuickBooks range from about 30 seconds for a simple one to 2 or 3 minutes when it's done carefully, including the VAT. In our own timed review in Ledgers, 486 transactions took 2 hours 32 minutes, about 19 seconds each.

How long would 500 transactions take in Xero or QuickBooks?

Nobody has published a measured figure. On the estimates bookkeepers and software companies publish, 500 transactions coded by hand would take somewhere between about 4 and 25 hours. Transactions that an existing bank rule already matches take a few seconds each in any system.

How much does a bookkeeper charge per hour in the UK?

A summer 2025 survey of 131 UK bookkeepers, published by The 6 Figure Bookkeeper with GoProposal by Sage, found a median hourly rate of £33.36 and a median monthly fee of £150.50 for routine bookkeeping.

Do I still approve transactions the AI has categorised?

Yes. Ledgers suggests a category and you approve it. In our review, 81% of suggestions were accepted as they were and 19% were changed, so the time went on the transactions that needed a decision.

Is this a fair comparison with Xero and QuickBooks?

Only roughly. Our figure is one measured review of one business's books. The Xero and QuickBooks figures are estimates, not measurements, and some come from companies that sell bookkeeping software. We've shown every source so you can judge for yourself.

See your numbers without learning accounting

Ledgers does the bookkeeping — bank feeds, VAT, year-end — and keeps your accountant in the loop. Free for pre-revenue founders.

Start free →

Get the next guide by email

Plain-English accounting for founders — a couple of new guides a week. No spam, unsubscribe anytime.

Keep reading · Bank feed & categorising