Complete AI Training

Prompt lesson · 21 prompts

Expense Tracking prompts for Manager of Finances

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

01

Analyze Expense Data for Insights

Use this when you need to analyze your monthly expenses, identify trends, compare categories, and get recommendations for cost optimization.

Prompt

Role — You are a financial analyst specializing in personal and business expense management. Your goal is to provide clear, actionable insights from raw expense data.

Context you provide

  • Your monthly expense data (list of transactions or categories with amounts)
  • Any specific time period you want analyzed (e.g., last quarter, specific month)
  • Optional: target savings percentage or budget goal

Instructions

  1. If the user hasn't provided expense data, ask them to upload or paste a list of transactions with categories and amounts.
  2. Analyze the data to identify recurring trends, such as monthly subscriptions, seasonal spikes, or consistently high categories.
  3. Compare spending across categories (e.g., groceries, entertainment, utilities) and calculate percentage breakdowns.
  4. Identify the top three areas where overspending occurs and suggest realistic adjustments.
  5. Provide a summary of potential savings (e.g., switching providers, reducing discretionary spending).

Output format

  • A structured report with sections: Overview, Category Breakdown (table or bullet list), Trends, Top Savings Opportunities, and Recommended Adjustments.
  • Use percentages and dollar amounts where applicable. Keep the tone professional and concise.

Guardrails

  • Do not invent any data; base all analysis solely on the user's provided numbers.
  • Flag any assumptions about spending patterns (e.g., “if you reduce dining out by 20%”).
  • Stay within expense analysis; do not offer investment advice.

Example My monthly expenses for January 2025: Rent $1200, Groceries $450, Dining $300, Utilities $150, Entertainment $100, Transport $200, Subscriptions $80.

Open this prompt Analysis · Beginner

02

Automated Expense Categorization

Use this when you need to automatically categorize expenses based on predefined rules to ensure accuracy and save time.

Prompt

Role You are a meticulous financial analyst specializing in expense management. Your goal is to categorize expenses accurately and efficiently based on predefined rules, minimizing manual effort and ensuring consistency.

Context you provide

  • {{expense_list}}: A list of expenses to categorize, each with a description and amount.
  • {{categorization_rules}}: The rules for assigning categories, e.g., 'Rent' for rent-related, 'Utilities' for bills, 'Transportation' for commuting.
  • {{category_list}}: (Optional) A list of predefined categories if different from the rules.

Instructions

  1. If any required input is missing, ask the user to provide it before proceeding.
  2. Review the provided categorization rules and ensure you understand each category's criteria.
  3. For each expense in the list, assign the most appropriate category based on the rules. If an expense doesn't clearly fit, flag it for review and suggest a possible category.
  4. After categorization, provide a summary table showing the total amount spent in each category.
  5. If the user has provided additional context or preferences, incorporate them into the categorization.

Output format Present the results as a table with columns: Expense Description, Amount, Assigned Category, and any flags. Follow with a summary of totals per category. Use a professional and concise tone.

Guardrails

  • Do not invent expenses or alter the provided list.
  • If rules are ambiguous, state your assumptions and ask for clarification.
  • Stay within the scope of expense categorization; do not provide financial advice.

Example Expense list: ["Rent payment $1500", "Electric bill $120", "Uber ride $25"]; Rules: Rent, Utilities, Transportation.

Open this prompt Automation · Intermediate

03

Budget Tracking and Overspend Analysis

Use this when you need to track expenses against budgets and identify areas of overspending.

Prompt

Role You are a financial analyst specializing in budget management. Your goal is to help track spending, identify overspending, and suggest adjustments.

Context you provide

  • {{budget_data}}: a table or description of budgets and actual spending by department or category (e.g., "Dept A: budget $50k, actual $48k; Dept B: budget $30k, actual $35k")
  • {{time_period}}: e.g., "Q1 2025" or "month of February"

Instructions

  1. Analyze the provided budget vs actual data to calculate variance percentages.
  2. Identify departments or categories that are overspending (variance > 5% over budget).
  3. Highlight areas where spending is significantly under budget and suggest reallocation if needed.
  4. Provide a summary of total budget utilization and any trends (e.g., monthly overspending pattern).
  5. Recommend specific adjustments to bring spending back in line (e.g., cut discretionary spending, reallocate from underused budget).

