Episode Details

Ever feel like your month-end close is stuck in quicksand, trapping your finance team in endless journal validations and email ping-pong? What if you could automate approvals, streamline postings, and get real-time notifications—all in one seamless workflow using tools you already have?Today, I’ll show you, step by step, how to connect Power Automate, Dynamics 365 Finance, and Teams for a month-end close that’s smarter, faster, and nearly hands-off.Why Manual Month-End Close Holds Teams BackIf you’ve ever spent the last week of the month glued to spreadsheets and Outlook, you’re not alone. A typical close in a mid-sized finance team still looks like this: someone starts a workbook, maybe color-codes cells for each account owner, and then—almost instantly—teams start chasing missing lines, misplaced journal numbers, and yet another copy of the policy checklist. Updates trickle in through email chains. There’s at least one person pasting journal entries from a subsidiary file, hoping nothing gets overwritten. Approvals start as a set of requests but quickly turn into a ping-pong match, bouncing from folder to folder. Even with cloud solutions, almost everyone falls back to spreadsheets because it feels safer, or at least, more familiar than chasing workflows across three different apps.Pressures build from the first day and keep mounting up to deadline. The controller is tracking a growing tally of incomplete sign-offs late into the evening. No matter how many times you’ve standardized your templates or tried to centralize the signoff process, old habits never seem to die. That final Friday, you still see reminder emails with phrases like “Just checking if you saw this...” or “Quick nudge for your approval.” The process drags as the team waits for all the pieces to fall into place.Let’s look at what actually happens when steps still hang on manual work. Even if you’ve invested in Microsoft 365, like a lot of organizations have, much of the muscle memory is built around workarounds. Finance teams open Dynamics 365 Finance for reporting, but the heavy lifting—cross-checking, documenting, deciding who approves what—all plays out in Outlook and Excel. That brings us right back to classic bottlenecks: the spreadsheet isn’t locked down, so someone might change a figure without a digital trace. Deadlines create a sense of urgency, but when the process is manual, urgency just raises stress and doesn’t solve the real issues.Ask any controller about their worst-close story and you’ll probably get some version of this: one month, you’re close to wrapping things up, but you’re missing one crucial approval. You send three reminders, copy the manager, escalate to a director—only to learn that the original approver put on an out-of-office reply two days earlier and is relaxing on a beach somewhere. The domino effect stops the entire close process. No one else in the approval chain can move forward, and the close date slips. Nobody enjoys explaining that sort of delay to leadership or auditors.This isn’t just an anecdote. Industry data puts the typical month-end close at anywhere from six to ten days for mid-market companies, and as long as two weeks for more complex organizations. The longer the close takes, the higher the risk of spotting errors too late to correct them. Late entries or forgotten journals sometimes surface during audits, not during the close. Studies show that nearly 70% of finance teams have had at least one material error crop up during audit season thanks to missed or rushed approvals during month-end. Each manual handoff is a chance for human error, and those mistakes can turn into write-ups in the audit trail—at best—or heavy risk exposure, at worst.What’s interesting is that most organizations have access to Microsoft 365 and Dynamics 365, and plenty are tinkering with Power Automate, even if it’s just for simple notifications. Yet when it comes to automating finance processes, especially month-end, old patterns persist