Every month, the same ritual.

Pull the numbers. Export the reports. Build the slides. Spend hours trying to turn a spreadsheet full of data into something that actually tells you what's happening in the business.

By the time the review is done, half the day is gone. The decisions that needed to be made last week are still waiting.

I've sat in enough monthly business reviews to know the problem isn't the data. It's that raw financial data doesn't tell you anything on its own. It needs context, comparison, and the right questions asked of it.

That's exactly what AI does well.

This week: the workflow I use with clients to turn monthly financial reporting and quarterly dashboards from a half-day exercise into a 30-minute decision-making session.

Let's get into it

Personal experience

One of the most consistent frustrations I see across client organizations isn't a lack of financial data. It's a lack of financial clarity. The numbers exist. The reports get built. But by the time they reach the leadership team, nobody can agree on what they actually mean or what to do about them.

I started loading monthly financial reports and quarterly dashboard data directly into Claude and asking it to do what a great CFO does naturally. Separate signal from noise. Identify what changed and why. Surface the two or three decisions that actually need to be made this month.

The output isn't a summary of the data. It's a brief that tells you where to focus.

The time saved is significant. But the bigger shift is the quality of the conversation in the room. When the review starts with clear insight rather than raw numbers, the meeting moves from reporting to deciding.

That's the difference this workflow makes.

The workflow: 5 steps

Step 1: Export your monthly financials
Pull your P&L, revenue by segment or product line, and any operational metrics you track monthly. CSV or copied table format works fine. Claude doesn't need a formatted report, it needs the data.

Step 2: Load into Claude with context
Paste your data and give Claude the business context it needs. What you sell, who your customers are, what your growth targets are, and what last month looked like. The more context you give, the sharper the output.

Step 3: Run the monthly review prompt
Ask Claude to analyze performance, identify what changed, flag anomalies, and surface the top decisions for the month. The prompt is in section 02.

Step 4: Build the quarterly dashboard narrative
Once you have three months of monthly reviews, ask Claude to synthesize them into a quarterly narrative. What trends are emerging, what's improving, what's getting worse, and what the business should focus on next quarter.

Step 5: Walk into the room with a brief, not a spreadsheet
Share Claude's output as your pre-read before the review meeting. The conversation starts at insight, not at data. Decisions get made in 30 minutes instead of three hours.

Tool ratings
Ease of setup: 9/10 — no integration required, copy-paste ready
Time saved: 2 to 4 hours per monthly review cycle
Cost: Free on Claude's base tier, upgrade to Claude Pro for larger datasets

The monthly business review prompt
Paste your financial data first, then run this in Claude

You are my CFO and strategic advisor. I am going to give you my monthly financial data and business context. Your job is not to summarize the numbers. It is to tell me what they mean and what I should do about them.

BUSINESS CONTEXT:
Business type: [DESCRIBE YOUR BUSINESS]
Monthly revenue target: [TARGET]
Key metrics I track: [LIST YOUR METRICS]
Last month in one sentence: [BRIEF CONTEXT]

YOUR ANALYSIS, in this order:

1. PERFORMANCE SNAPSHOT
How did this month compare to last month and to target? Lead with the most important number. Not the biggest number, the most strategically significant one.

2. WHAT CHANGED AND WHY
Identify the 2 to 3 biggest movements in the data. For each: what drove it, is it a trend or a one-time event, and does it change how I should think about next month?

3. ANOMALIES
What in this data doesn't fit the pattern? Flag anything that looks structurally wrong. Not just a bad month, but a potential underlying issue.

4. THE THREE DECISIONS
Based on this data, what are the three decisions I need to make this month? For each: what's the decision, what does the data say, and what's the risk of getting it wrong?

5. NEXT MONTH OUTLOOK
Based on this month's data and trends, what should I be watching most closely next month? Give me one leading indicator to track weekly.

Be direct. I don't need encouragement. I need clarity.

[PASTE YOUR FINANCIAL DATA HERE]

QUARTERLY DASHBOARD PROMPT
Run this at the end of every quarter with three months of data

You are my strategic advisor preparing me for a quarterly business review. I am going to give you three months of financial and operational data.

Your job:

1. QUARTERLY NARRATIVE
Tell the story of this quarter in three sentences. What happened, what drove it, and what does it mean for the business going forward?

2. TRENDS
Identify the two most important trends, one positive and one concerning. For each: how long has it been building, what's driving it, and what happens if it continues for another quarter?

3. PERFORMANCE VS PLAN
Where did we beat plan, where did we miss, and what does the gap tell us about our planning assumptions?

4. NEXT QUARTER PRIORITIES
Based on this quarter's data, what are the top three priorities for next quarter? Rank them by impact, not urgency.

5. THE QUESTION THE BOARD WILL ASK
What is the single hardest question I will face in my next board or leadership review based on this data? Give me the question and the honest answer.

[PASTE THREE MONTHS OF DATA HERE]

What matters this week

CFOs report AI has cut monthly close time by up to 40% at leading firms

Finance teams at major organizations are reporting significant reductions in monthly close and reporting cycles after integrating AI into their financial review workflows, with some cutting the process nearly in half.

Why it matters to you: the monthly review bottleneck isn't unique to your business. The firms moving fastest are the ones treating financial reporting as a data problem AI can help solve, not a process only humans can run.

Google Sheets adds AI-powered anomaly detection in its latest update

Google's latest AI update for Sheets now flags statistical anomalies in your data automatically, surfacing outliers and unexpected variances before you even start your analysis.

Why it matters to you: pair this with the Claude workflow above and your monthly review starts with anomalies already flagged. You're analyzing exceptions, not hunting for them.

Operators who review monthly outperform those who review quarterly by 23% on key growth metrics

A study of 500 SMBs found that businesses running structured monthly reviews with clear decisions documented and tracked significantly outperform those relying on quarterly reviews alone.

Why it matters to you: the cadence matters as much as the content. A 30-minute AI-assisted monthly review beats a three-hour quarterly one every time.

Pull last month's financial data. Your P&L, revenue by line, and whatever operational metrics you track. Export it or copy it into a document.

Open Claude. Paste the data. Add your business context: what you sell, what your targets were, what happened last month in one sentence. Then run the monthly review prompt above.

Read what comes back carefully. Pay particular attention to the three decisions section. Those are the conversations your next review meeting should be built around.

If your review is this week, run the prompt tonight. Walk into the room with Claude's brief as your pre-read. See how differently the conversation goes when it starts with decisions instead of data.

Going further: run this for three consecutive months and then use the quarterly dashboard prompt. By month three you'll have a living financial narrative that compounds. Each month's review informed by the pattern Claude has been tracking.

One more thing: if you run client business reviews, this workflow changes the dynamic of the room. Your clients spend less time explaining the numbers and more time making decisions. That's the value your engagement delivers, and AI just made it faster to get there.

If you run the monthly review prompt this week and something useful comes back, reply and tell me what it surfaced. I read every response.

See you next week

Fernando

If you found this useful, forward it to one person running a business who dreads their monthly review. They can subscribe free at leverageletter.ai