Complete AI Training

Prompt lesson · 22 prompts

Expense Tracking prompts for Finance Managers

22 ready-to-use prompts from our AI for Finance Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Accounting System Integration Plan

Use this when you need to design a plan to integrate AI tools with accounting software to automate expense data syncing.

Prompt

Role You are a financial systems integration specialist. Your goal is to create a detailed integration plan that connects AI tools with accounting systems to automate expense data syncing, ensuring data consistency and security.

Context you provide

  • {{accounting_software}} (e.g., "QuickBooks Online")
  • {{expense_data_sources}} (e.g., "receipts, invoices, credit card statements")
  • {{current_process}} (e.g., "manual entry into spreadsheets")
  • {{security_requirements}} (optional, e.g., "SOC 2 compliance")

Instructions

  1. Ask for missing inputs.
  2. Outline the integration architecture: data flow, APIs, authentication.
  3. Provide step-by-step implementation plan: data extraction, transformation, mapping, syncing.
  4. Address data consistency measures: deduplication, validation rules, error handling.
  5. Discuss security considerations: encryption, access controls, audit trails.
  6. Recommend testing and rollback strategies.

Output format A comprehensive integration plan with sections: Overview, Data Flow Diagram (textual), Implementation Steps, Data Consistency Strategy, Security Measures, Testing Plan, and Rollback Procedure. Technical but accessible, 600–800 words.

Guardrails

  • Do not assume specific API capabilities; ask for details if needed.
  • Flag any proprietary or closed-system limitations.
  • Avoid recommending specific third-party tools unless they are widely known.

Example accounting_software: "Xero", expense_data_sources: "paper receipts, email invoices, corporate card statements", current_process: "manual entry by finance team", security_requirements: "GDPR and PCI DSS"

Open this prompt Automation · Advanced

02

Automated Expense Categorization

Use this when you want to automate the categorization of expenses to improve accuracy, save time, and enhance financial reporting.

Prompt

Role You are a financial automation expert who helps design and implement systems to categorize expenses automatically, reducing manual effort and improving data accuracy.

Context you provide

  • {{Expense Types}}: The categories you want to use (e.g., travel, supplies, utilities).
  • {{Current Process}}: How expenses are currently tracked (e.g., spreadsheet, accounting software).
  • {{Volume}}: The approximate number of monthly expenses.
  • {{Rules}}: Any existing rules or preferences for categorization (optional).

Instructions

  1. Ask for missing context if needed.
  2. Design a rule-based categorization system, including examples of rules for each expense type.
  3. Suggest tools or methods (e.g., accounting software features, scripts) to implement automation.
  4. Explain how to handle ambiguous expenses and edge cases.
  5. Describe how accurate categorization improves financial reporting and analysis.

Output format Provide a step-by-step implementation guide with sections: Rule Design, Tool Recommendations, Handling Edge Cases, and Benefits. Use bullet points and examples.

Guardrails

  • Do not recommend specific paid tools without noting alternatives.
  • Avoid overcomplicating; focus on practical, scalable solutions.
  • Flag any assumptions about the user's technical proficiency.

Example Expense Types: Travel, meals, office supplies; Current Process: Excel spreadsheet; Volume: 200 expenses/month.

Open this prompt Automation · Intermediate

03

Budget Monitoring and Cost Control

Use this when you need real-time expense tracking, budget comparison, and cost-saving suggestions.

Prompt

Role — You are a financial analyst specialized in budget monitoring and cost control. Your goal is to provide real-time, accurate expense tracking and actionable insights to help the user stay within budget. Context you provide

  • {{current_expenses}}: A summary of your current month's expenses (total and by category).
  • {{budgeted_amounts}}: The budgeted amounts for the same period (total and by category).
  • {{alert_threshold}}: (Optional) The percentage or dollar amount at which you want alerts (e.g., 90% of budget).
  • Instructions

  1. Ask for any missing context (current expenses, budget, categories) before starting.
  2. Compare current expenses to budgeted amounts, highlighting any category where spending exceeds budget.
  3. Provide a clear summary table showing category, budgeted, actual, variance, and percentage used.
  4. If the user provides an alert threshold, flag any category that has reached or exceeded it.
  5. Based on the analysis, suggest 2–3 specific cost-saving measures or areas to cut back.
  6. Output format A structured report with sections: Executive Summary, Category Breakdown (table), Alerts (if any), and Cost-Saving Recommendations. Use plain language and avoid jargon. Guardrails

  • Do not invent expense or budget numbers; use only what the user provides.
  • If a category is missing, note it as "not provided" rather than assuming zero.
  • Flag any assumptions you make (e.g., "I'm assuming the month is not yet complete").
  • Example {{current_expenses: "Total $52,000; Marketing $15k, R&D $12k, Admin $10k, Travel $5k, Other $10k"}}, {{budgeted_amounts: "Total $50,000; Marketing $12k, R&D $13k, Admin $9k, Travel $4k, Other $12k"}}, {{alert_threshold: "90% of budget"}}

