← All insights
AI and trust 22 Sep 2026 · 10 min read

Can ChatGPT do my accounting? What it does well, what it gets wrong, what it must never touch

By the Navigator team ·

No, and since July 2026 the question has a second half. ChatGPT is good at the language around your books: explaining a line on the P&L, drafting the collections email, writing the spreadsheet formula, telling you what a due-to account is. ChatGPT cannot do the accounting itself. Given a bank feed it categorizes confidently and gets a share wrong. Given a spreadsheet it produces a total that looks right and is not. Asked twice, it can answer differently. And now that QuickBooks Online connects to ChatGPT and Claude with permission to create and delete invoices, "can it" comes with "should it be allowed to", which has a firmer answer.

Three jobs hide inside the word "accounting"

Recording is entering what happened: the sale, the bill, the payroll run, the transfer, each coded to an account. In QuickBooks Online most of it arrives through the bank feed and someone decides what each line is.

Closing is proving the recording is complete: reconciling every bank and card account to its statement, clearing the uncategorized lines, checking that receivables and payables agree with what customers and vendors say, and locking the month.

Deciding is what you do with a closed month: whether to hire, whether the margin on the service line is worth keeping, whether the bank will like the coverage ratio.

A chatbot can help with the third job and with the writing around the first two. It cannot own the first or the second, because both depend on seeing everything and remembering last month, and a chat window does neither. The Intuit 2026 AI Impact Report, a survey of more than 34,000 people published in May 2026, found 77% of US businesses now use AI regularly, up from 48% in July 2024, and that use is lowest in the areas its authors describe as requiring human judgment. That split matches what we see. Owners use it to understand the books and stop short of letting it keep them.

Where it is useful, five times a month

The best use is translation. Paste the P&L for the quarter, with customer names removed, and ask what changed and why the gross margin fell three points. The explanation will be readable and, if the numbers you gave it are right, mostly correct. Ask it what "accrued liabilities" means and you will get a better answer than most search results.

The second is drafting. A collections email for a customer 47 days past due, in a tone that keeps the account, takes one prompt. So does the cover note for the lender package, or the message to the bookkeeper listing the six transactions you want recoded.

The third is spreadsheet help. Ask for a formula that returns days sales outstanding from two cells and it will write one that works, and explain it.

The fourth is turning a variance into a sentence. "Repairs were $18,400 against a budget of $9,200 because two trucks went in the same month" is a sentence a chatbot writes well once you give it the two numbers and the reason.

The fifth is preparing questions. Before the monthly call with the bookkeeper, paste the balance sheet and ask what a careful reviewer would want explained. You will get a list, and half of it will be worth asking. The other half is why questions to ask your bookkeeper every month exists.

Where ChatGPT gets accounting wrong, and the pattern behind each mistake

Categorization is the first place it breaks. Justin McKelvey, a bookkeeper who wrote up his tests in September 2026, pasted in a bank feed and reported that it gave "a confident wrong answer on a third of them", and the word that matters is confident. It does not flag the lines it is unsure about. Ninety lines go in from a bank feed and 90 categories come back. If 30 are wrong, and nothing marks which 30, the review takes longer than the coding would have. The usual advice is to let the AI draft the categorization and have a human check it. We would rather it did not draft at all, because a reviewer checking 90 confident answers stops reading carefully around the fortieth, and the wrong ones are indistinguishable from the right ones on the page.

Arithmetic on long tables is the second. Short sums are fine. Two hundred rows are not, and the failure is quiet. A finance writer at CFO Impulse ran a 200-row dataset through ChatGPT and found the regional breakdown was still wrong after being corrected, that an "Other" bucket had absorbed three industries, and that after five prompt iterations it was, in their words, impossible to verify correctness. The output was a clean table with plausible totals. AI mistakes in accounting that look right catalogs the common ones.

Different answers on a rerun is the third. Ask the same question about the same file twice and you can get two numbers. Some of this is the model, and Thinking Machines showed in September 2025 that 1,000 runs of one prompt at the setting that is supposed to make output identical produced 80 distinct answers. Some of it is that a chat has no fixed source, so each run rebuilds the number. Why ChatGPT gives different answers to the same question goes through both causes.

Invention is the fourth. Ask for the March cash balance when March is not in what you pasted and you may get one anyway, with a decimal point. The model is completing a pattern, and the pattern includes a number.

What the exam scores say, and what they leave out

The study most people cite is from Brigham Young University, published in April 2023. Faculty at 186 universities put more than 20,000 accounting exam questions to ChatGPT; it scored 47.4% against 76.7% for students, and on short-answer questions it managed 28.7% to 39.1%. That was before GPT-4 and it is now old. Newer models are much better at the specific task of coding transactions: Digits' benchmark of June 2026 ran 2,000 real transactions through 13 models, and the best general model got 80.8% right on a single pass and 86.8% with a checking layer around it, while Digits' own purpose-built system scored 97.8%.

Eighty percent is impressive for a general tool and useless for a ledger, where one wrong line in five means the P&L is wrong every month. Ninety-seven percent is a purpose-built system with a review process around it, not a chat window. Owners seem to know this. The QuickBooks 2026 Business Owner Report, a survey of 1,305 owners taken in December 2025, found 20% would rely on AI alone for financial decisions, 37% would lean mostly on humans, and 34% wanted both equally. That middle group has it about right.

