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
| Description | Quantity | Unit Price | Total |
|-------------|----------|------------|-------|
| [Item] | X | $XX.XX | $XX.XX |
## Financial Summary
- **Subtotal**: $X,XXX.XX
- **Tax**: $XXX.XX
- **Total**: $X,XXX.XX
- **Payment Method**: [Method]
## Expense Categorization
| Category | Amount | Items |
|----------|--------|-------|
| Software | $XXX | Slack, GitHub |
| Office | $XX | Supplies |
## 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)
```csv
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
1---2name: financial-document-parser3description: Extract and analyze data from invoices, receipts, bank statements, and financial documents. Categorize expenses, track recurring charges, and generate expense reports. Use when user provides financial PDFs or images.4metadata:5 source: https://skillmd.com/skills/onewave-ai/financial-document-parser6---78# Financial Document Parser910Extract structured data from financial documents with automatic categorization and analysis.1112## When to Use This Skill1314Activate when the user:15- Provides invoices, receipts, or bank statements16- Asks to "parse this invoice" or "extract data from this receipt"17- Needs expense categorization18- Wants to track spending patterns19- Asks to generate expense reports20- Mentions financial document analysis21- Provides PDF or image of financial documents2223## Instructions24251. **Identify Document Type**26 - Invoice (business to business)27 - Receipt (point of sale)28 - Bank statement29 - Credit card statement30 - Expense report31 - Tax document32332. **Extract Core Information**3435 **For Invoices:**36 - Invoice number37 - Invoice date and due date38 - Vendor/supplier name and contact39 - Client/recipient name40 - Line items (description, quantity, unit price, total)41 - Subtotal, tax, and grand total42 - Payment terms43 - Payment methods accepted4445 **For Receipts:**46 - Merchant name and location47 - Date and time48 - Items purchased49 - Individual prices50 - Subtotal, tax, total51 - Payment method52 - Last 4 digits of card (if present)5354 **For Bank/Credit Card Statements:**55 - Statement period56 - Account number (last 4 digits)57 - All transactions (date, description, amount, balance)58 - Beginning and ending balance59 - Total credits and debits60 - Fees or interest charges61623. **Categorize Expenses**63 - Business expenses: Office supplies, software, equipment64 - Travel: Transportation, lodging, meals65 - Utilities: Internet, phone, electricity66 - Professional services: Legal, accounting, consulting67 - Marketing: Advertising, subscriptions68 - Entertainment: Client meals, events69 - Other: Miscellaneous70714. **Identify Patterns**72 - Recurring charges (subscriptions)73 - Duplicate charges74 - Unusual or high-value transactions75 - Tax-deductible expenses76 - Foreign currency transactions77785. **Generate Structured Output**79 - Create CSV-ready format80 - Summarize totals by category81 - Flag items needing attention82 - Calculate tax implications (if relevant)8384## Output Format8586```markdown87# Financial Document Analysis8889## Document Details90- **Type**: Invoice / Receipt / Statement91- **Date**: [Date]92- **Vendor/Merchant**: [Name]93- **Document Number**: [Number]94- **Total Amount**: $X,XXX.XX9596## Line Items97| Description | Quantity | Unit Price | Total |98|-------------|----------|------------|-------|99| [Item] | X | $XX.XX | $XX.XX |100101## Financial Summary102- **Subtotal**: $X,XXX.XX103- **Tax**: $XXX.XX104- **Total**: $X,XXX.XX105- **Payment Method**: [Method]106107## Expense Categorization108| Category | Amount | Items |109|----------|--------|-------|110| Software | $XXX | Slack, GitHub |111| Office | $XX | Supplies |112113## Insights114- Tax-deductible business expenses: $X,XXX115- Recurring charges detected: 3 subscriptions ($XXX/month)116- Foreign transaction fees: $XX117118## Flagged Items119- [ ] Large expense ($X,XXX) - verify approval120- [ ] Duplicate charge detected on [date]121122## Export Data (CSV Format)123```csv124Date,Vendor,Description,Category,Amount,Tax Deductible1252025-01-15,Adobe,Creative Cloud,Software,52.99,Yes126```127128## Recommendations129- Track recurring $XXX/month for [subscription]130- Consider negotiating bulk discount with [vendor]131- Set up payment reminder for [invoice due date]132```133134## Examples135136**User**: "Extract data from this invoice PDF"137**Response**: Parse PDF → Extract vendor info, line items, totals → Categorize as business expense → Format as structured data → Generate CSV export138139**User**: "Analyze my bank statement and categorize expenses"140**Response**: Extract all transactions → Categorize each (dining, software, travel) → Identify recurring charges → Calculate totals by category → Flag unusual transactions → Generate spending report141142**User**: "Parse these 10 receipts and create an expense report"143**Response**: Process each receipt → Extract merchant, date, amount, items → Categorize expenses → Calculate totals → Generate consolidated report → Create CSV for expense submission144145## Best Practices146147- Preserve exact amounts (don't round)148- Maintain currency symbols and formats149- Note when data is unclear or illegible150- Flag suspicious or duplicate transactions151- Provide tax-relevant categorization152- Use standard expense categories153- Generate export-ready formats (CSV, JSON)154- Protect sensitive info (mask account numbers)155- Identify missing information (no date, unclear vendor)156- Calculate totals and verify against document157- Note discrepancies or calculation errors158- Include exchange rates for foreign currency