To build a rolling cash budget with Claude, export last year's monthly profit and loss as a CSV, upload it with your invoice history and ask for an Excel workbook that converts each line to cash timing, holds every assumption on one tab and runs 12 months ahead. Each month, swap the finished month for actuals and add one more at the end.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowThe conversion step is the whole job. A profit and loss account records income when you invoice and costs when they arise; a cash budget records money when it reaches or leaves the bank. In the illustrative recruitment agency below, last year's books show a $75,600 profit, yet next year's cash budget dips to $6,507 in October with the business still profitable. Client payment delays, quarterly rent, tax instalments and loan capital explain the gap, and a P&L shows none of them.
What does Claude need from you before it builds a cash budget?
Claude needs five things, chief among them last year's monthly profit and loss and your sales invoices with paid dates, so it can turn income and costs into cash timing.
Gather five things. Most come straight out of your accounting software in a few minutes:
- Last year's profit and loss by month, as CSV or Excel, one column per month. Ask your bookkeeper whether the books are kept on an accruals basis (income when invoiced) or a cash basis; this tutorial assumes accruals, which is the harder and more common case.
- Last year's sales invoices with invoice date, paid date and amount. This is how Claude works out how quickly clients really pay, instead of trusting your payment terms.
- A list of the payments a P&L hides or spreads: annual subscriptions, rent dates, loan repayments (the P&L shows only the interest), tax instalments with dates from your accountant, planned equipment purchases and owner drawings.
- Your opening bank balance on the first day of the budget.
- The changes you already know about: a new hire, a price rise, a lease review.
On Claude's side, file creation and analysis are on every plan, Free included. On individual plans the setting, Code execution and file creation (called Create and edit files in the newer settings layout), is on by default under Settings > Capabilities; on Team plans it is on unless an Owner has turned it off. Files can be up to 30MB each, and building them uses more of your usage limit than ordinary chat. If your books are in Xero, its Claude connector can pull a profit and loss for flexible date ranges, so you can skip the export; keep a downloaded copy anyway, because the checks later compare Claude's totals against a file you control.
One thing to keep out of this chat: Claude's Personal Finance feature, which links your own bank and card accounts. It is built for household money, it isn't on Team or Enterprise plans, and Claude's help centre warns that after Claude uses those linked accounts in a chat, it may not be able to make Excel files there. Build the business budget in its own chat or project.
How do you turn last year's P&L into cash?
Treat each P&L line by when the money moves rather than when it is booked: fee income arrives later, salaries leave the same month, and some lines change or drop out of cash.
The illustrative agency places permanent candidates for client firms: seven people, fees invoiced when a candidate starts, clients on 30-day terms who often pay later. Here is last year's P&L as exported, with what the cash budget does to each line:
| P&L line, last year | Annual total | Cash treatment |
|---|---|---|
| Fee income | $666,000 | Arrives one to three months after invoicing |
| Salaries, including employer costs | $408,000 | Same month |
| Commission (10% of fees) | $66,600 | Paid the month after the fee is collected |
| Advertising | $20,400 | Same month |
| Job board subscription | $18,000 | All in January; the P&L spreads it at $1,500 a month |
| Rent | $48,000 | A quarter in advance: January, April, July, October |
| Software | $13,200 | Same month |
| Accountancy | $7,200 | One bill in March; the P&L spreads it |
| Depreciation | $6,000 | Left out: no money moves |
| Loan interest | $3,000 | Part of a $1,800 monthly repayment that also repays capital |
| Net profit | $75,600 | Not a cash figure at all |
Three lines change the picture most: fee income, because of the payment delay; the annual and quarterly bills, because they land in lumps; and the loan, because the capital repaid each month never appears in a P&L. Lines that don't exist in the P&L at all, tax instalments, equipment and drawings, come from your list in step 3.
How do you prompt Claude to build the cash budget workbook?
Prompt Claude in two steps: a reading pass before any spreadsheet, then the build. The reading pass catches the classification errors while they are cheap to fix.
I've attached last year's monthly P&L (CSV) and last year's sales
invoices with invoice date, paid date and amount.
1. List every P&L line with its annual total.
2. Mark each line: cash in the same month, cash at a different time,
or non-cash. Explain any line you're unsure about and ask me.
3. From the invoices, work out what share of each month's invoiced
value was paid one, two and three or more months later.
Use value, not invoice count, and leave out credit notes.
Don't build anything yet.
An illustrative answer: "Fee income $666,000 … Depreciation $6,000 is non-cash. Job board subscription is exactly $1,500 every month, which looks like an annual payment spread across the year: when is it actually paid? Payment pattern, by value: 55% paid the month after invoicing, 40% the month after that, 5% later." What to fix: the first run of this agency's data counted credit notes as paid invoices and reported 61% paid in the first month. The instruction to leave credit notes out, already in the prompt above, brought it back to 55%. Read the method Claude describes, not just the percentage.
Then the build, with every assumption from the next section pasted underneath:
Build an Excel workbook from the attached P&L and the assumptions below.
Tabs:
1. Actuals: last year's P&L exactly as exported, plus annual totals.
2. Assumptions: one row each, with value, unit and source.
3. Cash budget: 12 monthly columns. Opening balance, cash in, each
cash-out line, closing balance. Every forecast cell must be a
formula pointing at Assumptions or Actuals. No typed numbers.
4. Scenarios: a cell where I type Base, Cautious or Upside; the growth
and payment-pattern assumptions switch with it. Show the lowest
closing balance and its month for each scenario.
5. Checks: the tests I list, each showing OK or the difference.
Use my figures exactly. Don't invent assumptions; list anything missing.
What goes on the assumptions tab for a recruitment agency?
The assumptions tab holds every driver on one sheet: fee growth, how quickly clients pay, and the fixed costs and payments that fall in set months.
| Assumption | Base value | Source |
|---|---|---|
| Fee income | Same month last year plus 6% | Owner's target; last year $666,000 |
| Client payment pattern | 55% next month, 40% the month after, 5% the third month | Last year's invoices, by value |
| Money owed by clients on day one | $70,300, collected January to March | Aged receivables at year end |
| Salaries | $34,000 a month; plus $5,500 from April for a new consultant | Payroll; hiring plan |
| Commission | 10% of fees collected, paid the following month | Commission scheme |
| Advertising | $1,870 a month (10% rise) | Supplier notice |
| Job board subscription | $18,000 in January | Annual contract |
| Rent | $12,000 a quarter in advance; $12,600 from July | Lease, 5% rise at the July review |
| Software | $1,100 a month | Subscription list |
| Accountancy | $7,200 in March | Engagement letter |
| Loan | $1,800 a month, interest and capital | Loan schedule |
| Tax instalments | $9,000 in April and in October | Dates and amounts from the accountant |
| Laptops for the new hire | $4,800 in April | Supplier quote |
| Owner drawings | $3,000 a month | Owner |
| Opening bank balance | $55,000 | Bank statement |
| Depreciation | Excluded | Non-cash |
The source column is the part people skip and later regret. When a figure turns out wrong in June, it tells you whether the mistake was the owner's target, the payroll or the accountant's tax estimate, and who to ask.
The base case, month by month
With those assumptions, the agency's base cash budget comes out like this (all figures illustrative, rounded to the dollar):
| Month | Cash in | Cash out | Closing balance |
|---|---|---|---|
| Jan | $50,000 | $76,970 | $28,030 |
| Feb | $46,384 | $46,770 | $27,644 |
| Mar | $52,568 | $53,608 | $26,604 |
| Apr | $60,155 | $78,327 | $8,432 |
| May | $60,685 | $53,286 | $15,831 |
| Jun | $60,367 | $53,338 | $22,860 |
| Jul | $64,236 | $65,907 | $21,189 |
| Aug | $58,936 | $53,694 | $26,431 |
| Sep | $48,442 | $53,164 | $21,709 |
| Oct | $58,512 | $73,714 | $6,507 |
| Nov | $70,967 | $53,121 | $24,353 |
| Dec | $70,490 | $54,367 | $40,476 |
| Year | $701,742 | $716,266 |
January's cash in is entirely last year's invoices: $38,000 billed in December at 55%, plus November's and October's tails, exactly $50,000. None of January's own invoices arrive until February. January's cash out carries the $18,000 job board bill and a $12,000 rent quarter on top of $34,000 of salaries.
The two pinch points are April and October, and the workbook shows why. April's $78,327 holds the first month of the new consultant's salary, the laptops, a rent quarter and a $9,000 tax instalment, all before the new consultant has billed anything. October repeats the rent and tax pattern on a bigger payroll, and it starts from a lower balance because September's collections dipped to $48,442 after a quiet August for placements. A $6,507 low on a $54,000-a-month cost base is less than four days of spending.
Once the workbook exists, question it the way you would question a finance manager. Two examples from the agency, with illustrative answers:
How much would I need to hold back from drawings, starting in April,
to keep every month above $10,000 in the base case?
"Cut drawings by $500 a month from April. October then closes at $10,007, the lowest month; April closes at $8,932, so April also needs a one-off $1,068 held back, or the laptops moved to May." That answer is checkable in seconds: seven months of $500 from April to October adds $3,500 to October's $6,507.
Could we afford a second new consultant from September,
at $5,500 a month in salary and nothing else?
"Not in the base case without other changes: October would fall from $6,507 to -$4,493. It works in the upside case, where October would close at $33,446." Answers like these are what the budget is for; they turn "can we afford it?" into a month and a number.
Why run three cash budget scenarios?
Three scenarios show how low the cash balance could fall under different fee growth and client payment speeds, which a single base case hides. The agency ran three, changing only fee growth and how quickly clients pay:
| Scenario | Fees for the year | Cash received | Lowest balance | Year end |
|---|---|---|---|---|
| Base: fees up 6%, clients pay 55/40/5 | $705,960 | $701,742 | $6,507 in October | $40,476 |
| Cautious: fees 5% below last year from March, clients pay 45/45/10 | $643,700 | $637,810 | -$37,553 in October; first below zero in April | -$17,756 |
| Cautious, with the hire moved to July and drawings cut to $1,500 from April | $643,700 | $637,810 | -$10,553 in October | $12,244 |
| Upside: fees up 15%, clients pay 55/40/5 | $765,900 | $755,355 | $19,550 in April | $89,327 |
The cautious row is the useful one. A modest dip in fees plus clients paying a few weeks later turns a year that still shows a small profit on paper, about $1,590, into one that needs borrowing from April. Even after delaying the hire and halving drawings, October still goes $10,553 below zero, because the rent quarter and the tax instalment land together. That gives the owner a decision rule to write down now, while it is calm: if March's fees come in under $57,950 (5% below last March), move the hire to July, cut drawings, and talk to the bank about an overdraft before October rather than in it.
Ask Claude for the scenario comparison in words as well as numbers:
Compare the three scenarios. For each, give the lowest closing balance,
its month, and the two payments that cause it. Then tell me the
earliest month in which actual results would show which scenario
we're in, and what figure to watch.
A cash budget is a planning tool, not financial advice. Before you sign a lease, take on a hire or arrange borrowing on the strength of one, have your accountant check the assumptions, especially tax dates and amounts, which Claude cannot know.
How do you check a cash budget's totals before trusting it?
Build a Checks tab that proves the totals before you trust the workbook, because formulas can still be wrong everywhere at once. These checks catch most of it, and Claude can build each into the Checks tab:
- The import matches the export. Every line on the Actuals tab equals the exported file to the cent, and net profit reads $75,600.
- Cash in ties to invoices. Money owed at the start, plus fees invoiced, minus cash received, equals money owed at the end: $70,300 + $705,960 − $701,742 = $74,518. If cash received equals fees invoiced exactly, the payment delay has been ignored.
- The bank balance rolls. $55,000 + $701,742 − $716,266 = $40,476, and each month's closing balance is the next month's opening.
- No non-cash lines. Depreciation appears nowhere in cash out.
- No typed numbers. Ask Claude to list any cell in the Cash budget tab that holds a typed number rather than a formula. There should be none.
- Profit bridges to cash. The budget year's profit and the change in the bank balance are linked by a short list of known items, below.
| Bridge, base case | Amount |
|---|---|
| Budgeted profit for the year | $57,624 |
| Add back depreciation, including $1,200 on the new laptops over three years (no cash moves) | +$7,200 |
| Laptops bought (cash out in full; the P&L only sees depreciation) | -$4,800 |
| Loan capital repaid | -$18,600 |
| Tax instalments | -$18,000 |
| Owner drawings | -$36,000 |
| More owed by clients at year end ($74,518 against $70,300) | -$4,218 |
| Commission earned but not yet paid | +$2,270 |
| Change in bank balance ($55,000 to $40,476) | -$14,524 |
If the bridge doesn't close, something is missing from the cash budget. That single check is worth more than any number of reviews of individual cells.
If building the checks and totals in a spreadsheet is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.
How the first draft overstated January by $18,050
The agency's first build skipped the reading pass and went straight to the workbook. It looked tidy and said January would close at $46,080. The bank, a month later, said about $28,000. Two lines explained the $18,050 gap. Claude had copied the P&L's $1,500 a month for the job board instead of the $18,000 paid in January, which flattered January by $16,500. And it had used the P&L's $250 of loan interest as the monthly payment instead of the full $1,800, which flattered every month by $1,550.
Neither is an arithmetic error, which is why they survived a glance. Both are classification errors. The profit-to-cash bridge would have caught the loan, because it refuses to close by exactly $18,600, the year's loan capital. Only the reading pass catches the job board, because spreading $18,000 evenly still totals $18,000 for the year; the error lives entirely in the timing. The fix took two lines on the Assumptions tab. The lesson took longer: never let Claude infer cash timing from a P&L alone.
How do you roll a cash budget forward each month in 20 minutes?
Roll the cash budget forward on the first working day of each month by replacing the finished month with actuals and adding one month at the end, so it always looks 12 months ahead. Upload the closing bank balance and last month's P&L and ask:
Replace [last month]'s forecast with these actuals: cash in, each cash-out
line and the closing bank balance. Add a new month at the end so the
budget still runs 12 months ahead, using the same assumptions as the
same month last year. Then list the three biggest differences between
last month's forecast and actual, with the reason for each where the
data shows it, and say whether any assumption should change.
An illustrative answer for February: "Cash in $40,184 against $46,384 forecast: two December invoices worth $6,200 will now be paid in March, not February. Cash out $46,120 against $46,770: advertising spend $650 below plan. Closing balance $22,094 against $27,644. Suggest: move the payment pattern to 50/43/7 if late December payers repeat." What to fix: one month of late payers is noise, not a trend; change the payment-pattern assumption only after two or three months point the same way. For explaining differences properly, see explaining budget versus actual variances with AI.
Keep the workbook, last year's exports and the assumptions in one Claude project, so each month starts with everything in place; Free accounts can create up to five projects. On Pro and above you can hand the roll-forward to a scheduled task, as described in running month-end jobs as Claude scheduled tasks. If you would rather edit the workbook inside Excel, the Claude for Excel add-in works on the same file. When the lowest month gets close to zero, add a weekly view for that stretch with a 13-week cash flow forecast.
How do you adapt the assumptions to other service businesses?
Keep the same workbook structure and change only the assumptions that match how the business gets paid.
- An estate agency is paid commission when a sale completes, often months after the instruction, and completions bunch in some seasons. The cash-in assumption is a pipeline: properties under offer, an expected completion month and the share that fall through. Last year's completion dates, not invoice dates, drive the pattern.
- A marketing agency on retainers often bills in advance, so cash arrives before the work. Its risk is the opposite of the recruiter's: a client giving 30 days' notice removes next month's cash almost immediately. Model retainers client by client, with notice periods.
- An architecture practice bills in fee stages, with long gaps while drawings sit with planners or clients. Put each project's next stage on its own row with an expected billing month, and treat a slipped stage as the cautious scenario.
If your books are in QuickBooks and you would like a second opinion from its built-in planner, sanity-checking the QuickBooks cash flow planner shows how to compare the two. For the underlying ideas behind all of this in plain language, the plain-English guide to cash flow forecasting is the place to start.
If you want help fitting a cash budget into how your business actually runs, I offer one-to-one AI consultations for small businesses.
Cash budgets with Claude: follow-up questions
Can Claude link to my business bank account for this?
Not for a business budget. Claude's Personal Finance feature links bank accounts for your own household money, and it isn't offered on Team or Enterprise plans. Claude's help centre also notes that after it uses those linked accounts in a chat, it may not be able to make Excel files there. Use exports from your accounting software or bank instead.
Should I build a 12-month or a 13-week cash budget?
Both have a job. The 12-month version decides hires, big purchases and borrowing. When the lowest month in it sits within about one month's payroll of zero, add a 13-week weekly view for the tight stretch, because a month that ends positive can still dip below zero in its middle week.
Is the file Claude makes a real Excel workbook with formulas?
Yes. Claude creates .xlsx files with working formulas that you download or save straight to Google Drive, up to 30MB per file. Check that the forecast cells really are formulas rather than typed numbers before you trust it; the checks in this tutorial include asking Claude to list any typed numbers in the cash tab.
Which Claude plan do I need?
File creation and analysis are on every plan, Free included, and switched on by default for individual plans. Paid plans add more usage, which matters because building files uses more of your limit than ordinary chat, and Pro and above can schedule a task to run the monthly roll-forward. Pro is $20 a month billed monthly.
Further reads
- AI Cash Flow Forecasting Tools for Small Businesses Compared — Compare dedicated cash-forecasting tools with a Claude-built workbook.
- How to Forecast Next Quarter's Sales With AI Using Your History — Sharpen the fee forecast that drives the cash-in line.
- How to Use Claude With Excel and Google Sheets Safely — Keep financial files safe when Claude works on them.
- Claude Excel Add-In Cost: Which Plan Do You Need for Claude for Excel? — What Claude for Excel costs if you prefer to work inside Excel.
- Can Claude Reconcile My Xero Bank Account? What It Can Check — Clean, reconciled books make last year's actuals trustworthy.
- How to Make a Bank or Investor Update Deck With Claude Slides — Turn the finished budget into a deck for your bank.
Browse all AI-for-business tutorials
Sources: Claude Help Centre (create and edit files, Personal Finance), claude.com pricing, Xero's Claude connector listing. Every figure in the worked example is illustrative and was calculated for this tutorial. Checked 18 November 2026.