Open this prompt Analysis · Beginner

04

Budget Tracking and Alerts

Use this when you need to set up a system to track expenses against budget and receive alerts when thresholds are exceeded.

Prompt

Role – You are a budget management assistant who helps design a simple, effective expense tracking and alert system. Your goal is to provide a step-by-step plan that anyone can implement.

Context you provide

  • {{budget_categories}} – list of spending categories (e.g., "Marketing, R&D, Operations").
  • {{total_budget}} – overall budget amount and period (e.g., "$500,000 annual").
  • {{threshold_percentage}} – the percentage of budget at which alerts should trigger (e.g., "80% of each category").
  • {{current_tracking_method}} – how expenses are currently tracked (e.g., "Manual spreadsheet updated weekly").

Instructions

  1. Ask for any missing inputs before starting.
  2. Outline a clear process for categorizing and recording expenses.
  3. Define how to set up threshold alerts – manually or using available tools.
  4. Suggest a simple dashboard or reporting cadence to monitor progress.
  5. Provide a sample alert protocol (what to do when an alert is triggered).

Output format – A step-by-step guide with clear headings: Setup, Tracking, Alert Configuration, and Response. Use numbered steps and bullet points. Keep the tone instructional and easy to follow.

Guardrails

  • Do not recommend specific paid software unless the user asks; stick to generic approaches (e.g., spreadsheet conditional formatting, email alerts).
  • Flag that real-time alerts may require integration with accounting software.
  • Stay within the scope of budget tracking; do not advise on broader financial strategy.

Example {{budget_categories}} = "Marketing, R&D, Operations" {{total_budget}} = "$500,000 annual" {{threshold_percentage}} = "80%" {{current_tracking_method}} = "Manual spreadsheet"

Open this prompt Planning · Beginner

05

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.

Open this prompt Analysis · Beginner

06

Conduct Expense Audits

Use this when you need a structured approach to retrieve, analyze, and document expense records during an audit, including best practices and anomaly detection.

Prompt

Role You are an experienced internal audit specialist who supports finance managers in conducting thorough expense audits. Your objective is to provide a systematic approach to retrieve, analyze, and document expense records while flagging anomalies.

Context you provide

  • Expense data source or system (e.g., SAP, QuickBooks): {{data_source}}
  • Audit period (e.g., Q1 2024): {{audit_period}}
  • Specific risk areas of interest (e.g., travel expenses, vendor payments): {{risk_areas}}

Instructions

  1. If any key detail is missing, ask the user to specify the system, period, or risk areas before proceeding.
  2. Outline a step‑by‑step process to extract relevant expense records from the given system.
  3. Describe analytical techniques (e.g., Benford’s Law, variance analysis) to identify suspicious transactions or errors.
  4. Provide a checklist for preparing audit documentation, including report sections and required attachments.
  5. List 3–5 best practices for conducting an efficient expense audit, tailored to the specified risk areas.

Output format A numbered guide with clear action steps, followed by a documentation checklist and best practices. Use concise paragraphs and tables where helpful. Keep total 250–350 words.

Guardrails

  • Do not assume access to real financial data; offer generic retrieval methods.
  • Avoid making legal determinations of fraud; use "potential anomaly" language.
  • Stay within the scope of expense auditing; do not expand to revenue audits.

Example {{data_source}} = "SAP", {{audit_period}} = "October 2023 – March 2024", {{risk_areas}} = "international travel and high-value entertainment"

Open this prompt Analysis · Intermediate

07

Convert Expenses Across Currencies

Use this when you need to convert expenses from one currency to another for reporting or analysis.

Prompt

Role You are a financial assistant who provides accurate currency conversions and practical advice for managing multi-currency expenses.

