I'll walk you through our free Google spreadsheet template for crushing financial goals. In eight steps, we'll cover income, expenses, sinking funds, and more. Download the template from the link below, subscribe for tips, and let's start your journey to financial freedom!
-------- 📒 I wrote a kids book and it's available on Amazon! Get your copy of Investing for Kids: 65 Activities about Saving, Growing, and Investing Your Money: https://amzn.to/3CRNkp1
-------- If you're paying more than $35/month for your cell phone, you're doing it wrong! Check out Mint Mobile (the cell phone carrier that I use, and keeps it budget-friendly!) - http://fbuy.me/ujCzy
Disclosure: Links contain affiliates. When you buy through one of my links, I will receive a commission. This is at no cost to you and helps support my channel!
whether you're getting started with
budgeting for the first time or you're
simply looking for a new tool to help
you achieve your financial goals stick
around because in this tutorial we're
going step by step using a free Google
spreadsheet template that you can also
download as an Excel file to help you
crush your financial goals stick
[Music]
around hi guys welcome my name is
Justine I'm the host of Deb free
Millennials Channel and here we talk
about all ways to help you crush debt
Achieve Financial confidence that leads
to more fun and fewer payment if you are
into that lifestyle or finances is
something that you want to work on for
this year go ahead and click subscribe
we are going to be walking through my
budget template so let's go ahead and
get started by clicking the link in the
description box below where you can
access this toolkit for free and I'll
also land you on my newsletter so that
you can continue to get personal finance
tips for me so let's get started to get
started with editing this template
you'll want to make sure that you click
on on inside of Google Sheets you'll
want to click on file and then make a
copy and then rename it and save it to
your own Google Drive the master cannot
be edited because obviously everybody's
accessing it so what I find when it
comes to achieving financial goals is
writing everything down has been so
helpful for me it helped me pay off
$35,000 in student loan debt because I
had the awareness of the income and
expenses happening every single month so
I've broken this down into eight
different Steps step one is filling out
the financial inventory tab this is a
new sheet that I've included for this
year and what it does it actually helps
you figure out okay what are my monthly
income and expenses across the last 6
months this does require you to open up
your credit card statement or any bank
account statements and take a look at
okay these were my paychecks for months
1 through six getting an average of your
income and your fixed and discretionary
expenses is really going to help you
figure out okay okay realistically I'm
spending $3,500 on my fixed expenses
this is what I need to budget for when I
say fixed expenses I mean known bills
that you pay every single month that
generally cost the same amount month to
month things like rent or morgage
payment any insurance premiums utilities
internet cell phone things that you know
that are going to be consistent belong
the fixed expense category discretionary
expenses is all of the fun stuff
subscriptions clothes outing
entertainment restaurants that would
live in the discretionary expenses
anytime that you see a formula in a cell
please do not delete the formulas are
there to help you so that you can
automatically calculate this out
yourself so if you had a
$5,500 income for month one it's going
to show you the net let's say our
expenses were 2400 discretionary
expenses was $2,000 and you'll see a net
of $1,100 if you went over then you
would see a negative amount so you're
going to fill that out as best you can
so that you can get the most accurate
average as possible next you're going to
fill out any savings so including
emergency fund or a new car adding the
bank name the current balance then
you'll fill out any known debts here and
then also any type of investing accounts
that you might have such as a 401k or a
Roth IRA including the amount and then
any assets that you have including a car
house jewelry furnishings and so forth
as you are working through this I've
included a small net worth table here
for you so that you can quickly see okay
these are my assets what I have what
kind of cash and Investments I have on
hand minus my liabilities my debt what I
owe to get your net worth the next step
step two is filling out the yearly
glance table I love this because then it
takes a look at your income and expenses
for 12 months this is a great way for
you to estimate how much you're spending
on each of these budgeted categories
let's walk through the first table the
first table up at the top is for your
debt list any known debts here including
your monthly payment what your total
outstanding balance is and the interest
rate again anytime you see a calculation
in one of these cells do not delete it's
going to automatically calculate that
out for you the next table you want to
pay attention to is your income table so
this is going to show you exactly what
that monthly income is if it's $6 000 or
maybe it's different you make a change
here $8,000 and it's automatically going
to calculate that yearly amount for you
down below you're going to see the
budget table this is going to look
consistent across the yearly glance Tab
and what I have for your actual monthly
budget you're going to be spending the
majority of your time within the month
monthly budget template but for the
yearly glance tab what I like about this
is it's going to show you a percentage
of what you're spending on each of these
EXP expenses so it's going to have your
monthly and then your yearly so simply
fill out every single expense that you
have for the month if you have something
that's not listed here go ahead and add
it to each of these sections or delete
something that you don't pay for let's
say you don't pay for trash and
recycling you can always delete that and
make this customizable for yourself the
way that I have my budget broken down is
into four major subsections fixed fund
fudge and future let let's go over each
of those first is fixed those are any
expenses that I was mentioning that you
know are consistent month over month in
this example I have rent mortgage cell
phone internet groceries I include as a
fixed expense because I know I'm going
to be buying groceries every single
month I also included all your utilities
any car related expenses and insurance
this is separate from your debt table
this is why the debt lives up at the top
it has its own home next is your fund
money spending and if you have any
questions about what the these labels
are I went ahead and added descriptions
as a note for each of those sections so
the fund money section are any expenses
that are not essential but are nice to
have you don't need to spend money on
any of these categories every single
month but do allow yourself some fun I
am not a scorched Earth approach person
when it comes to personal finance I
truly believe that you can pay off your
debt while enjoying your life and
spending intentionally on the things
that you love which is why this is a
major category inside of my budget
template things like restaurants
shopping clothing and haircut all live
within the fun section next is fudge
fudge is not chocolate this is my little
tribute to Ralphie from A Christmas
Story where he goes oh fudge it's all
the miscellaneous things that you're
like oh I forgot about that or simply
adding in a buffer to your budget if you
spent over a different category let's
say you went over in restaurants you can
simply move that buffer amount of money
over to the restaurant category for
example so always allow a little bit of
buffer in your budget to help with
things future is is any outside savings
and investing that you're doing outside
of what you're doing pre-tax things like
a 401k contribution do not belong in
this section because this is your after
tax dollars that we're actually
utilizing for any type of savings like
an emergency fund car a vacation or
maybe saving for a down payment or doing
any outside investing outside of a 401k
things like a Roth IRA or a brokerage
account that you're utilizing take home
pay income for would live in the future
section another thing that's new this
year is I've included a chart to show
you visually how your money is broken
down and what your money goes towards so
in this example you can see that the
rent or mortgage was around 42% 41.7 I
round it up here in the in the chart to
show you exactly how much piece of the
pie it's getting you'll want to make
sure especially with rent or mortgage
payments I'm going to add a little tip
here that payment should be no more than
25 to 35% of your take-home pay most
people living in high cost of living
areas places like New York Los Angeles
San Diego are going to see their rent or
mortgage payment on the higher end of
35% or a Teensy bit more those who are
living and lower cost of living areas
places like the Midwest small towns are
going to see it more like less than the
30% Mark like 28 26 to 25% would be
amazing just to give you a benchmark of
where you should be at with your
percentages in your budget also if you
want to see percentages of a realistic
budget you can check out that video up
here in the cards let's take a look at
where you'll be living for the majority
of your time when you're doing the
budget template so this is the uh
monthly budget I included a blank
version but I'm going to show you the
example to give you a sense of how this
is broken down again you're going to see
all your debt listed out in the debt
table up at the top all of your debts
should be listed here including the
minimum payment where you actually pay
total outstanding balance I also knew
for this template for this year because
I was seeing a lot of my private
Financial coaching clients adding due
dates to the leftand side of each of
their expenses I thought I might as well
add that so the DD means due date of
when these payments are due to help you
keep track of things every single month
so for the January monthly example we
could put a due date of the 25th and
then you're going to see how that lines
up within the month and then if you want
to get real detailed with it as soon as
you make a payment you can just x that
out as it's been paid and then again
you're going to see the income what I'm
calling the income table in the planned
category you're going to estimate how
much you think you bring in each month
if you're a W2 income earner this going
to be really simple your paychecks are
probably the same if you're
self-employed you have a side hustle you
work hourly you get overtime pay this
could change and fluctuate which is why
it's so important to fill out the
financial inventory to get a sense of
what your average income is over the
past 3 to 6 months I put 6 months
because that's going to give you the
most accurate average 3 months would
also work really well here too your
planned columns here for the income and
here right here for the expenses is what
you're going to do at the beginning of
the month prior to you actually going
through this you're going to make a plan
at the beginning of the month or at the
end of the previous month of what's
coming up for this new month that I need
to prepare for and what do I want to set
aside MoneyWise for each of these
expenses maybe you've been having a a
really high grocery bills and it's like
$800 $900 for a family of two or three
and maybe you want to budget for
something like $600 you can see how that
updates things so if I put $600 here
you're going to see in this plan buttg
it's actually going to give me a
negative amount this should be as close
to zero as possible this is called zerob
based budgeting where income minus
expenses minus your monthly savings
whatever that net amount is should be as
close to zero as possible because we
want every dollar to have a name and an
assignment so it has a job that way
you're not accidentally spending money
that you wanted to earmark for your
emergency fund or pay for a new
subscription you've got it covered
because you are telling your money
exactly where to go very intentional
you're going to that's kind of the step
one of filling out the monthly budget
template the step two is as you're
actually going throughout your month
you're going to put in the actual column
what you actually spent in each category
if you are making multiple purchases
within one category what I like to do is
up here at the top I hit equals and then
I add every single transaction action
that I've made at the grocery store or
any toiletry related expenses and then
sometimes what I'll do is I'll highlight
the row I will add um insert a note
insert a note and then I'll say okay I
went the first expense was for Costco
the last two expenses were from Kroger
that way I know exactly where that
amount of money is coming from it's just
a really great visual for me to see okay
this is where this money is from and
this is what I have to work with the
next column that I have after actual is
spent from syncing funds if you are
setting up syncing funds where you are
conting money into every single month
and then you want to go ahead and
withdraw and spend from that syncing
fund this is where you can record that
transaction so for example and then
before I get into that let me also
explain running totals if you have any
money left over that you want to roll
over into the next month then you can
add it to the running total that way if
you've let's say earmarked in this
example clothing and you want to go
ahead and roll over any money that you
didn't spend from your $200 clothing
budget into the next month it's going to
record that here for you so any of those
calculations keep that so that you can
see how that Stacks up over time so
here's an example of how you use spent
from syncing funds in the running total
so you can see on shopping let's say I
want to earmark the
$300 but I actually spent from my
syncing fund of $300 $150 I can record
it as I spent $150 from this shopping
syncing fund and now I have $150 left to
work with this is really useful for
things like even car insurance or car
maintenance where you want to set aside
money every single month but you may not
be spending money on it every single
month okay next is your pre-tax paycheck
contributions you can record any pre-tax
paycheck contributions that you can see
so you have the awareness of what you're
actually spending on things like health
insurance 401K dental and vision
insurance this is really useful just to
have it in the front of your mind for
the next open enrollment period I've
also included a note section here for
you make any notes about what's
happening at the start of the month you
know maybe there's an upcoming birthday
or a vacation that's going to change
your budget reflect on any obstacles or
wins that you had at the end of the
month and then prepare and plan by
making notes for next month that you
need to prepare for what's also new for
this budget template this year is I've
included a handy chart to show you
exactly how you spent your money within
the month I find that these visuals
again are super helpful just to see how
your money how your spending money
breaks down per category so that you can
make smarter finan cial decisions in the
future so in this example I have it all
filled out for you you'll actually want
to get started by using the blank
monthly template so that you can fill it
out for your needs and if you're
wondering Justine why didn't you include
January through December include 12 tabs
of the template it's because I know
you're probably going to make major
adjustments to the tables here and
rather than you doing that 12 different
times all you need to do is update this
blank template click the arrow and then
click duplicate and then you're going to
label this January or October or
whenever the heck you're starting this
thing and then I update it for the
January budget and then it's going to
have all of your pre-filled budgeted
items including the planned amounts here
because you filled it out in the blank
tipet first that's a look at how you use
my very simple budget template and this
is a simple tutorial let me know if you
are using this budget template this year
to help you with your finances I
personally love it I still use it me and
my husband use it every single month in
our beers and budgeting episode and it's
the tool that I use with all my
one-on-one Financial coaching clients if
you would like access to this template
for free you can download it using the
link below give this video a big thumbs
up if you thought this was helpful for
you and motivating you to attack your
personal finance goals for this year and
I'll catch you in the next one
[Music]
yeah