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

preview_player
Показать описание
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.

Zero Based Budget Spreadsheet Templates

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

Help Getting Out of Debt
Debt Snowball Spreadsheet (free download) -

Related Videos -

Read more on how to budget, save money and get debt free:

Let’s Connect

Рекомендации по теме
Комментарии
Автор

Amazing! Thanks for showing this to everyone!

a
Автор

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

Thinknappythoughts
Автор

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

tubann
Автор

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

josephbaumann
Автор

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

totalmaeoz
Автор

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

thepowerofvoiceofficial
Автор

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

THEBLKYOGI
Автор

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!!

cindyodonnell
Автор

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!

tracypeel
Автор

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.

jamestrowbridge
Автор

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.

romanacvn
Автор

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

dfjama
Автор

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

MinnieOnCam
Автор

Can you share template for mac users? like in google doc or something

joyboy