Cowork expense audit
Skill bg-szy/TOP-SKILLS/skills/claude-skills/cowork-expense-audit
全球最大的 Claude Code 技能聚合库 · 收录 3900+ 来自 12+ 来源的技能,提供在线搜索与趋势分析看板 / The world's largest Claude Code skill aggregation hub — 3900+ skills from 12+ sources with online search and trend dashboard
npx -y skills add bg-szy/TOP-SKILLS --skill cowork-expense-auditAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Cowork-style sweep of a folder of receipts, statements, and expense exports -- categorizes every transaction, matches receipts to statement lines, flags policy violations and anomalies, and outputs a clean expense report plus a findings memo.
SKILL.md
3.3 KB, as published. Nobody here has run it
Cowork Expense Audit
Process an expense folder the way a careful controller does: reconcile receipts against statements, categorize consistently, and separate what is provably documented from what is missing. Input is a directory of receipts (PDF, images), card/bank statements, and any expense exports (.csv/.xlsx). Never invent an amount -- every number in the output traces to a source file.
Workflow
- Inventory. Catalog every file: receipts, statements, exports, and unclassifiable items. Note date ranges covered. If statements and receipts cover different periods, say so up front.
- Extract transactions. Build a master ledger from the statements/exports: date, merchant, amount, currency. From each receipt: merchant, date, total, tax, payment method, line items when legible.
- Reconcile. Match receipts to statement lines (exact amount+date first, then fuzzy within 3 days and small tip/FX variance). Output three lists: matched, statement lines with no receipt, receipts with no statement line.
- Categorize every transaction (meals, travel, software, equipment, client entertainment, etc.). Use the company's category list if provided; otherwise propose one and apply it consistently. Tag anything client-billable separately.
- Flag. Apply the policy if provided; otherwise apply defaults and label them as defaults: duplicate charges, weekend/holiday spend on business cards, round-number amounts, per-transaction limits exceeded, subscriptions appearing monthly with no owner, personal-looking merchants, and split transactions that dodge an approval threshold.
- Report. Write
expense-report.xlsx-ready CSV (or .xlsx if the xlsx skill is available) with the full categorized ledger, plusaudit-findings.md: totals by category, reconciliation gaps, flagged items each with severity and the specific source file cited, and a missing-documentation list to chase.
Rules
- Never fabricate or estimate amounts. An unreadable receipt is logged as unreadable, not guessed.
- Flags are questions, not accusations. Write "no receipt located for..." not "unauthorized spend."
- Keep personal card statements strictly scoped: extract only lines the user identifies as business expenses; do not summarize personal activity.
- Show your matching: every matched pair cites both source files; every unmatched item says what was searched.
- Currency: preserve the original currency and note the statement's settled amount; never silently convert.
- If more than 20% of transactions lack receipts, lead the findings memo with that fact -- it is the finding.
Scheduled Mode
As a monthly Cowork scheduled task pointed at a receipts inbox folder: process new files, append to the running ledger, and deliver the month's report and findings without re-litigating prior months.
Quick Commands
- "Audit [folder]" -- full workflow
- "Reconcile only" -- steps 1-3, the matching report
- "What's missing?" -- unmatched statement lines and the chase list
- "Billable pull" -- client-billable transactions grouped by client