lov-expense-report

Featured

Extract invoice data from images or text descriptions and generate a categorized Excel expense report. Supports receipt photos, scanned invoices, and manual text input. Auto-classifies into: business entertainment (客户餐费), travel-transport (机票/火车票/打车), travel-accommodation (酒店), travel-meals, office supplies, communication, and other. Use when the user mentions "发票报销", "expense report", "报销单", "发票整理", "invoice", "报销汇总", "发票分类", "reimbursement", or has invoice images to process.

Data & Documents 64 stars 16 forks Updated today MIT

Install

View on GitHub

Quality Score: 89/100

Stars 20%
60
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# expense-report — Invoice → Categorized Excel Extract invoice information from images or text, classify expenses, and generate a professional Excel report with subtotals per category. ## When to Use - User has invoice photos / scanned receipts to process - User describes expenses in text and wants them organized - User needs a categorized reimbursement report (报销单) - User mentions 发票报销, 报销汇总, 发票整理, expense report ## Expense Categories | Category | Keywords / Examples | |----------|-------------------| | 业务招待 | 客户餐费, 商务宴请, 礼品, 招待 | | 差旅-交通 | 机票, 火车票, 高铁, 出租车, 打车, 网约车, 加油, 过路费, 停车费 | | 差旅-住宿 | 酒店, 住宿, 宾馆 | | 差旅-餐饮 | 出差期间餐费, 工作餐 | | 办公用品 | 文具, 打印, 办公耗材, 办公设备 | | 通讯费 | 话费, 流量, 网费, 宽带 | | 其他 | 不属于以上类别的费用 | ## Workflow (MANDATORY) ### Step 1: Collect Invoice Data Accept input in any of these forms: - **Images**: Read invoice photos using the Read tool. Extract: date, vendor, amount, item type, notes. - **Text descriptions**: Parse the user's text for the same fields. - **Mixed**: Multiple images + supplementary text. For each invoice, extract these fields: ```json { "date": "2026-04-15", "vendor": "海底捞(国贸店)", "item": "客户餐费", "amount": 486.00, "category": "业务招待", "note": "与XX公司李总晚餐" } ``` ### Step 2: Classify Assign each invoice to a category from the table above. Rules: 1. If the user explicitly states the category, use it. 2. If the item/vendor clearly matches a category keyword, auto-assign. 3. For ambiguous items (e.g., "餐费" could be 业务招待 or 差旅-餐饮): ...

Details

Author
lovstudio
Repository
lovstudio/skills
Created
4 months ago
Last Updated
today
Language
Python
License
MIT

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category