Using AI To Rethink Spreadsheet Workflows In Bookkeeping
AIThis post was created with the assistance of artificial intelligence (AI).

🔍 Read the full analysis: Using AI To Rethink Spreadsheet Workflows In Bookkeeping on ThorstenMeyerAI.com

Before you orderOffer from Amazon

Get the latest gadgets 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

A November 22, 2026 article from ThorstenMeyerAI.com traces how spreadsheets and accounting software changed bookkeeping work, drawing on historical job figures and Bureau of Labor Statistics data. The figures show fewer bookkeeping, accounting and auditing clerks and more accountants and auditors over time; BLS forecasts further clerk declines and accountant growth, but those are projections, not outcomes.

A November 22, 2026 article from ThorstenMeyerAI.com uses the history of spreadsheets and U.S. employment figures to examine how automation is changing bookkeeping—and what artificial intelligence could change next. The article reports that the number of bookkeeping, accounting and auditing clerks fell from about 2.25 million in 1988 to about 1.53 million in 2025, while the number of accountants and auditors rose from about 963,000 to about 1.60 million. The figures describe a long-running shift, not proof that spreadsheets alone caused it.

The article centers on the spreadsheet’s ability to recalculate linked figures when a user changes an input. Before personal-computer spreadsheets, a business owner or accountant testing a new assumption might have to redo calculations manually or ask a data-processing department for help. The source recounts that accountant Don Jackson told writer Steven Levy in a 1984 Harper’s article that a calculation that once took him 20 hours could take 15 minutes with a spreadsheet. That account is a historical example, not a measure of how much time every accountant saved.

Dan Bricklin conceived the spreadsheet idea while studying a financial case at Harvard Business School in 1978. Working with programmer Bob Frankston, he developed VisiCalc, which shipped for the Apple II in October 1979, according to Bricklin’s account cited by the source. Its grid let users change a value and have dependent calculations update automatically. Lotus 1-2-3 followed for the IBM PC in 1983 and soon displaced VisiCalc as the leading spreadsheet, the article says.

The employment data in the article indicate a change in the balance between clerical and professional accounting roles. It cites BLS figures of about 2.25 million clerks in 1988 and 2.13 million in 2000, compared with about 963,000 accountants and auditors in 1988 and 1.09 million in 2000. By 2025, the cited counts were about 1.53 million clerks and 1.60 million accountants and auditors—roughly one of each for every one of the other group. The source says software and other changes also contributed; the figures do not isolate the spreadsheet’s effect.

At a glance
reportWhen: Published November 22, 2026; employment…
The developmentA November 22 article examines how spreadsheets reshaped bookkeeping and relates that shift to BLS employment data and projections for AI-driven automation.
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

From Ledger Entries to Analysis

The history matters because bookkeeping automation has often changed the tasks within accounting rather than eliminating the entire occupation. Spreadsheets made repeated calculations and scenario testing faster. Accounting software later took on much of the posting and adding work. In the article’s account, demand for clerical bookkeeping roles declined over time while employment among accountants and auditors increased. That pattern is consistent with work shifting toward tasks requiring review, interpretation and advice, but employment counts alone cannot establish why the shift happened.

AI brings a related question into current workplaces: whether software that can handle routine data entry and processing will reduce demand for bookkeeping staff, alter their duties, or do both. The BLS projections cited in the article point to a decline in clerk jobs alongside growth in accountant and auditor jobs. For businesses and workers, the distinction matters: automation may remove or speed up specific tasks without making the broader need for accurate records, financial checks and professional judgment disappear.

The data also caution against treating an automation tool as the sole cause of workforce change. The article notes that accounting software, as well as spreadsheets, took over parts of the work. Changes in business demand, technology and job classification may also matter, but the supplied material does not quantify their effects. The clearest takeaway is a documented change in job counts and a plausible task-level explanation—not a direct causal estimate.

Products Worth Considering

Logitech MX Keys S Combo Wireless Keyboard and Mouse, Graphite

Logitech MX Keys S Combo Wireless Keyboard and Mouse, Graphite

As an affiliate, we earn on qualifying purchases.

How Spreadsheets Changed the Ledger

