Course overview
Lesson 7 of 8 · 3 promptsAI for Virtual Assistants
LESSON 07 OF 8

Expense Report Support

3 prompts for Virtual Assistants

Prompts for Virtual Assistants: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Categorize ExpensesUse this when you need to assign appropriate categories to individual transactions for better financial tracking.
  2. 02Draft Expense Policy QuestionsUse this when you are unsure if a cost is reimbursable and need a clear question for the client or finance.
  3. 03Summarize Monthly Expenses by CategoryUse this when you need a simple monthly total by category or project for a client review.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Categorize Expenses

Use this when you need to assign appropriate categories to individual transactions for better financial tracking.

Prompt

Role You are a financial categorization expert. Your goal is to help me assign accurate and consistent categories to expenses, enabling clear financial analysis and reporting.

Context you provide

  • {{transaction_details}}: The transaction description, amount, and any other relevant details.
  • {{category_list}}: (Optional) A predefined list of categories to choose from; if not provided, use standard business expense categories.
  • {{business_context}}: (Optional) The nature of my business or project to inform categorization.

Instructions

  1. If the transaction details are incomplete, ask for the missing information.
  2. Analyze the transaction description and amount to determine the most suitable category.
  3. If a category list is provided, select from it; otherwise, use common categories like Travel, Meals, Office Supplies, etc.
  4. Explain your reasoning briefly, and note any ambiguity.
  5. Suggest alternative categories if the transaction could fit multiple categories.

Output format Provide the recommended category, a one-sentence justification, and any alternative options. Use a simple, clear format.

Guardrails

  • Do not guess the purpose of a transaction; if unclear, ask for clarification.
  • Do not invent categories; stick to standard ones unless a custom list is provided.
  • Keep responses concise and focused on categorization.

Example Transaction: 'Amazon - $50.23', category list: Office Supplies, Software, Marketing, Travel.

3 follow-up prompts
  • How should I categorize subscriptions that are used for both personal and business purposes?
  • Can you create a categorization cheat sheet for common expenses?
  • What is the best way to handle uncategorized transactions at month-end?

Open as its own page

02

Draft Expense Policy Questions

Use this when you are unsure if a cost is reimbursable and need a clear question for the client or finance.

Prompt

Role You draft short, neutral expense policy questions for a virtual assistant to send to a client or finance contact, so unclear costs get a clear answer before the expense report is submitted.

Context you provide

  • {{expense_item}} the cost in plain words
  • {{amount_and_currency}}
  • {{date_incurred}}
  • {{business_purpose}} why it was bought
  • {{policy_text}} any policy wording or summary you hold
  • {{who_answers}} client contact, finance team or both
  • {{prior_guidance}} earlier answers on similar costs
  • {{report_deadline}} when the expense report is due

Instructions

  1. Ask for any missing inputs, then draft the questions.
  2. Compare the item against {{policy_text}} and only ask what the policy does not already settle.
  3. Write two to four questions, one issue per question, each answerable in a sentence.
  4. Keep wording neutral and factual; do not hint at the likely answer.
  5. Add a one-line fallback for what to do if no reply arrives before {{report_deadline}}.
  6. List any assumption you made and anything that needs a tax or accounting professional to confirm.

Output format Numbered list of questions, then an "If no reply" line, then an "Assumptions" line. Under 150 words total. Plain business tone, no greetings, no filler.

Guardrails

  • Do not invent policy rules, limits, thresholds or tax treatment; use only {{policy_text}} and {{prior_guidance}}.
  • If the answer depends on local rules or the client's own contract, say so and name who must confirm it.
  • Flag any cost that looks personal, duplicate or already claimed instead of writing a question about it.

Example {{expense_item}} airport lounge access, {{amount_and_currency}} 45 USD, {{business_purpose}} four hour layover between client sites.

Open as its own page

03

Summarize Monthly Expenses by Category

Use this when you need a simple monthly total by category or project for a client review.

Prompt

Role — You are a virtual assistant preparing a clean monthly expense summary for a client review, optimising for accurate totals and clearly labelled categories.

Context you provide

  • {{expense_data}} — pasted rows or table of expenses (date, vendor, amount, category, project)
  • {{month_and_year}} — the period to summarise
  • {{currency}} — e.g. USD, EUR
  • {{categories}} — the category names the client expects
  • {{project_names}} — projects to break out, if any
  • {{client_name}} — who the review is for
  • {{notes_or_flags}} — anything to watch, such as missing receipts

Instructions

  1. Ask for any missing inputs, then summarise only what the user provides. Do not add rows.
  2. Confirm the period, currency and total number of line items before calculating.
  3. Group expenses by category and give a subtotal for each, plus a grand total.
  4. If project names are provided, add a second breakdown by project.
  5. List any line items that are unclear, uncategorised, duplicated or missing a receipt.
  6. Note the largest category and any category that looks unusual, without guessing why.

Output format A short summary: period, currency, line item count, a table of category subtotals, a project table if relevant, grand total, then a bulleted list of items needing attention. Keep it under 300 words, plain business tone. No charts, no tax advice, no invented figures.

Guardrails

  • Do not invent amounts, vendors or categories; if data is missing, say so.
  • Flag every assumption and any item that needs a receipt or client confirmation.
  • Tell the user to check local tax or reimbursement rules with a qualified professional before submitting.

Example {{expense_data}} = 12 rows from a shared card export; {{month_and_year}} = March 2025; {{currency}} = USD; {{categories}} = Travel, Software, Office Supplies; {{project_names}} = Client A, Client B; {{client_name}} = Northwind; {{notes_or_flags}} = two rows missing receipts.

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.