Keel demo client portal — bookkeeping, controller, and CFO reporting

← Back to siteDEMO  The Bluth Company is fictional and every number is illustrative — this demo runs the full Keel stack: bookkeeping, controller, and CFO. Your portal shows exactly what your engagement includes, nothing more. See what yours would look like ›Schedule a call
Period: May 2026 · Last refresh: Jun 11, 2026
BK · AccrualControllerCFO

Executive Summary — May 2026 close

All figures below are pulled directly from The Bluth Company's QuickBooks Online file (accrual basis) via the Intuit connector — no manual exports. Data refreshed Jun 6, 2026.

Revenue · May
$193,897
YTD: $1,355,688
Gross Margin i
15.9%
Target 25-35%
Cash on Hand
$83,092
≈3–4 months at current burn
DSO i
23.9 days
Target < 45 · ✓ excellent
DPO i
41 days
74% of AP aged 91+ days
AP 91+ Days i
$163,911
74% of total AP

Revenue, profit & balance-sheet trends — Jan through May 2026

Each metric is benchmarked against its rolling 3-month average. Variance detail lives on the Controller tab.

Margin Trends

Cash, AR, AP

DSO vs DPO

Equity & Liabilities

Monthly P&L (accrual basis)

MonthRevenueCOGSGross ProfitNet Income
Jan 2026$451,092.54$274,124.45$176,968.09$136,580.15
Feb 2026$220,019.04$141,434.70$78,584.34$39,289.88
Mar 2026$296,794.75$180,564.89$116,229.86$60,015.18
Apr 2026$193,883.98$199,342.68−$5,458.70−$49,506.00
May 2026$193,897.54$163,128.00$30,769.54−$20,484.84
YTD$1,355,687.85$958,594.72$397,093.13$165,894.37

Ties to the QBO P&L report to the penny. April’s COGS exceeded revenue — labor and materials committed to projects that didn’t bill.

P&L Snapshot

AR vs AP Aging

THE ONE THING THIS MONTH

Bluth has roughly four months to act. At the current burn rate (May NI −$20K, Apr NI −$50K), cash on hand of $83,092 supports ~3–4 months. Meanwhile $163,911 in AP is 90+ days overdue (Sitwell Enterprises alone at $73,836). The business cannot self-fund its way out from operations alone.

Three levers, in order: (1) restore revenue to the $292K+/mo Q1 baseline — requires bid pipeline visibility we don't currently have; (2) cut fixed costs to fit the $194K/mo run-rate — OpEx grew from 9% to 26% of revenue as revenue fell; (3) bridge capital — a $164K term loan or SBA Express buys 6–8 months of working room while levers 1 and 2 take effect. A vendor triage and financing plan must be set within 14 days.

What the numbers say

Flags for review (/Bosun)

Full variance-by-line detail: Controller tab → Variances vs. the 3-month baseline.

From your conversations EMAIL · CALLS · MEETINGS → PORTAL

Questions and requests from any channel land here automatically — answered, delivered, or flagged. Nothing said in a meeting dies in a notebook.

Jun 5 · 2:14p
“Can you resend whatever you have on the Sudden Valley overrun? Bank asked.”
✓ Answered same day — WIP schedule + margin card linked back; lender package updated (Q2 addendum).
Jun 3 · call
Call“I want to see margin by crew, not just by job — I think Crew C is the leak.”
✓ Delivered Jun 5 — Departmental labor report now runs monthly (Controller → Labor & Compensation). He was right: Crew C, 61% utilization.
May 28 · on-site
MeetingOwner mentioned negotiating to buy a retiring competitor’s truck fleet (6 vehicles, ≈$210K, likely financed).
⚑ Engagement change flagged — fixed-asset & loan schedules, insurance, and depreciation would enter scope. Queued in Notes & Needs; summaries & workflows update on confirmation.
May 27 · 9:02a
“Do we owe anything on the Ameriquest payoff quote or does it just expire?”
✓ Answered — no obligation; quote expires Jun 30. Refi comparison already in the CFO tab; reminder set for Jun 25.

Demo of the conversation feed — in a live engagement this is populated automatically from your email, calls, and meeting notes.

Top 3 Priorities

  1. Vendor strategy meeting within 14 days. Top exposure: Sitwell Enterprises $73,836. Keel will prepare priority list and negotiation playbook.
  2. Post May payroll true-up JE within 7 days. Clears $0 negative payroll liability.
  3. Collect the Sudden Valley underbilling. $14,855 earned but unbilled; progress bill issued June 3 — chase to cash within 14 days.

What we delivered this month

Multi-period context (Jan – May 2026)

→ For interpretation of these trends, see the Controller tab → Insight. For strategic implications and outlook, see the CFO tab → Foresight.

Your engagement at a glance

The Bluth Company runs the full Keel catalog — illustrative pricing.

ServiceScopeMonthlyOne-time setup
BookkeepingAccrual basis · 47 workflows$3,295/mo$2,500
ControllerFull catalog · core included with bookkeeping$4,120/mo$9,800
CFOFull catalog$6,930/mo$21,400
Total$14,345/mo$33,700

Division of labor

From your Business Processes & Procedures worksheet: The Bluth Company approves bills before payment and owns estimates, customer relationships, and the tax return. Keel owns every workflow on the Workflows tab — AP entry and payment runs, invoicing support, payroll journal entries via Gusto, the monthly close, and all reporting.

Engagement status

Active since January 2026 — onboarding complete, all bank and card feeds live, five closed months on file. Open items are tracked on the Notes & Needs tab.

Service Workflow Map

How Keel delivers on the engagement: By Service (the service map — click a category to expand its items), plus project management and implementation views.

By Service

3 service layers · 26 categories · 185 services in your engagement. Card color = layer · count = services within. Click any category to see its individual service items.

