SPV Consolidation Readiness Checklist (Free PDF)

Before you build a portfolio dashboard, make sure your foundations won't break reconciliation.

If you are running a property portfolio through multiple SPVs, you have probably tried to "consolidate" at some point-whether that is a monthly spreadsheet roll-up, a BI dashboard, or a reporting pack stitched together from multiple Xero or QuickBooks exports.

And the same problem keeps showing up:

The portfolio totals do not tie back to the SPVs
NOI looks right... until someone asks for a drill-down
Capex vs opex varies by entity
You spend month-end building bridges instead of analysing performance
Stakeholders stop trusting the dashboard

The issue usually is not your dashboard. It is consolidation readiness: the underlying COA, mappings, close controls, and intercompany rules that determine whether group reporting can reconcile cleanly.

To help, we put together a practical, finance-first checklist you can run in under 10 minutes.

-- Download: SPV Consolidation Readiness Checklist (PDF)
Use it to assess your portfolio, spot the blockers, and prioritise fixes.

Button copy (for your website):
Download the checklist (PDF)

What "consolidation-ready" actually means

You are consolidation-ready when you can confidently say:

Scope is clear: every entity in or out of the consolidation is known (and consistently treated).
Your financial language is consistent: COAs align or map cleanly to a portfolio reporting structure.
Month-end is controlled: reconciliations happen before consolidation, and closed periods do not keep changing.
Intercompany is understood: flows are documented and eliminations are defined.
Outputs reconcile and drill: portfolio numbers tie to SPVs, and you can drill down to account and transaction detail.

If any one of those fails, you do not just get a messy report-you get a portfolio view that becomes "directional," and month-end becomes a recurring project.

What is inside the checklist

The PDF is organised into 7 sections that mirror the real causes of consolidation pain:

Portfolio scope & entity hygiene
Chart of accounts & accounting policy
Mapping, controls & COA governance
Intercompany & eliminations
Reporting outputs & KPI definitions
Data quality & month-end readiness
Dashboard & operating cadence

Each checkpoint is marked Ready / Needs work / N/A, so you can score your readiness and identify what to fix first.

A few example checkpoints (so you know what you are getting)

Here are real items from the checklist:

Do you have a Portfolio COA (canonical reporting lines) agreed and written down?
Is every active SPV account mapped to a portfolio line item (with unmapped accounts flagged)?
Are bank accounts and key balance sheet accounts reconciled before consolidation cut-off?
Is there a consistent policy for capex vs opex (repairs vs improvements) applied across entities?
Are intercompany relationships documented (fees, recharges, loans) with a defined elimination approach?
Can you drill from portfolio -> SPV -> account -> transaction to explain variances?

These are the mechanics that decide whether your "portfolio dashboard" becomes trusted infrastructure-or another spreadsheet bridge.

How to use it (recommended workflow)

Run the checklist in one working session (finance + whoever owns bookkeeping / property accounting).
Mark every checkpoint as Ready / Needs work / N/A.
For every "Needs work," write:
- Owner
- Fix (policy, mapping, process, or system)
- Deadline
Prioritise fixes that unblock reconciliation fastest:
- Portfolio COA
- Complete mappings + unmapped-account alerts
- Month-end controls (recs + lock dates)
- Intercompany rules

Who this is for

This checklist is most useful if you have:

Multiple SPVs in Xero or QuickBooks (or you are about to)
A portfolio dashboard that does not reconcile cleanly
Investor / lender reporting that requires consistent definitions (NOI, capex, finance costs, gearing)
A month-end close that is starting to feel like a data exercise rather than performance analysis

Download the PDF

-- SPV Consolidation Readiness Checklist (PDF)
Download the checklist

Optional subtext (under the button):
No fluff-just the controls and definitions that make portfolio reporting reconcile.

What happens after the checklist

If your score comes back "amber" or "red," that is normal-most portfolios drift over time as accounts get added, policies vary by SPV, and intercompany grows.

The good news: the fixes are usually straightforward once they are visible:

standardise your reporting structure (Portfolio COA)
make mappings explicit and governed
tighten month-end readiness
define eliminations early
require drill-down as a non-negotiable

This is exactly why we are building a Xero- or QuickBooks-based multi-entity layer for SPVs: one portfolio view across entities, standardised COAs/mappings, and a foundation for FP&A, scenario planning, and investor-ready reporting packs.