Explain P&L Variances in the Accountant's Workbook with Copilot in Excel

What This Does

Your accountant or bookkeeper sends a monthly workbook with actual numbers next to budget or last year. Copilot in Excel can read the workbook, point to the lines that moved most and explain them in plain words, so you walk into the conversation with the right questions. It explains what the numbers show. It cannot tell you why a cost rose, because that lives in your kitchen and your invoices.

Before You Start

• Copilot in Excel needs a Microsoft 365 Copilot license, which you may not have. Microsoft says that if you do not see Copilot in Excel, it might not be included with your subscription or might be turned off by your organization. Look for the Copilot icon in the lower-right corner of Excel. If it is not there, check Microsoft's pricing and licensing pages for current options, or ask your IT contact or Microsoft account representative. If you do not have it, the same questions work in a chatbot with rounded numbers pasted in
• You have the workbook open from your accountant, with actual and budget (or prior period) columns
• This is real financial data. Save a copy first, and check that no payroll detail by named employee, account numbers or the EIN sit in the sheets you share with Copilot. Delete those tabs from your copy if they do

Steps

1. Open Copilot

In Excel, select the Copilot icon in the lower-right corner. Microsoft says Copilot in Excel opens in edit mode by default, which lets it change your workbook. Because this is the accountant's file, switch to chat mode, which Microsoft describes as keeping responses inside the chat without changing the workbook, or work in your saved copy.

2. Ask what moved

Type: "Compare actual to budget for each line on the P&L sheet. List the five lines with the largest differences in plain words, and say whether each is over or under budget."

3. Ask for the plain explanation

Type: "Explain what these differences could mean for a full-service restaurant, in two sentences each. Then list three questions I should ask my accountant." Treat the explanations as possibilities to check, not facts. Copilot only sees the numbers.

4. Ask for a chart if it helps

Type: "Make a simple chart of the five biggest differences." Microsoft says Copilot can create charts and PivotTables with editable links to the source data.

5. Verify two variances by hand

Pick two lines from the list, ideally the largest one and one small one. Find actual and budget on the sheet, subtract budget from actual yourself on your phone calculator, and compare it with Copilot's figure. Also check which direction is good: for a cost line, over budget is bad, and for a sales line, over budget is good. If either variance is off, ask Copilot which cells it used, and fix the prompt.

Real Example

Scenario: The October workbook arrives and you have ten minutes before a call with your accountant. These are invented round numbers in plain units.

What you type: The prompts in steps 2 and 3.

What you get: A list that includes food and beverage cost, budget 30,000, actual 33,000, which is 3,000 over budget, and labor, budget 28,000, actual 27,500, which is 500 under budget. You check both by hand (33,000 minus 30,000 is 3,000, and 27,500 minus 28,000 is negative 500) and they match. Your questions for the call: was the food cost jump a price change from a supplier, waste or a data entry timing issue, and is the labor saving real or just a late payroll posting?

Tips

• Ask Copilot to show which cells or formulas it used if a figure surprises you.
• Keep your own notes on what each big variance turned out to be. Next month's comparison is more useful that way.
• Benchmarks vary by concept and city. Compare against your own history and your accountant's view.

Tool interfaces change. If a button has moved, look for similar AI/magic/smart options in the same menu area.