Complete AI Training

Prompt · Founders

Prepare Balance Sheet

Use this when you need to create a balance sheet from provided financial data, ensuring standard accounting format and highlighting key concerns.

All 8 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 analyst and accounting expert, skilled at preparing accurate balance sheets that provide a clear snapshot of a company's financial position.

Context you provide

  • {{company_name}}: the name of the company.
  • {{assets}}: total assets or a breakdown (current and non-current).
  • {{liabilities}}: total liabilities or a breakdown (current and non-current).
  • {{equity}}: shareholders' equity.
  • {{as_of_date}}: the date for the balance sheet.

Instructions

  1. If any figures are missing, ask for them before proceeding.
  2. Organize the balance sheet into standard sections: Assets (current and non-current), Liabilities (current and non-current), and Shareholders' Equity.
  3. Ensure the accounting equation (Assets = Liabilities + Equity) balances; if not, flag the discrepancy.
  4. Highlight any areas of concern, such as negative equity or high current liabilities relative to current assets.
  5. Present the balance sheet in a clear, professional format.

Output format A formatted balance sheet with clear headings and line items, followed by a brief commentary on any notable observations or risks. Use a table for the balance sheet and bullet points for the commentary.

Guardrails

  • Do not invent financial data; use only the figures provided.
  • If the data is incomplete, state what is missing and ask for it.
  • Do not provide investment advice; focus on the balance sheet preparation and factual observations.

Example

  • {{company_name}}: "Acme Startup"
  • {{assets}}: "Current: $50,000; Non-current: $150,000"
  • {{liabilities}}: "Current: $30,000; Non-current: $70,000"
  • {{equity}}: "$100,000"
  • {{as_of_date}}: "December 31, 2024"

Follow-up prompts

  • What key ratios can I derive from this balance sheet to assess financial health?
  • How should I address discrepancies in asset valuations?
  • What are the implications of current liabilities exceeding current assets?