📘
Cashflow Budget Workbook — User Manual
Instruction Manual · How to use this template
The Cashflow Budget Workbook is a premium Google Sheets template that gives you a complete personal-finance command center. Enter each transaction once on the Transactions sheet, set up your recurring bills and subscriptions on the Recurring sheet, and the Budget sheet instantly shows your 50/30/20 breakdown, savings-goal progress, bill calendar, and a full dashboard of charts and KPIs — no formulas to touch, ever. It is designed for individuals, couples, or households who want a single place to see exactly where their money comes from, where it goes, and whether they are on track each month.
⚡ Quick start
1Step 1: Open the workbook and read the 'Read Me' sheet for a quick orientation on the color-coding and layout conventions used throughout.
2Step 2: Go to the Recurring sheet and enter every bill, subscription, and regular income source — rent, salary, streaming services, insurance, loan payments — with their frequency and amounts.
3Step 3: Switch to the Transactions sheet and begin logging each real transaction as it happens: date, type (Income or Expense), category, amount, a short note, and the payment method you used.
4Step 4: Open the Budget sheet and fill in your planned budget amount for each spending category (e.g., Groceries $400, Rent $1,200). The sheet will automatically pull your actual spending from Transactions and compare it to your plan.
5Step 5: Review the Budget dashboard KPIs and charts — check your Net Cash Flow, Cash Flow Rate, and the Budget vs Spent bars to see where you stand.
6Step 6: Revisit weekly: add new transactions, review the Running Balance chart for trends, and adjust budget targets as needed.
The Budget sheet is your financial dashboard and planning headquarters. It pulls actual income and spending from Transactions via SUMIFS formulas, compares them against your planned budget, tracks recurring bills at their monthly cost, monitors sinking-fund savings goals, and displays seven charts plus six KPI cards so you can see your entire financial picture without leaving this tab.
✍️ Step by step
11. In the Category column (budget section), list every spending category you want to track — e.g., Rent, Groceries, Dining Out, Transportation, Entertainment, Savings, Insurance. These must match the categories you use on the Transactions sheet exactly (spelling and capitalization matter).
22. In the Budget column next to each category, type your planned monthly spending limit as a plain number (e.g., 400 for $400). This is the only number you set manually per category.
33. The ƒSpent column automatically totals every transaction in that category from the Transactions sheet using SUMIFS, so you never calculate it yourself.
44. The ƒLeft column shows Budget minus Spent — a positive number means you are under budget; a negative number (often shown in red) means you have overspent.
55. In the recurring-bills section, enter each Bill name, its Amount, and its Frequency (Weekly, Biweekly, Monthly, Quarterly, Semi-Annual, Annual). The ƒMonthly column converts every frequency to a monthly equivalent so you can see true monthly obligations.
66. For sinking funds, fill in the Group name (e.g., Emergency Fund, Vacation, Car Repair) — the ƒActual, ƒTarget, and ƒUsed columns track how much you have saved, your goal, and the percentage used.
77. Review the KPI cards at the top: TOTAL INCOME, TOTAL EXPENSES, NET CASH FLOW, CASH FLOW RATE, Planned, and Actual — these update in real time as you add transactions.
88. Scroll to the chart area to see Income by Source, Expenses by Category, Budget vs Spent, Cash Flow by Method, Recurring Bills (monthly), Running Balance (12-month), and Sinking Funds — Saved vs Target.
99. Do not type in any column marked with ƒ — these are formula-driven and will break if overwritten.
📋 Column-by-column
| ƒSource | Auto-computed. Pulls each distinct income source from your Transactions sheet (e.g., Salary, Freelance, Dividends). You do not type here; it mirrors the categories you tag as Income on the Transactions sheet. |
| ƒPlanned | Auto-computed. Shows the planned (budgeted) income amount for each source. This value is derived from your Budget entries or recurring income setup. It tells you how much you expected to earn from each source this month. |
| ƒActual | Auto-computed. The actual income received from each source, summed from the Transactions sheet via SUMIFS. Compare this to ƒPlanned to see whether your income is on track. If Actual exceeds Planned, you earned more than expected — a positive sign. |
| ƒDiff | Auto-computed. Difference = Actual − Planned. A positive value means you received more than planned from that income source; a negative value means you fell short. Ideally this is zero or positive for every source. |
| Category | INPUT. Type the name of each spending or savings category you want to budget for. Examples: Rent, Groceries, Utilities, Dining Out, Transportation, Subscriptions, Clothing, Emergency Fund. Use the exact same spelling and case here as you do on the Transactions sheet, because formulas match on this text. |
| Budget | INPUT. Enter your planned monthly spending limit for this category as a number, no currency symbol needed (the sheet formats it). Example: 500 for a $500 grocery budget. Set realistic targets based on past spending; you can adjust these each month. |
| ƒSpent | Auto-computed. The total amount actually spent in this category during the current period, pulled from the Transactions sheet using SUMIFS. If this number is climbing close to your Budget value, you know to slow down spending. A value higher than Budget means you have overspent. |
| ƒLeft | Auto-computed. Remaining budget = Budget − Spent. A positive number (e.g., $120) means you still have room to spend in this category. Zero means you have hit your limit exactly. A negative number (e.g., −$45) means you are over budget by that amount — look for the red highlight as a visual warning. |
| Method | INPUT (in the cash-flow-by-method section). Enter the name of each payment method you use — e.g., Chase Checking, Amex Credit, Venmo, Cash, PayPal. This lets the Budget sheet break down cash flow by account or payment channel. |
| ƒIn | Auto-computed. Total money coming in through this payment method, summed from income transactions that used this method. For example, if your paycheck is deposited into Chase Checking, that amount appears here. |
| ƒOut | Auto-computed. Total money going out through this payment method, summed from expense transactions. A high value on a credit card method may signal heavy credit usage. |
| ƒNet | Auto-computed. Net cash flow per method = In − Out. A positive net means more money flowed in than out through this method (typical for a checking account receiving salary). A negative net is normal for a credit card used only for purchases. Review this to ensure no single method is draining funds unexpectedly. |
| Bill | INPUT. The name of a recurring bill or obligation — e.g., Rent, Netflix, Car Insurance, Gym Membership, Student Loan. List every predictable expense here so the workbook can calculate your total fixed costs. |
| Amount | INPUT. The amount you pay each time this bill is due, entered as a plain number. Example: 14.99 for a streaming subscription, 1200 for monthly rent. Use the amount per occurrence, not the annual total — the ƒMonthly column handles the conversion. |
| Frequency | INPUT. How often this bill recurs. Use one of the supported keywords: Weekly, Biweekly, Monthly, Quarterly, Semi-Annual, or Annual. The ƒMonthly column uses this to normalize every bill to a monthly cost so you can see your true monthly overhead. |
| ƒMonthly | Auto-computed. The monthly-equivalent cost of each recurring bill. Formula in words: if Frequency is Weekly, Monthly = Amount × 52 ÷ 12; if Biweekly, Amount × 26 ÷ 12; if Monthly, Amount; if Quarterly, Amount ÷ 3; if Semi-Annual, Amount ÷ 6; if Annual, Amount ÷ 12. This lets you compare all bills on the same monthly basis. A healthy total monthly bills figure is typically under 50% of your take-home income. |
| Category (spending share section) | Auto-computed. Mirrors your spending categories to show their share of total expenses in this analysis section. Do not edit. |
| ƒSpent (spending share section) | Auto-computed. Same spent total as above, repeated here for the share calculation. Shows how much you actually spent in each category. |
| ƒShare | Auto-computed. The percentage of total expenses that this category represents. Formula: Category Spent ÷ Total Expenses × 100. For example, if you spent $600 on groceries out of $3,000 total, ƒShare = 20%. Use this to see if any single category is consuming a disproportionate share of your budget — the 50/30/20 rule suggests needs ≤ 50%, wants ≤ 30%, savings ≥ 20%. |
| ƒvs Budget | Auto-computed. A comparison metric showing how your actual spending compares to your budgeted amount, typically expressed as a percentage or difference. A value at or below 100% (or zero difference) means you are within budget; above 100% or a positive difference means overspending. This is your at-a-glance budget adherence score per category. |
| Group | INPUT (sinking funds section). The name of each savings goal or sinking fund — e.g., Emergency Fund, Vacation 2026, New Laptop, Car Repair, Holiday Gifts. Each group tracks progress toward a specific target amount. |
| ƒActual (sinking funds) | Auto-computed. The amount you have actually saved toward this sinking fund goal so far, pulled from your transactions or designated savings entries. Watch this grow over time as you make contributions. |
| ƒTarget | Auto-computed or referenced. The target amount for this sinking fund goal. This may be pulled from a target you set elsewhere or within this section. For example, an Emergency Fund target of $10,000 or a Vacation target of $2,500. |
| ƒUsed | Auto-computed. The percentage of the target that has been reached. Formula: Actual ÷ Target × 100. A value of 75% means you are three-quarters of the way to your goal. At 100% the fund is fully funded. Values over 100% mean you have exceeded your target — consider reallocating the surplus. |
📊 Reading the numbers
• TOTAL INCOME KPI: The sum of all income transactions for the period. A healthy value depends on your situation, but it should be stable or growing month over month.
• TOTAL EXPENSES KPI: The sum of all expense transactions. Compare this directly to Total Income — if expenses exceed income, you are spending more than you earn.
• NET CASH FLOW KPI: Total Income minus Total Expenses. Positive means you saved money this period; negative means you dipped into savings or went into debt. Aim for a consistently positive value — even $50 positive is better than $0.
• CASH FLOW RATE KPI: Net Cash Flow divided by Total Income, expressed as a percentage. It tells you what fraction of your income you kept. A rate above 20% is excellent; 10–20% is solid; below 0% means you are losing money. This is essentially your savings rate.
• The Planned vs Actual KPIs let you compare your total budgeted spending plan against what actually happened — a large gap means your budget needs recalibration.
• Income by Source chart: Shows which income streams contribute most. Diversified sources reduce risk.
• Expenses by Category chart: Highlights your biggest spending areas. If one bar dominates, investigate whether that category can be trimmed.
• Budget vs Spent chart: Side-by-side bars per category — when the Spent bar exceeds the Budget bar, you have overspent. Green/under and red/over coloring makes this instant to read.
• Cash Flow by Method chart: See which accounts or payment methods carry the most activity. Useful for spotting an over-relied-upon credit card.
• Recurring Bills (monthly) chart: Visualizes your fixed monthly obligations. If this total approaches 50% of income, you have limited flexibility for variable spending.
• Running Balance (12-month) chart: A line chart showing your cumulative net position over the past 12 months. An upward trend means you are building wealth; a downward trend signals cash burn.
• Sinking Funds — Saved vs Target chart: Progress bars for each savings goal. Fully filled bars mean the goal is met.
⚠️ Avoid these mistakes
• Typing a category name on the Budget sheet that does not exactly match the Transactions sheet (e.g., 'Dining out' vs 'Dining Out') — SUMIFS will return zero because the match is case-and-space sensitive.
• Manually typing numbers into any ƒ column — this overwrites the formula and the cell will stop updating. If you accidentally do this, use Ctrl+Z (Cmd+Z on Mac) immediately to undo.
• Forgetting to enter a Frequency for a recurring bill — the ƒMonthly calculation will error or return zero, making your fixed-cost total inaccurate.
• Setting budget amounts that are wildly unrealistic (e.g., $50 for groceries for a family of four) — the Budget vs Spent chart will always show red, which desensitizes you to real overspending.
💡 Tips• Use the ƒShare column to run a quick 50/30/20 check: sum the shares of all Needs categories (should be ≤ 50%), all Wants (≤ 30%), and all Savings/Debt (≥ 20%).
• Review the Running Balance chart at the end of each month — it is the single best indicator of whether your financial trajectory is healthy.
• If a sinking fund's ƒUsed hits 100%, consider redirecting those contributions to a new goal or increasing your emergency fund target.
• Sort your recurring bills by ƒMonthly descending to quickly spot your most expensive obligations and evaluate whether any can be reduced or cancelled.
The Transactions sheet is your financial ledger — the single place where you log every income receipt and every expense. Each row is one transaction. The formulas on the Budget sheet pull from this data using SUMIFS, so accurate and consistent entries here are the foundation of the entire workbook.
✍️ Step by step
11. For each transaction, start by entering the Date in the first column using the format your spreadsheet locale expects (e.g., 2026-06-15 or 06/15/2026). Be consistent with your date format.
22. The ƒMonth column auto-extracts the month from your date (e.g., 'June 2026'), so you never need to type the month — it is used for monthly roll-ups and charts.
33. In the Type column, enter either 'Income' or 'Expense'. This is critical because the formulas split your totals based on this field.
44. In the Category column, type the category exactly as it appears on the Budget sheet — e.g., Groceries, Rent, Salary, Freelance. Consistency is essential for accurate summaries.
55. In the Amount column, enter the transaction value as a positive number regardless of whether it is income or expense. The Type column tells the workbook which direction the money flows. Example: 85.42 for a grocery trip.
66. In the Note column, add a brief description for your own reference — e.g., 'Costco weekly run', 'June paycheck', 'Uber to airport'. This is optional but very helpful when reviewing past transactions.
77. In the Method column, enter the payment method used — e.g., Chase Checking, Amex Credit, Cash, Venmo. This must match the Method names on the Budget sheet for the Cash Flow by Method chart to work.
88. The ƒIncome, ƒExpenses, and ƒNet columns auto-compute running totals. Do not edit them.
99. Review the KPI cards and Monthly Income vs Expenses chart at the top or side of this sheet periodically to confirm your data entry is tracking correctly.
📋 Column-by-column
| Date | INPUT. The date the transaction occurred. Enter in your locale's date format (e.g., 2026-06-15 or 06/15/2026). Example: 2026-06-01 for a rent payment on June 1st. Always use actual transaction dates, not the date you are entering the data, so monthly roll-ups are accurate. |
| ƒMonth | Auto-computed. Extracts the month and year from the Date column (e.g., 'June 2026' or '2026-06'). This is used by SUMIFS on the Budget sheet and by the Monthly Income vs Expenses chart to group transactions by month. Do not edit. |
| Type | INPUT. Must be either 'Income' or 'Expense' (use these exact words). This field determines whether the amount adds to your income total or your expense total. Getting this wrong will invert your numbers — a common source of errors. |
| Category | INPUT. The spending or income category this transaction belongs to. Must match a category on the Budget sheet exactly. Examples: Salary, Freelance, Groceries, Rent, Utilities, Dining Out, Entertainment. If you create a new category here, add it to the Budget sheet as well or it will not appear in budget comparisons. |
| Amount | INPUT. The transaction amount as a positive number — do not use negative signs. The Type column handles whether it is income or expense. Enter the exact amount in your currency. Example: 1250.00 for a rent payment, 3500 for a paycheck, 12.99 for a subscription. Do not include currency symbols. |
| Note | INPUT. A free-text description for your own reference. Examples: 'Weekly Costco run', 'Client invoice #1042', 'Birthday gift for Mom'. Optional but recommended — it makes reviewing past months much easier. This column is not used in any calculations. |
| Method | INPUT. The payment method or account used. Examples: Chase Checking, Discover Card, Cash, PayPal, Venmo. Must match the Method names on the Budget sheet for the Cash Flow by Method analysis to work. If you use a new payment method, add it to the Budget sheet's Method list. |
| ƒMonth (second instance) | Auto-computed. A secondary month extraction used internally for pivot calculations and chart grouping. May appear as a helper column. Do not edit. |
| ƒIncome | Auto-computed. A running or filtered total of all income transactions. This column isolates income amounts (where Type = Income) so the workbook can sum and chart income separately. A healthy monthly income figure is stable or growing over time. |
| ƒExpenses | Auto-computed. A running or filtered total of all expense transactions (where Type = Expense). Watch for sudden spikes — they may indicate an unusual purchase or a data-entry error (such as entering 5000 instead of 50.00). |
| ƒNet | Auto-computed. Net = Income − Expenses on a cumulative or per-row basis. A positive running net means you are in the black overall; a negative running net means cumulative expenses have exceeded cumulative income. This is the real-time heartbeat of your financial health. |
📊 Reading the numbers
• Amount KPI: The total value of all transactions entered. This is a raw volume figure — useful for seeing overall financial activity but not directional (it does not distinguish income from expenses).
• Income KPI: Total of all rows where Type = Income. Compare month over month to spot income trends or missed deposits.
• Expenses KPI: Total of all rows where Type = Expense. If this exceeds the Income KPI, you are spending more than you earn — take immediate action.
• Net KPI: Income minus Expenses. This is the most important number on this sheet. Positive = you saved money. Negative = you overspent. Aim for positive every single month.
• Monthly Income vs Expenses chart: A grouped bar or line chart showing income and expenses side by side for each month. Months where the expense bar exceeds the income bar are deficit months — look for patterns (e.g., December holiday spending, quarterly insurance payments).
⚠️ Avoid these mistakes
• Entering negative amounts for expenses — the Amount column should always be positive; the Type column handles the direction. A negative expense would be double-inverted and appear as income in calculations.
• Using inconsistent category names (e.g., 'Groceries' in one row and 'groceries' or 'Grocery' in another) — the SUMIFS formulas on the Budget sheet require an exact match, so even small differences cause spending to be missed.
• Forgetting to log cash transactions — they are easy to overlook but can create a gap between your actual spending and what the workbook shows.
• Leaving the Type column blank — the row's amount will not be counted in either Income or Expenses, silently skewing your totals.
💡 Tips• Enter transactions daily or every few days rather than in a big batch at month-end — it is faster, more accurate, and you are less likely to forget purchases.
• Use the Note column to tag irregular expenses (e.g., 'one-time' or 'annual') so you can filter or search for them later.
• Sort or filter by Method to reconcile each bank account or credit card statement against your entries.
• If you receive a refund, log it as an Income transaction with a category like 'Refund' and a note explaining the original purchase — this keeps your expense history accurate.
The Recurring sheet is where you define all predictable, repeating financial flows — both income (salary, rental income, side-hustle retainers) and expenses (rent, subscriptions, loan payments, insurance premiums). By entering each item once with its frequency, the sheet calculates the true monthly cost or income so the Budget sheet can factor in your fixed obligations accurately.
✍️ Step by step
11. In the Type column, enter 'Income' or 'Expense' to classify each recurring item.
22. In the Category column, enter the category this item belongs to — matching the categories on your Budget and Transactions sheets exactly (e.g., Salary, Rent, Subscriptions, Insurance).
33. In the Frequency column, specify how often this recurs: Weekly, Biweekly, Monthly, Quarterly, Semi-Annual, or Annual.
44. In the Amount column, enter the amount per occurrence as a positive number. Example: 1200 for monthly rent, 14.99 for a monthly streaming service, 600 for semi-annual car insurance.
55. In the First Payment column, enter the date of the first (or next upcoming) payment. This helps you and the Budget sheet's bill calendar know when each obligation starts.
66. In the Last Payment column, enter the final payment date if the obligation has a defined end (e.g., a 36-month car loan). Leave blank if it is ongoing (e.g., rent, utilities).
77. In the From Account column, enter the account the money leaves — e.g., Chase Checking, Savings. For income items, this might be your employer or client name.
88. In the To Account column, enter where the money goes — e.g., Landlord, Netflix, Student Loan Servicer. For income items, this is the account receiving the deposit (e.g., Chase Checking).
99. Review the ƒMonthly column and the KPI cards to confirm your total monthly recurring income and expenses look correct. The Recurring by Type chart gives a visual split.
📋 Column-by-column
| Type | INPUT. Either 'Income' or 'Expense'. This classifies the recurring item so the workbook can separate recurring income from recurring costs. Example: 'Income' for your salary, 'Expense' for your rent. |
| Category | INPUT. The category this recurring item falls under, matching your Budget and Transactions category names exactly. Examples: Salary, Rent, Subscriptions, Car Payment, Insurance. Consistency with other sheets is essential for cross-sheet formulas. |
| Frequency | INPUT. How often this payment or income occurs. Accepted values: Weekly, Biweekly, Monthly, Quarterly, Semi-Annual, Annual. This drives the ƒMonthly conversion formula. Example: 'Annual' for a yearly insurance premium of $1,200 will show $100/month. |
| Amount | INPUT. The amount per occurrence, entered as a positive number without currency symbols. Example: 2000 for a biweekly paycheck, 49.99 for a monthly gym membership. Always enter the per-occurrence amount, not a monthly or annual total — the ƒMonthly column does the conversion. |
| First Payment | INPUT. The date of the first or next scheduled payment, in your locale's date format (e.g., 2026-01-15). This anchors the payment schedule and helps the Budget sheet's bill calendar place the obligation on the correct date. Example: 2026-07-01 for rent due on the first of each month. |
| Last Payment | INPUT. The final payment date if this obligation has a defined end. Enter a date for finite commitments like a 48-month car loan ending 2029-06-15. Leave this cell blank for ongoing obligations like rent or utilities that have no set end date. |
| From Account | INPUT. The account or source the money comes from. For expenses, this is typically your bank account (e.g., Chase Checking). For income, this might be your employer's name or 'Client ABC'. Example: 'BofA Savings' for an automatic savings transfer. |
| To Account | INPUT. The destination of the money. For expenses, this is the payee (e.g., Landlord, Netflix, Sallie Mae). For income, this is the account receiving the deposit (e.g., Chase Checking). Example: 'Vanguard 401k' for a retirement contribution. |
| ƒMonthly | Auto-computed. Converts the Amount to its monthly equivalent based on Frequency. Weekly items are multiplied by 52 and divided by 12; Biweekly by 26 and divided by 12; Monthly stays as-is; Quarterly is divided by 3; Semi-Annual by 6; Annual by 12. This normalization lets you see the true monthly impact of every recurring item regardless of how often it is billed. A good benchmark: total recurring expenses should ideally stay below 50% of monthly income. |
| Type (second instance) | Auto-computed or helper column. May mirror or re-classify the Type for chart grouping purposes. Used internally by the Recurring by Type chart. Do not edit. |
| ƒMonthly (second instance) | Auto-computed. A secondary monthly calculation used for aggregation in the KPI cards or chart data. May sum or filter ƒMonthly values by type (Income vs Expense). Do not edit. |
📊 Reading the numbers
• Amount KPI: The sum of all per-occurrence amounts entered on this sheet. This is a raw total and does not account for differing frequencies — use the Monthly KPI for a normalized view.
• Monthly KPI: The total of all ƒMonthly values, giving you your true monthly recurring financial commitment (expenses) and inflow (income). If recurring monthly expenses are close to or exceed recurring monthly income, you have very little room for discretionary spending.
• Recurring by Type (monthly) chart: A bar or pie chart splitting your monthly recurring totals into Income vs Expense. Ideally, the Income portion is significantly larger than the Expense portion. If they are close, most of your income is consumed by fixed obligations, leaving little flexibility.
⚠️ Avoid these mistakes
• Entering the annual total in the Amount column when the Frequency is set to Monthly — this would overstate the monthly cost by 12x. Always enter the per-occurrence amount.
• Using frequency terms that do not match the expected keywords (e.g., 'Every 2 weeks' instead of 'Biweekly') — the formula may not recognize non-standard terms and will produce errors or zeros.
• Forgetting to add a recurring item here and instead only logging it on Transactions each month — you will miss it in your fixed-cost analysis and the Budget sheet's bill calendar.
• Not updating the Last Payment date when a loan is paid off or a subscription is cancelled — the item will continue to inflate your recurring totals.
💡 Tips• Audit this sheet quarterly: cancel subscriptions you no longer use, update amounts that have changed (e.g., a rent increase), and add any new recurring commitments.
• Use the From Account and To Account columns to trace the flow of money — this is especially useful if you have multiple bank accounts and want to see which account bears the most recurring charges.
• When you get a raise, update your salary entry here immediately so the Budget sheet reflects your new income baseline.
• Sort by ƒMonthly descending to see your biggest recurring costs at the top — these are the highest-leverage items to renegotiate or eliminate if you need to cut spending.
📖Glossary — what every value means
| Net Cash Flow | Total Income minus Total Expenses for a given period. It tells you whether you saved money (positive) or overspent (negative). In this workbook it is calculated as the sum of all Income-type transactions minus the sum of all Expense-type transactions. A consistently positive net cash flow — even a small one — means you are building wealth over time. |
| Cash Flow Rate | Net Cash Flow divided by Total Income, expressed as a percentage. It represents the share of your income that you actually kept after all expenses. Formula: (Total Income − Total Expenses) ÷ Total Income × 100. A rate above 20% is excellent, 10–20% is good, 0–10% is tight, and below 0% means you are spending more than you earn. |
| 50/30/20 Budget | A budgeting guideline that recommends allocating 50% of after-tax income to Needs (rent, groceries, insurance), 30% to Wants (dining out, entertainment, subscriptions), and 20% to Savings and debt repayment. In this workbook, the ƒShare column on the Budget sheet lets you check each category's percentage against these thresholds. |
| SUMIFS | A spreadsheet formula that sums values in a range based on multiple criteria. In this workbook, the Budget sheet uses SUMIFS to pull transaction totals from the Transactions sheet filtered by category, type, and/or month. You never need to write or edit these formulas — they are built in. |
| Sinking Fund | A savings strategy where you set aside money over time for a planned future expense (e.g., vacation, car repair, holiday gifts). In this workbook, the Budget sheet tracks each sinking fund's actual savings versus its target amount, and the ƒUsed column shows your progress as a percentage. A fund at 100% is fully funded. |
| Recurring Bills | Predictable, repeating financial obligations like rent, subscriptions, loan payments, and insurance premiums. In this workbook, these are entered on the Recurring sheet with their frequency, and the ƒMonthly column normalizes them all to a monthly cost for easy comparison and budgeting. |
| Running Balance | A cumulative net-cash-flow figure tracked over time (typically 12 months in this workbook). It shows the trajectory of your finances — an upward slope means you are accumulating savings; a downward slope means you are depleting them. Displayed in the Running Balance (12-month) chart on the Budget sheet. |
| ƒ (auto-computed) | The ƒ symbol before a column name indicates that the column is formula-driven and updates automatically. You should never type into a ƒ column. If you accidentally overwrite a ƒ cell, press Ctrl+Z (Cmd+Z on Mac) immediately to restore the formula. |
Every template ships with an AI side-panel. Type in plain language — it fills rows, explains any cell, and analyses your data for you.
How to use it
1To open the built-in AI assistant, click the ✨ sparkle icon in the side panel of your Google Sheets workbook. This opens a chat window where you can ask questions and give commands in plain English — no formulas or technical knowledge required.
2You can ask it to explain any cell: try prompts like 'explain B7', 'what does the Cash Flow Rate mean?', or 'why is my Groceries budget showing red?' The assistant reads your actual data and gives a personalized answer. You can also attach a screenshot or image (such as a bank statement or receipt) and the assistant will read and interpret it for you.
3Give the assistant action commands and it will read your sheet and act — for example, 'sum column C', 'fill the next row with today's rent payment', 'color row 1 gold', or 'auto-fit all columns'. It executes these directly in your sheet without breaking any existing formulas.
4The assistant includes one-click presets tailored specifically to this Cashflow Budget template — simply click a preset button to run a common analysis or action without typing a prompt. There is also a Tools tab with an 'Analyze All My Data' feature that generates a full written report on a new sheet, an auto-fit columns option, the ability to translate every label in the workbook to another language, and an infographic builder that creates a visual summary of your financial data.
5You can customize the assistant's tone (Friendly, Professional, or Concise) and enable Smart Styling for polished formatting. Pro users unlock additional capabilities including native chart creation, financial forecasts, and a comprehensive multi-page report — all generated from your actual data.
6The assistant comes with free AI trial requests to get you started. After the trial, a subscription gives you a bigger monthly allowance of requests so you can continue using all features. You can scan your entire workbook, ask follow-up questions, and use it as your personal finance co-pilot throughout the month.