Schema CPA

The Cost of Manual Data Entry in an Accounting Firm

By Schema CPAPublished Updated

The cost of manual data entry in an accounting firm is clients per season, times documents per client, times minutes to key one document, divided by 60, times loaded staff cost per hour. Add the time spent fixing keying errors. Every input comes from your own firm, so the result is your manual entry cost, not a benchmark.

The manual data entry cost formula

The manual data entry cost formula multiplies four inputs: clients per season, documents per client, minutes to key one document, and loaded staff cost per hour. The first three give hours of keying; the fourth turns hours into dollars. Rework and opportunity cost come on top, and the sections below cover each.

Written out:

seasonal entry cost = clients x documents per client x minutes per document / 60 x loaded cost per hour

Each input has a definition worth keeping fixed from year to year.

  • Clients per season: engagements where staff key figures from client documents. Leave out clients whose data arrives in a form the firm imports without typing.
  • Documents per client: individual documents, not files. A 40-page PDF holding a W-2, three 1099s and twelve bank statements is sixteen documents.
  • Minutes per document: active keying and checking time for one document, measured, not guessed. The next section covers how.
  • Loaded staff cost per hour: wages plus the employer's benefit and payroll costs for the people who do the keying.

A worked example for a 200-client firm

This is fictional example arithmetic for a fictional firm. The four inputs are the same ones the homepage calculator asks for.

InputExample valueWhere it comes from
Clients per season200Example firm's client list
Documents per client25Example firm's average, counted from last season
Minutes to key one document4Example firm's timed sample
Loaded staff cost per hour$34.80Example built from BLS figures, below

The loaded cost in the example starts from the BLS Occupational Outlook Handbook page for bookkeeping, accounting and auditing clerks, which gives a 2025 median pay of $24.36 per hour (May 2025 wage data). The BLS Employer Costs for Employee Compensation release for June 2026 reports that wages and salaries made up 70.0 percent of employer compensation costs for private industry workers. Dividing $24.36 by 0.70 gives $34.80 per hour as an example loaded rate. Your firm's own payroll records are a better source than either national figure.

The arithmetic:

  • Documents: 200 x 25 = 5,000 documents
  • Hours: 5,000 x 4 / 60 = 333 hours, to the nearest hour
  • Cost: 333.3 x $34.80 = about $11,600 for the season

That $11,600 is this fictional firm's current cost of keying, before any rework. The homepage hours calculator runs the same four inputs for your firm and shows today's cost of manual entry; it does not estimate a saving.

How many minutes does keying one tax document take?

Keying one tax document takes as long as your own timed sample says, and the range is wide. A clean W-2 with a few boxes filled is quick. A consolidated brokerage 1099 with dozens of sale lines, or a bank statement whose transactions must be entered one by one, can take many times longer. Time each type separately.

Time a sample of each document type rather than using one average. Ask staff to log active minutes per document for a week, with the type noted: W-2, 1099-INT, 1099-B, K-1, bank statement, credit card statement, pay stub. Ten of each is enough to see the spread.

The figures to expect will vary by firm, but the drivers are consistent:

  • Fields filled, not fields printed. A W-2 has many boxes; most clients use a handful. Time depends on how many carry figures.
  • Line items. Forms are a fixed set of boxes. Statements are a variable list of transactions. A checking statement with 140 transactions is a different job from one with 12. Converting statements to spreadsheets without retyping is the subject of the bank statements to Excel category.
  • Legibility. A phone photo taken at an angle costs more time than a PDF downloaded from the issuer.
  • Finding the document. If staff have to search a folder or email thread first, that search is part of the cost, even though it is not typing.

Use a weighted figure in the formula. If 60 percent of a firm's documents are simple forms at 2 minutes and 40 percent are statements at 7 minutes, the weighted figure is 0.6 x 2 + 0.4 x 7 = 4 minutes, which is the example firm's figure above.

The rework cost of data entry errors

The rework cost of data entry errors is the time spent finding, tracing and fixing figures keyed wrongly, plus anything done twice because of them. A transposed figure caught in review costs the reviewer's time to spot it and the preparer's time to correct it. One caught after the client signs costs more.

