Skip to content
Back to Resources
ClaudeBookkeepingBeginnerPrompt Pack

5 Claude Prompts for Financial Reporting & Summaries

Ready-to-use Claude prompts for writing client financial summaries, P&L narratives, cash flow analyses, and monthly reporting packages that save hours every month.

5 Claude Prompts for Financial Reporting & Summaries


Why Use AI for Financial Reporting?

Financial reporting is the most time-consuming recurring deliverable in bookkeeping. Every client expects a monthly or quarterly summary that goes beyond raw numbers — they want to understand what happened, why it matters, and what to do about it. Writing these narrative summaries takes 60 to 90 minutes per client when done well, and most bookkeepers either rush them or skip them entirely because of time pressure.

Claude can produce a polished financial narrative in minutes when you give it the right data. These prompts are built around real bookkeeping workflows — monthly closes, P&L reviews, cash flow analyses, and client reporting packages. They use terminology and formatting that bookkeepers and CPAs recognize, and they produce output that is ready to share with clients after a brief review.

The key is specificity. "Summarize these financials" produces a generic overview. "Write a narrative financial summary for a small marketing agency owner who is not an accountant, explaining why revenue increased 22% year-over-year and flagging the AR aging concern" produces something your client actually reads and acts on.

The Prompts

Prompt 1: Monthly Financial Summary for Business Owners

For translating monthly financials into a plain-language narrative that business owners understand and value.

Write a monthly financial summary for a bookkeeping client. The summary should explain what the numbers mean — not just restate them. Write for a business owner who is not an accountant.

<context>
- Client type: [e.g., marketing agency / restaurant / e-commerce store / dental practice]
- Entity: [e.g., LLC / S-Corp / Sole Prop]
- Period: [e.g., January 2026]
- Revenue: [e.g., $142,000 — consulting $98K, project work $44K]
- Prior period revenue: [e.g., $131,500 in December, $116,000 in January last year]
- Expenses: [e.g., $118,000 — Payroll $78K, Rent $8K, Software $12K, Marketing $7K, Misc $13K]
- Net income: [e.g., $24,000 — 16.9% margin]
- Notable items: [e.g., new enterprise client started, one-time renovation expense $5K, two invoices over 60 days totaling $18K]
</context>

<instructions>
- Open with a one-sentence assessment of overall financial health for the period
- Explain revenue trends — what drove changes from last month and last year
- Summarize expenses, highlighting any categories that changed significantly
- Address each notable item and explain what it means for the business
- Close with 2-3 specific, actionable recommendations
- Use headers and short paragraphs for easy scanning
- Keep under 500 words
</instructions>

<avoid>
- Restating numbers without explanation
- Accounting jargon (say "money coming in" not "accounts receivable")
- Vague statements like "revenue was good" — explain why and what it means
</avoid>

Example Output:

January 2026 Financial Summary

>
Overall: Your business had a strong January, generating $24,000 in net profit on $142,000 in revenue — a 16.9% profit margin, your best month in over a year.

>
Revenue Highlights: Total revenue increased 8% from December and 22% compared to January 2025. The new enterprise client contract ($15,000/month recurring) was the primary driver, adding predictable revenue that should continue through the year. Consulting revenue remains stable at $98,000 while project work contributed $44,000.

>
Expense Notes: Total expenses of $118,000 were in line with expectations. Payroll at $78,000 represents 55% of revenue — within healthy range for a service business. The $5,000 office renovation was a one-time expense that will not recur. No expense categories showed concerning upward trends.

>
Items Needing Attention: Two client invoices totaling $18,000 are now over 60 days past due. At this age, collection risk increases significantly. I recommend reaching out to both clients this week to confirm payment timeline and consider adjusting payment terms for future work.

>
Recommendations:

1. Follow up on the two aging invoices immediately — $18,000 in outstanding receivables affects your cash position

2. With the new recurring revenue, consider increasing your quarterly estimated tax payment to avoid an underpayment penalty

3. Review whether the additional revenue justifies hiring a junior team member to support the enterprise client workload

Prompt 2: Profit & Loss Narrative Report

For writing a detailed P&L narrative that explains category-level trends for review meetings or advisory engagements.

Write a detailed profit and loss narrative report for a bookkeeping client. This report supplements the financial statements with analysis and context.

<context>
- Client type: [e.g., construction company / SaaS startup / professional services firm]
- Period: [e.g., Q4 2025 vs Q3 2025 and Q4 2024]
- Revenue by category: [e.g., Residential projects $280K, Commercial projects $420K, Maintenance contracts $85K]
- COGS / Direct costs: [e.g., Materials $310K, Subcontractors $180K, Equipment rental $45K]
- Gross profit: [e.g., $250K — 31.8% gross margin]
- Operating expenses: [e.g., Payroll $120K, Insurance $22K, Vehicle $18K, Office $15K, Marketing $8K]
- Net income: [e.g., $67K — 8.5% net margin]
- Comparison notes: [e.g., Revenue up 12% QoQ, gross margin down from 34.2%, marketing spend increased 60%]
</context>

