Second Skillset
Try lesson 1

Guide · 6 min read

ChatGPT vs Claude vs Copilot vs Gemini vs Perplexity for accountants: how to choose

The short answer

There's no single best AI for accountants, and any ranking would be out of date within months. For most firms, the best choice is the tool your firm has approved on a business plan, that works where your work already is (Microsoft 365 or Google Workspace), and that you check like any other AI. This guide compares the five main assistants on facts each vendor publishes, and gives you a 30-minute test to run on your own kind of work.

How this comparison was made

What matters more than the model

Vendors release new models every few months. In our view, for everyday accounting tasks, how you use a tool matters more than which leading model it runs. Three things decide more:

  1. The plan and its data terms. Business plans from all five vendors say your data isn't used to train their models by default. Personal plans don't all say that. What your firm has approved, on which plan, decides what you may put in. See whether it's safe to put client data into ChatGPT.
  2. Where your work lives. An assistant inside Excel and Outlook saves copying and pasting, and copying is where client data leaks and figures get mistyped.
  3. How you check the output. Every one of these tools can produce a confident wrong answer. A firm that checks well gets more from an average tool than a firm that trusts a strong one.

The five tools at a glance

AI assistants for accounting work, from each vendor's published information
ToolPlans for organizationsBusiness data used for training?Works inside
ChatGPT (OpenAI)Business, EnterpriseNo, by defaultIts own app; an add-in for Excel and Google Sheets
Claude (Anthropic)Team, EnterpriseNo, for commercial productsIts own app; add-ins for Excel, Word, PowerPoint and Outlook
Microsoft CopilotMicrosoft 365 Copilot; Copilot Chat with a work accountNo (foundation models)Excel, Outlook, Teams and other Microsoft 365 apps
Gemini (Google)Gemini in Google WorkspaceNot without your permissionGmail, Docs, Sheets, Drive and Meet
PerplexityEnterprise Pro, Enterprise MaxNoIts own app and browser, with connectors to your files

Prices change more often than anything else, so check each vendor's current plans: ChatGPT, Claude, Microsoft 365 Copilot, Google Workspace and Perplexity.

Each tool in brief

ChatGPT

OpenAI says it doesn't train its models on inputs and outputs from ChatGPT Business, Enterprise and Edu or its API by default (OpenAI). On personal plans, training is on unless you turn it off (OpenAI Help Center). OpenAI also offers ChatGPT for Excel and Google Sheets as an add-in (OpenAI Help Center). If staff already use ChatGPT at home, the risk is that they use the same personal account for work. That's the gap a firm policy needs to close.

Claude

Anthropic says it doesn't use data shared through its commercial products to train its models (Anthropic). Claude for Excel is available on its Pro, Max, Team and Enterprise plans and shares context with its Word, PowerPoint and Outlook add-ins. Anthropic's own documentation says it isn't recommended for audit-critical calculations without verification, and notes that the add-in doesn't inherit an organization's custom data retention settings (Anthropic). Check both points against your firm's policy.

Microsoft Copilot

As used by organizations, Microsoft Copilot and Copilot Chat are covered by Microsoft's Data Protection Addendum, and Microsoft says prompts and responses aren't used to train its foundation models (Microsoft). It works inside Excel, Outlook and Teams. The Copilot guide covers what it does in each, and what to check.

Gemini

Google says Workspace doesn't use customer data, including prompts, to train models without the customer's prior permission or instruction, and Gemini works in the side panel of Gmail, Docs, Sheets, Drive and Meet (Google). Those commitments are for Workspace accounts, not personal Google accounts.

Perplexity

Perplexity's core product is research: answers drawn from the web, shown with their sources. For its Enterprise plans, Perplexity says your organization's data is never used to train or fine-tune its models, and that its agreements with the model providers it uses prevent training on its data too (Perplexity). Sources shown next to an answer still need opening: see how to check AI's tax research.

Which fits your situation

  • Your firm runs Microsoft 365 and IT manages it. Start with Copilot, because it's already inside the apps and under the agreement you have. Other assistants' Excel add-ins are an option if your IT team approves them.
  • Your firm runs Google Workspace. Start with Gemini, for the same reasons.
  • You need research with sources you can follow. Perplexity or any assistant with web search, plus the citation checks in the tax research guide. For tax and accounting authority, a research tool built for professionals may suit better (see below).
  • You work mainly in spreadsheets. Look at the Excel options: Copilot, ChatGPT for Excel, Claude for Excel. Run the test below on one of your own (anonymized) workbooks.
  • You're a solo practitioner or a very small firm. A single business plan from any of these vendors, used consistently and checked carefully, beats a mix of personal accounts.

Test them yourself in 30 minutes

Benchmarks published by vendors don't test accounting work. Your own test will tell you more. Use made-up data or data with every identifying detail removed, and give each tool exactly the same task and files.

  1. Pick one real task you do every month, such as coding a bank export or explaining account movements.
  2. Plant two problems in the practice file: a line nobody could code from its description, and a figure that stops the total tying.
  3. Use the same prompt in each tool, with the rules from the prompts guide.
  4. Score each answer on the checks below, then try one correction and see whether it fixes the problem without breaking anything else.
A scoring sheet for your test
CheckA pass looks like
The totalThe output ties to your control total, or the tool says it doesn't
The unclear lineFlagged for a person, not guessed
Every line keptNothing dropped, merged or quietly added
SourcesEvery cited line or document exists and says what's claimed
UncertaintyIt says when something isn't in the files
The correctionFixed first time, with nothing else changed

Run the same test again when a vendor releases a new model or your firm considers a change. It takes half an hour and tells you more than any ranking.

Specialist tax and accounting research tools

Several publishers of tax and accounting research now build AI into their products, answering from their own libraries of authority. They can be a better fit for research than a general assistant. They still make mistakes: a 2024 Stanford study found that AI research tools built for lawyers gave incorrect information more than 17% of the time (Stanford HAI). The same checks apply whichever tool you use.

Keeping this guide current

Plans, features and terms change often. We check every fact in this guide each quarter and update the date at the top. If you spot something out of date before then, tell us at tom@secondskillset.com.

Practice this now

Lesson 1 is the 30-minute test in practice form: a messy bank export with a line nobody could code and a total that has to tie. You set the rules for an AI assistant and check its work. No signup, and it takes under 10 minutes.

Start lesson 1 free

Sources

  1. OpenAI: Enterprise privacy
  2. OpenAI Help Center: how ChatGPT uses your data
  3. OpenAI Help Center: ChatGPT for Excel and Google Sheets
  4. Anthropic: data relationship between Anthropic, the customer and the user
  5. Anthropic: Use Claude for Excel
  6. Microsoft Learn: Enterprise data protection in Microsoft Copilot and Microsoft Copilot Chat
  7. Google: Generative AI in Google Workspace Privacy Hub
  8. Perplexity Help Center: What is Enterprise Pro?
  9. Stanford HAI: AI on trial, legal models hallucinate in 1 out of 6 (or more) benchmarking queries (May 2024)