The Plandisc blog

How local government planning managers track compliance deadlines without spreadsheet gridlock

Written by Nicklas Strunk Nielsen | Jul 27, 2026 7:54:24 AM

TL;DR: A shared spreadsheet records compliance deadlines. It does not show you which ones are two weeks away, who owns them, or what upstream data is still missing. A visual compliance calendar on a year wheel does all three, across every directorate, without a Friday afternoon reconciliation call.

Compliance deadlines in a municipality arrive from every direction at once. The finance directorate is closing the annual accounts. HR is waiting on legal sign-off before publishing the updated policy. The environment team has a permit renewal window that opened quietly in the middle of budget season. Each deadline has a different owner, a different recurrence pattern, and a different consequence for lateness.

Most planning teams respond by adding more columns to the spreadsheet. The real problem sits one level up. When no one can see all the deadlines together, in context, alongside who owns them and what still needs to happen first, the coordination work falls on a single coordinator to hold in their head. That is not a process. That is a person.

This post compares two approaches: tracking compliance on a shared spreadsheet versus a visual circular planning tool. It is written for planning managers and coordinators in local government who are responsible for keeping directorates on schedule and preparing evidence for audit windows and council reporting cycles.

What a visual compliance calendar actually does that spreadsheets cannot

A visual circular planning tool gives municipalities a shared, always-visible compliance timeline that static spreadsheets cannot update across directorates in real time. That single difference changes what a coordinator can do on a Tuesday morning without calling anyone.

On a year wheel, every compliance deadline sits on the calendar arc where it actually falls. You see March's audit submission next to February's data collection window next to the council reporting deadline in April. The proximity is visible. The sequence is visible. When the finance team sees that procurement has not yet submitted figures that feed the annual accounts, they do not need a separate meeting to surface that dependency. The wheel already shows the gap.

Spreadsheets fail differently. They do not fail loudly. A deadline two weeks out looks identical to one six months away unless someone has built conditional formatting into the file, and conditional formatting breaks the moment another user edits a cell. Version drift is the more common failure: five departments saving their own copy of the compliance tracker, each current as of a different date, none of them wrong per se, but no single one reflecting what is actually true right now.

The turnover problem spreadsheets cannot solve

Municipal coordinators rotate. When the person who built the compliance tracker leaves, the institutional knowledge embedded in that file leaves with them. Which rows are hard deadlines versus soft targets? What does the lead time in column F actually account for? What changed in the recurrence pattern after last year's regulatory update?

A structured year wheel carries that knowledge in the tool itself. Ownership, recurrence logic, and lead times are configured into the plan, not stored in one person's memory. A new coordinator can read the wheel without a two-hour handover call.

Spreadsheet vs. visual compliance calendar: side-by-side

Factor Shared spreadsheet Visual year wheel (Plandisc)
Cross-directorate visibility Each team sees its own file All directorates on one shared view
Deadline proximity Rows show dates, not urgency Circular layout surfaces what is coming soon
Ownership and reminders Name recorded, no enforcement Owner assigned with notification logic
Recurrence management Manual copy-paste each year Recurring deadlines roll forward automatically
Audit trail Snapshot only; no change history Timestamped updates create a reviewable record
Council reporting Requires manual summary build Wheel exports directly for presentation
M365 integration Stored in SharePoint, not connected Native Microsoft 365 integration
EU data residency Dependent on SharePoint configuration Covered by Plandisc's EU data residency commitments

When to use each option

When a spreadsheet is enough: You are a single coordinator managing fewer than a dozen compliance deadlines, all sitting within one directorate, with no upstream dependencies on other teams. The file lives in one place, one person maintains it, and the deadlines recur on a predictable annual schedule. In that narrow context, the overhead of a dedicated planning tool may outweigh the benefit.

When a visual compliance calendar becomes the better answer: Your deadlines span more than two directorates. Staff have rotated and the original tracker has not been fully updated. You have had at least one near-miss on a submission because a dependency was not visible in time. Council or auditors have asked how compliance is being tracked, and the answer was "we have a spreadsheet" — followed by a pause.

Most municipalities operating across finance, HR, environment, legal, and procurement are already past the threshold where a spreadsheet reliably works. The Status Quo is not a neutral default. Every year spent manually reconciling trackers across directorates is a year of coordination overhead that compounds when someone leaves or when a new reporting mandate arrives.

What to look for when choosing a compliance calendar tool

Does it show the full year in one view? Compliance work is annual by nature. A tool that shows one month at a time forces the same proximity blindness as a sorted spreadsheet. A year wheel layout gives you the whole cycle at once.

Can multiple directorates work in the same plan? The compliance failures that matter most are cross-directorate. If the tool segments by team rather than showing the whole organisation, you have replicated the spreadsheet problem in a different interface.

Does it integrate with your existing Microsoft 365 environment? Most Nordic municipalities are already on M365. A planning tool that connects to that environment, rather than sitting alongside it as a separate system, reduces the adoption barrier and keeps data in an environment your IT and GDPR teams have already assessed.

Does it support audit readiness? When auditors request evidence of how compliance deadlines were tracked, a tool that records updates with timestamps gives you a reviewable history. A spreadsheet gives you the current state of the file, which is not the same thing. The European Court of Auditors consistently flags documentation gaps and inadequate audit trails as recurring findings across public bodies — a compliance calendar that builds that trail automatically is easier to defend than one you reconstruct after the fact.

What happens to the data after procurement? If you procure through public tender and the vendor cannot answer questions about EU data residency and GDPR compliance in plain language, that is a gap worth closing before signing.

Plandisc recommendation

Plandisc is built as a year wheel, not adapted into one. Every compliance deadline you add sits on the circular annual arc, with an owner, a recurrence rule, and visibility to whoever needs it. Directorates work in the same shared plan rather than in parallel files. When a council member asks how the environmental permit renewal is tracking, you open the wheel, not a folder of spreadsheets.

The M365 integration means Plandisc connects to the environment your teams are already in. Nordic municipalities are among the most advanced in Europe on digital public administration, and the gap between that ambition and a manually updated compliance tracker is worth closing.

If your municipality procures software through formal tender, Plandisc supports that process. EU data residency, GDPR documentation, and security requirements are covered.

Book a Plandisc demo to see how the year wheel maps your compliance calendar and what it would take to move your current deadlines into a shared, always-visible plan.

Frequently asked questions

Does Plandisc replace our existing project management tools, or does it sit alongside them? Plandisc functions as your annual planning and compliance calendar. Most municipalities use it alongside task management tools like Planner or project-specific trackers. The year wheel gives you the overview layer; other tools handle the task detail underneath specific deadlines.

How long does it take to migrate an existing compliance spreadsheet into Plandisc? Most planning teams can import their core compliance deadlines and assign ownership within a few hours of initial setup. Plandisc's onboarding support covers this as part of getting started, and the circular layout makes it straightforward to see where recurrence rules need adjusting.

Can multiple directorates work in the same Plandisc wheel at the same time? Yes. The year wheel supports multiple layers by directorate, department, or theme. Each team sees its own deadlines in context with the whole organisation's calendar, which is the core visibility benefit over siloed spreadsheets.

What happens if a coordinator leaves and a new one takes over? The plan stays in the tool. Ownership, deadlines, recurrence logic, and any notes are visible to whoever has access, with no handover spreadsheet required. That is one of the clearest differences from a spreadsheet that lives in someone's personal OneDrive folder.