Merge figures from three systems
Report for May 2026, 14 clinical departments, 3 sources
Health
the variance is five weeks old.Open agent
Enlarge demo
Developed in Germany · Hosted in the EU or on-premises
Delivered together with
Case numbers come from the HIS, revenue from billing, staff and non-staff costs from the ERP. The three extracts are merged in one workbook, the clinical departments are compared side by side and variances are hunted down by hand. If a question comes up in the meeting, the whole process starts again.
3
source systems
HIS, billing and ERP each supply their own extract.
14
clinical departments
For every department, case numbers, revenue and costs are compared.
2
days
That is how long it takes to get from the workbook to a finished report.
1
follow-up question
One query in the meeting sends the whole process round again.
Once the three sources come together automatically and the variances are flagged, reporting effort falls by 70%.
The 70% reduction in reporting effort is this agent's headline figure. Source systems, number of departments and preparation time describe a typical month-end close in medical controlling; they are not measured values.
The agent merges data from the HIS, billing and ERP into a report with the variances flagged; medical controlling interprets it.
Report for May 2026, 14 clinical departments, 3 sources
6 flagged variances, the largest in cardiology with 214 cases
summary_mai2026.pdf, 2 pages, 6 variances linked to cases
It shows where actual and plan diverge and which cases lie behind them. Medical controlling provides the interpretation.
It presents figures and variances. Executive management decides on measures.
Anything booked after the reporting cut-off is missing from summary_mai2026.pdf. The cut-off date appears on every page.
Connected systems
HIS
ERP
billing system
Operations
Deployment model
Data processing
Responsible teams
How quickly is the Medical Controlling Agent ready to use?
Where is the data processed?
Where does the figure “70% less reporting effort” come from?
All agents
35%
more efficient process management
Management, quality management
60%
less preparation time
Executive board, hospital management
40 to 60%
less review effort
Billing, controlling
50%
earlier corrective action
Controlling, executive management
50%
less coordination effort
Medical controlling, strategy, executive management
45%
less coordination effort
Executive management, group controlling, legal