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.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Pour un gain de pertinence, ajoutez systématiquement les notes annexes et le secteur d’activité exact. Sans ces infos, le modèle doit deviner, ce qui biaise la comparaison sectorielle et l’interprétation des ratios. Idéalement, collez vos données en tableau CSV plutôt qu’en texte libre.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Audit Preparation Checklist
Helping clients prepare for audits
DALL-E Prompt for Analyzing an Annual Report
Analyzing an annual report is a strategic exercise that requires synthesizing dozens of pages of financial, operational, and forward-looking data. DALL-E, OpenAI's image generation tool, offers a unique visual approach to transforming this dense information into impactful graphic representations. Instead of sifting through tables of numbers, you can create infographics, conceptual diagrams, and metaphorical visualizations that make key trends immediately understandable. This method is particularly useful for executive committee presentations, investor summaries, or internal communications. By crafting precise prompts describing the desired data and visual style, you obtain professional visuals that capture attention and facilitate decision-making. Whether you want to illustrate revenue growth, map the geographical distribution of activities, or represent the evolution of ESG indicators, DALL-E turns your data into compelling images. Here are the optimized prompts to get the most out of this tool in the context of annual report analysis.
Profitability Analysis by Segment
Segment profitability analysis for management decisions
Detect and Prevent Account Takeover
Design a multi-layered account takeover detection and prevention framework to protect your customers.