4100 · Service Revenue · CLIN-001 PDR + CLIN-002 CDR
0
0
20,500,000
13.9%
4200 · Material Revenue · CLIN-003 LL Procure
1,782,000
5,894,000
7,700,000
5.2%
4300 · Production Revenue · CLIN-004 Bus Mfg
3,481,400
3,481,400
3,481,400
2.4%
Total Revenue
5,263,400
9,375,400
31,681,400
21.5%
Direct cost · 5xxx
5100 · Direct labour · engineering
428,000
1,612,000
10,840,000
7.4%
5200 · Direct labour · manufacturing
312,000
1,108,000
2,260,000
1.5%
5300 · Direct material · POs received
1,512,000
3,402,000
5,790,000
3.9%
5400 · Direct expense · travel + tooling
158,000
442,000
1,210,000
0.8%
Total direct cost
2,410,000
6,564,000
20,100,000
13.6%
Gross margin
2,853,400 (54.2%)
2,811,400 (30.0%)
11,581,400 (36.6%)
Allocated overhead · burden
6100 · G&A allocation @ 12% of direct
289,200
787,680
2,412,000
1.6%
6200 · Fringe @ 38% of direct labour
281,200
1,033,600
4,978,000
3.4%
Project net margin
2,283,000 (43.4%)
990,120 (10.6%)
4,191,400 (13.2%)
Note: ITD margin is muted by front-loaded engineering (CLIN-001/002) where labour intensity is higher. Forecast shows margin recovery in CLIN-004 Bus Mfg (lower labour-to-material ratio) and CLIN-005 AI&T (test labour at higher bill rate).
Programme-target margin remains 21.2% per EAC.
💰 Accounts Receivable · aging 2 invoices · $2.3M total
100% current
Customer
Invoice #
Amount
Days out
Bucket
[Customer · Defense]
INV-2026-0418 · CLIN-003 milestone 4
$1,782,000
3 d
Current
[Customer · Defense]
INV-2026-0419 · CLIN-004 unit-1
$498,000
3 d
Current
Total AR
$2,280,000
3 d avg
100% current
Aging buckets: 0-30 (current) $2.28M · 31-60 $0 · 61-90 $0 · >90 $0. DSO 31 days · within Net-30 terms · payment received 2026-05-15 expected per FFP schedule.
📒 Trial Balance · summary by class 182 active accounts · $84.2M total
In balance · DR=CR · variance $0
Account class
Range
Apr Δ Debit
Apr Δ Credit
Net change
Balance · close
Assets
1xxx
8,140,200
5,892,800
+2,247,400
$36,420,000
1010 · Cash
5,612,000
7,712,000
-2,100,000
$28,400,000
1100 · AR
2,280,000
0
+2,280,000
$2,280,000
1210 · Unbilled receivable (contract asset)
3,481,400
2,300,000
+1,181,400
$1,181,400
1320 · Inventory · raw materials
1,512,000
0
+1,512,000
$3,820,000
1340 · WIP inventory
740,000
0
+740,000
$740,000
Liabilities
2xxx
2,892,800
3,105,000
-212,200
$8,720,000
2100 · AP
2,892,800
3,105,000
-212,200
$3,105,000
Equity
3xxx
0
0
0
$22,440,000
Revenue
4xxx
0
5,263,400
+5,263,400
$31,681,400
Direct cost
5xxx
2,410,000
0
-2,410,000
$20,100,000
OpEx · burden
6xxx
570,400
0
-570,400
$7,390,000
TOTALS · Apr 2026
14,013,400
14,013,400
$0 ✓
$84,220,000
🧮 Period close · 16-step checklist 14 of 16 done · 2 in progress for May open
Apr 2026: COMPLETE
Step
Status
Owner
✓
1 · Lock sub-ledgers (AP/AR/Inv) for new entries to Apr
DONE
K. Whitman
✓
2 · Bank reconciliation · 4 accounts
DONE
L. Park
✓
3 · Inventory cost valuation · WIP roll-forward
DONE
L. Park
✓
4 · 3-way match · all open POs reconciled
DONE
P. Reyes
✓
5 · Project cost capture · timesheets posted
DONE
HR / PM
✓
6 · Depreciation · fixed assets (cleanroom, GSE)
DONE
K. Whitman
✓
7 · Accruals · monthly bonus + utilities
DONE
K. Whitman
✓
8 · ARM revenue recognition run · 2 events
DONE
E. Vargas
✓
9 · Burden allocation · G&A + Fringe
DONE
SYSTEM
✓
10 · Inter-co eliminations (S-01 only · N/A)
SKIP · single sub
—
✓
11 · FX revaluation (Apr month-end rates)
DONE · $0 impact
SYSTEM
✓
12 · Period close · TB lock
DONE
K. Whitman
✓
13 · Sub-ledger reconciliation report
PASS
K. Whitman
✓
14 · CFO sign-off + close letter to AC
DONE 09:14
D. Wong
15
15 · Open period 2026-05 · roll forward balances
PENDING
K. Whitman
16
16 · Generate CDRL A001 · monthly progress report
DRAFTING
E. Garcia (PM)
💧 Cash flow · Apr 2026 ($M)
Source / use
Apr
YTD
+ Customer collections (CLIN-003)
5.61
14.42
− Vendor payments (POs)
-3.40
-9.10
− Payroll (incl Andromeda allocation)
-3.20
-12.80
− Other opex (rent, utilities, IT)
-1.11
-4.42
Net cash flow · operating
-2.10
-11.90
Beginning cash
30.50
40.30
Ending cash · Apr 30
28.40
28.40
Runway: at -$3.0M/month current burn (with collections), 9.5 months runway before next CLIN-004 milestone billing in Q3-26 ($14.5M expected).
📈 KPI scorecard · Apr 2026
Metric
Apr
Trend (3mo)
Target
Status
DSO · Days Sales Outstanding
31
↘ 33→32→31
≤ 35
✓
DPO · Days Payable Outstanding
31
↗ 28→30→31
30 ± 3
✓
Inventory turns (annualised)
2.4
↗ 2.0→2.2→2.4
> 2.0
✓
Gross margin %
54.2%
↗ 50→52→54
> 35%
✓
Project CPI · ANDROMEDA
1.04
= 1.04→1.04→1.04
> 0.95
✓
Project SPI · ANDROMEDA
0.97
↘ 1.00→0.99→0.97
> 0.95
~
Cash runway (months)
9.5
↘ 11→10→9.5
> 6
✓
Backlog ($M)
119.3
↘ 130→127→119
> 50
✓
🔗 Where these numbers come from · 5 cross-system flows that close the loop
Revenue (4xxx) ← ARM
$5.26M Apr revenue is exactly the sum of Apr ARM events REV-007 + REV-008 (RE-003 cost-to-cost + RE-004 MES-driven). Reconciles to $0 variance on every close.
Direct material (5300) ← Procurement
$1.51M Apr material is sum of vendor bills 3-way matched in Apr (PO ↔ Receipt ↔ Bill). BCT $729K + Sodern $680K + smaller items. AP aging shows $3.1M open · payment scheduled Net-30.
Direct labour (5100/5200) ← Project Tasks
$740K Apr labour pulls from project timesheet entries against PROJ-A WBS tasks. Posts at standard cost rate with variance to actual run-rate. EVMS reconciles AC = labour + material.
Inventory (1320/1340) ← Items + WO
Raw $3.82M reflects on-hand serialised inventory at standard. WIP $740K = 2 RWs in Stage 4 install + sub-assy partial labour. Issues to WO drain raw, build WIP, deliver to FG on Stage 9.
$2.28M open from 2 invoices issued late Apr against milestones. Net-30 means receipt expected mid-May. DSO 31 days is on-target. Customer (defense, gov-paymaster) historically pays 28-35 days.
Trial Balance · summary by class
Full TB summary (182 active accounts · $84.2M balanced) is shown on the Period Summary tab. DR=CR variance is $0.
Full project P&L with EVMS roll-up is shown on the Period Summary tab. Direct material/labour/overhead pulls from procurement, project tasks, and burden allocations.
💡 Click any Bill # for full vendor bill detail (GL impact · payment schedule · 3-way match) ·
Click any PO # for full Purchase Order record (header · lines · vendor · receipts · compliance).
🏦 Bank Reconciliation · 4 accounts
All reconciled · 2026-04-30
Account
Bank
Type
NS balance
Bank statement
Variance
Last recon
Status
1010-01 · Operating
SVB · acct ****8442
Checking
$24,820,000
$24,820,000
$0
2026-04-30
✓ Reconciled
1010-02 · Payroll
SVB · acct ****8443
Checking
$1,820,000
$1,820,000
$0
2026-04-30
✓ Reconciled
1015 · Money market
BlackRock · MMF
Investment
$1,640,000
$1,640,000
$0
2026-04-30
✓ Reconciled
1020 · Wire-only
JPMorgan · acct ****1142
Checking
$120,000
$120,000
$0
2026-04-30
✓ Reconciled
Total cash
$28,400,000
$28,400,000
$0
—
—
Period close · 16-step checklist
Full close checklist (14 of 16 done · 2 in progress for May open) is shown on the Period Summary tab.