Can AI Assist Bookkeepers With Spreadsheet Tasks?
AIThis post was created with the assistance of artificial intelligence (AI).

🔍 Read the full analysis: Can AI Assist Bookkeepers With Spreadsheet Tasks? on ThorstenMeyerAI.com

Before you orderOffer from Amazon

Get hardware and tech essentials delivered free with Prime

  • Fast, free delivery on millions of items
  • Prime Video, Amazon Music and more included
  • Member-only deals all year
Start your free Prime trial Free trial for eligible customers · Cancel anytime
As an affiliate, we earn on qualifying purchases.

TL;DR

Spreadsheets and accounting software have automated many routine bookkeeping tasks, while U.S. employment data show fewer bookkeeping, accounting and auditing clerks and more accountants and auditors over time. The Bureau of Labor Statistics projects those trends to continue, but its forecasts are not outcomes, and the source does not establish how much change is caused by AI alone.

A historical account published November 22 examines how spreadsheets automated calculations that once took bookkeepers hours, alongside U.S. employment data showing a long decline in bookkeeping, accounting and auditing clerks relative to accountants and auditors. The account argues that AI may extend that shift, but the scale of its effect is not yet known; government job projections are forecasts, not evidence of what has already happened.

The story traces spreadsheets to Dan Bricklin’s idea for a calculator that would automatically update a whole financial model when a user changed one number. Working with programmer Bob Frankston, Bricklin developed VisiCalc, which shipped for the Apple II in October 1979. Its grid let users change an input and recalculate dependent figures without repeating each calculation by hand.

The practical difference appeared in accountant Don Jackson’s work. In a 1984 account by writer Steven Levy, Jackson said a financial scenario that had taken him 20 hours to recalculate by hand took 15 minutes with a spreadsheet. That example illustrates the time saved on a particular task; it does not establish that all bookkeeping work, or all bookkeeping jobs, disappeared.

The employment figures in the source show a changing balance. The Bureau of Labor Statistics counted about 2.25 million bookkeeping, accounting and auditing clerks in 1988, compared with about 963,000 accountants and auditors. In 2025, it counted about 1.53 million clerks and 1.60 million accountants and auditors. The source attributes automation to spreadsheets and accounting software, while describing AI as a further possible driver of change.

At a glance
reportWhen: Published November 22, 2026; employment…
The developmentA historical account of spreadsheets and U.S. labor data traces how automation reshaped bookkeeping and considers what AI may change next.
Crypto market snapshot
Fear & Greed Index
11/100 — Extreme Fear
Bitcoin BTC$60,832▲ 0.9%
Ethereum ETH$1,709▲ 1.3%
Tether USDT$0.9989▲ 0.0%
BNB BNB$557.07▲ 1.9%
USDC USDC$0.9994▲ 0.0%
XRP XRP$0.9231▼ 0.7%
Solana SOL$70.2▼ 0.6%
TRON TRX$0.305▲ 0.0%
Live data · CoinGecko · alternative.me (24h change)
Thorsten Meyer AI
Work After Work · Ep. 20

Infographic 01 · How the spreadsheet arrived

From the abacus to VisiCalc

Machines chased bookkeeping for decades. The spreadsheet put the calculation on every desk.

