NCREIF reporting automation for owners with third-party property managers
Every standard data point in CREx OS is defined to line up with NCREIF field definitions: property type and subtype, NCREIF region and division, market value, NOI, capital expenditures split the way NCREIF splits them, partial sales, debt, and occupancy. Your property managers keep Yardi, MRI, RealPage, AppFolio, or Entrata. You get one governed record, updated daily, that is ready for NCREIF submission and investor-grade reporting at quarter end.
What does NCREIF ready mean?
NCREIF ready means the property-level data in CREx OS is already classified, mapped, and validated against NCREIF definitions, so a quarterly NCREIF submission or an NCREIF PREA Reporting Standards package comes out of the same governed record your team closes every month. Nobody re-keys a property subtype, reclassifies a tenant improvement out of repairs and maintenance, or chases a market value in a separate workbook the week the submission is due. The mapping happens once, at onboarding, and the checks behind every feed keep it clean from then on.
CREx OS standard data points, mapped to NCREIF
NCREIF collects roughly 67 property-level fields each quarter from its data contributing members. These are the groups that matter most for index submission and investor reporting, and where each one lives in CREx OS.
| NCREIF data group | NCREIF fields and definitions | CREx OS standard data point | Where it comes from |
|---|---|---|---|
| Property classification | Property type (apartment, industrial, office, retail, hotel) and NCREIF subtype | Property type and subtype tags on every asset, set to the NCREIF list | Asset setup, reviewed by your CREx asset manager |
| Geography | NCREIF region (East, Midwest, South, West), division, and CBSA | Region, division, and CBSA derived from the property address | Address geocoding, locked at onboarding |
| Physical descriptors | Rentable square feet, unit count, floors, year built | Asset master record, reconciled against the rent roll | PM rent roll plus acquisition documents |
| Ownership | Ownership share, fund or account, joint venture structure | Fund to investment to property hierarchy with ownership percentages | Ownership structures workstream |
| Valuation | Beginning and ending market value, appraisal type (internal or external), valuation date | Quarterly valuations with source, method, and approver | Appraisals and internal marks, loaded outside the PMS |
| Income | Rental revenue, expense recoveries, other income | Firm chart of accounts revenue lines, mapped to NCREIF income groups | Daily PM general ledger and trial balance feeds |
| Operating expenses | Operating expense categories and net operating income | Operating expense lines rolled to NCREIF categories, NOI computed once | PM general ledger, CPA-reviewed mapping |
| Capital expenditures | Building improvements, tenant improvements, leasing commissions, expansion, other capital | Capital spend split into the NCREIF buckets, kept out of NOI | PM capital ledgers and draw reports |
| Dispositions | Partial sales proceeds, sale date, sale price | Partial and full sale events on the asset timeline | Closing statements, loaded by the AM team |
| Leasing | Percent leased and occupancy, weighted average lease term | Occupancy and WALT computed from the live rent roll | PM rent roll feeds, checked daily |
| Debt | Loan balance, interest rate, maturity, DSCR, loan to value | Loan records tied to covenant tests and valuations | Loan documents and servicer statements |
| Performance | Income return, appreciation return, total return, leveraged and unleveraged, IRR | Returns computed from the locked quarter, same formula every period | Calculated in CREx OS from the fields above |
Field groups reflect NCREIF's published data collection and the NCREIF PREA Reporting Standards. Your firm's exact submission template depends on your membership and the indices you contribute to, and we map to that template during onboarding.
Why NCREIF reporting is hard when a third party runs the books
The property manager's general ledger was built to run the building. NCREIF needs it described the way an institutional owner reports it. The gap shows up in the same four places.
Every PM has its own chart of accounts
Three managers, three account structures. Rolling them into NCREIF income and expense groups by hand every quarter is where numbers drift.
Capital hides inside operating expense
A roof patch booked as repairs, leasing commissions sitting in G&A. Misclassified capex overstates or understates NOI and bends the return.
Market value never lived in the PMS
Appraisals, debt, and ownership share sit in emails and workbooks. Someone merges them into the submission under deadline.
Classification is tribal knowledge
Is it garden or low-rise? Warehouse or flex? When subtype and division live in one analyst's head, the submission changes when that analyst does.
From PM feeds to an NCREIF-ready quarter
Feeds land daily from every property manager
General ledger, trial balance, rent roll, and lease data from Yardi, MRI, RealPage, AppFolio, Entrata, and other systems. No portal logins or file uploads. A quiet feed gets flagged the day it stops.
Accounts map once to your COA and to NCREIF
CPAs on the CREx team map each operator's accounts to your firm chart of accounts, and that chart to NCREIF income, expense, and capital groups. New accounts land in a review queue instead of a default bucket.
Owner-side data joins the property record
Valuations, debt, ownership share, and sale events are loaded against the same asset, so market value and NOI sit on one timeline with one source for each.
Checks run before anyone asks
Capex coded to operating expense, a subtype that changed without a reason, a market value that moved more than your threshold, occupancy that does not reconcile to the rent roll. Each one becomes a ticket with an owner.
The quarter closes with names on it
Approvals record who signed each property and domain. The NCREIF extract, the LP package, and the lender report all come from that locked quarter.
NCREIF returns, computed the same way every quarter
The NCREIF Property Index reports unleveraged quarterly returns on a time-weighted basis. The formula is public. Getting it right depends on clean inputs, which is the part CREx OS owns.
Total return = ( NOI + ( MVend − MVbegin ) − CapEx + Partial sales ) ÷ ( MVbegin + ½ CapEx − ½ Partial sales − ⅓ NOI )
Every input in that formula maps to a CREx OS data point in the table above. When a tenant improvement is coded to repairs, income return drops and appreciation return rises by the same amount. CREx catches that at the feed, not in the index.
Asset-level, machine-readable, and already in the record
The NCREIF PREA Reporting Standards moved toward asset-level reporting in standardized digital formats such as CSV and XML. That favors owners whose property data is already structured. It punishes owners who build the report in a spreadsheet.
Asset-level detail
Characteristics, valuations, income, expenses, and capital activity per property. CREx OS stores all five per asset, per period.
Machine-readable output
The record is API-first, so a CSV or XML extract is a query, not a rebuild. The same data powers dashboards and AI agents.
Debt service coverage
DSCR tested from actual NOI and actual loan terms, the same number the covenant monitoring workstream reports.
Weighted average lease term
WALT computed from the live rent roll and lease schedule, not a static abstract from acquisition.
Loan to value
Loan balance against the current quarter's market value, with the valuation source attached.
Discount rate and projected IRR
Valuation assumptions and projected returns stored alongside the actuals, so the recommended fields travel with the asset.
The mapping is only as good as the people who keep it
CREx OS
- Daily feeds from every PM system into one governed record
- NCREIF classification, regions, and field mapping on every asset
- Valuations, debt, ownership, and returns alongside operations
- Checks that flag capex in opex and unexplained value swings
- API and MCP access so the same numbers reach every report and agent
Your fractional asset management bench
- CPAs who own chart of accounts and NCREIF mapping
- Asset managers who chase missing feeds and wrong codes at the source
- Quarter-end review before anything is submitted or sent to LPs
- Monthly and quarterly investor reporting produced for you
- One named operator who knows your portfolio
Built for investment managers from $100M to $10B+ AUM across multifamily, commercial, and credit. See how the same close feeds investor-grade reporting across mixed PM estates.
NCREIF reporting questions
What is NCREIF?
What is the NCREIF Property Index (NPI)?
What are the NCREIF PREA Reporting Standards?
Is CREx certified or endorsed by NCREIF?
Do our property managers need to change systems or report differently?
How do you handle capital expenditures for NCREIF?
Where do market values come from?
Can we use this if we are not an NCREIF member?
How long does it take to become NCREIF ready on CREx OS?
Send us last quarter's submission pain.
Which managers, which fields took the longest, which number got restated. We will show you the same quarter mapped in CREx OS.
- Property count, property types, and PM systems
- Whether you contribute to NCREIF or benchmark against it
- Where the last submission or LP package broke
- A reply from a CREx operator within one business day
NCREIF and the NCREIF logo are trademarks of the National Council of Real Estate Investment Fiduciaries. CREx Software is not affiliated with or endorsed by NCREIF. References describe alignment of CREx OS data definitions to NCREIF's published standards.
NCREIF-ready data, every quarter, without the rebuild.
Book a demo with your PM estate and your submission calendar.
Book a demo → Investor reporting