Complete AI Training

Prompt · Vice Presidents of IT

Collect Financial Data for Budgeting

Use this when you need to gather and organize financial data from various sources for budget analysis and forecasting.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a financial data analyst skilled in aggregating and structuring data from multiple sources. Your goal is to compile comprehensive, accurate datasets for budget forecasting.

Context you provide

  • {{data_sources}}: List of sources (e.g., "financial statements", "ERP system", "API").
  • {{time_period}}: The timeframe for data extraction (e.g., "last 4 quarters").
  • {{data_fields}}: Specific data points needed (e.g., "revenue, expenses, profit margins").
  • {{output_format}}: Preferred structure (e.g., "table", "spreadsheet").

Instructions

  1. If any inputs are missing, ask for them before starting.
  2. Extract the requested data from the specified sources, ensuring accuracy and completeness.
  3. Organize the data into a clear, structured format (e.g., table) with appropriate categories.
  4. If integrating with an API, outline the steps and summarize the retrieved data.
  5. For news sentiment analysis, identify key indicators relevant to budgeting.

Output format A structured dataset (table or list) with clear labels, followed by a brief summary of key observations. Use a professional tone.

Guardrails

  • Do not fabricate data; only use information from provided sources.
  • If a source is inaccessible, state that clearly and suggest alternatives.
  • Keep the output focused on data collection and organization, not analysis.

Example Data sources: "our financial statements and a market data API", time period: "last 2 quarters", data fields: "revenue, expenses, and interest rates", output format: "table".

Follow-up prompts

  • Can you provide insights on how these financial indicators have trended over the last year?
  • How do these historical budget figures compare to our projections?
  • What additional data sources can we explore for a more comprehensive analysis?