Bring the source data to the cut-off date
Portfolio OBJ-118 with 14 properties, 4 exports adjusted to the last day of the month
Real estate
When the figures are checked, the vacancy numbers don't add up.Open agent
Enlarge demo
Developed in Germany · Hosted in the EU or on-premises
Delivered together with
Rent and vacancies are in the ERP, floor space and faults in the CAFM, incoming payments in financial accounting. Each source is exported separately, copied into a master sheet and adjusted to the cut-off date by hand. The real question, why net rent is falling in two properties, only gets attention after that.
4
source systems
ERP, CAFM, financial accounting and CRM each deliver their own export.
12
spreadsheet tabs
Every month, the exports are assembled into a new master sheet.
26
KPIs per property
The reporting template covers vacancy rate, net rent, tenant turnover and maintenance costs.
6 working days
until the report is ready
Four of them go on exports, reconciliation and cut-off corrections.
At the start of the month, controlling goes straight into variance analysis instead of exporting, and with the four days of preparation gone, 70% of the reporting effort disappears.
The 70% reduction in reporting effort is this agent's headline figure. The six working days to a finished monthly report reflect a typical process in property controlling, not a measured duration.
The agent brings the figures together and calculates the variance; controlling identifies the cause.
Portfolio OBJ-118 with 14 properties, 4 exports adjusted to the last day of the month
26 KPIs for 14 properties, 2 vacancy values with a source discrepancy
briefing_OBJ-118.pdf with 6 variances, each with source and calculation
It shows that the vacancy rate in the Rheinbogen quarter is rising compared with the previous month, with both source values alongside. Property controlling interprets it.
The draft goes to the head of property management, who decides what goes on to the executive management meeting.
Until a change of tenant is entered in the ERP, it counts the unit as occupied. The report reflects the data, not the intention behind it.
Connected systems
Property portfolio ERP
CAFM
financial accounting
Operations
Deployment model
Data processing
Responsible teams
How quickly is the Property Reporting Agent ready to use?
Where is the data processed?
Where does the figure “70% less reporting effort” come from?
All agents
60%
less preparation time
Board, Portfolio Management
30%
faster decision cycles
Investment, asset management
50%
less audit preparation
ESG, sustainability management
60%
less re-keying
Property takeover, data management, IT
50%
fewer incorrect responses
Legal, Compliance, Property Management
20%
better pricing strategy
Asset management, controlling