๐Ÿ“Š CFO Report Suite โ€” Dwad Lane

9 reports ยท 1,885 transactions ยท Jun 9, 2026 ยท finance.db

๐Ÿ”ฅ Burn Rate & Cash Runway
How fast you're spending, and how long your current savings lasts at that rate. Excludes the Janโ€“Mar medical emergency spike โ€” uses a "normal" baseline instead.
Cash on Hand
โ‚ฑ1,098,166
UB Savings ยท live balance
Avg Monthly Burn (all-in)
โ‚ฑ434,056
6-month avg incl. medical emergency
Normal Monthly Burn
โ‚ฑ225,311
Excl. Janโ€“Mar medical payoffs
Runway (Normal Burn)
4.9 mo
At โ‚ฑ225K/mo ยท to zero, no income
Break-Even Income Needed
โ‚ฑ225,311
Per month to stop drawing down
Current Monthly Income
~โ‚ฑ0
No recurring confirmed โ€” AR pending
Monthly Outflows โ€” UB Savings
Green = money in. Red = money out. The Feb โ‚ฑ1M+ green spike was Gerry's consulting payment covering medical bills.
โš ๏ธ No confirmed recurring income right now. Both invoices (โ‚ฑ371K total) are overdue and uncollected. At โ‚ฑ225K/mo normal burn, you have ~4.9 months of runway from savings alone โ€” assuming nothing breaks and no big surprises.
๐ŸŽฏ Break-even target: โ‚ฑ225K/mo (~$4,000 USD) recurring would stop savings drawdown completely. fCAIO at โ‚ฑ167K/mo + one more client covers it.
Runway Scenarios
How long savings lasts depending on what income arrives.
ScenarioMonthly IncomeNet BurnRunway
Zero income (worst case)โ‚ฑ0โˆ’โ‚ฑ225,311/mo4.9 months
Both invoices collected + no new workโ‚ฑ371,255 (one-time)โˆ’โ‚ฑ225,311/mo6.5 months
fCAIO (VGL) paying monthlyโ‚ฑ167,000/moโˆ’โ‚ฑ58,311/mo18.8 months
fCAIO + Gerry Lane Holdingsโ‚ฑ350,000/mo+โ‚ฑ124,689/moโˆž (growing)
$5K/mo target hitโ‚ฑ280,000/mo+โ‚ฑ54,689/moโˆž (growing)
๐Ÿ’ฐ Income Concentration Risk
Where your money actually comes from. Single-client dependency = the most dangerous financial risk for a solopreneur. If one source stops, everything stops.
Income Sources (Active)
2
Gerry (LHO) + Virginia (VGL) โ€” both Lane family
Single-Family Dependency
100%
All PHP income is Lane family money
Largest Single Inflow
โ‚ฑ1,000,000
Feb 19 consulting payment from Gerry
Total Income (6 months)
โ‚ฑ1,902,462
All sources Dec 2025โ€“May 2026
Income by Source
Percentage of total 6-month income by origin.
Income Timeline
When money actually arrived vs. when it was expected.
DateSourceAmount
Dec 26, 2025INREM โ€” Int'l wire
OCBC SGD or ING AUD
โ‚ฑ291,900
Feb 4, 2026Instapay โ€” Gerry
Mold inspection reimbursement
โ‚ฑ39,200
Feb 19, 2026Instapay โ€” Gerry
Lane Holdings consulting
โ‚ฑ1,000,000
Dec 26, 2025INREM โ€” Int'l wire #2โ‚ฑ120,000
Apr 28, 2026Instapay 0005123287
Source unconfirmed โ“
โ‚ฑ290,000
Apr 28, 2026INREM PCHC
Int'l wire โ€” source unconfirmed โ“
โ‚ฑ120,000
May 6, 2026Instapay โ€” Gerry
Apr 27 reimbursement bundle
โ‚ฑ160,581
Risk Assessment
RiskSeverityCurrent StateMitigation
Single-family dependencyCRITICAL100% of PHP income from Lane familyfCAIO external clients = priority #1
Irregular income timingHIGHNo predictable monthly payment dateInvoice net-30 terms + follow-up cadence
No retainer structureMEDIUMProject-based billing, not recurringPropose monthly retainer to Gerry/Virginia
FX exposure (AUD/SGD)MEDIUMInt'l inflows in foreign currencyTime conversions โ€” balance TBD
Upwork income near zeroLOWโ‚ฑ135 YTD โ€” effectively dormantNot a priority โ€” fCAIO is the path
๐Ÿšจ The core risk: If Gerry stops paying (family business decision, cash flow issue, or relationship friction), your PHP income hits zero overnight. The โ‚ฑ371K in overdue invoices is already a warning sign โ€” 30 days with no response isn't normal for a healthy client relationship.
๐Ÿ’ณ Credit Card Debt Payoff Projector
Move the slider to see how long it takes to clear the UB CC balance at different monthly payment amounts. UB Cashback Platinum charges ~3.5%/month interest on the outstanding balance.
UB CC Balance
โ‚ฑ183,431
Outstanding as of May 2026
Monthly Interest Rate
3.5%
~42% APR ยท typical PH CC rate
Interest Burn YTD (UB)
โ‚ฑ22,812
Janโ€“May 2026 ยท โ‚ฑ4,562/mo avg
Min to Beat Interest
โ‚ฑ6,420
3.5% ร— โ‚ฑ183,431 โ€” just to not grow
Interactive Payoff Calculator
How long to clear โ‚ฑ183,431 at different monthly payment amounts?
Months to Clear
โ€”
Total Interest Paid
โ€”
Debt-Free Date
โ€”
Quick Scenario Comparison
StrategyMonthly PaymentMonthsTotal InterestVerdict
Minimum (interest only)โ‚ฑ6,420Never clearsโˆžTrap
Slow payโ‚ฑ10,00029 monthsโ‚ฑ102,000Expensive
Moderateโ‚ฑ20,00012 monthsโ‚ฑ52,000Acceptable
Aggressiveโ‚ฑ50,0004 monthsโ‚ฑ14,000Good
Full lump sum nowโ‚ฑ183,4311 monthโ‚ฑ0Best ROI
๐Ÿ’ก Lump sum is the highest-ROI move available to you right now. Paying โ‚ฑ183,431 from savings today saves ~โ‚ฑ52,000+ in future interest โ€” a guaranteed 28% return on that money. Once both invoices clear, this should be the first allocation.
๐Ÿ“ˆ Spending Trend by Category
Month-over-month movement across all spending categories. Based on CC statements (SB + UB). Medical excluded from the trend chart โ€” it's a one-time event that distorts everything.
Category Trend (Excl. Medical) โ€” Janโ€“May 2026
Month-by-Month Breakdown
CategoryJanFebMarAprMayTrend
Grabโ‚ฑ30,961โ‚ฑ23,093โ‚ฑ31,737โ‚ฑ10,765โ‚ฑ13,762โ†“ Down
Subscriptionsโ‚ฑ17,190โ‚ฑ20,411โ‚ฑ53,554โ‚ฑ51,760โ‚ฑ29,508โ†‘โ†“ Volatile
Diningโ‚ฑ13,071โ‚ฑ17,443โ‚ฑ24,017โ‚ฑ0โ‚ฑ0? Unclear
CC Interestโ‚ฑ9,192โ‚ฑ10,748โ‚ฑ11,943โ‚ฑ9,536โ‚ฑ13,375โ†‘ Creeping
Shoppingโ‚ฑ33,320โ‚ฑ13,391โ‚ฑ4,957โ‚ฑ13,394โ‚ฑ7,577โ†“ Down
Businessโ‚ฑ0โ‚ฑ320โ‚ฑ6,039โ‚ฑ26,856โ‚ฑ998โ†‘ Spiked Apr
Travelโ‚ฑ0โ‚ฑ0โ‚ฑ22,705โ‚ฑ6,899โ‚ฑ0Seasonal
Insuranceโ‚ฑ2,227โ‚ฑ2,440โ‚ฑ861โ‚ฑ841โ‚ฑ1,441Stable
โš ๏ธ CC Interest is the only category trending upward consistently. Every other category is flat or declining โ€” but interest keeps climbing. This is the one line item that compounds against you the longer the CC balance sits unpaid.
๐Ÿ“Œ Subscriptions spiked Marโ€“Apr because several annual renewals hit (Kubera โ‚ฑ15K, Evernote โ‚ฑ13K, Tradeify โ‚ฑ13K). The May drop-back is normal โ€” those were one-time annual charges.
๐Ÿงพ AR Aging Report
Accounts Receivable โ€” money that clients owe you. The longer an invoice sits unpaid, the harder it is to collect. Industry rule: >30 days = risk. >60 days = serious risk. >90 days = likely loss.
Total AR Outstanding
โ‚ฑ371,255
2 invoices ยท 0 paid
Days Overdue (Avg)
16 days
Across both invoices weighted
Oldest Invoice
30 days
LFO-2026-001 sent Apr 24
Collection Probability
High
Family clients ยท strong relationship
Invoice Aging Detail
InvoiceClientSentDueAmountDays OutAction
LFO-2026-001 Lane Holdings
Gerry M. Lane ยท consulting
Apr 24 May 24 โ‚ฑ204,255 30 days ยท OVERDUE Follow up TODAY
INV-2026-001 Virginia G. Lane
VGL LMS ยท fCAIO Month 1
May 19 May 22 โ‚ฑ167,000 2 days ยท OVERDUE Gentle reminder
AR Aging Bucket View
๐Ÿ“‹ Suggested follow-up language for LFO-2026-001 (Gerry):

