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
npx skills add genspark-ai/genoffice --skill budget-planner -a claude-codeWhat 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-code2Manually: put the files in place
~/.claude/skills/budget-planner/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/budget-planner/
1Skills CLI (Vercel)
npx skills add genspark-ai/genoffice --skill budget-planner -a codex2Manually: put the files in place
.agents/skills/budget-planner/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add genspark-ai/genoffice --skill budget-planner -a cursor2Manually: put the files in place
.cursor/skills/budget-planner/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install genspark-ai/genoffice skills/recommended/budget-planner2Manually: put the files in place
.github/skills/budget-planner/SKILL.md1Skills CLI (Vercel)
npx skills add genspark-ai/genoffice --skill budget-planner -a gemini-cli2Platform CLI
gemini skills install https://github.com/genspark-ai/genoffice --path skills/recommended/budget-plannerManually: put the files in place
.devin/skills/budget-planner/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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