Bookkeeping (Accrual)
Hindsight · What happened?
52 services
Daily Transaction Processing
11
Reconciliations
7
Operational Accounting
16
Non-Cash Accounting
8
Month-End Close
5
Compliance Support
5
Controller
Insight · Why did it happen?
67 services
Financial Oversight
8
Cash Flow Management
7
Financial Reporting
5
Job Costing & Project Accounting
8
Inventory & Cost Accounting
8
Revenue & Margin Analysis
6
Labor & Compensation Analysis
6
Advanced Accounting Oversight
7
Process Improvement & Automation
7
Risk & Compliance
5
CFO
Foresight · What should we do next?
66 services
Strategic Planning
7
Forecasting & Budgeting
8
Financial Leadership
5
Financing & Capital Management
8
Pricing & Profitability Strategy
7
Job Costing Strategy
6
Inventory & Supply Chain Strategy
6
Compensation & Workforce Strategy
6
Business Intelligence
7
Mergers, Acquisitions & Exit Planning
6
Bookkeeping — Hindsight: descriptive financial reporting Controller — Insight: diagnostic + performance analysis CFO — Foresight: predictive + strategic advisory

Project Management — Active Initiatives

Kanban view of cross-engagement projects: bookkeeping cleanups, controller setup work, CFO advisory initiatives, and onboarding. Move cards between columns as status changes.

To Do 4
BK MED
Complete Gusto → QBO mapping
Eliminates monthly payroll true-up JE. Configure mapping for Wages, Employer Taxes, WC, Health.
Owner: Keel Due: 14 days
CT MED
Set up QBO job costing structure
Customer:Sub-Customer hierarchy + Class tracking. Required for project margin analysis.
Owner: Keel Due: 60 days
CFO LOW
Build FY2027 annual budget
First annual budget. Revenue plan + expense plan + capex + workforce plan.
Owner: Keel + Owner Due: Q3 2026
BK LOW
Document month-end close SOP
Formal SOP for BD+1 through BD+7 close workflow. Currently informal.
Owner: Keel Due: 30 days
In Progress 3
CFO HIGH
AP crisis — vendor strategy
$164K in 91+ AP. Vendor priority list + payment plan negotiations with top 3 critical subs.
Owner: Client + Keel Due: 14 days
CFO HIGH
Open Grand Harbour Bank banking conversation
Working-capital line or SBA Express term loan. Existing relationship via Grand Harbour Checking 0142.
Owner: Client + Keel Due: 30 days
BK MED
Reclassify $2,190 uncategorized
Build transaction-level list from May 2026 GL for owner review.
Owner: Keel Due: 14 days
Blocked 2
CFO HIGH
Refinance Ameriquest MCA
Blocked on SBA conversation outcome. $101,318 MCA at likely 20-40% effective rate.
Owner: Client + Keel Due: 60 days
BK MED
Workers Comp policy confirmation
Blocked: awaiting client to confirm policy is current. Booked at $4,308.
Owner: Client Due: When updated
Done 4
BK MED
May 2026 monthly close
Books balanced. P&L, BS, CF Statement, GL, AR/AP Aging all produced. Portal delivered.
Owner: Keel Due: Completed 06/09
BK LOW
Process Dec 2025 BS (CF baseline)
Required for Statement of Cash Flows working capital deltas.
Owner: Keel Due: Completed 06/09
Setup LOW
Build engagement portal v1
Reference implementation with all 185 services across BK/CT/CFO layers.
Owner: Keel Due: Completed 06/10
BK DONE
Post April + May payroll JE
Payroll reclassified from Liability into COGS (Wages, Taxes, WC, Health). Balance is $0.
Owner: Client (Owner) Due: Completed 06/11

Implementation Timeline — June through August 2026

3-month roadmap grouped by phase. Each phase has an owner; sub-tasks ladder down within. Bar position shows when work is active.

Workstream
June 2026
July 2026
August 2026
W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
W13
Bookkeeping Cleanup
Keel Bookkeeping
✓ Post Apr+May payroll JE
Reclassify $2,190 uncategorized
Gusto → QBO payroll mapping
Document month-end close SOP
AP Crisis Resolution
Client + Keel CFO
Vendor priority list + outreach
Vendor payment plans (top 3 subs)
Banking & Financing
Client + Keel CFO
Open Grand Harbour Bank banking conversation
SBA Express loan application
Refinance Ameriquest MCA
Controller Infrastructure
Keel Controller
Set up QBO job costing structure
First per-job margin reports
Compliance & Tax
Keel CFO
Q2 tax payment (Jun 15)
Q3 tax payment prep (Sep 15)
FY27 Planning
Keel CFO + Owner
Budget discovery + assumptions
Build FY27 budget
Data as of May 31, 2026 · refreshed Jun 6, 2026

Standard Reporting — May 2026 package

The complete monthly package produced by your bookkeeping engagement — statements, agings, and reconciliation status. Pure facts: interpretation lives on the Controller tab; outlook on the CFO tab.

Period Recap

  • Revenue: $193,897 — below YTD average ($271K/mo); fifth month in a row of declining or flat top line
  • Gross Profit: $30,770 (15.9% margin) — compressed sharply from the Jan–Mar 36–39% band. May margins are well below the Q1 average and consistent with April's loss month — signaling real margin compression, not a one-off.
  • Operating Expenses: $51,254 (26.4% of revenue) — up from 9% in January; fixed costs growing as % of declining revenue
  • Net Income: −$20,485 (−10.6% net margin) — second consecutive loss month (Apr −$49,506). After January's strong $137K, Feb-May has trended progressively weaker.
  • Cash on hand: $83,092 — recovered from the February low of $28K

Close scorecard — May 2026

  • ✓ Close delivered business day 6 (target BD6)
  • ✓ Bank-rule auto-coding: 86% of transactions (41% in January)
  • ✓ Books balanced — assets $473,510 = liabilities + equity
  • ⚠ Reconciliations: bank/CC/loan recons pending statement confirmation (see Recon & Cash)
  • ⚠ Uncategorized: $2,190 (1.1% of revenue) — reclass before June close
Updated from conversations

Your reporting tier PREMIUM — INCLUDED WITH ACCRUAL

