• Credit Cards
    • Close
    • Best Credit Cards
      • The Best Credit Cards of 2023
      • Best Rewards Credit Cards
      • Best Cash Back Credit Cards
      • Best Travel Rewards Credit Cards
      • Best Balance Transfer Credit Cards
      • Best Sign-Up Bonus Credit Cards
      • Best Credit Cards For Young Adults
      • Best Credit Cards For College Students
    • Best By Credit Score
      • Excellent Credit
      • Good Credit
      • Average Credit
      • Fair Credit
      • Poor Credit
    • Credit Cards Tools
      • Compare Credit Cards
      • Credit Score Calculator: Get Your Estimated Credit Score Range
      • Balance Transfer Calculator: How much can you save?
    • Explore More
      • Credit Needed for a Credit Card
      • The Different Types of Credit Cards
      • How To Choose A Credit Card
      • How To Apply For A Credit Card
      • How To Use A Credit Card Responsibly
      • How Credit Card Miles Work
      • How Credit Card Reward Points Work
      • Maximize Credit Card Rewards
    • Close
  • Banking
    • Close
    • Best Of
      • Best Saving Accounts
      • Best High-Yield Savings Accounts of 2022
      • Best Money Market Accounts
      • Best Free Checking Accounts
      • Best CD Rates
      • Best Business Checking Accounts
      • Best Banks
    • Savings
      • How To Start Saving
      • How Much Should I Save Each Month?
      • Short-Term Savings
      • Savings Accounts Perks And Benefits
      • Money Market vs. Savings Account
    • Explore More
      • Banking 101
      • How To Choose a Bank
      • How To Switch Bank Accounts
      • Start An Emergency Fund
      • Build A CD Ladder
      • When To Open Multiple Bank Accounts
      • Understanding Overdraft Protection and Fees
      • Automatic Payments Explained
    • Start Saving
    • Close
  • Loans
    • Close
    • Personal Loans
      • Best Personal Loans
      • Best Personal Loans For Excellent Credit
      • Best Personal Loans For Good Credit
      • Best Personal Loans For Fair Credit
      • Best Personal Loans For Bad Credit
      • Peer-to-Peer Loans
    • Auto
      • Best Auto Loans
      • Auto Loan Interest Calculator
      • Finance A Car The Smart Way
      • How To Refinance Your Car Loan
      • Peer-to-Peer Auto Loans
    • Students
      • Best Student Loans
      • How Do Student Loans Work?
      • Best Companies For Student Loan Refinancing in 2022
      • Manage Student Loans
      • Student Loan Refinance Guide
      • How To File A FAFSA As An Independent Student
    • Mortgage
      • Best Online Mortgage Lenders
      • How to Get Approved for a Mortgage
      • Best Mortgage Rates
      • When To Refinance Mortgage
      • How much house can I afford?
      • First-Time Home Buying Guide
    • Close
  • Investing
    • Close
    • Best Of
      • Best Investment Accounts
      • The Best Robo-Advisors
      • Best Online Brokerage Accounts
      • Best IRA Investment Accounts
      • Best Roth IRA Investment Accounts
      • Best Investment Apps
    • Start Investing
      • How To Invest
      • Start Investing With Little Money
      • How To Invest In Stocks
      • How To Invest In Real Estate
      • Investing vs. Saving
      • Investment Calculator: How Much Will You Earn?
      • Find A Financial Advisor
      • Robo-Advisors vs. Discount Brokers
    • Retirement
      • The Beginner’s Guide To Saving For Retirement
      • How Much Do You Need To Have Saved For Retirement?
      • How Much Should You Contribute To Your 401(k)?
      • How To Optimize Your 401(k)
      • How To Roll Over Your 401(k)
      • Roth IRA Or Traditional IRA
      • IRA vs. 401(k)
    • Reviews
      • Personal Capital Review
      • Betterment Review
      • Wealthfront Review
      • M1 Finance Review
      • You Invest By J.P. Morgan Review
      • E*TRADE Review
      • Blooom Review
    • Close
  • Insurance
    • Close
    • Life Insurance
      • Best Life Insurance Companies
      • How Much Insurance Should You Have?
      • Term Life vs. Whole Life Insurance
      • How To Buy Life Insurance
      • Life Insurance Cost
    • Home Insurance
      • Best Homeowners Insurance
      • Best Renter’s Insurance
      • What Does Homeowners Insurance Cover?
      • When Should You Make A Claim?
      • What Does Renter’s Insurance Cover?
      • Should You Get Home Contents Insurance?
    • Auto Insurance
      • Car Insurance 101
      • Best Car Insurance
      • Best Car Insurance For College Students
      • Lower Your Auto Insurance
      • Reduce Car Insurance After an Accident
      • Auto Insurance Coverage Types
      • Minimum Auto Insurance Coverage
    • Close
  • Personal Finance
    • Close
    • Your Money
      • How To Budget
      • Best Budgeting Apps
      • How To Make Money Online
      • Should You Finance Or Pay Cash?
      • Set Up An Emergency Fund
    • Your Credit
      • How Credit Works
      • Credit Score Calculator: Get Your Estimated Credit Score Range
      • Best Credit Tracking Apps
      • Fix Bad Credit On Your Own
      • How To Build Credit
      • Improve Your Credit Score
      • Get A (Really) Free Credit Report
    • Your Debt
      • How To Get Out Of Debt
      • How To Consolidate Debt
      • Debt Management Programs
      • Debt-to-Income (DTI) Ratio
      • Debt Snowball vs. Avalanche
      • How To Pay Medical Bills You Can’t Afford
    • Tools
      • Free Budget Template (Google Sheets)
      • Mortgage Payment Calculator
      • Auto Loan Interest Calculator: Monthly Payment & Total Cost
      • Home Affordability Calculator
      • Loan Payoff Calculator: How Quickly Can You Repay Your Loan?
      • Rent or Buy Calculator – Home
      • Buy vs. Lease Calculator – Car
    • Close
  • 573 In Person
    • Close
    • In Conversation With
      • Lemonade’s CEO, Daniel Schreiber
      • Personal Capital’s CEO and VP
      • Bank Novo’s CEO, Michael Rangel
    •  
      • M1 Finance’s CEO, Brian Barnes
      • Find More
    • Close
  • Home
  • >>Spending Less
  • >>Free monthly budget template (Google Sheets)