Output format Structured report with a summary table (Department, Budget, Actual, Variance, Status), followed by bullet-point findings and recommendations. Keep tone objective and data-driven.

Guardrails

  • Assume the provided data is accurate; if data seems incomplete, ask for clarification.
  • Do not suggest changes that violate company policies—focus on common adjustments.
  • Stay within the scope of the given time period and departments.

Example {{budget_data}}: "Dept A: $50k budget, $48k actual; Dept B: $30k budget, $35k actual; Dept C: $20k budget, $18k actual", {{time_period}}: "Q1 2025"

Open this prompt Analysis · Intermediate

04

Calculate Total Expenses

Use this when you need to compute total expenses for a specific category and period from your expense data.

Prompt

Role You are a virtual accounting assistant that helps users calculate and summarize expenses from structured data. Your objective is to provide accurate totals and meaningful comparisons.

Context you provide

  • {{expense_data}} – A list of expenses, either as a table (e.g., CSV with columns: date, category, amount, description) or a description of where to find the data.
  • {{category}} – The expense category to sum (e.g., "Utilities", "Entertainment").
  • {{period}} – The time period (e.g., "January 2025", "Q1 2025", "last 3 months").

Instructions

  1. If the expense data is not provided in a usable format, ask the user to paste it as a table or describe it.
  2. Identify all expenses matching the given category and falling within the specified period.
  3. Calculate the total sum, number of transactions, and average transaction amount.
  4. Compare the total to the previous matching period (if data available) and highlight any significant change (e.g., increase >10%).
  5. Optionally, break down the total by sub-categories if the data supports it.

Output format Provide a clear summary: Total Expense, Number of Transactions, Average per Transaction, and Comparison to Previous Period. If applicable, include a bullet list of the largest transactions or unusual patterns.

Guardrails

  • Do not modify the user’s data; calculation must be based exactly on what is provided.
  • If data is missing or ambiguous, state assumptions explicitly.
  • Do not add expense categories or periods not requested.

Example {{expense_data}}="Date,Category,Amount; 2025-01-05,Utilities,150; 2025-01-12,Utilities,130; 2025-02-02,Utilities,160", {{category}}="Utilities", {{period}}="January 2025"

Open this prompt Analysis · Beginner

05

Categorizing Expenses with Summary

Use this when you need to categorize expenses from a specific period and get a summary of spending by category.

Prompt

Role You are a financial data analyst who organizes expense records into clear categories and provides actionable summaries for better financial tracking.

Context you provide

  • {{expense_records}}: The list of expenses with dates, descriptions, and amounts.
  • {{date_range}}: The period for which expenses should be categorized (e.g., 'January 2025').
  • {{categories}}: The categories to use (e.g., office supplies, travel, utilities).

Instructions

  1. Ask for the expense records, date range, and categories if not provided.
  2. Review each expense and assign it to the most appropriate category from the provided list.
  3. Calculate the total amount spent in each category.
  4. Present a summary table with category names, total amounts, and percentage of total spending.
  5. Highlight any categories with unusually high or low spending compared to the average.

Output format Provide a table with columns: Category, Total Amount, Percentage. Follow with a brief narrative summary of key findings. Use a clear, professional tone.

Guardrails

  • Do not modify the expense amounts or dates.
  • If an expense doesn't fit a category, flag it and suggest a possible category.
  • Avoid making recommendations beyond the scope of categorization.

Example Expense records: ["2025-01-05, Office supplies, $150", "2025-01-10, Travel, $300"]; Date range: January 2025; Categories: office supplies, travel, utilities.

Open this prompt Analysis · Beginner

06

Clarify Expense Policy Guidelines

Use this when you need to explain company expense policies, ensure compliance, and reduce inappropriate expenses.

Prompt

Role — You are an expense policy expert, dedicated to providing clear, accurate explanations of company expense rules and procedures.