TierComes withWhat it includesAsk us anything — we…
StandardCash basisMonthly P&L, balance sheet, cash flow, recon statusAnswer any question about your reports
CustomHybrid basis+ class/department/location views, weekly AR & AP agingsAdjust existing reports on request — re-slice, rename, add a dimension
PremiumAccrual basis+ accrual-grade statements (WIP, prepaids, deferrals), KPI dashboardsBuild new reports & dashboards on request — say it, see it in the portal

Requests arrive by email, call, or meeting — captured automatically, delivered into this portal. Fair-use applies to new-report builds; anything unusual gets scoped before work starts.

“What’s the $18,500 deposit on the 2nd? Don’t recognize it.” Traced same day: Stonegate progress payment, invoice #1247, matched and categorized. Answered — included in every tier.

Call · Jun 3“Can the P&L split coatings out from restoration?” Class structure updated; the June statements arrive split by service line. Adjusted — a Custom-tier request.

“I want a weekly cash-in / cash-out view, one page, every Monday.” New report built and scheduled; first one landed Jun 2. Built new — a Premium-tier request, included on Accrual.

AR Visuals

AR Aging Composition (May)

Customer Concentration (Top 5 + Other)

Accounts Receivable Summary · May 2026

Customer-level AR detail. Top customers shown by total outstanding balance.

5-Month AR Aging Trend

AR built up steadily Jan to Mar as pipeline filled, then collections caught up in Apr/May.

BucketJanFebMarAprMay
Current$0$0$28,227$0$0
1-30 days$7,753$84,938$97,018$127,696$114,849
31-60 days$1,454$7,753$43,627$30,668$36,054
61-90 days$2,708$1,454$7,753$7,556$0
91+ days$0$2,708$2,708$3,882$1,174
Total AR$11,916$96,853$179,333$169,801$152,077
Total AR
$152,077
Current + 1-30
$114,849
31-60 days
$36,054
61-90 days
$0
91+ days
$1,174

Top Customers by Outstanding AR

Customer / ProjectCurrent1-3031-6061-9091+Total
Lucille Austero / Stonegate Management Company$0$39,935$0$0$0$39,935
Rita Leeds / Vista Terrace Homeowners Association$0$31,708$0$0$0$31,708
Maggie Lizer / MRP Property Management$0$10,914$5,784$0$0$16,697
Balboa Marina Estates$0$0$13,455$0$0$13,455
Seaward Commons Apartments$0$0$11,189$0$0$11,189
Steve Holt / Tantamount Residential$0$11,184$0$0$0$11,184
Kitty Sanchez / Northgate Realty Partners$0$10,991$0$0$0$10,991
Gene Parmesan$0$7,380$0$0$0$7,380
Summit Ridge Community Corporation c/o Standpoor Gr$0$0$3,570$0$0$3,570
Ann Veal / Milford Association & Property Manageme$0$2,737$0$0$0$2,737
TIC Marina Point Landing c/o Northgate Realty Partners$0$0$2,056$0$0$2,056
Seaward Commons$0$0$0$0$1,174$1,174

Commentary

AR aging is well-managed. DSO of 23.9 days is excellent (industry norm 30-45 days). The 91+ bucket holds only $1,174 — under 1% of AR. Top customer concentration is moderate.

5-month AR trajectory: $12K (Jan) → $97K (Feb) → $180K (Mar) → $172K (Apr) → $152K (May).

AP Crisis Visuals

5-month AP aging composition. Watch the 91+ band (red) grow as the 30-day bands shrink — that's the crisis developing.

AP Aging Composition (May)

Vendor Concentration (Top 5 + Other)

Accounts Payable Summary · May 2026

Vendor-level AP detail. Top vendors shown by total outstanding balance.

5-Month AP Aging Trend — The Crisis Develops

Total AP roughly stable ($212-410K range), but COMPOSITION shifted dramatically. The 91+ bucket exploded from $80K (Jan) to $164K (May) — visible breakpoint at April.

BucketJanFebMarAprMay
Current$44,632$7,881$16,551$27,829$16,792
1-30 days$68,563$38,259$28,807$34,642$17,581
31-60 days$38,659$46,270$31,845$22,747$16,884
61-90 days$10,467$9,790$47,238$20,960$5,039
91+ days$137,300$109,690$119,481$152,424$163,911
Total AP$299,620$211,891$243,920$258,602$220,208
Total AP
$220,208
Current
$16,792
1-30 days
$17,581
31-60 days
$16,884
91+ days
$163,911
74% of AP

Top Vendors by Outstanding AP

VendorCurrent1-3031-6061-9091+Total
Sitwell Enterprises LLC$0$0$0$0$73,836$73,836
Atlas Building Specialties$6,735$7,761$6,336$507$16,583$37,923
Compass Painting & Construction$0$0$0$4,243$29,236$33,479
Northwind Painting Corp$0$0$0$0$21,637$21,637
Oswald Scaffolding Inc.$0$1,788$10,548$0$0$12,337
Kessler Consulting Group, Inc.$0$0$0$0$10,585$10,585
BLX Supply$0$0$0$289$5,865$6,154
Ferroline$4,554$253$0$0$0$4,806
Keel$0$4,087$0$0$0$4,087
JT Concrete Pumping$0$2,667$0$0$0$2,667
Shoreline Lumber$2,290$81$0$0$0$2,371
Peninsula Paint$1,743$0$0$0$0$1,743
Elgin Construction Services$0$0$0$0$1,570$1,570
Pinnacle Maintenance Service Inc.$0$0$0$0$1,445$1,445
Bayside Mechanical$0$0$0$0$1,296$1,296

Commentary — the AP story

74% of AP ($163,911) is over 90 days old. Top exposure: Sitwell Enterprises at $73,836. The aged balance is concentrated in subcontractors.

5-month AP trajectory: $299K (Jan) → $212K (Feb) → $244K (Mar) → $258K (Apr) → $220K (May).

The strategic implication is on the CFO tab (Strategic Memo · AP Crisis), which traces the April inflection.

P&L Flow — May 2026

Revenue cascades to Net Income through COGS, Gross Profit, and Operating Expenses.

5-Month P&L Trend (Jan – May 2026)