Advertiser Disclosure The offers that appear on this site are from companies from which 573 receives compensation. This compensation may impact how and where products appear on this site (including, for example, the order in which they appear). 573 does not include all companies or all offers available in the marketplace.
Budget Well
#Spending Less

Free monthly budget template for Google Sheets

Written by

Lauren Graves

  • 50/30/20 monthly budget template
  • 50/30/20 budgeting explained
  • How to create your personal budget template
  • Tips for making the most of your spreadsheet
  • Don’t like using a spreadsheet? Try these budgeting apps instead
  • The bottom line

50/30/20 monthly budget template

Our Google Sheets budget template lets you plug in your income and expenses to automatically calculate how much you have left to spend each month. It helps you see exactly what your income is going toward and shows you if you’re under or over budget as you track your spending.

To get the spreadsheet and start budgeting, simply enter your name and email address below and we’ll send the Google Sheets link right to your inbox!

50/30/20 budgeting explained

This spreadsheet follows the 50/30/20 budgeting method. This is a widely used strategy that’s easy to apply and remember.

Basically, it helps you set priorities in your budget and categorize expenses by breaking your spending into three types: needs, wants, and savings. Then, it gives a different percentage of your income to each of these expense categories.

Here’s how 50/30/20 budgeting works:

  • 50% is for needs. This includes household expenses that may fluctuate (think: groceries and utilities) as well as fixed costs, like insurance premiums or car payments, and other non-negotiables.
  • 30% is for wants. This includes the things you do for fun, such as going to concerts or dining out, and other things that are important to you, like updating your seasonal wardrobe or donating to charity.
  • 20% is for saving. This includes putting money into your emergency fund, investing in retirement accounts, and saving for big financial goals — like the down payment on a car or house.