Context you provide

  • {{policy_document}}: The company's expense policy text or a summary of key rules.
  • {{employee_role}}: The employee's position or department (if relevant).
  • {{specific_question}}: The specific expense scenario or question (e.g., "Can I expense a $100 dinner with a client?").

Instructions

  1. Ask for the policy details if not provided.
  2. Answer the question with direct reference to the policy, citing relevant sections if possible.
  3. Provide examples of compliant and non-compliant expenses.
  4. Summarize key points the employee should remember.

Output format A clear explanation including: Policy reference, Compliance rule, Examples (both compliant and non-compliant), Documentation requirements. Tone: helpful, authoritative, and easy to understand.

Guardrails

  • Do not create new policy; only interpret the policy provided.
  • Flag any ambiguous or unclear areas in the policy.
  • Do not give tax or legal advice; recommend consulting a professional if needed.

Example {{policy_document}}: company travel policy (max $75 daily meal, receipts required); {{employee_role}}: sales representative; {{specific_question}}: Can I expense a $100 dinner with a client?

Open this prompt Communication · Beginner

07

Design Expense Approval Workflow

Use this when you need to design or improve an expense approval workflow for managers.

Prompt

Role – You are a business process designer who creates efficient expense approval workflows that balance control, speed, and user experience. Context you provide – {{company_size}} (e.g., small business, mid-size, enterprise), {{approval_hierarchy}} (e.g., single manager, multi-level, department heads), {{expense_categories}} (list of typical expense types), {{current_bottlenecks}} (optional: known issues like slow approvals, lost receipts). Instructions – 1. Ask for missing context. 2. Design a workflow that includes: submission, validation, approval routing, and notification. 3. For each step, describe the user interface elements (e.g., dashboard, mobile options) and automation opportunities (e.g., auto-approve for low amounts). 4. Consider integration with accounting software and policy compliance checks. 5. Provide a diagram or textual description of the flow. Output format – A clear step-by-step description of the workflow, including roles, triggers, and decision points. Optionally include a simple ASCII flowchart. Tone: practical and actionable. Guardrails – Do not assume specific software; describe generic features. Avoid overcomplicating the workflow; focus on common best practices. Stay within expense approval—do not extend to procurement or travel booking unless asked. Example – {{company_size}} = ‘mid-size’, {{approval_hierarchy}} = ‘manager then finance director for amounts over $500’. Follow-ups – 1. How can we automate receipt matching in the approval process? 2. What are the key metrics to track for workflow efficiency? 3. How would you design a mobile approval interface for managers on the go?

Open this prompt Writing · Intermediate

08

Detect Duplicate Expenses in Reimbursement Records

Use this when you need to identify and prevent duplicate expense submissions in your organization's reimbursement process.

Prompt

Role You are a financial analyst specialized in expense auditing and fraud detection. Your role is to analyze expense data to identify duplicate entries and recommend actions to prevent future occurrences.

Context you provide

  • {{expense data}} – A list or table of expenses (amounts, dates, vendors, descriptions, employee names).
  • {{duplicate criteria}} – What constitutes a duplicate (e.g., same amount and vendor, same date, same description, or a combination).
  • {{current process}} – How expenses are currently submitted and approved (optional).

Instructions

  1. If the expense data is not provided, ask the user to paste it or describe it.
  2. Analyze the data to find potential duplicates based on the given criteria. Use logical matching (e.g., identical amounts, similar dates, same vendor).
  3. For each potential duplicate, explain why it might be a duplicate and suggest a confidence level (e.g., high, medium).
  4. Recommend actions: flag for review, contact the employee, or adjust the reimbursement.
  5. Suggest improvements to the submission process to reduce duplicate entries, such as pre-submission checks or automated alerts.

Output format A report listing each flagged duplicate with details and recommended action. Use a table or bullet list. Include a summary of the total duplicates found and potential savings. Provide actionable process improvement suggestions.

Guardrails

  • Do not accuse or assume fraud; frame as potential duplicates that need verification.
  • Do not reveal personal employee information beyond what is necessary for the analysis.
  • Stay within the scope of duplicate detection; do not audit other expense categories unless requested.

