Blog · Throughput

Accelerating transaction creation, seven ways.

Bank rules, recurring templates, batch entry, file import, receipt capture, direct API sync, and an AI connector that proposes and waits. What each one actually speeds up, and where each one breaks.

The short answer

Pick by bottleneck, not by speed claim.

There are seven approaches worth knowing for accelerating transaction creation and financial data processing in QuickBooks Online: bank rules for repeating merchants, recurring templates for known schedules, batch entry and reclassification in QuickBooks Online Accountant and Advanced, file import for bulk history, receipt and bill capture such as Dext, Hubdoc or AutoEntry, direct API integration for systems that generate transactions continuously, and an AI connector over the ledger that drafts entries across many client files and waits for a person to approve them.

They are not interchangeable, because they accelerate three different bottlenecks. Capture is getting the data in. Decision is working out what it codes to. Entry is the keystrokes. Almost every product sold as a speed tool fixes exactly one of the three, and a firm that buys the wrong one gets a faster version of the step that was never slow. Diagnose first.

Diagnose first

Three bottlenecks that look identical from the outside.

Capture

The transaction is not in front of you yet. It is in a receipt in someone's glovebox, a statement nobody downloaded, a PDF bill in a shared inbox. Nothing downstream can start. Receipt capture and file import fix this and nothing else.

Decision

The data is in front of you and you do not yet know what it is. Which account, which class, is this vendor 1099-eligible, does this client capitalize at $1,000 or $2,500. This is the expensive bottleneck and the one most tools quietly leave with you.

Entry

You know exactly what to post and posting it takes eleven clicks. Batch entry, recurring templates and API writes attack this. It is real, it is the smallest of the three at most firms, and it is the one demos are built around.

The reason this matters commercially: a firm that is decision-bound and buys a capture tool will conclude that automation does not work for accounting. It worked. It just arrived at a step that was already fast.

Approach 01

Bank rules, the free thing nobody maintains.

Bank rules are the highest-return unpaid work in QuickBooks Online. A rule matching a descriptor to an account is deterministic, instant, and free, and a client with fifty recurring merchants can have most of a month coded before you open the file.

The failure mode is silent. A merchant changes its bank descriptor, a rule stops matching and nothing tells you, or worse a rule keeps matching a descriptor that now means something different. Rules written for a reason outlive the reason. Our own product asks a firm to re-review its whole rule set every five weeks, and that cadence exists because we watched rules quietly stop being true on our own clients.

Speeds up: decision and entry, for repeating merchants only. Ceiling: whatever share of a client’s volume is genuinely repetitive. Breaks when: descriptors change, or nobody owns the rule set.

Approach 02

Recurring transactions and templates.

Scheduled and reminded recurring transactions in QuickBooks handle rent, subscriptions, retainer invoices, and the standard monthly journal entries: depreciation, prepaid amortization, deferred revenue releases. If your firm posts the same entry every month and someone types it every month, that is unpaid work you chose.

Speeds up: entry. Ceiling: anything whose amount and coding are known in advance. Breaks when: the amount changes and the reminder is on autopilot, which is how a stale prepaid schedule survives three quarters.

Approach 03

Batch entry and batch reclassification.

QuickBooks Online Accountant and QuickBooks Online Advanced include tools for entering and reworking transactions in bulk, including Reclassify Transactions, which changes the account, class, and customer across a selected set at once. If you are cleaning up a year that was coded by someone with different opinions, this is the fastest supported path inside the product, and it is included rather than an extra subscription.

We use this. It works, and for a firm inheriting a year of somebody else’s coding it is the most useful thing in QuickBooks Online Accountant. The one structural point worth making is that reclassification is a cleanup pass, so by definition it runs after the books were coded wrong. It fixes the year. It does not stop next year needing the same pass, which is the argument for getting the coding right at the point of entry.

Speeds up: entry, at scale. Ceiling: the plan you are on. Breaks when: the fix requires judgment per transaction rather than one rule applied to a selection.

Approach 04

File import for bulk history.

Importing bank activity or transaction history from a file is how most catch-up work starts, and it is the approach most likely to create a mess that takes longer to clean than the import saved. The three questions to answer before any import: what happens if a row already exists in the books, what validation runs before anything posts, and how do you reverse the whole thing if it lands wrong.

Those three questions are why our own import behaves the way it does. It refuses rows that duplicate transactions already on the account in the same date range, it runs a validation pass that posts nothing so you can read the outcome first, and it returns a run identifier that reverses the entire import in one step. An import you cannot reverse is not a fast path, it is a bet.

