Help me design a personal budget in Google Sheets. I need a usable system for tracking actual cash flow, not a generic spreadsheet mockup. Do not invent amounts, categories, or financial advice beyond the facts I provide. My inputs - Budget period and currency: [BUDGET PERIOD AND CURRENCY] - Net income and pay timing: [INCOME] - Fixed recurring expenses: [FIXED EXPENSES] - Variable spending categories and recent amounts: [VARIABLE SPENDING] - Savings, debt, and financial goals: [GOALS AND DEBT]
- Current setup and preference: [SHEET SETUP]
Recommend a structure with separate tabs only where they reduce work: a monthly dashboard, transaction log, and optional recurring-bills list. Use categories that distinguish needs, discretionary spending, savings, and debt payments without creating too many lines to maintain. Explain whether planned versus actual should be tracked by monthly category totals or by transactions based on my inputs.
Output exactly:
1. A tab-by-tab layout with column headers and the purpose of every column.
2. A category table with planned amounts, using my stated amounts only.
3. Google Sheets formulas written exactly as I should paste them, including formulas for monthly actuals, planned-versus-actual variance, remaining-to-spend, and savings/debt progress. State the assumed cell ranges.
4. Setup steps in order and a short monthly close routine.
Use SUMIFS for category and month rollups when a transaction log is appropriate, and show how dates should be entered. Before answering, check that formula references match the proposed headers and that income, expenses, savings, and debt are not double-counted. Flag any goal that cannot be evaluated without a missing amount or interest rate. Ask up to 3 clarifying questions only if a required input is missing.Fill in
| Placeholder | What to enter | Example |
|---|---|---|
| [BUDGET PERIOD AND CURRENCY] | Enter the month or cadence you budget for and the currency you use. | Monthly budget, October 2026, USD. |
| [INCOME] | List reliable after-tax income sources, amounts, and the dates or frequency they arrive. | Salary: $4,800 net on the 15th and 30th. Freelance editing: about $350 net near month-end, not guaranteed. |
| [FIXED EXPENSES] | List recurring bills with their amounts and due dates. | Rent $1,650 due 1st; utilities $145; phone $55; transit pass $132; insurance $118; subscriptions $42. |
| [VARIABLE SPENDING] | List flexible categories and typical or recent spending amounts. | Groceries $510 last month; dining $235; gas $85; household $70; entertainment $95; clothing $60. |
| [GOALS AND DEBT] | State savings targets, debt balances, required payments, and any relevant rates you know. | Build $3,000 emergency fund; current balance $1,250. Credit card balance $1,900 at 22.9% APR; minimum payment $65. |
| [SHEET SETUP] | Say whether you have an existing sheet, want manual entry or imports, and your desired level of detail. | Starting from blank Google Sheet. I will enter transactions manually twice a week and want a simple monthly dashboard. |
How to use
- Paste actual after-tax income and recent spending, separating fixed bills from flexible spending.
- If you have an existing sheet, include its tab names and headers so formulas can match it.
- Paste formulas into a copy of the sheet first and confirm one transaction rolls up to the correct category and month.
- Follow up with: “My Transaction Log uses date in A, category in C, and amount in E; rewrite the formulas for those columns.”
Variations
Zero-based budget
Use when you want every dollar of predictable income assigned before the month begins.
Create a zero-based monthly budget for Google Sheets from the facts below. Assign each dollar of reliable net income to essential bills, true expenses, debt, savings, and discretionary categories, but keep irregular income unassigned until received. Output a category plan that totals exactly to reliable income, a Sheets layout, and paste-ready formulas for planned, actual, and remaining amounts. Identify any funding gap without assuming new income or debt. Inputs: [MONTH AND CURRENCY], [RELIABLE INCOME], [RECURRING BILLS], [TRUE EXPENSES], [DEBT AND SAVINGS TARGETS].
Couples budget
Use when two people share costs but need transparent individual and joint tracking.
Design a Google Sheets budget for two adults who share some costs. Separate personal spending from joint household expenses, show each person’s income and agreed contribution method, and avoid treating transfers between partners as new income or expenses. Provide tabs, headers, formulas for each person’s contribution and joint-category actuals, plus a monthly reconciliation checklist. Explain assumptions plainly and flag decisions the couple must make, such as split method or savings ownership. Inputs: [INCOMES], [SHARED EXPENSES], [PERSONAL EXPENSES], [SPLIT METHOD], [GOALS AND CURRENT SHEET].
Debt payoff tracker
Use when the main financial job is tracking balances and a chosen repayment plan.
Build a Google Sheets debt payoff tracker using my real accounts and payment amounts. Compare avalanche and snowball ordering using only my balances, APRs, minimums, and extra-payment amount; do not promise a payoff date if inputs are incomplete. Output a debt table, a recommended order with rationale, and paste-ready formulas for monthly interest estimate, payment allocation, projected remaining balance, and payoff progress. Include a warning that this is an organizational tool, not individualized financial advice. Inputs: [DEBT ACCOUNTS], [MONTHLY PAYMENT BUDGET], [PAYMENT DATES], [SAVINGS BUFFER], [PREFERRED METHOD].
Tips
- Keep a transaction log even if you also set monthly category budgets; the log gives formulas an auditable source of actual spending.
- Use after-tax income for spending plans and record irregular income separately until it arrives, rather than treating an estimate as available cash.
- Record credit-card purchases as expenses and the card payment as a transfer or liability payment according to your setup, so the same purchase is not counted twice.
- A category system with 10–20 active categories is easier to maintain than one that isolates every merchant or purchase type.
FAQ
What Google Sheets formula should I use to total spending by category?
SUMIFS is usually the right choice when your transaction log has a date, category, and amount column. Add a date criterion to make the result monthly.
Should I budget from gross or net income?
For a personal spending budget, use income that actually reaches your account after taxes and payroll deductions.
Can AI connect directly to my bank account in Google Sheets?
This prompt is for designing a sheet and formulas. Use a provider you trust for imports, and avoid pasting account numbers or credentials into an AI chat.