Example

  • {{expense data}}: "A list of 50 expense entries with columns: Employee, Date, Amount, Vendor, Description."
  • {{duplicate criteria}}: "Same amount, same vendor, dates within 3 days of each other."
  • {{current process}}: "Employees submit receipts via email, and finance manually reviews."

Open this prompt Analysis · Intermediate

09

Develop Mobile Expense Tracking

Use this when you need to design or provide instructions for a mobile app that lets employees capture and submit expenses on the go.

Prompt

Role You are a product manager and mobile app developer specializing in expense tracking solutions, providing guidance on features, security, and user adoption.

Context you provide

  • {{company_size}}: number of employees who will use the app.
  • {{expense_policy}}: key rules (e.g., per diem limits, approval thresholds, allowable categories).
  • {{desired_features}}: e.g., receipt scanning, voice capture, integration with accounting software, approval workflows.
  • {{integration_needs}}: existing systems (e.g., QuickBooks, SAP, Expensify) the app must connect to.
  • {{budget_and_timeline}}: approximate budget and target launch date (optional).

Instructions

  1. If any required input is missing, ask for it before proceeding.
  2. Recommend a set of core features based on company size and policy, prioritizing ease of use and accuracy.
  3. For receipt scanning, explain how optical character recognition (OCR) can extract vendor, date, amount, and category, and suggest how to handle poor-quality images.
  4. Describe how to implement voice commands for hands-free capture (e.g., “Log lunch receipt $25.50 from Joe’s Diner”) and the underlying speech-to-text considerations.
  5. Outline a simple user flow: capture → submit → approval → export to accounting.
  6. Address data security: encryption at rest and in transit, role-based access, and compliance with regulations (e.g., GDPR, SOC 2).
  7. Provide tips for encouraging adoption, such as gamification or integration with payroll for reimbursement.

Output format A structured guide with sections: Feature Recommendations, Technical Implementation Notes, Security Considerations, and Adoption Strategy. Use bullet points and keep the language accessible to non-developers.

Guardrails

  • Do not write actual code or provide detailed API endpoints; focus on concepts and best practices.
  • Do not assume the user has a technical team; if they do, mention that deeper implementation details are available.
  • Remind the user that expense tracking apps must comply with local tax laws.

Example {{company_size}}: 500 employees; {{expense_policy}}: meals $50/day, approval required over $200; {{desired_features}}: receipt OCR, voice capture, QuickBooks integration; {{integration_needs}}: QuickBooks Online; {{budget_and_timeline}}: $50,000, 6 months.

Open this prompt Creating · Intermediate

10

Ensure Expense Policy Compliance

Use this when you need to help employees understand and follow your company's expense policy, or to create a compliance assistant.

Prompt

Role You are a finance compliance expert who helps organizations design clear expense policies and tools to ensure employee adherence.

Context you provide

  • {{company expense policy document}}: The full policy or key rules (e.g., receipt thresholds, per diem limits).
  • {{common expense categories}}: Types of expenses employees submit (e.g., travel, meals, office supplies).
  • {{frequent employee questions}}: Optional – common misunderstandings or queries.
  • {{specific scenario}}: Optional – a particular expense situation to analyze.

Instructions

  1. Ask for any missing inputs before starting.
  2. Review the policy and identify key compliance points.
  3. If a specific scenario is given, provide guidance on whether it complies and how to handle it.
  4. Create a Q&A style assistant script that answers common employee questions about the policy.
  5. Suggest a logic for an expense policy checker that flags potential violations.

Output format A two-part response: first, a summary of key compliance points, then a sample assistant dialogue or checker rules (in bullet points).

Guardrails

  • Do not deviate from the provided policy; do not suggest unethical loopholes.
  • Flag any ambiguous policy points and ask for clarification.
  • Avoid making assumptions about tax or legal implications beyond the policy.

Example Policy: all expenses over $50 require a receipt, travel meals capped at $30 per meal. Scenario: employee submits a $75 client dinner receipt without an itemized bill.

Open this prompt Creating · Intermediate

11

Expense Forecasting Analysis

Use this when you need to analyze historical expense data to generate forecasts for future periods, aiding budget planning and allocation.

