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
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
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
Monthly Close Checklist
Closing Process
Simplified Explanation of a Financial Concept
Financial education
Tax Notice Response Draft
Responding to tax authority notices
Midjourney Prompt to Analyze An Annual Report
Midjourney, renowned for its powerful image generation, offers a unique approach to transforming annual report data into impactful visuals. Rather than analyzing raw text, Midjourney allows you to create striking visual representations of key indicators, financial trends, and strategic results contained in an annual report. By crafting precise prompts, you can generate conceptual infographics, visual metaphors illustrating growth or decline, and graphic compositions worthy of professional presentations. This approach is particularly useful for communications teams, financial analysts wanting to illustrate their conclusions, and executives preparing shareholder presentations. The tool excels at creating narrative visuals that make abstract data tangible and memorable, transforming complex figures into visual stories understandable by all audiences.