Creekside Overhead Doors
May 2026 Financial Insights
Prepared by Prosynergy
Create Value to reduce suffering and restore human flourishing
Incorrect password. Please try again.
This report contains confidential financial information.
Prosynergy
Bookkeeping with purpose

May 2026 Insights for Creekside Overhead Doors

Prepared by Krishna  ·  Prosynergy Bookkeeping

Video Walkthrough
Key Metrics — May 2026
Revenue
$70,360
↑ +14.2% vs April
Net Income
−$163,088
↓ Inventory timing — see insights
Cash in Bank
$81,500
↓ −$71,992 vs April
Profit Quality Score
0.32
Cash losses lighter than accounting losses
"May was a month of heavy outlays staged for future installs — but with $218,855 sitting 60+ days past due, the real test is whether receivables convert before the cash cushion runs dry."
Three Power Insights

The Books Look Worse Than the Business Is — For Now

The −$163,088 net loss looks alarming, but it's timing, not trouble. Creekside bought about $192,000 in doors and openers in May for jobs not yet installed or invoiced. The income to cover them is sitting in the pipeline — the risk is just the gap between cash out and revenue back.

Track which May purchases are tied to which scheduled June installs so the margin story closes cleanly next month.

$218,855 Is More Than 60 Days Overdue

85.4% of A/R ($256,165) is past 60 days. Top exposures: Martins Construction $31,300, Jeff Mlinek $22,540, Michael O'Neill $17,870, Dale Harris $12,500. With cash down $72,000 this month, how fast these collect sets how long you can keep spending at this pace.

By June 15 — personally contact every balance over $5,000 that is 91+ days old. That's approximately $78,000 across roughly 10 customers.

Cash Is Declining — But Still Manageable. Watch June Closely.

Cash ended May at $81,500, down from $153,500 in April. The current ratio is still healthy at 4.52 and there's no long-term debt — a genuine strength. But cash has fallen in three of the last four months. June depends on how much May inventory converts to invoiced revenue and how hard the 91+ day A/R gets collected.

Set a June cash floor target of $60,000 minimum and review weekly. If collections don't recover cash above $100,000, revisit July inventory purchase pace.
Profit & Loss Summary — 4-Month View
Line Item Feb 2026 Mar 2026 Apr 2026 May 2026 4-Mo Avg
Income
Revenue $153,232$216,712$61,615 $70,360 $125,480
Cost of Goods Sold
Total COGS $72,599$91,004$155,789 $217,892 $134,321
Gross Profit $80,633 $125,707 −$94,174 −$147,532 −$8,842
Gross Margin % 52.6% 58.0% −152.8% −209.7% −63.0%
Operating Expenses
Advertising$240$197$218$240$224
Auto Expense$4,318$2,761$3,564$7,609$4,563
Computer / Internet$20$20$284$20$86
Insurance——$147$147$74
Office / Software$158$951$873$660$661
Accounting Fees$285$285$285$285$285
Licenses / Tolls—$375$705$497$394
Admin Wages—$1,752$3,217$3,519$2,122
Admin Owner GIP——$6,400$1,600$2,000
Professional Fees$554$63$913$299$457
Equipment & Tools$997$417$159—$393
Building R&M——$1,090—$273
Telephone$414$469$414$536$458
Utilities$232$195$173$143$186
Other$16$158$628$2$201
Total Operating Expenses $7,234$7,644$19,069$15,556 $12,376
Net Income $73,399 $118,063 −$113,243 −$163,088 −$21,217
Net Margin % 47.9% 54.5% −183.8% −231.8% −78.3%
Cash Flow — Where Did the Money Go?
What This Means
COGS front-loaded the month
$161k in doors & openers purchased for future installs — not current-month revenue. This is the single largest driver of the cash decline.
A/R collections offset the spend
$90,767 collected from prior customer invoices — without this, ending cash would have been near zero.
Customer deposits building
$19,250 in new down payments received — confirmed future work on the books.
Cash declined $72k in one month
Not a crisis — no debt, strong current ratio — but the direction requires June to reverse.
Undeposited payments grew
$14,130 more cash sitting in the pipeline at month-end — collected but not yet hit the bank account.
Key Accounts Snapshot — May 2026
Financial Health Ratios
Current Ratio
4.52
Healthy (threshold: >1.5). Strong buffer — current assets cover liabilities more than 4× over, even after the cash decline.
Quick Ratio
4.24
Healthy (threshold: >1.0). Liquid assets comfortably cover all current obligations without needing to sell inventory.
DSO (Days Sales Outstanding)
109 days
Concern (threshold: <45 days). Customers are taking nearly 4 months to pay on average. Collections need active attention now.
Debt Service Coverage
N/A
No formal debt service. Zero long-term loans on the balance sheet — a genuine financial strength that protects cash flow flexibility.
Looking Ahead
Before Next Month
The Event
The ~$192,000 in May inventory (Clopay doors + Action Industries openers) should fuel June installs and revenue. If jobs install on schedule, June swings the P&L back positive.
Estimated Impact
If 60–70% of that inventory converts to completed jobs, June revenue could reach $120,000–$140,000 and gross margin should return positive.
One Action Item
By June 15 — contact every A/R balance over $5,000 that is 91+ days old. That's roughly $78,000 across about 10 customers, and a focused week of calls could move the July cash position.
Let's Discuss
Right now, materials bought for future jobs are expensed straight to COGS when purchased — that's what's driving the big monthly margin swings. We'd like to talk about capitalizing these to an Inventory or Work-in-Process account instead, releasing them to COGS only as jobs complete. That would smooth out the P&L so each month reflects actual job profitability. We'll want to confirm this fits your CPA's tax approach before changing anything — can we set up a quick call?
How helpful was this month's review?
★ ★ ★ ★ ★
Tap a star to submit your rating. Takes 5 seconds.
This report is prepared for informational purposes only based on data provided by the client. Prosynergy Bookkeeping is not a licensed CPA firm. This report does not constitute tax, legal, or financial advice. Consult a qualified professional for guidance on financial decisions.
Prosynergy Bookkeeping  ·  May 2026  ·  Creekside Overhead Doors  ·  Prepared by Krishna