Service · Software development

Custom management reporting system development.

A custom management reporting system brings figures, commentary and context together in a single periodic report. For CFOs and controllers who need to put together monthly, quarterly and annual reports from ERP, CRM and standalone sources, with an audit trail, sign-off and branded distribution to your stakeholders.

MRS

A management reporting system is not a dashboard.

A custom KPI dashboard shows in real time where things stand right now. A management reporting system (MRS) does something different: it periodically builds a fixed report document from the same underlying sources, with figures, charts and written commentary for each block. Once a month, quarter or year, that report goes through a review flow to the board, clients or investors. The result is not a screen a controller consults, but a document a controller compiles, adds commentary to and formally sends out.

Since 2015, we have been developing custom reporting software for finance teams, consultancies and accounting firms. Not a standard Power BI rebuild, but a platform that fits the specific combination of source systems, industry format and review process that your organisation currently handles manually in Excel. For many CFOs and controllers, the pain is not "we have no dashboard" but "every month, putting together the management pack takes three days, and with every iteration an error creeps into a formula".

A management reporting system solves this by separating source data, report template and commentary layer. The data comes in automatically via ETL. The template is set up once and stays stable afterwards. The finance team writes the commentary in the tool itself, linked to the figure block it relates to. With every new period, the system generates a fresh report, with comparable versions, an intact audit trail and automated distribution.

What an MRS project typically delivers.

One source
ETL from ERP, CRM, HRIS and CSV files
Branded
Report in your own house style, not a generic BI look
Sign-off
Approval workflow with an audit trail per report
Drill-down
From aggregate to underlying transaction

Three flavours of management reporting.

Depending on who reads the report, how often it is published and how many source systems are involved.

Flavour 01

Internal management report

Compact project

Monthly management reporting for the management team: P&L, cash flow, KPIs, forecast versus actual. Figures from the accounting package and CRM, commentary written by the controller, and an automatic PDF sent to the management team. Suited to scale-ups and larger SMEs where the management pack is still assembled by hand in Excel or PowerPoint, and finance loses three to four days every month to formatting instead of analysis.

P&L & cash flowForecast vs actualCommentaryPDF distribution
Flavour 02

Client report or board report

Mid-sized project

For consultancies, marketing agencies or accountants who send a branded report to each client on a regular basis. Or for directors who compile quarterly reports for the board and shareholders. One template, multiple reports, each with its own data, house style and commentary. The system scales as the number of clients or subsidiaries grows, without the compilation process becoming proportionally heavier.

White-labelMulti-tenantReview flowPortal sharing
Flavour 03

Compliance or investor reporting

Larger project

Mission-critical reporting where an audit trail, sign-off and sector-specific formats are mandatory. Wwft, GDPR, ISO or industry-association requirements for finance. Investor reporting for PE/VC with deep integrations with ERP, data lake and a commentary flow for the CFO. For projects like this we often also build an investor portal where LPs or regulators can consult earlier reports themselves, together with the associated sign-off log.

Audit trailSign-offSector formatVersion control

What you get at the end.

A working reporting platform plus everything around it so you can manage and extend it yourself.

Reporting platform

Production and staging environments, in your cloud or hosted by us.

Codebase + docs

Full source code, build instructions and architecture overview.

Template editor

Your team adapts report templates itself, without a developer.

Training

Two sessions for the finance team plus an admin guide for IT.

Management (optional)

Monitoring, backups, security patches and ongoing development per sprint.

When custom is the right choice.

Power BI, Tableau, Looker, Qlik and Domo cover the standard cases well. We don't replace them; we build custom solutions when one of these patterns applies.

Client reporting

White-label reports

Consultancies and agencies that need to deliver a monthly report in the client's house style. One template, n reports, each with its own branding and commentary. Out-of-the-box BI tools only allow this crudely via export to PowerPoint, which is fragile and doesn't scale beyond a handful of clients.

Compliance

Sector-specific format

Dutch tax, Wwft, industry-association format. When a standard BI tool can't produce that format out of the box and the export flow has to be done by hand every time, or when a regulator requires a specific layout that changes every year and can't be solved with a report colour tweak in Power BI.

Source systems

Multi-source data

A combination of standard ERP/CRM with your own legacy systems, industry software or CSV files from suppliers. Too diverse for an out-of-the-box connector — an ETL layer is needed on top to clean up the source mess before the report gets started.

Commentary

Figures plus explanation

When the controller adds written commentary to each report and that commentary has to flow into the document automatically — not separately in Word. With a custom tool, you link commentary to the exact block of figures it relates to, including version history across quarters.

Modules in a management reporting system.

Not every project needs all the modules. We sketch the full picture so you can see which parts are relevant to your situation.

Data aggregation

ETL and harmonisation

Automated extraction from ERP, CRM, HRIS, accounting software and standalone CSV files. The raw data is mapped to a single central data layer on which the report runs, so a change in a source system doesn't immediately break the report.

Report templates

Excel-like, in your house style

Templates with formulas, subtotals and charts, formatted to match your house style or that of your client. The finance team edits templates themselves without developer involvement, much like editing a tab in Excel.

Commentary flow

Commentary per block

For each block of figures or each chart, the controller or CFO writes commentary in the tool. Earlier commentary remains available as version history, so you can see trends in the explanation itself, not just in the numbers.

Approval workflow

Review and sign-off

A recommended process with author, reviewer and final approver. The system records every step with a timestamp and user. After sign-off the version becomes immutable and distribution runs automatically via PDF, email or a shared portal.

Distribution

To the right stakeholders

Generate PDF or Word files, send them automatically to the stakeholder list for each report type, or make them available in a secured portal where the recipient logs in themselves. For each recipient we record who received which version and when.

