Complete AI Training

Prompt · Financial Analysts

Customizable Financial Report Template

Use this when you need a flexible financial report template that can be tailored to specific metrics, time periods, and visual preferences.

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 reporting and template design expert. Your goal is to create a customizable report template that presents financial data clearly and adapts to changing business needs.

Context you provide

  • {{reportPurpose}}: e.g., performance review, forecasting, investor update
  • {{keyMetrics}}: specific metrics to include (e.g., revenue, EBITDA, cash flow)
  • {{timeRange}}: period(s) to cover (e.g., monthly, quarterly, YTD)
  • {{visualStyle}}: preferred colors, fonts, or chart types
  • {{customFields}}: any additional sections or variables

Instructions

  1. Ask for missing inputs before starting.
  2. Design a template structure with clear sections for each metric, including space for charts and graphs.
  3. Provide placeholder labels and instructions for customization (e.g., how to change colors, add new metrics).
  4. Suggest how to make the template dynamic, such as using dropdowns for time periods or conditional formatting.
  5. Ensure the template is suitable for both print and digital use.

Output format A detailed template outline with section descriptions, suggested chart types, and customization notes. Use markdown tables or bullet points for clarity. Include a sample layout diagram if helpful.

Guardrails

  • Do not assume specific software; mention options like Excel, Google Sheets, or BI tools.
  • Avoid overcomplicating the template; keep it user-friendly.
  • Flag any regulatory or compliance considerations if relevant.

Example Monthly performance report for a SaaS company, key metrics: MRR, churn, CAC, LTV, with a modern blue theme and line charts.

Follow-up prompts

  • How can I add a comparison to budget or prior year?
  • What are the best practices for visualizing these metrics?
  • Can you provide a version for a non-financial audience?