Skip to main content
skill CX Codex

budget-planner — Claude Code skill: budget workbook from a business plan

budget-planner turns a business plan or project spend into an Excel budget with account lines, a monthly spread, summaries and a separate assumptions sheet.

Apache-2.0 ★ 12,746 updated 2026-10-29

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add genspark-ai/genoffice --skill budget-planner -a claude-code
Open on GitHub

What budget-planner does

Hand it a business plan, earlier figures or a note on what a project will cost, and it returns an Excel workbook. Four sheets come out: Assumptions, Detail with level-1 and level-2 accounts plus a column per month, Summary with totals by account and by quarter, and a Change log opened by an “Initial version” row.

Scope gets settled in one round of questions: perimeter, period and start month, currency, tax basis, history, whether revenue belongs in the file, the chart of accounts and the roll-ups approvers ask for. It then puts the key assumptions in front of you (headcount and start months, unit prices, growth rate, exchange rate, one-off versus recurring spend) and waits for confirmation on every line. Amounts on Detail are formulas pointing at Assumptions, so one changed input moves the whole book.

A price or growth rate you never supplied stays blank and carries a [to confirm] mark, and the summary reflects that. Contingency is added as a separate account line only after you approve it. Tax rates and social-insurance ratios follow current local rules, so have a finance or tax specialist read the file before it goes to formal submission.

What it helps with

  • Build an annual department budget from a business plan
  • Spread project spend over 12 months with one-off items in their month
  • Give approvers a summary by quarter and by level-1 account
  • Recalculate the workbook after a headcount assumption changes
  • Convert a multi-currency budget into the reporting currency

Example prompts for the agent

  • Build next year's department budget from this business plan, currency USD, starting in January.
  • Spread this project's spend across 12 months and keep every assumption on its own sheet.
  • Add a conservative scenario and show the three largest accounts by share.

How to install budget-planner

1Skills CLI (Vercel)

npx skills add genspark-ai/genoffice --skill budget-planner -a claude-code

2Manually: put the files in place

~/.claude/skills/budget-planner/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/budget-planner/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about budget-planner

How do I install budget-planner in Claude Code?

Run npx skills add genspark-ai/genoffice --skill budget-planner -a claude-code. The skill then sits at ~/.claude/skills/budget-planner/SKILL.md.

What does budget-planner do?

It builds an Excel budget from a business plan or a description of project spend: account lines, monthly amounts, summaries by account and quarter, an assumptions sheet and a change log.

What happens if I leave out a unit price?

The cell on the assumptions sheet stays empty and is marked [to confirm], and the summary is shown as incomplete. The skill will not fill in a number for you.

Source text

SKILL.md · Apache-2.0
---
name: budget-planner
description: Turn a business plan into an annual or project budget with account lines, monthly spread, summaries and a separate assumptions sheet, delivered as an Excel workbook
category: finance
scenarios: Annual budget | Project budget | Assumption modelling
quickPrompts: Build next year's department budget from this business plan | Turn this project's spend into a budget workbook
metadata:
  version: 1.0.0
---

You are a budget-planning specialist. The user gives you a business plan, historical figures or a description of project spend; you deliver a budget workbook with clear account lines, traceable formulas and assumptions listed on their own sheet.

## Workflow

1. Pin down the scope (ask for everything missing in one go): budget perimeter (company / department / project), period and starting month, currency, tax-inclusive or not, same-period historical data, whether revenue is included, the company's chart of accounts or usual categories, and the roll-up dimensions approval needs (by month / quarter / account / project).
2. In your reply, first list the "Key assumptions": headcount and start months, unit-price assumptions (cost per head, unit purchase price, growth rate, exchange rate), and the split between one-off and recurring spend. Have the user confirm or change each line; nothing enters the workbook before it is confirmed.
3. Build the workbook as an Excel workbook with the spreadsheet tools available here. Title it "<Scope> <Year/Project> Budget".
   - Sheet "Assumptions", columns: Assumption | Value | Unit | Source/Basis | Notes. Every detail calculation references cells on this sheet.
   - Sheet "Detail", columns: Level-1 account | Level-2 account | Description | one column per month (1-12) | Full-year total | Notes. Monthly amounts come from Assumptions parameters via formulas; one-off spend lands in its specific month.
   - Sheet "Summary": two summary tables, by level-1 account and by quarter, aggregated from Detail with formulas. Add a "YoY" column when historical data exists and a "Net position" row when revenue is included.
   - Sheet "Change log", columns: Date | Change | Before | After | Reason. Write the first row as "Initial version".
   - Number columns right-aligned with thousands separators, total rows bold, negatives in parentheses or red.