Variance vs. rolling 3-month baseline. Conservative thresholds: Green within ±10% (or ±1pp), Amber 10-20% (or 1-2pp), Red beyond.

Jan 2026Feb 2026Mar 2026Apr 2026May 20263-mo AvgStatus
Revenue$451,093$220,019$296,795$193,884$193,898$236,899−18.2%
COGS$274,124$141,435$180,565$199,343$163,128$173,781−6.1%
Gross Profit$176,968$78,584$116,230−$5,459$30,770$63,118−51.2%
Gross Margin %39.2%35.7%39.2%−2.8%15.9%24.0%-8.1pp
Operating Expenses$40,388$39,294$56,215$44,047$51,254$46,519+10.2%
OpEx as % of Revenue9.0%17.9%18.9%22.7%26.4%19.8%+6.6pp
Net Income$136,580$39,290$60,015−$49,506−$20,485$16,600loss vs +$16.6K avg
Net Margin %30.3%17.9%20.2%−25.5%−10.6%4.1%-14.7pp
Revenue
$193,897
Gross Profit
$30,770
15.9% margin
Operating Expenses
$51,254
26.4% of revenue
Net Income
−$20,485
−10.6% margin

Profit & Loss · May 2026

Accrual basis. Current month (May 2026) + YTD (Jan-May 2026).

Account May 2026 % Rev YTD (Jan-May) % YTD Rev
INCOME
3000 Reconstruction Revenue$144,96374.8%$1,105,16981.5%
3050 Project Support & Compliance$47,47424.5%$247,39418.2%
3100 Business Management & Oversight$1,4600.8%$3,1240.2%
Total Income$193,897100.0%$1,355,688100.0%
COST OF GOODS SOLD
4000 Reconstruction Costs$146,45675.5%$830,17161.2%
4005 Wages - Laborers$12,3546.4%$82,3916.1%
4010 Payroll Taxes-Constr Wages$00.0%$22,5441.7%
4015 Workers Comp Insur-Cosntr$4,3082.2%$21,5441.6%
4020 Health and Accident Ins-Constr$100.0%$1,9450.1%
Total COGS$163,12884.1%$958,59570.7%
GROSS PROFIT$30,77015.9%$397,09329.3%
OPERATING EXPENSES
*Uncategorized Transactions$2,1901.1%$2,1900.2%
6310 Advertising$5,6292.9%$18,4231.4%
8210 Rent-Office$6,1693.2%$24,7851.8%
8230 Repairs and Maint - Office$5840.3%$3,7750.3%
8250 Utilities$1,1000.6%$9,9030.7%
8260 Telephone$990.1%$990.0%
8270 Office Supplies$3,9702.0%$19,0511.4%
8330 Leases-Computer Software$2,4221.2%$12,6170.9%
8410 Vehicles Expenses-Admin$4,1892.2%$18,8661.4%
8460 Travel Expense$1,8661.0%$8,0670.6%
8470 Meals$2,6811.4%$9,7500.7%
8540 License Fees$5260.3%$5260.0%
8690 Insurance-Other$9,2784.8%$47,2733.5%
8710 Accounting Services$4,0272.1%$14,3611.1%
8730 Consulting Services$2,8101.4%$12,1360.9%
8790 Other Professional Services$1,1720.6%$8,0570.6%
8920 Dues and Subscriptions$1,0420.5%$4,4370.3%
8930 Bank Service Charges$4440.2%$2,2850.2%
8770 Recruiting and Hiring-Admin$00.0%$4880.0%
8780 Training and Education-Admin$00.0%$8830.1%
8590 Taxes-Other$00.0%−$3,192−0.2%
8720 Legal Services$00.0%$13,3351.0%
8320 Leases-Computer Eqpt$00.0%$1,1660.1%
Total Operating Expenses$51,25426.4%$231,19917.1%
NET INCOME−$20,485−10.6%$165,89412.2%

Top Expenses

Commentary

May 2026 revenue of $193,897 produced $30,770 in gross profit (15.9%) and −$20,485 in net income (-10.6% margin). Gross margin is strong for a reconstruction contractor.

Revenue mix: Reconstruction Revenue at $144,963 (74.8% of total). Project Support & Compliance $47,474 (24.5%). Business Mgmt & Oversight flat fee $1,460.

Items requiring attention
$2,190 in *Uncategorized Transactions needs reclassification. Workers Comp at $4,308 (1.1% of COGS) is materially low for construction.

Balance Sheet Composition (May 31, 2026)

Asset Composition

Liability + Equity Composition

5-Month Balance Sheet Trend

Month-end positions. Material movements (red/amber) flagged in commentary.

Jan 31Feb 31Mar 31Apr 31May 313-mo AvgStatus
Total Assets$499,043$417,377$546,648$517,807$473,510$493,944−4.1%
Cash on Hand$195,851$28,370$74,742$53,608$83,092$52,240+59.1%
AR Total$11,916$96,853$179,333$169,801$152,077$148,662+2.3%
AP Total$299,620$211,891$243,920$258,602$220,208$238,138−7.5%
Total Liabilities$484,894$390,968$474,833$393,607$271,229$419,803−35.4%
Total Equity$14,150$26,409$71,815$124,200$202,281$74,141+172.8%
Total Assets
$473,510
Total Liabilities
$271,229
57.3% of assets
Total Equity
$202,281
42.7% of assets
Current Ratio
0.79x
Target 1.5-2.0x

Balance Sheet · As of May 31, 2026

Accrual basis. Books are in balance: Total Assets $473,510 = Total Liabilities + Equity $473,510.

