Thoughts

[Medicaid Application] Session 15 - Combined all receipts into single printable PDF: Merged all 149 receipt PDFs + 1 PNG (tattoo permits) into ALL_RECEIPTS_COMBINED.pdf (201 pages, 17.7 MB). Multipage PDFs preserved intact. Files grouped by category: Amazon, Hosting, Lucky Supply, Marketing, Other, Software, Training, Utilities. Used PyPDF2 for merge, Pillow for PNG-to-PDF conversion. File located in project root for easy printing.

[Medicaid Application] Session 14 COMPLETE - Notion cleanup + final numbers locked: Deleted 11 Notion entries (8 Cloudways pre-service entries, 1 OpenAI Jan duplicate, 1 ProTrainings no-receipt, 1 Google Workspace no-receipt). Added 5 entries (4 Squarespace Feb-May 2025 email campaigns, 1 Tattoo Permits $400). Confirmed 66 unverified Amazon charges = Lauren's personal purchases, excluded. Convention parking removed (no receipt). FINAL NUMBERS: Gross Income $75,426.15, Total Expenses $17,218.27, Net Self-Employment Income $58,207.88. Rule established: every Notion entry must match a receipt down to the penny, no entries without receipts. Cloudways is a new service starting ~Jan 2026 - only Feb 2026 invoice ($35.28) is legitimate. Only remaining open items: unspecified deposits ($28,513) and appointment amounts.

[Medicaid Application] Session 14 - Full verification pass + FINAL_REPORT recalculation: Cross-verified all 156 receipt files against both Notion databases (40 Shop Expenses, 126 Shop Bills). Major corrections: Spectrum shop bills are $118-130/mo (Internet + Voice), not $89.99; water corrected from bank payment amounts ($2,871) to actual monthly bills ($2,077); Adobe added 8 Feb-May entries (+$309); OpenAI expanded to 13 months (+$140). Net result: expenses $17,614.90 (was $17,054), net income $57,811.25 (was $58,372). Key gotcha: bank multi-month catch-up payments inflate utility totals vs actual monthly bills. Always use portal data as source of truth for utilities. Remaining gaps: 8 Cloudways receipts, 1 ProTrainings receipt, OpenAI Notion duplicate on Jan 27, 4 Squarespace entries missing from Notion.

[Medicaid Application] Session 10 continued - Major discoveries: (1) Reporting period is Feb 2025-Feb 2026, not through March. (2) Venmo is a second payment channel invisible to Woodforest bank data. Business expenses found via Venmo: Notion Business $24/mo (Nov-Mar), Later.com $300.01 (Dec annual), GeneratePress $149 (Jan theme license), plus $321+ in March 2026 AI tool charges (Hedra, fal.ai, Krea, ElevenLabs, OpenRouter, Cloudflare, OpenArt) for future tracking. (3) Squarespace has two products: $336/yr annual hosting + $10/mo email campaign. Bank $35/mo charges are Cloudways, not Squarespace. (4) eBay $70.36 Jul 2025 = Thomas trains, personal. (5) FINAL_REPORT needs complete recalculation for correct period with Venmo expenses included. Notion databases are now the authoritative source for expense data.

[Medicaid Application] Session 9 update - 7 total Amazon bank charges identified as Lauren's account (not Dave's business): $8.32 (08/03), $25.61 (06/07), $42.68 (09/20), $14.93 (02/21), $25.61 (08/14), $14.93 (08/23), $14.93 (12/03). Total $146.21 removed from business expenses. Lauren has her own Amazon account using same Mastercard/Woodforest bank account. Dave does all shop ordering from his account. Any Amazon bank charge not in Dave's Amazon payment history is Lauren's personal order.

Medicaid Application - Amazon charges bank PER SHIPMENT not per order. A $127.94 order may appear as multiple bank charges ($25.61 + $102.33) on different dates. When matching Amazon bank charges to orders, match by date proximity and item content, not just total amount. 4 of 20 matched Notion entries had bank amounts that matched zero Amazon order totals because they were individual shipment charges. Session 4 also misidentified "Atticus Talak" as numbing cream when it's actually bifenthrin insect control for the shop.

Medicaid Application Session 8 retro - CRITICAL: Never batch-fetch Amazon invoice pages with Promise.all. Parallel fetches cause data-shifting where order IDs get mapped to wrong invoice responses. Always fetch sequentially with 500-600ms delays. This silently corrupted 29 PDFs before being caught. Amazon invoice URL: amazon.com/gp/css/summary/print.html?orderID=ORDER_ID. Order details URL: amazon.com/gp/your-account/order-details?orderID=ORDER_ID. Amazon order search on Your Orders page is completely broken (ignores search terms).

