A Barefoot Investor budget spreadsheet is a way to track the book’s money buckets, but the method does not depend on a particular spreadsheet. You can make a simple Excel workbook that calculates the commonly described 60/10/10/20 allocations from monthly take-home income, then compare those targets with what you actually spend.
What the Barefoot Investor budget means
Scott Pape’s Barefoot Investor approach is an Australian personal-finance system built around directing income into named accounts or “buckets” for different purposes. The familiar starting split is 60% for Daily Expenses, 10% for Splurge, 10% for Smile and 20% for Fire Extinguisher. These percentages are generally applied to income after tax, not gross salary. The labels help make the plan tangible: bills and necessities have a limit, guilt-free spending has a place, and savings or debt reduction gets a deliberate share.
The buckets are a framework rather than a promise that every household can meet those percentages immediately. Housing costs, irregular income, dependants, debt and location can all affect what is realistic. The book’s steps and the author’s current materials are the best reference for the intended method; a spreadsheet found online may be an independent adaptation, not an official or endorsed template.
Does the method require a spreadsheet?
No. The system can be run with separate bank accounts and automatic transfers, with a notebook, a spreadsheet or a budgeting app used to review spending. A spreadsheet is useful when you want to see the monthly plan, identify which category is drifting and adjust the next month’s budget. It is not a replacement for moving money into the right accounts or checking your transactions.
Also distinguish a bucket from a spreadsheet category. A bank account physically separates money; a spreadsheet records and analyses it. If all income remains in one account, the sheet can still show allocations, but it cannot prevent that balance being spent on something else. Conversely, accounts without a tracking sheet may still work if you regularly check balances and statements.
Build a basic Excel layout
In Excel for Microsoft 365 on Windows, create a workbook with a Budget sheet and a Transactions sheet. On Budget, use one row per bucket and columns for the percentage, planned monthly amount, actual amount and difference. Put your monthly after-tax income in B1. For a basic version, set up this table:
- A2:A5: Daily Expenses, Splurge, Smile and Fire Extinguisher.
- B2:B5: 60%, 10%, 10% and 20%, respectively.
- C2:C5: the calculated monthly target for each bucket.
- D2:D5: actual spending or transfers recorded for the month.
- E2:E5: the amount remaining against each target.
With monthly take-home income of $5,000 in B1, the first target uses B1 for income and B2 for the Daily Expenses percentage. Enter =$B$1*B2 in C2 and fill it down through C5. The fixed reference to B1 keeps the income cell constant; the percentage reference changes by row. C2 returns $3,000, and the other targets are $500, $500 and $1,000.
With the four planned amounts in C2:C5, enter =SUM(C2:C5) in C6. It returns $5,000, confirming that these four percentages add up to 100% of the example income. If your percentages do not total 100%, the sum will expose the gap or over-allocation; check the rates before relying on the transfer plan.
Record actual spending and spot differences
For a quick workbook, you can type monthly actual totals directly into D2:D5 using bank statements or transaction exports. In E2, enter =C2-D2 and fill down to E5. With a $3,000 Daily Expenses target and $3,080 recorded, E2 is -$80, meaning spending exceeded the target by $80. A positive result means some of the planned amount remains. Be consistent about whether you record transfers into a bucket or purchases from it: counting both as spending would double-count money.
A more detailed setup uses a Transactions sheet, with dates in column A, bucket names in column B and amounts in column C. Record each purchase once and use the same category spelling as the Budget sheet. With the bucket name in A2 and transaction categories in Transactions!B2:B500, put this in D2 to total that bucket’s recorded transactions: =SUMIF(Transactions!$B$2:$B$500,A2,Transactions!$C$2:$C$500). It returns the sum of matching amounts; for example, three Daily Expenses transactions of $80, $45 and $25 return $150. Copy it down beside the other bucket names. Extend the range if you expect more than 499 transactions, or use a formatted Excel Table so new rows are easier to include.
For meaningful monthly comparisons, record only transactions for the month being reviewed. The simplest option is to keep a separate transaction list for each month. If you maintain one year-long list, add a month-selection method or use a PivotTable rather than mixing several months into one actual total. In Excel for Microsoft 365 on Windows, select the transaction data and choose Insert > PivotTable to summarize by bucket and date. Excel for Mac has the PivotTable feature too, though ribbon placement can vary slightly by release.
How to use the buckets without double-counting
Daily Expenses commonly covers recurring necessities such as housing, utilities, groceries, transport and insurance. Splurge is for personal spending that can be used without treating every purchase as a failure. Smile is typically for planned treats or goals such as a holiday. Fire Extinguisher is the part directed toward financial priorities such as paying down debt or building savings, depending on where someone is in the steps.
Mojo is often discussed as the emergency-savings account in the Barefoot system, but it should not automatically be added as another percentage on top of the four percentages above. Doing that would make a 100% allocation exceed income. Follow the book’s sequence for how the Fire Extinguisher money and Mojo fit together, and represent a transfer only once in your own workbook. Your spreadsheet can include a separate savings-balance tracker without counting the same dollars as both an expense and a new allocation.
Make the spreadsheet fit real household cash flow
A monthly budget is a planning unit, but pay may arrive weekly, fortnightly or irregularly. Convert amounts to a consistent monthly basis before comparing them. For example, multiplying a weekly amount by 52 and dividing by 12 gives an average monthly equivalent; using four weeks instead would understate the annual total. If income changes, use a conservative estimate for planning and update the sheet when actual pay arrives rather than assuming every month will match a strong one.
Irregular bills need attention too. Annual registration, insurance renewals, school costs and repairs can make a month look over budget even when the household has planned sensibly over a full year. You can list these separately with their due dates and monthly set-aside amounts, or include them in the relevant bucket. Choose one approach and avoid entering the same bill in both places. A useful review asks whether the annual cost was anticipated, not just whether the current month exceeded a target.
If the 60% Daily Expenses target is not workable, record the actual essentials and examine the gap rather than hiding it in a different bucket. A sheet can reveal whether the issue is a one-off bill, an unrealistic percentage or ongoing costs that need a broader plan. Changing percentages is a personal adaptation, not evidence that the spreadsheet has discovered a universally correct budget.
Common spreadsheet mistakes and safer handling
- Using gross pay: the usual percentage split is described in relation to after-tax income. Using pre-tax salary inflates the targets.
- Mixing transfers and purchases: entering a transfer to an account as spending and then entering purchases from that account counts the same money twice.
- Leaving out timing: an annual bill can be affordable over time but still cause a short-term cash shortage if no money was set aside.
- Changing categories mid-month: keep category definitions stable, or add a note explaining a change so comparisons remain useful.
- Trusting a template blindly: check formulas, percentage totals and any hidden rows before using a downloaded workbook.
Keep the workbook free of online-banking passwords, card numbers and other credentials. A normal budget sheet needs transaction dates, descriptions, categories and amounts, not login details. Store it somewhere appropriate for the sensitivity of your finances, and be cautious with macros or files from unknown sources. A macro-enabled template is not necessary for the basic calculations described here.
Spreadsheet, bank accounts or budgeting app?
A spreadsheet offers transparent calculations and flexibility: you can change categories, add notes and see the formulas. Its trade-off is manual upkeep unless you import and review transaction data. Separate bank accounts can make the buckets visible in everyday balances and support automatic transfers, but account fees, transfer timing and account terms vary. A budgeting app may categorize transactions automatically, but check its fees, privacy practices, supported institutions and category rules before connecting accounts.
These tools can be combined. For instance, automatic transfers can implement the plan, while a spreadsheet provides a monthly check on whether spending matches it. Compare the tool’s cost with the time it saves and the clarity it provides; a complicated tracker that is not maintained is less useful than a simple one reviewed consistently. If evaluating an account or app, check current provider terms rather than assuming features or pricing are permanent.
Frequently Asked Questions
Where can I download the official Barefoot Investor spreadsheet?
Check Scott Pape’s official website or current book materials for any resources available now. A spreadsheet described as “Barefoot” elsewhere may be a third-party template, so verify its source and formulas rather than assuming endorsement.
What percentages should I put in the spreadsheet?
The commonly cited starting split is 60% Daily Expenses, 10% Splurge, 10% Smile and 20% Fire Extinguisher, calculated from take-home income. Check the relevant edition or official guidance for context, and treat the figures as a framework rather than a guarantee they suit every household.
Should I include Mojo as a fifth percentage?
Not automatically. The four percentages already total 100%. Mojo is associated with emergency savings in the system, so follow the book’s sequence and avoid allocating the same money twice in your own budget.
Can I use this spreadsheet with weekly pay?
Yes. Convert income and planned costs to a consistent period, or maintain a weekly plan and review it against monthly bills. The important point is not to compare a weekly amount directly with a monthly target.
Is a Barefoot Investor spreadsheet financial advice?
No. A workbook organizes information and performs arithmetic; it does not assess your whole financial position or account terms. For decisions about debt, tax, investments or other financial matters, check the relevant terms with the provider or consult a qualified professional.
Related
- Antique Inventory Spreadsheet Example and Setup
- Sales Tracking Spreadsheet Template: Free Excel Setup
- How to Add Animated Text to PowerPoint Presentations
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set an Out of Office Reply in Outlook 365To set an out of office reply in Outlook 365, open Automatic Replies, switch them on, write your…
- Excel Freeze Panes Shortcut: Windows Keys and TipsIn Excel for Microsoft 365 on Windows, press Alt, then W, F, and F to open Freeze Panes.…
- Excel Insert Row Shortcut: Fast Ways for Windows and MacExcel has no built-in shortcut named “IR.” If you mean insert row, select the row with Shift+Space, then…
- Split Cell in Google Sheets: Separate Text Into ColumnsTo split text in a Google Sheets cell, select the cell or range, choose Data > Split text…
- How to Use Styles from Another Word Document in WordTo use styles from another Word document, copy them with Word’s Organizer, then apply the imported styles to…
- How to Share a Group Calendar in New OutlookTo share a group calendar in New Outlook, add the people who need access as members of its…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.