15 minone accountant's what-if with a spreadsheet, instead of 20 hours on paper (Harper's, 1984)
19 Oct 1979first complete VisiCalc package, for the Apple II (Bricklin)
1M+spreadsheet programs bought in the US in 1984, Levy reported; VisiCalc alone over 700,000 copies
65tax advisers who founded DATEV in Nuremberg in 1966 to do bookkeeping by computer (company's account)

Machines and the books

  • Tokyo, November 1946: an American soldier with an electric calculator against a Japanese postal worker with a soroban. The abacus won four rounds out of five (Computer History Museum).
  • Nuremberg, 14 February 1966: 65 tax advisers found DATEV to do their clients’ bookkeeping by computer; the first data centre had four rented IBM mainframes at DM 245,000 a month (DATEV).
  • Spring 1978: Harvard Business School student Dan Bricklin imagines a calculator that redoes a ledger sheet by itself (Bricklin).
  • October 1979: VisiCalc by Bricklin and Bob Frankston ships for the Apple II. The analyst Ben Rosen: “the software tail that wags (and sells) the personal computer dog.”
  • Early 1983: Lotus 1-2-3 for the IBM PC; it soon replaces VisiCalc as the leading spreadsheet (Bricklin).
  • 1984: more than a million spreadsheet programs a year in the US. Levy warns: even an elegant spreadsheet is “a house of cards”.

Company and personal accounts are marked as such. The 20-hours figure is one accountant’s own account, as reported by Steven Levy.

Sources: D. Bricklin, VisiCalc history; S. Levy, Harper's, November 1984; Computer History Museum; DATEV company history.
Powered by Thorsten Meyer AI

Automation Changes the Work Mix

The figures matter because they point to a shift in the kinds of accounting work being done, not simply the disappearance of financial recordkeeping. Spreadsheets made calculations and scenario testing faster; accounting software also took on much of the routine posting and adding. The source says about 1.5 million clerk jobs remained in 2025, even after decades of automation.

For bookkeepers, the practical issue is which tasks can be automated and which still require people to check records, resolve discrepancies and understand a client’s financial situation. The source does not quantify how much time AI currently saves, or how many jobs it has affected. It reports the BLS view that AI could take over routine activities such as data entry while overall demand for accountants grows. That is a forecast, not a guarantee about any particular worker or employer.

Products Worth Considering

Ledger Nano X Crypto Hardware Wallet – Bluetooth (Black + Billfodl)

Ledger Nano X Crypto Hardware Wallet – Bluetooth (Black + Billfodl)

Apple MacBook Air 15-inch Laptop with M5 Chip, 16GB Memory, 512GB SSD, Midnight

Apple MacBook Air 15-inch Laptop with M5 Chip, 16GB Memory, 512GB SSD, Midnight

As an affiliate, we earn on qualifying purchases.

From Ledgers to VisiCalc

Before personal-computer spreadsheets, changing a financial assumption could mean reworking a paper ledger with a calculator. Computers were already being used for bookkeeping before VisiCalc: the source notes that German tax-adviser cooperative DATEV was founded in 1966 to process clients’ accounts using mainframe computers. Such systems, however, relied on large machines and specialist operators. A business manager who wanted to test a new assumption could not necessarily recalculate a model directly.

VisiCalc brought that kind of recalculation to a personal computer. Lotus 1-2-3 followed for the IBM PC in 1983 and soon displaced VisiCalc as the leading spreadsheet, according to the source. By 1984, Levy reported that Americans were buying more than a million spreadsheet programs annually. The longer employment comparison in the account shows clerical numbers moving from about 2.25 million in 1988 to 2.13 million in 2000, while accountant and auditor numbers rose from about 963,000 to 1.09 million over the same period.

“I would work for twenty hours. With a spreadsheet, it takes me 15 minutes.”

— Don Jackson, an accountant, quoted by Steven Levy in 1984

AI’s Employment Effect Remains Unclear

The account does not provide a measured estimate of how much AI has already changed bookkeeping employment, wages or workloads. Nor does it isolate AI’s effect from spreadsheets, accounting software, business growth or other changes in the profession. The long-term employment figures show a shift in job counts, but do not by themselves prove which technology caused each change.

The BLS projections cited in the source anticipate a 6% decline in clerk employment by 2035 and 5% growth for accountants and auditors. The agency expects AI to take over routine tasks such as data entry without reducing overall demand for accountants. These are projections, not confirmed outcomes, and the source does not give a specific forecast for the number of jobs AI itself will eliminate or create.

Watch the 2035 Job Forecast

The next evidence will come from updated employment data and future BLS projections showing whether the expected divergence between clerical roles and accountant and auditor roles continues. Those figures can track changes in job totals, though they may not identify AI as the cause without more detailed analysis.

For now, the record presented here is historical: spreadsheets sharply reduced the time needed for some calculations, accounting software took over routine processing, and substantial numbers of bookkeeping clerks remained employed. The question for AI is whether it will alter that balance further, and which tasks will still require human review. The available source describes a possible direction, not a settled result.

Key Questions

Can AI assist bookkeepers with spreadsheet tasks?

The source says the BLS expects AI to take over routine work such as data entry. It does not document specific AI tools or establish how much they currently reduce bookkeeping workloads.

Did spreadsheets eliminate bookkeeping jobs?

The source says spreadsheets and accounting software automated parts of the work, but about 1.53 million bookkeeping, accounting and auditing clerks were still counted in the United States in 2025. The figures do not show that spreadsheets alone caused employment changes.

How much faster could a spreadsheet make a calculation?

Accountant Don Jackson told Steven Levy in 1984 that one client calculation that had taken him 20 hours by hand took 15 minutes with a spreadsheet. That is a reported example, not a universal time-saving estimate.

What does the BLS project for bookkeeping and accounting jobs?

The source reports BLS projections of a 6% decline in bookkeeping, accounting and auditing clerk jobs by 2035 and 5% growth in accountant and auditor jobs. These are forecasts, not confirmed future employment figures.

Source: ThorstenMeyerAI.com

Nothing in this article is financial or investment advice. Cryptocurrency and precious-metal investments carry significant risk — do your own research and consider a licensed advisor.
You May Also Like

The Top 6 AI Solutions For Student Organizations In 2026

Discover the leading AI tools transforming student organizations in 2026, enhancing productivity, organization, and collaboration for students worldwide.

GTA 6 Price & Launch Timeline: Gaming Signal Monitor Insights

Latest gaming signal monitor insights reveal GTA 6’s expected price and release timeline, with official details still pending. Here’s what is known now.

Federal vendor registration renewal assistant

A new federal vendor registration renewal assistant is being tested to help small businesses manage renewal tasks and stay compliant for government contracts.

Food Industry Trends: Uninspected Beef, Pork, And Goat On The Radar

Recent reports highlight uninspected beef, pork, and goat products on recall lists, prompting industry and regulatory attention on food safety practices.