4. After delivering, report in the reply: the total budget, the top three accounts and their share, the two or three assumptions with the biggest effect on the result, and ask whether the user wants a conservative / aggressive scenario version.

## Style and formatting

- Account names match the user's chart of accounts; without one, use two levels (level 1 / level 2) and do not subdivide further.
- Freeze the header row on every sheet; amount columns use two decimals and the currency symbol throughout.
- Every assumption carries a source (historical average / contract / quote / user estimate); anything without one is marked "estimate".
- The top of the Summary sheet holds at most three lines of text: total budget, scope, version date.

## Rules

- No hand-typed derived numbers on the Detail sheet. Every value that can be derived must be a formula, so changing an assumption flows through the whole workbook.
- Never fill in unit prices or growth rates the user did not provide from "industry common sense". Leave the Assumptions cell blank, mark it "[to confirm]", and let the Summary show as incomplete accordingly.
- Tax-inclusive and tax-exclusive bases are consistent across the workbook. Tax rates, social-insurance ratios and similar follow current local regulations; have a tax or finance professional review before formal submission.
- A contingency reserve is added only once the user approves it, as its own account line, never buried inside other accounts.
- Staff cost is computed from the start month, not full-year full headcount; leavers and new positions get separate rows.
- Multi-currency budgets set exchange rates on the Assumptions sheet and convert to the reporting currency; Detail keeps an original-currency column.
- Accounts that differ from last year's actuals by more than the user's threshold get the reason noted in the Notes column.

© genspark-ai · Apache-2.0 · genspark-ai/genoffice

Similar skills

All skills for Finance and business →

From the same set65

The whole set →
layout layout — a Claude Code prompt that defines operations for sorting ranges, merging cells, freezing headers and configuring print settings in spreadsheet files. Runs whenever the agent needs to reorder data or prepare a sheet for printing. GP ChatGPT ★ 12,746repo stars expense-report expense-report turns a stack of receipts into an expense claim workbook, with a line-by-line breakdown and a sheet listing what breaks the policy. CX Codex +1 ★ 12,746repo stars quiz-maker quiz-maker generates complete tests and quizzes by topic and difficulty, delivering ready-to-use Word documents with answer keys and error analyses. CX Codex +1 ★ 12,746repo stars business-plan This skill turns a project idea and source material into a Word business plan with market, product, competition, finance, and team sections. CX Codex +1 ★ 12,746repo stars personal-finance personal-finance turns income, expenses, and savings targets into a monthly budget and action plan. Delivers the result as an Excel workbook with formulas and tracking sheets. CX Codex +1 ★ 12,746repo stars thesis-advisor thesis-advisor is a Claude Code skill that turns your research materials into a thesis outline, chapter draft, or literature-review framework in Word; you provide the evidence and conclusions. CX Codex +1 ★ 12,746repo stars financial-formatting financial-formatting — a prompt for styling balance sheets, income statements, cash flow statements, and other accounting tables. Defines number formats, row hierarchy, color schemes, and layout rules aligned with GAAP and IFRS standards. GP ChatGPT ★ 12,746repo stars invoice-tax-checklist invoice-tax-checklist converts transaction details into an invoicing and tax checklist saved as a Word document. Keeps tax rates as placeholders for expert review. CX Codex +1 ★ 12,746repo stars

Project sponsors

Companies that keep this analytics open