Merge data from the sources
Data sheet for reporting month 2026-07, 4 sources, reporting date 31 July, 1 source as of 28 July
Administration
It takes gathering the figures, from scratch every month.Open agent
Enlarge demo
Developed in Germany · Hosted in the EU or on-premises
Delivered together with
The directorate requests the report as of the reporting date; the figures sit in separate systems and in an Excel file on a shared drive. By the time all sources show the same date, there has been a rough draft, a query and a corrected version.
1
reporting date
The directorate requests the monthly report as of the reporting date.
4
sources
Specialist applications, budget software, HR system and an Excel file.
2
versions
First the raw figures, then the corrected version after a query.
12x
a year
The same routine repeats every month.
The report is ready on the second working day instead of the fifth, because gathering the figures accounts for up to 70% of the effort.
The reduction of up to 70% in reporting effort is this agent's headline figure. Four sources and twelve runs describe a typical monthly report in a municipal department and were not measured.
On the reporting date, the agent reconciles the figures from the connected sources; political interpretation stays with the head of department.
Data sheet for reporting month 2026-07, 4 sources, reporting date 31 July, 1 source as of 28 July
KPI sheet with 14 KPIs, 1 formula and 1 source field per KPI
monatsbericht_2026-07_entwurf.pdf, 2 pages, 14 KPIs, 3 outliers marked
It shows changes and outliers. Management decides what follows from them.
It marks the outlier with its KPI and reporting date. The department whose application produced the figure supplies the explanation.
It reads the four connected sources as of the reporting date. If a unit also keeps its case numbers in its own Excel file in a user folder, those figures do not feed into any KPI.
Connected systems
Departments' specialist applications
budget and finance software
HR management system
Operations
Deployment model
Data processing
Responsible teams
How quickly is the Administrative Reporting Agent ready to use?
Where is the data processed?
Where does the figure “up to 70% less reporting effort” come from?
All agents
30 to 50%
less planning effort
Treasury, finance directorate
35%
less coordination effort
Project office, directorate
40 to 60%
faster assessment
Funding Bodies, Project Sponsors
up to 70%
less reporting effort
Executive management, controlling, committees
40%
less planning effort
Treasury, finance directorate, council office
35%
fewer overload days
Tourism, public order office, transport planning