Is Copilot Worth It for a Small Accounting Firm? Tasks and Seat Cost

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Is Copilot Worth It for a Small Accounting Firm? Tasks and Seat Cost.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Is Copilot Worth It for a Small Accounting Firm? Tasks and Seat Cost.

Microsoft 365 Copilot Business costs $21 a user a month on annual billing, $25.20 billed monthly, or $18 for the first year if bought before 31 December 2026, on top of a Microsoft 365 business plan. At $60 an hour of staff time it pays back after 21 minutes saved a month, so start with three seats and a 30-day log.

The catch is that part of Copilot is already free. Copilot Chat comes with business plans and answers questions about your inbox, calendar and meetings in Outlook, so the seat must earn its cost on what the free version cannot do: Teams meeting recaps, and priority and advanced access in Excel and the other apps. Test each task on an unlicensed account first, and count only the minutes the free route cannot give you.

Follow me on Instagram@sagnikteaches

The seat price three ways, and what a trial does to the discount

Microsoft's Copilot Business page lists the add-on at $21 per user per month on annual billing and $25.20 on monthly billing. The first-year promotion at $18 runs from 1 July to 31 December 2026, needs an annual commitment, and is limited to existing customers with an eligible business plan. Both subscriptions auto-renew, so diarise the renewal date. Microsoft also notes that some advanced AI features are billed by usage on top of the licence fee. The product is being relabelled Microsoft Copilot in places, so expect both names on screen.

Connect on LinkedInSagnik Bhattacharya
BillingPer seat per monthPer seat per yearThree seats per year
Annual, list price$21$252$756
Annual, first-year promotion to 31 December 2026$18$216$648
Monthly billing$25.20$302.40$907.20

The promotion saves $36 a seat, or $108 across three seats over the year. That is worth taking once you have decided, and not a reason to decide. Microsoft's page offers a one-month trial that asks for a credit card and converts to paid unless you cancel, and the promotion's terms say the discount is not available on trial subscriptions. Timing therefore matters: a trial started in the first week of November ends in early December, which leaves about three weeks to buy at $18 if the seats have earned their place. Check with Microsoft or your reseller that a purchase after a trial still qualifies. Some Microsoft partners also offer a 25-user, 30-day Copilot Business trial called Copilot in 30; eligibility, headcount limits and the closing date vary by partner, so ask yours whether a six-person firm qualifies.

Subscribe on YouTube@sagnikteaches

What you already have: three licence labels

Microsoft's page on which Copilot licence you have says work users see one of three labels under their name on the Microsoft 365 home page. Copilot Chat (Basic) means no add-on and no access to Copilot in Word, Excel, PowerPoint and OneNote. M365 Copilot (Basic) means no add-on but standard access in those apps. M365 Copilot (Premium) means the add-on, with priority access to the full experience. Look at your own label before anything else, because it tells you where the free route stops.

AreaWithout a seatWith a seat
Copilot ChatIncluded with eligible business plans; in Outlook it answers questions about the inbox, calendar, meetings and other limited dataThe full Copilot experience in Word, Excel, PowerPoint and OneNote, with priority access
ExcelStandard access if your label is M365 Copilot (Basic); none in the app if it is Copilot Chat (Basic)Priority access to the full experience, plus what Microsoft calls advanced AI features in the spreadsheet, including Agent Mode for multi-step tasks
OutlookMicrosoft says all subscribers have access to Copilot in Outlook, and Copilot Chat answers questions about the inbox, calendar and meetingsCopilot Chat also reaches Teams chats and wider company data; Microsoft does not say clearly which Outlook buttons need the licence, so test them
Teams meetingsNo intelligent recap unless you have Teams PremiumIntelligent recap included
Ongoing work without a fresh promptNot includedAutopilot and Cowork, which the Copilot Business page lists among the paid plan's advanced AI experiences

Two rows decide most firms' sums. Teams recaps are a clear paid-only feature. Everything else sits on a line that Microsoft's own pages leave blurry, which is why the next section matters more than any feature list.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