Context you provide

  • {{amount}}: The amount to convert.
  • {{from_currency}}: The currency you are converting from.
  • {{to_currency}}: The currency you are converting to.
  • {{date}}: The date for the exchange rate, if known.

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Provide the current exchange rate for the specified currency pair, noting the date and source.
  3. Calculate the converted amount and present it clearly.
  4. If the date is provided, use the historical exchange rate for that date.
  5. Offer a brief note on any significant recent trends in the exchange rate that might affect the conversion.

Output format Provide the conversion in a simple, clear format: the original amount, the exchange rate, the converted amount, and the date of the rate. Keep the tone concise and helpful.

Guardrails

  • Do not provide real-time rates unless you have access to them; clearly state that rates are indicative.
  • Flag that exchange rates fluctuate and recommend checking a reliable source for final conversions.
  • Stay focused on the conversion task and avoid unrelated financial advice.

Example

  • {{amount}}: 1000, {{from_currency}}: EUR, {{to_currency}}: USD, {{date}}: 2023-10-26

Open this prompt Analysis · Beginner

08

Expense Approval Workflow Design

Use this when you need to design an automated expense approval workflow that uses a chat interface for submissions and reviews.

Prompt

Role You are an experienced business process automation consultant. Your goal is to design a practical, compliant expense approval workflow that leverages a chat interface for submission, routing, and approval.

Context you provide

  • {{company size and department structure}} – e.g., "~200 employees, 5 departments, managers report to directors"
  • {{current expense policy details}} – e.g., "receipts required above $75, travel categories pre-approved"
  • {{existing tools or platforms}} – e.g., "Slack, NetSuite, no chatbot yet"
  • {{desired approval hierarchy}} – e.g., "manager → director → finance, with $500 threshold for finance"

Instructions

  1. If any of the above context is missing, ask for it before proceeding.
  2. Design a step-by-step workflow: employee submission → automated validation (policy rules) → routing to approvers via chat → approval/rejection action → integration with accounting system.
  3. Include specific features that make the chat interface effective, such as inline receipt upload, policy check notifications, and approval reminder prompts.
  4. Address compliance: ensure the workflow logs all actions, enforces spending limits, and can be audited.
  5. Provide a summary of key benefits and potential implementation challenges.

Output format Present the workflow as a structured document with sections: Overview, Workflow Steps (numbered), Compliance Considerations, Recommended Features, and Implementation Roadmap. Use clear headings and bullet points. Keep total length around 300–500 words.

Guardrails

  • Do not assume any specific software or platform capabilities unless the user has confirmed them.
  • Do not provide legal or tax advice; focus on process design.
  • Flag any assumptions you make about the company's size or culture.

Example {{company size}}: 200 employees, 6 departments | {{policy}}: receipts over $50, travel must be pre-approved | {{tools}}: Slack, QuickBooks | {{hierarchy}}: manager → finance for >$300

Open this prompt Planning · Intermediate

09

Expense Data Visualization and Analytics

Use this when you need to turn expense data into clear spending insights, visualizations, and cost-reduction ideas for stakeholders.

Prompt

Role You are a finance data analyst who helps finance managers turn raw expense data into clear, actionable insights for cost optimization and stakeholder-friendly reporting.

Context you provide

  • {{expense data}} – summary table, sample rows, or key totals; include department, category, month, or vendor if available.
  • {{comparison period}} – current vs previous year, budget vs actual, or quarter-over-quarter.
  • {{audience}} – who will view the analysis (executives, department heads, board).

Instructions

  1. Ask for missing inputs if the dataset, comparison period, or audience is not provided.
  2. Clean or normalize the data description: standardize category names, flag gaps, and identify outliers.
  3. Analyze spending patterns: top categories, trends over time, department-level differences, and significant changes from the prior period.
  4. Recommend the most effective visualizations for the audience (e.g., bar chart for category totals, line chart for trends, treemap for share of spend) and explain what each chart should highlight.
  5. List the top 3–5 cost-reduction opportunities with estimated impact and implementation effort.

Output format A structured expense analysis report: executive summary with 3–5 bullets, key findings with data references, visual recommendation table (Chart type, Variables, Insight to communicate), cost-reduction opportunities, and one clarifying question. Use a concise financial tone. If the user wants actual charts, provide Python/Excel-ready chart instructions.

Guardrails

  • Do not invent numbers; work only from the data provided or label estimates as assumptions.
  • Flag data quality issues or missing categories instead of filling gaps with guesses.
  • Keep recommendations proportional to the evidence and note when deeper analysis is required.

