financial-document-parser

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Financial Document Parser

财务文档解析器

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

从财务文档中提取结构化数据，并自动进行分类与分析。

When to Use This Skill

何时使用该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

当用户出现以下情况时激活：

提供发票、收据或银行对账单
要求“解析这张发票”或“从这张收据中提取数据”
需要对费用进行分类
想要跟踪支出模式
要求生成费用报告
提及财务文档分析
提供财务文档的PDF或图片

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)

识别文档类型
- 发票（企业对企业）
- 收据（零售交易）
- 银行对账单
- 信用卡对账单
- 费用报告
- 税务文档
提取核心信息

针对发票：
- 发票编号
- 发票日期与到期日
- 供应商名称及联系方式
- 客户/收件人名称
- 明细项目（描述、数量、单价、总价）
- 小计、税费及总计
- 付款条款
- 支持的付款方式
针对收据：
- 商家名称及地点
- 日期与时间
- 购买物品
- 单品价格
- 小计、税费及总计
- 付款方式
- 卡末4位数字（如有）
针对银行/信用卡对账单：
- 对账单周期
- 账户编号（末4位）
- 所有交易记录（日期、描述、金额、余额）
- 期初与期末余额
- 总入账与总出账
- 手续费或利息费用
费用分类
- 商务费用：办公用品、软件、设备
- 差旅：交通、住宿、餐饮
- 公用事业：网络、电话、电力
- 专业服务：法律、会计、咨询
- 营销：广告、订阅服务
- 娱乐：客户餐饮、活动
- 其他：杂项
识别模式
- 重复收费（订阅类）
- 重复扣款
- 异常或高价值交易
- 可抵扣税费的费用
- 外币交易
生成结构化输出
- 创建可导出为CSV的格式
- 按类别汇总总计
- 标记需要关注的项目
- 计算税务影响（如相关）

Output Format

输出格式

markdown

undefined

markdown

undefined

Financial Document Analysis

财务文档分析

Document Details

文档详情

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

类型: 发票 / 收据 / 对账单
日期: [日期]
供应商/商家: [名称]
文档编号: [编号]
总金额: $X,XXX.XX

Line Items

明细项目

Description	Quantity	Unit Price	Total
[Item]	X	$XX.XX	$XX.XX

描述	数量	单价	总价
[物品]	X	$XX.XX	$XX.XX

Financial Summary

财务摘要

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

小计: $X,XXX.XX
税费: $XXX.XX
总计: $X,XXX.XX
付款方式: [方式]

Expense Categorization

费用分类

Category	Amount	Items
Software	$XXX	Slack, GitHub
Office	$XX	Supplies

类别	金额	项目
软件	$XXX	Slack, GitHub
办公	$XX	办公用品

Insights

洞察

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

✓ 可抵扣税费的商务费用: $X,XXX
⚠ 检测到重复收费: 3项订阅服务（$XXX/月）
ℹ 外币交易手续费: $XX

Flagged Items

标记项目

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

大额支出（$X,XXX）- 请核实审批情况
检测到重复扣款，日期为[日期]

Export Data (CSV Format)

导出数据（CSV格式）

csv

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

csv

日期,供应商,描述,类别,金额,是否可抵扣税费
2025-01-15,Adobe,Creative Cloud,软件,52.99,是

Recommendations

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

用户: "从这张发票PDF中提取数据" 回复: 解析PDF → 提取供应商信息、明细项目、总计 → 分类为商务费用 → 格式化为结构化数据 → 生成CSV导出文件

用户: "分析我的银行对账单并对费用进行分类" 回复: 提取所有交易记录 → 对每笔交易分类（餐饮、软件、差旅）→ 识别重复收费 → 按类别计算总计 → 标记异常交易 → 生成支出报告

用户: "解析这10张收据并生成费用报告" 回复: 处理每张收据 → 提取商家、日期、金额、物品 → 对费用进行分类 → 计算总计 → 生成汇总报告 → 创建用于费用报销的CSV文件

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

保留精确金额（请勿四舍五入）
保留货币符号与格式
标注数据不清晰或难以辨认的情况
标记可疑或重复交易
提供与税务相关的分类
使用标准费用类别
生成可直接导出的格式（CSV、JSON）
保护敏感信息（掩盖账户编号）
识别缺失信息（无日期、供应商不清晰等）
计算总计并与文档核对
标注差异或计算错误
标注外币交易的汇率