Financial statements filed by documents-app, mapped to property_financials columns.
Approve to write into the RE app; nothing is written until you approve.
It's filed to the deal's SharePoint folder and lands here as pending review.
Drop statements here, or
PDF / Excel / Word / CSV · max 40 MB. The
property, statement type, and period are auto-detected from the file — including multi-property workbooks (each property is split out automatically).
The file names —
that matched no deal. Pick the right one above.
— its Revenue/OpEx/NOI/Cash Flow are only known at the period total, not split by month.
This document itself carries no monthly $ grid — the Revenue/OpEx/NOI/Cash Flow figures above
are what's already on file for those months (property_financial_details), not extracted from
this statement.
Property
No FO property found for this deal (investment_number
). Create the property in FO first.
Off by as mapped — the statement itself balances, so this is our mapping
side
as filed
as mapped
dropped
Accounts that never reached a section:
⚠ These account for
of the gap — something else moves the rest.
A flag is cleared on the mapping page
— find the account and un-flag it.
⚠ line item(s) didn't map and were excluded from NOI:
⚠ The publish gate would HOLD this statement
—
Tying out is not the same question. Approving overrides this hold and
publishes anyway.
Publish gate not checked — treat the tie-out below as arithmetic only,
not as clearance to publish.
✓ Ties out✗ Ties on what was checked — but the extraction is incomplete≠ Differs from the loaded master — approving updates it✗ Does not foot to its own reported totalsNo reference to check against (unverified)
· reconciled:
of OpEx sits below their expense line
(
accounts,
hover) — same money, cut at a different line
· vs
checked
of
:
—
compared against nothing
⚠ The extraction stopped short of the statement
· no reached our accounts, but the document shows
worth ≈
—
Only
account(s) were extracted. Approving publishes figures that omit the above.
⚠ The figures above and the grid below disagree
· reads
in the mapped line items but
in the figures above —
so the cash flow shown does not deduct it
Same figures as the card above, month by month — what to reconcile the statement against.
Metric
The identity checked twice — as the statement filed it, and as the model
classifies it. Only the second is what the reports show.
as filed
as mapped
Assets
Liabilities
Equity
Assets − (Liabilities + Equity)
On the wrong side of the balance sheet:
is filed under
but maps to ,
which is
·
Balances both ways, with every account mapped — nothing dropped and nothing on the wrong side.
Same money, cut differently. Your statement's Total Expense holds three things
the model separates, because NOI is measured before all of them.
Total Income
the statement's own top line
= Total Expense
compare to the statement's printed total
= Net Ordinary Income
income − total expense · the statement's bottom line
NOI (this model)
income − operating expenses only — your statement prints no such line
Every account on this statement is placed in exactly one of the rows above — nothing dropped.
📅 Tied out over the
overlapping month(s); the loaded master is missing
— approving adds .
(figures below are summed over the shared months, so they compare like-for-like;
the card header shows the full -month total.)
metric
reconstructed
reference
Δ
excluded as subtotal:
unmapped account(s) — add them to the library.
Nothing on our side fixes this — every account is mapped, and the
statement's own figures disagree with each other. You can publish it
anyway so the month shows up in the model, with the break recorded
against it.
a reason is required
Approved, but not in the reports yet.
The publish check held it back, so its figures are staged rather than live —
which is why this property doesn't appear on the Model tab.
Every account line as extracted from the document, its amount, and the
property_financials bucket it flowed into. Muted rows were recorded but
excluded from the recomputed NOI.
No raw source lines were captured for this statement.