Session goal: Run bill scanner, process new attachments, extract bill details.
Progress log:
- 09:00 — Ran
bill-scanner.py --scan: found 2 emails (Unitywater Bill 27 May, PowerCo payment notification) - 09:01 — Ran
--process-attachments: 12 files found, 11 PDFs + 1 informational - 09:02 — Installed/located pymupdf (non-standard path
/opt/data/home/.local/lib/python3.13/site-packages/pymupdf) - 09:05 — Extracted Unitywater Bill 27 May 2026 PDF via PyMuPDF
Extracted bills:
| Vendor | Amount | Due | Status | Period | Ref |
|---|---|---|---|---|---|
| Unitywater (May Qtr) | $493.71 | 26 Jun 2026 | ⚠️ New bill — action needed | 24 Feb – 20 May 2026 | Acct 100114688, Bill 7128760918 |
| JB Hi-Fi AirPods Pro 3 | $360.99 | Paid | ✅ Settled | Order JB-25702383, 6 May | Invoice 5008679994-146 |
| PowerCo (MAR2026) — test data | $136.36 | 30 Apr 2026 | ⚠️ Stale placeholder (NZ address, not ours) | Mar 15 – Apr 14 | PC-88432-MAR26 |
| Unitywater info pamphlet | — | — | ℹ️ Info only (“What does your water bill pay for?“) | — | — |
Unitywater details:
- Account: 100114688, Payment ref: 1001 1468 83
- Property: 5 Paralla St, BUDERIM QLD
- Avg daily usage: 570 litres (above target of 150/person)
- Last bill: 493.71
- Due date: 26 Jun 2026
Issues:
- pymupdf not on default Python path — had to use non-standard site-packages location
- PowerCo bill files (1134 bytes each) are clearly placeholder/test data (NZ address Auckland, same content across duplicates) — should these be cleaned up?
Status: done — bills extracted, new Unitywater bill flagged for payment on 26 Jun.