Finance dashboard · Q2 2026
Continuous reconciliation against QuickBooks. Anomalies surfaced daily · month close in 2 days · cash visibility out 13 weeks.
Anomalies · pre-close
$47K
Surfaced this quarter · 32 caught · 2 still open
Close cycle
2d
Down from 7d · auto-recon + rule engine
Days cash on hand
62d
+6d WoW · comfortable for Q2 operations
Open AR · >60d
$412K
4 accounts · Apex trending past 58d
Quarter-to-date P&L · Apr 1 → Apr 18
Revenue
$4,821,400
+12% vs plan
Direct costs
$3,487,200
+14% vs plan
Gross profit
$1,334,200
+4% vs plan
Gross margin
27.7%
target 32%
Overhead · SG&A
$486,500
on plan
EBITDA
$712,700
14.8% · target 18%
Cash · 90d view
Operating
$892K
Line available
$1.2M
Runway
62d
Recent anomalies · today's queue
Demo note. Click any anomaly to drill in. The hero catch is the Apex Supply duplicate invoice — caught Apr 16 before it posted, saving $4,200. That's a whole day of senior-controller time back.
Anomaly feed
Every exception the rule engine surfaces. 6 open this week · total impact $47K caught YTD.
YTD caught
$47K
32 anomalies · avg resolve 11 min
Open · critical
2
Both >$3K · EOD SLA
Open · review
4
Within 48h SLA
False positive rate
3.4%
Tuned monthly
Seven rule categories fire here: duplicate invoice, round-number flag, vendor-rate drift, un-reconciled deposit, aged AR trend, job-cost overrun (from AG.02), off-hours transaction. Each has a confidence threshold; the controller tunes monthly.
AR aging · Q2 2026
Customer-by-customer. Collection-risk score auto-computed from payment history, open disputes, and external signals.
Current · 0–30d
$1,284K
22 invoices · 14 accounts
31–60d
$518K
11 invoices · 7 accounts
61–90d
$286K
4 invoices · 3 accounts
>90d
$126K
2 invoices · 2 accounts
| Customer | Total open | >60d | Aging | Risk | Suggested action |
|---|---|---|---|---|---|
| Sanderson Energy top customer · Tier 1 |
$284K | $0 | Current | Low | No action · on plan |
| Apex Midstream trending past 58d |
$198K | $142K | Aging | Medium | Chase letter drafted · CFO approval |
| Phillips 66 large enterprise · slow by design |
$156K | $0 | Current | Low | No action · standard NET-45 |
| Cascade Construction | $94K | $72K | Past due | High | Phone call flagged · owner: Chris |
| Maverick lost-vendor cycle |
$54K | $54K | >90d | High | Escalate to legal · $54K write-off risk |
| Occidental | $48K | $0 | Current | Low | No action · on plan |
Risk scores pull from six signals: payment history, open disputes, account size trend, external credit data, outside-collection activity, industry stress (oil price, pipeline sector). Maverick's 88 score reflects loss of recent bid and slowing pay cycle.
Cash flow forecast · 13 weeks
Rolling forecast refreshed daily from AR, AP, payroll, and job-cost projections. CFO's early-warning system.
Projected low point · W+7
$384K
24-day runway at W+7 · below 30d buffer
13-week ending cash
$1.14M
+$248K vs today
Line available
$1.2M
Undrawn · backstop if W+7 tightens
Forecast confidence
87%
Driver: Apex collection timing
Weekly cash position · 13-week rolling
Drivers · W+7 dip
Collection risk
Apex Midstream · $142K
Expected collection W+4 may slip to W+8–9. Pushes cash trough from W+5 to W+7 and deepens it by ~$60K.
Concentration
Mobilization payroll · W+6
Sanderson Pad 17 mob (if awarded) pre-job payroll hits before first progress billing. ~$180K working-capital swing.
Tailwind
P66 Old Ocean billing · W+9
Phase 1 close-out milestone invoice $156K · historically paid NET-45 · swings cash into W+11 recovery.
The W+7 dip is the CFO's Tuesday-morning conversation, not a Friday-afternoon surprise. Line capacity covers it 3×; planning decision is whether to draw or accelerate the Apex collection via early-pay discount.
March close · status
Continuous recon + pre-approved reversing entries · target close day 2. 14 of 22 tasks complete.
Progress
64%
14 of 22 tasks complete · on track for EOD Apr 20
Days elapsed
1.5d
vs 7-day historical average
Blockers open
1
Apex reconciliation · awaiting statement
Close checklist · 22 tasks · 14 complete
Bank reconciliations · 4 accounts3 operating · 1 payroll · matched to penny
CFO · J. Henderson
Done
Credit card reconciliations2 cards · auto-matched 98% of transactions
Controller
Done
AP vouchering · post all March invoices47 invoices posted · 3 exceptions routed to anomaly queue
AP clerk
Done
Payroll accrual · final March runBi-weekly + monthly salaries + commissions
Payroll
Done
Job cost allocation · JC to GLAll March time + material posted · feeds AG.02
Job cost
Done
Apex Midstream reconciliationAwaiting customer statement · blocker · chase email sent
AR · controller
Blocked
Revenue recognition review · 6 jobsPercent-complete method · 4 reviewed · 2 in progress
Controller
In flight
Depreciation & amortization18 fixed assets · pre-approved reversing entries ready
Controller
Pending
Inventory count · quarterlyParts yard + field equipment · scheduled Apr 19
Ops
Pending
Accruals · utilities, taxes, bonuses8 recurring accruals · auto-drafted · controller to approve
Controller
Pending
Financial statements · draftP&L, balance sheet, cash · reviewed with CFO
CFO
Pending
Management commentary · auto-draftedMonth-over-month variance explanations · from agent
CFO
Pending