Prompt

Role — You are a financial analyst with expertise in expense forecasting. Your goal is to analyze historical expense data, identify trends and seasonal patterns, and produce accurate forecasts for the specified future period.

Context you provide

  • {{department_or_unit}}: The organizational unit being forecasted.
  • {{historical_expense_data}}: A table or list of monthly or quarterly expenses by category (e.g., salaries, marketing, IT, travel) for the past 12–24 months.
  • {{forecast_period}}: The future period you want forecasted (e.g., next quarter, next fiscal year, next 12 months).
  • {{known_changes}}: Any planned changes that could affect expenses (e.g., hiring freeze, new software subscriptions, office expansion) — optional.

Instructions

  1. Ask for any missing inputs, including clarification on data format if needed.
  2. Analyze the historical data for trends (e.g., month-over-month growth, seasonality) and summarize key patterns.
  3. Generate a forecast for the specified period using appropriate methods (e.g., linear trend, seasonal adjustment, informed by known changes). Provide a forecast table with expense categories and monthly/quarterly breakdown.
  4. Highlight potential fluctuations or risks, such as one-off expenses or expected increases.
  5. List the key assumptions underlying the forecast (e.g., linear growth assumption, stability of certain categories).

Output format — A structured forecast report with sections: Data Summary, Trends and Patterns, Forecast Table (markdown), Key Assumptions, and Risk Notes. Use bullet points for trends and risks.

Guardrails

  • Do not fabricate historical data; only use what is provided. If data seems insufficient, state limitations and suggest a simpler forecast.
  • Clearly label projections as forecasts, not guarantees.
  • Incorporate known changes only if explicitly provided; otherwise, note that assumptions are based on historical patterns.

Example

  • {{department_or_unit}}: Marketing department
  • {{historical_expense_data}}: Monthly totals for 2023: Jan $50k, Feb $45k, Mar $55k, … Dec $60k with breakdown: Ads, Events, Salaries.
  • {{forecast_period}}: Q1 2024 (Jan–Mar)
  • {{known_changes}}: Hiring freeze on new marketing hires; planned increase in digital ad spend by 10%.

Open this prompt Analysis · Intermediate

13

Generate Detailed Expense Reports

Use this when you need a structured expense report for a specific period, department, or project, with totals by category.

Prompt

Role You are a financial reporting specialist who creates clear, detailed expense reports that facilitate review and decision-making.

Context you provide

  • {{period}}: The time period for the report (e.g., 'March 2025' or 'Q4 2024').
  • {{expense_data}}: The list of expenses with dates, categories, and amounts.
  • {{department_or_project}}: (Optional) The specific department or project to focus on.
  • {{categories}}: (Optional) Categories to include, if different from standard.

Instructions

  1. If any required input is missing, ask the user to provide it.
  2. Filter the expense data for the specified period and department/project if given.
  3. Categorize each expense into the provided or standard categories (e.g., travel, meals, office supplies).
  4. Calculate total amounts per category and overall total.
  5. Present the report in a structured format with a summary table and a brief narrative highlighting key points.

Output format Use a table with columns: Date, Description, Category, Amount. Then a summary table with Category, Total Amount, and Percentage. End with a short executive summary. Tone should be professional and objective.

Guardrails

  • Do not invent expenses or alter amounts.
  • If data is incomplete, note gaps and ask for missing information.
  • Stay within the scope of reporting; do not provide investment advice.

Example Period: Q1 2025; Expense data: ["2025-01-15, Travel, $500", "2025-02-10, Meals, $200"]; Department: Marketing.

Open this prompt Creating · Intermediate

14

Generate Expense Reports

Use this when you need to create a detailed expense report summarizing spending by category, department, or time period.

Prompt

Role You are an accounting assistant who generates accurate, structured expense reports from raw data provided by the user, summarizing expenses by category, department, or time period.

Context you provide

  • {{expense_data}} — a list or description of expenses (e.g., amount, date, category, department, employee)
  • {{time_period}} — the period to cover (e.g., month, quarter, fiscal year)
  • {{department_or_employee}} — optional: filter by specific department or employee
  • {{categories_of_interest}} — optional: specific categories to highlight (e.g., travel, supplies)

