Automated Portfolio Reconciliation for Real Estate Funds
The problem
Reconciling a fund means checking internal books against administrator statements, valuations and bank data that each name the same position differently, a pair of files at a time. The variances that matter often surface only at the audit, when a difference of a few francs can take an afternoon to explain.
What Quanthome does
Quanthome reconciles every source in one structured base, entity-matching each record to the asset it describes, and surfaces each difference as a flagged variance carrying both values and their origin. Every matched item traces to its source for the audit, and the mappings persist, so the next period opens on current statements rather than a blank line-by-line comparison.
See every variance before the audit does.
Reconcile every source at once
Books, administrator statements, valuations and bank data line up in one structured base, entity-matched to the same asset, rather than checked pairwise across files that name positions differently.
Drop the line-by-line review
Differences surface as flagged variances with both values and their source, so no one rebuilds the comparison by hand or re-keys each statement before the gaps can be found.
Catch errors early, every cycle
Variances appear while corrections are still cheap, and saved mappings reopen on current statements at the next period, moving the time from finding the gaps to explaining them.
How fund administrators catch variances before the audit
The Data Engine ingests administrator statements, valuations and bank data alongside the internal books into one structured base. Entity matching ties every record to the asset it describes, so the books and an external statement agree on what an asset is. Any source the Data Engine can structure becomes part of the reconciliation. No source is compared by hand.
Differences between sources surface as they appear, each one with both values and their origin, so the team reviews a specific gap rather than searching for it. Variances surface continuously, while corrections are cheap, not at the audit when they are most expensive to fix. Every matched and flagged item traces to its source, so the export is a trail the auditor can follow.
Entity mappings, matched positions and documented explanations persist from one period to the next. The next reconciliation opens on current statements, not a blank line-by-line comparison. Time moves from finding the gaps to explaining them.
Built for
The fund finance, administration and audit teams that have to make the books and every external statement agree.
Owners & operators
Quanthome gives direct asset owners and the property managers who run their buildings one consistent, building-level view, performance, tenancy, capex and risk, from the same data.
Asset allocators & indirect real estate investors
One view across your direct buildings and your indirect holdings, so reports and decisions land in hours, not weeks.
Service providers & valuers
Run the same repeatable process every cycle, on the regulator's timetable, from one structured Swiss dataset rather than a fresh round of data collection each time.
Explore further
Quanthome Platform
The analyst workbench for real estate.
Quanthome Data Engine
From scattered documents to one structured, audited view.
Quanthome AI
Page-on-demand dashboards, generated from a question.
API & MCP
Your tools, our data.
Quanthome Workflows
From structured data to finished deliverables.
See How Quanthome Supports Portfolio Reconciliation
Portfolio reconciliation in real estate funds: where the gaps between books and statements come from
Entity matching across administrators, valuers and banks: agreeing on what an asset is
From line-by-line comparison to flagged variances: catching errors before the audit
What People Ask Before the First Reconciliation
What is portfolio reconciliation?
Portfolio reconciliation is the comparison of internal books against external sources, such as administrator statements, valuations and bank data, to find and explain every variance between them. Quanthome runs the comparison in one structured base, entity-matching every record to the asset it describes, so differences surface as flagged items rather than through a line-by-line manual review.
Which sources can be reconciled?
Internal books are reconciled against administrator statements, valuations and bank data. Any source the Data Engine can structure becomes part of the reconciliation, so the comparison runs across every source in one base rather than pairwise by hand. Coverage extends as new sources are ingested.
What happens when a variance is found?
It is flagged with both values and their sources, so the team reviews a specific difference rather than searching for it. Variances surface as sources are ingested, while corrections are cheap, and each resolved item is recorded with its explanation, so the position stays documented for the audit.
Does the reconciliation produce an audit trail?
Yes. Every matched and flagged item is traceable to its source record, so the exported reconciliation is evidence the auditors can follow rather than a comparison they rebuild. A difference of a few francs no longer takes an afternoon to explain; the explanation is recorded where the variance was resolved.
How does the reconciliation save time at the next period?
The entity mappings, matched positions and documented explanations persist between periods. The next reconciliation opens on current statements rather than a blank comparison, so the team starts from flagged variances instead of repeating the line-by-line review. Each cycle is a refresh, not a rebuild.
CHF 250B+ of Fund NAV on One Structured Base. Variances Surfaced Before the Audit, Not During It.
Tell us the period and the sources. We will run the reconciliation with you in a working session.
Book a working session