Drill-down

From aggregate to transaction

In the online view you click through from a total to the underlying items, transactions or source documents. Handy for reviewers and auditors who need to trace a value straight back to the source line without a separate query.

Not sure about a large project yet?

Test your idea first: a working prototype in 1 day

With OneDayBuild, we make your idea tangible in a single day for €1,150, so you know whether further development is worth the investment. Decide to go ahead with the full build? Then we deduct the cost in full.

View OneDayBuild →

Target groups and use cases.

Who builds a management reporting system, and what for.

Use case

Monthly management team reporting

P&L, cash flow, KPI pack and forecast versus actual in one document for the management team. Figures from the accounting software and CRM, commentary per block by the controller, sent automatically on the first working day after month-end close.

Use case

Client reporting for agencies

Consultancies, marketing agencies and accountants who need to deliver a periodic report per client. One platform, dozens of branded reports, generated and distributed in the same flow every month or quarter.

Use case

Board and investor reporting

Quarterly reports for the board, shareholders or LPs. A fixed format with figures, narrative and appendix. Sign-off by the CFO and CEO before sending, plus an archive of earlier versions for due diligence.

Use case

Compliance and department reporting

Wwft (Dutch anti-money laundering act), GDPR, ISO or industry association formats. Or internal reports per department: sales, finance, operations. The same data flow each time, but a different report type and a different group of recipients.

How an MRS project works.

01Introduction→ 02Discovery→ 03Build→ 04Rollout
First conversation

Introduction

Which reports you currently produce, which source systems, which review process. We assess whether a custom solution is the right answer here.

A few sprints

Discovery

Workshop with finance and IT. Examples of current Excel reports, mapping of source fields, definition of metrics and commentary blocks.

Sprint cycle

Iterative build

Two-week sprints. Every sprint delivers a working build, and you test it with a real report from the previous period.

Ongoing

Rollout and maintenance

Phased, starting from a first reporting cycle. After that, ongoing maintenance plus optional extensions each quarter.

Tech stack for reporting systems.

For each project we choose what fits. No dogma about a single framework, but sharp choices upfront.

Frontend and reporting
Next.jsReactPuppeteer (PDF)React-PDFRecharts
Data and ETL
PostgreSQLDuckDBPython (pandas)dbtAirbyte
Auth and infrastructure
Auth0Azure ADGCP/AWSTerraformS3 + KMS

Frequently asked questions about management reporting.

What is the difference between a management dashboard and a reporting system?
A management dashboard shows real-time KPIs on a single screen, such as a live view of sales, stock and cash flow. A management reporting system (MRS) periodically produces a fixed report document: a PDF or Word file with figures, charts and written commentary that goes through a review flow once a month or quarter. Many organisations need both: a dashboard for day-to-day steering, and a reporting system for formal reporting to the board, clients or regulators.
Do you replace Power BI, Tableau or Qlik?
No. For standard reporting those tools are excellent and cheaper than a custom build. We build custom when the standard tools can't deliver a specific format: branded client reporting with an audit trail, industry-specific compliance formats, data from non-standard sources, or a commentary flow in which the controller writes explanations that end up in the document automatically. A custom MRS often runs alongside Power BI or Tableau, not instead of them.
Can the report use our branding or our client's branding?
Yes. A branded report is one of the most common reasons to build a custom MRS. For client reporting (consultancies, marketing agencies, accountants) we set up a separate template per client: logo, colours, typography, cover page and header. The figures block and the commentary stay the same; only the skin differs. A single MRS instance can run dozens of white-label reports side by side.
How do you handle different source systems?
We start with a mapping workshop: which source systems (ERP, CRM, HRIS, accounting package, industry-specific software) supply which fields. We then set up an ETL layer that periodically retrieves and harmonises data in a central data layer. We build connectors via standard APIs or, for legacy systems, via database replication or CSV import. Changes in a source system are absorbed in the ETL layer, so the report itself stays stable.
How does the commentary flow work?
For each report block, the controller or CFO can add written commentary, for example on a deviation between forecast and actual. We store that commentary separately per reporting period and link it to the figure. When the PDF is generated, the figure and the commentary come together in one document. Earlier commentary remains available in the version history, so you can see how the explanation develops across quarters.
What about security, audit trail and sign-off?
Every report goes through a review workflow: author, reviewer, sign-off. The system records every change with a timestamp and user. After sign-off, the report is locked as an immutable version, so you can later show exactly which report was sent to which stakeholder and when. Authentication runs via your existing IdP (Azure AD, Okta, Auth0), data is encrypted at rest and in transit, and access is role-based per report type.
What determines the cost of an MRS project?
Three factors: the number of source systems we need to connect (a single accounting package is different from a mix of ERP, CRM and legacy), the complexity of the report templates (one standard management report versus dozens of branded client reports), and the weight of the review flow (simple sign-off versus a multi-step compliance chain). An introductory call is always free, and we'll give you a realistic scope estimate for your situation.
Do you work with our finance and IT departments?
Almost always. Finance provides the domain knowledge (which metrics, which commentary, which format) and IT provides access to the source systems and the security framework. We deliver the software and the architecture. In the final sprint, we hand over knowledge to your IT team and provide a runbook for incidents. For larger projects, we organise the collaboration through shared Linear/Jira boards and a fixed sprint cadence.

Talk to us about your management reporting.

A free, no-obligation half-hour introduction. We listen to your current reporting process, look at a sample Excel file from the latest period, and advise whether a custom solution or a standard BI stack is the better answer. Also see related services: Custom KPI dashboard, Custom ERP system and enterprise software development.

Edit content