360 Secure SkillHub
360 安全技能中心

Jackzhang Expense Receipt Organizer

扫描文件夹中的 PDF 发票与图片支付截图,用 tesseract.js 在本地做 OCR 并抽取金额、日期、路线、收款方等信息,生成含银行信息的 CSV 汇总表,再把汇总表与全部原始文件打包成一个 zip 报销文件包,随后清理临时文件。目前主要针对火车票报销场景。

jackzhang2046
jackzhang2046
热度 23.37
最近更新 2026-05-20 03:36:05
分类:效率依赖:代码执行 / 读写文件应用场景:数据处理 / 文件转换 / 工作流 / 财务

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add jackzhang-expense-receipt-organizer
Metadata
name
jackzhang-expense-receipt-organizer
slug
jackzhang-expense-receipt-organizer
version
1.0.0
description
Organize receipts/invoices/payment screenshots into CSV report and zip for company reimbursement
homepage
null
metadata
{"clawdbot":{"emoji":"🧾","requires":{"bins":["node","npm"]},"os":["linux","darwin","win32"]}}

Expense Receipt Organizer

Automatically OCR and organize travel receipts, invoices, payment screenshots into a neat reimbursement package.

When to Use

  • User needs to报销 (company reimbursement)
  • Have multiple PDF invoices + image payment screenshots
  • Want auto OCR recognition + summary table + packaged zip

Core Steps

  1. Collect files — scan folder for PDF invoices and image screenshots
  2. OCR recognition — use tesseract.js to extract text from images/PDF
  3. Information extraction — extract amount, date, route, payee from recognized text
  4. Generate CSV — create formatted summary table with bank info
  5. Package files — put summary + all original files into one folder
  6. Zip it — compress to a single zip file ready to send to company
  7. Clean up — move temporary files to trash

Dependencies

  • Node.js/npm installed (comes with OpenClaw)
  • No extra binary required (tesseract.js runs in Node, no system tesseract needed)

Usage

User: Help me organize my reimbursement receipts
Assistant: 
1. Ask user where the files are
2. Ask for reimbursement person name + bank account info
3. Run the process:
   - npm install tesseract.js in temp folder
   - OCR all images
   - extract information
   - generate CSV
   - package everything
   - clean up
4. Tell user where the final zip is located

Example Output

~/Desktop/{Name}_reimbursement_{Date}.zip
├── {Name}_reimbursement.csv  (summary table with bank info)
├── *.pdf (original invoices)
└── *.jpg (original payment screenshots)

Notes

  • Uses CSV format for maximum compatibility (opens in Excel/WPS/Numbers)
  • Keeps original files attached for company audit
  • Cleans up temporary files after packaging
  • Currently optimized for train ticket reimbursement, easily extended to other receipt types