Tutorial to Create a Zero Based Budget in Google Sheets

Tutorial to Create a Zero Based Budget in Google Sheets | Start a Budget with Google Sheets

Рет қаралды 13,183

Күн бұрын

Want to start a budget from scratch right now? I’m going to show you how to make a zero based budget in google sheets in 32 minutes.
If you’re not a DIY budget kind of person, you can get a fully functioning budget spreadsheet in google sheets for just $5.
mrjamiegriffin.thrivecart.com...
Zero Based Budget Spreadsheet Templates
50/30/20 Budget Spreadsheet: mrjamiegriffin.thrivecart.com...
Annual Budget Spreadsheet: mrjamiegriffin.thrivecart.com...
Monthly Budget Spreadsheet: mrjamiegriffin.thrivecart.com...
A zero based budget helps you be proactive and intentional with your money. You can use google sheets to plan out your budget and automate your calculations. This Google Sheets zero based budget tutorial will teach you how to make a budget that works for your life, and accounts for all of your budget categories - needs, wants, and savings. This how to make a budget tutorial covers every step of making a budget spreadsheet using Google Sheets.
Jump Links
0:00 Intro
1:51 Example of Finished Budget Spreadsheet
4:17 Initial Budget Setup
8:13 Setting Up Income Streams
9:28 Using Spreadsheet Formulas for Auto-calculation
10:24 Format Budget Spreadsheet as Currency
11:20 How to Duplicate Spreadsheet Formulas
12:08 Calculating Yearly Totals (with formulas)
14:26 Calculating Your Total Income
16:28 Set Up Your Savings Goals (Sinking Funds)
18:07 Fixed Expenses Set Up
19:15 How to Adjust Formulas
21:30 Setting Up Your Flexible Expenses
25:45 How to Calculate Total Expenses and Net Income
28:18 Color Formatting to Make Your Budget Look Pretty
31:21 Conclusion and Wrap Up
My FAVORITE budgeting and getting debt free tools
Qube Money digital cash envelopes to save money - bit.ly/3kvmRBf
Tiller Automated Budgets - • Tiller Money - Create ...
Sinking Fund Spreadsheet for $10 - mrjamiegriffin.thrivecart.com...
Sinking Fund Tracker Printables - www.etsy.com/listing/14708374...
Join the Debt Free Community (free private FB group) - / getdebtfreecommunity
Help Getting Out of Debt
The Debt Free Playbook: mrjamiegriffin.com/debt-free-...
Debt Snowball Spreadsheet (free download) -
www.mrjamiegriffin.com/debtsn...
Related Videos -
What are Sinking Funds? How to use Sinking Funds in Your Budget - • Sinking Funds Explaine...
3 Must Have Budgeting Categories Every Budget Should Have - • 3 Budget Categories Yo...
Save More Money with SaverLife - • SaverLife Review - Sav...
Start the Cash Envelope System - • How to Start the Cash ...
Subscribe to my channel bit.ly/mrjamiegriffin
Read more on how to budget, save money and get debt free:
www.mrjamiegriffin.com
Let’s Connect
Instagram: / mrjamiegriffin
Facebook: / mrjamiegriffin
Twitter: / mrjamiegriffin
Etsy: www.etsy.com/shop/mrjamiegriffin
Affiliate Disclosure - some of the links in the description or mentioned in the video are affiliate links. If you sign up through my link, I’ll get a small commission at no extra cost to you. I only recommend products that I think are awesome and that can change your life. Get more information on affiliates here - mrjamiegriffin.com/disclaimer/

Пікірлер: 31

@Thinknappythoughts 2 жыл бұрын

This was extremely helpful...I scoured KZfaq for something that fits my needs and you nailed it for me. Thanks a million!!!!

@MrJamieGriffin 2 жыл бұрын

Yes! That’s so good to hear!

@a476716048 3 жыл бұрын

Amazing! Thanks for showing this to everyone!

@MrJamieGriffin 3 жыл бұрын

You’re welcome! Happy it’s helpful!

@josephbaumann292 Жыл бұрын

Great budget and explanation, thanks! Can’t wait to use it.

@MrJamieGriffin Жыл бұрын

Happy to help! Hope the new budget is exactly what you need!

@cindyodonnell6057 2 жыл бұрын

Thank you for doing this video! I learned quite a bit and it will be extremely useful for me! Thanks again and I look forward to watching your other videos!!

@MrJamieGriffin 2 жыл бұрын

Hey Cindy! Happy to help and glad the tutorial was helpful! Are there any other budget videos you’d like to see?

@tubann4 Жыл бұрын

Tack försökt göra en bra budget länge, denna var precis vad jag ville ha 😍

@MrJamieGriffin Жыл бұрын

Glad it helped!

@THEBLKYOGI Жыл бұрын

You are great I appreciate you. This will help me and my family tremendously!

@MrJamieGriffin Жыл бұрын

I’m glad the video was helpful! Best of luck budgeting!

@totalmaeoz 2 жыл бұрын

this is exactly what i needed!! thank you! im going to follow your page

@MrJamieGriffin 2 жыл бұрын

Awesome! So glad it helped! Let me know if there are more budget or Google sheet videos you want to see!

@thepowerofvoiceofficial 7 ай бұрын

I REALLY like this layout!! Thank you for sharing this video with us!!

@MrJamieGriffin 7 ай бұрын

You’re welcome! I’m glad you love the layout. I love having all months in one tab that I can see and compare easily.

@brianenergi3367 Жыл бұрын

Great video! Thanks :)

@MrJamieGriffin Жыл бұрын

You’re welcome!

@tracypeel6424 Жыл бұрын

Thank you for this. I had to swop the Total year and Average per month because I kept getting something about a circular formula but I like it like that anyway!

@MrJamieGriffin Жыл бұрын

+Tracy Peel you’re welcome! I’m glad you found a tweak that works even better.

@jamestrowbridge Жыл бұрын

If you highlight all of the columns, then double click (or manually size by dragging) the line between the columns, they will all maintain/change to uniform widths.

@MrJamieGriffin Жыл бұрын

Thank you! It took me way too long to figure that out 😁

@romanacvn 2 жыл бұрын

keep getting Sorry, you can't freeze columns which contain only part of a merged cell. Try to break apart merged cells or freeze more columns to include the complete merged cells.

@MinnieOnCam 2 жыл бұрын

I have conditional formating in my net income that way it will show as red if I am below $0

@MrJamieGriffin 2 жыл бұрын

That’s a great idea Minnie! It creates a simple but powerful visual!

@dfjama 11 ай бұрын

Thanks Jamie for this video, I have a question though about the meaning of the Normal Month column. Can you please explain?

@MrJamieGriffin 11 ай бұрын

Absolutely. The Normal Month column is meant to be a month of typical, expected expenses. When you set up your budget, this is where you’ll enter your expected budget for each expense and income. This gives you a way to compare each month of the year to your expected budget.

@dfjama 11 ай бұрын

@@MrJamieGriffin Thanks again for the quick response. If I need only income vs expense without budget vs actual what change do I need to make in the template?

@MrJamieGriffin 11 ай бұрын

@@dfjama it sounds like you don’t want the Normal Month column then. If that’s the case, just don’t put that column in the spreadsheet.