"Hi Gerry, following up on Invoice LFO-2026-001 for โ‚ฑ204,255 (sent Apr 24, due May 24). Happy to answer any questions. Please let me know the expected payment date so I can update my records. Thanks!"
๐Ÿ“‹ Suggested follow-up for INV-2026-001 (Virginia):

"Hi Virginia, just a gentle reminder โ€” Invoice INV-2026-001 for โ‚ฑ167,000 (VGL LMS Month 1) was due May 22. Please let me know when I can expect settlement. Looking forward to continuing Month 2!"
๐Ÿ“ฆ Subscription True Cost Stack
Every recurring charge โ€” deduped to CC statement sources, annualized, and tiered by ROI. Three tiers: Keep (core tools), Review (investigate or justify), Kill (confirmed waste).
Total Subscriptions YTD
โ‚ฑ187,060
From CC statements ยท Janโ€“May 2026
Annualized Estimate
โ‚ฑ449,000
If all renew on current cadence
Confirmed Keep
โ‚ฑ96,000/yr
Core tools with clear ROI
Cuttable (Conservative)
โ‚ฑ80โ€“130K/yr
Duplicates + idle + waste
โœ… KEEP โ€” Core Tools (Clear ROI)
ServiceWhat it doesYTD SpentAnnual Est.
Claude.ai + AnthropicAI assistant โ€” literally Donnaโ‚ฑ15,961โ‚ฑ38,000
PerplexityResearch layerโ‚ฑ5,305โ‚ฑ12,700
SuperwhisperVoice captureโ‚ฑ3,729โ‚ฑ3,729 (annual)
BitwardenPassword manager (keep this one)โ‚ฑ3,008โ‚ฑ3,008 (annual)
Proton MailPrivacy email infraโ‚ฑ1,841โ‚ฑ1,841 (annual)
Google AI Pro5TB + Gemini Advanced + NotebookLM + YouTube Liteโ€”~โ‚ฑ4,800/mo
Oura RingSleep + HRV tracking โ€” re-subbed Jun 7โ€”โ€”
CloudflareDNS / infrastructureโ‚ฑ519โ‚ฑ519 (annual)
Telegram PremiumCommunicationsโ‚ฑ707โ‚ฑ2,120
SpotifyMusicโ‚ฑ1,416โ‚ฑ3,400
NetflixStreaming (one plan)โ‚ฑ2,501โ‚ฑ7,500
๐ŸŸก REVIEW โ€” Investigate Before Renewing
ServiceFlagYTDAction
ChatGPT Businessโœ… Already dead โ€” ended May 1, 2026โ‚ฑ20,841Done
Tradeify (ร—2 entries)TRADEIFY โ‚ฑ13,655 + Tradeify โ‚ฑ6,591โ‚ฑ20,246Login โ†’ check active plans. Likely two plans or billing name change.
Kubera.comโ‚ฑ15,345 annual โ€” CFO system now existsโ‚ฑ15,345Decide before next renewal (~Mar 2027).
Evernoteโœ… CANCELLED Jun 9 โ€” 900 notes archivedโ‚ฑ17,115Done
Shadowโœ… CANCELLED Jun 9 โ€” $47/yr confirmedโ‚ฑ12,114Done
LinkedIn (ร—2 cards)PayPal โ‚ฑ6,616 + UB โ‚ฑ6,518โ‚ฑ13,134Check if same PayPal billed to both cards. Kill duplicate.
Disney+3rd streaming serviceโ‚ฑ2,420Actually watching it? If not, cut.
HBOMax4th streaming serviceโ‚ฑ1,028Cut if not watching regularly.
HostingerAnnual web hosting โ‚ฑ14,470โ‚ฑ14,470What's hosted here? Confirm still needed.
๐Ÿ”ด KILL โ€” Confirmed Waste
ServiceWhy KillAnnual Saving
Discord Nitro + 8 Boostsโœ… CANCELLED Jun 9 โ€” ends Jul 4~โ‚ฑ28,416/yr
YouTube Premiumโœ… CANCELLED Jun 9 โ€” replaced by Google AI Proโ€”
Google One (old)โœ… CANCELLED Jun 9 โ€” replaced by AI Pro 5TBโ€”
GoPro Subscriptionโš ๏ธ Can't find account โ€” may be Elle's~โ‚ฑ45,350/yr
Microsoft 365โœ… CANCELLED Jun 9~โ‚ฑ8,900/yr
2LUV / Love Lettersโœ… CANCELLED Jun 9 โ€” Elle app, not worth it~โ‚ฑ14,820/yr
LastPassโœ… Already dead โ€” expired Mar 2026โ‚ฑ2,473
Any.doโœ… CANCELLED Jun 9โ‚ฑ1,430
CryptoReviewing.comโœ… No recent charges โ€” confirmed deadโ‚ฑ1,463
ScribdYou have Audible + every other content sub.โ‚ฑ469
FXReplayโœ… No recent charges โ€” confirmed deadโ‚ฑ732
TOTAL KILLSโ‚ฑ6,567/yr
๐Ÿ’พ Savings Rate Analysis
Of every peso that came in, how much stayed? A healthy savings rate is 20%+. Below 0% means you're drawing down โ€” spending more than you earn that month.
Total In (6 months)
โ‚ฑ1,902,462
All deposits into UB Savings
Total Out (6 months)
โ‚ฑ2,713,394
All outflows from UB Savings
6-Month Net
โˆ’โ‚ฑ810,932
Net drawdown โ€” mostly medical
Avg Savings Rate
โˆ’42.6%
Negative = spending more than earning
Monthly Savings Rate
๐Ÿ“Œ Context matters here. The โˆ’330% in Jan and โˆ’660% in Mar look catastrophic โ€” but they were entirely driven by Kai's medical bills being paid off from savings. Apr's +875% is the rebound once Gerry's consulting payment landed. Strip out medical and the picture normalizes significantly.
๐ŸŽฏ Target: Once both invoices clear and a retainer structure is in place, a 20โ€“30% savings rate (saving โ‚ฑ45Kโ€“โ‚ฑ67K/month on โ‚ฑ225K income) is the healthy baseline to aim for.
Savings Rate by Month
MonthInOutNetRateContext
Dec 2025โ‚ฑ292,362โ‚ฑ364,759โˆ’โ‚ฑ72,397โˆ’24.8%Normal month, slightly high spend
Jan 2026โ‚ฑ0โ‚ฑ330,695โˆ’โ‚ฑ330,695โˆ’โˆžZero income ยท Kai hospitalized
Feb 2026โ‚ฑ1,039,336โ‚ฑ876,980+โ‚ฑ162,356+15.6%โ‚ฑ1M from Gerry ยท medical payoffs
Mar 2026โ‚ฑ110โ‚ฑ724,324โˆ’โ‚ฑ724,214โˆ’โˆžContinued medical CC payoffs
Apr 2026โ‚ฑ410,105โ‚ฑ156,601+โ‚ฑ253,504+61.8%โ‚ฑ290K+โ‚ฑ120K landed ยท low spend
May 2026โ‚ฑ160,654โ‚ฑ260,035โˆ’โ‚ฑ99,381โˆ’61.9%Month not finished ยท invoices pending
๐Ÿ”ฎ 3-Month Cash Flow Forecast
Projected Junโ€“Aug 2026 based on known recurring outflows. Income shown in two scenarios: zero new income vs. both invoices collected + VGL retainer continuing.
Starting Balance (Jun 1)
~โ‚ฑ998,785
Est. after May commitments clear
Known Monthly Outflows
โ‚ฑ225,311
Recurring baseline
Scenario A End Balance
โ‚ฑ323,852
Aug 31 ยท zero new income
Scenario B End Balance
โ‚ฑ1,427,107
Aug 31 ยท invoices + VGL retainer
Forecast Chart โ€” Jun to Aug 2026
Known Recurring Outflows (Monthly Baseline)
ItemTypeMonthly CostCertainty
Elle household allocationTransferโ‚ฑ95,000Est. โ€” varies
Core subscriptions (keep tier)Recurringโ‚ฑ6,400Confirmed
UB CC minimum paymentDebt serviceโ‚ฑ20,000Confirmed
SB CC minimum paymentDebt serviceโ‚ฑ15,000Confirmed
GCash top-upsCash/miscโ‚ฑ14,000Est. avg
All other subscriptionsRecurringโ‚ฑ25,000Est. avg
Grab (food + transport)Variableโ‚ฑ22,000Est. avg
Dining + Shopping + miscVariableโ‚ฑ27,911Est. avg
TOTAL BASELINEโ‚ฑ225,311/mo
๐Ÿšจ Scenario A (no new income): By Sep 2026 savings drops to ~โ‚ฑ100K โ€” critically low. The 3-month window is real. This is why the two overdue invoices and fCAIO continuity are not optional follow-ups โ€” they're survival items.
โœ… Scenario B (invoices + VGL retainer): Balance grows. โ‚ฑ371K in collected invoices + โ‚ฑ167K/mo retainer puts you in positive territory by July and growing through August.
โ†ฉ๏ธ Reimbursement Recovery Tracker
Money you paid out of pocket for legitimate work/family expenses โ€” and are entitled to get back. Tracked by submission status, amount, and aging.
Total Paid Back (2026)
โ‚ฑ160,581
May 6 Instapay โ€” Apr 27 bundle settled
Still Outstanding
โ‚ฑ94,840+
Gloria + Starlink + defibrillator TBD
Submitted to Gerry
โ‚ฑ94,840
2 items submitted Apr 24 โ€” no reply
Approved, Amount TBD
โ‚ฑ?
Defibrillator โ€” receipt PDF not yet read
Full Reimbursement Ledger
ItemSubmittedAmountStatusNotes
Mold Inspection โ€” Villa Halcyon Apr 27 bundle โ‚ฑ39,200 โœ… PAID May 6 Part of โ‚ฑ160,581 bundle
Generator Repair โ€” Villa Halcyon Apr 27 bundle โ‚ฑ5,500 โœ… PAID May 6 Part of โ‚ฑ160,581 bundle
Villa Halcyon Maintenance 2023โ€“24 Apr 27 bundle โ‚ฑ37,950 โœ… PAID May 6 Part of โ‚ฑ160,581 bundle
Starlink Equipment โ€” Villa Halcyon Apr 27 bundle โ‚ฑ53,700 โœ… PAID May 6 Part of โ‚ฑ160,581 bundle
Kubera Subscription Apr 27 bundle TBD โœ… PAID May 6 Part of โ‚ฑ160,581 bundle
Gloria Salary Supplement 2026 Apr 24, 2026 โ‚ฑ60,000 ๐ŸŸก SUBMITTED 30 days no reply from Gerry
Starlink Monthly โ€” Villa Halcyon
Jun 2025โ€“Apr 2026 (11 months)
Apr 24, 2026 โ‚ฑ34,840 ๐ŸŸก SUBMITTED 30 days no reply from Gerry
Defibrillator โ€” Mindray Beneheart C2
For Kai ยท AED unit
May 13, 2026 โ‚ฑ? TBD โœ… APPROVED Receipt PDF in Gmail โ€” amount not yet read
๐ŸŸก Gloria (โ‚ฑ60K) + Starlink Monthly (โ‚ฑ34,840) have been sitting with Gerry for 30 days. Bundle these with the defibrillator receipt into a single follow-up email. One combined ask is easier than three separate ones.
๐Ÿ”ด Action needed: Read the defibrillator receipt PDF (SI.May Gerard Lane in Gmail). The amount is approved by Gerry โ€” you just need to confirm the number and add it to the reimbursement bundle.