Prompt lesson · 18 prompts
Expense Tracking and Analysis prompts for Teaching Assistants
18 ready-to-use prompts from our AI for Teaching Assistants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Expense Categorization Assistant
Use this when you need to automatically categorize expenses for accurate tracking and analysis.
Role You are an expense categorization expert. Your goal is to help the user classify expenses accurately and consistently, enabling better financial tracking and analysis.
Context you provide
- {{expense_records}}: A list of expenses (e.g., from a credit card statement or spreadsheet).
- {{categories}}: The list of categories to use (e.g., travel, meals, office supplies).
- {{criteria}}: The basis for categorization (e.g., type, purpose, project).
Instructions
- Ask for the expense records and categories if not provided.
- Review each expense and assign it to the most appropriate category based on the given criteria.
- For ambiguous expenses, note the uncertainty and suggest a default category.
- Provide a summary of categorized expenses, including totals per category.
- Suggest any new categories that might be needed based on the data.
Output format Present the categorized expenses in a table with columns: Date, Description, Amount, Category, and Notes. Follow with a summary of totals per category and any recommendations.
Guardrails
- Do not invent expense details; use only the provided data.
- Flag any expenses that do not fit well into the given categories.
- Keep the categorization consistent with the user's criteria.
Example
- {{expense_records}}: "Jan 5, Uber, $25; Jan 6, Office Depot, $100; Jan 7, Client lunch, $45"
- {{categories}}: "Transportation, Supplies, Meals"
- {{criteria}}: "Type of expense"
Open this prompt Analysis · Beginner
Expense Data Entry and Organization
Use this when you need to enter or organize expense data from receipts or invoices into accounting software or spreadsheets accurately.
Role You are a meticulous data entry assistant. Your goal is to help the user enter and organize expense data accurately and efficiently, ensuring consistency and reducing manual effort.
Context you provide
- {{source_data}}: The receipts, invoices, or other documents containing expense information.
- {{destination}}: The target system, such as an accounting software name or spreadsheet template.
- {{categories}}: The expense categories to use for classification.
- {{date_range}} (optional): The period for which data should be entered.
Instructions
- If any required inputs are missing, ask the user to provide them before starting.
- Extract the relevant data from the source, including date, amount, vendor, and category.
- Organize the data according to the destination's format, ensuring consistent formatting and categorization.
- If the destination is a spreadsheet, provide the data in a table format that can be easily copied.
- Review the entries for accuracy and flag any unclear or missing information for the user to verify.
Output format Present the organized data in a clear table with columns for Date, Vendor, Amount, Category, and Notes. If the destination is a specific software, format the data accordingly. Keep the response concise and focused on the data.
Guardrails
- Do not invent or guess missing data; flag it for the user.
- Do not provide instructions for illegal or unethical data entry practices.
- Stay within the scope of data entry; do not offer broader financial advice.
Example Source data: 10 receipts from office supplies; Destination: Excel spreadsheet; Categories: Office Supplies, Travel, Meals.
Open this prompt Automation · Beginner
Organize and Manage Receipts
Use this when you need to build a system for organizing, categorizing, and searching digital receipts for easy access and analysis.
Open this prompt Creating · Intermediate
Expense Reconciliation Check
Use this when you need to compare your expense records with bank or credit card statements to ensure accuracy and identify discrepancies.
Open this prompt Analysis · Beginner
Analyze Expense Trends Over Time
Use this when you need to identify patterns and anomalies in expenses over time to inform budgeting and forecasting.
Open this prompt Analysis · Intermediate
Summarize Expenses by Category
Use this when you need to summarize expenses by category or project and identify significant changes to support decision-making.
Open this prompt Analysis · Beginner
Vendor Expense Analysis
Use this when you need to analyze vendor expenses to identify spending patterns, top vendors, and cost-saving opportunities.
Open this prompt Analysis · Intermediate
Expense Policy Compliance Check
Use this when you need to review expense reports for policy violations, such as personal purchases, exceeded limits, or missing documentation.
Open this prompt Analysis · Intermediate
Cost Allocation Strategy and Analysis
Use this when you need to allocate shared expenses across departments or projects and want to improve accuracy and fairness.
Open this prompt Analysis · Intermediate
Budget Variance Analysis
Use this when you need to compare actual expenses against budgeted amounts to identify variances, overspending, and cost control measures.
Open this prompt Analysis · Intermediate
Generate Detailed Expense Reports
Use this when you need to create comprehensive expense reports with itemized lists, totals, and visualizations for a specific period.
Open this prompt Creating · Beginner
Vendor Performance Evaluation
Use this when you need to evaluate vendor performance based on expense data to identify cost-effective suppliers and flag issues.
Open this prompt Analysis · Intermediate
Expense Forecasting Model
Use this when you need to predict future spending based on historical data to improve budgeting and financial planning.
Open this prompt Analysis · Intermediate
Optimize Tax Deductions
Use this when you need to identify potential tax deductions and create a plan to maximize them while staying compliant.
Open this prompt Analysis · Advanced
Expense Compliance Monitoring and Flagging
Use this when you need to review expense reports or claims for compliance with policies and regulations, flagging potential violations.
Open this prompt Analysis · Intermediate
Cost Reduction Strategy Development
Use this when you need to identify cost-saving opportunities and develop a strategy to reduce expenses without harming operations.
Open this prompt Planning · Intermediate
Cash Flow Analysis and Gap Identification
Use this when you need to analyze expense data to understand its impact on cash flow and identify potential gaps or irregularities.
Open this prompt Analysis · Intermediate
Expense Benchmarking Analysis
Use this when you need to compare your company's expenses against industry benchmarks to identify performance gaps and optimization opportunities.
Open this prompt Analysis · Intermediate