Dear CFO by Phoenix Strategy Group

For real estate

Every property, every entity, one portfolio view.

Each property in its own LLC, each with its own books. Dear CFO consolidates them, keeps NOI and cash current, and brings in rent rolls and occupancy from the tools you already use.

Works with

  • QuickBooks Online logo
  • Xero logo
  • Google Sheets logo
  • BigQuery logo

Portfolio NOI

$1.92M

+4% vs budget

Occupancy

94%

+1.5 pts

Illustrative figures

The problem

A portfolio of spreadsheets

Every property has its own entity and its own books. Seeing the portfolio means exporting each one, reconciling them by hand, and hoping nobody changed a file.

  • A set of books per property entity
  • Rent rolls and leases in property software
  • Occupancy tracked in spreadsheets

Rent rolls, leases and occupancy from your property-management software come in through Google Sheets or BigQuery.

  • QuickBooks Online logoQuickBooks Online
  • Xero logoXero
  • Google Sheets logoGoogle Sheets
  • BigQuery logoBigQuery
Dear CFO

How it works

Everything flows into one live set of numbers.

Each system syncs on its own schedule into one managed warehouse. Statements, metrics and answers all read from it, so they always agree.

QuickBooks Online
Xero
Google Sheets
BigQuery

Live statements

P&L and balance sheet, current

Your metrics

Defined once, kept current

Answers

Ask in plain English

Numbers you can track

The numbers real estate run on.

Illustrative figures

NOI by property

Net operating income per property or entity, from the books.

5 properties

Consolidated portfolio

Every property entity’s books combined into one view.

12

entities consolidated

Occupancy

Brought in from your property system through Google Sheets.

94% occupied

Cash flow

Cash flow statements from QuickBooks, by entity and combined.

$262K this month

Budget vs actual

Each property scored against its budget.

4 of 5 on budget

What is budget vs actual? →

Receivables

Open tenant invoices, aged from their due dates.

96%

collected on time

What is AR aging? →

Questions

Dear CFO for real estate

Each property is its own LLC. Can you combine them?

Yes. Connect each entity’s books and view them separately or consolidated into one portfolio.

Do you connect to our property-management software?

Not directly. Rent rolls, leases and occupancy come in through Google Sheets or BigQuery, next to the books.

Which statements are available?

P&L and balance sheet from QuickBooks or Xero, and cash flow from QuickBooks.

Other industries

All industries

See it against your own numbers.

Create a login and connect your systems in minutes, or book a call and we will walk through it with your business in mind.