A "10 out of 10" Win: How I Sliced 20% Off a Department's Month-End Process Using Copilot Cowork

Month-end closing is notoriously the most stressful time of the month in finance. But instead of just survival, I’ve been focusing on transformation.

By applying what we are learning here, I just optimized an entire department's service invoicing process by ca. 20% using a simple, intelligent report—and I have the receipts to prove it.

The Manual Nightmare (Before)

Every month, our service department needs to ensure we have the correct billable amounts ready for customer invoicing. The old process was a classic case of corporate friction:

The service team pulled raw, unstructured hour logs from our system.
Each Project Manager (PM) had to manually comb through this massive text file.
They then had to open a separate, master Excel sheet called "Signed", manually input the hours for their specific projects, and calculate the totals based on hourly or daily rates.
Only after this grueling process was finished could I step in to actually generate and send the invoices.

Step 1: The Bottom-Up Approach (Change Management)

Instead of trying to push a top-down solution, I went straight to the operational frontline. I sat down with a single PM to map out the workflow and identify the lowest-hanging fruit.

We realized that simply transforming the raw data dump into a clean, intuitive overview report would save them massive amounts of time. I built a prototype, tested it with that exact PM to make sure it met their real-world needs, and then booked a meeting with the department manager.

Step 2: The "Concierge MVP" Strategy

When I met with the manager to show her the first draft, she loved it. Her deep experience allowed her to provide invaluable feedback to refine the report even further.

To get this live immediately without waiting for complex integrations, we deployed what is known as a "Concierge MVP" via Microsoft Copilot Cowork:

The Current Workflow: Right now, the manager simply emails the raw data export directly to me.
The AI Skill: I run it through my custom Copilot Cowork skill, which instantly structures the data, cleans it up, and generates the overview report.
The Delivery: I send the clean report back to her team.

This allows us to prove the massive ROI right now while I maintain, monitor, and fine-tune the skill behind the scenes.

The Proof: A "10 out of 10" Rating 🌟

We rolled out the new process for the May month-end closing, and the feedback has been incredible. The department manager:

"Durhuus, Allan, we have evaluated the month-end closing process in connection with the new report you fixed as a supporting tool for controlling and updating the hours in 'Signed' 🫡 Overall score must be a 10—everyone in the team agrees that it gives a much better overview. A conservative estimate on the efficiency/optimization of our working time is probably around 20%. It is faster to get an overview of which projects are relevant to look at, and thereby we can update 'actuals' faster in the given month."

What’s Next?

This is only Phase 1. Now that the logic is proven and the team loves it, Phase 2 will involve automating the update to the "Signed" Excel sheet directly.

This will completely shift their role from manual data-entry operators to strategic controllers. They won't spend days building the report; they will spend minutes auditing a finished product.

Every small win like this proves that you don't need a massive IT project to drive serious efficiency in a global firm. You just need the right mindset, a bit of curiosity, and the tools we are building here.

One step closer to that AI Finance Manager title!

6 comments

A "10 out of 10" Win: How I Sliced 20% Off a Department's Month-End Process Using Copilot Cowork