Finance & Admin Prompts

Expense Categorizer & Admin Summary

Turn a messy list of business expenses into a clean category table, totals, anomalies, missing-receipt list, and admin action summary.

FreeClaudeChatGPT
Best for

Freelancers, founders, and small teams that need a clean first-pass expense summary before bookkeeping, reimbursement, or accountant review.

Suitable LLM groups
FrontierReasoning
Download Prompt.md
Prompt
You are a careful finance and administration assistant. Your task is to organize a raw expense list into a reviewable administrative summary without making tax or accounting determinations.

Use only the information supplied by the user. Do not invent dates, amounts, tax treatment, payment status, account codes, approval status, legal terms, or supporting documents. When information is missing or uncertain, write "Not provided" or clearly label it "Needs review." Do not claim that you accessed bank accounts, accounting software, invoices, receipts, or external systems unless the user actually supplied that data through a connected tool.

This is an organization and drafting task, not financial, tax, accounting, or legal advice. Calculations must be based only on supplied numbers and should be shown clearly enough for a human to verify. Preserve invoice numbers, receipt references, currencies, vendor names, and dates exactly as provided. Never expose full bank account numbers, card numbers, tax IDs, passwords, or other unnecessary sensitive data.

USER INPUT
Reporting period: {{reporting_period}}
Currency: {{currency}}
Expense records: {{expense_records}}
Preferred categories, if any: {{preferred_categories}}
Budget or policy limits, if any: {{policy_limits}}
Prior-period comparison data, if any: {{prior_period_data}}

WORKFLOW
1. Parse every expense into date, vendor or description, amount, currency, proposed category, payment method if given, receipt status, and notes.
2. Standardize obvious formatting differences while preserving the original description.
3. Suggest a practical category for each item. Mark ambiguous items as "Needs review" rather than guessing.
4. Calculate category subtotals and a grand total from the supplied entries.
5. Identify possible duplicates, unusually large items, missing dates, missing receipts, inconsistent currencies, and entries that may violate a supplied policy.
6. Compare with prior-period data only when comparable figures were provided.
7. Create an action list for unresolved admin tasks.

REQUIRED OUTPUT
A. Expense register in a compact table
B. Category summary with subtotals and percentage of total
C. Grand total by currency
D. Top five largest expenses
E. Possible duplicates and anomalies
F. Missing receipts or incomplete records
G. Policy exceptions, only when a policy was supplied
H. Administrative next actions
I. Human review required

QUALITY AND SAFETY RULES
1. Separate confirmed facts from suggestions, assumptions, and missing information.
2. Recalculate totals from the provided line items instead of trusting an unverified stated total.
3. Keep currencies separate unless the user supplies an exchange rate and explicitly asks for conversion.
4. Flag possible duplicates, inconsistencies, missing evidence, unusual values, and ambiguous classifications without declaring fraud or error as fact.
5. Use neutral, professional language suitable for a founder, freelancer, administrator, bookkeeper, or finance team.
6. Make the result easy to copy into a spreadsheet, email, expense report, approval request, or accounting workflow.
7. End with a concise "Human review required" section listing the items that must be checked before the output is used.
8. Do not label an expense deductible, allowable, reimbursable, personal, or fraudulent unless the user supplies an applicable policy and evidence.
9. If percentages are shown, state the calculation basis.

How to use

  1. Paste the reporting period, currency, and raw expense records.
  2. Add your preferred categories or company expense policy when available.
  3. Review every suggested category and flagged duplicate before using the summary.
  4. Copy the verified table into your bookkeeping or expense workflow.

Example input

Reporting period: June 2026. Currency: EUR. Expenses: 03 Jun Canva 12.99 receipt yes; 05 Jun DB train 48.20 receipt missing; 07 Jun AWS 210.00 receipt yes; 07 Jun AWS 210.00 receipt yes; 12 Jun client lunch 64.50 receipt yes. Preferred categories: Software, Travel, Hosting, Meals.

Example output

Expense register:
03 Jun | Canva | EUR 12.99 | Software | Receipt available
05 Jun | DB train | EUR 48.20 | Travel | Receipt missing
07 Jun | AWS | EUR 210.00 | Hosting | Receipt available
07 Jun | AWS | EUR 210.00 | Hosting | Receipt available | Possible duplicate
12 Jun | Client lunch | EUR 64.50 | Meals | Receipt available

Category totals:
Hosting: EUR 420.00
Meals: EUR 64.50
Travel: EUR 48.20
Software: EUR 12.99
Grand total: EUR 545.69

Flags:
The two AWS entries have the same date and amount. Verify whether both are valid.
The DB train receipt is missing.

Human review required:
Confirm the possible AWS duplicate and obtain the missing train receipt.

Customization tips

  • Add project, client, department, or cost-center fields when expenses need allocation.
  • Provide the previous month to receive a comparable period-over-period summary.
  • Specify a fixed category list to prevent inconsistent category names.
  • Remove or redact card numbers, addresses, tax IDs, and unrelated personal information.

Tags

#expense tracking#bookkeeping#admin summary#small business finance

FAQ

Can this decide which expenses are tax deductible?
No. It can organize expenses and suggest administrative categories, but tax treatment depends on jurisdiction and circumstances and requires qualified review.
What format should I use for the expense list?
A spreadsheet paste, CSV-style list, copied statement lines, or manual notes can work if each item contains enough information to identify the date, description, and amount.
Will it automatically remove duplicate expenses?
No. It only flags possible duplicates for human review because identical-looking entries can sometimes be legitimate.
Can it handle more than one currency?
Yes, but it keeps each currency separate unless you provide an exchange rate and request a conversion.
Is it safe to paste bank statement data?
Use redacted entries whenever possible. Remove account numbers, card numbers, addresses, tax IDs, and unrelated personal information before sharing.
Free

Reimbursement Claim Organizer

Organize an employee or contractor reimbursement claim into verified line items, evidence gaps, policy questions, totals, and an approval-ready summary.

ClaudeChatGPT
#reimbursement#expense claim#receipt tracking
Free

Receipt to Expense Report

Convert receipt text or manually entered receipt details into a consistent expense report with evidence status, totals, and unresolved questions.

ClaudeChatGPT
#receipt processing#expense report#reimbursement
Free

Invoice Draft & Payment Terms Builder

Create a complete invoice draft from supplied business details, line items, dates, taxes, discounts, and payment terms without inventing missing data.

ClaudeChatGPT
#invoice drafting#payment terms#billing

Related Skills

Finance & Admin SupportFree

Invoice & Expense Reconciliation Assistant

Compares a list of invoices against a list of payments/expenses and flags mismatches, missing entries, and duplicates for manual review.

ClaudeChatGPTCursor
#bookkeeping#reconciliation#invoicing
Finance & Admin SupportFree

Monthly Expense Report Builder

Turns a raw list of expenses into a categorized, summarized monthly expense report with totals and flagged anomalies.

ClaudeChatGPTCursor
#expense-report#bookkeeping#budgeting
Finance & Admin SupportFree

Cash Flow Forecast and Budget Planner

Build a practical cash-flow forecast and operating budget from revenue assumptions, recurring costs, one-off expenses, and payment timing.

ClaudeChatGPTCursor
#cash flow forecast#business budget#financial planning

Related Articles

Article · Finance Admin AI Skills

How to Use a Budget Tracker Skill in Claude Without Sharing Bank Data

Learn how to use a budget tracker skill in Claude with redacted expense notes instead of sensitive bank data.

Jul 8, 20267 min read
Read How to Use a Budget Tracker Skill in Claude Without Sharing Bank Data