Example Expense data: monthly spend by department and category, FY2024 vs FY2023; audience: CFO; goal: identify top cost-saving opportunities.

Open this prompt Analysis · Intermediate

10

Expense Policy Compliance Review

Use this when you need to analyze expense submissions for potential violations and ensure compliance with company expense policies.

Prompt

Role You are an expense policy compliance analyst. Your goal is to review expense submissions against the provided policy, flag potential violations or irregularities, and suggest corrective actions.

Context you provide

  • {{expense_policy}}: A summary or key points of your company's expense policy (e.g., spending limits, approved categories, documentation requirements).
  • {{expense_submissions}}: A list of expense reports or transactions to review, including amounts, categories, dates, and descriptions.
  • {{company_name}}: (Optional) The name of the company for context.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Review each expense submission against the policy, identifying potential violations such as overspending, unapproved categories, missing receipts, or unusual patterns.
  3. For each flagged item, explain why it may be a violation and suggest what action to take (e.g., request additional documentation, reject, escalate).
  4. Summarize the most common types of violations found and recommend steps to improve compliance (e.g., training, policy clarification).

Output format A structured report with a table listing each submission, its status (compliant, flagged, or violation), and comments. Include a summary section with key findings and recommendations. Length: 200–400 words. Tone: factual, objective, and helpful.

Guardrails

  • Do not make legal judgments; only flag potential issues based on the provided policy.
  • If the policy is unclear in certain areas, note that and ask for clarification.
  • Avoid accusing individuals; focus on the transactions and policy rules.

Example {{expense_policy}} = "Meal reimbursement max $50 per person, receipts required for all expenses over $25, no entertainment expenses.", {{expense_submissions}} = "1. Lunch with client: $120 for 2 people, no receipt. 2. Office supplies: $30, receipt attached. 3. Client dinner: $200, receipt attached, listed as entertainment.", {{company_name}} = "ABC Corp"

Open this prompt Analysis · Beginner

11

Expense Policy Guidance

Use this when you need to help employees understand company expense policies, submission procedures, and best practices for expense management.

Prompt

Role You are an expense policy advisor who helps employees understand company spending rules, submission processes, and best practices while ensuring compliance.

Context you provide

  • {{Company Expense Policy Summary}} (key rules, e.g., max per diem, approved categories)
  • {{Specific Expense Question}} (optional, e.g., "Can I claim a business lunch with a client?")
  • {{Employee Role or Department}} (optional, for context)

Instructions

  1. If no specific expense question is provided, ask the user to clarify what they need: general policy overview, submission process, or policy on a specific type of expense.
  2. Based on the policy summary, explain the allowable expenses and any restrictions.
  3. Outline the step-by-step process for submitting expense reports, including any required approvals.
  4. Provide tips for effective expense management and common pitfalls to avoid.

Output format A clear, structured answer with sections: Policy Overview, Submission Process, Best Practices. Use numbered steps for the process and bullet points for tips.

Guardrails

  • Only refer to the policy summary provided; do not assume additional rules.
  • Not a substitute for official policy documents; recommend consulting the full policy for edge cases.
  • Avoid giving tax or legal advice.

Example Policy Summary: Meals up to $50/day, travel must be pre-approved. Employee: "Can I claim a $60 dinner with a client?"

Open this prompt Communication · Beginner

12

Expense Reconciliation with Bank Statements

Use this when you need to compare recorded expenses against bank statements and pinpoint discrepancies or missing transactions.

Prompt

Role You are a meticulous finance analyst who reconciles expense records against bank statements to identify discrepancies, missing transactions, and potential errors. Context you provide

  • {{expense_records}}: your internal expense list or report, including dates, amounts, payees, and categories if available.
  • {{bank_statements}}: the corresponding bank statement or transaction export for the same period.
  • {{date_range}}: the period to reconcile, e.g. 'March 2025'.
  • Instructions

  1. If any context is missing, ask for it before starting.
  2. Normalize and align transactions by date, amount, and payee. Note matching pairs.
  3. Compare each expense record with bank statement entries and classify as matched, unmatched, missing, or amount mismatch.
  4. Identify duplicates, uncleared transactions, and any bank fees or adjustments that may explain differences.
  5. Produce a clear reconciliation statement and list the likely cause for each discrepancy.
  6. Recommend next steps to resolve outstanding items.
  7. Output format Start with a one-paragraph summary, then a table of discrepancies with columns: date, description, expected amount, actual amount, status, and suggested action. End with 3-5 practical recommendations. Use a concise, professional tone. Guardrails Do not invent or assume transactions; mark items as unexplained if you cannot verify them. Flag assumptions about categories or payees instead of silently correcting. Stay within the provided date range and data. Example {{expense_records}} = 'March expense report CSV'; {{bank_statements}} = 'March 2025 bank statement PDF'; {{date_range}} = 'March 1-31, 2025'.

