Microsoft 365 Copilot for accountants: 12 prompts AU finance teams should standardise in 2026

Finance teams are the highest-yield department for Microsoft 365 Copilot adoption in Australian mid-market. The reasons are practical: finance work is heavily Word + Excel + Outlook, has repeating monthly workflows that benefit from prompt standardisation, and has the kind of writing tasks (variance commentary, board notes, audit responses) where Copilot's draft-then-edit pattern is materially faster than from scratch. The twelve prompts below are the ones Frontrow has seen work consistently across AU CFOs, FP&A teams and external accountants.

The Frontrow finance prompt library — 12 prompts

Excel — month-end reconciliation and variance

1. 1"Summarise the variances in this trial balance against the prior month, surfacing any movement greater than 5% with a one-line plain-English explanation." Used at month-end close to triage variance investigation.
2. 2"Identify any rows in this AR ageing report where the customer balance has moved into 60+ day bucket since last month, with the customer name, amount and last invoice date." The receivables triage prompt.
3. 3"Look at this BAS workings sheet and flag any GST treatment that looks unusual — particularly export sales without ABN, intra-group invoices without GST, or capital purchases not separated from operational." BAS prep sanity check.

Word — board pack and commentary

1. 1"Draft the CFO commentary for the monthly board pack based on the attached P&L, with specific attention to revenue against forecast, gross margin movement, and any one-off items. Tone: factual, concise, no superlatives. Australian English." The monthly board commentary draft.
2. 2"Rewrite this audit committee paper to focus on the three key control improvements made this quarter, the residual risks, and the proposed plan for the next quarter. Maximum 1.5 pages." Audit committee paper sharpening.
3. 3"Summarise the attached External Audit findings letter into a one-page management response: each finding, the agreed action, the responsible owner, and the target date." External audit response.

Outlook — finance email

1. 1"Draft a polite but firm 30-day overdue invoice email to a long-standing customer, referencing the original invoice date and amount, offering a phone call to discuss any disputed items, and noting the standard 7-day pay-or-call expectation." Receivables follow-up.
2. 2"Summarise the last 20 emails in this thread with the auditor into a brief running log: outstanding requests, our responses, dates. I need to see what's still open." Audit correspondence thread summary.

Teams + Loop — finance meetings

1. 1"Summarise the action items, owners and target dates from the meeting recording attached." Post-meeting action capture.
2. 2"Build a Loop component with columns for vendor, contract value, contract end date, renewal owner, and renewal status. Pre-populate the rows from this list." Contract renewal tracker.

PowerPoint — finance presentations

1. 1"Create a five-slide deck from this management report. Slide 1: top-line summary. Slide 2: revenue performance. Slide 3: margin movement. Slide 4: cash position. Slide 5: outlook. Use the corporate template." Monthly results deck.
2. 2"Restructure this technical accounting memo into a presentation for the audit committee. Each major argument as one slide. Add a final slide of recommendations." Technical memo to presentation.

How AU finance teams should roll these out

1. 1Save the 12 prompts in a Loop page accessible to the whole finance team.
2. 2Run a 30-minute training with the team — one prompt at a time, with the team's actual data.
3. 3Assign two champions (typically the management accountant and the FP&A lead). They become the first stop for prompt questions.
4. 4Review what's working after 4 weeks. Refine the library. Add 2-3 prompts that emerge from the team's own work. Remove any that aren't earning their place.

Where Copilot still doesn't fit

Copilot is a draft-first tool. It is not a verified calculator. Treat Copilot output the way you treat a graduate accountant's first draft: useful starting point, requires senior review before it goes anywhere external. The two finance scenarios where this matters most: anything with regulatory submission implications (BAS, ASIC, APRA) and anything material to the financial statements. Copilot's hallucination rate is low but not zero. Review every number.