You can think of your budget as a spending plan. By breaking your total income down into categories, you’re telling yourself how much you can spend in each category — not focusing on what you shouldn’t spend. This can be a helpful perspective if you’ve ever found budgeting to be too restrictive. Spending plans tend to be more realistic for most of us.

Now that you know how a 50/30/20 budget (or spending plan) works, the next step is to personalize the budget template.

How to create your personal budget template

Using the spreadsheet is easy. Follow these steps to make it your own:

  1. Enter your monthly income (after taxes) at the top of the spreadsheet.
  2. Fill in the blanks for your monthly expenses by putting your typical costs in the “Budgeted” column for each category.
  3. Add any categories we missed in the “Other” rows.
  4. Track your actual spending throughout the month in the “Spent” column.
  5. Use the “Leftover Income To Budget” box at the bottom of the spreadsheet to see how much of your total cash you haven’t yet allocated to a budget category (make sure you’re using all of your income!)

What if you don’t really know how much you spend? No worries, just use your transaction history and bank statements to make your best guess for any expenses you’re not sure about.

Once you’ve entered all the values, the spreadsheet will tell you how much you have left at the end of the month. The “Actual Spend” boxes will be green if you’re under budget or red if you’re over budget. If you’re over budget, look for ways to save money and cut your spending.

There are two fields for your actual spend: one that compares your spending to your budget and one that compares your actual spending to your overall income. This is an important difference. Actual spend vs. your budget subtracts how much you’ve spent from how much you’ve budgeted or put into the different budgeting fields. Actual spend vs. your income subtracts how much you’ve spent from your total monthly income.

If you budget all of your income (which you should), these two fields should be the same.

Why you should budget your whole income

Budgeting all of your income is a strategy known as zero-based budgeting and it’s a good way to use your money more efficiently.

If you split 100% of your income across your spending categories — 50% for needs, 30% for wants, and 20% for saving/debt repayment — you’ll know exactly what happens to every dollar at the end of the month so you can feel confident you’ve put all your money to good use. You won’t have to worry about ending up with “leftover” cash and having to decide what to do with it.

What if you’ve budgeted for your wants and needs and don’t know how to use the rest of your money? Try adding it to your emergency fund, investing it, or repaying more of your debt.

Figuring out your wants vs. needs

All of our wants and needs are different, and you might have to tweak the spreadsheet to make it work for you.

For example, maybe travel expenses are actually a “need” for you because you travel for work or a gym membership is non-negotiable. Feel free to play around with the categories and make sure to update them regularly as your personal and financial needs change.

Tips for making the most of your spreadsheet

Once you have your spreadsheet set up, it’s important to make the most of it all year long. Here are a few tips to help you apply your spending plan every month.

Review your budget on a monthly basis

At the beginning of the month, review the money you have for each category and adjust your spending accordingly. If a recurring expense changes or you need to update your income, do it right away.

Track your spending

Log your spending every time you pay a bill or make a purchase. Checking the spreadsheet often is a good way to avoid overspending and save money.

Check in each week

Check in with your remaining totals at the start of each week and identify areas where you might need to cut back. Your budget will only work if your income and expenses are accurate.

Adjust as needed

If your actual costs turn out to regularly be more or less than you estimated, update your budget accordingly. And if something comes up that you didn’t budget for, like an unexpected repair or medical bill, make adjustments to your spending. For example, if you overspend in one category for one month, try to spend less in another.

Stay positive

If you do go over budget one month, don’t let it discourage you. Just do what you can to balance your spending and start fresh next month. Sticking to a budget is hard, but you’ve got this. Remember, it’s about progress not perfection.

Don’t like using a spreadsheet? Try these budgeting apps instead

If you already know budget templates just don’t work for you, you can try an app instead.