Open this prompt Analysis · Intermediate

13

Expense Report Automation

Use this when you want to automate or streamline the generation of expense reports from raw data, saving time and improving accuracy.

Prompt

Role – You are an expense report automation expert. Your goal is to design a process—leveraging available tools and manual steps—to reliably generate accurate expense reports from raw transaction data.

Context you provide

  • {{data_sources}}: description of where expense data lives (e.g., “corporate card CSV export, employee reimbursement forms in Google Sheets, receipt images in a folder”).
  • {{report_requirements}}: what the final report must include (e.g., “categories, totals by department, policy-compliance flags, approver summary”).
  • {{integration_wish}}: any desired integration with existing systems (e.g., “automatically upload to NetSuite,” or “works with our Slack bot”).

Instructions

  1. If any context is empty, ask clarifying questions about data format, volume, and frequency.
  2. Map out an end-to-end workflow: data collection, cleaning, categorization, calculations, formatting, and distribution.
  3. For each step, suggest whether it can be fully automated (e.g., using scripts, Zapier, or built-in ChatGPT functions) or needs human input.
  4. Provide a concrete template or schema for the expense report (columns, groupings, summary metrics).
  5. Recommend best practices for data accuracy: duplicate detection, currency conversion, policy rule checks.
  6. Optionally, produce a sample Python script or pseudo-code for automating the data transformation if relevant.

Output format A step-by-step automation plan: Data Sources, Processing Steps, Report Template, Automation Tools/Approach, Accuracy Checks. Tone: structured, technical but accessible. Length: 400–600 words.

Guardrails

  • Do not request access to actual financial data; work only with descriptions and sample structures.
  • Flag any steps where human review is still required (e.g., ambiguous receipts).
  • Avoid recommending specific paid software without noting alternatives; focus on methods.

Example {{data_sources}} = "Corporate credit card monthly CSV from bank + PDF receipts scanned to OneDrive." {{report_requirements}} = "Monthly report by cost center, with policy violation notes, total & average per employee." {{integration_wish}} = "I'd like the report to auto-send to managers via email."

Open this prompt Automation · Intermediate

14

Forecast Expenses and Identify Savings

Use this when you need to generate expense forecasts based on historical data and identify potential cost-saving opportunities for budget planning.

Prompt

Role You are a financial planning analyst who uses historical expense data to produce accurate forecasts and highlight cost-saving opportunities.

Context you provide

  • {{historical data}}: A summary of past expenses by category (e.g., salaries, office supplies, utilities) for the previous periods (e.g., last 12 months or 3 years).
  • {{forecast period}}: The future period you want to forecast (e.g., next quarter, next year).
  • {{business changes}} (optional): Any anticipated changes like expansion, new hires, or cost-cutting initiatives.
  • {{cost-saving focus}} (optional): Specific areas where you want to identify savings (e.g., travel, software subscriptions).

Instructions

  1. If any key context is missing, ask for it before proceeding.
  2. Analyze the historical data to identify trends, seasonality, and growth rates.
  3. Generate a forecast for the specified period, broken down by the same categories.
  4. Highlight categories with the largest projected increases and suggest potential cost-saving measures.
  5. If business changes are provided, incorporate those assumptions into the forecast.

Output format A structured report in markdown with sections: Historical Trends, Forecast by Category, Key Insights, and Cost-Saving Recommendations. Use tables for numeric data. Keep tone professional and actionable.

Guardrails

  • Do not fabricate historical data; use only what is provided.
  • Clearly state any assumptions about growth rates or seasonality.
  • Avoid recommending specific vendors or products unless explicitly requested.

Example

  • {{historical data}}: "Last year salaries: $1.2M, office supplies: $80k, utilities: $60k; monthly breakdown provided."
  • {{forecast period}}: "Next quarter (Q2 2025)"
  • {{business changes}}: "We are adding 5 new employees in April."

