- #Personal budget on excel how to#
- #Personal budget on excel full#
- #Personal budget on excel download#
And your monthly expenses add up to $4,500.
For example: let’s say your total monthly income is $5,000.Just below that number, write your total monthly income so you can compare the two numbers.This will tell you exactly how much money you’re projected to spend for that month.Just as a note, if you have a heading at the top of each column, then your formula will start at B2, not B1. You’ll also need to adjust the formula depending on how many line items (categories) you have.įor example, if you have 30 lines of expenses, your formula would read: =sum(B2:B30). Step 3: At the end of Column B, you’ll need to plug in the formula, =sum(B2:B19) in order for the spreadsheet to tally up your expenses. After all amounts are listed, you’ll be able to see if you have a deficit or an overage in any particular category.Step 2: In Column B list the amount of each bill, or the amount of money you’d like to budget for that category. I usually like to call this one Miscellaneous. Some categories can act as an umbrella covering things like going out to eat, movies, entertainment, etc.Be sure to list ALL of your family’s expenses including everything from monthly bills to dance classes to overall categories like pets or vacation savings.Edit the categories to reflect your family’s needs. Ready to get started? How do I make a family budget spreadsheet? Step 1: In Column A you’ll see sample categories listed. If you are unable to open a PDF, you can draw out a template (based on the instructions below) and fill it in for now, until you are able to create a digital one. Keep the spreadsheet open in another tab as we work step by step to get your family’s monthly budget set up. Once in your program of choice, type out your own monthly template based on the sample I provided.You also can use this as a printable, but personally I find that it’s more efficient to use the computer.After downloading the template, you’ll want to open up Google Sheets or Microsoft Excel (or whatever program you have where you can create spreadsheets).
#Personal budget on excel download#
Before we get started: download your free printable budget template (no need to subscribe or anything). Now that we have our monthly income in mind and the components of a family budget (bills/expenses), we can create a plan. How I Do Our Family’s Monthly Budget (with free excel template)
#Personal budget on excel full#
You can read our full disclosure policy, here.
#Personal budget on excel how to#
Related: How to Afford to be a SAHM on One Income
This strategy will change your life when it comes to budgeting.īut first, you should know I am not a financial planner, expert, or anything of the sort! Just a mom like you who has to wear a million hats while managing a family.Īs a stay-at-home mom, I am responsible for various aspects of our daily lives:Īnd my husband is responsible for a different set of duties: I’ll walk you step by step through how I created my monthly excel spreadsheet in Google Sheets, to how I maintain our family’s budget once a month. Today I’m going to share my simple budget strategy with you. Get my free printable excel budget template to help keep you on track. Inside: Learn how I do our family’s monthly budget ! Keeping track of household expenses is essential.