📘
Cashflow Budget Workbook — Complete User Manual
Instruction Manual · How to use this template
The Cashflow Budget Workbook is a premium Google Sheets template that gives you complete cash-flow clarity from a single data-entry habit: log every transaction once on the Transactions sheet, and every dashboard, 50/30/20 split, savings-goal tracker, and bill calendar updates itself automatically. It is designed for individuals, couples, or freelancers who want to see exactly where their money goes each month without building or maintaining any formulas. Your workflow is simple — set your budget targets and recurring bills once, then log transactions as they happen; the Budget sheet synthesizes everything into KPIs, charts, and progress bars so you can make confident spending decisions at a glance.
⚡ Quick start
1Step 1: Open the Read Me sheet and review the color-coding legend — green-header columns are auto-computed (ƒ), white-header columns are where you type.
2Step 2: Go to the Recurring sheet and enter every recurring income and expense (rent, subscriptions, salary, etc.) with its frequency and amount — the sheet will convert each entry to a monthly figure automatically.
3Step 3: Switch to the Budget sheet and fill in the Category and Budget columns with your spending categories and the dollar amount you plan to spend in each category this month; also set up any sinking-fund savings goals in the Group, ƒTarget section.
4Step 4: Begin logging every transaction on the Transactions sheet — enter the Date, Type (Income or Expense), Category (must match a Budget category exactly), Amount, optional Note, and Method (cash, debit, credit, etc.).
5Step 5: Return to the Budget sheet at any time to see your KPI cards (Total Income, Total Expenses, Net Cash Flow, Cash Flow Rate) and seven auto-updating charts that show exactly where you stand against your plan.
6Step 6: Review the Running Balance (12-month) chart at month-end to confirm your net worth trajectory, and adjust Budget targets or Recurring entries as your situation changes.
The Budget sheet is your command center. It pulls live data from the Transactions sheet using SUMIFS formulas to show how your actual income and spending compare to your plan across every category, payment method, and savings goal. Visit this sheet whenever you want a snapshot of your financial health for the current month.
✍️ Step by step
11. In the Category column (budget section), type each spending or income category you want to track — e.g., Groceries, Rent, Utilities, Entertainment. Use the exact same spelling you will use on the Transactions sheet.
22. In the Budget column next to each category, type the dollar amount you plan to spend (or earn) for that category this month — e.g., 600 for Groceries.
33. The ƒSpent and ƒLeft columns will auto-populate as you log transactions: ƒSpent pulls the sum of matching transactions, and ƒLeft shows how much budget remains.
44. In the Bill, Amount, and Frequency columns, list each recurring bill (electric, internet, insurance, etc.) along with its dollar amount and how often it recurs (monthly, quarterly, annually). The ƒMonthly column converts every frequency to a monthly equivalent automatically.
55. Review the KPI cards at the top — TOTAL INCOME, TOTAL EXPENSES, NET CASH FLOW, and CASH FLOW RATE update in real time as transactions are logged.
66. Scroll to the sinking-funds section and enter each savings goal in the Group column with its target amount — ƒActual, ƒTarget, and ƒUsed will track your progress automatically based on transactions tagged to that group.
77. Use the seven charts (Income by Source, Expenses by Category, Budget vs Spent, Cash Flow by Method, Recurring Bills, Running Balance, Sinking Funds — Saved vs Target) to visually assess your position.
88. At the start of each new month, update the Budget column if your targets have changed; the ƒ columns will reset based on the new month's transactions.
99. Compare the Planned vs Actual KPIs to see whether your total budgeted amounts align with what actually happened — a large gap means your budget needs recalibration.
📋 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 budgeted (planned) amount for each income source, drawn from the Budget column entries that correspond to income categories. Helps you see whether you expected this income. |
| ƒActual | Auto-computed. Displays the actual income received for each source by summing all Income-type transactions in that category from the Transactions sheet using SUMIFS. Compare this to ƒPlanned to see if you earned more or less than expected. |
| ƒDiff | Auto-computed. Difference between Actual and Planned income (ƒActual − ƒPlanned). A positive number means you earned more than planned (good); a negative number means you fell short. Ideally this is zero or positive. |
| Category | Input column (budget section). Type the name of each spending or income category — for example, Groceries, Dining Out, Transport, Rent, Salary. Important: spell each category exactly as you will on the Transactions sheet, because the formulas match on this text. One category per row. |
| Budget | Input column. Enter the dollar amount you plan to spend (or earn) in this category for the month. Use whole numbers or decimals, no currency symbols — e.g., 500 or 1200.50. This is your target; the template will measure your actuals against it. |
| ƒSpent | Auto-computed. Totals every transaction on the Transactions sheet whose Category matches this row's Category and whose Type is Expense, for the current month. If you see a number here that looks wrong, check that your category spelling matches exactly between sheets. |
| ƒLeft | Auto-computed. Budget minus Spent (Budget − ƒSpent). A positive value means you still have room in that category; a negative value means you have overspent. Watch for negative numbers — they signal a category that needs attention. |
| Method | Input column. Enter each payment method you use — e.g., Cash, Debit Card, Credit Card, Venmo, Bank Transfer. One method per row. This lets the template break down cash flow by how money moves. |
| ƒIn | Auto-computed. Total money received through this payment method, summed from Income transactions on the Transactions sheet that match this Method. Useful for seeing which accounts receive the most inflows. |
| ƒOut | Auto-computed. Total money spent through this payment method, summed from Expense transactions that match this Method. Helps you see which payment channel drains the most cash. |
| ƒNet | Auto-computed. Net cash flow for this method (ƒIn − ƒOut). A positive value means more money flowed in through this method than out; a negative value is typical for spending-only methods like a credit card. For your main bank account, you want this positive. |
| Bill | Input column. Type the name of each recurring bill — e.g., Electric, Internet, Car Insurance, Netflix. One bill per row. This feeds the Recurring Bills chart. |
| Amount | Input column. Enter the dollar amount of each bill as charged — e.g., 150 for your electric bill. Use the actual billed amount, not an estimate, for accuracy. |
| Frequency | Input column. How often the bill recurs. Type one of: Weekly, Biweekly, Monthly, Quarterly, Semi-annually, or Annually. The ƒMonthly column uses this to normalize every bill to a per-month cost. |
| ƒMonthly | Auto-computed. Converts each bill to its monthly equivalent cost. For example, a $600 annual insurance premium shows as $50/month; a $100 weekly expense shows as roughly $433/month. Formula in words: if Frequency is Monthly, ƒMonthly = Amount; if Annual, Amount ÷ 12; if Quarterly, Amount ÷ 3; if Weekly, Amount × 52 ÷ 12; and so on. This lets you see the true monthly burden of every bill regardless of billing cycle. |
| Category (analysis) | Auto-computed. Lists each expense category again in the analysis section. This column mirrors the Category input column and is used to drive the Expenses by Category chart and the ƒShare calculation. |
| ƒSpent (analysis) | Auto-computed. Same as the budget-section ƒSpent — total actual spending in each category, pulled from Transactions via SUMIFS. |
| ƒShare | Auto-computed. The percentage of your total expenses that this category represents (Category ƒSpent ÷ Total Expenses × 100). For example, if you spent $500 on Groceries and your total expenses are $2,500, ƒShare = 20%. This is critical for 50/30/20 analysis — you can see at a glance whether needs, wants, or savings dominate your spending. |
| ƒvs Budget | Auto-computed. Shows how actual spending compares to the budgeted amount as a percentage or difference (Spent ÷ Budget × 100 or Spent − Budget). Values above 100% (or positive differences) mean overspending; values below 100% mean underspending. A healthy target is 90–100% for needs categories and well under 100% for discretionary categories. |
| Group | Input column (sinking funds section). Enter the name of each savings goal or sinking fund — e.g., Emergency Fund, Vacation, New Laptop, Car Repair. One goal per row. |
| ƒActual (sinking funds) | Auto-computed. The total amount saved toward this goal so far, pulled from Transactions where the Category matches this Group name and the Type is tagged appropriately. This is your running saved-so-far total. |
| ƒTarget | Auto-computed or input (depending on setup). The total dollar amount you want to save for this goal — e.g., 5000 for an emergency fund. If this is an input, type your target here. The Sinking Funds chart uses this to show a Saved vs Target bar. |
| ƒUsed | Auto-computed. The percentage of the target that has been reached (ƒActual ÷ ƒTarget × 100). For example, if you have saved $2,000 of a $5,000 goal, ƒUsed = 40%. A value of 100% means the goal is fully funded. Track this to prioritize which goals need more contributions. |
📊 Reading the numbers
• TOTAL INCOME KPI: The sum of all income transactions for the current month. A healthy value depends on your situation, but it should match or exceed your TOTAL EXPENSES. If it is lower, you are spending more than you earn.
• TOTAL EXPENSES KPI: The sum of all expense transactions for the month. Compare this to TOTAL INCOME — if expenses exceed income, your Net Cash Flow will be negative, which is unsustainable long-term.
• NET CASH FLOW KPI: Total Income minus Total Expenses. Positive means you have surplus cash (good); negative means you are drawing down savings or going into debt (bad). Aim for a consistently positive value.
• CASH FLOW RATE KPI: Net Cash Flow divided by Total Income, expressed as a percentage. It tells you what fraction of every dollar earned you actually keep. A rate above 20% is excellent; 10–20% is solid; below 10% leaves little margin for emergencies; negative means you are losing money.
• Planned vs Actual KPIs: Planned is the total of all your Budget column entries; Actual is what you really spent. If Actual consistently exceeds Planned, your budget targets are unrealistic and need adjustment.
• Income by Source chart: A bar or pie chart showing which income streams contribute the most. Useful for spotting over-reliance on a single source.
• Expenses by Category chart: Shows spending distribution across categories. Look for any single category consuming a disproportionate share (ƒShare > 30% for a discretionary category is a red flag).
• Budget vs Spent chart: Side-by-side bars for each category. Categories where the Spent bar exceeds the Budget bar need attention.
• Cash Flow by Method chart: Shows net flow per payment method. If your credit card method is deeply negative, ensure you can cover the balance each month.
• Recurring Bills (monthly) chart: Visualizes your fixed monthly obligations. If recurring bills consume more than 50% of income, you have limited flexibility for discretionary spending.
• Running Balance (12-month) chart: A line chart of your cumulative net cash flow over 12 months. An upward trend means growing savings; a downward trend means depletion. Look for the slope — a flattening line means you are approaching break-even.
• Sinking Funds — Saved vs Target chart: Bar chart comparing saved amounts to goal targets. Fully filled bars mean funded goals; short bars indicate goals that need more attention.
⚠️ Avoid these mistakes
• Spelling a category differently on the Budget sheet vs. the Transactions sheet (e.g., 'Dining' vs. 'Dining Out') — this breaks the SUMIFS lookup and your ƒSpent will show zero even though you have transactions.
• Entering a currency symbol ($) or comma in the Budget or Amount columns — this can cause formula errors; type plain numbers only.
• Forgetting to set the Frequency for a recurring bill — the ƒMonthly conversion will be wrong or zero.
• Leaving the Group column blank for a sinking fund row — the formulas cannot match transactions to a nameless goal.
💡 Tips• Use data validation (Data → Data validation) on the Category column to create a dropdown that prevents typos and keeps naming consistent with Transactions.
• Review the ƒShare column monthly to run a quick 50/30/20 check: sum the shares of needs categories (should be ≤ 50%), wants (≤ 30%), and savings/debt (≥ 20%).
• Sort the ƒLeft column ascending to see your most-overspent categories at the top — those are the first areas to cut.
• Duplicate the Budget sheet at month-end (right-click tab → Duplicate) to archive a snapshot before updating targets for the new month.
The Transactions sheet is your financial diary — every dollar in or out gets one row here. This is the only sheet where you do regular data entry. Every other sheet reads from this one, so accuracy and consistency here drive the entire workbook's value.
✍️ Step by step
11. Each time you earn or spend money, add a new row at the bottom of the Transactions sheet.
22. In the Date column, enter the date of the transaction in the format your spreadsheet locale expects (e.g., 2026-06-15 or 06/15/2026).
33. In the Type column, type either 'Income' or 'Expense' — this determines which KPIs and charts the amount flows into.
44. In the Category column, type the category name that exactly matches one of the categories you set up on the Budget sheet — e.g., Groceries, Salary, Rent.
55. In the Amount column, enter the dollar value as a positive number — e.g., 45.99. Do not use negative numbers for expenses; the Type column handles directionality.
66. In the Note column, optionally add a short description — e.g., 'Weekly grocery run at Costco' or 'June paycheck'. This is for your reference only and does not affect any calculations.
77. In the Method column, enter the payment method used — e.g., Debit Card, Credit Card, Cash, Venmo. This must match a Method entry on the Budget sheet for the Cash Flow by Method chart to work.
88. The ƒMonth, ƒIncome, ƒExpenses, and ƒNet columns fill themselves automatically — do not type in them.
99. Periodically check the KPI cards (Amount, Income, Expenses, Net) and the Monthly Income vs Expenses chart to confirm your entries are being captured correctly.
📋 Column-by-column
| Date | Input column. Enter the date when the transaction occurred. Use a consistent date format such as YYYY-MM-DD or MM/DD/YYYY. Example: 2026-06-15. The ƒMonth column extracts the month from this date automatically, so an accurate date is essential for monthly roll-ups. |
| ƒMonth | Auto-computed. Extracts the month (and possibly year) from the Date column — e.g., Jun 2026 or 2026-06. This is used internally to group transactions by month for the Running Balance chart and monthly KPIs. You do not edit this column. |
| Type | Input column. Must be either 'Income' or 'Expense'. This single word controls whether the amount is added to income totals or expense totals across the entire workbook. Spelling matters — use exactly 'Income' or 'Expense' with that capitalization. |
| Category | Input column. The spending or earning category for this transaction. Must match a Category on the Budget sheet exactly (case-sensitive). Examples: Groceries, Salary, Rent, Freelance, Entertainment. If you type a category that does not exist on the Budget sheet, it will not appear in the Budget vs Spent analysis. |
| Amount | Input column. The dollar value of the transaction as a positive number. Do not include dollar signs, commas, or negative signs — just the number. Examples: 12.50, 1500, 200. The Type column determines whether this is income or expense, so all amounts are positive. |
| Note | Input column (optional). A free-text description for your own reference. Examples: 'Birthday dinner with Sarah', 'Monthly Spotify subscription', 'Q2 freelance invoice from Acme Corp'. This field is not used in any calculations but is invaluable when you review past transactions to understand where money went. |
| Method | Input column. The payment method or account used for this transaction — e.g., Cash, Debit Card, Credit Card, Venmo, Bank Transfer. Must match a Method entry on the Budget sheet for the Cash Flow by Method breakdown to include it. One method per transaction. |
| ƒMonth (duplicate) | Auto-computed. This is a second month-extraction column used internally for helper calculations or chart data ranges. It mirrors the first ƒMonth column. Do not edit. |
| ƒIncome | Auto-computed. Shows the Amount value only if the Type is 'Income'; otherwise it is blank or zero. Formula in words: IF Type = Income THEN Amount ELSE 0. This column feeds the TOTAL INCOME KPI and the income side of the Monthly Income vs Expenses chart. |
| ƒExpenses | Auto-computed. Shows the Amount value only if the Type is 'Expense'; otherwise it is blank or zero. Formula in words: IF Type = Expense THEN Amount ELSE 0. This column feeds the TOTAL EXPENSES KPI and the expense side of the Monthly Income vs Expenses chart. |
| ƒNet | Auto-computed. The net effect of this single transaction on your cash position. Formula: ƒIncome − ƒExpenses. For an income transaction this equals the Amount (positive); for an expense it equals negative Amount. The running sum of this column over time produces the Running Balance chart on the Budget sheet. |
📊 Reading the numbers
• Amount KPI: The total of all transaction amounts regardless of type. This is a raw volume figure — it tells you how much money moved through your accounts, but not the direction. Useful as a quick pulse check.
• Income KPI: The sum of all transactions where Type = Income. This should match the TOTAL INCOME KPI on the Budget sheet. If it does not, check for miscategorized transactions.
• Expenses KPI: The sum of all transactions where Type = Expense. Compare to Income — if Expenses > Income, you spent more than you earned.
• Net KPI: Income minus Expenses for all transactions on this sheet. Positive is good (surplus); negative is bad (deficit). This mirrors the NET CASH FLOW KPI on the Budget sheet.
• Monthly Income vs Expenses chart: A grouped bar chart showing income and expenses side by side for each month. Look for months where the expense bar exceeds the income bar — those are deficit months. A consistent pattern of income bars taller than expense bars indicates healthy cash flow.
⚠️ Avoid these mistakes
• Entering a negative number in the Amount column for expenses — the formulas expect positive numbers and use the Type column to determine direction; a negative expense amount would be treated as negative spending, skewing your totals.
• Typing 'Expense' with a lowercase 'e' or misspelling it as 'Expence' — the ƒIncome and ƒExpenses formulas rely on exact text matching, so a typo means the transaction is not counted in either total.
• Using a category name that does not exist on the Budget sheet — the transaction will be recorded here but will not appear in Budget vs Spent, making your budget tracking incomplete.
• Leaving the Date column blank — without a date, the ƒMonth extraction fails and the transaction will not appear in monthly charts or roll-ups.
💡 Tips• Log transactions daily or at least weekly — a backlog makes it easy to forget small cash purchases that add up.
• Use the Note column strategically: tag transactions with keywords like 'tax-deductible' or 'reimbursable' so you can filter for them later using Google Sheets' built-in filter (Data → Create a filter).
• Sort by the ƒMonth column to quickly review all spending in a given month.
• If you accidentally enter a transaction twice, simply delete the entire row — the ƒ columns on the Budget sheet will recalculate automatically.
The Recurring sheet is where you define every predictable, repeating income or expense — salaries, subscriptions, loan payments, rent, etc. By logging them once here with their frequency, the sheet auto-converts each to a monthly figure and feeds the Budget sheet's Recurring Bills chart. This saves you from re-entering the same transactions every month.
✍️ Step by step
11. For each recurring cash flow, add one row. Start with the Type column — enter 'Income' or 'Expense'.
22. In the Category column, type the category this recurring item belongs to — e.g., Salary, Netflix, Rent, Car Payment. Match the spelling used on the Budget and Transactions sheets.
33. In the Frequency column, specify how often this recurs: Weekly, Biweekly, Monthly, Quarterly, Semi-annually, or Annually.
44. In the Amount column, enter the dollar value per occurrence — e.g., 15.99 for a monthly Netflix subscription or 1200 for monthly rent.
55. In the First Payment column, enter the date of the first (or next upcoming) payment — e.g., 2026-01-01. This helps you track when the obligation began.
66. In the Last Payment column, enter the end date if the recurring item has a known expiry (e.g., the final car payment date). Leave blank if it is ongoing (e.g., rent with no fixed end).
77. In the From Account column, type which account or method the money leaves — e.g., Checking Account, Credit Card.
88. In the To Account column, type where the money goes — e.g., Landlord, Netflix, Savings Account. This is especially useful for transfers between your own accounts.
99. The ƒMonthly column will automatically convert the amount to a monthly equivalent based on the Frequency you entered. Review the KPI cards and the Recurring by Type chart to see your total recurring obligations.
📋 Column-by-column
| Type | Input column. Enter 'Income' or 'Expense' to classify this recurring cash flow. Income entries might include salary, freelance retainers, or rental income. Expense entries include subscriptions, loan payments, rent, insurance premiums, etc. |
| Category | Input column. The category this recurring item falls under — e.g., Salary, Streaming, Rent, Insurance. Should match the category names on Budget and Transactions sheets for cross-sheet consistency. |
| Frequency | Input column. How often this income or expense recurs. Accepted values: Weekly, Biweekly, Monthly, Quarterly, Semi-annually, Annually. The ƒMonthly column uses this to normalize the amount to a per-month figure. |
| Amount | Input column. The dollar amount per occurrence. Enter as a positive number with no currency symbol. For example: 15.99 for a monthly subscription, 2600 for a biweekly paycheck, or 1200 for annual insurance. |
| First Payment | Input column. The date of the first (or next upcoming) payment in your standard date format — e.g., 2026-01-15. Useful for tracking when obligations start and for planning cash flow timing. |
| Last Payment | Input column. The date of the final payment, if applicable — e.g., 2029-06-15 for a car loan payoff date. Leave this blank for indefinite recurring items like rent or streaming subscriptions. When filled, it helps you see when an obligation will end. |
| From Account | Input column. The account or payment method from which this recurring amount is drawn — e.g., Checking Account, Chase Visa, PayPal. Helps you understand which accounts carry the heaviest recurring burden. |
| To Account | Input column. The destination of the payment — e.g., Landlord, Spotify, Savings Account, Student Loan Servicer. For income, this is the account receiving funds (e.g., Checking Account). Useful for tracking money flow between your own accounts and external payees. |
| ƒMonthly | Auto-computed. Converts the Amount to a monthly equivalent based on the Frequency. Formula in words: Weekly = Amount × 52 ÷ 12; Biweekly = Amount × 26 ÷ 12; Monthly = Amount; Quarterly = Amount ÷ 3; Semi-annually = Amount ÷ 6; Annually = Amount ÷ 12. This lets you compare all recurring items on the same monthly basis regardless of their billing cycle. A large ƒMonthly value on an expense line signals a significant fixed cost. |
| Type (summary) | Auto-computed. Groups recurring entries by type (Income vs. Expense) in a summary section used for the Recurring by Type chart. You do not edit this column. |
| ƒMonthly (summary) | Auto-computed. Aggregates the ƒMonthly values by type — total monthly recurring income and total monthly recurring expenses. The difference between these two totals tells you how much of your monthly cash flow is already spoken for by recurring obligations. If recurring expenses consume more than 60-70% of recurring income, you have limited discretionary spending room. |
📊 Reading the numbers
• Amount KPI: The sum of all recurring amounts at their native frequency (not monthly-adjusted). This is a raw total and is less useful for comparison than the Monthly KPI, but gives you a sense of total contractual obligations.
• Monthly KPI: The sum of all ƒMonthly values — your total monthly recurring cash flow obligation. Compare this to your monthly income; if recurring obligations exceed 70% of income, your budget is heavily committed and vulnerable to unexpected expenses.
• Recurring by Type (monthly) chart: A bar or pie chart splitting total monthly recurring amounts into Income vs. Expense. Ideally the Income bar is significantly taller than the Expense bar. If they are close or Expense exceeds Income, your recurring commitments alone may put you in a deficit before any discretionary spending.
⚠️ Avoid these mistakes
• Entering the total annual amount when the Frequency is set to Monthly — e.g., typing 1200 for an annual insurance premium with Frequency set to Monthly would overstate your monthly obligation by 12x. Enter the amount per occurrence, not the annual total.
• Forgetting to update this sheet when you cancel a subscription or a loan is paid off — stale entries inflate your recurring totals and make your budget look tighter than it really is.
• Using inconsistent category names between Recurring, Budget, and Transactions — this breaks cross-sheet lookups.
💡 Tips• Review this sheet quarterly and delete or update any items that have changed — cancelled subscriptions, renegotiated bills, or completed loan payments.
• Use the Last Payment column as a reminder: filter for items with a Last Payment date in the current year to celebrate upcoming financial freedom from that obligation.
• Sort by ƒMonthly descending to see your biggest recurring costs at the top — these are the highest-impact items to renegotiate or eliminate if you need to free up cash flow.
• Add a row for annual expenses you tend to forget (car registration, holiday gifts, tax preparation fees) so they are reflected in your monthly budget as small, predictable amounts.
📖Glossary — what every value means
| Net Cash Flow | Total Income minus Total Expenses for a given period. It measures whether you earned more than you spent (positive = surplus, you are saving money) or spent more than you earned (negative = deficit, you are depleting savings or going into debt). In this template it is calculated on the Budget sheet. A consistently positive net cash flow is the foundation of financial health. |
| Cash Flow Rate | Net Cash Flow divided by Total Income, expressed as a percentage. It tells you what percentage of every dollar earned you actually keep after all expenses. Formula: (Total Income − Total Expenses) ÷ Total Income × 100. A rate above 20% is excellent and indicates strong saving habits; 10–20% is healthy; below 10% means you have very little margin; a negative rate means you are spending more than you earn. |
| 50/30/20 Rule | A popular budgeting guideline that recommends allocating 50% of after-tax income to needs (rent, groceries, insurance), 30% to wants (dining out, entertainment, hobbies), and 20% to savings and debt repayment. In this template, you can use the ƒShare column on the Budget sheet to check whether your spending categories fall within these thresholds by summing the shares of needs, wants, and savings categories respectively. |
| Sinking Fund | A savings strategy where you set aside small amounts of money regularly toward a planned future expense — e.g., saving $100/month toward a $1,200 annual car insurance premium or $200/month toward a $2,400 vacation. In this template, sinking funds are tracked in the Group/ƒActual/ƒTarget/ƒUsed section of the Budget sheet and visualized in the Sinking Funds — Saved vs Target chart. A fully funded sinking fund (ƒUsed = 100%) means you have saved enough to cover the planned expense. |
| SUMIFS | A Google Sheets formula function that sums values in a range based on multiple criteria. In this template, the Budget sheet uses SUMIFS to pull transaction totals from the Transactions sheet, matching on criteria like Category, Type, and Month. You never need to write or edit these formulas — they are built into the template's ƒ columns. |
| Running Balance | A cumulative total of net cash flow over time. Each month's Running Balance equals the previous month's balance plus the current month's Net Cash Flow. In the Running Balance (12-month) chart on the Budget sheet, an upward-sloping line means you are accumulating wealth over time; a downward slope means you are spending down your reserves. |
| Recurring Expense | Any expense that repeats on a predictable schedule — weekly, biweekly, monthly, quarterly, semi-annually, or annually. Examples include rent, subscriptions, loan payments, and insurance premiums. The Recurring sheet converts all frequencies to a monthly equivalent (ƒMonthly) so you can see your true fixed monthly cost base. |
| ƒ (Formula Column) | Any column prefixed with ƒ in this template is auto-computed — it contains a formula that calculates its value from your inputs. You should never type in a ƒ column. Examples: ƒSpent, ƒNet, ƒMonthly, ƒShare. If you accidentally overwrite a ƒ cell, use Ctrl+Z (Cmd+Z on Mac) to undo immediately. |
| Budget vs Spent | A comparison of your planned budget amount for each category against your actual spending. Shown as a paired bar chart on the Budget sheet. When the Spent bar exceeds the Budget bar, you have overspent in that category. Ideally, Spent bars are at or slightly below Budget bars, indicating disciplined spending aligned with your plan. |
| Net | In the context of payment methods and transactions, Net refers to money in minus money out (ƒIn − ƒOut) for a specific method or time period. Positive net means more money flowed in than out through that channel; negative net is normal for expense-only methods like credit cards but should be watched for magnitude. |
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, look for the ✨ sparkle icon in the right-side panel of Google Sheets and click it. The assistant can read the data in your spreadsheet and help you understand, troubleshoot, or optimize your budget — all without leaving the workbook.
2Try prompts like: 'Fill this row with an example transaction', 'Explain what the value in cell B7 means', 'Which category am I overspending in?', 'What should I cut to save an extra $200/month?', or 'Summarize my spending for this month.' The assistant understands the structure of the template and can reference specific cells and sheets.
3The assistant is great for quick analysis and plain-English explanations of your financial data — for example, ask 'Why is my Cash Flow Rate so low?' and it will walk you through which expense categories are dragging it down. It can also help you brainstorm budget adjustments and set realistic savings targets.
4The assistant cannot modify formulas in ƒ columns, access external bank accounts, or sync with third-party financial services. It works only with the data present in your spreadsheet. It also cannot guarantee financial advice — treat its suggestions as informational, not professional financial counsel.
5You start with a set of free AI requests to explore the feature. After those are used, a subscription plan gives you a larger monthly allowance of requests so you can continue using the assistant throughout each billing cycle. The exact number of free and subscription requests is shown in the side panel.
6For best results, be specific in your prompts — instead of 'Help me budget', try 'I want to reduce my Dining Out spending by 25% — what would that save me monthly and how does it affect my Cash Flow Rate?' The more context you give, the more tailored and actionable the response will be.