AccountAmount% of Assets
CURRENT ASSETS
1000 Grand Harbour Checking (0142)$83,09217.5%
1001 Grand Harbour Checking (0319)$00.0%
1002 Grand Harbour Savings (0026)$00.0%
1010 Petty Cash$00.0%
1072 Bill.com Money Out Clearing$00.0%
Bank Accounts$83,09217.5%
1210 Accounts Receivable$94,92620.0%
Accounts Receivable$94,92620.0%
1430 Employee Loans$3,7960.8%
Undeposited Funds$00.0%
Other Current Assets$3,7960.8%
Total Current Assets$181,81438.4%
FIXED ASSETS
1830 Office Furniture and Equipment$2,5920.5%
1845 Chevrolet Suburban$71,21615.0%
1940 Accum Depreciation-Vehicles$-48,388−7.5%
1840 Vehicles$35,8937.6%
1850 Construction Equipment$171,39236.2%
1950 Accum Depreciation-Constr Eqpt$-50,000−7.7%
1850 Construction Equipment$134,89228.5%
1880 Leasehold Improvements$118,32125.0%
Total Fixed Assets$291,69661.6%
TOTAL ASSETS$473,510100.0%
CURRENT LIABILITIES
2110 Accounts Payable$223,50347.2%
Accounts Payable$223,50347.2%
2135 Capital One Quicksilver (0455)$4,1680.9%
2140 Capital One Quicksilver (0512)$5040.1%
2145 Capital One Venture (0688)$4710.1%
2150 AppleCard (0731)$-5,560−0.9%
2155 Grand Harbour Bank (0287)$6570.1%
2160 Divvy Credit Cards$20,5254.3%
2165 Citi Card (0964)$00.0%
2130 Credit Cards Payable$22,2664.7%
Credit Cards$22,2664.7%
2210 Notes Payable$109,50023.1%
2211 Ameriquest$101,31821.4%
2210 Notes Payable$210,81844.5%
2345 Payroll Liabilities$0Clean
Other Current Liabilities$-21,903−3.4%
Total Current Liabilities$229,78048.5%
LONG-TERM LIABILITIES
2520 Auto Loan$41,4498.8%
Total Long-Term Liabilities$41,4498.8%
TOTAL LIABILITIES$271,22957.3%
EQUITY
2960 Distributions,Div., and Draws$-253,415−39.1%
2920 Retained Earnings$-9,787−1.5%
Net Income$165,89483.3%
TOTAL LIABILITIES + EQUITY$473,510100.0%

Asset Composition

Commentary & Critical Findings

Total assets $473,510 = Total L+E $473,510. Books balance. Working capital is negative ($-65,707) primarily because of the resolvable negative payroll liability.

!
CRITICAL findings
Payroll Liabilities $0 — clean. AP $223,503 + Notes Payable $210,818 dominate current liabilities — see Cash Flow Report. Ameriquest $101,318 needs documentation review (likely high-rate MCA).

⚠ Additional information needed

  • Apr 2026 Balance Sheet for MoM comparison columns
  • Dec 2025 YE Balance Sheet for YoY trend
  • Ameriquest loan documentation (rate, term, schedule)
  • Depreciation schedule for fixed assets

Cash Flow Visuals

Cash on Hand Trend

Cash Flow Waterfall (May)

5-Month Statement of Cash Flows Trend (Jan – May 2026)

Cash flow computed from Net Income + Balance Sheet movements. Operating + Investing + Financing should equal the actual cash change. Differences indicate non-cash items (depreciation, accruals) or unmodeled changes.

Cash Flow ComponentJan 2026Feb 2026Mar 2026Apr 2026May 2026YTD (Jan-May)
Net Income$136,580$39,290$60,015−$49,506−$20,485$165,894
Adjustments to reconcile NI to cash:
Change in AR−$10,620−$116,354−$112,986$9,532$74,875−$124,333
Change in AP$13,145−$120,178$32,029$14,682−$48,081−$86,262
Change in Credit Cards$6,381$10,678−$5,878$3,119−$2,165$14,305
Change in Payroll Liabilities−$39,123$0$0−$157,148−$153,548−$349,819
Cash from Operations$119,793$166,623$6,442$46,833$25,652$226
Investing Activities
Change in Fixed Assets (net)−$3,485−$0−$575−$0−$0−$4,060
Cash from Investing−$3,485−$0−$575−$0−$0−$4,060
Financing Activities
Change in Debt (Notes + Loans)−$23,115−$23,115$56,126$15,691$26,392$64,462
Owner Distributions/Contributions−$1,262−$37,028−$20,012−$19,422−$19,026−$96,751
Cash from Financing−$24,377−$60,143$41,517$1,513$12,503−$8,447
NET CHANGE IN CASH (computed)$99,454$226,766$47,541$44,761$38,154$12,733
Actual cash change (from BS)$99,454−$229,426$46,373−$28,951$29,483−$18,226

Commentary

The Statement of Cash Flows tells the operational story. Key observations across the period:

  • Operating cash is volatile: ranged from $-168,083 (Feb) to $18,076 (May)
  • AR change is consistently negative through Feb-Apr (cash tied up in receivables as pipeline grew)
  • AP change reveals the deferral pattern: increases in AP balance = source of cash that masked operational cash demand
  • Financing activity: track changes in notes payable for the lender conversation context
Reconciliation gaps
Where "Net Change in Cash (computed)" differs from "Actual cash change", the delta represents non-cash items not captured in this simplified model: depreciation, amortization, accrued/deferred items, and other balance sheet movements outside the main AR/AP/Debt/Equity buckets. A full reconciliation would be part of the formal Cash Flow Statement (XLSX deliverable).

Reconciliation Status · As of May 31, 2026

Status of all bank, credit card, loan, payroll, and other reconciled accounts at month-end.

AccountTypeReconciled ThroughStatusNotes
1000 Grand Harbour Checking (0142)Bank05/31/2026Recon pendingActivity confirmed in GL; bank statement match pending
1001 Grand Harbour Checking (0319)BankRecon needed$0 balance; confirm if active
1002 Grand Harbour Savings (0026)BankRecon needed$0 balance; confirm if active
1010 Petty CashBankRecon neededConfirm if active
1072 Bill.com Money Out ClearingClearing05/31/2026Confirm zeroClearing accounts should zero at month-end
2130 Credit Cards (7 cards)Credit Card05/31/2026Recon pendingTotal $22,266; per-card recon to lender statements
2210 Notes Payable (multiple)LoanSchedule neededIncluding Ameriquest MCA $101,318
2345 Payroll LiabilitiesPayroll✓ Clean$0 balance
2520 Auto LoanLoanSchedule neededAmortization schedule should match BS $41,449

