Family home budget spreadsheet how to#
Family home budget spreadsheet full#
Family home budget spreadsheet software#

Remember, IвЂ™m using completely random numbers here.ДЄgain, use the вЂњSumвЂќ function to see the total of all those monthly expenses. ItвЂ™s greatВ to use your credit card/debit card statements as a reference, and go through old receipts. STEP 9:В Finally, itвЂ™s time to calculate all your months expenditures - everything from rent, to groceries, to utilities, dog food, cell phone bill, shopping, etc. To do this, create a new cell called вЂњRemaining Total.вЂќВ This formula is very easy to create.В Just hit the equal sign symbol (=), select your first вЂњtotal,вЂќ hit the minus symbol (-), and then select the вЂњtotal savedвЂќ number to see what you have left in your budget. STEP 8:В WeвЂ™re nearly done now! The next step is to subtract your take-home pay from what youвЂ™ve portioned out for savings. See below for reference of what it should look like. When youвЂ™ve finished that, go ahead and create another вЂњTotalвЂќ cell where you can see what those numbers add up to by using the same addition formula shown in Step 6. Go ahead and extrapolate this out for every category of automated savings you want/need. Check out the five step image below of how I navigated through this portion of the budget. Simple math! This formula will displayВ the total amount of money you should put away to meet this savings goal. In this this case itвЂ™s 20%, so youвЂ™d multiple by. Next, select your gross income total, hit the вЂњ*вЂќ key (which stands for multiply, and put in the percentage youвЂ™re multiplying it by. Simply click on the cell where you want the total to appear, and hit the вЂњ=вЂќ sign ( all formulas start with a вЂњ=вЂќ). This makes it easy to see how much you need to put away. STEP 7: You can calculate these percentage out of your gross monthly income very easily. To illustrate this step for our purposes today, I setВ 15% of the monthly income to be portioned directly intoВ savings, 5% for 401k, and another 5% for the safety net. These percentages will vary for everyone depending on what their goals are and how aggressively they save for retirement. For example, organizing how much you portion out of each paycheck for savings, retirement savings, and your safety net. STEP 7: Now, we can move onto the automatic savingsВ sectionВ of your monthly budget. This is what it looks like with real (althoughВ completely arbitrary) numbers. Simply hold downВ the control key, and select the columns which will make up that вЂњTotalвЂќ number. STEP 6: After youвЂ™ve selected the вЂњSum optionвЂќ from the вЂњFunctions tab,вЂќ youвЂ™re good to go. Navigate over to the вЂњFunctionsвЂќ icon located on the right-hand side of your screen. STEP 5:В Next, select the cell where you want the вЂњTotalвЂќ to appear - weвЂ™re going to create a very simple formula that will calculate the total and does the math for you.

Family home budget spreadsheet full#

Step 4: Add a вЂњTotalвЂќ cell at the bottom so you can see what youвЂ™ve brought in that month in full (IвЂ™m using totally random numbers here for the purpose of this post). These numbers should reflect your income after tax. Step 3: In the column over, add the numbers that correspond to each source of income. If youвЂ™re a freelancer, this section willВ most likely look different each month,В but leave yourself enough room to add and remove items as needed. STEP 2: Create a column, label it вЂњIncome,вЂќ and list out all your sources of income. STEP 1: Open up Google, head to your Sheets page, create a new sheet, and name it.

Here we go - read on for my Excel budget template!

Family home budget spreadsheet how to#

Again, this is being done through Google Sheets, so youвЂ™ll have to have a Google account to use this feature.ДO NOT be intimated by the number of steps or photos! Seriously, I see these guides online and IвЂ™ll scroll through and think I could never understand them, but itвЂ™s really very easy once you understand how to set up basic formulas. Today, IвЂ™m going to take you through creating a budget in Excel for the purpose of tracking your monthly budget which will include: tracking your income, seeing how to track your savings goals, and tracking/organizing your expenses.

Family home budget spreadsheet software#

Personally, I use Google Excel Sheets to manage my expenses because IвЂ™m honestly too lazy to download the software to my computer.В ItвЂ™s also simpler to manage and keep track of everything since itвЂ™s stored in the cloud, and I have access to it whenever wherever. However, this is simply what works best for me, and I encourage you to try out some different options for yourself. Now, a lot of people prefer using apps to manage their budgets, and there are truly a ton of them out there. We talk a lot about managing budgets here at TFD - Chelsea and IВ even made a video about it.В Today, IвЂ™m going to go into more granular detail as to how one can actually createВ a monthly budget using my personal favorite method - Excel Sheets.