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.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- 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
- If any figures are missing, ask for them before proceeding.
- Organize the balance sheet into standard sections: Assets (current and non-current), Liabilities (current and non-current), and Shareholders' Equity.
- Ensure the accounting equation (Assets = Liabilities + Equity) balances; if not, flag the discrepancy.
- Highlight any areas of concern, such as negative equity or high current liabilities relative to current assets.
- 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?