A side-by-side test on an unlicensed account

Before buying, spend an afternoon on this. It costs nothing if you use a trial seat for the second half.

  1. Sign in as an ordinary staff user without the add-on, open the Microsoft 365 home page and write down the label under the name.
  2. Take six tasks from last month's real work, using dummy or anonymised client data, and run each on that account.
  3. Run the same six on a trial seat.
  4. For each, record one of three results: works the same, works but weaker, or missing. Note what exactly was weaker, such as a button that does not appear, a shorter answer or a refusal to read a file.
  5. Count in the ledger below only the minutes where the free route was weaker or missing.

Every task that works the same on the free route is a task that does not justify a seat. That is not a failure. It means the firm already has some of the benefit, at no cost, and can spend seats where they make a difference.

Naming the tasks: a ledger for three roles

Take an illustrative six-person firm: one partner, two senior accountants, two bookkeepers and an administrator. The partner's time costs the firm $120 an hour, a senior's $60, a bookkeeper's $35 and the administrator's $28. The minutes below are assumptions for the firm to replace with its own timings, not Microsoft's claims.

RoleTaskAppFree route?Minutes saved per runRuns a monthMinutes a month
PartnerBrief before a client meeting from recent email and the calendarOutlookLikely81296
PartnerRecap and action list for a recorded client callTeamsNo10880
PartnerSummary of a long client thread with open questionsOutlookLikely41560
SeniorExplain an inherited client workbookExcelTest15690
SeniorClean a bank CSV: dates, duplicates, categoriesExcelTest1010100
SeniorPivotTable and chart for a review meetingExcelTest8864
SeniorFirst-draft variance commentaryExcelTest10880
BookkeeperChaser emails for missing recordsOutlookTest32060
BookkeeperClean a bank CSVExcelTest61272
BookkeeperDebug a formula that returns the wrong totalExcelTest10440

The Free route column carries three values. No means Microsoft says a paid licence or Teams Premium is needed. Likely means Copilot Chat's reach into Outlook should cover it. Test means Microsoft's pages do not settle it and your side-by-side test must. For the chaser emails, the mechanics of finding who owes what are in how to chase missing client records with AI before deadlines, and the CSV tidy-up has a fuller method in cleaning messy data with AI.

Three prompts with sample output, and what to fix

These show what a trial seat produces on real tasks. The outputs are illustrative. Each ends with the check an accountant needs before using the result.

The first is for Excel, in the mode Microsoft calls Chat only, which analyses without changing the workbook.

Prompt: Explain this workbook sheet by sheet in plain English. Then list every formula that
contains a typed-in number instead of a cell reference, with the cell address.

Sample output:
Bank: 212 lines (Date, Description, Amount). Ledger: 198 entries. Rec: matches each bank line
to a ledger entry by amount and date within 3 days; 14 lines unmatched and highlighted.
Typed-in numbers in formulas: Rec!H4 (=G4*1.15), Rec!H9 (=G9-25), Ledger!F31 (=E31/12).

Check: ask "Are there hidden sheets or hidden rows?" because the model read three sheets and this workbook has a fourth called Adj. Click each cell address it gave you, and treat "matches" as unproven until a control total on both sides agrees. If an older workbook still calls the =COPILOT() function, Microsoft retired it on 14 September 2026, so those formulas no longer return answers. Use the side pane instead.

The second is for Outlook, on a thread that has run to 25 messages.

Prompt: Summarise this thread. List what the client has sent, what is still missing for the
year-end file, and any date they promised.

Sample output:
Sent: bank statements January to September, payroll summary.
Missing: October to December statements, fixed asset invoices over $1,000, director's loan balance.
Promised: statements "by Friday" (message dated 14 October).

Check: the thread mentions two different Fridays, so open the 14 October message and confirm which one the client meant. Summaries also merge forwarded text with the sender's own words, so skim the three most recent messages yourself before quoting any date to the client.

The third is for Teams, after a recorded call with a client, and needs the licence or Teams Premium.

