Manual data entry in finance: what the research actually says
Everything citable about what manual finance work costs — hours, euros, errors, close days and people. Each figure below carries its publisher, its year and a link to the document it came from, so you can check it rather than take our word for it.
Last updated:
Sources cited: 18
The headline numbers
The eight figures worth carrying into a meeting. Each links to the section that gives it context, and to the document it came from.
On this page
- 1.How much time do finance teams spend on manual data entry?
- 2.What does it cost to process an invoice, manually and automated?
- 3.How often does manual entry go wrong, and what do the errors cost?
- 4.How long does the month-end close take, and why is it not getting shorter?
- 5.How much of finance still runs on spreadsheets, and how wrong are they?
- 6.What is manual work doing to finance teams and the talent pipeline?
How much time do finance teams spend on manual data entry?
This is the hardest number in the whole field to source well. Plenty of vendors quote a tidy hours-per-week figure with no study behind it. Here is what can actually be traced to a published survey — and where the honest gaps are.
25 hours
Time businesses spend each week on manual data entry or reconciling data between applications.
Respondents were business owners and executives at growing mid-market businesses, so this is whole-business data-wrangling time, not one accountant's timesheet.
Intuit QuickBooks, Business Solutions Survey, 2024Vendor-commissioned
54%
Name manual and repetitive tasks as a problem with the business systems they already run.
95% reported at least one challenge with their current systems; manual and repetitive work was the most common single answer.
Intuit QuickBooks, Business Solutions Survey, 2024Vendor-commissioned
87%
Say manual data wrangling has damaged the timeliness of their financial reporting. 91% say it has cost them productivity, 88% morale, 85% profitability.
Intuit QuickBooks, Business Solutions Survey, 2024Vendor-commissioned
64%
Finance leaders who say the sheer volume of day-to-day manual work leaves little or no time for proper planning and analysis.
Vendor-commissioned, but a large sample across the US, Canada, UK, France, Germany, Australia and Singapore, and reported in full by the Journal of Accountancy.
BlackLine, Survey of 1,300+ C-suite and senior finance and accounting professionals across seven markets, 2024Vendor-commissioned
21.9%
Share of accounts payable staff time spent handling supplier enquiries — chasing and answering rather than processing. Ardent records the trend on this as flat.
Ardent attributes much of this to invoice exceptions: suppliers ring because something did not go through.
Ardent Partners, The State of ePayables 2025: AP's Unfinished Journey, 2025Analyst benchmarking
12,000
Invoices processed per accounts payable full-time equivalent per year — the cross-industry median.
Sample of 3,665 organisations. APQC updates this database nightly, so treat the figure as current rather than tied to a report year.
APQC, Open Standards Benchmarking, measure 101290 (invoices processed per AP FTE), 2026Independent research
What we take from this
Notice what is missing. There is no well-sourced, finance-specific figure for hours per week per accountant on rekeying, and we are not going to invent one. The numbers that circulate — eight hours a week, ten hours a week — trace back to vendor landing pages and LinkedIn posts citing surveys nobody can produce.
The defensible way to size your own problem is APQC's productivity median. If your AP function processes materially fewer than 12,000 invoices per person per year, the gap is time going somewhere, and rekeying is the usual place. That comparison uses your own numbers rather than a borrowed average, which is why our calculator is built around it.
What does it cost to process an invoice, manually and automated?
This is the best-measured part of the whole subject. Ardent Partners has benchmarked accounts payable annually for two decades and defines Best-in-Class as the 20% of enterprises with the lowest processing costs and shortest cycle times.
$9.84
Average all-inclusive cost to process a single invoice. Ardent records the trend as declining.
All-inclusive means labour, systems and the overhead attached to both — not just software.
Ardent Partners, The State of ePayables 2025 (Table 1: The 2025 AP Benchmarks), 2025Analyst benchmarking
$2.65 vs $12.42
Cost per invoice for Best-in-Class organisations against everybody else. The gap is 4.7 times.
Ardent Partners, The State of ePayables 2025 (Table 2: The 2025 AP Maturity Framework), 2025Analyst benchmarking
8.2 days
Average time to process one invoice, from receipt to approval and payment.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
2.9 vs 13.5 days
Invoice cycle time, Best-in-Class against all others. The leaders are 4.7 times faster.
Early-payment discounts are unreachable at 13.5 days. That is a cash cost on top of the processing cost.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
35.4%
Invoices processed straight through, with no human intervention at all. Improving year on year.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
51.0% vs 29.0%
Straight-through processing rate, Best-in-Class against all others.
Ardent's separate AP Metrics That Matter 2025 puts the same comparison at 49.2% against 23.4% — a 2.1 times advantage. The two publications sample slightly differently; both are Ardent, both are 2025.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
57.4%
Suppliers who submit invoices electronically. So roughly two in five still send something a person has to key.
Best-in-Class reach 67.2%, everyone else 47.3%.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
65.4%
Invoices linked to a purchase order — the precondition for matching an invoice automatically.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
$2.25 vs $10.95
The same Best-in-Class comparison three years earlier, for anyone tracking the trend.
Both ends of the range have drifted up with wages. The multiple between them has barely moved.
Ardent Partners, Accounts Payable Metrics that Matter in 2022, 2022Analyst benchmarking
Cost to process one supplier invoice
Ardent Partners, The State of ePayables 2025. Best-in-Class is the 20% of enterprises with the lowest processing costs and shortest cycle times.
- Best-in-Class
- $2.65
- Average
- $9.84
- All others
- $12.42
What we take from this
The single most useful thing in this section is that the gap is not a technology gap. Best-in-Class organisations run the same ERPs as everyone else. What separates them is the share of invoices that never reach a human: 51% against 29%. Cost per invoice is downstream of that one number.
The benchmarks are published in US dollars and we quote them unconverted, because invoice processing cost is overwhelmingly labour and a currency conversion would imply a precision the benchmark does not have. Use them as a shape, not a price list, and put your own numbers through the calculator.
How often does manual entry go wrong, and what do the errors cost?
Two different questions get muddled here: how often a person mistypes a field, and how often an invoice ends up needing human rework. The second is far better measured than the first, and matters more.
18.4%
Average invoice exception rate — invoices that stop and need a person to resolve them. Ardent calls exceptions the single biggest reason the other AP benchmarks are not better.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
11.1% vs 20.9%
Exception rate, Best-in-Class against all others.
Ardent's AP Metrics That Matter 2025 reports the same split as 9.0% against 22.0%, a 59% lower exception rate for the leaders.
Ardent Partners, The State of ePayables 2025, 2025Analyst benchmarking
68%
Finance leaders who say reliance on manual processes leaves their organisation exposed to errors that could undermine business decisions.
BlackLine, Survey of 1,300+ finance and accounting leaders, seven markets, 2024Vendor-commissioned
37%
CFOs who do not completely trust the accuracy of their own organisation's financial data. Among senior finance and accounting staff below CFO level it is about 50%.
Asked why: 31% said data comes from too many different sources, 27% blamed clunky spreadsheets, 25% named outdated processes including manual data collection.
BlackLine, Survey of 1,300+ finance and accounting leaders, seven markets, 2024Vendor-commissioned
0.34%
Measured per-field error rate for single-entry keying in a controlled study — 358 errors across 104,720 fields.
Not a finance study. It is included because it is one of the few places anyone has actually counted, and it puts a floor under the question.
Barchard & Pace, Preventing human error: the impact of data entry methods on data accuracy and statistical results, 2011Academic research
$145,000
Median loss per occupational fraud case. Billing schemes — phantom suppliers and inflated invoices — are the second most common scheme type.
1,921 cases across 138 countries. The ACFE estimates a typical organisation loses about 5% of revenue to fraud each year, and the median scheme runs 12 months before it is caught.
Association of Certified Fraud Examiners, Occupational Fraud 2024: A Report to the Nations, 2024Independent research
What we take from this
Be sceptical of the keying-error statistics in circulation. The often-quoted "1% of manually entered data is wrong" and Gartner's "$12.9 million a year in poor data quality" are repeated everywhere and sourced almost nowhere — we could not put either in front of a primary document, so neither is stated as fact above.
The exception rate is the number to manage. An 18.4% exception rate on 50,000 invoices is 9,200 invoices a year that stop and wait for a person. That is where the cost, the cycle time and the supplier phone calls all come from, and it is measurable inside your own ledger this week.
The fraud figures matter for a reason people miss: a billing scheme works precisely because a human keys the invoice and a human approves it. Controls that check every invoice against a purchase order and a receipt, on every invoice rather than on a sample, are the same controls that make processing cheaper.
How long does the month-end close take, and why is it not getting shorter?
The close is where manual work becomes visible to everyone outside finance, because it is the one deadline the rest of the business notices. The benchmarks have barely moved in six years.
8.0 days
Median cycle time in days to complete the monthly financial close.
Sample of 3,123 organisations, cross-industry. APQC's database updates continuously.
APQC, Open Standards Benchmarking, measure 104615 (cycle time to complete monthly financial close), 2026Independent research
6.0 days
Median cycle time to complete the monthly consolidated financial statements — the narrower measure, from trial balance to consolidated statements.
Worth knowing both. Vendors quoting a fast close benchmark are usually quoting this one, not the full close.
APQC, Open Standards Benchmarking (cycle time to complete monthly consolidated financial statements), 2026Independent research
59% vs 60%
Organisations completing the monthly close within six business days in 2023, against 2019. Ventana calls the difference statistically insignificant.
Four years, a pandemic, and a great deal of software spending later, the close is exactly where it was.
Ventana Research / ISG, Dynamic Insights: The Smart Financial Close, 2023Analyst benchmarking
44%
Organisations completing the quarterly close within six business days, down from 49% in 2019. The harder close got harder.
Ventana Research / ISG, Dynamic Insights: The Smart Financial Close, 2023Analyst benchmarking
31%
Organisations that automate most or all of their reconciliations. Half of them close the quarter within six business days, against a third of those with little or no automation.
Ventana Research / ISG, Dynamic Insights: The Smart Financial Close, 2023Analyst benchmarking
11%
Organisations using workflow extensively in the close — despite 54% of workflow users closing the quarter inside six days against 21% of those with limited automation.
Ventana Research / ISG, Dynamic Insights: The Smart Financial Close, 2023Analyst benchmarking
88% vs 40%
Companies applying substantial automation to the close who finish monthly books within six business days, against those applying little or none.
The same research found 69% of companies automating reconciliations close monthly within six days, against 53% of those that do not.
Ventana Research, Office of Finance Benchmark Research, 2019Analyst benchmarking
Closing the monthly books within six business days
Ventana Research / ISG. The 2019 figure is Office of Finance Benchmark Research; the 2023 figure is Dynamic Insights: The Smart Financial Close. Ventana describes the change as statistically insignificant.
- 2019
- 60%
- 2023
- 59%
What we take from this
The interesting finding is not the median. It is that automation demonstrably shortens the close — 88% against 40% in Ventana's own numbers — and yet only 11% of organisations use workflow extensively and only 31% automate most reconciliations. The technique works and almost nobody applies it.
That gap is the honest reason closes are not getting faster. It is not that the tools do not work. It is that reconciliation and journal preparation are exactly the tasks that get postponed in favour of the deadline in front of you, every month, forever.
How much of finance still runs on spreadsheets, and how wrong are they?
The shadow ERP. Organisations buy the system, and the real work carries on in a workbook beside it. The most striking evidence comes from teams that own dedicated planning software and use spreadsheets anyway.
96%
FP&A professionals using spreadsheets for planning.
AFP notes the finding holds regardless of company size, geography, ownership type or seniority.
Association for Financial Professionals, 2025 AFP FP&A Benchmarking Survey Report: Technology and Data, 2025Independent research
93%
Using spreadsheets for reporting on a daily or weekly basis. Every single respondent used them at least quarterly.
Association for Financial Professionals, 2025 AFP FP&A Benchmarking Survey Report: Technology and Data, 2025Independent research
71%
Use enterprise performance management software for planning at least quarterly — and still show up in the 96% and 93% above. Owning the system did not replace the workbook.
Association for Financial Professionals, 2025 AFP FP&A Benchmarking Survey Report: Technology and Data, 2025Independent research
61% and 60%
Cite unreliable data and inaccessible data as the main barriers to getting value from their technology — ahead of skills or tools.
Association for Financial Professionals, 2025 AFP FP&A Benchmarking Survey Report: Technology and Data, 2025Independent research
84%
Real operational spreadsheets found to contain errors, across nine audit studies with published methodologies covering 163 spreadsheets. Only one of the nine found errors in fewer than 86%.
Weighted average across the nine studies. Older field audits found lower rates, but used methods unlikely to catch most errors — the better the audit, the worse the result.
Raymond Panko, University of Hawaii, Audits of Operational Spreadsheets, 2024Academic research
27%
Finance leaders who do not fully trust their financial data and blame clunky spreadsheets specifically.
BlackLine, Survey of 1,300+ finance and accounting leaders, seven markets, 2024Vendor-commissioned
15,841
COVID-19 cases missing from UK national reporting between 25 September and 2 October 2020, because results were being collated in the legacy .xls format, which stops at 65,536 rows. Rows past the limit were dropped silently, with no error. An estimated 48,000 contacts went untraced.
The paper exists because the failure was clean enough to use as a natural experiment. Its conservative estimate is that the resulting break in contact tracing was associated with more than 125,000 additional infections and over 1,500 additional deaths. Public Health England confirmed the case figures in its own statement of 4 October 2020.
Fetzer & Graeber (Warwick and Harvard Business School), Does Contact Tracing Work? Quasi-Experimental Evidence from an Excel Error in England, 2020Academic research
How FP&A teams actually work
2025 AFP FP&A Benchmarking Survey Report: Technology and Data. The bottom bar is the share using dedicated planning software; the top three are spreadsheet use by the same population.
- Spreadsheets, at least quarterly
- 100%
- Spreadsheets for planning
- 96%
- Spreadsheets for reporting, daily or weekly
- 93%
- EPM software for planning, at least quarterly
- 71%
What we take from this
The AFP finding is the one to remember, because it kills the usual explanation. These are not teams who could not afford a system. Seven in ten own dedicated planning software and every one of them is still in a spreadsheet at least quarterly. The workbook is not a gap in the tooling; it is where the awkward last mile lives — the reclassification, the accrual nobody automated, the report the system will not produce in the shape the board wants.
Panko's audits are the honest version of the spreadsheet-error statistic. You will see "94% of spreadsheets contain errors" quoted constantly; the properly weighted figure across studies with published methods is 84% of 163 spreadsheets, and it is more damning than the round number, because the better-designed audits found more.
Public Health England is worth citing precisely because it was not incompetence. It was a well-run organisation, a routine file format, and a limit that failed silently. That is the actual risk profile of a spreadsheet in a finance process: not that someone is careless, but that nothing tells you when it breaks.
What is manual work doing to finance teams and the talent pipeline?
The cost that does not appear on any benchmark: the people. Two things are happening at once — the work is exhausting the people doing it, and fewer people are arriving to replace them.
99%
Accountants who experience exhaustion, feelings of inefficiency and alienation from their work at some point in their careers — the three dimensions that define burnout.
University research in partnership with a software vendor, reported by the AICPA's own Journal of Accountancy.
University of Georgia and FloQast, Study of burnout in the accounting profession, 2024Academic research
44%
US workers across all occupations reporting burnout — the comparison that makes the accounting figure meaningful.
Society for Human Resource Management, SHRM employee mental health research, 2024Independent research
55% vs 41%
Accountants suffering stress and burnout, against employees in other sectors.
Institute of Chartered Accountants in England and Wales, ICAEW member survey, 2022Independent research
51%
Accounting and finance team leaders in Central and Eastern Europe reporting symptoms of professional burnout.
AICPA, CIMA and PwC, Joint study of finance team leaders, 2023Independent research
55,152
US students who earned a bachelor's or master's degree in accounting in 2023–24, down 6.6% on the year — after falls of 9.6% and 7.4% in the two years before.
Separately, US Department of Education data show 40,817 accounting bachelor's degrees in the same year, down 3.3%.
AICPA, 2025 Trends: A Report on Accounting Education, the CPA Exam, and Public Accounting Firms' Hiring of Recent Graduates, 2025Independent research
124,200
Projected annual openings for accountants and auditors in the US, 2024–34. Roughly twice the number of accounting degrees now being awarded each year.
Openings include replacements for people leaving the occupation, not just growth. Median wage $81,680 (2024).
US Bureau of Labor Statistics, Employment Projections, 2024–34, 2025Official statistics
+7.3%
Growth in US undergraduate accounting enrolment in autumn 2025 — a third consecutive annual rise, and the first good news in this section.
Enrolment leads graduations by three to four years, so the graduate numbers should stop falling before the end of the decade.
AICPA and National Student Clearinghouse, Final Fall Enrollment Trends, 2026Independent research
US accounting degrees awarded, annual change
AICPA Trends reports. Bachelor's and master's degrees combined; 2023–24 is the most recent year reported, at 55,152 degrees.
- 2021–22
- −7.4%
- 2022–23
- −9.6%
- 2023–24
- −6.6%
What we take from this
Put the two halves together and the arithmetic is unforgiving. The US needs roughly 124,000 accountants a year and is producing about 55,000 accounting graduates, of whom only some enter the profession. Whatever manual work is not automated in the next few years will not simply be done more slowly. In many teams it will not be done at all.
This is also the strongest argument against the framing that automation is about headcount reduction. In a profession that cannot fill the roles it already has, taking the rekeying away is not how you employ fewer accountants. It is how you keep the ones you have.
How this page was put together
Every figure was read out of the publisher's own document — the report, the benchmark record, the press release, the paper — and not out of an article quoting it. Each line carries the publisher, the edition and a link, so you can check any of it in a click.
Statistics are tagged by where they come from. Independent research, analyst benchmarking, academic work and official statistics are all stronger evidence than a vendor-commissioned survey. Vendor research is included where the sample is large and the method is disclosed, but it is labelled so you can weigh it accordingly.
Where a widely-repeated statistic could not be traced to a primary source, it was left out and the gap noted rather than papered over. That applies to the popular claims about keying error rates, the cost of poor data quality, and hours per week per accountant on manual entry. If you have the underlying study for any of those, we would genuinely like to see it.
Reviewed annually. Ardent Partners, APQC and the AICPA all publish on a yearly or biennial cycle, so the figures here are re-checked against the newest editions each August.
Run these benchmarks against your own numbers
The benchmarks above are prefilled into our calculators, cited to the same sources. Free, no email required, nothing stored.
DSO / cash release calculator
See how much cash is tied up in your receivables, and what pulling your DSO back by a few days is worth.
AP cost-per-invoice calculator
Work out what each supplier invoice costs you to process, and the annual gap to best-in-class.
Automation ROI calculator
Put hours saved against build cost and get a payback period in months for any finance process.
Related research
This page covers what the manual work costs. Its sibling covers what finance teams think about handing that work to AI — and why trust, not technology, is where it stalls.
Questions people ask
How much does it cost to process an invoice manually?
Ardent Partners' State of ePayables 2025 puts the average all-inclusive cost at $9.84 per invoice. Organisations Ardent classes as Best-in-Class — the 20% with the lowest costs and shortest cycle times — process the same invoice for $2.65, while everyone else averages $12.42. The gap tracks almost entirely with how many invoices are processed straight through without a person touching them: 51% for the leaders against 29% for everyone else.
How many hours a week do finance teams spend on manual data entry?
There is no well-sourced, finance-specific figure for this, and the hours-per-week numbers in circulation generally trace back to vendor marketing rather than research. The best-evidenced adjacent figure is Intuit's 2024 Business Solutions Survey, in which businesses reported spending 25 hours a week on manual data entry and reconciling data between applications — but that is whole-business time, not one accountant's. A more defensible way to size your own problem is APQC's benchmark of 12,000 invoices processed per accounts payable person per year: if your team is well below that, the difference is time going somewhere.
What is a normal invoice exception rate?
Ardent Partners puts the 2025 average at 18.4% — nearly one invoice in five stops and needs a human to resolve it. Best-in-Class organisations run at 11.1% against 20.9% for everyone else. Ardent identifies exceptions as the single biggest reason the other accounts payable benchmarks are not better, because an exception drives cost, cycle time and the supplier phone calls that consume 21.9% of AP staff time.
How long should a month-end close take?
APQC's cross-industry median for completing the monthly financial close is 8.0 days, from a sample of 3,123 organisations. The narrower measure — trial balance to consolidated financial statements — has a median of 6.0 days. Ventana Research found 59% of organisations closing within six business days in 2023, statistically unchanged from 60% in 2019.
What percentage of spreadsheets contain errors?
Across nine spreadsheet audit studies with published methodologies, covering 163 real operational spreadsheets, errors were found in 84% by weighted average, and only one of the nine studies found errors in fewer than 86%. That figure comes from Raymond Panko's long-running review of the audit literature at the University of Hawaii. The widely-quoted "94%" is a looser summary of the same body of work; the 84% figure is the one with the methodology attached.
Do finance teams still use spreadsheets if they have an ERP or planning system?
Yes, almost universally. The 2025 AFP FP&A Benchmarking Survey found 96% of FP&A professionals use spreadsheets for planning and 93% use them for reporting daily or weekly, with every respondent using them at least quarterly — while 71% of the same group also use dedicated enterprise performance management software. Owning the system does not replace the workbook.
Is there really an accountant shortage?
In the US, yes, on the numbers. The AICPA's 2025 Trends report counted 55,152 accounting degrees awarded in 2023–24, down 6.6% after falls of 9.6% and 7.4% in the preceding two years, while the Bureau of Labor Statistics projects about 124,200 annual openings for accountants and auditors through 2034. Undergraduate accounting enrolment has now risen for three consecutive years, which should ease the graduate numbers later this decade, but not before the shortfall is felt.
Where do these statistics come from, and how often are they updated?
Every figure on this page was read from the publisher's own document and carries the publisher's name, the edition year and a link to the original. Where a widely-repeated statistic could not be traced to a primary source — including the popular claims about keying error rates and the cost of poor data quality — it is either left out or flagged as unverified rather than quoted. The page is reviewed annually against the newest editions of the underlying research.
Want to know which of these numbers is yours?
Thirty minutes with a Chartered Accountant who builds this software for a living. We will work out your cost per invoice, your exception rate and your close duration from your own systems, and tell you honestly whether automation is worth it.