Speeds up: capture and entry, in bulk. Ceiling: the quality of the file. Breaks when: duplicates land silently and you find them in a reconciliation three weeks later.

Approach 05

Receipt and bill capture.

Dext, Hubdoc and AutoEntry read source documents and push them into QuickBooks with the vendor, date, amount and tax already read off the page. For a client with genuine paper volume, this is the single biggest reduction in elapsed time, because it moves the capture step off your desk and onto the client’s phone.

Speeds up: capture. Ceiling: document volume. Breaks when: you expected it to fix decision. Character recognition reads a receipt accurately and has no view on whether that receipt is a capitalizable asset under this client’s threshold.

Approach 06

Direct API integration.

If a client generates transactions continuously, from a commerce platform, a payment processor, a point of sale or a billing system, the correct answer is a direct integration rather than any amount of human speed. Before you build or buy one, know the envelope you are working in. The QuickBooks Online API is OAuth 2.0 with a realm identifier per company, throttled per company, with a batch endpoint for grouping operations and refresh tokens that expire if a connection goes unused. Intuit publishes the current figures, and its own developer documentation is the only place worth taking them from.

Those limits are more permissive than most firms assume, which is the part worth internalizing. The ceiling on transaction throughput in a well-built integration is almost never the API. It is the number of postings a human is willing to accept without reading them.

Speeds up: capture, decision and entry, for one predictable source. Ceiling: engineering time. Breaks when: the source system changes shape, or a token expires quietly and nobody is monitoring the sync.

Approach 07

An AI connector over the ledger.

The newest category, and the reason this list needed rewriting in 2026. Instead of a person deciding and a tool typing, an AI client connected to the ledger drafts the work, shows what it intends to post with the net debits and credits, and waits. The accountant reads a batch instead of building it.

This is what Numbers Game is. A firm connects its QuickBooks Online companies once, adds the connector to its own Claude or ChatGPT account, and asks for work in plain language: clear the uncategorized queue for this client, build the depreciation entry, reconcile January, prepare the close. The work runs against the live ledger rather than an export, across every client file the firm has connected, from one conversation.

The important design decision is what it refuses to do. Nothing writes until a person approves it. There is no Numbers Game model and no AI provider sitting between a firm and its clients’ data, because the firm brings its own Claude or ChatGPT subscription and that account does the thinking. And there are hard rails underneath: per company, 50 writes and 20 deletes a minute, with a separate 500-row lane reserved for batch imports whose contents a human already reviewed. Those rails exist because the failure mode of a fast tool is not a wrong entry, it is four hundred wrong entries.

Speeds up: decision and entry, across many clients at once. Ceiling: review capacity, which is the honest answer. Breaks when: a firm treats it as an autopilot instead of a drafting layer.

Side by side

Seven approaches, three bottlenecks, one ceiling each.

ApproachBottleneck it removesCeilingFailure mode
Bank rulesDecision and entry, repeating merchantsShare of volume that repeatsDescriptor changes, nobody owns the rule set
Recurring templatesEntryAnything known in advanceAmount changes, reminder on autopilot
Batch entry and reclassifyEntry, at scalePlan tier and permitted transaction typesFix needs judgment per transaction
File importCapture and entry, in bulkQuality of the fileSilent duplicates, no reversal
Receipt captureCaptureDocument volumeBought to fix decision
Direct API integrationAll three, one sourceEngineering timeSource changes, token expires unwatched
AI connector over the ledgerDecision and entry, many clients at onceReview capacityTreated as autopilot
The real constraint

Once drafting is free, review becomes the whole job.

Here is the thing every throughput conversation eventually arrives at. If a tool can propose three hundred coded lines in a minute, the minute is not the constraint. The constraint is a person reading three hundred lines and being willing to put their name on them, and no amount of speed on the drafting side moves that.

