Consolidated Cash
-
11 accounts · 5 institutions
Revenue - QTD
-
5 companies · posted through last close
Operating Income - QTD
-
-
Receivables
-
-
Priority Items
DecisionFoundry Supply - $250K working-capital advance requested. Approving in full dips the week-7 low point to - below the $3.60M floor. A two-tranche structure keeps it safe. Open review ›
CollectionsCalderon Energy - $1.84M now 61–90 days. Largest single exposure; at 74 days against net-60 terms. Next statement run flags it automatically. Open receivables ›
PayrollWest Bridge Industrial - +31 field hires since Aug 1 for the Gulf Coast turnaround. Weekly gross up $27.6K over four weeks to $418.6K; peak-week ~$460K mid-September. Open payroll ›
On TrackMeridian $302.9K intercompany note repaid Aug 20 with $2.9K interest - posted to both ledgers, netted out of consolidation.
Cash Runway - 26 Weeks
Thirteen weeks of actual flows, then thirteen projected - each bar starts where the last ended, against the family minimum-cash floor
Actual in
Actual out
Projected in
Projected out
Opening
Floor $3.60M
Cash by Company
Payroll Coverage
Weeks of own payroll each company's cash covers
Receivables Aging
Open invoices by days outstanding · click a bucket for its invoices
Properties - Net Monthly
After debt service and carry · 12 properties
Consolidated Cash
-
11 accounts · 5 institutions
13-Week Low Point
-
-
Avg Weekly Net
-
Companies + properties · trailing 13 weeks
Thinnest Payroll Cover
-
-
Property Net / Mo
-
Folds into the weekly money map
Weekly Money Map
Collections in above the line · payroll, vendors, and other out below it · hover a company for its full breakdown
Collections in
Payroll
Vendors & AP
Other out
Intercompany Lending
Short-term credit between the family office and the companies - every loan paired on both ledgers, eliminated on consolidation
| Loan | From → To | Amount | Drawn | Rate | Status | Purpose |
|---|
OUTSTANDING
INTEREST ACCRUED MTD $5.3K
REPAID YTD $302.9K (+$2.9K INT)
Cash Crunch Watch
Weeks of cover at current burn, scheduled collections, and flag
| Company | Cash | Weekly out | Wks cover | Coll. 0–30d | 4-wk trend | Status |
|---|
Weekly out = payroll + vendors + other, trailing average. Collections 0–30d = open invoices scheduled inside 30 days. WATCH under 4 weeks of cover; CRUNCH under 2.5.
Available for Lending
Sources the family could draw on without touching reserves
| Family treasury balance | $1,150K |
| Pending review - Foundry advance | −$250K |
| Property reserves (earmarked) | $330K |
| Uncommitted, above reserve | $570K |
Two-tranche structure for Foundry: $175K now, $75K in week 10 - keeps every week above the $3.60M floor with margin. Approve from the runway chips above.
Meridian crunch flag: 2.0 weeks of cover, but $1.26M of its receivables sit in 0–30 days - timing, not solvency. Watch weekly.
Open Receivables
-
-
Past 60 Days
-
-
Weighted Days Out
-
Dollar-weighted, all open invoices
Collected in August
$4.86M
218 receipts matched to invoices
In Collections Escalation
-
2 clients · counsel engaged on 1
Invoice Aging
Click a bucket to open its invoices inline · filter by company
| Bucket | Invoices | Amount | % of A/R | Share of A/R |
|---|
Customer Concentration
Open receivables by client, across all companies
-
Top Outstanding by Client
Largest open balances
| Client | Company | Oldest | Balance |
|---|
Recent Collections
Latest payment receipts
| Date | Client | Amount | Days out |
|---|
Vendor Payables (A/P)
-
| Vendor | Company | Unpaid | Bills | Due | Status |
|---|
Headcount (latest wk)
-
-
Weekly Payroll (gross)
-
-
Net to Employees
-
-
Employer Burden
$118K
Taxes + benefits, on top of gross
Next Runs
Tue Sep 1 · Thu Sep 3
Paychex & QBO Tue · Gusto Thu
Headcount & Payroll
Bars = total headcount · hover a week for each company's headcount and weekly payrollWeekly Payroll Runs
Most recent run per company - week 35, paid Fri Aug 28 · click a row for gross-to-net detail
| Company | Source run | Emp | Hours | Gross | Net | Status |
|---|
Active Contracts
-
-
Combined Contract Value
-
Signed backlog across the group
Earned to Date
-
-
Earned, Not Yet Billed
$842K
Flows to invoicing at milestone
Flagged Margins
1
M-77 - cost drift in change orders
Active Projects
-Earned value from each project system · costs matched from vendor invoices and job-coded labor · click a row for detail
| Project | Company | Client | Contract | Earned | Costs | Margin | Status |
|---|
Work in Progress
Earned vs billed, per active job
| Project | Earned | Billed | Gap |
|---|
Margin Watch
Re-computed nightly from the ledger
⚠
M-77 - Bexley Medical Office Bldg 2 at 14.2%Against a 22% book average. Drift is in change orders: labor posted to the job, offsets not yet negotiated. Controller's Monday review.
●
J-118 - Calderon Site B at 24.1% and climbingEarned 68% on the season's largest contract; labor matched to site by job code weekly.
●
J-114 and M-71 reached 100% earnedFinal invoices cut; retention lines tracked to release dates.
Portfolio Value
-
-
NOI / Mo
-
Income properties, before debt
Debt Service / Mo
-
-
Net Monthly to Family
-
After debt and land carry
In the Wealth Picture
Carried with appraisal dates
Portfolio
-Every property on one book · click a row for detail · click a column to sort
| Property | Type | Value | Occupancy | Gross / mo | NOI / mo | Debt / mo | Net / mo |
|---|
Debt - the Fixed Outflow
Servicer portals · payments scheduled and reconciled against the ledger
| Loan | Property | Balance | Rate | Monthly | Next payment |
|---|
Items Reconciled - Aug
4,961
Bank, card, payroll, storefront lines
Auto-Match Rate
99.94%
4,958 of 4,961 matched on entry
Open Exceptions
4
Awaiting a person · none older than 6 days
Draft Entries Queued
2
Prepared by the system · posted by a person
Unexplained Delta
$11.5K
Of $46.3M in August lines - 0.02%
Line-Item Reconciliation
Both sides of every reconciled line - source system vs books, item by item
| Date | Item | Source | Source amt | Books | Books amt | Delta | Status |
|---|
Exception Queue
What needs a person - evidence attached, action recommended
Automation
Pulls, matches, drafts - on schedule, never auto-posted
| Automation | Cadence | Last run | Status |
|---|
Match rate - Aug
99.4%
4,961 of 4,988 lines auto-matched
Close cycle
6 days
from 30–45 before automation
Once numbers stop being rekeyed and every mismatch surfaces the morning after, the close compresses to inside a week.
Number Registry
Every figure on this console: its source system, landing table, transformation rule, and cadence · click a row for its chain
| Figure | Surface | Value | Source system | Landing table | Rule | Cadence | Last sync |
|---|