Run checks on a budget report before you send it with Copilot in Excel

← All use cases / Work

ToolMicrosoft Copilot

One user asked Copilot in Excel for a list of checks to run before sending a budget report. After the checks, a £4,000 duplicate invoice was zeroed out and the contractor total came to £52,400, matching the raw export.

Prompt to copy
Before I send this budget report, give me a checklist of the checks I should run on this workbook: duplicate entries, totals that don't match the raw data, missing or blank values, odd outliers and formula errors. For each check, tell me exactly where to look in this sheet and flag anything you find, but don't change any figures without asking me.

Replace the [PLACEHOLDERS] with your own details before you send it.

How to try it

  1. Open the workbook in Excel and keep the original raw export to hand.
  2. Ask Copilot the prompt and work through each check it lists.
  3. Fix anything it flags yourself, then reconcile the final totals against the raw export.

Why this works

Mistakes in reports usually come from duplicated rows, broken formulas or totals that drift from the raw data. A checklist of where to look makes the review systematic, and keeping the changes in your own hands means nothing is altered without you seeing it.

Tips for a better result

  • Keep a copy of the original file before making any fixes.
  • Ask for checks specific to your report, such as VAT or currency columns.
  • Reconcile the final total against the raw export yourself.
  • For more ways to work with spreadsheets, see our guide to learning Excel formulas with AI.

Common mistakes to avoid

  • Letting it change figures without you reviewing them.
  • Assuming no flags means the report is perfect.
  • Sharing sensitive financial data outside approved work tools.

Try a variation

Here’s a variation of our own (not from the original source) to try next:

I've got this [MONTHLY REPORT] in Excel. Build me a reusable 'pre-send' checklist sheet with each check, where to look, a formula I could use to spot problems, and a column to tick it off. Don't change any existing data.

If this was useful, our AI for work and business hub has lots more in the same vein.

More work use cases

Rebuild an awkward inherited spreadsheet report with Copilot in Excel

Someone who inherited a report built on pivot tables, which was a pain to update because the pivots could move when refreshed, asked Copilot in Excel to redo it. Even with a rough, loosely worded request, Copilot worked out how to read the pivots and rebuilt the report on a separate tab, which they said came out flawlessly.

Full guide →
Source: X @Bouje99

Catch up on work after a holiday with Copilot

A project manager working across Japan and the US used to lose a whole day catching up after holidays. Now he uses Copilot to sort email subjects by urgency, draft holding replies, summarise the decisions made while he was away and turn meeting transcripts into action lists, telling it to use only the information he provides.

Full guide →

Turn long work papers into an audio overview with Copilot

Faced with a pile of board papers, one user put them into a Copilot Notebook and created an audio overview to listen to while driving home, joking that it made them sound much more interesting than they really are.

Reference: X @Cliffinkent