TL;DR — the brutal one-screen version
- The Sunday email is structurally correct but full of broken data. Camp tracker shows negative remaining ($2,550 paid $2,208.35 = "remaining -$341.65") — that's a sign flip in the code, not your math. High-priority debt shows balances as "-14.7k" — same sign convention bug. Monthly interest shows $0.00 across all 5 cards because the formula is dead.
- Email firing chaos is real and documented. This morning alone: 4 emails in 13 minutes (Operations Summary 7:40 → Operating Snapshot WEEKLY 7:43 → Weekly Review 7:44 → Monthly Overview WEEKLY 7:53). Apr 26 night fired 6+ in 60 min. Triggers across 4 different scripts (BOS v1, BOS v2, Architect V11, plus ghost projects) need a hard reset.
- You have 9 sheets and at least 8 separate script projects. 5 of those 9 are mature (BOS v1/v2, Quick Capture, MIS-related). 4 are murky: Operating OS v1 (Eden), HS Unified, Daily Tracker, and the new HookStreet_Command_Center_Rebuilt (committed Apr 26, may be the one to rally around) all have their own script projects now — possibly firing their own emails you haven't traced.
- Sommerset balances are healthy. 9332 (2528) $7,168.90 + 9312 (6651) $5,843.44 = $13,012 STR liquidity. May 15 mortgages are $7,303 combined. If the autopay actually pulls from 5777 (per
MORTGAGE_ROUTING.md) the LLCs aren't touched. Verify which account Shellpoint + Selene actually debit before May 14.
- "Keap $199" — NOT FOUND in your CSV (2020 → Apr 29 2026). Zero hits on "Keap" or "Infusionsoft" anywhere. Closest match: I HAVE ADHD LLC charged $199/mo on Chase 8412 Nov 2023 → Mar 2024 (now stopped). If a Keap charge exists today it's on a card not in this CSV, OR you're misremembering the merchant name. Search Gmail for "Keap" receipt or call the suspected card to confirm.
- What I CAN'T do this session: transcribe the audio recording (Recording (5).m4a — grocery convo, no audio tool wired up) and read .xlsx directly (Monthly Obligations.xlsx and v2.xlsx) — but I have the live v2 sheet contents from
docs/MAY_AUTOPAY_PREFUND_2026-05.md, so the xlsx loss is minimal.
1 · The 9 sheets you sent — actual map
| # | Sheet | Sheet ID | Script ID | What it does | Status |
|---|
| 1 | HookStreet_Operating_OS_v1 | 1LWsKTLLm | 1h_DCul | Eden Gardens tracker (ACTION_TRACKER, WAITING_ON, PROJECTS) — was a DATA SOURCE for BOS v1 per old SCRIPTS_AUDIT, but NOW has its own bound script you're showing me | UNTRACED Open the script's Triggers tab — does it fire emails? |
| 2 | HS_Unified_Business_Life_OS_COMPLETE | 1qDqEMI | 1gWmXugY | STR_Properties + Master_Activity_Log — BOS v1 reads from here. Has its own script too. | UNTRACED Same — check triggers |
| 3 | Daily Tracker | 1ZGADlm5 | 1NiGxw0 | Open tasks tab — read by BOS v1 daily snapshot | UNTRACED Same |
| 4 | Monthly Obligations (BOS v1) | 1L_rxCSOnc | 1_cgriwCQ | The production engine. Fires this morning's Operating Snapshot WEEKLY 7:43 AM PDF + Operations Summary + Weekly Review + Daily + Mildred_Start. 113 functions in Code.js. Reads from sheets 1/2/3. | PRIMARY Keep. Has the most logic. |
| 5 | Monthly Obligations v2 | 1qNYUbb | 1ROnmAAhtTYE | Cleaner data domain. Fires Hookstreet OS — WEEKLY (Monthly Overview) 7:53 AM Sunday. Complementary to v1 — not duplicate. | PRIMARY Keep. Cleaner cashflow. |
| 6 | Quick Capture (Responses) | 1Wp4Opb | 1v2i7D7o | Form responses for grocery/idea/task/business/calendar capture. Routes Grocery to Chanie + Sam. | DOUBLE-ROUTER RISK Per old audit: BOS v1 ALSO polls this every 30 min. Possible double-process. |
| 7 | Artist Travel — Yeshai / Ely Katz | 1NqWsrqE | 1B-6Htby | UNDOCUMENTED in your workspace docs. Almost certainly the transportation tracker for music gigs (Jack Arene Lusabia $260 invoice, Symphona, Bnei Akiva, Lior Souchard A/R per CONTEXT.md). | UNDOCUMENTED Either fold into TRANSPORT_AR_JACK doc or leave standalone — but record what triggers it has. |
| 8 | HookStreet_Command_Center_Rebuilt | 17XDHLIu | 18WtehG4 | NEW. Committed Apr 26 (BOS commit 49e997d "feat: add HookStreet Command Center Rebuilt — 63-tab master OS shell"). Drive-only, 63-tab shell. | SHELL What's the relationship to the Next.js command-center web app? Is this the Sheet-based replacement? Decide and document. |
| 9 | ZW_OS_GOOGLE_FIX_v2 | 1YwwDx | (none — xlsx import) | Excel-imported file (URL has rtpof=true&sd=true = "round-tripped from .xlsx"). No bound script. | RETIRE Likely an older state. Move to Drive archive folder. |
Plus what's not in your list but exists
| Sheet | Status |
|---|
1cosuFrU MIS_v7.1_gsheet (production MIS) | Active. Per Sam's earlier draft 11:30 AM today, has plaintext Schwab + Finnhub credentials in KEY_VALUE tab — security emergency, separate from this audit. |
1MU_NiSn Architect V11 Microservices Edition | Active rogue. Fires its own MIS Power Hour. Per today's earlier MIS-MAP draft, this is the source of weekend MIS Power Hour emails (no weekend skip). |
| BOS v7.3 rogue | SCRIPTS_AUDIT (Apr 16) flagged this one as firing the 4:48 AM duplicate AM email. Still likely live until Sam runs Delete All Project Triggers. |
So to answer "where does the code live?" honestly:
You have at least 8 distinct Apps Script projects across this workspace. Only 2 of them (BOS v1 sheets/, BOS v2 sheets-v2/) are checked into git locally. The other 6+ live exclusively on Google Drive — no version control, no diff history, no rollback. This is the single biggest structural risk in your operating stack today.
2 · The Sunday email — brutal teardown
The PDF you uploaded is "Hookstreet Operating Snapshot WEEKLY 07:43" — generated Sunday May 3 2026 7:43 AM EDT by renderCompactSnapshot_ at Code.js:1828, wrapped to PDF by packagePdf_ at Code.js:1773. Source sheet: BOS v1 Monthly Obligations.
🔴 CRITICAL — data is wrong
| # | Bug | What you see | What it should be | Root cause |
|---|
| 1 | Camp Tracker "Remaining" sign flipped | Arievim −$341.65, Agudah −$650, Ohr Chedva −$1,420 | +$341.65, +$650, +$1,420 (real remaining) | extractCampRows_ at Code.js:2948 reads data[i][3] (sheet's balance column where debt is stored as negative) instead of computing total − paid from the parsed Notes regex it already runs. One-line fix: change money_(remaining) to money_(Math.abs(remaining)) or — better — compute from parsed totalMatch/paidMatch. |
| 2 | HIGH PRIORITY DEBT balances negative | Citi 2550 −14.7k, Chase 8412 −7.8k, Ink Plus 4089 −11.9k, USB 0049 −14.1k, US Alliance HELOC −217.0k | Display as positive ($14,710 / $7,800 / $11,900 / $14,100 / $217,000) | Sheet stores debt as negative. Render uses raw value. Add ABS at display. |
| 3 | Monthly Interest $0.00 across all 5 cards | $0.00 next to 14.99% / 18.49% / 16.74% / 19.49% / 8.50% | Citi 14.99% × $14,710 / 12 ≈ $184/mo. Five rows, five real numbers. | Formula is multiplying negative balance × APR, or formula isn't connected at all. Verify column on the Sheet (likely column where the staging row reads from). |
| 4 | "Suggested Action" column shows numbers | "528.53" / "194" / "274" / "365" / "1248.5" | Action text — "Pay min" / "Call for plan" / "Hold" / "Move to lower-APR" | The column is being filled with the suggested-payment NUMBER, not an action. Either the column was wired to wrong source, or the action column was never populated. |
| 5 | Days Left "−2" wrong direction for past-due | Arievim May 1 → "Days Left: −2" | "OVERDUE 2d" or "2 days past due" | buildActionBumpers_ at Code.js:2903 already has the '⚠️ OVERDUE' logic. The MOST URGENT PAYMENTS table doesn't apply it — it dumps r[3] (numeric days) raw. Fix: same OVERDUE branch in the urgent-payments renderer. |
| 6 | Time format violates locked rule | "Generated: 05/03/2026 07:43" | "Sun, May 3 2026 · 7:43 AM EDT" | Code.js:718 uses 'MM/dd/yyyy HH:mm' — 24-hr, no AM/PM. Memory feedback_time_format.md (Apr 27 lock): every user-facing time MUST be 12-hr AM/PM, no seconds. Change to 'EEE, MMM d yyyy · h:mm a z'. |
| 7 | "Items" count rendered as currency | BY CATEGORY → Debts row Items = "$11.00" | 11 | Items count column inheriting currency formatting from money_() helper. Strip dollar formatting on count fields. |
🟠 CONTENT BUGS — placeholder data still living in production
| # | Bug | Evidence | Fix |
|---|
| 8 | NEWS / NOTES section all "Example headline" | Market / Business / Local rows all say "Example headline / Short summary" — placeholder seed never replaced | Decide: (a) wire NEWS_INPUT tab to a real news fetch (per docs/NEWS_BRIEF_DESIGN.md Path A/B/C still pending), or (b) DELETE the section. Don't keep dead placeholders in the Sunday email. |
| 9 | BUSINESS ITEMS — 4 Example placeholders | Hookstreet / Transportation / STR / Capital all show "Example: …" text | Same — either populate BUSINESS_REPORT_INPUT from a real source (Quick Capture, monday.com, or a Sam-curated tab) or delete the section. |
| 10 | PERSONAL ITEMS first 4 are Example | "Example: doctor appointment" / "upcoming trip prep" / "home issue to resolve" / "school follow-up" | The placeholder seed is muddying the real items below ("Florida properties mortgage payments", "Taxes"). Strip Example rows from PERSONAL_REPORT_INPUT. |
| 11 | Florida properties row appears TWICE | Same Personal/High/Florida properties/Open/3/14/2026/Sam/identical Notes — back to back | Duplicate input row in PERSONAL_REPORT_INPUT. Delete one. |
| 12 | INSTALLMENT PLANS — only "Custom Payment Plan Example" shows | Single row: Other / Custom Payment Plan Example / Vendor Name / $0 / $0 / Specific Dates / Active | Real plans (Affirm Apple $210.54 May 23, Affirm Priceline #1 $224.80 May 2, Priceline #2 $257.06 May 16, Amazon #1 $54.40 May 17, Klarna Karp $80.59 May 1, plus 2 NEW Apr-25/27 plans) are NOT in this tab. Per docs/MAY_AUTOPAY_PREFUND_2026-05.md appendix and memory reference_affirm_klarna_schedules.md, you have ~$848 of Affirm exposure on 5609 in May that this section completely misses. |
| 13 | Hebrew calendar text mangled | "תְּ הִלִּים Holidays Jewish תְּ הִלִּים פ״ג-פ״ז day all" — RTL reversed and concatenated | The Sheet→PDF export doesn't honor RTL. Either filter Hebrew all-day events out of the calendar section, or render the calendar in HTML instead of Sheets→PDF. |
| 14 | "+19 more events not shown (WEEKLY cap = 25)" | The cap eats real meetings because all-day Hebrew holidays + daily Shacharis/Mincha eat the slots | Filter recurring religious events (Shacharis Amud, Mincha/Maariv Kaddish, all-day מאי holidays) out of the WEEKLY list — they're context, not bumpers — OR raise the cap to 50. |
🟡 STRUCTURE BUGS — sections that need scoping or deletion
| # | Issue | Recommendation |
|---|
| 15 | OPTIMIZED PAYMENT PLAN includes Shellpoint $3,853 May 15 (12 days away) at the top of a "this week" section | Filter to next 7 days. Keep mid-month bills in a separate "May 15 cluster" section. |
| 16 | "Suggested Payment" = Min Due verbatim — what does "optimized" actually mean here? | Either implement an actual optimization (e.g., minimums + extra payment toward highest-APR card) or rename to "AUTOPAY ROSTER" honestly. |
| 17 | No "Where's the cash" section | You have docs/MAY_2026_OPENING_SNAPSHOT.md with 9332 ($7,168) + 9312 ($5,843) + 5609 ($6,386) — none of this is in the Sunday email. Add a CASH POSITIONS section showing each operating account balance + funding move recap (Chanie sent $2,300 to 7792 + $750 to 5007 May 1). |
| 18 | UTILIZATION WARNINGS only shows Citi 2550 (97.16%) and Ink Plus 4089 (93.56%) — but USB 0049 has $14,100 balance shown elsewhere. What's its limit and is it utilized? | Either include all cards with utilization > 80% OR add a footnote saying "limit data missing for cards X, Y." |
🟢 GOOD — keep these
- KEEP ACTION BUMPERS — TOP 5 THIS WEEK at top-of-report — exactly the structure you want for "what hits next"
- KEEP CAMP TRACKER concept (burn-down for Arievim/Agudah/Ohr Chedva) — once the sign-flip is fixed, this is the single most useful section in the whole email. ~$2,400 of camp obligations remaining; you should see it weekly.
- KEEP CALENDAR — CHRONOLOGICAL section IF Hebrew rendering + cap are fixed
- KEEP BY CATEGORY rollup (Debts / FL-Fixed / Fixed Bills / Installments) — concentration view
✨ BRILLIANT — what the system already gets right structurally
The architecture of "top-5 bumpers + burn-down trackers + concentration rollup + calendar + tasks" is correct. This isn't a structural rebuild — it's a data + formatting fix sprint. Once you (a) fix the sign-flip, (b) populate or delete placeholder rows, (c) cleanse Hebrew calendar handling, (d) restore time format to AM/PM, the same email becomes phone-readable.
Per memory feedback_html_pdf_format.md: HTML-PDF format reads like PDF on phone — and your current email is firing as a literal Sheets→PDF dump, not the HTML-PDF format that already works for you. Switching the WEEKLY render path from renderCompactSnapshot_/packagePdf_ to the HTML render path (which Code.js:2300+ already has — see row2() helpers and '#ede9fe' color usage) gives you the format you actually like, with no new code.
3 · Email firing chaos — the real picture this morning
Today (Sunday May 3 2026) between 7:40 and 7:54 AM EDT, your inbox received 4 different Sunday emails from BOS:
| Time | Subject | From which sheet/script |
|---|
| ~7:40 AM | Hookstreet OS — Operations Summary | Sun, May 3 2026 | BOS v1 (1_cgriwCQ) — OPERATIONS_SUMMARY_SEND |
| 7:43 AM | Hookstreet Operating Snapshot WEEKLY 07:43 (the PDF you sent me) | BOS v1 — renderCompactSnapshot_ via packagePdf_ |
| ~7:44 AM | Hookstreet OS — Weekly Review | Sun, May 3 2026 | BOS v1 — WEEKLY_SEND → runReport_('WEEKLY') |
| 7:53 AM | Hookstreet OS — WEEKLY | 05/03/2026 (Monthly Overview content) | BOS v2 (1ROnmAAhtTYE) — separate engine |
This is consistent with docs/SYSTEM_MAP.md §4 finding (Apr 19): two near-identical "WEEKLY" subjects with different date formats fire simultaneously. docs/TRIGGER_REGISTRY.md says cleanup is "AWAITING SAM'S TRIGGER INVENTORY (Phase B)" — meaning the Apr 28 plan to fix this never got the screenshots from you it was waiting on.
The fix is mechanical and small:
- Open Apps Script for BOS v1 (link). Click clock icon (Triggers). Screenshot every row to me.
- Same for BOS v2 (link).
- Same for the 4 Drive-only scripts (Operating OS v1, HS Unified, Daily Tracker, Artist Travel, Command Center Rebuilt) — open each sheet → Extensions → Apps Script → Triggers tab → screenshot.
- I cross-reference against the registry, flag duplicates + ghosts, you approve, you click delete.
- Run
CREATE_DEFAULT_TRIGGERS() once on BOS v1 + BOS v2. Verify 48h.
Total Sam-time: ~20 min for screenshots, then ~10 min review with me.
4 · Cash positions reconciliation — the Chase image you sent
| Account | Last 4 | Image (1:16 PM May 1) | Per MAY_2026_OPENING_SNAPSHOT.md | Match? |
|---|
| 9332 Sommerset Realty LLC | 2528 | $7,168.90 | $7,168.90 | ✅ |
| 9312 Sommerset Realty LLC | 6651 | $5,843.44 | $5,843.44 | ✅ |
| Combined STR liquidity | | $13,012.34 | $13,012.34 | ✅ |
Cross-check against May 15 STR mortgage hits
Per docs/MORTGAGE_ROUTING.md (locked Apr 30):
- Shellpoint (9332) $3,853.33 → Pay-From: Chase 5777 (NOT 9332's account 2528)
- Selene Finance (9312) $3,450.00 → Pay-From: Chase 5777 (NOT 9312's account 6651)
- Total May 15 STR mortgages: $7,303.33
OPEN QUESTION: Mildred's monday.com note Apr 30 said "pay 9312/9332 vendors from HSC 1260" — that's a vendor routing. But the mortgages per MORTGAGE_ROUTING are 5777-funded. Verify on May 14 statement that Shellpoint + Selene actually debited 5777, not the LLC operating accounts. If they pulled from 2528 + 6651 directly, your STR liquidity drops $7,303 in one day.
On the optimistic side: even if both mortgages did pull from the LLC accounts, you'd still have ~$5,700 across both ($7,168 − $3,853 = $3,315; $5,843 − $3,450 = $2,393). Tight but not negative. Worth one phone call to Chase to confirm autopay routing.
5 · Rocket Money CSV — what April 2026 actually looked like
Source: 2026-04-29T15_43_13.729Z-transactions.csv · 22,475 rows · 2020-07-07 → 2026-04-29
April 2026 confirmed activity (sample, autopay focus)
| Date | Vendor | Amount | From account | Confirms |
|---|
| Apr 1 | Allied Health Pr (payroll PPD) | +$9,842.35 | 5609 (Chanie's payroll) | Income source ✅ |
| Apr 2 | Yeshiva Darchei WEB PMTS | $2,281.82 | 7792 (Chase Premier Plus) | ✅ Confirms 7792 routing per v2 sheet (resolves the conflict flagged in MAY_AUTOPAY_PREFUND). Wife funds 7792, then Darchei pulls. |
| Apr 3 | BAISYAAKOVATERES | $1,100 | 5609 | ⚠️ BYAM tuition paid from 5609, NOT 7792 as v2 sheet suggests. Possible discrepancy. |
| Apr 3 | CITI AUTOPAY (×2) | $307 + $553.42 | 5609 | ✅ Two Citi autopays — matches the "Citi $307" + "Citi $528.53" pattern in this Sunday's PDF |
| Apr 6 | KMF (Kia Motor Finance) | $599 | 5609 | ✅ Kia autopay live (PDF shows "Paid - refresh data" — actually it IS pulling, the status is wrong) |
| Apr 6 | Klarna* Klarna | $135.01 | 1260 | ✅ Confirms Klarna routes through 1260 (business). Matches verified May 1 = $80.59 final. |
| Apr 7 | GEICO Auto | $483.90 | 5609 | ✅ Geico autopay live. Matches PDF. |
| Apr 23/24 | HONDA PMT PPD | $475.85 | 5609 (Apr 24) | ⚠️ Honda paid from 5609, NOT 1260 as old reference_card_account_map.md memory said, NOT 7792 as v2 sheet says. Three sources, three different accounts. Real answer is 5609. |
| Apr 24 | Zelle from "9332 SOMMERSET REALTY, LLC" | +$986.42 | 1260 (Bus Complete) | ✅ STR revenue routing into business — confirms 9332 produces income |
| Apr 27 | USAlliance Finan CK-WTH | $1,382.26 | 5007 (Premier Savings) | HELOC pulling from savings — verify this is intentional |
| Apr 29 | 20FOUR7VA Square | $108.76 (×4 in April) | 1260 | ✅ Mildred's weekly invoice — autopay live on 1260 |
| Apr 29 | KOLSAVE MARKET | $471.51 | 5609 | Big Friday grocery hit |
Routing conflicts surfaced by this CSV (worth fixing in v2 sheet)
| Item | v2 sheet says | CSV says | Action |
|---|
| Darchei Tuition | Chase 7792 | 7792 ✅ | v2 is right — close the conflict in MAY_AUTOPAY_PREFUND |
| BYAM Tuition | Chase 7792 | 5609 | Update v2 row OR investigate — was Apr a one-off? |
| Honda Payment Car | Chase 7792 | 5609 | Update v2 row to 5609. Memory reference_card_account_map.md also wrong (says 1260). |
What's NOT in the CSV (and you assumed was)
- Keap $199 — ZERO hits. No Keap, no Infusionsoft, no recurring $199 from any plausible CRM vendor in your entire 6-year transaction history.
- Closest match: I HAVE ADHD LLC / IHAVEADHD.COM — $199/mo on Chase 8412 from Nov 2023 → Mar 21 2024 (4 charges, then stopped). Not Keap. Could you be mis-recalling?
- CLEAR membership $199 (Aug 9 2024) — refunded next day.
- If Keap is currently active: the card it charges is NOT in this CSV (the CSV covers Chase 5609/7792/1260/5007/5777 + Cap One 6003/2903 + Citi 4301/0157/4089/8412/2409/0972/1875/0102/6377/6965/2096 + Amex 1003/1004 — that's basically every card). Either it's a card on a different bank login, or wife's card, or the merchant name is something else. Check Gmail for "Keap subscription" receipts.
6 · What I cannot do this session
| Asset | Why | Workaround |
|---|
Recording (5).m4a (1.3 MB grocery convo with wife) | No audio transcription tool wired into this Claude Code session | Two options: (a) play it locally and dictate the gist back to me, or (b) drop into Otter.ai / MacWhisper / iPhone Voice Memos transcript and paste the text. Then I can ingest into BOS Quick Capture / Grocery list. |
Monthly Obligations.xlsx + v2.xlsx | Read tool doesn't parse .xlsx natively | Both are Excel exports of the live Google Sheets I already have indirect content for via docs/MAY_AUTOPAY_PREFUND_2026-05.md (read 2026-04-28 from the live v2 sheet via Drive MCP). Move the .xlsx files to archive/excel-exports/ — they're frozen snapshots, not live data. |
| Chase 5609 / 5007 / 5777 / 1260 / 7792 current balances | Not in the screenshot you sent (only 9332 + 9312 LLC accounts shown) | Drop a Chase summary screenshot or specific account balances when convenient. |
7 · Recommended action sequence (priority order)
| # | Action | Sam-time | Why this order |
|---|
| 1 | Trigger inventory + cleanup — open the 8 script projects, screenshot Triggers tab on each. Send to me. I diff, you approve deletes. | 30 min split (20 you + 10 with me) | This is the unblock for everything else. As long as 4 triggers fire on Sunday morning, no fix to the WEEKLY email matters because v2 will keep firing the parallel one. |
| 2 | Camp tracker sign-flip fix — single-line code change in extractCampRows_. I'll do the edit + clasp push. | 5 min | One-line fix, biggest visible improvement to the email Sam reads weekly. |
| 3 | Time format fix — change 'MM/dd/yyyy HH:mm' → 'EEE, MMM d yyyy · h:mm a z' across Code.js (4 occurrences in the rendering path). | 5 min | Memory feedback_time_format locked Apr 27 — it's been violated since. |
| 4 | Sign-flip on HIGH PRIORITY DEBT balances — wrap balance in Math.abs() at display. | 5 min | Pairs with #2. Both the camp tracker and the debt rows show negatives — same root cause class. |
| 5 | Switch WEEKLY to HTML render instead of Sheets→PDF | 30 min code + verify next Sunday | Memory feedback_html_pdf_format says HTML-PDF works on phone. Current Sheets→PDF doesn't. |
| 6 | Strip placeholder rows from PERSONAL_REPORT_INPUT, BUSINESS_REPORT_INPUT, NEWS_INPUT (or delete those sections entirely from email if you're not going to populate) | 10 min in sheet | "Example: doctor appointment" is bleeding trust in the email every Sunday. |
| 7 | Add real INSTALLMENT_PLANS rows for Affirm Apple, Priceline #1, #2, Amazon #1, Klarna Karp (plus the 2 new Apr 25/27 plans) | 15 min in sheet | You have $848 of Affirm exposure in May the email currently doesn't surface. |
| 8 | Update v2 routing rows for BYAM (5609 not 7792) and Honda (5609 not 7792) | 2 min in sheet | CSV verified above — small but eliminates a recurring confusion. |
| 9 | Add CASH POSITIONS section to WEEKLY render — pull from a CASH_BALANCES tab Sam updates Sunday morning before email fires | 20 min code + Sam Sunday entry | The PDF doesn't currently show that you HAVE $13K in STR LLCs and $6K in 5609. That's load-bearing context for "what to pay next." |
| 10 | Decide fate of HookStreet_Command_Center_Rebuilt — is this the new master shell, or is the Next.js command-center the master? | 10 min decision | Two things called "Command Center" exist. Pick one. Frozen-status the other. |
8 · Open questions for you
- Keap $199 — was it Keap, or could it have been "I have ADHD" subscription you canceled in 2024? If it's currently active, search Gmail for "Keap" or check the suspected card (probably one of the Citi cards near max). Confirm and I'll dig.
- Sheets 1, 2, 3 (Operating OS v1, HS Unified, Daily Tracker) have their own scripts now — what do they do? Were these added recently, or always there? Need their Triggers tab screenshots.
- HookStreet_Command_Center_Rebuilt (sheet 8) committed Apr 26 — did you build this as a Sheet-based replacement for the Next.js command-center? Or are both meant to coexist?
- Artist Travel - Yeshai/Ely Katz (sheet 7) — undocumented in workspace docs. Should I add a 1-pager to
docs/ describing it?
- ZW_OS_GOOGLE_FIX_v2 (sheet 9) — pretty clearly older, no script. OK to retire to Drive archive?
- Audio recording — re-upload as transcript when you can, or play locally + dictate gist?
- Can wife send you the Keap receipt if Keap is on her card? (Privacy boundary respected — only if relevant to her.)