SPV Consolidation Readiness Checklist (Free PDF)

Integration update, 20 October 2026: Clarity Ledger now connects Xero, QuickBooks Online and FreeAgent. GBP Xero examples below remain valid. Check current provider and currency eligibility; planning, KPI and pack-preparation tasks described as manual remain separate workflows.

Download the checklist (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.

Use the checklist for an initial review; resolving issues and gathering evidence may take longer. It covers manual finance controls, not an automated assessment or a statement that formal consolidated accounts are complete.

Download the SPV Consolidation Readiness Checklist (PDF). Use it to assess your portfolio, record evidence and prioritise fixes.

---

What "consolidation-ready" actually means

You are consolidation-ready when you can confidently say:

1. Scope is clear: every entity in or out of the consolidation is known (and consistently treated).
2. Your financial language is consistent: COAs align or map cleanly to a portfolio reporting structure.
3. Month-end is controlled: reconciliations happen before consolidation, and closed periods do not keep changing.
4. Intercompany is understood: flows are documented and eliminations are defined.
5. 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:

1. Portfolio scope & entity hygiene
2. Chart of accounts & accounting policy
3. Mapping, controls & COA governance
4. Intercompany & eliminations
5. Reporting outputs & KPI definitions
6. Data quality & month-end readiness
7. Dashboard & operating cadence

The two-page PDF has 14 checkpoints marked Ready / Work / N/A, evidence fields and an action log for each fix, owner and deadline. Use the count to organise work, rather than treating it as certification.

---

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

The checklist asks you to document and review questions such as:

• 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)

1. Run the checklist in one working session (finance + whoever owns bookkeeping / property accounting).

2. Mark every checkpoint as Ready / Needs work / N/A.

3. For every "Needs work," write:

   • Owner
   • Fix (policy, mapping, process, or system)
   • Deadline

4. 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

Keep the completed checklist with the supporting schedules and agreed actions.

---

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

Clarity Ledger currently supports selected GBP Xero companies, saved profit and loss, balance sheet and trial balance reports, and mappings that you review and apply. The checklist is a separate manual resource. Intercompany eliminations, formal consolidated accounts, transaction drill-through, forecasting, scenarios and investor packs require your own finance process; QuickBooks Online and FreeAgent connections are also available; check provider eligibility. See the current reporting scope.