ChatGPT Prompt for Analyzing a Financial Balance Sheet
Analyzing a financial balance sheet is a key skill for executives, accountants, investors, and financial analysts. Traditionally reserved for certified public accountants, this task can now be accelerated with ChatGPT. By providing the key data of your balance sheet — assets, liabilities, equity, cash — you can get a structured analysis including fundamental financial ratios, identification of warning points, and strategic recommendations. ChatGPT excels at synthesizing numerical data and putting indicators into perspective. Whether you are preparing for a board meeting, a fundraising round, or just a quarterly management review, a well-crafted prompt will allow you to extract actionable insights in seconds. This guide offers an optimized prompt along with three variants tailored to your level of financial expertise, turning your raw accounting data into clear decision-making analysis.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a senior financial analyst with 15 years of experience in audit and financial consulting. I will provide you with my balance sheet data. Analyze it following this structure:
- Executive Summary: Summarize the overall financial health in 3-4 sentences.
- Financial Structure Analysis: Evaluate the asset/liability breakdown, working capital, working capital requirement (WCR), and net cash.
- Key Ratios: Calculate and interpret the following ratios: current ratio, debt-to-equity ratio, return on equity (ROE), solvency ratio, inventory turnover if applicable.
- Warning Points: Identify weak signals or potential risks.
- Sector Comparison: Compare these results to industry standards if possible.
- Recommendations: Propose 3-5 concrete actions to improve the financial situation.
Present each ratio with its formula, calculated value, and interpretation. Use tables for numerical data. Clearly state any assumptions you make if data is missing.
Here is my balance sheet data:
[PASTE YOUR DATA HERE]
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt works by assigning a precise expert role that activates the model's specialized financial knowledge, and by providing a detailed output structure that forces a thorough and methodical analysis. The explicit request for formulas, calculations, and interpretations avoids superficial responses and ensures a deliverable directly usable for decision-making.
Use Cases
Variants
Expected Output
You will obtain a structured financial report including an executive summary, tables of calculated ratios with their formulas and interpretations, a prioritized list of warning points, and concrete strategic recommendations. The format is directly usable for a management committee or investment file.
Frequently Asked Questions
What format should I provide my balance sheet in to ChatGPT?
The most efficient format is a structured table with clearly identified line items (fixed assets, current assets, equity, long-term liabilities, short-term liabilities) and their amounts. You can copy and paste directly from Excel or Google Sheets. If you have a PDF, extract the key figures first. For a comparative analysis, provide data across 2 to 3 fiscal years with the years clearly indicated. The more structured your data, the more accurate and relevant the analysis will be.
Can ChatGPT replace a chartered accountant for balance sheet analysis?
No, ChatGPT does not replace a chartered accountant. It is an excellent complementary tool for getting a quick initial read, identifying trends, and preparing relevant questions before a meeting with your accountant. However, ChatGPT can make calculation errors, does not know your company's specific context, and cannot certify accounts. Use it as a preliminary analysis assistant, and always validate key conclusions with a certified professional.
How can I get a multi-year comparative analysis with ChatGPT?
Provide the data for each fiscal year, clearly labeled by year (e.g., 'FY 2024', 'FY 2025'). Add this instruction to your prompt: 'Compare the evolution of each line item and ratio across the provided fiscal years, calculate percentage changes, and identify significant trends.' ChatGPT will then produce a comparative table with the changes and highlight abnormal variations or worrying trends that require special attention.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Generate a Compelling Investment Pitch
Create a structured, compelling investment pitch adapted to your audience for effective fundraising.
Optimize Tax Structuring
Optimize your company tax structure with an analysis of reorganization options and quantified simulations.
Summarize Insurance Product Reviews
Analyze customer reviews on your insurance products to identify strengths, pain points and concrete improvement levers.
Generate Blog Content Ideas for Insurance
Generate a complete, SEO-optimized blog content plan for your insurance or financial services website.