N+P Group, an international waste-to-resource business with over 500 employees and 45 legal entities in the United Kingdom and the Netherlands, went from 7 to 50 Exsion licences in four years and now runs management reporting, two monthly management consolidations, a shareholder consolidation, weekly group cash flow and bank reconciliation checks from Business Central in Excel, without downloading a single report. Group Financial Controller Chris Hoyle explains how the finance team got there, from the first six months of manual compiling to a team where everyone from the management team to the site administrators presses refresh.
Chris Hoyle is Group Financial Controller at N+P Group, an international business specialised in repurposing waste into sustainable resources. The company operates across three core activities: trading waste streams, sorting recyclable materials into high-value commodity streams and processing non-recyclable waste into alternative fuels. With over 500 employees, 45 legal entities and operations in the United Kingdom and the Netherlands, the reporting demands are substantial.
[[TABLE_START]]
Metric | Before | After
Exsion licences | 7 | 50, four years later
Group cash flow view across 40 to 50 entities | Once, maybe once a month | Every week
Downloading reports from 45 to 50 legal entities | Manual, per entity | None, one refresh and the data flows through
Ad hoc data requests from the business | Big projects to build reports | 10 to 20 queries a month answered by key users, no project
Time for a new team member to work independently | Not measured | A couple of sessions over a couple of days
First six months after a Business Central go-live without Exsion | Downloading and compiling reports all the time | Not repeated: Exsion from day one
[[TABLE_END]]
N+P operates multiple business units with dozens of legal entities. Each entity has its own bank accounts, its own transactions and its own reporting requirements. For a finance team, that means pulling data from dozens of sources, consolidating it and producing reports. Manually.
Chris: "We've built our whole control environment on our ERP system and use Exsion to access the data within it quickly and readily. That allows us to build reporting across all our different types of processes, whether it's management reporting, cash flow reporting or our audit cycle."
In Business Central terms, each of those 45 entities is a separate company with its own G/L Entry (table 17) and Bank Account Ledger Entry (table 271). Exsion Reporting lets the team tick the companies in one query grid and get one table back with a company column, which is what makes group-level reporting possible without an export per entity.
N+P runs two monthly management consolidations and a shareholder consolidation. Data flows directly from Business Central into Excel, where the team has built standardised reports from individual legal entity level all the way up to full group consolidation.
Chris: "As we go through month end, we can refresh these reports to monitor how month end is going, identify potential issues and then report on a business unit and group level."
That in-flight monitoring is the practical difference between a live connection and an export. A refresh of 700,000 G/L Entry rows takes under five seconds, so the group controller can check the close every morning of month end rather than once it is finished. For groups that need intercompany eliminations and currency translation on top, Exsion Corporate adds that layer; our guide on how to consolidate multiple companies in Business Central using Excel walks through the steps.
N+P's trading division is a distinctive operation. Tonnage data from the operational software flows into Business Central, which means the finance team can combine operational and financial data in the same report through Exsion.
Chris: "We have reports structured by customer and supplier, and we can understand revenue, cost of sales and the margin on each contract. We budget under the same structure, so during month end we can compare to budget very easily and see where the differences are."
Consolidating cash positions across 40 to 50 legal entities, each with their own bank accounts, would be an enormously time-consuming exercise without direct data access. With Exsion, the team does it weekly.
Chris: "Without Exsion, we'd be looking at cash flow once, maybe once a month. In this kind of environment, that's not fast enough. Exsion allows us to do it each week."
The team uses its cash flow reports at multiple levels: for day-to-day cash management, but also to report group liquidity positions to the management team.
Chris: "The beauty of Exsion is having all the data in one place. That allows us to build reports at different levels of the business, whether that's legal entity, business unit or the group."
Business Central now offers AI functionality for bank reconciliation. Copilot helps auto-match bank transactions to general ledger entries and makes suggestions where standard rules fall short; Microsoft describes the process in its guide to reconciling bank accounts in Business Central. But auto-matching is not the same as provably correct. That is where Exsion comes in: for GL checks, exception lists and reconciliation reports in Excel.
At N+P, the team currently uses Exsion to download transactional data and perform bank reconciliations directly in Excel. A project is underway to move the full reconciliation process into Business Central, including AI matching for payment runs. Once that is live, the role of Exsion shifts: from building the reconciliation to verifying and reviewing it.
Chris: "The intention is that the management accountants become more of a reviewer rather than a manual doer. We'll use Exsion to build reports off the back of the reconciliation in BC."
That is the direction: AI handles the matching inside Business Central, Exsion provides the reporting layer that lets controllers check, filter and prove that everything adds up.
At N+P, the entire finance team works with Exsion Reporting, from the management team right down to the administration teams at individual sites. That is no accident.
Chris: "We don't have to spend any time downloading reports from our 45, 50 legal entities. We just press refresh and the data flows through. That saves us a lot of time. And that for me is the major benefit."
Because Exsion inherits Business Central user permissions, a site administrator who can see one company in Business Central sees that one company in Excel, and the group controller sees all 45. There is no second security model to maintain as licences grew from 7 to 50.
New team members get access to Exsion from their first day. The team operates a buddy system: an experienced user is paired with the new colleague. Within a few days, people are working independently.
Chris: "The software was already preloaded onto my system. From day one I had access and was able to use it. It's super simple. You're in an environment that everybody already understands because you're just in Excel. Within a couple of sessions, over a couple of days, new people are very quickly up to speed."
When a new report is needed, the team turns to one of its experienced key users. No project plan required, no IT involvement, no weeks of waiting.
Chris: "We get probably 10 to 20 ad hoc queries every month from all parts of the business. If the data is there, we can get it. We don't do big projects to build reports anymore."
N+P is also rolling out team-wide training with Exsion365, to enable the broader team to build their own reports independently.
Chris has worked at organisations where Exsion was not available. He has even implemented Business Central for a business without adding Exsion, and calls that a big mistake in hindsight.
Chris: "We spent the first six months after implementing 365 essentially downloading reports all the time and compiling them. I'd 100% recommend it. If you're struggling with working in silos, or you're spending a lot of time downloading multiple reports into Excel, compiling them, reformatting them, then fundamentally this will save you hours every week across your team."
Starting is deliberately low-risk: the add-in installs from AppSource in about five minutes, the 30-day trial covers the full product and pricing is public, so a group with 45 entities can test a multi-company refresh before committing to a single licence.
[[FAQ_START]]
How many entities does N+P Group report on with Exsion? | 45 legal entities across the United Kingdom and the Netherlands, with reports built from individual entity level up to full group consolidation.
How often does N+P Group consolidate cash flow? | Weekly. Without direct data access the team would look at cash across its 40 to 50 entities once, maybe once a month; with Exsion it does so every week.
How does N+P Group use Exsion alongside Copilot bank reconciliation in Business Central? | Copilot auto-matches bank transactions inside Business Central, and Exsion is used to check, filter and verify the reconciliation in Excel, so management accountants become reviewers rather than manual doers.
How quickly do new finance staff at N+P Group become productive with Exsion? | New team members get access on day one and are paired with an experienced user. Within a couple of sessions over a couple of days they work independently.
[[FAQ_END]]