Bookkeepers traditionally recorded business transactions as debits and credits in a general ledger, then totaled and checked the entries. The source describes this as work that could require repeated calculations and manual corrections. A spreadsheet changed the process by linking figures: changing an input automatically updates calculations that depend on it, making what-if analysis faster and easier to repeat.

Computers were already being used for bookkeeping before personal spreadsheets. The article points to DATEV, a German tax-adviser cooperative founded in 1966, which used a data centre with rented IBM mainframes to process clients’ accounts. That system depended on large computers and specialist support. VisiCalc brought interactive calculations to a personal computer, allowing users to revise figures on screen without sending each new scenario to a data-processing department.

The source cites historical counts showing that the United States had around two bookkeepers for every accountant for much of the period from 1950 through 1970. By 2025, the cited clerk and accountant totals were close to equal. These categories are not identical to every modern bookkeeping and accounting job, and the article’s figures should be read within the classifications and years it reports.

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

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

What the Employment Figures Cannot Show

The figures do not establish how much of the decline in clerk employment was caused by spreadsheets, accounting software or AI. The article attributes the historical shift partly to automation but does not provide a study separating technology’s effect from other economic or workplace changes. Its historical examples also describe particular businesses and users, not the experience of every bookkeeping team.

The BLS outlook cited in the source is a projection, not a confirmed future result: it anticipates a 6% decline in bookkeeping, accounting and auditing clerk employment by 2035 and 5% growth for accountants and auditors. The source says the agency expects AI to take on routine work such as data entry without reducing overall demand for accountants. It does not provide details here about how quickly businesses will adopt AI, which tasks will be automated, or how those forecasts may change.

The article also does not report a new survey, experiment or independently reviewed assessment of AI’s effect on bookkeeping productivity. Its news value is the comparison of historical spreadsheet changes with current employment data and forecasts, rather than a newly measured impact of AI in workplaces.

Tracking AI and Accounting Work

The next measurable test will be whether future employment data follow the BLS projections: fewer bookkeeping, accounting and auditing clerk jobs and more accountant and auditor roles through 2035. Those figures will show how employment changed, though they will not, by themselves, identify AI as the cause.

For now, the source frames AI as the next stage in a longer history of tools that automate routine financial work. Readers should distinguish between tasks that software can handle, forecasts about job totals, and confirmed changes reported by employers or labor statistics. The article supplies no separate announcement of an AI product, adoption programme or new employment study, so the scale and timing of any additional change remain open.

Key Questions

What is the development reported in the article?

The November 22, 2026 article from ThorstenMeyerAI.com connects the history of spreadsheets with U.S. bookkeeping and accounting employment figures and BLS projections about future work.

Did spreadsheets eliminate bookkeeping jobs?

The article says bookkeeping, accounting and auditing clerk employment declined over the period covered, but it does not establish that spreadsheets alone caused the decline. It also points to accounting software as an automation factor and reports about 1.53 million clerk jobs in 2025.

What does the BLS project for these jobs?

According to the source, BLS projections call for a 6% decline in bookkeeping, accounting and auditing clerk employment and 5% growth in accountant and auditor employment by 2035. These are forecasts, not observed outcomes.

Does the source show that AI has already reduced bookkeeping employment?

No. The article discusses AI as a potential source of further automation and cites projections, but it does not provide a new measurement showing that AI has already caused job losses.

Source: ThorstenMeyerAI.com

You May Also Like

Passkeys Were Invented By Engineers With Zero Understanding Of Consumer Brain

New analysis suggests passkeys were developed without understanding user behavior, raising questions about their effectiveness and adoption.

Mobilisiert, Nicht Ausgegeben: Was Von Europas €200-Milliarden-KI-Offensive üBrig Bleibt

Die EU kündigt eine KI-Strategie mit €200 Mrd an, doch nur ein Bruchteil ist garantiert. Die tatsächlichen Investitionen bleiben unklar, die Wirkung gering.

The pyramid cracks. What agentic AI does to the consulting leverage model.

Generative AI disrupts traditional consulting by compressing analysis work, causing industry split between strategy advisory and execution firms.

What Anthropic’s IPO Pricing Means For AI

Anthropic priced its IPO at $83 per share, offering 980 million shares ahead of expected Nasdaq trading under ANT on Nov. 19, 2026.