<instructions>
- Structure with sections: Revenue Analysis, Cost of Goods Sold, Gross Profit, Operating Expenses, Bottom Line, and Outlook
- For each section, explain what happened and why it matters
- Calculate and comment on key ratios: gross margin, net margin, expense ratios
- Highlight any trends that warrant attention — positive or concerning
- Close with a forward-looking paragraph on what to watch next quarter
</instructions>

<format>
Professional narrative report with clear section headers. Include specific dollar amounts and percentages throughout. This may be shared with the client's banker or advisory board.
</format>

Example Output:

Revenue Analysis: Q4 revenue of $785,000 represents a 12% increase over Q3, driven primarily by a surge in commercial project completions. Commercial work accounted for 53% of revenue, up from 48% in Q3. Maintenance contracts provided a stable $85,000 baseline. The revenue mix shift toward commercial is notable — these projects carry different margin profiles than residential.

>
Cost of Goods Sold: Direct costs totaled $535,000, yielding a gross margin of 31.8% — down from 34.2% in Q3. The 2.4-point margin compression is attributable to rising material costs (lumber and steel) and increased reliance on subcontractors for the larger commercial projects. Material costs per revenue dollar increased from $0.37 to $0.39.

>
Outlook: Revenue momentum is strong heading into Q1, with a signed commercial backlog of $380,000. The priority should be protecting gross margin through tighter material procurement and evaluating whether to hire full-time labor to reduce subcontractor dependency.

Prompt 3: Cash Flow Analysis Summary

For explaining cash flow dynamics to clients who struggle to understand why profit does not equal cash in the bank.

Write a cash flow analysis summary for a bookkeeping client. Focus on explaining why the bank balance does not match the profit number — this is the single most common question business owners ask their bookkeeper.

<context>
- Client type: [e.g., consulting firm / retail store / contractor]
- Period: [e.g., January 2026]
- Net income for the period: [e.g., $24,000]
- Beginning cash balance: [e.g., $45,000]
- Ending cash balance: [e.g., $38,000]
- Key cash flow items: [e.g., Client collected $12K in old receivables, Owner took $15K distribution, Paid $8K quarterly estimated tax, Equipment loan payment $3,200 (principal $2,400), Accounts receivable increased $18K due to two large unbilled projects]
</context>

<instructions>
- Open by stating the apparent contradiction: business was profitable but cash went down (or vice versa)
- Walk through the bridge from net income to ending cash in plain language
- Explain each major item: what it is, why it affects cash, and whether it is a concern
- Distinguish between one-time cash events and recurring patterns
- End with a cash flow recommendation
- Use a simple bridge format the client can follow
</instructions>

<avoid>
- The phrase "cash flow statement" — call it a "cash summary" or "where your money went"
- Assuming the client understands accrual vs. cash basis
- Debits and credits terminology
</avoid>

Example Output:

Where Your Money Went — January 2026

>
Your business earned $24,000 in profit in January, but your bank account actually decreased by $7,000. Here is why that happened and whether you should be concerned.

>
Starting Point: $45,000 in the bank on January 1st.

>
Money In (beyond revenue already collected):

- Collected $12,000 from clients who owed you from prior months — good news, this reduces your outstanding receivables

>
Money Out (beyond normal expenses):

- Owner distribution: $15,000 — this is your personal draw, not a business expense

- Quarterly estimated tax payment: $8,000 — required prepayment to the IRS

- Equipment loan payment: $3,200 — only $800 of this was interest (an expense); the other $2,400 reduces your loan balance but does not show as an expense on your P&L

- Two large projects billed but not yet collected: $18,000 — you did the work and recognized the revenue, but the cash has not arrived yet

>
Ending Point: $38,000 in the bank on January 31st.

>
The takeaway: Your business is profitable. The cash decrease was driven by your personal distribution and tax payment — both are normal and expected. The $18,000 in uncollected receivables is the item to watch. If those clients pay in February as expected, your cash position will recover.

Prompt 4: Reconciliation Report with Client Cover Note

For generating a professional reconciliation report with a client-facing summary.

Draft a monthly bank reconciliation report with a client cover note. The report should be detailed enough for audit purposes and the cover note should be understandable by a non-accountant.