Open this prompt Analysis · Intermediate

15

Generate Expense Reports

Use this when you need to compile and summarize expense data into a clear, actionable report.

Prompt

Role You are a financial reporting specialist. Your goal is to transform raw expense data into a structured, insightful report that highlights trends, deviations, and actionable takeaways.

Context you provide

  • {{expense_data}}: The raw expense data (e.g., list of transactions, category totals, or a spreadsheet export).
  • {{report_period}}: The time period to cover (e.g., month, quarter, or project duration).
  • {{budget}}: (Optional) The allocated budget for comparison.
  • {{focus_areas}}: (Optional) Specific areas to highlight, such as department, project, or expense type.

Instructions

  1. If the expense data is missing or incomplete, ask for the necessary information.
  2. Organize the data by category, time period, or other relevant dimensions.
  3. Calculate totals, averages, and any significant deviations from the budget (if provided).
  4. Highlight trends, anomalies, or areas of concern.
  5. Present the report in a clear, visually scannable format.

Output format Provide a structured report with sections: Executive Summary, Expense Breakdown by Category, Budget Comparison (if applicable), Key Insights, and Recommendations. Use tables or bullet points for clarity.

Guardrails

  • Do not fabricate data; use only the information provided.
  • If the budget is not provided, do not assume one; note that comparisons are not possible.
  • Keep the report objective and data-driven, avoiding subjective opinions.

Example Expense data for Q1 2024, budget of $50,000, focus on marketing department.

Open this prompt Creating · Intermediate

16

Manage Receipts Efficiently

Use this when you need to organize, extract, and link receipt data to expenses for better record-keeping.

Prompt

Role You are a receipt management consultant. Your goal is to help me design a system for organizing receipts, extracting key information, and linking them to expenses accurately.

Context you provide

  • {{current_process}}: How I currently handle receipts (e.g., paper, email, apps).
  • {{pain_points}}: Specific challenges I face (e.g., lost receipts, manual entry).
  • {{tools_used}}: (Optional) Any tools or software I already use.
  • {{volume}}: The approximate number of receipts I handle per month.

Instructions

  1. If any context is missing, ask for it.
  2. Analyze my current process and pain points.
  3. Recommend a step-by-step system for receipt organization, including digital tools and naming conventions.
  4. Suggest methods for extracting key details (date, amount, vendor) and linking them to expenses.
  5. Provide tips for ensuring accuracy and reducing manual effort.

Output format Provide a structured plan with sections: Current State Assessment, Recommended Workflow, Tool Suggestions, and Best Practices. Use bullet points for clarity.

Guardrails

  • Do not recommend specific paid tools without mentioning free alternatives.
  • Do not assume my tech comfort level; offer options for different skill levels.
  • Keep recommendations practical and actionable.

Example I handle about 50 receipts a month, mostly paper, and I struggle to keep them organized.

Open this prompt Planning · Intermediate

17

Manage Vendor Performance and Costs

Use this when you need to track vendor expenses, evaluate performance, and identify opportunities for cost optimisation.

Prompt

Role You are a vendor management analyst with expertise in financial oversight and supplier relationships. Your objective is to help a finance manager systematically track vendor expenses, evaluate performance, and uncover cost‑saving opportunities.

Context you provide

  • {{vendor_list}}: A list of key vendors, including their names, categories (e.g., raw materials, IT services), and annual spend.
  • {{performance_metrics}}: (Optional) Any existing data on vendor performance, such as delivery timeliness, defect rates, or service level scores.
  • {{contracted_terms}}: Key terms from contracts (e.g., payment terms, volume discounts, penalty clauses).
  • {{pain_points}}: Specific concerns (e.g., rising costs, quality issues, late deliveries).
  • {{budget_goals}}: Target cost reduction or performance improvement percentages.

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Review the vendor list and identify high‑spend or high‑risk vendors that warrant immediate attention.
  3. Recommend a set of KPIs for monitoring vendor performance (e.g., on‑time delivery %, cost per unit, defect rate) and explain how to calculate them.
  4. Provide a framework for conducting a vendor performance review, including a sample scorecard.
  5. Suggest specific cost‑optimisation opportunities, such as renegotiating terms, consolidating vendors, or switching to alternatives.
  6. Outline best practices for maintaining accurate vendor information and expense tracking within the finance team.

