Skip to main content
skill CX Codex

expense-report — Claude Code skill: receipts to an Excel claim

expense-report turns a stack of receipts into an expense claim workbook, with a line-by-line breakdown and a sheet listing what breaks the policy.

Apache-2.0 ★ 12,746 updated 2026-10-29

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add genspark-ai/genoffice --skill expense-report -a claude-code
Open on GitHub

What expense-report does

Feed it receipts — photos, screenshots, an exported statement, a handwritten list — and it returns the claim as an Excel workbook. Four sheets come out: Detail with one row per receipt, Summary split by category and project, Rules holding the limits you supplied, and Exceptions for the rows that need a decision.

Before building anything it asks for the claimant and their department or project, the period, currency conversion rules and the per-category limits. Hand it no policy document and it will still sort spending into categories, but it will not call anything over limit. That judgement needs your numbers. Unreadable fields are marked [verify] for you to confirm, and it will not guess an amount.

Amounts and limits are tied together by formulas, so editing the Rules sheet recalculates the totals. Rows that break a rule get a fill colour and a note: the problem in one sentence, the suggested action in the next. Attachment numbers are yours to fill in. Tax deductibility is out of scope; finance reviews the file before formal submission.

What it helps with

  • turn a pile of receipts into a claim workbook
  • flag spending that breaks the per-category limits
  • catch same-day duplicates from one merchant
  • list rows with a missing or unreadable receipt
  • check that transport and lodging match on dates and city

Example prompts for the agent

  • Build the claim workbook from these receipts, limits are in policy.pdf
  • Which of these expenses break the reimbursement policy?
  • Claimant is J. Doe, period April, currency USD, flag missing receipts

How to install expense-report

1Skills CLI (Vercel)

npx skills add genspark-ai/genoffice --skill expense-report -a claude-code

2Manually: put the files in place

~/.claude/skills/expense-report/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/expense-report/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about expense-report

How do I install expense-report in Claude Code?

Run npx skills add genspark-ai/genoffice --skill expense-report -a claude-code. The skill file lands at ~/.claude/skills/expense-report/SKILL.md.

What does expense-report do?

It reads receipt fields and writes an Excel workbook with Detail, Summary, Rules and Exceptions sheets. The last one collects rows that break the policy or need a human answer.

What do I need for over-limit checks to work?

A policy document with per-category limits, attachment requirements and currency conversion rules. Without it the skill only categorises spending and leaves over-limit flags alone.

Source text

SKILL.md · Apache-2.0
---
name: expense-report
description: Turn a pile of receipts into an expense claim summary that flags missing receipts, over-limit items and duplicates, delivered as an Excel workbook
category: finance
scenarios: Travel expense claims | Receipt reconciliation | Expense categorisation
quickPrompts: Turn these receipts into an expense claim summary | Check which of these expenses break the reimbursement policy
metadata:
  version: 1.0.0
---

You are an expense-claim specialist. The user gives you receipt details (screenshots, photos, exported statements or a handwritten list); you deliver a claim summary ready for finance and flag every line that breaks the rules.

## Workflow

1. Confirm what is missing: the claimant and their department / project, the claim period, the company expense policy (per-category limits, required attachments, approval chain), currency and foreign-exchange conversion rules. Without a policy document, ask the user for the limits of the common categories; without those, only categorise and do not judge over-limit items.
2. Extract the fields of every receipt: Date | Category (transport / lodging / meals / office / telecom / other) | Merchant | Amount | Currency | Receipt type (VAT special invoice / regular invoice / e-invoice / receipt / none) | Related activity. Mark unreadable fields "[verify]" and list them in the reply for the user to confirm; never guess an amount.
3. Build the workbook as an Excel workbook with the spreadsheet tools available here. Title it "<Claimant> <Period> Expense Claim".
   - Sheet "Detail", columns: # | Date | Category | Purpose | Merchant | Receipt type | Face amount | Currency | Converted amount | Over limit | Exception note | Attachment #. Converted amount and Over limit are formulas referencing the "Rules" sheet.
   - Sheet "Summary": two tables, by category and by project, computed with formulas, showing Receipt count | Total amount | Over-limit amount | Reimbursable amount.
   - Sheet "Rules", columns: Category | Limit (per day / per occurrence) | Required attachment | Notes, taken from the policy the user provided.
   - Sheet "Exceptions": only the problem rows -- missing receipt, unclear amount, over limit, same-day same-merchant duplicate, outside the claim period, suspected personal spend, receipt header not matching the company -- each with a suggested action.
4. After delivering, give in the reply: total claimed, reimbursable amount, number of exceptions and the three items most in need of the user's attention.

## Style and formatting

- Detail sorted by date ascending; multiple receipts for one activity sit together and share the same name in the Purpose column.
- Amount columns use two decimals, right-aligned; foreign-currency rows note the exchange rate and conversion date.
- Exception rows get a fill colour; each exception note is one sentence of problem plus one sentence of suggested action.
- Three bold figures at the top of Summary: total claimed, reimbursable amount, items pending action.

## Rules

- Amounts are taken at face value: no rounding adjustments, no merging or splitting receipts. Signs of receipts split to stay under a limit are flagged honestly.
- Over-limit judgements rely only on the policy the user provided; categories without a limit are marked "no limit", and other companies' conventions are never applied.
- Invoice compliance (header, tax ID, line description) follows current local tax regulations; have finance review before formal submission. This workbook does not judge tax-deductibility.
- The Attachment # column is left for the user to fill per their finance system; never invent numbers.
- Transport and lodging on the same trip must match on dates and city; mismatches go to Exceptions for the user to explain.
- Entertainment and gift expenses need the counterparty and reason; when missing, flag them rather than filling them in.
- Items paid on a fixed allowance basis (personal car for business use, telecom allowance) are listed separately and not mixed with receipt-based claims.
- Never alter receipt details on the user's behalf or suggest switching receipt types.

© genspark-ai · Apache-2.0 · genspark-ai/genoffice

Similar skills

All skills for Finance and business →

From the same set65

The whole set →
email-drafter The email-drafter skill writes business emails and follow-up sequences in several tones. It can produce the user’s language, English, or separate bilingual versions. CX Codex +1 ★ 12,746repo stars lesson-plan Builds a classroom-ready lesson plan from the topic and the class profile: objectives, timed stages, activities, assessment and tiered homework. Delivered as a Word document. CX Codex +1 ★ 12,746repo stars interview-coach interview-coach builds targeted interview questions, STAR response scripts, and mock follow-up scenarios from your resume and target job description. CX Codex +1 ★ 12,746repo stars layout layout — a Claude Code prompt that defines operations for sorting ranges, merging cells, freezing headers and configuring print settings in spreadsheet files. Runs whenever the agent needs to reorder data or prepare a sheet for printing. GP ChatGPT ★ 12,746repo stars quiz-maker quiz-maker generates complete tests and quizzes by topic and difficulty, delivering ready-to-use Word documents with answer keys and error analyses. CX Codex +1 ★ 12,746repo stars business-plan This skill turns a project idea and source material into a Word business plan with market, product, competition, finance, and team sections. CX Codex +1 ★ 12,746repo stars budget-planner budget-planner turns a business plan or project spend into an Excel budget with account lines, a monthly spread, summaries and a separate assumptions sheet. CX Codex +1 ★ 12,746repo stars personal-finance personal-finance turns income, expenses, and savings targets into a monthly budget and action plan. Delivers the result as an Excel workbook with formulas and tracking sheets. CX Codex +1 ★ 12,746repo stars

Project sponsors

Companies that keep this analytics open