Expense Report Wizard
Paste the following prompt into your AI chat to install this skill:
Install @user_c7ccc21d/expense-report-wizard according to https://skillhub.cn/install/skillhub.md.
About this skill
Problem
After a business trip, invoices often sit scattered across phone galleries, download folders, and chat attachments. It is easy to miss whether the invoice title matches the company, whether dates fall inside the trip window, whether travel exists between cities, whether hotel records are missing, or whether meal spend exceeds internal limits. Special invoices, reissues, refunds, and red-letter reversals make the cleanup even harder.
Core capabilities and flow
The skill advances through six steps:
- Context capture: confirm home city, trip dates, destination, company name, and optionally collect finance policy and per-diem standards.
- Invoice intake: accept photos, pasted text, or a local folder such as ~/Downloads/出差发票, then batch-read JPG, PDF, OFD, and files inside ZIP archives.
- Classification and trip log: organize entries by transport, hotel, meals, and other, then infer a day-by-day itinerary.
- Report generation: emit Markdown, CSV, or a custom template, including per-diem, deductible tax, and red-letter reversals.
- Compliance review: separate structural checks, invoice validity checks, and threshold checks; without a company policy it only checks items that have evidence and avoids inventing rules.
Boundaries
It does not replace finance approval, does not connect directly to ERP/SAP/Yonyou, and does not verify invoice authenticity or final tax deductibility. Title checks require the company name, threshold checks require a user-provided finance policy, and the scope is mainly mainland China invoice formats rather than overseas invoices.
Use Cases
- Organize trip invoices from a folder by date and category.
- Generate expense report with hotel, meal, per-diem totals.
- Check meal caps, hotel caps, and missing transport.
- Batch-read folder invoices through OCR layers.
Best For
- Finance assistant who turns trip invoices into reports.
- Product or sales employee checking title, route, and caps.
- Admin who renames invoice files with date, category, amount.
- Ops who exports reports to Tencent Docs for approval.
Related Skills
Organizes files by extension into subfolders like Documents, Code, and Archives, then outputs a report.
Extract tables, formulas, charts, and layout from invoices, reports, papers, and multi-column documents.
Generates a multi-sheet Excel report containing only structured data tables from byteplan-analysis results.
Automatically sort directory files into type-based folders, with dry-run preview, reports, and JSON custom rules.