Open Items

Uncategorized Transactions of $2,190
Review and reclassify each transaction in this account.

⚠ Additional information needed

  • Bank statements: Grand Harbour Checking (0142), any active Grand Harbour accounts
  • Credit card statements: all 7 card accounts
  • Lender statements/amortization schedules: Auto Loan, 2210 Notes Payable, 2211 Ameriquest
  • Payroll provider reports (Gusto): May 2026 — needed for COGS labor reconciliation
  • Confirmation of which 0-balance bank accounts are still active vs. closed
Data as of May 31, 2026 · refreshed Jun 6, 2026

Controller — insight layer · May 2026

Why the month happened the way it did. The facts are in Standard Reporting; the strategic outlook is on the CFO tab. This is the "why" in between.

Soundings — why the month went the way it did

Bluth had two consecutive loss months. April lost $49,506 (NI) on a -2.8% GM; May lost $20,485 on a 15.9% GM. YTD Net Income of $165,894 is carried almost entirely by January's strong $137K month — Feb through May trended progressively weaker.

The pattern points to a labor utilization problem: revenue dropped 57% from January's $451K to May's $194K, but COGS did not scale down in proportion. April's COGS ($199K) exceeded revenue ($194K) — meaning labor and material were committed to projects that didn't bill. May's partial GM recovery (from -2.8% to 15.9%) came from a $36K COGS reduction, not new revenue.

What's needed: Job costing (/Bosun) is the diagnostic — it will tell whether April was one bad project, a project gap that left crews idle, or systemic margin erosion across all work. Without job-level data, we're working from totals. Bid pipeline visibility (/Bosun + CRM data) determines whether the revenue softness is demand-side or capacity-side.

Updated from conversations

Call · Jun 3Owner suspected Crew C. Confirmed: 61% utilization vs the 78% target — standby time costs ≈$6,800/mo in unabsorbed labor. Deployment fix live under Labor & Compensation; re-sounded at the June close.

Grand Harbour Bank asked about the Sudden Valley overrun. Close-review note added: change-order documentation on remaining phases moves to dual sign-off until the recovery plan proves out.

Controller layer — now running

Job costing & WIP scheduleLive — net overbilled +$8,445 (cash-favorable)
Labor burden on jobs24% applied from May close
Field utilization71% vs 78% target — Crew C the drag
Internal controlsDual approval · 3-way match · June review clean
Policies & SOPsManual v1.0 · 4 of 6 SOPs

Detail lives under the category pills above — every line links to a delivered service item.

Margin Trajectory — 5-Month Path

Five-month margin path: Jan 39.2% → Feb 36.4% → Mar 38.8% → Apr -2.8% → May 15.9%. The Q1 plateau collapsed in April; May partial recovery still well below band. Pattern signals real margin compression, not a one-off project anomaly.

Why each line moved

MetricMayWhy it looks this way
Revenue$193,897Flat vs Apr ($194K). Two months in a row of declining demand from the Jan peak ($451K). Job pipeline slowed.
Gross Profit %15.9%Well below the Jan-Mar 36-39% band. Recovered from April's loss but still less than half of Q1 levels — real margin compression.
OpEx % of Revenue26.4%Up from 9% in January. Fixed costs same, revenue declining → ratio rising mechanically.
Net Income−$20,485Confirmed loss. Two consecutive loss months (Apr −$49,506 May −$20,485). YTD NI of $165,894 driven almost entirely by January.
Cash on Hand$83,092Recovered from Feb low ($28K). AR collections improved; AP catch-up has not happened.
DSO23.9 daysExcellent. Customers paying on cycle.
DPO41 daysThe central diagnostic is aging, not pace. Vendors funding Bluth — pace looks normal (≈41 days) while 74% of AP sits 91+ days old.

5-Month Revenue & Net Income Trajectory

Pipeline slowdown is independent of the accounting issue — see the consistent decline from Jan.

Variances vs. the 3-month baseline

  • Revenue down 39.9% vs baseline ($323K avg → $194K actual). Material.
  • Gross Profit dropped to $30,770 in May (down from $177K Jan) — a true 83% decline. Apr was −$5,458 (negative GP). This is the central operational concern now.
  • OpEx within tolerance (-2.8% vs baseline). Fixed-cost discipline is fine; the issue is on the revenue and COGS-recognition sides.
  • Cash down 46.2% vs baseline — recovered but not back to Jan levels.
  • AR up 76.8% vs baseline (working capital tied up in active project receivables).
  • DPO blew out by +92 days vs baseline. This is the working capital crisis.

What the patterns tell us

  • 1. Payroll JE posted ✓. April + May payroll moved into COGS. Books now reliable. The diagnostic shifts to operational concerns below.
  • 2. The April DPO inflection (33→94 days) is not random. Something happened operationally — cash demand spiked or collections lagged. Diagnostic conversation with owner needed.
  • 3. Top-vendor concentration is real risk: Sitwell Enterprises alone is $74K of the $164K 91+ AP. Single relationship can derail the project pipeline.
  • 4. Revenue trajectory shows pipeline slowdown. Five months down or flat. This is independent of the accounting issue and warrants a sales-pipeline review.
  • 5. The Ameriquest MCA ($101,318) is the most expensive piece of debt. Likely 20-40% effective rate. Refinance candidate.

→ For the forward outlook, the decisions needed, and the strategic plan, see the CFO tab → Foresight.

Financial Oversight

8 services in this category — Bluth engagement.

/Bosun

Review financial statement accuracy

Active
/Bosun

Review reconciliations

Active
/Bosun

Review journal entries

Active
/Bosun

Supervise bookkeeping staff

Active
/Bosun

Establish accounting policies

Active
/Bosun

Establish month-end close procedures

Active
/Bosun

Implement internal controls

Active
/Bosun

Develop accounting SOPs

Active

Cash Flow Management

7 services in this category — Bluth engagement.