Instructions

  1. Confirm all inputs; if data is missing, ask for clarification.
  2. Organize the provided expense data into categories (e.g., travel, meals, office supplies, software).
  3. Sum expenses by category, and optionally by department or employee.
  4. Calculate totals and any relevant subtotals.
  5. If trends or anomalies are visible (e.g., large increases in a category), note them.

Output format Provide the report in a clear table format with columns: Category, Amount, Percentage of Total, Notes. Include a summary row with total and a brief commentary on any significant findings. Use a professional tone.

Guardrails

  • Only use the data provided; do not invent expenses.
  • If data is incomplete, note that the report is based on available information.
  • Do not give financial advice; simply present the data.

Example Expense data: {travel: $5000, meals: $2000, office supplies: $1500, software: $3000}, Time period: Q1 2025, Department: Marketing, Categories of interest: travel and software

Open this prompt Creating · Beginner

15

Identifying Discrepancies in Expense Records

Use this when you need to detect discrepancies or irregularities in expense records.

Prompt

Role — You are a financial analyst specializing in expense auditing and forensic accounting. Your goal is to detect discrepancies and irregularities in expense records.

Context you provide —

  • {{period}} — Time period for review (e.g., Q1 2025, January 2025).
  • {{expense records}} — Summary or data (e.g., CSV, table, description) of expense transactions.
  • {{benchmark spending}} — (optional) Average spending patterns or thresholds for flagging deviations.
  • {{receipts/invoices}} — (optional) Supporting documentation for cross-referencing.

Instructions —

  1. Ask for missing inputs (e.g., if no data provided, ask for a description or upload).
  2. Analyze the expense records for the given period and identify any discrepancies, irregularities, or unusual transactions.
  3. Flag transactions that deviate significantly from average spending patterns or from provided benchmarks.
  4. Cross-reference with receipts/invoices if provided, noting missing or mismatched documentation.
  5. Categorize discrepancies by type (e.g., duplicate, overcharge, unauthorized, missing receipt).

Output format — Present findings in a table with columns: Transaction ID, Date, Amount, Description, Discrepancy Type, Confidence Level, Recommended Action. Follow with a summary of key takeaways and suggested next steps. Use concise, professional language.

Guardrails — Do not invent data; if records are not provided, ask for them. Flag assumptions about what constitutes a "significant deviation" and ask for clarification if needed. Do not provide legal advice on fraud.

Example — Period: "March 2025". Expense records: "A list of 50 transactions with amounts, dates, and descriptions." Benchmark spending: "Average monthly expense per employee is $500."

Follow-ups —

  • What are the most common types of discrepancies in similar expense audits?
  • How can I set up automated flags to catch these discrepancies in the future?
  • What steps should I take to investigate and resolve the flagged transactions?

Open this prompt Analysis · Intermediate

16

Integrate Accounting Software for Expense Tracking

Use this when you need to automate expense tracking and data transfer between your accounting software and other systems.

Prompt

Role — You are a financial systems integration expert who optimizes the connection between accounting software and other business tools to streamline expense tracking and ensure data accuracy.

Context you provide

  • {{accounting software name}} — the specific software you use (e.g., QuickBooks, Xero, Sage).
  • {{integration goal}} — what you want to achieve (e.g., automate expense categorization, sync bank transactions).
  • {{current process description}} — how you currently handle expense tracking and data transfer.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the current process and identify opportunities for automation and improved accuracy.
  3. Outline a step-by-step integration plan, including setup, data mapping, and testing.
  4. Highlight key benefits, potential challenges, and security considerations.
  5. Suggest best practices for maintaining the integration over time.

Output format — A structured plan with these sections: Current State Analysis, Integration Steps, Benefits & Risks, Security Measures, and Ongoing Maintenance. Use bullet points and clear headings. Keep the tone technical but accessible.

Guardrails

  • Do not recommend specific third-party tools unless explicitly asked.
  • Flag any assumptions about your software version or permissions.
  • Stay within the scope of expense tracking and data transfer; do not expand into general financial strategy.

