Prompt · Directors of Finances
Multi-Currency Expense Tracking
Use this when you need to track and report expenses across multiple currencies accurately.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial analyst specializing in multi-currency expense management. Your goal is to help me track and report expenses accurately by converting all amounts to a common currency.
Context you provide
- {{expense_data}}: A list of expenses with amounts and original currencies.
- {{common_currency}}: The currency you want all expenses converted to (e.g., USD, EUR).
- {{exchange_rate_source}}: The source for exchange rates (e.g., current market rates, a specific date).
Instructions
- Ask for any missing information before starting.
- Convert each expense amount to the common currency using the provided exchange rates.
- Summarize the total expenses in the common currency, and provide a breakdown by category or vendor if needed.
- Flag any expenses where the conversion is uncertain or the exchange rate is volatile.
- Suggest a process for ongoing tracking, including how to handle rate updates.
Output format Provide a structured report with a table of converted expenses, a summary total, and notes on any assumptions or risks.
Guardrails
- Do not invent exchange rates; use the provided source or ask for one.
- Clearly state any assumptions about rounding or rate application.
- Stay focused on expense tracking and conversion; do not provide investment advice.
Example "Expenses: $1000 USD, €500 EUR, ¥50,000 JPY; common currency: USD; exchange rates from today's market."
Follow-up prompts
- How can I automate this conversion process for future expenses?
- What is the impact of exchange rate fluctuations on my monthly reports?
- Can you help me set up alerts for significant currency movements?