/Bosun

Monitor cash position

Active
/Bosun

Monitor working capital

Active
/Bosun

Manage AR aging

Active
/Bosun

Manage AP aging

Active
/Bosun

Improve collections processes

Active
/Bosun

Optimize payment timing

Active
/Bosun

Prepare short-term cash forecasts

Active

Financial Reporting

5 services in this category — Bluth engagement.

/Lookout

Create management reporting packages

Active
/Lookout

Develop KPI dashboards

Active
/Lookout

Prepare departmental reporting

Active
/Lookout

Prepare board reporting

Active
/Lookout

Develop operational scorecards

Active

Job Costing & Project Accounting

8 services in this category — Bluth engagement.

/Bosun

Review job profitability

Active
/Bosun

Analyze project margins

Active
/Bosun

Monitor labor utilization

Active
/Bosun

Review burden allocation

Active
/Bosun

Review WIP schedules

Active
/Bosun

Analyze overbilling and underbilling

Active
/Bosun

Monitor project performance

Active
/Bosun

Review change order profitability

Active

Inventory & Cost Accounting

8 services in this category — Bluth engagement.

/Bosun

Inventory valuation oversight

Active
/Bosun

Inventory turnover analysis

Active
/Bosun

Shrinkage analysis

Active
/Bosun

Cost accounting oversight

Active
/Bosun

Gross margin analysis

Active
/Bosun

Product profitability analysis

Active
/Bosun

Purchasing trend analysis

Active
/Bosun

Inventory control procedures

Active

Revenue & Margin Analysis

6 services in this category — Bluth engagement.

/Bosun

Customer profitability analysis

Active
/Bosun

Product profitability analysis

Active
/Bosun

Service line profitability analysis

Active
/Bosun

Gross margin reporting

Active
/Bosun

Revenue trend analysis

Active
/Bosun

Pricing analysis

Active

Labor & Compensation Analysis

6 services in this category — Bluth engagement.

/Bosun

Contractor cost analysis

Active
/Bosun

Labor efficiency analysis

Active
/Bosun

Departmental labor reporting

Active
/Bosun

Commission reporting

Active
/Bosun

Compensation analysis

Active
/Bosun

Workforce utilization reporting

Active

Advanced Accounting Oversight

7 services in this category — Bluth engagement.

/Bosun

Review accrual accounting

Active
/Bosun

Review revenue recognition

Active
/Bosun

Review non-cash transactions

Active
/Bosun

Review depreciation schedules

Active
/Bosun

Review fixed asset accounting

Active
/Bosun

Review debt schedules

Active
/Bosun

Review prepaid and deferred accounts

Active

Process Improvement & Automation

7 services in this category — Bluth engagement.

/Bosun

Workflow development

Active
/Bosun

Accounting system optimization

Active
/Bosun

Software implementation

Active
/Bosun

Process documentation

Active
/Bosun

Automation implementation

Active
/Bosun

Reporting automation

Active
/Bosun

Integration management

Active

Risk & Compliance

5 services in this category — Bluth engagement.

/Bosun

Fraud prevention controls

Active
/Bosun

Segregation of duties

Active
/Bosun

Documentation standards

Active
/Bosun

Audit preparation

Active
/Bosun

Regulatory compliance monitoring

Active
Data as of May 31, 2026 · refreshed Jun 6, 2026

CFO — plan vs. actual · May 2026

Strategic outlook and the decisions ahead. The facts are in Standard Reporting; the diagnosis is on the Controller tab. This is the "what next."

Heading — the course from here

Three levers, worked in order: restore revenue to the $292K+/mo Q1 baseline (requires bid-pipeline visibility), cut fixed costs to fit the $194K/mo run-rate, and bridge the working-capital gap with a ≈$164K term facility while the first two take hold.

The decisions and forecasts below put dates and owners on each — vendor triage within 14 days, the financing conversation within 30, job costing live within 30.

Updated from conversations

Meeting · May 28Truck-fleet acquisition (≈$210K, financed) modeled into the 13-week and the capital plan: DSCR would move 1.61 → ≈1.38 — still above the proposed 1.25 covenant, but it consumes the growth tranche for FY27. Framed as a decision for the Jul 14 strategic review; scope flag already in Notes & Needs.

Ameriquest payoff quote expires Jun 30 — refinance decision pulled ahead of expiry on the decision calendar. At ≈$2,100/mo saved, waiting past the quote costs real money.

Adopted this quarter

Pricing cardMarkups 42 / 48 / 35% · 30% GM walk-away floor
Capital allocation40/40/20 after a $100K cash floor · distributions paused
Revenue forecast$3.4M FY26 pipeline-weighted · $5.2M FY27 target
Ameriquest MCA refinanceIn motion — saves ≈$2,100/mo
Incentive bonus planApproved June 1

The Working Capital Chasm — Visualized

What's available (Cash + collectible AR) vs what's owed (AP 91+). The gap is the financing requirement.

/Navigator The decisions ahead

DecisionTimingOwner
Vendor strategy meeting — prioritize critical subsWithin 14 daysClient + Keel
Begin SBA Express / term-loan conversation with Grand Harbour BankWithin 30 daysClient + Keel
Refinance Ameriquest MCA30–60 daysClient + Keel
Set up QBO job costing structure60–90 daysKeel
Build annual budget (FY2027)Q3 2026Client + Keel

Decisions Timeline — Next 90 Days

Sequenced by urgency and dependency. Bars show timing windows; red = must-start-now, amber = within 30, green = 60-90 days out.

/Navigator 13-week cash position outlook

Modeled three scenarios against the post-JE cost base (full detail in CFO → Forecasting & Budgeting → Cash flow forecasting):

  • Status Quo: Treading water. Two cash-low weeks (Wk 1 $30K and Wk 3 $31K, both below $36K target). Ends Wk 13 at ~$78K — essentially the same as starting. AP 91+ days backlog of $164K stays unpaid → vendor risk persists.
  • Cash AP Catch-up: Not feasible from operations. Even at $11K/week vendor catch-up rate, cash goes negative by Wk 3 and crashes to $(88K) by Wk 13. Bluth cannot pay down 90+ days AP without external capital.
  • Financed Catch-up: $164K SBA term loan: $146K pays down 90+ days AP immediately in Wk 1, $18K stays as buffer. Loan service ~$0.88K/week starts Wk 5. Ends Wk 13 at ~$88K with vendors current and a clean BS — trades vendor risk for serviced lender debt.

