Getting Started With AI In Bookkeeping Spreadsheets
AIThis post was created with the assistance of artificial intelligence (AI).

🔍 Read the full analysis: Getting Started With AI In Bookkeeping Spreadsheets on ThorstenMeyerAI.com

Before you orderOffer from Amazon

Get smart everyday buys 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

The source article, published November 22, 2026, uses the history of spreadsheets to examine how automation has changed bookkeeping work and what AI may change next. It reports that U.S. bookkeeping, accounting and auditing clerk employment was about 1.53 million in 2025, while BLS projections point to a further decline; those projections are estimates, not outcomes. For readers starting with AI in bookkeeping spreadsheets, the practical lesson is to test narrow, repeatable tasks and check every result against source records.

A November 22, 2026, report on ThorstenMeyerAI.com examines how spreadsheets and accounting software changed bookkeeping, and uses that history to consider the next wave of AI-assisted work. The figures it cites show U.S. bookkeeping, accounting and auditing clerk employment at about 1.53 million in 2025; the Bureau of Labor Statistics projects a further decline by 2035, but that forecast is not a confirmed outcome.

The report’s historical example is the launch of VisiCalc, the spreadsheet developed by Dan Bricklin and programmer Bob Frankston. Bricklin’s idea grew from the labor of changing one figure in a financial model and then recalculating the rest by hand. The first complete VisiCalc package shipped for the Apple II on October 19, 1979, according to Bricklin. A spreadsheet recalculated dependent figures when a user changed an input, making financial what-if analysis much faster.

In a 1984 account by writer Steven Levy, Cincinnati accountant Don Jackson said a calculation that once took him 20 hours could be completed in 15 minutes with a spreadsheet. The report also describes a longer shift from bookkeeping clerks toward accountants: BLS figures cited in the article put clerks at about 2.25 million in 1988 and 1.53 million in 2025, while accountants and auditors rose from about 963,000 to 1.60 million over the same years.

The report attributes the employment change to more than spreadsheets alone: accounting software also automated posting and adding. It says the BLS expects bookkeeping, accounting and auditing clerk employment to decline by 6% through 2035, while accountant and auditor employment grows by 5%. The agency’s forecast suggests routine tasks such as data entry may be automated without reducing overall demand for accountants. That is a projection about occupations, not a guarantee about any individual business or worker.

At a glance
reportWhen: Published November 22, 2026; employment…
The developmentA November 22, 2026, article traces spreadsheets’ effects on bookkeeping and uses that history to frame how businesses might approach AI-assisted spreadsheet work.
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

Lessons for AI Spreadsheet Work

The history offers a practical frame for readers beginning to use AI in bookkeeping spreadsheets: automation changes tasks, but does not by itself explain what happens to a whole occupation. Spreadsheets made recalculation easier; later software took on more transaction posting. AI tools may assist with categorizing entries, extracting information from documents, spotting anomalies or explaining formulas, but the source material does not establish how reliably particular AI products perform those tasks.

For a business, the immediate question is not whether AI will replace bookkeeping, but which bounded task can be tested safely. A spreadsheet assistant might help draft a formula or flag entries that differ from a pattern. A person still needs to compare the output with invoices, bank records and the ledger. Incorrect classifications or missed transactions can affect reporting and decisions, so an automated result should not be treated as verified merely because it appears plausible.

The employment figures also underline that job counts and job duties are different measures. The report describes a decline in clerk employment alongside growth in accountant and auditor employment, but the figures do not prove that spreadsheets alone caused the change. For workers and small firms, the useful takeaway is to learn how automation affects specific processes while preserving review, documentation and accountability.

Products Worth Considering

Logitech MX Mechanical Wireless Illuminated Keyboard, Tactile Quiet, Graphite

Logitech MX Mechanical Wireless Illuminated Keyboard, Tactile Quiet, Graphite

As an affiliate, we earn on qualifying purchases.

From VisiCalc to AI Tools

