AI Skill Report Card

Triaging Financial Emails

A-84·Nov 22, 2026·Source: Web

Quick Start

Run this triage whenever asked to "check my emails for invoices/payments/waivers" or "give me today's finance email summary":

  1. Pull all emails received in the last 24 hours.
  2. Filter to finance-related categories (see keyword list below).
  3. Extract key fields from each email (and attachments).
  4. 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).
  5. Export a single report (PDF or Excel) with High Priority items listed first, Manual Review items below.
15 / 15

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.

CategoryKeywords to match
Invoiceinvoice, inv#, bill, billing statement
Paymentpayment, paid, wire, ACH, EFT, payment confirmation
Pay Applicationpay app, pay application, AIA G702, G703, application for payment
Waiverlien waiver, conditional waiver, unconditional waiver, release of lien
Remittanceremittance, remittance advice
Checkcheck, 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:

  1. High Priority items, sorted descending by dollar amount
  2. 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.

Recommendation▾
Clarify the threshold ambiguity ($4,000 vs $5,000) with a single default and a one-line note instead of repeating it three times across the doc.
18 / 20

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.
Recommendation▾
Add an example of a High Priority item with a mismatch between body and attachment amounts to demonstrate that specific flagging behavior.
  • 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.
0
Grade A-AI Skill Framework
Scorecard
Criteria Breakdown
Quick Start
14/15
Workflow
15/15
Examples
18/20
Completeness
18/20
Format
14/15
Conciseness
13/15