Triaging Financial Emails
Quick Start
Run this triage whenever asked to "check my emails for invoices/payments/waivers" or "give me today's finance email summary":
- Pull all emails received in the last 24 hours.
- Filter to finance-related categories (see keyword list below).
- Extract key fields from each email (and attachments).
- Classify as High Priority (amount ≥ $5,000, default threshold — confirm with user if different, e.g. $4,000 in some cases) or Manual Review (everything else relevant).
- Export a single report (PDF or Excel) with High Priority items listed first, Manual Review items below.
Progress:
- Step 1: Pull emails from last 24 hours
- Step 2: Filter by finance keywords/categories
- Step 3: Extract amount, sender, subject, date, document type
- Step 4: Open and scan attachments for amounts/context
- Step 5: Apply priority threshold and tag each item
- Step 6: Sort (High Priority on top, Manual Review below)
- Step 7: Export as PDF or Excel
- Step 8: Summarize counts and flag anything ambiguous
Step 1: Pull Emails
Retrieve all inbox emails with timestamp within the past 24 hours. Include all folders likely to receive finance mail (Inbox, and if accessible, shared/AP inboxes).
Step 2: Filter by Category
Match subject line, body, and sender against these categories. An email can match more than one category.
| Category | Keywords to match |
|---|---|
| Invoice | invoice, inv#, bill, billing statement |
| Payment | payment, paid, wire, ACH, EFT, payment confirmation |
| Pay Application | pay app, pay application, AIA G702, G703, application for payment |
| Waiver | lien waiver, conditional waiver, unconditional waiver, release of lien |
| Remittance | remittance, remittance advice |
| Check | check, cheque, check #, check number |
Discard clear non-matches (newsletters, marketing, internal non-financial threads).
Step 3: Extract Key Fields
For each matched email, capture:
- Date/time received
- Sender (name + email)
- Subject line
- Document type(s) matched (from table above)
- Dollar amount(s) mentioned in body
- Project/job name or invoice/PO number if present
- Attachment present? (Y/N) and attachment names
Step 4: Scan Attachments
Open PDF/Excel/Word attachments and extract:
- Total amount due / paid
- Invoice or pay app number
- Vendor/subcontractor name
- Due date, if present
- Confirm whether the amount matches what's stated in the email body (flag mismatches)
If attachment is unreadable (scanned image, corrupted), note "Attachment unreadable — manual review required."
Step 5: Apply Priority Threshold
- Default high-priority threshold: $5,000. Always ask or confirm the user's preferred threshold at the start of a session, since it has varied (e.g., $4,000 in practice).
- Amount ≥ threshold → High Priority
- Amount < threshold, or amount unclear/missing, or document type is ambiguous → Manual Review
- No dollar amount found at all but category matched (e.g., a waiver with no amount) → Manual Review, note reason.
Step 6: Sort
Order the final list:
- High Priority items, sorted descending by dollar amount
- Manual Review items, sorted by date received (newest first)
Step 7: Export
Produce one file, named Finance_Email_Triage_[MM-DD-YYYY].pdf or .xlsx based on user preference. Columns:
Priority | Date | Sender | Subject | Doc Type | Amount | Project/Invoice# | Attachment | Notes
- PDF: use a clean table, High Priority section with a header/color flag, Manual Review section below with its own header.
- Excel: use two sheets or one sheet with a "Priority" column plus conditional formatting (red/yellow for High Priority, gray for Manual Review).
Step 8: Summarize
End with a short text summary: total emails scanned, number matched, number High Priority, number Manual Review, total dollar value of High Priority items, and any items flagged as unreadable/ambiguous.
Example 1: Input: Email from "ABC Subcontractors" — Subject: "Pay Application #12 — Project Riverside" — Body mentions "$18,250 due" — PDF attachment "PayApp12.pdf" attached. Output:
Priority: High
Date: Today 9:14 AM
Sender: ABC Subcontractors
Subject: Pay Application #12 — Project Riverside
Doc Type: Pay Application
Amount: $18,250.00
Project/Invoice#: Riverside / Pay App #12
Attachment: Yes (PayApp12.pdf) — amount confirmed in attachment
Notes: —
Example 2: Input: Email from "Vendor Co" — Subject: "Remittance Advice" — Body: "Payment of $1,200 processed for Invoice 4532" — no attachment. Output:
Priority: Manual Review
Date: Yesterday 4:02 PM
Sender: Vendor Co
Subject: Remittance Advice
Doc Type: Remittance, Payment
Amount: $1,200.00
Project/Invoice#: Invoice 4532
Attachment: No
Notes: Below threshold
Example 3: Input: Email: "Conditional Waiver attached for your review" — scanned image attachment, no amount in body. Output:
Priority: Manual Review
Doc Type: Waiver
Amount: Not found
Attachment: Yes (scanned image — unreadable)
Notes: Attachment unreadable — manual review required; amount could not be confirmed.
- Always confirm the high-priority dollar threshold at the start of each session — it has changed between $4,000 and $5,000 in practice.
- Cross-check the amount mentioned in the email body against the amount in the attachment; flag any mismatch explicitly rather than silently picking one.
- Treat "no amount found" as a reason for Manual Review, not as "not priority" — missing data should never default to low priority.
- Keep vendor/project names consistent so recurring senders are easy to scan across daily reports.
- If multiple amounts appear in one email (e.g., partial payment + retainage), extract the total and note the breakdown.
- Don't silently drop emails just because no attachment is present — body-only mentions of payments/amounts still count.
- Don't classify by subject line alone — scan the body and attachment, since subjects are often generic ("Invoice Attached").
- Don't merge High Priority and Manual Review into one unsorted list — the top-to-bottom order is a requirement, not a preference.
- Don't guess amounts from unreadable attachments — always flag as "unreadable, manual review" instead of estimating.
- Don't forget to re-verify the 24-hour window boundary (timezone matters) to avoid missing early-morning emails.