Claude Prompt Library

30 Claude Prompts That Build Budgets

30 copy-paste prompts

Describe your money situation and Claude returns a finished budget: itemized categories, totals, percent-of-income, and formulas in a copy-paste table you can drop into Sheets or Excel. Prompts for household, small business, projects, marketing, events, and teams. Not "give me some tips".

In short: This page contains 30 copy-paste ready prompts, organized into 6 categories with a description and pro tip for each. The first 15 prompts are free instantly โ€” no signup needed. Hand-curated and tested by the AI Academy team.

By Louis Corneloup ยท Founder, Techpresso
Last updated ยทHand-curated & tested by the AI Academy team

Personal & Household Budgets

5 prompts

Monthly 50/30/20 Household Budget

1/30

You are a certified personal-finance coach who builds clear, no-jargon budgets. <context> I want a complete monthly household budget using the 50/30/20 framework (needs / wants / savings), returned as a self-contained, copy-paste budget table I can drop straight into Google Sheets or Excel. </context> <inputs> - Monthly take-home income: [AMOUNT] - Fixed needs (rent, utilities, insurance, groceries, transport): [ITEMS + AMOUNTS] - Wants (dining, subscriptions, hobbies): [ITEMS + AMOUNTS] - Savings and debt goals: [EMERGENCY FUND, RETIREMENT, DEBT PAYMENTS] - Household size: [NUMBER OF PEOPLE] </inputs> <task> Build a budget table with columns: Category, Subcategory, Budgeted, % of Income, and a Notes column. Group rows under Needs (target 50%), Wants (30%), and Savings/Debt (20%), with a subtotal per group and a grand total. Add a variance row comparing each group's actual share to its 50/30/20 target, and flag any group that is over. Fill every line with a realistic number derived from my inputs. </task> <constraints> - Every % of Income must be computed as amount / income; totals must reconcile exactly to income. - Show the exact spreadsheet formula (e.g. =B2/$B$1) once per column so I can extend rows. - No filler categories; only what I listed plus any obvious missing essential you flag. </constraints> <format> Return the budget as a Markdown table (spreadsheet-ready), then a 3-line note on which group is over target and the fastest fix. </format>

Produces a complete monthly household budget grouped by needs, wants, and savings with percent-of-income and variance, ready to use.

๐Ÿ’ก

Pro tip: Give Claude last month's actual bank totals per category so it can show budgeted-vs-actual variance, not just an ideal split.

Zero-Based Monthly Budget

2/30

You are a zero-based budgeting expert who assigns every dollar a job. <context> I want a zero-based budget where income minus all allocations equals exactly zero, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Total monthly income (all sources): [AMOUNT] - Recurring bills: [ITEMS + AMOUNTS + DUE DATES] - Variable spending categories: [GROCERIES, GAS, FUN, ETC] - Sinking funds to build (car repair, gifts, annual bills): [ITEMS + TARGET] - Debt payments: [DEBT, MINIMUM, EXTRA] </inputs> <task> Build a budget table with columns: Category, Type (Bill / Variable / Sinking Fund / Debt / Savings), Assigned, Due Date, and Priority. Allocate income top-to-bottom until Remaining to Assign hits zero. Add a running Remaining-to-Assign column that decreases with each row, and a final total row proving income minus assigned equals 0. Include a sinking-funds block that divides each annual target by 12. </task> <constraints> - The budget MUST balance to zero; show the check formula (income - SUM(assigned) = 0). - Sinking-fund monthly amount = annual target / 12; show that math in the Notes. - Sort bills by due date so I can pace withdrawals. </constraints> <format> Return the table (spreadsheet-ready), then a short note on which categories to trim first if income drops. </format>

Builds a balanced zero-based budget where every dollar is assigned and remaining-to-assign reaches zero, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude your pay cadence (weekly, biweekly, monthly) and it will split the assignments across paychecks instead of one lump.

Debt Payoff Budget (Snowball vs Avalanche)

3/30

You are a debt-elimination strategist who builds payoff plans people actually finish. <context> I want a debt payoff budget that shows both the snowball and avalanche methods side by side, returned as a copy-paste table and payoff schedule ready for Sheets or Excel. </context> <inputs> - Each debt with balance, APR, and minimum payment: [LIST] - Total monthly amount I can put toward debt: [AMOUNT] - Any windfall or extra I expect: [AMOUNT + TIMING] </inputs> <task> Build two tables. Table 1: each debt with Balance, APR, Minimum, and payoff order under both Snowball (smallest balance first) and Avalanche (highest APR first). Table 2: a month-by-month payoff schedule for the recommended method showing Month, Focus Debt, Payment, Interest Accrued, and Remaining Balance until every debt hits zero. Compute total interest paid and payoff date for BOTH methods so I can compare. </task> <constraints> - Interest per month = balance * (APR/12); show the formula. - Roll each cleared debt's payment into the next (true snowball/avalanche behavior). - State clearly which method saves more interest and by how much. </constraints> <format> Return both tables (spreadsheet-ready), then a 2-line recommendation on which method fits my situation. </format>

Generates a debt payoff budget comparing snowball and avalanche with a month-by-month schedule and total interest, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to add a column for the emotional 'quick win' date so you can weigh motivation against pure interest savings.

Annual 12-Month Household Budget

4/30