So the design question stops being “how fast can we post” and becomes “how do we make a batch reviewable”. That is a different and much more interesting engineering problem, and it is where we spend most of our time. Four things make a batch readable rather than merely large.

  • Confidence has to come from outside the model. A language model asked to rate its own certainty will hand you a number that reads as calibrated and is not. Where we score a proposed coding, the score is computed from how well the transaction agrees with the firm’s own rules, how consistently that merchant has been coded before, the quality of the bank descriptor, and the aggregator’s own categorization signal. It is never a number the model reports about itself.
  • Some things are held no matter how confident anything is. An unmapped register, an accounting basis nobody has stated, foreign currency, a rule pointing at a different account, a failed ledger lookup, an unidentified card payoff, unbalanced splits, an entry already in the books, and payroll. Payroll is cleared, never coded: the provider posts the journal that splits the run into wages, employer taxes and deductions, and the bank line’s job is to clear it.
  • Reversal has to be one step. If undoing a batch means finding four hundred entries by hand, nobody will run a batch large enough to matter. An import here returns a run identifier that reverses the whole thing.
  • Approval has to leave a fingerprint. When a person approves something that was held, their approval and their stated reason are written onto the resulting entries, and approving lifts the confidence bar and nothing else. Every structural check still holds.
The hardest case

What we learned pointing this at real bank feeds.

Bank activity is where throughput stops being a philosophy and becomes a risk, because it is the one part of the work that could code hundreds of transactions while nobody is watching. It is available to firms on the platform today, and every new connection starts at propose-only, which posts nothing at all.

The controls are the feature. Every connection starts at propose only, which posts nothing at all, and a firm moves it from there deliberately. A client with several bank connections is governed by its strictest one, not its loosest. The confidence bar defaults to 0.90 and an owner or admin can move it between 0.75 and 1.00, and the floor is not arbitrary: 0.75 is the highest a transaction can score when the bank supplies nothing but a raw payment descriptor, so a bar below it would be posting on the amount alone.

The honest number from a week against real client banks: on a client whose rules were already in place, 157 lines posted unattended. On the same client’s unmapped merchants, 332 were held. That is the system behaving correctly in both directions, and it is the right way to read the feature. It is a confidence mechanism, not an autopilot.

None of this is free, and the honest way to describe it is to say so. A newly connected bank has no rule history and no merchant history, so an unseeded first run holds most of the batch. Expect roughly an hour per client, once, reading the recurring merchants out of imported history and saving how that client has already been coded as rules. Firms that skip that hour conclude the feed does not work, and they are not wrong about what they saw.

Questions firms ask

Faster transaction creation, answered.

What is the fastest way to create transactions in QuickBooks Online?
For repeating merchants, bank rules, because they are deterministic and free. For known monthly entries, recurring templates. For bulk cleanup, the batch tools in QuickBooks Online Accountant and Advanced. For continuous sources such as commerce or payments, a direct API integration. For everything else across many client files, an AI connector that drafts the entries and waits for approval.
How many transactions can a QuickBooks Online integration process?
More than most firms expect. Intuit throttles per company and publishes the current request and batch limits in its developer documentation. In practice the API is rarely the limit. The limit is how many postings a person is willing to approve without reading them, which is why the useful question is how reviewable a batch is, not how fast it can be sent.
Can AI create transactions in QuickBooks automatically?
It can draft them. Whether it posts them without a person is a product decision, and it is the decision worth interrogating before you buy anything. In Numbers Game nothing writes to a client's books until a named person approves it, and there are hard rails per company: 50 writes and 20 deletes a minute, with a separate 500-row lane for imports a human has already reviewed.
How do I bulk import transactions without creating duplicates?
Insist on three behaviours before you import anything: the import refuses rows that duplicate transactions already on the account in the same date range, a validation pass runs that posts nothing so you can read the outcome first, and the whole import can be reversed in one step from a run identifier. An import you cannot reverse is a bet, not a fast path.
Should I trust an AI confidence score on a categorization?
Only if you know where the number comes from. A model asked to grade its own certainty produces something that reads calibrated and is not. Ask the vendor whether confidence is computed outside the model, and from what. Ours comes from agreement with the firm's own rules, that merchant's coding history, the quality of the bank descriptor, and the aggregator's categorization signal.
Does faster transaction entry mean I can bill less time?
It means the mix changes. Categorization and reconciliation stop consuming the week, and the firm's product becomes the review and the narrative on top of it. Clients were never buying data entry. They were buying someone who could tell them what the number means and stand behind it.
Related reading

The rest of this series.

Accounting tools for managing multiple client accounts

The five-layer stack for a firm running many QuickBooks Online clients, and the ledger-access layer most firms never fill.

AI tools for bookkeeper workflows and client reporting

Four categories of AI accounting tool, eight questions that separate them, and a recommendation by situation.

The best QuickBooks Online integration is the one for your job

Seven integration categories, how QBO OAuth and rate limits work, and eight checks before you connect a client’s books.

Watch it draft against your own books.

Bring one client file to a 30-minute walkthrough. Nothing posts unless you approve it, and you keep whatever it produces.