Financial Document Parser

Extract structured data from financial documents with automatic categorization and analysis.

When to Use This Skill

Activate when the user:

• Provides invoices, receipts, or bank statements

• Asks to "parse this invoice" or "extract data from this receipt"

• Needs expense categorization

• Wants to track spending patterns

• Asks to generate expense reports

• Mentions financial document analysis

• Provides PDF or image of financial documents

Instructions

Identify Document Type

• Invoice (business to business)

• Receipt (point of sale)

• Bank statement

• Credit card statement

• Expense report

• Tax document

Extract Core Information

For Invoices:

• Invoice number

• Invoice date and due date

• Vendor/supplier name and contact

• Client/recipient name

• Line items (description, quantity, unit price, total)

• Subtotal, tax, and grand total

• Payment terms

• Payment methods accepted

For Receipts:

• Merchant name and location

• Date and time

• Items purchased

• Individual prices

• Subtotal, tax, total

• Payment method

• Last 4 digits of card (if present)

For Bank/Credit Card Statements:

• Statement period

• Account number (last 4 digits)

• All transactions (date, description, amount, balance)

• Beginning and ending balance

• Total credits and debits

• Fees or interest charges

Categorize Expenses

• Business expenses: Office supplies, software, equipment

• Travel: Transportation, lodging, meals

• Utilities: Internet, phone, electricity

• Professional services: Legal, accounting, consulting

• Marketing: Advertising, subscriptions

• Entertainment: Client meals, events

• Other: Miscellaneous

Identify Patterns

• Recurring charges (subscriptions)

• Duplicate charges

• Unusual or high-value transactions

• Tax-deductible expenses

• Foreign currency transactions

Generate Structured Output

• Create CSV-ready format

• Summarize totals by category

• Flag items needing attention

• Calculate tax implications (if relevant)

Output Format

Financial Document Analysis

Document Details

• Type: Invoice / Receipt / Statement
• Date: [Date]
• Vendor/Merchant: [Name]
• Document Number: [Number]
• Total Amount: $X,XXX.XX

Line Items

Financial Summary

• Subtotal: $X,XXX.XX
• Tax: $XXX.XX
• Total: $X,XXX.XX
• Payment Method: [Method]

Expense Categorization

Insights

• ✓ Tax-deductible business expenses: $X,XXX
• ⚠ Recurring charges detected: 3 subscriptions ($XXX/month)
• ℹ Foreign transaction fees: $XX

Flagged Items

• Large expense ($X,XXX) - verify approval
• Duplicate charge detected on [date]

Export Data (CSV Format)

Date,Vendor,Description,Category,Amount,Tax Deductible
2025-01-15,Adobe,Creative Cloud,Software,52.99,Yes

Recommendations

- Track recurring $XXX/month for [subscription]

- Consider negotiating bulk discount with [vendor]

- Set up payment reminder for [invoice due date]

## Examples

**User**: "Extract data from this invoice PDF"
**Response**: Parse PDF → Extract vendor info, line items, totals → Categorize as business expense → Format as structured data → Generate CSV export

**User**: "Analyze my bank statement and categorize expenses"
**Response**: Extract all transactions → Categorize each (dining, software, travel) → Identify recurring charges → Calculate totals by category → Flag unusual transactions → Generate spending report

**User**: "Parse these 10 receipts and create an expense report"
**Response**: Process each receipt → Extract merchant, date, amount, items → Categorize expenses → Calculate totals → Generate consolidated report → Create CSV for expense submission

## Best Practices

- Preserve exact amounts (don't round)
- Maintain currency symbols and formats
- Note when data is unclear or illegible
- Flag suspicious or duplicate transactions
- Provide tax-relevant categorization
- Use standard expense categories
- Generate export-ready formats (CSV, JSON)
- Protect sensitive info (mask account numbers)
- Identify missing information (no date, unclear vendor)
- Calculate totals and verify against document
- Note discrepancies or calculation errors
- Include exchange rates for foreign currency