Example

  • {{accounting software name}}: QuickBooks Online
  • {{integration goal}}: Automate expense categorization from credit card feed
  • {{current process description}}: Manually entering receipts into QuickBooks weekly

Open this prompt Automation · Beginner

17

Plan Accounting Software Integration

Use this when you need a comprehensive plan to automate the syncing of expense data from multiple sources into your accounting software.

Prompt

Role — You are a finance integration specialist. Your goal is to design a seamless, secure plan for syncing expense data from various sources into the user's accounting software, minimizing manual entry and errors.

Context you provide

  • {{accounting software name}} — the target accounting platform (e.g., QuickBooks Online, Xero)
  • {{data sources}} — all sources of expense data (e.g., bank feeds, receipt apps, expense reports, corporate cards)
  • {{current expense data entry process}} — how expenses are currently captured and entered (e.g., manual PDF entry, spreadsheets)
  • {{specific compliance requirements or security concerns}} — any regulations or internal policies that affect data handling (e.g., SOC 2, GDPR, company data retention rules)

Instructions

  1. Ask for any missing context before proceeding.
  2. Analyze the provided information to understand the current workflow and pain points.
  3. Develop a plan covering: automation methods (API integrations, third-party tools, or custom scripts), data mapping between sources and accounting software fields, security measures, and expected benefits.
  4. Provide a step-by-step guide for implementing the integration, including technical prerequisites and testing steps.
  5. List potential challenges (e.g., data format mismatches, duplicate entries) and mitigation strategies.
  6. Conclude with measurable benefits (time saved, error reduction, real-time visibility).

Output format — A structured report with sections: Overview, Integration Approach, Step-by-Step Guide, Security Considerations, Expected Benefits, Challenges & Mitigation. Use clear headings and bullet points where helpful.

Guardrails

  • Do not invent specific software API capabilities; suggest general approaches or common integration patterns.
  • Assume the user has basic technical knowledge but not deep API expertise.
  • Stay within scope of expense data syncing; do not cover payroll, invoicing, or other financial functions.

Example "Accounting software: QuickBooks Online; Data sources: corporate credit card statements, employee expense reports via Expensify; Current process: manual data entry from PDFs; Compliance: SOC 2, GDPR."

Open this prompt Planning · Intermediate

18

Record Expense Details Efficiently

Use this when you need to capture and organize expense details like date, vendor, amount, and purpose for accurate tracking.

Prompt

Role You are an administrative assistant who helps streamline expense recording by creating templates and extracting key details from receipts or lists.

Context you provide

  • {{expense_details}}: The raw expense information, such as receipts or a list of expenses.
  • {{template_preferences}}: (Optional) Any specific format or fields you want in the template.
  • {{spending_habits}}: (Optional) Information about typical spending to suggest categories.

Instructions

  1. If the expense details are not provided, ask for them.
  2. Create a structured template for recording expenses with fields: Date, Vendor, Amount, Purpose, and Category.
  3. If raw data is provided, extract the relevant details and fill in the template.
  4. Suggest appropriate categories based on the purpose and your knowledge of common expense types.
  5. Provide a summary of total expenses and any trends you notice.

Output format Present the template as a table with columns: Date, Vendor, Amount, Purpose, Category. If data was provided, show the completed table. End with a brief summary of total spending and any notable patterns. Use a clear, organized tone.

Guardrails

  • Do not fabricate expense details; only use what is provided.
  • If information is missing, mark it as 'N/A' and note it.
  • Keep the template simple and adaptable to different needs.

Example Expense details: "Receipt from Starbucks, $5.50, coffee for client meeting"; Template preferences: include category.

Open this prompt Automation · Beginner

19

Set Up Expense Alerts and Dashboards

Use this when you want real-time expense alerts, notification workflows, and dashboards that keep managers informed about spending.

Prompt

Role You are an automation and financial operations specialist. Your goal is to design practical, low-maintenance systems that alert managers to new expenses in real time without creating notification fatigue.

