Expense Reports and Reconciliation
Expense reports are one of the least glamorous and most error-sensitive parts of the executive assistant role. Receipts pile up, categories blur together, policy rules are easy to miss, and the finance team returns anything that does not reconcile to the penny. It is repetitive, detail-heavy work, which makes it a natural fit for AI assistance. The goal is not to hand off your judgment but to let the AI do the sorting, categorizing, and cross-checking so you can review a clean draft instead of building one from scratch.
This lesson shows you how to use AI to organize receipts, categorize spending against policy, catch mismatches before finance does, and draft the summary that goes with the report.
What You'll Learn
- How to turn a messy list of receipts into an organized, categorized expense draft
- A prompt pattern for checking expenses against a spending policy
- How to reconcile a report against a card statement and flag discrepancies
- How to draft a clear expense summary and handle sensitive items with care
Organizing and Categorizing Receipts
Start by getting every expense into one place as plain text: date, vendor, amount, and what it was for. You can type these from receipts or paste from a spreadsheet. Then let the AI structure them.
Prompt:
Below is a list of expenses from my executive's business trip. Organize them into a clean table sorted by date. Add a category column using these categories: Airfare, Lodging, Ground Transport, Meals, Client Entertainment, and Other. Total each category and give a grand total. Flag anything you were unsure how to categorize. [paste expenses]
You now have a categorized draft with subtotals, which is most of the report already assembled.
Checking Against Policy
Every organization has spending rules: meal caps, receipt thresholds, what needs pre-approval. The AI can screen the report against those rules if you give them to it.
Prompt:
Here is our expense policy: meals are capped at 75 per person per day, any single expense over 50 requires an itemized receipt, and client entertainment over 200 needs manager pre-approval. Check the expense list against these rules and flag every item that may violate a rule or need extra documentation. For each flag, tell me exactly which rule applies.
Policy screening becomes a review task instead of a hunt.
| Criteria | Manual policy check | AI-assisted policy check |
|---|---|---|
| Coverage | Easy to skip a line | Every line screened |
| Rule recall | From memory | Applied from the pasted policy |
| Speed | Slow line-by-line | Whole report at once |
| Your role | Finding violations | Reviewing flagged items |
Manual policy check
- Coverage
- Easy to skip a line
- Rule recall
- From memory
- Speed
- Slow line-by-line
- Your role
- Finding violations
AI-assisted policy check
- Coverage
- Every line screened
- Rule recall
- Applied from the pasted policy
- Speed
- Whole report at once
- Your role
- Reviewing flagged items
The AI catches the routine violations so you can focus on the judgment calls, like whether a borderline client dinner was reasonable in context.
Reconciling Against the Card Statement
Reconciliation is where reports get rejected. Every expense on the report should match a charge on the corporate card statement, and any charge without a matching receipt needs explaining. This cross-check is tedious by hand and quick for an AI.
Prompt:
I have two lists below. The first is the expense report I built. The second is the corporate card statement for the same period. Match them line by line. Tell me: (1) charges on the statement with no matching expense on the report, (2) expenses on the report with no matching charge, and (3) any amounts that are close but not identical. Present the unmatched and mismatched items in a short table. [paste both lists]
This is the single highest-value use of AI in the whole expense workflow, because it catches exactly the errors finance would bounce the report for.
Drafting the Summary
Finance and your executive both appreciate a short narrative that explains the report. Let the AI write the first draft.
Prompt:
Write a three-sentence summary for this expense report covering the trip purpose, the total amount, and any items I flagged for explanation. Keep it factual and professional, suitable to send to the finance team.
Handling Sensitive Information
Expenses can reveal private details: personal card numbers, home addresses, health-related purchases, personnel matters. Be deliberate about what you share with an AI tool.
- Redact account numbers and personal identifiers before pasting. The AI does not need a full card number to categorize a charge.
- Follow your organization's data rules. If your workplace restricts what can go into external tools, treat expense data as covered by those rules.
- Never let the AI invent amounts. Instruct it to work only from the figures you provide and to flag anything missing rather than filling a gap.
Verify Before You Submit
The numbers have to be exactly right, and AI arithmetic on long lists is usually reliable but not guaranteed. Two safeguards:
- Recompute the totals yourself or with a spreadsheet before submitting. Treat the AI's totals as a draft.
- Confirm every flagged item against the actual receipt or policy document rather than the AI's paraphrase of it.
Key Takeaways
- Turn a messy receipt list into a categorized draft with subtotals in one prompt
- Screen the report against your spending policy by pasting the rules into the prompt
- Reconcile the report against the card statement to catch the errors finance would reject
- Redact sensitive identifiers and instruct the AI to work only from figures you provide
- Recompute totals and verify flagged items before submitting the report