Prompt: List the decisions made, the actions with owner and due date, and anything the client
asked that we did not answer.

Sample output:
Decisions: move to quarterly reporting from January.
Actions: [staff name] sends engagement letter draft by 20 November; client sends stock count by 30 November.
Unanswered: whether the loan interest can be claimed against profit.

Check: the unanswered item is a tax question and belongs to a person, not to the recap. Play back the 40 seconds around each action to confirm names and dates. Tell clients when a call is recorded or transcribed, as you would for any recording.

A summary that read a credit as a debit

Picture a senior who asks the side pane for variance commentary on a client's expenses. It reports that travel fell by $4,200 year on year. The ledger shows two credit notes posted late, so travel actually rose by $1,100 and the apparent fall came from sign handling in a summary range. The senior catches it only because the control total on the commentary sheet is off by the same $5,300. The fix is a habit, not a setting: every figure in a Copilot draft is ticked back to a cell, and the draft is never sent while the control total disagrees. Budgeting that habit as 20% of the minutes saved is realistic, and the next section applies it.

Pricing the ledger: what each seat returns

Multiply each role's minutes by that role's hourly cost, then take off a 20% allowance for checking Copilot's output. The break-even column uses the list price of $21 and the same allowance, so it states how many gross minutes a month the seat must save.

RoleMinutes a monthValue at hourly costAfter a 20% checking allowanceBreak-even minutes at $21
Partner, $120 an hour236$472$37813
Senior, $60 an hour334$334$26726
Bookkeeper, $35 an hour172$100$8045
Administrator, $28 an hour, Outlook triage only20$9$756

The bar is low because staff time is expensive. A seat is worth 21 minutes of a senior's time, and about 10 minutes of a partner's. The administrator, with 20 minutes of Outlook triage that the free route probably covers, falls well short and does not get a seat.

The strict reading matters more than the headline. If the side-by-side test shows that every Outlook and Excel task works the same without a seat, the only minutes that count are the Teams recaps: 80 minutes, worth $160 at the partner's rate, or $128 after the allowance. That is still about six times the seat price, but it now rests on one feature. Before paying for a seat only for recaps, compare the price of Teams Premium, which also lists intelligent recap. The senior's and the bookkeeper's seats rest entirely on the Test rows, and for them the afternoon of testing is worth more than any estimate here.

Why three seats, and which three

Start with the partner, one senior and one bookkeeper. They cover three different task sets, so a month's log tells you which role pays, and the second senior waits until the first senior's log has a result. The whole start costs $756 a year at list price, $648 with the promotion, which is $63 a month at list. That is about half an hour of the partner's time. If one role clearly fails the test, that seat has cost $21 for a month of learning, which is cheap compared with six seats bought on a hunch.

If you were thinking of buying for everyone, the maths pushes back. Six seats at list price cost $1,512 a year. If only three people use them meaningfully, the cost per active user is $504 a year, or $42 a month, which is double the list price. Seats that sit idle pay nothing back, and the licence does not make anyone use it.

A firm that should buy no seats yet

Not every firm should buy. Take a two-person practice with a partner and a bookkeeper, no recorded client calls, and most of the work inside a bookkeeping package rather than Excel. Its ledger would hold only Outlook tasks that the free route probably covers, so the strict total is zero minutes and the correct purchase is zero seats. The free Copilot Chat still gives that firm thread summaries and drafting help, and the side-by-side test costs an afternoon. It should revisit the decision when recorded calls become routine, when an Excel-heavy job arrives, or when Microsoft's pages show a feature it relies on has moved behind the licence.

Client files, permissions and Copilot's activity history