Before personal-computer spreadsheets, accountants could use calculators and paper ledgers, while larger-scale computer processing was generally handled by specialists. The report notes that DATEV, a German tax-adviser cooperative, was founded in 1966 to process clients’ bookkeeping by computer. Those systems predated VisiCalc, but they did not offer every business user the same direct, interactive way to change a number and see the dependent calculations update.

VisiCalc helped popularize that capability on personal computers. Lotus 1-2-3 followed for the IBM PC in 1983 and soon displaced VisiCalc as the leading spreadsheet, according to the report. The shift reduced the time required for some calculations, but the historical sequence involved several technologies and changes in work organization. The same caution applies when comparing spreadsheet automation with AI: a tool’s capabilities, adoption and effect on employment are separate questions.

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

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

What the Forecast Cannot Show

The article does not provide evidence that AI has already caused a specific number of bookkeeping jobs to disappear, nor does it isolate AI’s effect from spreadsheets, accounting software, business growth or other changes. Its 2035 employment figures are BLS projections; actual employment may differ. The source also does not compare the accuracy or cost of particular AI bookkeeping products, or report results from a controlled trial of AI-assisted spreadsheet workflows.

Readers should treat the historical counts as figures reported for the specified years and categories, not as proof of a single cause. The report’s suggestion that AI may take over routine work is grounded in the agency’s outlook, but how quickly businesses adopt tools and how workers’ responsibilities change remain uncertain.

Testing AI in the Ledger

For a business considering AI in spreadsheets, a sensible next step is a limited trial on a repeatable, low-risk task, using a copy of the data rather than changing the official books. Record what the tool is asked to do, check its output against the original documents and ledger, and keep a person responsible for approving any entry. Avoid placing sensitive financial information into a service until its data-handling terms have been reviewed.

The broader test will be whether AI tools can perform useful bookkeeping tasks accurately and consistently in real operations. The source report offers historical context and cites labor projections, but it does not set a timetable for adoption or establish a particular tool’s performance. Future employment data and evidence from businesses’ use of AI will show more about how the work changes.

Key Questions

What is the report about?

It traces how spreadsheets and accounting software changed bookkeeping work, then considers AI as a potential next source of task automation. It is a historical report, not a product test of AI bookkeeping tools.

How many bookkeeping clerks were reported in 2025?

The source cites about 1.53 million U.S. bookkeeping, accounting and auditing clerks in 2025. It also cites about 1.60 million accountants and auditors for that year.

Does the BLS forecast mean AI will eliminate bookkeeping jobs?

No. The report says the BLS projects a 6% decline in clerk employment through 2035 and 5% growth for accountants and auditors. These are projections, not confirmed outcomes, and the figures do not isolate AI as the sole cause.

How can a small business begin using AI in bookkeeping spreadsheets?

Start with a narrow task, such as drafting a formula or flagging unusual entries, and test it on copied data. Verify each result against original records before using it in official books, and check how the AI service handles financial information.

Source: ThorstenMeyerAI.com

This content is for general information only and is not financial, tax or legal advice. Consult a qualified professional for decisions about your money.
You May Also Like

Apple’s Lawsuit Sheds Light On The Risks Of Employee Movement In Tech

Apple has filed a lawsuit against OpenAI, accusing former employees of stealing trade secrets, underscoring the legal risks of employee transitions in the tech industry.

Apple Is Reaching For Chinese Memory. Europe Doesn’t Even Have That Option.

Apple seeks US approval to buy chips from China’s CXMT, exposing Europe’s lack of memory manufacturing capacity amid global shortages.

Search as Code: Perplexity Is Right About the Future — Just Not First to It

Perplexity introduces Search as Code (SaC), enabling AI agents to assemble custom retrieval pipelines, enhancing accuracy and control in search tasks.

11 AI-Powered Note-Taking Apps That Will Boost Productivity in 2026

Explore the top 11 AI-powered note-taking apps in 2026 that enhance productivity through voice, handwriting, and smart features, with detailed analysis and future outlook.