Quarterly Invoice Collection

What BOB Does

1. xlsx-tools → Read the subscriptions sheet and the card statements; build the expected-invoice checklist for the quarter: one row per supplier charge with date, amount, and an empty invoice-received column
2. Confirm the checklist — flag any charge that is private rather than business, and any supplier known to be portal-only before the search runs
3. invoice-collector → Search Gmail for the quarter's date boundaries, download PDF attachments, rename to `yyyymmdd_supplier_invoiceid.pdf`, upload to the period's Drive folder
4. xlsx-tools → Reconcile collected PDFs against the checklist: fill the invoice date and filename per matched row, and report the unmatched rows as the portal list — the invoices that must be fetched by hand
5. Log into each portal on the list and download the invoices to the local Downloads folder. No renaming — the agent handles that
6. invoice-collector → Classify everything in Downloads: identify supplier, invoice date, and invoice number from each PDF, rename to the convention, upload to the same Drive folder, and update the checklist rows
7. Final reconciliation report — filed count, Drive folder, and the remaining exceptions split into private / still missing / ambiguous, each with the reason it was not filed