<context>
- Client: [e.g., Retail store, LLC]
- Period: [e.g., January 2026]
- Bank statement ending balance: [e.g., $28,743.56]
- Book (general ledger) balance: [e.g., $27,418.31]
- Outstanding checks: [e.g., #1089 $420 (vendor), #1092 $890 (rent), #1095 $1,650 (inventory)]
- Deposits in transit: [e.g., Cash register deposit $1,800 made 1/31]
- Adjustments needed: [e.g., Bank service charge $42 not recorded, POS processing fees $163.25 not recorded, Interest earned $8.50 not recorded, Customer check returned NSF $575]
</context>

<instructions>
- Show the complete reconciliation: bank balance to reconciled balance and book balance to reconciled balance
- Organize outstanding items with check numbers, amounts, and descriptions
- Write journal entries for each adjustment (account names, debit/credit)
- Draft a 3-4 sentence cover note for the client highlighting any items needing their attention
- If the reconciliation does not balance, note the discrepancy and suggest investigation steps
</instructions>

<format>
Professional reconciliation format with clear sections. The cover note should be suitable for email.
</format>

Example Output:

Client Note: Your January bank reconciliation is complete and balances. Three checks totaling $2,960 are still outstanding — these are normal timing differences and should clear in early February. One item needs your attention: a customer check for $575 was returned by the bank as insufficient funds. Please let me know if you would like to re-deposit it or if we should follow up with the customer for an alternative payment method.

Prompt 5: Multi-Period Trend Analysis

For providing clients with a broader view of financial trends across several months or quarters.

Write a multi-period financial trend analysis for a bookkeeping client. This analysis should identify patterns, flag concerns, and highlight opportunities over time.

<context>
- Client type: [e.g., dental practice / law firm / landscaping company]
- Periods compared: [e.g., Last 6 months — August 2025 through January 2026]
- Monthly revenue: [e.g., Aug $52K, Sep $48K, Oct $55K, Nov $61K, Dec $58K, Jan $67K]
- Monthly expenses: [e.g., Aug $44K, Sep $43K, Oct $46K, Nov $49K, Dec $47K, Jan $53K]
- Monthly net income: [e.g., Aug $8K, Sep $5K, Oct $9K, Nov $12K, Dec $11K, Jan $14K]
- Key changes over period: [e.g., added a new hygienist in November, marketing spend increased from $2K to $4K starting October, supply costs up 18% over the period]
</context>

<instructions>
- Identify the overall trajectory: is the business growing, stable, or declining?
- Calculate period-over-period growth rates for revenue, expenses, and net income
- Identify 2-3 notable trends with specific data points
- Correlate business decisions (new hire, marketing increase) with financial outcomes where possible
- Provide a forward-looking assessment: if current trends continue, what should the client expect?
- Close with 2-3 recommendations based on the trends
</instructions>

<format>
Professional narrative with a trend summary table at the top showing the key metrics by period. Follow with 3-4 paragraphs of analysis and recommendations.
</format>

Example Output:

6-Month Trend Summary

>
Revenue has grown 29% over the past six months, from $52,000 in August to $67,000 in January. More importantly, net income has grown 75% ($8,000 to $14,000) — meaning the practice is becoming more profitable, not just busier. Net margin improved from 15.4% to 20.9%.

>
The Marketing Investment is Working. The increase in marketing spend from $2,000 to $4,000 per month starting in October correlates with the revenue acceleration. October through January revenue averaged $60,250, compared to $50,000 for August-September. The $2,000 per month increase has generated approximately $10,000 per month in additional revenue — a 5:1 return.

>
Recommendations:

1. Maintain the current marketing spend — the ROI is strong and there may be room to increase if capacity allows

2. Monitor supply costs, which are rising faster than revenue — negotiate bulk pricing or evaluate alternative suppliers

3. The new hygienist is generating revenue above their cost — consider whether a second hygienist would be justified by Q3

Tips for Better Results

  • Always include comparison data. Financial narratives without context are meaningless. Include prior month, prior year, or budget comparisons so Claude can explain what changed and why.

  • Specify the audience explicitly. A summary for a business owner reads very differently from one for an investor or a bank. Tell Claude who will read it.

  • Use actual figures, not ranges. "Revenue of approximately $142,000" produces better output than "revenue in the $140K range." Claude writes more confidently and specifically with precise inputs.

  • Include the "why" when you know it. If you know why revenue increased (new client, seasonal pattern, price increase), include that context. Claude will weave it into the narrative more naturally than if it has to guess.

  • Review all calculations. Claude occasionally makes arithmetic errors, especially with percentages and period-over-period comparisons. Always verify the math against your accounting records before sharing with clients.

  • 5 Claude Prompts for Tax Preparation Documentation

  • 5 Claude Prompts for Bookkeeper Client Communication

  • Claude CoWork for Bookkeepers & CPAs

  • Get weekly AI prompts for Bookkeeping professionals

    Join professionals already saving hours every week. Free. No spam.