Prepare a monthly financial report
This Cowork prompt generates a professional financial report from your accounting files (bank exports, invoices, tracking spreadsheets). Claude analyzes data, calculates KPIs, compares with previous month, and flags alerts. M+1 projections help with planning. Ideal for freelancers, small businesses, and startups without a CFO.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Analyze my financial data and generate a monthly financial report for [month/year].
Source files
- Bank export: [path, e.g. ~/Finance/bank-statement-{month}.csv]
- Income tracking spreadsheet: [path, e.g. ~/Finance/income.xlsx or .csv]
- Expense spreadsheet: [path, e.g. ~/Finance/expenses.csv]
- Invoices issued (folder): [path, e.g. ~/Finance/invoices-issued/]
- Invoices received (folder): [path, e.g. ~/Finance/invoices-received/]
- Previous month's report (for comparison): [path]
Report structure
1. Executive summary (5 lines)
- Total income for the month
- Total expenses
- Net result (profit/loss)
- Change vs. previous month (in % and in value)
- Alert if critical threshold reached
2. Detailed income
- Breakdown by source/client/category
- Top 5 clients by revenue
- Change vs. previous month
- Recurrence rate (returning vs. new clients)
- Invoices awaiting payment (amount and age)
3. Detailed expenses
- Breakdown by category (rent, salaries, tools, marketing, etc.)
- Top 5 expense items
- Recurring vs. one-time expenses
- Change vs. previous month
- Alerts for abnormal expenses (>20% vs. average)
4. Key metrics
- Net margin (%)
- Collection rate
- Burn rate (if startup)
- Estimated runway (months remaining at the current pace)
- Recurring revenue / total ratio
5. Projections
- Income estimate for M+1 based on trends
- Expected expenses for M+1
- Things to watch for the following month
Save the report to [path, e.g. ~/Finance/reports/report-{month-year}.md].
Personalize this prompt with Léa · AI assistant
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
The 5-section structure covers all aspects of financial reporting. Cross-referencing sources (bank, invoices, tracking) ensures data consistency. Automatic alerts on anomalies and projections add a decision-making dimension to the report.
Use Cases
Variants
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 améliorer la précision, ajoutez des instructions pour normaliser les catégories de dépenses communes entre vos fichiers CSV, surtout si les libellés bancaires diffèrent de votre tableau de suivi.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Organize and rank job applications
This Cowork prompt analyzes every CV and cover letter in your applications folder. Claude evaluates each candidate on 5 weighted criteria, generates an overall score, summary, and ranking. The shortlist is argued with points to explore in interviews. Email templates (acceptance and rejection) are included for a complete recruitment process.
Sort and organize my Downloads folder
This Cowork prompt turns your messy Downloads folder into a clean, date-organized file structure. Claude directly accesses your files, identifies types, spots duplicates, and proposes a smart sorting plan. Each file is renamed with its modification date for chronological ordering. The process is safe: no deletion without your explicit approval. Perfect for a one-time cleanup or monthly routine.
Create an onboarding pack for a new team member
This Cowork prompt generates a complete, personalized onboarding kit from your internal documents. Claude analyzes your processes, documentation, and past packs to create: welcome guide, D1/W1/M1 checklist, first week schedule, and feedback template. Each file is saved in a dedicated folder for the new team member.
Automate invoice generation
This Cowork prompt automates invoice generation from your service data (CSV, spreadsheet). Claude applies legal mentions, calculates VAT and totals, numbers sequentially, and saves each invoice in your file structure. The global summary and payment tracking update complete the billing process.