You are a household financial planner who builds year-long budgets with seasonal awareness. <context> I want an annual household budget spread across all 12 months, capturing irregular and seasonal costs, returned as a copy-paste 12-column table ready for Sheets or Excel. </context> <inputs> - Monthly income (note any seasonal changes): [AMOUNTS] - Recurring monthly expenses: [ITEMS + AMOUNTS] - Irregular/annual costs (insurance, taxes, holidays, back-to-school): [ITEMS + AMOUNTS + MONTH] - Savings targets: [EMERGENCY, VACATION, ETC] </inputs> <task> Build a table with a Category column plus Jan-Dec columns and a Year Total column. Place each recurring cost in every month and each irregular cost in its actual month. Add subtotal rows for Income, Expenses, and Net (Income - Expenses) per month, plus a cumulative running-balance row across the year. Highlight the months that go negative. </task> <constraints> - Year Total column = SUM of the 12 monthly cells; show the formula once. - Running balance carries the prior month's ending balance forward; show that formula. - Keep numbers realistic and reconciled with my inputs. </constraints> <format> Return the 12-month table (spreadsheet-ready), then a short note on which months need a buffer and how big. </format>

Builds a 12-month household budget with monthly net, cumulative balance, and seasonal costs mapped to real months, ready to use.

๐Ÿ’ก

Pro tip: Feed Claude the exact month each annual bill hits so it can pre-warn you which months need cash set aside in advance.

Variable / Irregular Income Budget

5/30

You are a financial coach who specializes in budgeting for freelancers and commission earners. <context> My income changes month to month. I want a budget built on a conservative baseline with a priority-based spending plan for surplus, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Lowest, average, and best monthly income over the last year: [3 AMOUNTS] - Essential monthly expenses I must always cover: [ITEMS + AMOUNTS] - Non-essential wants: [ITEMS + AMOUNTS] - Tax set-aside rate: [PERCENT] - Buffer/emergency target: [AMOUNT] </inputs> <task> Build two tables. Table 1: a baseline budget covering essentials, taxes, and buffer contribution using my LOWEST month as income. Table 2: a priority waterfall listing where each extra dollar goes above baseline (top up buffer, then savings, then wants, then investing), with a trigger amount for each tier. Show the tax set-aside as income * rate. </task> <constraints> - Baseline must be fully fundable from the lowest month; flag any shortfall. - Tax set-aside line = gross income * tax rate; show the formula. - The waterfall must be ordered by priority with clear dollar thresholds. </constraints> <format> Return both tables (spreadsheet-ready), then a 3-line rule for what to do in a below-average month. </format>

Creates a variable-income budget with a conservative baseline plus a priority waterfall for surplus months, ready to use.

๐Ÿ’ก

Pro tip: Give Claude your real low/average/high months and it will size the buffer to bridge your worst realistic income gap.

XML tags are just the start. Learn the full Claude workflow.

A growing library of 300+ hands-on AI tutorials covering Claude, ChatGPT, and 50+ tools. New tutorials added every week.

Start 7-Day Free Trial

Small Business Budgets

5 prompts

Startup First-Year Operating Budget

6/30

You are a startup CFO who builds first-year operating budgets for founders. <context> I am launching a business and need a month-by-month first-year operating budget covering startup costs and ongoing expenses, returned as a copy-paste 12-month table ready for Sheets or Excel. </context> <inputs> - Business type and model: [DESCRIBE] - One-time startup costs: [ITEMS + AMOUNTS] - Recurring monthly costs (rent, software, salaries, marketing): [ITEMS + AMOUNTS] - Expected monthly revenue ramp: [MONTH 1 -> MONTH 12 ESTIMATE] - Starting cash / funding: [AMOUNT] </inputs> <task> Build a table with a line-item column plus Month 1-12 and a Year Total column. Include revenue, COGS, gross profit, operating expense line items, one-time startup costs in the month they occur, net profit/loss per month, and a running cash-balance row starting from my funding. Break costs into logical groups (Payroll, Software, Marketing, Facilities, Other) with subtotals. </task> <constraints> - Gross profit = Revenue - COGS; Net = Gross profit - OpEx; show both formulas. - Running cash = prior cash + net; flag the month cash goes negative (runway). - Numbers must reconcile; Year Total = SUM of the 12 months. </constraints> <format> Return the 12-month table (spreadsheet-ready), then state the runway in months and the two biggest cost levers. </format>

Builds a month-by-month first-year startup budget with revenue ramp, cash runway, and grouped expenses, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to add a conservative and optimistic revenue row so you see how runway shifts if sales come in slower.

Annual Operating Budget (P&L Style)

7/30

You are a small-business controller who prepares annual operating budgets. <context> I want a full-year operating budget structured like a profit-and-loss statement, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Prior-year revenue and expenses (or estimates): [FIGURES] - Expected growth rate: [PERCENT] - Revenue streams: [LIST] - Fixed vs variable cost lines: [LIST + AMOUNTS] - Target net margin: [PERCENT] </inputs> <task> Build a P&L-style budget table with columns: Line Item, Prior Year, This Year Budget, Change (%), and % of Revenue. Structure it as Revenue (by stream) -> Total Revenue -> COGS -> Gross Profit -> Operating Expenses (grouped) -> Operating Income -> Net Income. Apply the growth rate to revenue and scale variable costs with it while holding fixed costs flat unless noted. </task> <constraints> - % of Revenue = line / total revenue; Change % = (this year - prior)/prior; show both formulas. - Gross Profit and Net Income must be computed rows, not hard-typed. - Compare resulting net margin to my target and flag the gap. </constraints> <format> Return the P&L budget table (spreadsheet-ready), then a 3-line note on whether the target margin is realistic and what to cut if not. </format>

Generates an annual P&L-style operating budget with growth applied, percent-of-revenue, and margin check, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude which costs are truly fixed; it will scale only the variable lines with growth so the margin math stays honest.

13-Week Cash Flow Budget

8/30