An accounting firm holds data that many staff should not see together, so settle these before the first prompt. The facts come from Microsoft's Copilot data and privacy page.

  • Permissions decide what it can show. Microsoft says Copilot surfaces only organisational data to which a user has at least view permission. Loose permissions on a client folder become visible faster once Copilot can search them, so review who can open what before you roll out.
  • Edits travel with the file. Whatever Copilot writes into a workbook and you save becomes ordinary content, so everyone with access to the file, co-authors included, sees it. Check it before the file is shared.
  • Prompts are stored. Prompts and responses form each user's Copilot activity history. Admins can search it with Content search or Microsoft Purview, and users can delete their own history from their account page.
  • Training. Microsoft states that prompts, responses and data accessed through Microsoft Graph are not used to train its foundation models.
  • Web search. When web search is used, Copilot builds a query from the prompt and sends it to Bing, so keep client names out of prompts that need the web.
  • Accuracy is yours. Microsoft says responses are not guaranteed to be factual and users should review output before sending it to others.

Write the rules down in a short policy before the trial. An AI acceptable use policy for a small professional firm gives a starting point, and the email side of the ledger links naturally to AI email triage for professional firms.

A 30-day log and the stop rule

Each of the three people keeps a one-line log per task, in a shared spreadsheet, with the minutes the task took and the minutes it would have taken before. Here is an illustrative extract from week two.

DatePersonTaskMinutes beforeMinutes with Copilot, including checkingNote
11 NovPartnerRecap of a client call156Action dates corrected from the recording
12 NovSeniorBank CSV clean2514Dates were fine, three categories wrong
13 NovBookkeeperChaser emails, 12 clients4031Tone stiff, rewrote opening lines
14 NovSeniorVariance commentary3034Sign error found; slower than doing it by hand

The last row is the useful one. A draft that costs more time than it saves is a result, and it belongs in the log. At day 30 apply two rules. Keep a seat if the person's logged saving, net of checking, is at least twice the break-even in the pricing table. Stop and reassign a seat if the person logged an error that reached a client, or if the total saving is under the break-even. For the wider method of baselines and sampling, how to measure time saved after rolling out AI in a small firm covers it.

Excel work with Copilot also has a companion in an older tutorial: Copilot data analysis in Excel shows the prompts in more detail. The seat decision here is about whether to pay for them.

Working back from 31 December

The promotion window makes the order of steps matter. If you are reading this in November or early December, work backwards from the deadline.

  1. Week one. Run the side-by-side test and fill in the ledger with your own minutes. Nothing is bought yet.
  2. Week two. Start trial seats for the three people and set up the shared log.
  3. Weeks two to six. Log every task, and hold a ten-minute check at the end of the first week so a bad pattern shows early.
  4. A fortnight before 31 December. Apply the day-30 rules. If the seats pass, ask your reseller whether the $18 promotion still applies to a purchase made after a trial, and buy annual seats only for the people who passed.
  5. If the deadline has gone. The price is $21, and the lost saving is $108 across three seats. Nothing about the decision changes, so do not rush a purchase to save $108.

Questions partners ask before buying seats

Is there a cheaper way to get Teams meeting recaps?

Possibly. Microsoft says intelligent recap needs either a Copilot licence or Teams Premium, and the Teams Premium page lists intelligent recap as a feature. If recaps are the only reason you want a paid licence, compare the current Teams Premium price with the Copilot seat before you buy either.

Do clients' files go into Microsoft's AI training?

Microsoft states that prompts, responses and data accessed through Microsoft Graph are not used to train foundation models. That does not cover everything: Copilot can show a user anything that user already has permission to open, and anything it writes into a saved workbook is visible to everyone who can open that file.

What happens to workbooks that used the COPILOT function?

Microsoft retired the =COPILOT() worksheet function on 14 September 2026, so formulas that still call it no longer return answers. Replace them with values, or with ordinary formulas written using the Copilot side pane, and check the totals against the source data before the file goes back to a client.

Further reads

Sources: Microsoft's Copilot Business add-on page, Microsoft Support pages on Copilot licence labels and Copilot in Excel, Microsoft Learn data and privacy documentation for Copilot, and Microsoft's Teams Premium page (fetched November 2026).

Want your three Copilot seats chosen from real tasks?

On a 1:1 call we'll list the tasks in your own month, test which of them need the paid licence, and decide which three people should start so the log gives you a clear answer.

Book a 1:1 call with me