90-day Outlook

  • Expected revenue at run rate: ~$584K over the next 90 days (±20% on project timing)
  • Expected EBITDA: $146–250K assuming pipeline holds and pricing intact
  • Cash position: WILL deteriorate further if AP backlog is not addressed — pure math: $78K/mo recurring outflow against intermittent AR collection
  • Key inflection: end of Q2 close + execution of vendor settlement plan

Forward strategic themes

  • Working capital first. Until DPO is back under 90 days, every other strategic conversation is constrained.
  • Debt structure second. Ameriquest MCA is the most expensive obligation. Term-loan refinance frees $3–7K/month.
  • Job costing third. Until per-project margins are visible, pricing, bid strategy, and customer profitability discussions are unfounded.
  • Pipeline fourth. Five months of declining/flat revenue is a separate concern from the AP crisis. Sales-pipeline review when working capital is stable.

→ For the diagnostic of what happened, see the Controller tab → Insight. For the descriptive recap, see Standard Reporting → Hindsight.

Strategic Planning

7 services in this category — Bluth engagement.

/Navigator

Long-term financial planning

Active
/Navigator

Strategic growth planning

Active
/Navigator

Scenario planning

Active
/Navigator

Business model analysis

Active
/Navigator

Risk assessment

Active
/Navigator

Strategic initiative evaluation

Active
/Navigator

Capital allocation planning

Active

Forecasting & Budgeting

8 services in this category — Bluth engagement.

/Navigator

Annual budgeting

Active
/Navigator

Rolling forecasts

Active
/Navigator

Revenue forecasting

Active
/Navigator

Expense forecasting

Active
/Navigator

Cash flow forecasting

Active
/Navigator

Workforce planning

Active
/Navigator

Capital expenditure forecasting

Active
/Navigator

Inventory forecasting

Active

Financial Leadership

5 services in this category — Bluth engagement.

/Navigator

Executive leadership participation

Active
/Navigator

Board meeting participation

Active
/Navigator

Ownership advisory

Active
/Navigator

Strategic planning facilitation

Active
/Navigator

Departmental financial leadership

Active

Financing & Capital Management

8 services in this category — Bluth engagement.

/Navigator

Banking relationships

Active
/Navigator

SBA financing support

Active
/Navigator

Debt restructuring

Active
/Navigator

Line of credit management

Active
/Navigator

Investor reporting

Active
/Navigator

Capital raise support

Active
/Navigator

Loan covenant monitoring

Active
/Navigator

Capital structure planning

Active

Pricing & Profitability Strategy

7 services in this category — Bluth engagement.

/Navigator

Pricing strategy development

Active
/Navigator

Customer profitability strategy

Active
/Navigator

Product profitability strategy

Active
/Navigator

Service line profitability strategy

Active
/Navigator

Market expansion analysis

Active
/Navigator

Acquisition analysis

Active
/Navigator

Investment analysis

Active

Job Costing Strategy

6 services in this category — Bluth engagement.

/Navigator

Bid strategy development

Active
/Navigator

Project pricing models

Active
/Navigator

Capacity planning

Active
/Navigator

Labor deployment strategy

Active
/Navigator

Contract profitability analysis

Active
/Navigator

Expansion planning

Active

Inventory & Supply Chain Strategy

6 services in this category — Bluth engagement.

/Navigator

Inventory investment strategy

Active
/Navigator

Working capital optimization

Active
/Navigator

Supply chain analysis

Active
/Navigator

Purchasing strategy

Active
/Navigator

Inventory financing analysis

Active
/Navigator

Inventory reduction initiatives

Active

Compensation & Workforce Strategy

6 services in this category — Bluth engagement.

/Navigator

Commission plan design

Active
/Navigator

Bonus plan design

Active
/Navigator

Contractor versus employee analysis

Active
/Navigator

Organizational design

Active
/Navigator

Workforce scaling strategy

Active
/Navigator

Compensation benchmarking

Active

Business Intelligence

7 services in this category — Bluth engagement.

/Lookout

Driver-based forecasting

Active
/Lookout

Financial modeling

Active
/Lookout

Sensitivity analysis

Active
/Lookout

Break-even analysis

Active
/Lookout

Unit economics

Active
/Lookout

Customer lifetime value analysis

Active
/Lookout

Strategic KPI development

Active

Mergers, Acquisitions & Exit Planning

6 services in this category — Bluth engagement.

/Navigator

Business valuation support

Active
/Navigator

Due diligence support

Active
/Navigator

Acquisition analysis

Active
/Navigator

Exit planning

Active
/Navigator

Succession planning

Active
/Navigator

Sale preparation

Active

Notes & Needs

Open items, missing data, decisions pending. Use Move to reassign, Mark Complete to close. Categories collapse and persist across reloads.

Client Action Required 6

NN-202605-04MEDIUM
Confirm Workers Comp policy is current. Booked at $4,308 (1.1% of COGS).
Opened: 06/10/26Awaiting Client
NN-202605-05MEDIUM
Upload Ameriquest loan documentation for $101,318 balance.
Opened: 06/10/26Awaiting Client
NN-202605-06MEDIUM
Upload April 2026 Balance Sheet for Cash Flow Statement + comparative analysis.
Opened: 06/10/26Awaiting Client
NN-202605-07MEDIUM
Upload annual budget (if exists) for Budget vs Actual reporting.
Opened: 06/10/26Awaiting Client
NN-202605-10LOW
Set up QBO classes/jobs to enable granular Job Costing Reports.
Opened: 06/10/26Awaiting Client

Keel Internal 95

General 4

Controller 9 categories

CFO 10 categories

✓ Completed Items 0 click to expand