What it must never touch

Posting to the ledger. An entry a chatbot writes into QuickBooks is an entry with no reviewer, and it will be found in twelve months by your CPA.

Reconciliation. A reconciliation is a proof that the books match the outside world, and the outside world is the bank statement, which the chatbot cannot see. RemoteBooksOnline's list of what ChatGPT cannot do, updated in late 2025, has reconciling first, followed by processing transactions, finding duplicates and preparing filings. We would sign that list.

Anything you sign. The tax return, the covenant compliance certificate, the personal financial statement for the bank. A number on one of those that came from a chat and not from a report is a number you cannot defend.

Payroll files, bank details and customer identities on a personal plan. The bookkeeper quoted above lists what should never be pasted: client names, tax IDs, account numbers, bank feeds, payroll files, full ledgers. The reason is the training terms on consumer plans; is it safe to upload financial statements to ChatGPT or Claude goes through what each plan does with your data.

The connector changed the second half of the question

Since late July 2026, Intuit's connector lets ChatGPT and Claude read a QuickBooks Online file directly for US customers on every plan. It also lets them create, update, send and delete invoices and estimates, add customers and items, and import transactions into the general ledger. Intuit says destructive actions require user confirmation. The connector has no permission model of its own; it inherits the QuickBooks role of whoever connects it. If that is you, the owner, the chatbot can do everything you can.

That is a bigger exposure than an upload. A pasted P&L can produce a wrong sentence. A connector with write access can produce a wrong invoice, sent to a customer, in your name, on the strength of a prompt that was misread. The fix is to connect through a reports-only user, which QuickBooks Plus and above let you create, and to read the audit log for anything written while it was connected. The ChatGPT and Claude QuickBooks connectors walks through the setup.

Navigator was built on the other side of that line. It connects to QuickBooks Online read-only, so nothing it does can write to the ledger, and the numbers it reports are computed from the ledger rather than by the model; the AI explains them and every answer cites the transaction it came from, so any figure opens to show which company and which entry. The AI is included on every plan with no question cap. That does not make it a bookkeeper either. It reads the books; someone still has to keep them.

A working rule, and the multi-entity catch

The rule that holds up: numbers come from the ledger, the AI explains them, and anything the AI computes gets checked against a report before it is repeated to anyone.

The catch for owners with several companies is that a chatbot sees one file at a time. Paste the P&Ls for three companies and ask for total revenue and you will get the sum, which includes the management fee the operating company paid the holding company and the rent it paid the property LLC. Those are real in each file and counted twice in the total. Nothing in the chat knows that. It will report the inflated figure with confidence. Consolidation is arithmetic with rules, and intercompany eliminations explained is the set of rules a chatbot does not apply on its own.

Questions owners ask

Can ChatGPT do bookkeeping?

Not on its own. It can categorize a sample of transactions, draft a chart of accounts and explain what an entry means, and it will do all three confidently. It cannot reconcile a bank account, post to a ledger it can see the whole of, or find the duplicate it created last month. Bookkeeping is the recording and the checking, and it can only help with the first.

Can ChatGPT replace my bookkeeper?

No. A bookkeeper's value is that the books tie to the bank statement at month end and someone is accountable when they do not. A chatbot has no memory of last month, no access to the statement unless you paste it, and no accountability. It can make a good bookkeeper faster at the writing parts of the job. It cannot do the job.

Is ChatGPT accurate with numbers?

Less than it looks. It does short arithmetic well and long tables badly, and it does not tell you which is which. In one finance writer's test on a 200-row dataset, a regional breakdown was still wrong after correction and an "Other" bucket hid three industries. Every number it computes should be checked against a report from the system that holds the data.

Can ChatGPT read my QuickBooks?

Since late July 2026, yes, for US customers on any QuickBooks Online plan, through Intuit's connector. It reads the P&L, cash flow and benchmarks, and it can also create, edit, send and delete invoices and estimates and import transactions. It gets the permissions of whoever connects it. Connect it as a reports-only user, or it can write to your ledger as you.

What should I never paste into ChatGPT?

On a personal plan, where your conversations may be used for training unless you opt out: customer names, tax IDs, bank and card numbers, payroll files, full bank feeds and full ledgers. A business or enterprise plan changes the training terms, not the risk of a wrong answer. A summarized P&L with the customer names removed is a reasonable thing to paste; a payroll register is not.

If you want to use a chatbot well rather than not at all, ChatGPT prompts for small business finances has the ones that work with a P&L pasted in. For the tools that read QuickBooks directly, and what each one can and cannot change, read the best AI for QuickBooks. And why ChatGPT gives different answers to the same question explains the rerun problem in more detail than fits here.

If you would rather ask questions of your own books and see the entry behind each answer, the trial is read-only, connects in about fifteen minutes and needs no card: navigatorhq.ai.

Navigator Insights by email

Get the next post by email.

One email when a new post goes up: cash, lenders, running several companies and AI. Unsubscribe in one click.

By subscribing you agree to our Privacy Policy.

Published . Last updated . Reviewed by a CFO on the Navigator team.

See every company you own in one place. Every morning.

Navigator connects to QuickBooks Online read-only, consolidates your entities, and answers the questions in these posts on your own numbers. Thirty days free, no card.

Start free trial Run the free Health Check