How to use Claude for FP&A

A series of practical guides, written up from builds on the Claude for Finance YouTube channel.

You can use Claude for most of the mechanical work in FP&A: building the annual budget and the rolling forecast, three-statement models and management packs, variance commentary, dashboards and group consolidations. Claude compiles, calculates, builds, reconciles and drafts. The decisions stay with you: the direction from leadership, the conversations with budget owners, what you know about the business and its history, and the final sign-off.

This is a series of practical guides. Each one is written up from a video in which I build the work end to end with Claude, on a realistic dataset for a fictional company. Start with the one closest to the work in front of you.

What Claude does, and what stays with you

In every piece of FP&A work there is a mechanical part and a judgement part. The mechanical part is where the weeks go: pulling data out of systems, normalising it, building schedules, writing formulas, tying totals, drafting the first version of the words. Claude takes that part, with you supervising every step.

The judgement part does not move. Claude cannot sit in the leadership meeting that sets the direction. It cannot push back on a department head who has padded a number. It does not know what a stakeholder told you last week, or why a line behaved the way it did three years ago. And it is not signing anything. That is why the finance professional who knows the craft gets the best results from it: you know what good looks like before you see it.

The guides

• How to build an annual budget with Claude. Build a budget agent that normalises last year, challenges your assumptions and consolidates a twelve-month phased P&L.
• How to build a 12-month rolling forecast with Claude. Settle the assumptions first, then build a working timeline and a rolling view driven by one start-date cell.
• How to build a three-statement model and management pack with Claude in Excel. From a general ledger and an account mapping to the three statements, a dynamic variance report and a board-ready pack.
• How to automate variance commentary with a Claude agent. What an AI agent is, and how to build one that drafts your monthly commentary in your voice.
• How to build a reusable finance dashboard with Claude. A board-grade interactive dashboard from your management pack, and how to roll it forward each month.
• How to do a group consolidation with Claude. Two entities, two currencies, three prompts with a review stop after each, and the decisions only you can make.

Five habits that make Claude reliable on FP&A work

1. Brief it like a new member of the team. Give it the files, the business context and the strategic direction, the same things you would hand someone on their first day.
2. Set the boundaries before it starts. Use only these numbers. Never invent a figure. If anything is unclear, stop and ask rather than guess.
3. Break the work into stages, and check each one. Never ask for a budget or a consolidation in one go. One schedule at a time, reviewed before the next.
4. Build it so it can be audited. Inputs, calculations and outputs kept apart, formulas rather than typed numbers, and a checks block that proves the totals tie.
5. Review it like a junior colleague's work. However much you would check the most junior person's work before it left the building, check this the same amount. You own the output.

Questions finance professionals ask

Can Claude build a budget on its own?

No, and it should not. Claude can take the three mechanical stages of a budget: normalising last year's actuals, building the revenue, people cost and cost schedules, and consolidating the phased P&L. Leadership direction and the challenge of department managers stay with you, and so does the sign-off.

Can I trust the numbers Claude produces?

Trust is the wrong test. Check them the way you would check a junior colleague's work: that the actuals tie to source, that every figure traces to an input, and that the checks read zero. Checks tell you the model is consistent with itself. Whether it is right is still your call.

Which Claude tools do these guides use?

The builds in the videos use Claude Cowork for model builds from a folder of files, Claude in Excel for work inside an existing workbook, and projects with standing instructions for agents that repeat every month.

Do I need to know how to code?

No. Everything in these guides is done in plain English. What you need is your finance craft: knowing what good looks like and where things usually go wrong.