There are a number of excellent budgeting apps to help you create a budget, track expenses, and see your cash flow. Many connect directly to your bank accounts to automate your budgeting and categorize your spending habits, so there’s very little setup required.

Here are two of our favorite budgeting apps for everyday budgeting.

PocketSmith

PocketSmith is a beginner-friendly budgeting app and money management tool. It makes it easy to look at your spending habits and think “big picture” about your money.

One way PocketSmith helps you do this is with future forecasting. As you set up your next month’s budget, you can take a look at how small decisions impact your finances six months down the road. Then you can play around with budget categories and read reports to understand how you’re really spending rather than just how you want to be spending.

You Need A Budget (YNAB)

YNAB is a more extensive solution that helps you create a zero-based budget. Zero-based budgeting requires you to give every dollar a job and take tracking your spending to the next level.

To use this app, you’ll set some financial goals and log your spending throughout the month. Then, YNAB‘s reporting tools will help you monitor how you’re doing and show you your full financial picture. This is an especially great option for anyone focused on reducing their debt.

The bottom line

Budgeting can be as simple — or as complicated — as you want to make it. Our budget spreadsheet is designed to be as easy to use as possible and to take the guesswork out of budgeting. Get out of debt, understand your spending habits, and meet your savings goals by taking care of your budgeting.

Read more:

  • How to make a budget: Our step-by-step guide to managing your money
  • What does a realistic budget look like?

About the author

573 Staff

Read more from this author
 

Editor’s Note:

This content is not provided or commissioned by the bank, credit card issuer, or other advertiser. Opinions expressed here are author's alone, not those of the bank, credit card issuer, or other advertiser, and have not been reviewed, approved or otherwise endorsed by the advertiser. This site may be compensated through the bank, credit card issuer, or other advertiser.

Budget & Save

  • Saving Accounts
  • Checking Accounts
  • Investment Accounts
  • Find A Financial Advisor

Saving Goals

  • Quiz: Are You Saving In The Right Place?
  • How Much Should You Save?
  • The Bank Account BufferTM
  • Emergency Funds

Best Savings Accounts

  • Capital One 360
  • Discover Online Savings
  • Best High Yield Savings Accounts

Best Checking Accounts

  • Aspiration
  • Chime
  • Best Free Checking Accounts
  • About us
  • Contact us
  • Privacy Policy
  • Press
  • Ad Choices
  • Do not sell my personal information
USNews chicago_tribune forbes kiplinger new_york_times npr usa_today yahoo_finance
General Disclaimer: See the online credit card application for details about terms and conditions. We make every effort to maintain accurate information. However, all credit card information is presented without warranty. To confirm terms and conditions, click the "Apply Now" button and review info on the secure credit card terms page.

View our Privacy Policy | View our Terms of Service XL Media, C/O FIRMSPACE 500 W 2ND ST SUITE 1900, Austin, TX 78701, United States

Advertiser Disclosure: The offers that appear on this site are from companies from which 573 receives compensation. This compensation may impact how and where products appear on this site (including, for example, the order in which they appear). 573 does not include all companies or all offers available in the marketplace.

Editorial Disclosure: This content is not provided or commissioned by the bank, credit card issuer, or other advertiser. Opinions expressed here are author's alone, not those of the bank, credit card issuer, or other advertiser, and have not been reviewed, approved or otherwise endorsed by the advertiser. This site may be compensated through the bank, credit card issuer, or other advertiser

Disclaimer: The content on this site is for informational and educational purposes only and should not be construed as professional financial advice. Should you need such advice, consult a licensed financial or tax advisor. References to products, offers, and rates from third party sites often change. While we do our best to keep these updated, numbers stated on our site may differ from actual numbers. See our Privacy Policy & Disclaimer for more details.

User Generated Content Disclaimer: The comments below each article are not provided or commissioned by the bank advertiser. Responses have not been reviewed, approved or otherwise endorsed by the bank advertiser. It is not the bank advertiser's responsibility to ensure all posts and/or questions are answered.