Take a fictional example. A preparer keys wages of $48,210 from a W-2 as $48,120. The return is off by $90. In review, the reviewer ties wages back to the W-2, spots the difference, sends the return back, and the preparer corrects it and re-checks anything that depended on that figure. If that takes 15 minutes of reviewer time and 10 of preparer time, one transposition costs 25 minutes.

Duplicates cause a different kind of error. A client who forwards the same 1099-INT twice can have interest entered twice. The error is not a typo, so a typo check will not catch it; it shows up only when someone notices income is higher than expected.

To price rework, count it. For two weeks, ask reviewers to log each keying error they find and the minutes spent sending it back and fixing it. Divide by the number of documents keyed in those weeks to get rework minutes per document, then add that to minutes per document in the formula.

In the example firm, if rework averages 0.5 minutes per document, the season adds 5,000 x 0.5 / 60 = about 42 hours, or roughly $1,450 at the example loaded rate.

Errors that reach the client

The most expensive errors are the ones review misses. A figure that is wrong on a signed return may mean an amended return, a client conversation and, depending on what the error was, correspondence later in the year. The time those take is real, but it is irregular, and a firm with one such case in a season cannot average it into a per-document rate with any confidence. Track these cases separately: note each one, the document it came from, and the hours spent putting it right. Over two or three seasons the list shows whether certain document types, such as long brokerage statements or phone photos of receipts, produce most of the late errors.

Reducing rework without changing tools

Some rework falls with process changes alone. Keying from the original PDF rather than a printed copy cuts transcription slips. Checking totals against the document's own totals, such as a statement's ending balance or a 1099-B's summary line, catches many errors before review sees them. Flagging duplicates at intake, before anyone keys a figure, stops the double-entry case entirely. Each of these costs a few seconds per document and can be measured with the same two-week log.

What is the opportunity cost of manual data entry?

The opportunity cost of manual data entry is the value of the work that staff could have done in the hours spent keying. In tax season those hours are scarce, so the cost is often a return extended, a review rushed or a new client turned away, rather than the wage paid for the keying.

The wage cost in the formula is the visible part. The less visible part shows up in capacity. In the example firm, 333 hours of keying is about nine 38-hour weeks of one person's time during the busiest months. If those hours were available for preparation and review, the firm could finish more returns before the deadline or carry fewer extensions into the summer.

Opportunity cost is hard to price exactly, and inventing a dollar figure for it defeats the point of the formula. A better approach is to name what the hours would go to: earlier starts on business returns, a second review on complex returns, time to answer client questions before April. Then decide whether that work is worth more to the firm than the keying.

Firms looking at what reduces keying, from issuer downloads to document reading, can start with how to reduce data entry in accounting. Evaluating tools is a separate step, covered in what to look for in accounting firm automation software. After any change, measure the result against a baseline; the post on setting a baseline of staff hours per tax return covers what to record before changing anything.

When manual data entry is the cheaper choice

Manual data entry is the cheaper choice when the formula's result is small: few clients, few documents per client, or documents so simple that keying them takes less time than setting up and checking any alternative. It also wins for one-off documents a tool cannot read reliably, where checking automated output would take longer than typing.

Run the formula for the clients in question, not the whole firm. A firm might find that its 40 business clients with monthly statements account for most of its keying hours, while 160 individual clients with two or three forms each account for little. Changing the process for the first group and leaving the second alone can be the right answer.

Other cases where keying by hand is reasonable:

  • Very small volume. A sole practitioner with a few dozen simple returns may spend less time keying than learning a new process.
  • Unusual documents. Handwritten records, foreign-language statements or one-of-a-kind schedules may need a person anyway.
  • Data already in a structured file. If a client sends a spreadsheet export, importing it is neither manual entry nor automation, and the formula should leave it out.

Whatever the choice, check the cost against the alternative's full cost, including the time to review any automated output. A tool that extracts figures still needs someone to confirm them. Schema CPA, for example, reads tax forms, bank statements and payroll reports and exports the figures to Excel or CSV. With that tool or any other, budget time for someone at the firm to confirm the figures before relying on them.

All posts in Tax season workflow