A Month-End Checklist That Updates Itself with Copilot Pages

Every month-end has a checklist, and every checklist is out of date by Tuesday. Someone asks "did the owner report go out?", someone else checks three folders, and the spreadsheet with the ticks in it still says "in progress" for something that finished last week.

In this guide we use Copilot Pages to build a month-end checklist where Copilot works out the status of each task from the files themselves, quotes the evidence, and keeps the page current when you tell it what changed. It's a shared page the whole team can open and edit, and Copilot can update it alongside you.

Here's the whole thing, sped up:

What you'll need

• A Microsoft 365 Copilot licence, with Copilot Chat at m365.cloud.microsoft (Work mode).

• Your month-end files in SharePoint or OneDrive. Ours are the outputs of earlier posts: the variance report, the owner report and deck, the vendor scorecard and the tenant notice.

Step 1: Ask Copilot to check the work

In Copilot Chat, list the tasks and tell Copilot where to look and how to decide:

Build our September 2026 month-end checklist for the three properties (Harbourfront Office Tower, Northgate Distribution Centre, Lakeview Medical Plaza) as a table with columns: Task, Owner, Status (Done, In progress, Not started, Blocked), Evidence. Tasks: run the budget variance report; draft the owner report; build the owner deck; clear invoices waiting for approval; decide capital treatment of the elevator modernization billing; review vendor performance; send the tenant notice for the Car 2 elevator shutdown; schedule the Northgate condition inspection. Work out each status from our files in the Site Inspections SharePoint site and quote the file or figure as evidence. If you can't find evidence, say Not started. Use Owner: Property Manager for everything.

The key sentence is the last rule: no evidence, no tick. That stops Copilot from marking things done just because they sound done.

Step 2: Read the verdict

Copilot opened the files, reasoned in nine steps and came back with 4 Done, 2 In progress, 1 Blocked and 1 Not started. Every row quoted a file and a figure: the $37,764.92 actual against $29,400 budget from the variance report, scores of 33 and 36 for ClearAir and Metro Lift from the vendor scorecard, and $8,780 of invoices still waiting for approval.

The best part was how careful it was about "done". It found the tenant notice, read it, and still marked the task In progress: "I found the notice, but no evidence that it was distributed to tenants." That's exactly right. Writing a notice is not the same as sending it.

Step 3: Turn it into a page

Under the answer, select the three dots, then Edit in Pages. The table becomes a Copilot Page: a shared, editable document with Copilot alongside it. Then ask for changes in plain English:

Update the page: add a Due column (Oct 7 for invoices and the elevator decision, Oct 9 for the tenant notice and the Northgate inspection, and Done items show the date finished as Oct 5), put the month-end position summary at the top as a short status line, and add a 'Next actions' section underneath with one line per open item.

Step 4: Tell it what changed

To show how the page stays current, we told Copilot that one of the held invoices had been approved. Instead of editing cells, you just say so:

Update from today: PR-1188 was approved by the controller and posted; CA-30417 is still waiting for the PO change. Update the page to reflect this, and shorten every Evidence cell to one sentence so the table is easier to read.

Copilot moved the invoice task from Blocked to In progress, updated the summary line to 4 Done, 3 In progress, 1 Not started, and rewrote the Next actions so only the four open items remain:

Where it slipped

When we asked for the due dates and the Next actions section, the chat said "Sorry, something went wrong." The page had been updated anyway: the Due column, the status line and the Next actions were all there. So if Copilot reports an error, look at the page before you try again, or you may end up with everything twice.

A quick game: done or not done?

Copilot marked these as In progress, not Done. Would you?

• The tenant notice is written and saved in SharePoint.

• The elevator report says the modernization is capital work.

• One of two held invoices has been approved.

Ours: all three are In progress. A notice nobody received, a recommendation nobody approved, and half the invoices. If your team would have ticked them, your checklist has been too generous.

Lessons from the build

• Rule out ticks without evidence. One sentence in the prompt makes the whole checklist trustworthy.

• Let people talk, not type. "PR-1188 was approved" is faster than finding the right cell, and Copilot updates everything that depends on it.

• Keep the page, not the chat. The chat scrolls away. The page is the thing you share with the controller.

• Point it at the folders, not the people. The checklist is only as current as your files, which is a good reason to keep them in one place.

Ideas to take it further

• Start every month from the same prompt: change the month and the task list, and Copilot rebuilds the checklist from scratch.

• Share the page with finance: the controller sees the same status you do, without a status meeting.

• Add the agents: the variance agent, the billing agent and the SharePoint agent all produce files Copilot can check.

• Close the loop: when the page says 8 Done, ask Copilot to draft the month-end close email to the owner.

Why this matters

A checklist is only useful if it's true. When the evidence for each task lives in a different folder, keeping it true is a part-time job. Bring your data from different systems into one place and put AI in front of it, and the checklist checks itself: Copilot reads the files, quotes the evidence and tells you what's actually left.

Need help?

Smart Solutions sets up Microsoft 365 Copilot, SharePoint and month-end automation for Canadian property and facilities teams. If you'd rather have purchase orders, invoices and approvals in one product, take a look at ProcuraCloud, our procurement platform for small and mid-sized businesses. Contact us to talk about your month-end.