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 13 addendum: Dave confirmed he already downloaded the tattoo permits receipt (Gmail image attachment) and Sheraton Norfolk folio (Gmail PDF attachment). These were the last two items on the "Dave downloads" list. All receipt downloads are now complete. Only remaining tasks: full verification pass (receipts vs Notion) and FINAL_REPORT.md recalculation.

Medicaid Application Session 13 - Receipt replacement complete: Replaced ALL generated receipt PDFs with official documents downloaded from vendor portals and Gmail. 15 Amazon invoices (portal print-to-PDF), 14+1 Squarespace invoices (portal), 13 Spotify (renamed portal UUID files), GeneratePress (Gmail print-to-PDF), 6 one-off receipts from Gmail (Afterlife Press, Norfolk Expo, Cathy Montie, 2x ProTrainings, Mar 2026 Claude Max $100). Added Lauren's ProTrainings BBP ($26.63) to Notion Shop Expenses. Dropped Amazon order 114-6863457-2728209 ($127.94) for having too many personal items. Only generated files remaining are Spectrum Jan/Feb 2025 (intentional). Key discovery: Dave upgraded from Claude Pro ($20/mo) to Claude Max ($100/mo) as of Mar 12, 2026. Next session: full verification pass syncing receipt files against Notion Shop Expenses and Shop Bills databases, then recalculate FINAL_REPORT.md with corrected Spectrum amounts ($118-130/mo vs old $89.99), dropped Amazon order, added Lauren ProTrainings, and Mar 2026 Claude Max.

[Medicaid Application] Session 11 COMPLETE: Recalculated FINAL_REPORT.md for correct Feb 2025-Feb 2026 period. Final numbers: Gross Income $75,426.15 (handwritten Feb-May $14,500 + bank Jun-Feb $60,926.15), Business Expenses $17,054.22 (Notion Shop Expenses $6,282.85 + Shop Bills $8,963.02 + tattoo permits $400 + Norfolk convention $1,408.35), Net Self-Employment Income $58,371.93. 11 sessions total. Key additions this session: Feb-May handwritten income/expenses integrated with bank data, Venmo-paid expenses (Notion $72, Later.com $300, GeneratePress $149), Norfolk Tattoo Expo convention costs ($800 booth, $528.35 hotel, $80 parking). 6 open items remain for Dave's review. Next: receipt verification pass to ensure all Notion entries have matching original invoices/receipts.

[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 10 - Receipt cross-verification and Notion fixes: Cross-verified 121 receipt PDFs against Notion Shop Expenses (38 entries) and Shop Bills (now ~111 entries). 94 matched, 21 expected gaps (handwritten/portal era). Found and fixed: (1) Atticus Talak Bifenthrin $43.11 re-added to Shop Expenses (was deleted between sessions), (2) 8 "Website hosting" $35/mo entries corrected from Vendor=Squarespace to Vendor=Cloudways (bank-rounded Cloudways charges), (3) 11 Squarespace Email Campaign $10/mo entries added (Jun 2025-Mar 2026), (4) March 2026 bills added (electric $240.97, Adobe x2, Cloudways $59.49, Spectrum $94.99), (5) Twilio $20 and Claude AI $5+$100 added, (6) FINAL_REPORT.md recalculated: Amazon reduced by $146.21 (Lauren's charges), new totals: Business Expenses $14,602.73, Net Self-Employment Income $53,156.40. Key clarification from Dave: Squarespace $336/yr = annual shop website hosting, $10/mo = email campaign subscription, $35/mo bank charges = Cloudways (not Squarespace).

[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 7 - Receipt PDF Generation Complete (88 PDFs) Generated 88 receipt PDFs across 15 vendor categories using Gmail MCP + fpdf2 Python scripts + Chrome browser portal navigation. All non-Amazon vendors done. EMAIL-BASED (33 PDFs): - Lucky Supply: 8 order confirmations ($151-$462, Jun 2025-Jan 2026) - Spectrum: 10 months (Jun 2025-Mar 2026, $89.99-$94.99/mo from payment confirmation + payment scheduled emails) - Anthropic/Claude: 7 receipts (Dec 2025-Mar 2026, Pro $20/mo, Max $100/mo, one-time credits) - Anthropic API: 1 credit purchase ($20) - Cloudways: 2 invoices (Feb $35.28, Mar $59.49) - Belzel Books: 1 order (#47000, $400 - Chad Koeplinger books) - Afterlife Press: 1 Venmo receipt ($414.50) - Cathy Montie BBP: 1 training ($39.95) - ProTrainings: 1 certification ($26.63) - Twilio: 1 account funding ($20) - Google Workspace: 1 invoice notification PORTAL-BASED (55 PDFs): - Adobe: 20 invoices (10 Lightroom $10.66-$12.80/mo + 10 Creative Cloud Pro $74.71/mo, Jun 2025-Mar 2026) - Squarespace: 11 invoices (10 monthly $10 scheduling + 1 annual $336 website renewal) - Spotify: 5 order history entries (Nov 2025-Mar 2026, $21.34-$23.47 Premium Family) - Carteret-Craven EC: 10 shop electric bills ($160-$241/mo, matched invoice numbers from Lauren's forwarded email to bank-verified amounts) - Havelock Water: 9 shop water bills ($130-$216/mo, from Munis Self Service portal data) NOT AVAILABLE: - ChatGPT/OpenAI (~6 Notion entries): No portal invoice access, no email receipts. Need bank statements as fallback. - Spotify Jun-Oct 2025 (5 months): Not in order history. Payment failures suspected. Need bank statements. - Amazon (~66 entries): Deferred to Session 8 - largest batch, needs dedicated context window. KEY TOOLS/METHODS: - generate_receipt_pdf.py: fpdf2-based PDF generator (no system deps, unlike WeasyPrint which needs libgobject) - Batch scripts: batch_generate_pdfs.py through batch7_squarespace_pdfs.py in project root - Gmail MCP for email data extraction, Chrome MCP for portal navigation - Carteret-Craven EC: Lauren forwarded 16 invoice .eml files; matched invoice numbers to 10 months of CSV amounts NEXT SESSION: Amazon invoices (~66), then Woodforest bank statements (10 months) as universal fallback proof.

[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.