← ClaudeAtlas

expense-auditlisted

Month-end audit of employee expense reports. Takes the month's export from the expense tool, converts every line to USD at the finance month-end rates, checks each employee's report against the travel and expense policy (category caps, receipts, pre-approvals, duplicates, late submissions), auto-approves clean reports, routes everything else to the controller for a decision, and files the audit report for payroll. Use when someone asks to "run the expense audit", "close out expenses for <month>", or "check this month's expense reports".
trevhud/rote · ★ 8 · AI & Automation · score 71
Install: claude install-skill trevhud/rote
# Month-End Expense Audit Run this after the expense tool's submission window closes. The input is the month's export: one row per expense line, plus the reporting period (`YYYY-MM`). Payroll reimburses from the filed report, so every number in it has to be traceable to a rule in [references/expense-policy.md](references/expense-policy.md). Work through the steps in order. Steps 1 to 3 do not depend on each other, so do them together. ## Step 1: Convert every line to USD Look up the period's month-end rates in [references/fx-rates.md](references/fx-rates.md) and convert each line's `amount` from its `currency` to USD. Use the month-end rate of the reporting period for every line, even lines dated in an earlier month. Round to the cent only after converting. If a line uses a currency that isn't in the table, stop and ask finance for the rate. Do not look one up online. Payroll must match the general ledger. ## Step 2: Check for duplicate submissions (MANDATORY) Two lines are duplicates when they have the same employee, merchant (ignore case), amount, currency, and date. Keep the first one submitted (lowest expense id) and flag every later copy. Duplicates are a **block**: they go back to the employee and the controller cannot approve them. This check is mandatory. Run it on every line, every month, even when the batch looks small enough to eyeball. ## Step 3: Check for late submissions (MANDATORY) The policy window is 60 days. Flag any line dated more than 60 days bef