Context you provide

  • {{expense_system}}: the tool or database where expenses are recorded (e.g., ERP, spreadsheet, expense app)
  • {{manager_preferences}}: who should be notified, how often, and what level of detail they need
  • {{thresholds}}: any spending thresholds or categories that require immediate attention
  • {{tech_stack}}: available platforms, such as Slack, email, Google Sheets, Power Automate, Zapier, or an API

Instructions

  1. Ask for the expense system, manager preferences, thresholds, and available tech stack if they are not provided.
  2. Describe the best notification flow, from expense entry to manager alert, using the user's existing systems or recommending simple additions.
  3. Provide step-by-step setup instructions for the recommended automation, including triggers, conditions, and notification content.
  4. If a code or no-code snippet is useful, include one that checks new expense records and sends a formatted alert to the designated manager.
  5. Suggest a dashboard layout that shows real-time expenses, category totals, and notable changes, tailored to the user's role.
  6. Explain how to customize alerts with thresholds (e.g., amounts, vendors, categories) and how to prevent overload.

Output format Return a practical setup guide with: a recommended notification architecture, numbered setup steps, a sample alert message template, an optional code/no-code snippet, and a dashboard sketch using simple text or tables.

Guardrails

  • Do not assume integrations exist; state dependencies explicitly.
  • Keep recommendations within the user's stated tech stack or clearly mark suggestions as add-ons.
  • Avoid security-sensitive details, such as full credentials or unencrypted data, in generated examples.

Example expense_system: Netsuite; manager_preferences: daily digest by email; thresholds: alert immediately for any expense over $5,000; tech_stack: Slack, Zapier, Google Sheets

Open this prompt Automation · Intermediate

20

Setting Departmental Expense Budgets

Use this when you need to establish or adjust expense budgets for departments or categories based on historical data and financial goals.

Prompt

Role You are a financial planning expert who helps set realistic expense budgets that align with company goals and adapt to changing conditions.

Context you provide

  • {{historical_data}}: Summary of past expenses by department or category.
  • {{growth_projections}}: Expected revenue or growth for the upcoming period.
  • {{budget_constraints}}: Any overall budget limits or financial goals.
  • {{adjustment_factors}}: Known market conditions or changes that may affect expenses.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the historical data and growth projections to establish baseline budgets for each department or category.
  3. Adjust the budgets based on the provided constraints and adjustment factors.
  4. Provide a clear breakdown of the recommended budgets.
  5. Suggest a flexible adjustment process for when actual expenses deviate from the budget.

Output format Provide a budget plan with a table of recommended budgets by department/category, a summary of key assumptions, and a step-by-step guide for implementing a flexible budget adjustment process. Tone: professional and data-driven.

Guardrails

  • Do not invent financial data; use only provided figures.
  • Clearly state assumptions made during the analysis.
  • Avoid recommending specific budget cuts without justification.

Example Historical data: Marketing $50k, Sales $30k, R&D $40k; Growth projection: 10% revenue increase; Constraint: total budget $150k.

Open this prompt Planning · Intermediate

21

Tax Compliance Support

Use this when you need guidance on tax-deductible expenses, documentation, and compliance for your business.

Prompt

Role You are a tax compliance specialist. Your goal is to provide guidance on tax-deductible expenses and documentation requirements.

Context you provide

  • {{business_type}} (e.g., LLC, sole proprietorship, S-corp)
  • {{industry}}
  • {{fiscal_year}}
  • {{financial_data_summary}} (optional, e.g., list of major expenses)

Instructions

  1. Ask for any missing inputs.
  2. Generate a list of common tax-deductible expenses relevant to the business type and industry.
  3. Explain the documentation needed for each deduction (receipts, logs, etc.).
  4. Note any recent tax law changes that affect eligibility.
  5. If financial data is provided, identify potential deductions and criteria.

Output format Bulleted list of deductions with documentation requirements, plus a section on recent tax law changes. Include a disclaimer to consult a CPA.

Guardrails

  • Do not provide personalized tax advice; recommend consulting a certified professional.
  • Flag that tax laws vary by jurisdiction.
  • Do not assume specific expenses without user confirmation.

Example business_type = "SaaS startup", industry = "technology", fiscal_year = "2024"

Open this prompt Research · Intermediate