GitHub Copilot Prompt to Analyze a Financial Balance Sheet

GitHub Copilot, the AI-powered coding assistant, is not limited to code generation. With its data analysis and processing capabilities, it becomes a formidable ally for finance professionals who want to automate financial balance sheet analysis. By using Copilot in a development environment like VS Code, you can ask it to generate analysis scripts, interpret financial ratios, detect accounting anomalies, and produce summary reports from raw data. Whether you are a CFO, management controller, or financial analyst, a well-structured prompt allows Copilot to turn spreadsheets of numbers into actionable insights. The challenge is to formulate your request with enough context — balance sheet structure, accounting standards, key indicators — so that the AI produces a rigorous and usable analysis. This guide offers an optimized prompt as well as variants adapted to your level of expertise to get the most out of GitHub Copilot in your financial analyses.

The prompt

GitHub Copilot

Analyze the following financial balance sheet in accordance with French accounting standards (French GAAP). For each item, calculate the N/N-1 variations in absolute value and percentage. Then produce: 1) An analysis of the financial structure (working capital, working capital requirement, net cash) with interpretation. 2) Liquidity ratios (current, quick, cash), solvency ratios (financial autonomy, repayment capacity), and profitability ratios (ROE, ROA). 3) A synthetic diagnosis of identified strengths and weaknesses with prioritized recommendations. 4) A summary table formatted in Markdown. Here is the balance sheet data: [PASTE DATA HERE]. Present the analysis in a structured manner with clear headings, professional comments, and alerts on critical thresholds exceeded.

Personalize this prompt with Léa

Answer 3 questions and Léa tailors the prompt to your situation.

Why it works

This prompt works because it imposes a complete financial analysis methodology in four distinct steps, which forces Copilot to structure its response exhaustively rather than superficially. The explicit reference to French GAAP and specific ratios removes ambiguity and guides the AI toward recognized financial calculations. Finally, the request for a diagnosis with prioritized recommendations pushes the model beyond simple data restitution toward true analytical interpretation.

Expected result

You will obtain a complete and structured financial analysis including item-by-item variations, key ratios calculated with their values and interpretation (favorable, neutral or unfavorable), as well as an overall diagnosis of the company's financial health. The result will include a Markdown summary table ready to integrate into a report, with visual alerts on indicators that exceed commonly accepted critical thresholds.

Variants by level

FAQ

Can GitHub Copilot analyze a financial balance sheet directly from an Excel file?

GitHub Copilot cannot directly read Excel files. You must first convert your data into structured text (CSV, Markdown table, or JSON) and paste it into your editor. Copilot can then generate a Python script using pandas or openpyxl to automate importing and analyzing your Excel files on a recurring basis.

Are the financial calculations produced by GitHub Copilot reliable?

Copilot correctly applies standard financial formulas when the prompt specifies them clearly. However, it is essential to verify the results, especially ratio calculations and variations. For critical decisions, use Copilot as an acceleration and structuring tool, but always validate key figures with a spreadsheet or accounting software.

How to adapt the prompt for an IFRS balance sheet instead of French GAAP?

Replace the mention 'French GAAP' with 'IFRS' in the prompt and specify the desired specifics: treatment of goodwill, fair value of assets, presentation of equity according to IAS 1. Also add relevant IFRS indicators like adjusted EBITDA or net debt/EBITDA ratio commonly used by international analysts.

How to use this prompt

Copy the prompt with the button above.
Paste it into ChatGPT, Claude or your favorite AI assistant.
Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 2500+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt library Learn prompting Prompt builder Prompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Midjourney Prompt for Analyzing a Contract

Midjourney, as an AI image generation tool, cannot analyze the textual content of a contract in the legal sense. However, it excels at creating impactful visuals to illustrate complex contractual concepts: negotiation process infographics, visual representations of key clauses, decision flow diagrams, or professional illustrations for legal presentations. These visuals transform dry documents into engaging communication materials, making them easier to understand for non-legal audiences. Whether you are a lawyer preparing a client presentation, a legal officer training your teams, or an entrepreneur looking to simplify your terms and conditions, Midjourney allows you to create professional-quality visual representations. The following prompts are designed to generate clear, structured illustrations that are appropriate for the legal and contractual context, respecting the visual codes of the sector: sobriety, clarity, and professionalism. Discover how to turn contract analysis into a visual experience with optimized prompts for Midjourney.

Midjourney Prompt for Creating E2E Tests

Midjourney, renowned for its power in AI image generation, can play an unexpected but strategic role in the creation of E2E tests.

Midjourney Prompt for Organizing a Project

Midjourney is primarily known for generating artistic images, but it proves to be a powerful tool for creating impactful project management visuals.

Midjourney Prompt for Planning a Product Launch

Midjourney has become an essential tool for marketing teams and entrepreneurs who want to bring their product launch vision to life before

Midjourney Prompt for Writing a Newsletter

Midjourney has become an essential tool for creating impactful visuals that accompany your newsletters. In a context where inboxes are saturated, the header image or illustrations embedded in your newsletter make all the difference between an email that's opened and one that's ignored. With Midjourney, you can generate custom visuals that reinforce your editorial message, illustrate your sections, and create a consistent visual identity from one edition to the next. Whether you produce a weekly tech newsletter, a monthly digest for your community, or a corporate newsletter, Midjourney lets you produce professional-quality images without hiring a graphic designer. The prompts presented on this page are specifically designed to generate visuals suitable for newsletter format: horizontal banners, section illustrations, thematic icons, and mood images. Each prompt includes essential technical parameters such as the aspect ratio suited for emails and a visual style consistent with email marketing standards. Discover how to transform your newsletters into memorable visual experiences.

Midjourney Prompt to Optimize SEO

Midjourney has become an essential tool for SEO professionals who want to enrich their visual content without blowing their budget. Search engines increasingly value pages that feature original and relevant images, at the expense of overused generic stock photos. By generating unique visuals with Midjourney, you improve time on page, reduce bounce rate, and increase your chances of appearing in Google Images — a source of organic traffic often overlooked. SEO optimization through images involves creating contextual visuals that reinforce content understanding for users and crawlers. A well-crafted Midjourney prompt allows you to produce blog illustrations, stylized infographics, featured images, and explanatory diagrams that capture attention in SERPs. By combining precise descriptions, web-friendly format parameters, and visual consistency with your brand guidelines, you turn each image into a natural search engine optimization lever. This guide provides optimized prompts to create visuals that directly serve your SEO strategy.