travel-subsidy_skill

Overview

This skill processes two specific uploaded zip archives named exactly 发票.zip and 火车票.zip to calculate business-trip subsidy eligibility, split related vs remaining files, and produce two result zip packages. It validates inputs, reads structured tables, builds chronological trips, computes conservative subsidy days and amounts, and reports progress at every key step.

How this skill works

The skill unzips both archives into a dedicated run directory, locates the best structured table in each archive, and maps table rows to files by filename or stable identifiers. It infers cities and routes from table fields and remarks (preferring table data over OCR), assembles chronological itineraries with strict continuity and time-gap rules, decides subsidy eligibility per business rules, and generates two output zips containing workbooks and grouped files.

When to use it

• You have both 发票.zip and 火车票.zip with at least one structured table each.
• You need a conservative, auditable calculation of 出差补助 based on provided invoices and train tickets.
• You want split outputs: one package with subsidy-related evidence and one with remaining files.
• You require step-by-step progress notifications and clear failure reporting.
• You need normalized, professional output workbooks preserving key business fields.

Best practices

• Upload both archives with exact filenames: 发票.zip and 火车票.zip; otherwise the skill will stop.
• Ensure structured tables (.xlsx/.csv) include filename/identifier, date, amount, and remarks where possible.
• Do not rely on OCR: include usable structured tables to maximize accuracy.
• Keep original uploads intact; the skill copies archives into a run directory and never modifies originals.
• Provide clear hotel names or route text in remarks to improve city inference and subsidy determination.

Example use cases

• Audit and prepare 出差补助 claims from a batch of invoice and train-ticket archives for reimbursement.
• Split a mixed pile of trip evidence into subsidy-eligible and remaining sets with normalized spreadsheets.
• Automate conservative subsidy day counting for multi-city loops and same-day round trips.
• Generate presentation-ready output zips with renamed copies and a clear explanation of unresolved items.