← LeaderboardThe Skill Leaderboard

expense-report

Turn a pile of receipts into an expense claim summary that flags missing receipts, over-limit items and duplicates, delivered as an Excel workbook

Published by genspark-ai ↗genspark-ai/genoffice

Try your first task

Create a draft expense-claim workbook

Start a fresh conversation. Replace the highlighted placeholders.

Use expense-report to prepare a draft Excel claim from [receipts] for [claimant, project and period] under [provided policy, currency and FX rules]. Preserve face amounts, flag unreadable fields as [verify] and never invent attachments or missing receipt details. Build Detail, Summary, Rules and Exceptions sheets, with conversion/limit and summary formulas tied to supplied rules. Reconcile totals, flag duplicates, missing evidence and date/city mismatches; without limits categorize only. Return claimed/reimbursable totals and priority exceptions for finance review. Do not submit the claim or decide tax deductibility.

Required inputs

  • [receipts]
  • [claimant, project and period]
  • [provided policy, currency and FX rules]
  • [verify]

User-approved starter prompt based on a pinned source version; check current skill requirements before running. Task evidence ↗

SKILL.md

name: expense-reportdescription: Turn a pile of receipts into an expense claim summary that flags missing receipts, over-limit items and duplicates, delivered as an Excel workbookcategory: financescenarios: Travel expense claims | Receipt reconciliation | Expense categorisationquickPrompts: Turn these receipts into an expense claim summary | Check which of these expenses break the reimbursement policymetadata:   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 " 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.
expense-report by genspark-ai · The Skill Leaderboard