expense-report

name	expense-report
category	thai-finance
version	1.0.0
description	Extract, categorize, and summarize SME receipts and expenses.
risk_level	high
output_type	csv, xlsx-schema, markdown

Expense Report Skill

Purpose

Convert receipt and invoice files into structured expense report.

Use When

• User has receipts/invoices to summarize
• User asks for expense report
• User wants monthly expense category summary

Required Inputs

• Source folder
• Reporting period
• Expense categories

Workflow

0. Require the expense-report discovery manifest; typed source overrides replace role defaults and must be recorded in the report.
1. Create file inventory.
2. Extract date, vendor, document number, amount, VAT, total.
3. Categorize by finance rules.
4. Flag missing, duplicate, suspicious, or high-value items.
5. Verify — recompute category subtotals and the grand total in an independent pass from the row-level data; reconcile against the sum of individual rows. Mismatches get re-derived from source, never smoothed over.
6. Exception resolution loop — if flagged items are ≤3 and resolvable by asking the user (e.g. "receipt X: personal or business?"), ask those targeted questions once, then re-run steps 2–5 for only the affected rows. Cap: 1 round. Anything still unresolved ships as a marked exception, not a guess.
7. Export table and summary.

Output Contract

Columns:

• source_file
• document_type
• date
• vendor
• category
• amount_before_vat
• vat
• total_amount
• payment_method
• confidence
• review_flag
• notes

Risk Control

• Draft for owner/accountant review.
• Do not guess missing amounts.
• Always include source reference.