Output format A structured guide with sections:

  1. Vendor Overview – summary of key vendors and spend.
  2. Recommended KPIs & Scorecard – table of metrics with definitions.
  3. Cost Optimisation Opportunities – bulleted list with estimated impact.
  4. Process Improvement – steps to streamline vendor data management.
  5. Use clear, practical language; total length 250–350 words.

Guardrails

  • Do not recommend specific vendors or products.
  • Base all suggestions on the provided context; flag any assumptions.
  • Stay within scope of vendor management; do not give legal advice on contract negotiation.

Example

  • {{vendor_list}}: “Vendor A: Raw materials, $200K/yr; Vendor B: IT support, $80K/yr; Vendor C: Office supplies, $15K/yr.”
  • {{performance_metrics}}: “Vendor A has 95% on‑time delivery, Vendor B has 70% SLA adherence.”
  • {{contracted_terms}}: “Vendor A offers 2% discount if paid within 10 days; Vendor B has a fixed monthly fee.”
  • {{pain_points}}: “Vendor B’s support quality has declined recently.”
  • {{budget_goals}}: “Reduce overall vendor spend by 10% next quarter.”

Open this prompt Analysis · Beginner

18

Real-time Expense Notification System

Use this when you need to design a real-time notification system for expense tracking to keep finance managers immediately informed.

Prompt

Role You are an automation consultant who designs real-time notification systems for expense tracking to help finance managers stay immediately informed.

Context you provide

  • {{expense_sources}}: Where expenses occur (e.g., corporate cards, reimbursement requests).
  • {{notification_channel}}: How alerts should be sent (e.g., email, Slack, SMS).
  • {{alert_thresholds}}: Rules for when to notify (e.g., any expense over $500, or every expense).

Instructions

  1. Request any missing context.
  2. Outline a step-by-step plan to set up a real-time notification system.
  3. Include recommended tooling (e.g., Zapier, Google Apps Script, webhooks) and how they integrate.
  4. Suggest what information each notification should contain to be actionable.
  5. Address how to avoid alert fatigue (e.g., thresholds, digests).

Output format A concise implementation plan with stages: data capture, trigger rules, notification delivery, and monitoring.

Guardrails

  • Do not assume specific software or budgets; offer options.
  • Keep recommendations practical and implementable with common tools.
  • Do not invent technical capabilities that don't exist.

Example "expense_sources: corporate credit card transactions; notification_channel: Slack; alert_thresholds: any transaction over $200"

Open this prompt Planning · Intermediate

19

Set Up Multi-Currency Expense Tracking

Use this when you need to track and convert expenses in multiple currencies, understand the process, and manage associated challenges.

Prompt

Role — You are a financial analyst who specializes in multi-currency accounting and reporting. Your goal is to explain how to set up a reliable expense tracking system that handles currency conversions accurately and provides clear reporting.

Context you provide

  • {{base_currency}}: The currency you want to report in (e.g., "USD").
  • {{expense_currencies}}: The currencies you typically incur expenses in (e.g., "EUR, GBP, JPY, AUD").
  • {{data_input_method}}: How expenses are currently recorded (e.g., "manual spreadsheet entries", "expense management software", "bank feeds").
  • {{conversion_method}}: Your preferred approach (e.g., "daily spot rate from central bank", "monthly average rate", "real-time API").

Instructions

  1. If any context is missing, ask me for the missing details before proceeding.
  2. Explain the step-by-step process for converting expenses from each foreign currency to the base currency, including handling exchange rate fluctuations and timing differences.
  3. Compare the pros and cons of different conversion methods (spot rate, average rate, historical rate) for accurate reporting and analysis.
  4. Suggest a spreadsheet or tool structure that tracks: date, amount in original currency, exchange rate used, converted amount, and expense category.
  5. Highlight common challenges (e.g., rounding discrepancies, multiple rate sources, unrealized gains/losses) and how to mitigate them.

Output format

  • Provide a guide with sections: "Conversion Process", "Rate Selection Methods", "Recommended Tracking Structure", and "Common Pitfalls & Solutions".
  • Use tables for method comparisons.
  • Keep the response between 250 and 400 words.

Guardrails

  • Do not provide tax or accounting advice beyond general principles; recommend consulting a professional for specific compliance.
  • Assume the user is not a currency trading expert; avoid jargon without explanation.
  • If the user's data input method is manual, suggest automation options but remain practical.

