Microsoft 365 Copilot
Practical guide for tax professionals — foundational practices for safe and effective use, then task-specific patterns for speed.
How to use this guide
- Tier 1 — Hygiene (4 modules): read in order. Each module is the foundation for the next.
- Tier 2 — Fluency (9 modules): pick by the task type you do most. Modules are independent.
- Each module: concept, tax-flavoured worked example, applied exercise on your own engagement data, sources.
Modules
H1 · Prompting basics
Goal: write prompts that get useful answers on the first or second try, instead of vague responses that need three rewrites.
1.1 Why vague prompts fail
Copilot does not know what you are working on, what your client expects, or what "good" looks like for your output. If you don't tell it, it defaults to generic responses that look professional but lack substance.
1.2 The four-part prompt pattern
Most effective prompts contain four elements:
- Role — who Copilot should act as (e.g., "Act as a tax advisor reviewing a Lithuanian holding structure").
- Task — what specifically you want done ("draft", "summarize", "compare", "identify risks").
- Context — background needed: jurisdiction, transaction type, client industry, deadline, audience.
- Format — how the output should look: bullet list, table, memo section, email, length.
1.3 Worked example
Task: summarize a meeting recording for a tax review engagement.
"Summarize this meeting."
"Act as a tax consultant. Summarize this Teams meeting recording for a corporate income tax review engagement. Focus on: tax positions discussed, open follow-ups assigned to our team, client commitments with deadlines. Output as three bullet lists under those headings. Maximum 200 words."
1.4 Applied exercise — pick a real task
- Choose a real task from your current engagement (e.g., summarize a client email thread, draft a section of a memo, list issues from a meeting note).
- Write your prompt using all four elements.
- Run it in Copilot Chat (work mode).
- Note: did you need to iterate? What was missing?
- Share with one peer for feedback on the prompt itself, not the output.
1.5 Sources
- Microsoft Learn — Learn about Copilot prompts
- Microsoft Copilot Lab — prompt examples
- Microsoft Adoption — Copilot scenario library
H2 · Grounding Copilot in your work content
Goal: get Copilot to base its answers on your actual files, emails, and meetings — not on general knowledge or guesses.
2.1 What grounding means
By default, Copilot Chat answers from general knowledge. When you reference specific files, emails, meetings, or SharePoint sites, Copilot reads those sources and answers based on them. This is called grounding.
Grounded answers are more accurate and can cite where the information came from. Ungrounded answers are guesses dressed in confident language.
2.2 How to ground in M365 Copilot Chat
- Reference a file: type
/and select the file, paste a SharePoint/OneDrive link, or attach via the paperclip. - Reference a person: type
/and pick the person — Copilot can pull recent emails and chats with them. - Reference a meeting: type
/and select the meeting — Copilot uses the recording transcript and chat. - Reference a SharePoint site: paste the site URL — Copilot can search across documents in that site.
2.3 Worked example
Task: extract tax warranties from an SPA stored in SharePoint.
"What tax warranties are typically in an SPA for a Lithuanian target?"
"/[SPA_ProjectAlpha.docx] Extract every tax warranty and tax indemnity clause from this SPA. List each as: clause number, one-sentence summary, exposure type (CIT, VAT, WHT, transfer pricing, other). Output as a table."
2.4 Applied exercise — extract from a real engagement file
- Choose one real document from a current engagement: a memo, meeting note, contract excerpt, or report.
- Ask Copilot the same factual question two ways: first ungrounded (no file reference), then grounded (with /reference).
- Compare the answers. Note specifics, accuracy, and citations.
- Verify the grounded answer against the source document yourself.
2.5 Sources
- Microsoft Learn — Use Microsoft 365 Copilot Chat
- Microsoft Learn — Data, privacy, and security for Microsoft 365 Copilot
- Microsoft Copilot Lab — prompts by app
H3 · Failure modes — what goes wrong and how to catch it
Goal: recognize the specific ways Copilot fails on tax work, so you don't deliver wrong answers to clients.
3.1 The five failure modes that matter most
Authoritative sources: e-tar.lt (Lithuanian legal acts register), EUR-Lex (EU law), official VMI publications, OECD official documents, your firm's verified knowledge base.
3.3 Worked example
Task: ask Copilot for the WHT rate on dividends paid from Lithuania to a Polish parent.
A typical Copilot response will state a rate, may reference "the Lithuania-Poland tax treaty," and may even cite an article number. Some of this will be correct. Some may not be. Things to verify:
- Is the rate current? Treaties and domestic rules change.
- Did Copilot apply the participation exemption / parent-subsidiary directive correctly?
- Did Copilot account for substance requirements and beneficial ownership?
- Is the cited treaty article real, and does it say what Copilot claims?
3.4 Applied exercise — find a failure on purpose
- Ask Copilot a specific tax-technical question without grounding (e.g., a treaty article, a domestic rule citation, a deadline).
- Verify every factual claim in the answer against an authoritative source.
- Note: how many claims were correct, partial, or wrong? Were any hallucinated?
- Share the example anonymously in the team channel — failure examples are training material.
3.5 Sources
H4 · Output handling — from Copilot answer to client-ready
Goal: turn Copilot output into work product that meets your professional standard, with a clean audit trail.
4.1 The review pass
Treat every Copilot output as a junior draft. Three things to check before using it:
- Substance — is every factual claim correct? Verify citations, rates, dates, names.
- Completeness — did Copilot omit anything material? Compare against source.
- Tone and framing — does it match the audience (client, partner, internal)? Adjust hedging, formality, jargon.
4.2 Citation verification workflow
For any Copilot output containing a legal or factual citation:
- Locate the cited source in an authoritative repository (e-tar.lt, EUR-Lex, official VMI page, your firm's library).
- Confirm the article, paragraph, or ruling exists.
- Confirm it says what Copilot claims it says.
- Confirm it is current — no amendments or repeals since the date Copilot referenced.
- Replace Copilot's paraphrase with your own verified wording in the final output.
4.4 Worked example
Task: Copilot drafted a paragraph for a tax memo. Making it client-ready:
- Pass 1 — substance: every reference checked against e-tar.lt. One article number was wrong (Copilot cited Article 12; correct is Article 14). Corrected.
- Pass 2 — completeness: Copilot omitted the substance test under the participation exemption. Added.
- Pass 3 — tone: too tentative for a closing memo. Replaced "may potentially" with "is." Removed a generic disclaimer that didn't match firm style.
4.5 Applied exercise — produce a client-ready output
- Use Copilot to draft a real piece of engagement output: a memo paragraph, a client email, a section of a report.
- Run all three review passes. Track every change you made.
- Note: how much of the original Copilot draft survived?
- Discuss with a peer: was Copilot a useful starting point, or did manual rework outweigh the time saved?
4.6 Sources
- Microsoft Learn — Manage your Microsoft 365 Copilot Chat history
- Microsoft Purview — data security and compliance for Copilot
- e-tar.lt — Lithuanian legal acts register
F0 · Task-fit judgment (cross-cutting)
Goal: decide before starting whether AI will speed up this task — not after spending 20 minutes on prompts.
Where Copilot speeds up tax work
- First-draft prose where structure is conventional (memo sections, client letters, executive summaries).
- Summarising long inputs (meeting transcripts, document sets, email threads).
- Reformatting between formats (Word ↔ PPT, table ↔ prose, prose ↔ bullets).
- Information extraction from unstructured documents (warranties, dates, parties, defined terms).
- Drafting standard analysis (issue identification, comparable selection, rule articulation).
Where Copilot slows you down
- Tasks requiring authoritative legal citations end-to-end — verification overhead exceeds drafting time.
- Highly novel analysis with no convention to lean on — AI offers generic framings.
- Numerical work requiring precision — rounding, errors, fabricated figures.
- Highly client-specific tone — heavy rewriting needed.
- Tasks where you don't yet know what "good" looks like — AI accelerates the wrong direction.
- Is the structure conventional? If no, AI is unlikely to help.
- Are the inputs already in M365 (Word, SharePoint, Outlook, Teams)? If no, grounding is hard, output will be weak.
- Does the output need verified citations? If yes, budget verification time and decide whether net-time still wins.
- Estimated manual time vs estimated AI-assisted time? If AI is not at least 30% faster including verification, skip.
Applied exercise — weekly task review
- List all your tasks from one working week.
- For each, mark: AI used (yes/no), AI saved time (yes/no/unclear), would-use-AI-again (yes/no).
- Look for patterns: which task types consistently win, which consistently lose?
- Share patterns with the team — your data shapes which fluency modules others prioritize.
F1 · Memo and advisory drafting
Goal: produce a first-draft tax memo section in less time than typing it from scratch.
Prompt patterns that hit the standard fast
- Outline-first — ask Copilot to draft only an outline grounded in your engagement notes; then ask it to expand each section. Faster than asking for a full memo in one shot, and easier to redirect.
- Precedent-grounded — reference an existing memo from a similar engagement; ask Copilot to adapt structure and tone, replacing facts with the new client's. Preserves your firm's voice.
- Issue-list-to-prose — feed Copilot a bullet list of identified issues with your analysis; ask for memo paragraphs. Keeps your analysis intact and AI handles the prose mechanics.
"Write a tax memo on the planned restructuring."
"/[Engagement_Notes.docx] /[Memo_Template_2024.docx] Adapt the memo template using the engagement notes. Sections: Background, Issues, Analysis, Recommendation. Lithuanian CIT and PIT focus. Tone: advisory to a sophisticated GC. Cite article numbers as placeholders [Art X] — I will verify and replace."
Time-boxed exercise — re-do a memo you've already drafted
- Pick a memo or memo section you would normally draft in 60–90 minutes.
- Time-box the AI-assisted version: 30 minutes including verification.
- Log: baseline estimate, actual time, iteration count, citations needing replacement, % of AI draft surviving in final output.
- Verdict: repeat this approach / adjust / skip for this task type. Note what made it fast or slow.
F2 · Due diligence report sections
Goal: convert raw findings into structured DD report sections faster than manual write-up, without losing rigor.
Prompt patterns that hit the standard fast
- Findings-to-table — feed Copilot raw notes; ask for a findings table with columns: issue, exposure (qualitative + quantitative if known), recommendation, risk rating. Table format forces clean thinking.
- Standard-section-fill — reference your firm's DD template; ask Copilot to fill specified sections from data room extracts and your issue list.
- Data-room-summary — ground in a SharePoint folder of data room files; ask for a summary by document category (financial statements, contracts, tax filings, correspondence with authorities).
"Write the tax DD section."
"/[DataRoom_Tax_folder] /[DD_Report_Template.docx] Draft the Tax section of the DD report. Sub-sections: CIT, VAT, WHT, transfer pricing, payroll, historical positions. Per finding: one-paragraph description, qualitative exposure (low/medium/high), recommendation. Source-cite to data room file names. Output as Word using the firm's heading styles."
Time-boxed exercise — DD section side-by-side
- Pick one DD sub-section (e.g., VAT findings) you have already drafted manually on a real engagement.
- Re-do it using AI on the same source materials, time-boxed to half the original time.
- Compare both outputs side-by-side: completeness, accuracy, structure.
- Log: which findings were caught, missed, or invented by AI? What's the failure pattern?
F3 · Tax review documentation
Goal: produce review working papers and findings memos faster, while preserving audit trail and reviewer-defensibility.
Prompt patterns that hit the standard fast
- Procedure-checklist — ask Copilot to generate a review procedures checklist for a specified tax type and period; you adapt to engagement specifics. Faster than starting from a blank page.
- Anomaly-flagging — feed Copilot exported transaction data; ask for unusual items by criteria (round numbers, threshold patterns, related-party flags, period-end clustering). Treat output as suggestions, not conclusions.
- Working-paper-narrative — feed your bullet-point procedures and observations; ask Copilot to convert to formal working paper narrative. Keeps your judgment, AI handles prose.
"Help me write up the CIT review."
"/[CIT_Review_Notes.xlsx] /[Workpaper_Template.docx] Draft the CIT review working paper. Per area, document: procedures performed, observations, conclusions. Areas: revenue recognition, deductible expenses, related-party transactions, loss carry-forwards, R&D incentives. Tone: factual, non-advocate. Place [VERIFY] tags wherever a number or rule citation appears."
Time-boxed exercise — write up a real review section
- Pick a CIT or VAT review section you would normally write up in working papers.
- Time-box the AI-assisted version.
- Log: time saved, [VERIFY] tags reviewed, errors caught at verification.
- Verdict: which review areas suit AI write-up, which don't? Document the pattern.
F4 · Client letters and emails
Goal: produce client correspondence in the right tone and length, faster than typing from scratch.
Prompt patterns that hit the standard fast
- Draft-from-bullets — give Copilot 3–5 bullet points of what to convey; specify recipient, tone, length. Get a polished draft in seconds.
- Reply-with-context — /reference the email thread; ask Copilot to draft a reply that addresses specified points and maintains the tone established with this client.
- Tone-shift — paste your own draft; ask Copilot to make it more concise, more formal, or less hedged. Faster than self-editing in many cases.
"Write an email to the client about the deadline."
"Draft a short email to the CFO. Bullets to convey: VMI extension granted to 30 November; we will deliver draft return by 23 November for their review; one open item — confirmation of dividend payment date. Tone: matter-of-fact, no hedging. Max 120 words. No 'I hope this finds you well.'"
Time-boxed exercise — three real client emails
- Pick three real client emails you would normally write today.
- AI-draft each in under 5 minutes total; review and send.
- Log: time saved per email; how many sent without rewriting; client engagement (replies, action taken).
- Verdict: which email types suit AI drafting? Which need to stay manual?
F5 · Comparables and data analysis
Goal: faster handling of structured data — extraction, cleaning, comparison, summary tables.
Prompt patterns that hit the standard fast
- Extract-to-table — give Copilot unstructured input (PDF text, document set, transcript); specify columns; get a clean table.
- Compare-and-rank — feed Copilot a list of items (companies, structures, options); specify ranking criteria; get a comparison table with rationale per row.
- Excel-formula-build — describe the calculation logic in plain language; ask Copilot in Excel to write the formula or generate the column. Especially useful for SUMIFS, INDEX/MATCH, and lookups across sheets.
"Compare these companies."
"/[Comparables_List.xlsx] Evaluate each company against transfer pricing comparability criteria: independence (no shareholding >25%), industry (NACE 4-digit match to tested party), geography (EU), data availability (last 3 years). Output: original list + 4 columns marking each criterion (yes/no/insufficient data) + comment column. No additions to the list. Do not invent missing data — use 'insufficient data'."
Time-boxed exercise — real data task with full verification
- Pick a real data task: a comparables shortlist, a transaction sample for testing, a list of contracts to categorise.
- AI-assist the task; verify every output row against source.
- Log: time saved, error rate, type of errors (made-up data, miscategorisation, omission).
- Verdict: which data tasks pass the verification overhead test? Which don't?
F6 · Word → PPT transformation
Goal: turn an existing Word memo or report into a presentable slide deck without re-writing everything.
Prompt patterns that hit the standard fast
- Memo-to-deck — in PowerPoint Copilot: "create presentation from file" → reference the Word doc. Get a starting deck; restructure heavily.
- Section-to-slide — for each section of your memo, ask Copilot to produce one slide: title, 3 bullets, speaker note. Keeps slide count predictable.
- Outline-first — ask Copilot to propose a 6–8 slide outline from the Word doc; approve outline; then generate slides. Avoids 25-slide bloat.
"Make a presentation from this memo."
"Create a 7-slide deck from /[Restructuring_Memo.docx] for a client steering committee. Slides: 1 title, 1 executive summary, 3 issues (one per slide, each with a recommendation), 1 next steps with owner and date, 1 Q&A. Bullets only, max 4 per slide. Speaker notes required. Use the firm's PPT template if referenced."
Time-boxed exercise — Word memo to deck
- Take a Word memo or report you have already delivered.
- Generate a deck via Copilot; spend max 20 minutes adjusting.
- Compare to what you would have built manually.
- Log: time saved, restructuring needed, what AI got right and wrong about hierarchy and emphasis.
F7 · Table and data extraction from documents
Goal: pull structured data out of unstructured documents (contracts, emails, scanned text) faster than manual reading.
Prompt patterns that hit the standard fast
- Field-list-extraction — specify exactly which fields to extract; reference document; get table output. The narrower the field list, the more accurate the result.
- Multi-doc-aggregation — reference a folder; ask for one row per document with specified columns; get a consolidated extraction.
- Defined-terms-pull — ask Copilot to extract all defined terms from a contract with their definitions, page references, and where each is used in operative text.
"Get the key info from these contracts."
"/[Contracts_Folder] For each contract, extract: counterparty name, contract date, term, governing law, tax-related clauses (presence yes/no, clause numbers), termination notice period, change-of-control provision. Output: one row per contract, columns as listed. Mark missing fields as 'not specified' — do not infer or guess."
Time-boxed exercise — real document set extraction
- Pick a real document set (contracts, emails, financial statements, prior year filings).
- AI-extract a defined field list to a table.
- Verify a sample (e.g., 20%) against source documents.
- Log: extraction accuracy by field type, time vs manual, types of errors. Some fields will be reliable; others won't. Document the pattern.
F8 · Multi-document synthesis
Goal: synthesize across many sources (data room, prior memos, email threads) into one coherent output.
Prompt patterns that hit the standard fast
- Cross-reference-check — reference two or more documents; ask Copilot to identify inconsistencies, missing references, or unaddressed points.
- Timeline-build — reference a folder; ask for a chronological timeline of events with source citation per event. Useful for engagement history, dispute chronologies, restructuring sequences.
- Position-consolidation — reference prior memos and correspondence; ask Copilot to consolidate the firm's prior positions on a recurring issue with that client. Surfaces drift over time.
"Summarize all these documents."
"/[Engagement_Folder_2023] /[Engagement_Folder_2024] Build a chronological timeline of all tax positions taken for this client across both engagements. Per entry: date, position taken, supporting authority cited, document source (file name + section). Flag any contradictions or shifts between 2023 and 2024 positions."
Use multi-document synthesis when you would otherwise not do the synthesis at all (too expensive manually) — that's where it adds genuine value, even with verification overhead.
Time-boxed exercise — synthesis you've done manually before
- Pick a multi-source synthesis task you have done manually before (e.g., a position paper, a recurring client memo, a status summary).
- AI-assist; verify against sources.
- Log: completeness vs your manual version, missed points, fabricated points, time delta.
- Verdict: at what document count does AI synthesis become net-negative? Verification grows with scale; the break-even is the data point.
Sources
- Microsoft Learn — Reference multiple files in Copilot Chat
- Microsoft Adoption — multi-source scenarios