You are a cash-flow specialist who builds 13-week rolling forecasts for small businesses. <context> I need a 13-week cash flow budget to see exactly when cash gets tight, returned as a copy-paste weekly table ready for Sheets or Excel. </context> <inputs> - Starting cash balance: [AMOUNT] - Expected weekly cash inflows (invoices, sales, timing): [DETAIL] - Recurring outflows (payroll dates, rent, suppliers, loan payments): [DETAIL + TIMING] - Any one-time items in the next quarter: [ITEMS + WEEK] </inputs> <task> Build a table with a line-item column plus Week 1-13. Rows: Beginning Cash, itemized Inflows with subtotal, itemized Outflows with subtotal, Net Cash Flow, and Ending Cash (which becomes next week's beginning). Place each payment in its actual week. Add a minimum-cash-threshold row and flag any week that breaches it. </task> <constraints> - Ending Cash = Beginning + Inflows - Outflows; Beginning Cash (week n) = Ending Cash (week n-1); show both. - Timing matters: put payroll and rent in the correct weeks, not averaged. - Highlight the tightest week and by how much. </constraints> <format> Return the 13-week table (spreadsheet-ready), then name the risk week and two moves to cover it. </format>

Builds a 13-week rolling cash-flow budget with weekly inflows, outflows, and ending-cash carryforward, ready to use.

๐Ÿ’ก

Pro tip: Give Claude real invoice due dates and payment terms so the weekly timing reflects when cash actually lands, not monthly averages.

Break-Even & Pricing Budget

9/30

You are a pricing and unit-economics analyst. <context> I want a break-even budget that shows how many units or clients I must sell to cover costs and turn a profit, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Product/service and price per unit: [NAME + PRICE] - Variable cost per unit: [AMOUNT] - Total monthly fixed costs: [ITEMS + AMOUNTS] - Target monthly profit: [AMOUNT] - Realistic monthly volume range: [LOW - HIGH] </inputs> <task> Build two tables. Table 1: unit economics with Price, Variable Cost, Contribution Margin per unit, and Contribution Margin %. Table 2: a scenario grid across volumes (e.g. low, break-even, target, high) showing Units, Revenue, Variable Cost, Fixed Cost, and Profit for each. Compute the exact break-even units and the units needed to hit my target profit. </task> <constraints> - Contribution margin = price - variable cost; break-even units = fixed costs / contribution margin; show both formulas. - Units for target profit = (fixed + target profit) / contribution margin; show it. - Keep the volume scenarios inside my stated realistic range. </constraints> <format> Return both tables (spreadsheet-ready), then state the break-even volume and whether my target is achievable in range. </format>

Produces a break-even and pricing budget with per-unit margins and a profit-by-volume scenario grid, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to re-run the grid at a 10% higher price so you can see how much a small price bump lowers your break-even point.

Hiring & Headcount Budget

10/30

You are an HR finance partner who builds fully-loaded headcount budgets. <context> I want a hiring budget that shows the true cost of planned roles across the year, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Roles to hire, base salary, and start month: [LIST] - Employer payroll tax / benefits load rate: [PERCENT] - One-time costs per hire (recruiting, equipment, onboarding): [AMOUNT] - Any contractors vs full-time split: [DETAIL] - Annual people budget cap: [AMOUNT] </inputs> <task> Build a table with columns: Role, Type, Start Month, Base Salary, Loaded Cost (base * (1 + load rate)), One-Time Cost, Months Active This Year, and Cost This Year (prorated from start month). Add a total-headcount-cost row and a monthly run-rate row for the exit-month. Compare the total to my budget cap and flag overage. </task> <constraints> - Loaded cost = base * (1 + load rate); Cost This Year = loaded/12 * months active + one-time; show formulas. - Prorate every hire from its actual start month, not a full year. - Flag whether the plan fits under the cap and by how much. </constraints> <format> Return the table (spreadsheet-ready), then a 3-line note on which hire to delay if I need to fit the cap. </format>

Builds a fully-loaded hiring budget with prorated costs, benefits load, and a cap check across roles, ready to use.

๐Ÿ’ก

Pro tip: Give Claude the real employer burden rate for your region; a 25-40% load can be the difference between fitting the cap or not.

Project Budgets

5 prompts

Project Cost Budget (WBS-Based)

11/30

You are a project manager who builds work-breakdown-structure cost budgets. <context> I need a project budget organized by work breakdown structure with a contingency reserve, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Project name and objective: [DESCRIBE] - Major phases/workstreams: [LIST] - Cost drivers per phase (labor hours + rate, materials, vendors, tools): [DETAIL] - Contingency rate: [PERCENT] - Total approved budget: [AMOUNT] </inputs> <task> Build a table with columns: WBS Code, Phase / Task, Labor Cost (hours * rate), Materials, Vendor/Other, Task Total, and % of Project. Group tasks under each phase with subtotals, then add Direct Cost Total, a Contingency line (direct * rate), and Total Budget. Compare Total Budget to my approved amount and flag any gap. </task> <constraints> - Labor cost = hours * blended rate; Contingency = direct total * rate; % of Project = task / total; show all three formulas. - WBS codes must be hierarchical (1, 1.1, 1.2, 2...). - Every task total must roll up correctly to phase and project totals. </constraints> <format> Return the WBS budget table (spreadsheet-ready), then a short note on the highest-cost phase and where scope risk sits. </format>

Generates a WBS-based project cost budget with labor, materials, contingency, and rolled-up totals, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to add a 'confidence' column per line so you know which estimates are firm bids vs rough guesses to pad.

Home Renovation / Construction Budget

12/30

You are a construction cost estimator who builds renovation budgets homeowners can hold contractors to. <context> I want a detailed renovation budget broken down by trade and phase with a contingency, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Project scope and square footage: [DESCRIBE] - Rooms/areas involved: [LIST] - Known costs or quotes so far: [ITEMS + AMOUNTS] - Materials I will pick vs contractor-supplied: [DETAIL] - Total budget ceiling: [AMOUNT] - Contingency rate: [PERCENT] </inputs> <task> Build a table with columns: Category (Demolition, Structural, Electrical, Plumbing, Materials, Finishes, Labor, Permits, etc.), Line Item, Estimated Cost, % of Total, and Status (Quoted / Estimated). Subtotal by category, add a Hard Cost Total, a Contingency line, and Grand Total. Compare Grand Total to my ceiling and show remaining headroom. </task> <constraints> - Contingency = hard cost total * rate; % of Total = line / grand total; show formulas. - Separate quoted (firm) from estimated (soft) costs in the Status column. - Grand Total must not silently exceed my ceiling without a flag. </constraints> <format> Return the renovation budget table (spreadsheet-ready), then a 3-line note on where overruns usually hide and what to lock in first. </format>

Builds a trade-by-trade renovation budget with quoted-vs-estimated status, contingency, and a ceiling check, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude which quotes are firm; it separates locked costs from soft estimates so you know your real exposure to overruns.

Freelance Client Project Budget & Quote

13/30

You are a freelance operations consultant who turns project scope into a priced budget and client-ready quote. <context> I need a project budget for a client engagement that doubles as a quote, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Client and project scope: [DESCRIBE] - Deliverables and estimated hours each: [LIST] - My hourly or day rate: [AMOUNT] - Pass-through costs (software, stock, subcontractors): [ITEMS + AMOUNTS] - Desired profit margin or buffer: [PERCENT] - Payment schedule preference: [DEPOSIT %, MILESTONES] </inputs> <task> Build two tables. Table 1: deliverables with Hours, Rate, Line Cost (hours * rate), and pass-through costs, subtotaled to a project subtotal, plus a buffer line and a Total Quote. Table 2: a payment schedule (deposit, milestone payments, final) with Amount and % of total that sums exactly to the quote. Include an internal cost-vs-price note so I see my effective margin. </task> <constraints> - Line cost = hours * rate; buffer = subtotal * margin; payment rows must sum to the total quote; show formulas. - Keep pass-through costs separate from labor so the client sees the breakdown. - Round the client-facing total to a clean number and note the rounding. </constraints> <format> Return both tables (spreadsheet-ready), then a 2-line note on how to present the buffer without itemizing it to the client. </format>

Creates a freelance project budget and client quote with priced deliverables and a balanced payment schedule, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to show your effective hourly rate after the buffer so you can check the project is actually worth taking.

Grant / Nonprofit Program Budget

14/30

You are a nonprofit grants manager who builds funder-ready program budgets. <context> I need a program budget for a grant application with direct and indirect costs, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Program name and duration: [DESCRIBE + MONTHS] - Personnel (role, % time on program, annual salary): [LIST] - Non-personnel costs (supplies, travel, equipment, contracts): [ITEMS + AMOUNTS] - Indirect / overhead rate allowed: [PERCENT] - Total grant request: [AMOUNT] - Any matching funds: [AMOUNT] </inputs> <task> Build a table structured as Personnel (salary * % effort), Fringe, Non-Personnel line items grouped by type, Total Direct Costs, Indirect Costs (direct * rate), and Total Program Cost. Add columns for Grant Request, Matching Funds, and Total, and a justification note per major line. Show that Grant Request plus Match equals Total Program Cost. </task> <constraints> - Personnel cost = salary * % effort; Indirect = total direct * indirect rate; show formulas. - Grant Request + Match must equal Total Program Cost exactly; flag any mismatch. - Include a one-line justification for each personnel and major cost line (funders require it). </constraints> <format> Return the program budget table (spreadsheet-ready), then a short note on which lines funders scrutinize most. </format>

Builds a funder-ready nonprofit program budget with effort-based personnel, indirect costs, and match reconciliation, ready to use.

๐Ÿ’ก

Pro tip: Give Claude the funder's exact indirect-cost cap; many grants disallow or limit overhead and the budget must respect it.

Product / Software Development Budget

15/30

You are a product development lead who budgets software builds by phase and role. <context> I need a development budget for building a product, broken down by phase and resource, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Product and scope: [DESCRIBE] - Phases (discovery, design, build, QA, launch): [LIST] - Team roles, rate, and estimated weeks each: [LIST] - Tooling, infrastructure, and third-party costs: [ITEMS + AMOUNTS] - Contingency rate: [PERCENT] - Budget cap: [AMOUNT] </inputs> <task> Build a table with columns: Phase, Role/Item, Weeks, Weekly Cost, Line Cost (weeks * weekly cost), and % of Total. Group by phase with subtotals, add recurring tooling/infra as its own group, then Direct Total, Contingency line, and Total Build Cost. Compare to the cap and show remaining headroom. </task> <constraints> - Line cost = weeks * weekly cost; Contingency = direct total * rate; % of Total = line / total; show all formulas. - Separate one-time build costs from recurring monthly infra costs. - Total must not exceed the cap without an explicit flag and a suggested cut. </constraints> <format> Return the development budget table (spreadsheet-ready), then a 3-line note on the phase most likely to overrun and why. </format>

Generates a phased software development budget by role and week with tooling, contingency, and a cap check, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to split one-time build costs from recurring infra so you can see your ongoing monthly run-rate after launch.

Marketing Budgets

5 prompts

Annual Marketing Budget by Channel

16/30

You are a marketing operations lead who allocates annual marketing budgets across channels. <context> I want an annual marketing budget allocated by channel and spread across quarters, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Total annual marketing budget: [AMOUNT] - Channels in play (SEO, paid search, paid social, content, email, events, PR, tools): [LIST] - Priority channels this year: [LIST] - Rough historical performance per channel: [NOTES] - Primary goal: [LEADS / REVENUE / AWARENESS] </inputs> <task> Build a table with columns: Channel, Q1, Q2, Q3, Q4, Annual Total, and % of Budget. Allocate spend by quarter with more weight to priority channels, add a subtotal row per quarter and a grand total that equals my annual budget exactly. Include a small reserve/test line. Add a Notes column stating the rationale for each channel's share. </task> <constraints> - Annual Total = SUM of quarters; % of Budget = channel annual / grand total; show formulas. - Grand total must reconcile to my annual budget to the dollar; flag if off. - Keep a test/reserve line of at least a few percent for new bets. </constraints> <format> Return the channel budget table (spreadsheet-ready), then a 3-line note on the biggest bet and what to cut first if budget is trimmed. </format>

Builds an annual marketing budget allocated by channel and quarter with percent-of-budget and a test reserve, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude your rough cost-per-lead by channel and it will weight allocation toward the channels that actually convert.

Paid Ads Campaign Budget & ROAS Forecast

17/30

You are a performance-marketing analyst who forecasts paid ad budgets and returns. <context> I want a paid ads budget with a funnel forecast so I can see expected leads, sales, and ROAS before I spend, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Total ad budget and time period: [AMOUNT + WEEKS/MONTHS] - Platforms and planned split: [E.G. GOOGLE, META, LINKEDIN] - Benchmark CPC or CPM: [FIGURES] - Expected CTR, landing-page conversion rate, close rate: [PERCENTS] - Average order value or deal size: [AMOUNT] </inputs> <task> Build a table with columns per platform: Budget, CPC/CPM, Clicks or Impressions, Conversions (clicks * CVR), Customers (conversions * close rate), Revenue (customers * AOV), and ROAS (revenue / budget). Add a totals row across platforms and a blended ROAS. Include a break-even CPA row (AOV * margin) so I know my max allowable cost per customer. </task> <constraints> - Clicks = budget / CPC; Conversions = clicks * CVR; Revenue = customers * AOV; ROAS = revenue / spend; show every formula. - Flag any platform whose forecast ROAS is below 1. - Keep benchmark inputs visible so I can adjust and see the model recompute. </constraints> <format> Return the forecast table (spreadsheet-ready), then a 3-line note on which platform to scale and the CPA ceiling to enforce. </format>

Produces a paid ads budget with a full funnel forecast of clicks, customers, revenue, and ROAS by platform, ready to use.

๐Ÿ’ก

Pro tip: Give Claude conservative conversion rates first; if the model still shows profit, the campaign has real margin for error.

Product Launch Marketing Budget

18/30

You are a launch marketing strategist who budgets go-to-market campaigns by phase. <context> I want a marketing budget for a product launch split across pre-launch, launch week, and post-launch, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Product and launch date: [DESCRIBE + DATE] - Total launch marketing budget: [AMOUNT] - Tactics planned (ads, influencers, PR, content, events, email): [LIST] - Primary launch goal: [SIGNUPS / SALES / PRESS] - Any hard costs already committed: [ITEMS + AMOUNTS] </inputs> <task> Build a table with columns: Tactic, Phase (Pre-Launch / Launch Week / Post-Launch), Budgeted, % of Total, and Expected Outcome. Group rows by phase with subtotals, add a grand total equal to my budget, and a timeline note for when each spend fires relative to launch date. Weight spend toward the phase that best serves my goal. </task> <constraints> - % of Total = tactic / grand total; phase subtotals must sum to the grand total; show formulas. - Grand total must reconcile to my budget exactly; flag any gap. - Tie each tactic to a concrete expected outcome, not a vague benefit. </constraints> <format> Return the launch budget table (spreadsheet-ready), then a 3-line note on the phase that deserves the most spend for my goal. </format>

Builds a phased product launch marketing budget across pre-launch, launch week, and post-launch with outcomes, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude whether your goal is press or sales; it shifts spend toward PR/influencers or performance ads accordingly.

Content Marketing Budget

19/30

You are a content marketing director who budgets content production and distribution. <context> I want a content marketing budget covering production and distribution across a quarter, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Content types and monthly volume (blog, video, podcast, design): [LIST] - Cost per piece or per hour (writers, editors, video, design): [FIGURES] - Distribution and tooling costs (SEO tools, promotion, syndication): [ITEMS + AMOUNTS] - Total quarterly content budget: [AMOUNT] - Primary goal: [ORGANIC TRAFFIC / LEADS / BRAND] </inputs> <task> Build a table with columns: Content Type, Monthly Volume, Cost per Piece, Monthly Cost (volume * cost), Quarterly Cost, and % of Budget. Add a Production subtotal, a Distribution & Tools group with its own lines and subtotal, and a grand total equal to my budget. Include a cost-per-piece efficiency note. </task> <constraints> - Monthly Cost = volume * cost per piece; Quarterly = monthly * 3; % of Budget = line / grand total; show formulas. - Separate production spend from distribution/tooling spend clearly. - Grand total must reconcile to my budget; flag any overage. </constraints> <format> Return the content budget table (spreadsheet-ready), then a 3-line note on the highest-leverage content type for my goal. </format>

Generates a quarterly content marketing budget separating production from distribution with cost-per-piece math, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to add an estimated output-per-dollar column so you can compare which content format gives the most reach per euro.

Funnel-Stage Budget (CAC & LTV)

20/30

You are a growth analyst who allocates marketing budget across funnel stages using unit economics. <context> I want a marketing budget allocated across funnel stages (awareness, consideration, conversion, retention) anchored to CAC and LTV, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Total marketing budget for the period: [AMOUNT] - Current CAC and LTV: [FIGURES] - Target CAC:LTV ratio: [E.G. 1:3] - Tactics mapped to each funnel stage: [LIST] - New-customer target for the period: [NUMBER] </inputs> <task> Build two tables. Table 1: budget by funnel stage with Stage, Tactics, Budgeted, % of Total, and Purpose. Table 2: a unit-economics check with CAC, LTV, LTV:CAC ratio, implied customers from budget (budget / CAC), and whether that hits my new-customer target. Recommend a reallocation if the ratio is unhealthy or the target is missed. </task> <constraints> - Implied customers = conversion-stage budget / CAC; LTV:CAC = LTV / CAC; show formulas. - Stage budgets must sum to the total; % of Total = stage / total. - Flag if LTV:CAC is below the healthy 3:1 benchmark and suggest the fix. </constraints> <format> Return both tables (spreadsheet-ready), then a 3-line note on whether to spend more on acquisition or retention given my ratio. </format>

Builds a funnel-stage marketing budget tied to CAC and LTV with a unit-economics health check, ready to use.

๐Ÿ’ก

Pro tip: Give Claude your real LTV and CAC; if the ratio is under 3:1 it will push budget toward retention before more acquisition.

Event Budgets

5 prompts

Wedding Budget

21/30

You are a wedding planner who builds itemized budgets couples can actually stick to. <context> I want a complete wedding budget allocated across all categories with tracking columns, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Total budget: [AMOUNT] - Guest count: [NUMBER] - Location and season: [DESCRIBE] - Must-have priorities: [E.G. PHOTOGRAPHY, VENUE, FOOD] - Categories to include: [VENUE, CATERING, ATTIRE, FLOWERS, MUSIC, PHOTO, ETC] </inputs> <task> Build a table with columns: Category, Line Item, Budgeted, % of Total, Estimated, Actual, and Difference. Allocate the total across categories using realistic industry percentages, weighting my priorities higher. Add per-category subtotals, a grand total equal to my budget, a per-guest cost row (total / guests), and a suggested 5% buffer line. </task> <constraints> - % of Total = category / grand total; Per guest = total / guest count; Difference = Actual - Estimated; show formulas. - Grand total (including buffer) must not exceed my budget; flag if it does. - Keep Estimated and Actual columns blank-ready so I can track as I book. </constraints> <format> Return the wedding budget table (spreadsheet-ready), then a 3-line note on where couples overspend and what to book first. </format>

Builds an itemized wedding budget with priority-weighted allocation, per-guest cost, and estimate-vs-actual tracking, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude your top two non-negotiables; it protects their budget share and trims the categories you care about less.

Corporate Conference Budget

22/30

You are a corporate events manager who budgets multi-track conferences. <context> I want a full conference budget covering venue, production, catering, speakers, and marketing, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Event name, dates, and expected attendees: [DESCRIBE] - Venue and AV/production requirements: [DETAIL] - Catering plan (meals, breaks): [DETAIL] - Speaker fees and travel: [DETAIL] - Marketing and staffing needs: [DETAIL] - Total budget or target cost-per-attendee: [AMOUNT] </inputs> <task> Build a table with columns: Category, Line Item, Unit Cost, Quantity, Line Total (unit * qty), and % of Total. Group by Venue, Production/AV, Catering, Speakers, Marketing, Staffing, and Contingency, each with subtotals. Add a grand total, a cost-per-attendee row, and a contingency line. Compare to my budget or target per-attendee cost. </task> <constraints> - Line Total = unit cost * quantity; Cost per attendee = grand total / attendees; Contingency = subtotal * rate; show formulas. - Catering and other per-head items must scale with attendee count. - Grand total must reconcile to my budget or flag the overage. </constraints> <format> Return the conference budget table (spreadsheet-ready), then a 3-line note on the categories most exposed to attendee-count changes. </format>

Generates a corporate conference budget with unit-times-quantity line items, contingency, and cost-per-attendee, ready to use.

๐Ÿ’ก

Pro tip: Give Claude a low and high attendee estimate; per-head catering and swag swing the total fast, so budget for the range.

Fundraising Gala Budget (Costs & Revenue)

23/30

You are a nonprofit development director who budgets fundraising events for net proceeds. <context> I want a gala budget that models both expenses AND revenue so I can see projected net funds raised, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Event and expected attendees: [DESCRIBE] - Ticket price and expected tickets sold: [AMOUNT + NUMBER] - Sponsorship tiers and expected sponsors: [DETAIL] - Additional revenue (auction, raffle, donations): [ESTIMATES] - Expense categories (venue, catering, entertainment, printing, staffing): [DETAIL] </inputs> <task> Build two tables. Table 1 (Revenue): each source with Unit, Quantity, and Total, summed to Gross Revenue. Table 2 (Expenses): line items grouped by category with subtotals and Total Expenses. Add a summary block: Gross Revenue - Total Expenses = Net Proceeds, plus a cost-to-raise-a-dollar ratio (expenses / revenue) and a net-margin percentage. </task> <constraints> - Net Proceeds = Gross Revenue - Total Expenses; Cost ratio = expenses / revenue; show both formulas. - Revenue quantities (tickets, sponsors) must be realistic vs attendee count. - Flag if the cost-to-raise ratio exceeds a healthy threshold (about 0.5). </constraints> <format> Return both tables plus the summary (spreadsheet-ready), then a 3-line note on the highest-margin revenue source to grow. </format>

Builds a fundraising gala budget modeling revenue and expenses to project net proceeds and cost-to-raise ratio, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to add a break-even ticket-count row so you know the minimum turnout before the event loses money.

Party / Celebration Budget

24/30

You are an event host and planner who builds tidy party budgets for private celebrations. <context> I want a budget for a private party or celebration with per-guest costs, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Occasion and guest count: [DESCRIBE + NUMBER] - Total budget: [AMOUNT] - Categories (venue, food, drinks, decor, entertainment, cake, favors): [LIST] - DIY vs paid choices: [DETAIL] - Must-haves: [LIST] </inputs> <task> Build a table with columns: Category, Line Item, Budgeted, % of Total, and Per-Guest Cost. Allocate the total across categories, weighting must-haves. Add category subtotals, a grand total equal to my budget, a total per-guest cost row, and a small buffer line. Mark DIY items so I can see savings vs paid options. </task> <constraints> - % of Total = category / grand total; Per-Guest = line / guest count; show formulas. - Grand total (with buffer) must stay within my budget; flag if not. - Scale food and drink lines with the guest count. </constraints> <format> Return the party budget table (spreadsheet-ready), then a 2-line note on the easiest category to trim without guests noticing. </format>

Creates a private-party budget with category allocation, per-guest cost, and DIY-vs-paid flags, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude which items you'll DIY; it reallocates the savings to the parts guests actually remember, like food and music.

Multi-Day Festival / Market Budget

25/30

You are a festival producer who budgets multi-day public events with revenue and cost sides. <context> I want a budget for a multi-day festival or market covering setup, operations, and revenue, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Festival concept, days, and expected daily attendance: [DESCRIBE] - Revenue streams (tickets, vendor fees, sponsorships, concessions): [DETAIL] - Cost categories (site, stages/AV, permits/insurance, staff/security, marketing, cleanup): [DETAIL] - Ticket price and vendor fee: [AMOUNTS] - Target net or break-even: [GOAL] </inputs> <task> Build two tables. Table 1 (Revenue): each stream with Unit, Quantity, and Total, summed to Gross Revenue. Table 2 (Costs): line items grouped by category with subtotals, a Total Cost, and a contingency line. Add a summary: Gross Revenue - Total Cost = Net, a break-even attendance row, and revenue/cost per attendee. </task> <constraints> - Net = Gross Revenue - Total Cost; Break-even attendance = total fixed cost / per-head contribution; show formulas. - Separate fixed costs (permits, stages) from variable per-attendee costs. - Flag if projected attendance is below break-even. </constraints> <format> Return both tables plus the summary (spreadsheet-ready), then a 3-line note on the biggest financial risk across the days. </format>

Builds a multi-day festival budget with revenue and cost tables, break-even attendance, and per-attendee metrics, ready to use.

๐Ÿ’ก

Pro tip: Give Claude a rainy-day attendance scenario; outdoor events live or die on weather, so budget the downside explicitly.

Most people use 10% of Claude. Tutorials unlock the rest.

AI Academy: 300+ hands-on tutorials on Claude, ChatGPT, Midjourney, and 50+ AI tools. New tutorials added every week.

Start Your Free Trial

Department & Team Budgets

5 prompts

Annual Department Operating Budget

26/30

You are a finance business partner who builds annual department operating budgets. <context> I want an annual operating budget for my department broken into categories and spread by quarter, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Department and headcount: [DESCRIBE] - Prior-year spend by category (payroll, software, travel, training, vendors, other): [FIGURES] - Growth or cut mandate: [PERCENT UP/DOWN] - Known new costs this year: [ITEMS + AMOUNTS] - Total budget target: [AMOUNT] </inputs> <task> Build a table with columns: Category, Q1, Q2, Q3, Q4, Annual Total, Prior Year, and Change (%). Allocate each category by quarter, apply the mandate, add new costs in the right quarter, and subtotal quarters. Add a grand total that meets my target and a variance-to-target row. Include a Notes column justifying major changes. </task> <constraints> - Annual Total = SUM of quarters; Change % = (this year - prior)/prior; show formulas. - Grand total must land on my target; flag and suggest cuts if over. - Keep quarterly phasing realistic (e.g. training front-loaded, travel event-driven). </constraints> <format> Return the department budget table (spreadsheet-ready), then a 3-line note on the categories with the least flexibility if cuts are demanded. </format>

Generates an annual department operating budget by category and quarter with prior-year comparison and target check, ready to use.

๐Ÿ’ก

Pro tip: Give Claude the exact quarter big costs hit; even phasing hides cash-flow spikes that finance will question.

Team Headcount & Compensation Budget

27/30

You are a people-finance analyst who builds team compensation budgets. <context> I want a compensation budget for my team including current staff, planned hires, and raises, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Current team (name/role, base salary): [LIST] - Planned merit-increase pool: [PERCENT] - Planned promotions/adjustments: [DETAIL] - New hires with target salary and start month: [LIST] - Benefits/tax load rate: [PERCENT] - Comp budget cap: [AMOUNT] </inputs> <task> Build a table with columns: Role, Current Base, Increase (%), New Base, Loaded Cost (new base * (1 + load)), Months This Year, and Cost This Year (prorated). Include current staff with raises and new hires prorated from their start month. Add a total-comp row, a merit-pool-used row, and a comparison to the cap with remaining headroom. </task> <constraints> - New Base = current * (1 + increase); Loaded = new base * (1 + load); prorate new hires from start month; show formulas. - Merit increases across the team must not exceed the merit pool; flag if they do. - Total must fit the cap or flag the overage with a suggested trade-off. </constraints> <format> Return the comp budget table (spreadsheet-ready), then a 3-line note on how to fund a key raise if the pool is tight. </format>

Builds a team compensation budget with raises, prorated new hires, benefits load, and a merit-pool and cap check, ready to use.

๐Ÿ’ก

Pro tip: Feed Claude the merit pool as a hard cap; it will distribute raises within it instead of quietly blowing past the number.

Quarterly Budget vs Actual Tracker

28/30

You are an FP&A analyst who builds budget-versus-actual variance reports. <context> I want a quarterly budget-vs-actual tracker for my team so I can explain variances, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Budget categories and quarterly budgeted amounts: [LIST] - Actuals to date per category: [FIGURES] - Any known committed-but-unspent amounts: [DETAIL] - Forecast for the rest of the quarter: [NOTES] </inputs> <task> Build a table with columns: Category, Budget, Actual, Variance (Budget - Actual), Variance %, Committed, Projected Full-Quarter, and Status (Under / On Track / Over). Fill each row from my inputs, add a totals row, and compute a projected end-of-quarter position. Flag every category trending over budget and note the likely cause column. </task> <constraints> - Variance = Budget - Actual; Variance % = variance / budget; Projected = Actual + Committed + remaining forecast; show formulas. - Status must be driven by the projected number, not just actuals to date. - Totals row must reconcile across every column. </constraints> <format> Return the budget-vs-actual table (spreadsheet-ready), then a 3-line variance narrative I can paste into a review deck. </format>

Produces a quarterly budget-vs-actual tracker with variance, committed spend, projections, and status flags, ready to use.

๐Ÿ’ก

Pro tip: Ask Claude to write the variance narrative in finance-review language so you can drop it straight into your QBR slides.

CapEx Budget Request

29/30

You are a finance manager who prepares capital-expenditure requests for approval. <context> I want a CapEx budget request for equipment or assets with a simple payback view, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Assets/equipment requested with unit cost and quantity: [LIST] - Useful life per asset (years): [FIGURES] - Installation/setup and any recurring maintenance: [AMOUNTS] - Expected annual savings or added revenue from the investment: [AMOUNT] - Approval threshold or budget cap: [AMOUNT] </inputs> <task> Build a table with columns: Asset, Unit Cost, Quantity, Total Cost (unit * qty), Useful Life, Annual Depreciation (total / life), and Setup/Other. Add a Total CapEx row. Then add a justification block: total investment, expected annual benefit, simple payback period (investment / annual benefit), and whether it clears the approval threshold. </task> <constraints> - Total Cost = unit * quantity; Annual Depreciation = total / useful life; Payback = investment / annual benefit; show all formulas. - Separate one-time CapEx from recurring maintenance (which is OpEx). - State clearly whether the request is under or over the approval threshold. </constraints> <format> Return the CapEx table and justification (spreadsheet-ready), then a 3-line business case I can send to the approver. </format>

Builds a CapEx budget request with depreciation, setup costs, and a simple payback-period business case, ready to use.

๐Ÿ’ก

Pro tip: Give Claude the expected annual savings; a payback under two years is the fastest way to get a CapEx request approved.

Travel & Expense (T&E) Budget

30/30

You are a finance operations lead who builds travel and expense budgets for teams. <context> I want an annual travel and expense budget for my team by trip type and quarter, returned as a copy-paste table ready for Sheets or Excel. </context> <inputs> - Trip types and expected count per year (client visits, conferences, offsites): [LIST] - Average cost per trip (flights, hotel, meals, ground, registration): [FIGURES] - Per-diem policy: [AMOUNT/DAY] - Team size and travelers: [NUMBER] - Total T&E budget cap: [AMOUNT] </inputs> <task> Build a table with columns: Trip Type, Trips per Year, Avg Cost per Trip, Annual Cost (trips * avg), % of Budget, and Quarterly split. Break avg cost into a small sub-table (airfare, lodging, meals via per-diem, ground, other). Add a grand total that fits the cap, a per-trip and per-traveler cost row, and a reserve line for unplanned travel. </task> <constraints> - Annual Cost = trips * avg cost; Meals = per-diem * days; % of Budget = line / total; show formulas. - Grand total (with reserve) must stay within the cap; flag any overage. - Keep a reserve line for unplanned or emergency travel. </constraints> <format> Return the T&E budget table (spreadsheet-ready), then a 3-line note on the trip type to cut first if the cap tightens. </format>

Generates an annual travel and expense budget by trip type and quarter with per-diem math and a reserve line, ready to use.

๐Ÿ’ก

Pro tip: Tell Claude your per-diem policy; meals and incidentals are where T&E budgets quietly overrun without a hard daily cap.

Frequently Asked Questions

Yes. Each prompt tells Claude to return a finished budget as a structured table with itemized categories, subtotals, a grand total, and the actual spreadsheet formulas (percent of income, variance, running balance). You copy the table straight into Google Sheets or Excel and it works, no manual setup needed.
Claude returns the budget as a Markdown table, which pastes cleanly into a spreadsheet as rows and columns. The prompts also ask Claude to show one example formula per calculated column (like =B2/$B$1), so you can drag it down to extend rows or add categories without redoing the math.
Fill in the bracketed placeholders: your income or total budget, the line items and amounts you already know, any rates (tax, contingency, benefits load), and your target or cap. The more real numbers you provide, the more accurate the budget. If you leave a field vague, Claude uses a realistic estimate and flags it.
Yes. The page covers six budget types: personal and household, small business, projects, marketing, events, and department or team. Each category uses the format that fits it, from a 50/30/20 household split to a P&L-style operating budget or a break-even model with unit economics.
Yes. Several prompts, like the budget-vs-actual tracker, include Estimated, Actual, Variance, and Status columns so you can track performance over time. Give Claude your actual figures and it computes the variance, flags every category trending over budget, and can write a short variance narrative for a review.

Prompts are the starting line. Tutorials are the finish.

A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.

7-day free trial. Cancel anytime.