🔍 Read the full analysis: AI Meets Bookkeeping: A Spreadsheet-Focused Guide on ThorstenMeyerAI.com
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
TL;DR
A November 22, 2026 article from ThorstenMeyerAI.com traces how spreadsheets made financial recalculation faster and changed the balance between bookkeeping clerks and accountants. It cites BLS figures showing about 1.53 million clerks and 1.60 million accountants and auditors in 2025, while warning that projected job changes through 2035 are forecasts, not outcomes.
A November 22 report from ThorstenMeyerAI.com examines how spreadsheets changed bookkeeping by automating calculations and how AI may further reshape routine accounting tasks. The report cites Bureau of Labor Statistics figures showing roughly 1.53 million bookkeeping, accounting and auditing clerks and 1.60 million accountants and auditors in the United States in 2025, a marked shift from the historical pattern of about two bookkeepers for every accountant.
The report centers on the spreadsheet’s ability to recalculate linked figures after a user changes an input. Before spreadsheets, a business what-if could mean revising a ledger and repeating calculations by hand. In an account reported by Steven Levy in 1984, Cincinnati accountant Don Jackson said a calculation that once took him 20 hours took 15 minutes with a spreadsheet. That is an attributed example from one accountant, not a measurement of productivity across the profession.
Dan Bricklin conceived the spreadsheet idea while studying a paper-based financial case at Harvard Business School in 1978. Working with programmer Bob Frankston, he developed VisiCalc, whose first complete package, Bricklin later wrote, shipped for the Apple II on October 19, 1979. The product let users change figures in a grid 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, according to the report.
The employment figures show a longer shift, but do not establish that spreadsheets alone caused it; accounting firm workflows for AI bookkeeping risk reviews offer a related look at changes in accounting work. BLS data cited in the article put bookkeeping, accounting and auditing clerks at about 2.25 million in 1988, compared with about 963,000 accountants and auditors. By 2025, the clerk group numbered about 1.53 million, while accountants and auditors numbered about 1.60 million. The report also points to accounting software and other changes in work, alongside spreadsheets, as contributors to the change.
Infographic 01 · How the spreadsheet arrived
From the abacus to VisiCalc
Machines chased bookkeeping for decades. The spreadsheet put the calculation on every desk.
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
Routine Accounting Work Is Shifting
The history matters because it shows that automation can change the tasks workers perform without making an occupation disappear outright. Spreadsheets reduced the time needed for recalculations and made it easier to test different assumptions. Accounting software also took over much of the posting and adding involved in bookkeeping, according to the report. Yet the BLS count cited for 2025 still includes about 1.53 million clerks.
AI is now being discussed as another tool for automating routine work. The BLS projects that bookkeeping, accounting and auditing clerk employment will decline by 6% from 2025 to 2035, while accountant and auditor employment will grow by 5% over that period. The agency expects AI to take on routine tasks such as data entry, while projecting no reduction in overall demand for accountants. Those estimates are forecasts, not confirmed future results, and they do not establish how any particular employer will change its staffing.
Products Worth Considering

Ledger Nano Gen5 Crypto Wallet with Touchscreen, Black

Logitech MX Creative Console with 9 Customizable Keys, Graphite

Ledger Nano X Bluetooth Crypto Hardware Wallet
As an affiliate, we earn on qualifying purchases.
From Paper Ledgers to Spreadsheets
Bookkeepers record business transactions, posting money received and spent to accounts and checking totals. For much of the 20th century, US employment data counted substantially more bookkeepers than accountants: the report gives a ratio of roughly two to one in census figures from 1950 through 1970. Before personal-computer spreadsheets, changing an assumption could mean recalculating ledger sheets manually or relying on a central data-processing operation.
Computers were already being used in accounting before VisiCalc. The report says DATEV, a cooperative founded by German tax advisers in 1966, processed clients’ bookkeeping using rented IBM mainframes. Such systems required large computers and specialists. VisiCalc brought a changeable calculation grid to a personal computer, making what-if calculations more accessible to individual users. In 1984, Levy reported that Americans were buying more than a million spreadsheet programs a year, worth over $250 million; those are figures reported at the time, not current market data.
What the Employment Figures Cannot Show
The figures describe changes in job categories over time, but they do not isolate the effect of spreadsheets from accounting software, economic conditions, business growth or other technologies. The historical example of one accountant’s time savings also cannot establish how much the profession as a whole changed because of spreadsheets.
The report presents BLS projections for 2025 to 2035, but future employment levels and AI’s effect on particular duties remain uncertain. It does not specify how quickly businesses will adopt AI tools, which tasks will be automated at individual workplaces, or whether changes in demand will differ by industry, firm size or location.
The Next Test for Accounting Automation
The next point to watch is whether actual employment data through 2035 follows the BLS projections and how the mix of work changes as employers adopt AI. The source article does not identify a specific upcoming BLS release or a confirmed implementation timetable. Readers should treat the stated declines and growth rates as projections through 2035, not as a settled account of what will happen to bookkeeping or accounting jobs.
Key Questions
What is the news development?
A November 22, 2026 report reviews how spreadsheets changed bookkeeping and compares that history with BLS employment figures and projections for AI-related automation.
How many bookkeeping clerks were counted in 2025?
The report cites about 1.53 million bookkeeping, accounting and auditing clerks in 2025, alongside about 1.60 million accountants and auditors.
Did spreadsheets eliminate bookkeeping jobs?
The figures do not show that spreadsheets alone eliminated the work. The report says bookkeeping clerk employment fell from about 2.25 million in 1988 to about 1.53 million in 2025, while also identifying accounting software and other factors. Millions of clerks remained employed in 2025.
What does the BLS project for these occupations?
For 2025 to 2035, the BLS projects a 6% decline in bookkeeping, accounting and auditing clerk employment and 5% growth for accountants and auditors. These are projections, not confirmed future results.
Does the report show how AI will affect a particular worker or company?
No. It cites an overall BLS forecast and says routine tasks such as data entry may be taken over by AI. It does not establish when or how a specific employer will adopt AI or change staffing.
Source: ThorstenMeyerAI.com