[Medicaid Application] Final session summary. Notion Medicaid Application page now contains 3 databases fully populated and verified: SHOP EXPENSES (39 entries, all Checked): 15 Lucky Supply orders (Dave's only, Bryan Reynolds removed), 19 identified Amazon business items (A&D Ointment, tattoo ink, gloves, razors, art supplies, etc.), Afterlife Press $414.50, Belzel $400, 2 ProTrainings certifications, Cathy Montie BBP class $39.95, Twilio. 66 unchecked Amazon entries were confirmed as Lauren's personal orders and deleted. $693.86 Amazon charge also confirmed as Lauren's. SHOP BILLS (92 entries): Carteret-Craven Electric (13 months Feb 2025-Feb 2026), Havelock Water/Sewer, Spectrum internet, Adobe, Squarespace, Claude AI, OpenAI, Cloudways hosting, Google Workspace, Spotify (10 months). CLIENT APPOINTMENTS (114 entries): 76 Dave, 38 Lauren. Filterable by Artist property. All addresses from Jotform release forms (source of truth). 17 name/address corrections made from handwritten data. 13 Dave clients have no release form: Wesley Tingle, Dakota Merchant, Sienna Murice, Amanda Song, Shirley Seiler, Yasmin Dixon, Leslie Bass, Angel Herrera, Samantha Garida, Jack Cook, Lisa Yan, Braxton Badillo, Shane Briggs. Data sources used across all sessions: handwritten DMA-5043 forms (income.csv, expenses.csv), Woodforest bank emails via Gmail MCP (1,377 transactions), Google Calendar (Dave + Lauren), Jotform release forms CSV (1,879 entries), Amazon order history, Lucky Supply order emails, vendor portal data (Adobe, Squarespace, Spotify, utilities). Key decisions: release forms = source of truth for names/addresses, Lauren clients without release forms excluded, touch ups and consultations excluded from Lauren's list, all unchecked Amazon = Lauren's personal (deleted).

[Medicaid Application] Session 6 continued - Lauren's appointments added to Notion. Pulled events from laurentedder01@gmail.com Google Calendar (Feb 2025-Feb 2026). Filtered ~200 calendar events down to 38 confirmed tattoo appointments (Jun 7 2025-Feb 27 2026). Filtering rules: excluded non-tattoo events (Ronen/Ro entries = son, medical/dental/eye appointments, social hangouts, birthdays, pet care "Heart and flea Monte/Fonzie", Water due reminders, taxes, yard sales, parties, trips, concerts). Excluded touch ups and consultations per Dave's instruction. Excluded any client without a Jotform release form (release form = source of truth). Excluded entries already on Dave's Notion calendar (Tailynn Turner 07/26 was on both). Key client mappings from calendar nicknames: Dakota = Dakota George, Bwizzle = Brittany White (social, excluded - no release form), Mandy = Amanda Jarvis, all Kristin entries = social per Dave. Added "Artist" select property (Dave/Lauren) to Client Appointments database. All 76 existing = Dave, 38 new = Lauren. Total now 114 entries. Important technical learning: Notion MCP tool permissions do NOT propagate to Claude Code background subagents. Had to do all 114 updates directly rather than via parallel agents.

[Medicaid Application] Session 6 - Notion databases built and data verified. Three databases created under Notion "Medicaid Application" page: Shop Expenses, Shop Bills, Client Appointments. All data sources used: (1) /data/income.csv - 62 handwritten income records Jun 2024-Jun 2025 for Mar-Jun 2025 client entries and prices, (2) /data/expenses.csv - 80 handwritten expense records for Feb-May 2025 bills/supplies, (3) /data/2025-2026/FINAL_REPORT.md + expenses_report.csv + income_report.csv + appointments.csv - bank-derived data Jun 2025-Mar 2026, (4) /data/2025-2026/amazon_review.csv - 124 Amazon transactions classified business/personal with matched products, (5) /data/2025-2026/luckys_orders.csv - 12 Lucky Supply orders with itemization, (6) Release Forms CSV (1,879 Jotform entries) for client address/name verification, (7) Gmail MCP for Woodforest bank emails (Feb-May 2025 electric bills, Cathy Montie BBP receipt, Afterlife Press), (8) Google Calendar for appointment descriptions. Key fixes: 17 client name/address corrections from release form cross-reference. Added Spotify (shop bill) and Cathy Montie BBP class (shop expense). Removed Bryan Reynolds' Lucky Supply orders. Added Checked/Unchecked status filter to Shop Expenses (39 checked, 66 unchecked Amazon items). 13 clients have no release form on file.