BOS Sheet Cleanup — Camps, Mortgage, Test Loan

Codified from Gmail draft 19dc113c132263b3 · Apr 24 2026

⚠ NOTE Apr 26 2026: Camps were captured this session (Arievim / agudah / ohr chedva).
Test loan + dummy installment data already cleaned via MIGRATE_CAMPS_AND_CLEAN_2026_04_26.
This doc is preserved for reference + future similar cleanups.

Honest answer first

Three discrete cleanups. Do them sequentially, not parallel.
Most of the time = waiting on Chanie for camps amounts.
Active time: 60 min.

Task 1 — Remove test loan (10 min, do FIRST)

Quickest, lowest risk. Knock out first.

1. Open BOS sheet
2. Find the test loan entry — likely:
   - Labeled "TEST" or "test" anywhere in description
   - $1.00 amount or other dummy value
   - Lender = "Test" or "Demo"
3. Before deleting:
   - Note the row number
   - Check if any formula references this row directly
   - If referenced — fix the formula first
4. Delete the row
5. Verify monthly obligation totals re-calculate correctly
6. Verify weekly cash baseline didn't shift unexpectedly

Task 2 — Verify mortgage amounts (15 min)

Per OBLIGATIONS.md, current values:

• Shellpoint 9332 — $3,853.33
• Selene 9312 — $3,450.00
• Fifth Third home (NY) — $3,312.59
• US Alliance HELOC — $1,248.50

For each, pull latest statement + verify:

1. SHELLPOINT (account 0546)
   - Login: shellpointmtg.com
   - Latest statement → confirm payment amount
   - Escrow change in last 12 months? (taxes/insurance often re-amortize)
   - Note next due date

2. SELENE FINANCE (9312)
   - Login: seleneadvantage.com
   - Same checks

3. FIFTH THIRD BANK (NY home)
   - Login: 53.com
   - Same checks

4. US ALLIANCE HELOC
   - Login: usalliance.org
   - Different — variable rate (currently 8.50% APR)
   - Confirm if rate changed; payment may have changed
   - Verify autopay still active

Task 3 — Camps data (15 min active + Chanie wait)

STATUS Apr 26 2026: Captured this session. See OBLIGATIONS section of Monthly Obligations tab — Arievim / agudah / ohr chedva.

Original procedure:

STEP 1 — Ask Chanie (5 min)
Send simple text:

Hey can you send me the totals + payment schedule for: Boys Day Camp, Camp Agudah, Camp Libby? Need to add to budget.

STEP 2 — When she responds, log each (10 min)
- Add to BOS Camps tab (or Monthly Obligations rows):
- Camp name
- Total tuition
- Deposit + due date
- Installments + dates
- Payment method (check / autopay / credit)
- Move from "Pending" to confirmed monthly outflow
- Recalculate projected monthly outflow

STEP 3 — Set payment reminders
- Calendar event for each installment
- Or build into BOS Weekly Report

Task 4 — Commit + deploy (10 min)

cd hookstreet-bos-sheets
git add .
git commit -m "BOS cleanup: remove test loan, verify mortgages, add camps"
git push

Re-run BOS Weekly Report. Confirm new monthly obligation total matches expected.

Update CONTEXT.md project status:
- "BOS Sheet" status → "Clean"
- Remove cleanup items from next actions

Done state

• Zero "TBD" amounts in OBLIGATIONS.md
• No test data in BOS
• All mortgages verified against latest statements
• Camps populated with payment schedule
• Monthly outflow figure trustworthy