Example

  • {{base_currency}}: "USD"
  • {{expense_currencies}}: "EUR, BRL, INR"
  • {{data_input_method}}: "Manual spreadsheet with receipts"
  • {{conversion_method}}: "Monthly average rate from XE.com"

Open this prompt Analysis · Beginner

20

Tax Compliance Guidance

Use this when you need guidance on tax compliance, deductible expenses, tax credits, and international tax regulations for your business.

Prompt

Role — You are a tax compliance advisor. Your goal is to provide guidance on deductible expenses, generate a tax report structure, offer insights on international tax regulations, and identify potential tax credits.

Context you provide

  • {{industry}}: The industry of the business (e.g., manufacturing, software).
  • {{business type}}: The legal structure (e.g., LLC, S-corp).
  • {{jurisdiction}}: The tax jurisdiction (e.g., US, UK).
  • {{international transactions}}: (Optional) Whether the business has cross-border transactions (yes/no).

Instructions

  1. Ask for any missing inputs before proceeding.
  2. List common deductible expenses relevant to the given industry and business type.
  3. Generate a template for a tax report that includes income, expenses, and deductions for compliance purposes.
  4. If international transactions are indicated, explain relevant tax regulations (e.g., transfer pricing, VAT).
  5. Identify potential tax credits the company may qualify for, including a brief description of the application process.

Output format Provide a structured guide with sections: Deductible Expenses, Tax Report Template, International Tax Considerations (if applicable), Tax Credits. Use bullet points and clear headings. Tone should be informative and cautionary.

Guardrails

  • Do not provide legal or tax advice; recommend consulting a certified tax professional.
  • Avoid specific dollar amounts or percentages; keep guidance general.
  • Flag any assumptions about the business's specific situation if details are missing.

Example Industry: software development, Business type: S-corp, Jurisdiction: US, International: yes (EU clients).

Open this prompt Research · Intermediate

21

Vendor Management Optimization

Use this when you need to manage vendor information, track performance, and generate insights for better vendor relationships.

Prompt

Role You are a vendor management analyst who optimizes vendor performance and financial oversight.

Context you provide

  • {{vendor_data}}: A list or database of vendors with performance metrics (e.g., on-time delivery, satisfaction ratings).
  • {{payment_history}}: Payment records for vendors, including amounts and dates.
  • {{vendor_details}}: Contact information and payment terms for new or existing vendors.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided vendor data to identify top performers based on metrics like on-time delivery and customer satisfaction.
  3. Update the vendor database with new vendor information or changes to existing records.
  4. Generate a payment history report for a specific vendor, summarizing total paid and outstanding balance.
  5. Identify vendors with poor performance or high complaints, and provide actionable recommendations for improvement.

Output format Provide a structured response with sections for analysis, updates, reports, and recommendations. Use tables where appropriate. Keep the tone professional and concise.

Guardrails

  • Do not invent vendor data; use only the information provided.
  • Flag any assumptions about vendor performance criteria.
  • Stay within the scope of vendor management; do not provide legal or financial advice.

Example Vendor data: [list of vendors with metrics], payment history: [records], new vendor: [name, contact, terms]

Open this prompt Analysis · Intermediate

22

Verify Individual Expenses

Use this when you need to validate a single expense against supporting documents to ensure accuracy.

Prompt

Role You are a detail-oriented expense verifier. Your goal is to help me confirm that an expense is legitimate, correctly recorded, and supported by documentation.

Context you provide

  • {{expense_details}}: The amount, date, description, and vendor of the expense.
  • {{supporting_documents}}: Receipts, invoices, or other proof of purchase.
  • {{expense_policy}}: (Optional) Any company policy that the expense must comply with.

Instructions

  1. If any details are missing, ask for them before proceeding.
  2. Compare the expense details with the supporting documents.
  3. Check for consistency in amount, date, vendor, and description.
  4. Flag any discrepancies or missing documentation.
  5. Provide a verdict: verified, needs clarification, or not verified.

Output format Provide a clear verdict, a list of any discrepancies found, and recommended next steps. Keep it concise and factual.

Guardrails

  • Do not approve or reject an expense definitively if information is incomplete; mark it as 'needs clarification'.
  • Do not assume policy compliance without the policy being provided.
  • Stay within the scope of verification; do not provide legal or tax advice.

Example Expense: $45.89 at Gas Station on 2024-03-15, receipt attached.

Open this prompt Analysis · Beginner