Now for part 3! I hope that part 2 will make a little more sense in this part. We left off making the tithe tracker for those of you who tithe part of your income. Next we'll work on setting up each month and making totals for the end of the year.
21. Starting in cell C2 you'll want to type in January. Then click on the bottom right corner of the cell and drag until cells are filled with February through December. To do this you want to make sure your cursor looks like a small plus sign (+).
22. Then you'll want to scroll to the bottom of the spreadsheet and you'll want to copy over from column B all the way to column N for each of the totals. This is what your spreadsheet should look like.
23. Now scroll up to the top of the spreadsheet and we'll work in column O. You'll name cell O2 Expected Yearly. And then in cell O3 type in the formula =B4*12 and copy this down to the cell right above Total Income Before Tithe. This will tell you what your budgeted yearly amounts are in each category.
24. Next you can copy the totals formulas in rows 24 - 41 over to column O as well.
25. Next you'll want to name cell P2 Actual Yearly, this will show the total spent in each category over the whole year. The formula in cell P4 will be =SUM(C4:N4) or the sum of January through December in that category. Then you can copy down to the cell above Total Income Before Tithe. And then you can copy over the Totals at the bottom over to column P as well.
26. The spreadsheet is almost complete but you'll want to make a couple changes in columns O & P, scroll to the bottom to view the lines Made More and Spent Less. You'll want to change the formulas in these columns. O31 should have the formula =O24-$O$24 and then you can copy over to P31.
27. Next change the formula in O33 to =$O$27-O27 and then copy over to P33.
And that's the whole spreadsheet! I hope the pictures helped further explain the steps. I don't think it's too hard to make once you get started. Each month, Josh and I used our tracked expenses on Mint to fill in the income and expenses for that month. Then we make sure that we didn't spend more than we made, that we use any money we made more than we thought to make a contribution to our goals, and we check to see if we spend less than we thought. The spreadsheet helps us look at what Mint tracks for us. I'll do another blog soon to show our monthly process. Please comment or send me an email or direct message if you have any questions, I'm happy to help!
Click here to look at the spreadsheet created in this tutorial.
Showing posts with label Personal Finance. Show all posts
Showing posts with label Personal Finance. Show all posts
Sunday, January 14, 2018
Saturday, January 13, 2018
How to Make a Budget in Google Sheets Part 2
The first part of this series was fairly easy to do but I think this part will be a little bit more challenging to explain. Get ready!
11. In the last part we set up our budget amounts. So each month, before we can spend, we take out a percentage of our money and give it to our local church. In our budget we have two income spots, income before tithe and income after tithe. Income after tithe is what we will use to cover our expenses each month. If you don't go to church you can skip the tithe line. After putting in budget amounts I add formulas to total up the income and expenses. In the Before Tithe section I use the formula: =SUM() And in the parentheses I highlight the cells for income. In this example the formula looks like =SUM(B4:B5)
12. Next I use the formula =SUM(B4:B5)*.10 in the tithe category to show that we are taking 10 percent out of our income to give to the church.
13. The next formula simply subtracts the tithe line from the income before tithe line. You subtract by typing the formula =B24-B25
14. Next on the Total Expenses line you want to use the same formula as Step 11 except this time use it to total the expenses. =SUM(B8:B22)
15. Now after we have figured out the total income and expenses we add in some other formulas below those. The first we add is cashflow, this line shows us if we spent more than we made. We always want this line to be a zero or a positive number. This formula subtracts total expenses from total income after tithe. =B26-B27
16. Now in our example we have a negative number on that line because we didn't account for giving a tithe. So if you have that in your budget as well, now is the part where you might feel the sacrifice of tithing (which is a good thing). You'll need to adjust your budget amounts so that line equals zero. You want every dollar to be accounted for so don't make it a positive number either. It will hopefully be a positive amount in the monthly sections but this is still the budgeted portion of the spreadsheet.
17. Next Josh and I always add a line that subtracts budgeted income from actual income. We use this line to tell us if we made more than we thought and then we use that amount to make a contribution to some of our goals. In this example we'll use the extra money to go towards an emergency fund, which is the first step of Dave Ramsey's 7 Baby Steps for Getting out of Debt . The formula used here is =B24-$B$24 Use the dollar sign to make that second cell permanent so that when we copy this formula into the monthly totals, it will stay the same for each cell. If you don't, it will make the formulas inaccurate in later steps.
18. Next we make line to know if we spent less than we thought. This was a line we made just to remind us to keep that amount in our bank account as roll over for the next month. This subtracts actual from budgeted. The first cell in this formula will be the permanent one. =$B$27-B27
19. 2 more steps for this part! After this I add a tithe tracker so that we make sure we give what we're committed to giving and this year we're going to try our best to keep up with it each week. It's not too difficult to make. I label the start of it Tithe Tracker and the cell to the right has a formula that links this cell and the tithe cell.
20. Then in the leftover cell I create a formula that subtracts each weeks contribution from the tithe amount. =B35-SUM(B36:B40)
I hope this part was well explained part of this might make more sense as week keep going. On to Part 3!
Friday, January 12, 2018
How to Make a Budget in Google Sheets Part 1
In my first personal finance post I said I had plans to write a tutorial on how to create a budget spreadsheet using Google Sheets. Well, here it is...1 year later. Josh and I just redid our budget for this year and I'm motivated again to keep using the format we have and maybe in another year I'll share with you how we use this every month. LOL. This will be the first post of several for the tutorial. I decided to do this in parts just so it isn't too long, they will all be linked together so finding the next part will be easy.
1. First you will want to open up a new page in Google Chrome and click on the 3x3 squares next to "image" in the top right hand corner.
2. After clicking on the squares a drop down menu will appear and you'll want to select "Drive". If you don't already have a Google account, selecting "Drive" may have you create one (it's free so go ahead and sign up!).
4. Once you have opened your new Google Sheets you can name it at the top by clicking on "Untitled Spreadsheet" and typing in whatever name you want to give the document.
5. I also like to give the spreadsheet a title in the cell A1. But that's just me, you don't have to add that! My font size is 18 for those of you that want to know, and I extend the right side of the cell by clicking on the right line and dragging it.
6. Next I like to freeze columns A and B and rows 1 and 2 so that I can see them at all times. This is done by selecting row 1 and dragging down to row 2 so that both rows are light blue. Then in the ribbon below the title of your spreadsheet, select view, freeze, and 2 rows.
7. You'll know that you have done it correctly when a gray line appears under row 2.
8. Repeat steps 6 on columns A and B to complete the freeze panes but instead of choosing "2 Rows" choose "2 columns". You'll know you have done this correctly when a gray line appears at the right edge of column B.
9. Next I like to add my headings for the budget categories. I'll also write a blog soon on the different budget categories you might want to think about and the categories we use in ours. Starting in cell A3 I list out the different types of income and then in the column following I list out the different types of expenses. You can be as creative as you want with the formatting, I like to make ours easy to look at.
10. Next in column B you can add a header for Expected Monthly amounts and add in the dollar amounts that you'd like to see spent or earned in each month for the year. In following parts we'll work on making sure your amounts are accurate. (I also went back later and added dollar signs to the expenses amounts).
There are the first ten steps! Stay tuned for Part 2. In total, including writing this post and capturing the screen shots while making the budget, these steps only took me 1 hour. So think how quick and easy it will be when you don't have to write out the steps and think about how to explain the process! Let me know if you have any questions or suggestions!
1. First you will want to open up a new page in Google Chrome and click on the 3x3 squares next to "image" in the top right hand corner.
2. After clicking on the squares a drop down menu will appear and you'll want to select "Drive". If you don't already have a Google account, selecting "Drive" may have you create one (it's free so go ahead and sign up!).
3. Clicking on "Drive" will bring you to this screen. You'll want to choose the blue button "New" and then click on "Google Sheets".
5. I also like to give the spreadsheet a title in the cell A1. But that's just me, you don't have to add that! My font size is 18 for those of you that want to know, and I extend the right side of the cell by clicking on the right line and dragging it.
6. Next I like to freeze columns A and B and rows 1 and 2 so that I can see them at all times. This is done by selecting row 1 and dragging down to row 2 so that both rows are light blue. Then in the ribbon below the title of your spreadsheet, select view, freeze, and 2 rows.
7. You'll know that you have done it correctly when a gray line appears under row 2.
8. Repeat steps 6 on columns A and B to complete the freeze panes but instead of choosing "2 Rows" choose "2 columns". You'll know you have done this correctly when a gray line appears at the right edge of column B.
9. Next I like to add my headings for the budget categories. I'll also write a blog soon on the different budget categories you might want to think about and the categories we use in ours. Starting in cell A3 I list out the different types of income and then in the column following I list out the different types of expenses. You can be as creative as you want with the formatting, I like to make ours easy to look at.
10. Next in column B you can add a header for Expected Monthly amounts and add in the dollar amounts that you'd like to see spent or earned in each month for the year. In following parts we'll work on making sure your amounts are accurate. (I also went back later and added dollar signs to the expenses amounts).
There are the first ten steps! Stay tuned for Part 2. In total, including writing this post and capturing the screen shots while making the budget, these steps only took me 1 hour. So think how quick and easy it will be when you don't have to write out the steps and think about how to explain the process! Let me know if you have any questions or suggestions!
Friday, February 17, 2017
How to Stay Motivated About Sticking to Your Budget
![]() |
| Photo by Green Chameleon |
1. Make Your Own
Budget Format
Josh and I have
created our own spreadsheet through Google Sheets to track our expenses in a month. There is
just something helpful about creating a system that works well just for you.
For us it creates ownership, we've put effort into a system that helps us track
our spending, income and goals so that helps us put it to good use instead of
wasting it. We can also change it any time we want, fix the system if part of
it doesn't work well for us. Specifically we use Google Sheets because we can both access it on our own computers or on any computer where we can log in to our Google account. I have plans to make a tutorial post that might
help those of you who struggle with Google Sheets.
2. Set Financial Goals
Financial goals are so helpful. We really like Dave Ramsey’s 7 Baby Steps. They aren’t steps that can be completed in one day, they take some
effort and perseverance because some might take a long time and the length may be frustrating. But they are logical and we like that we didn't have to think them up ourselves. Also, Dave Ramsey's website has a lot of helpful resources on various topics. Right now, Josh and I are working on Baby Step #2 which is paying off all short-term debt. We're hoping that we get our debt under control before we have any little mouths to feed (I've heard little mouths can be quite expensive).
3. Give Yourself Rewards
I am so excited and motivated to pay off debt! You want to know why? Josh and I have a series of rewards for completing that goal. For Josh, we agreed he can save up for a truck after we pay off the debt. He sold is old truck in 2015 and I think he misses it almost every day. It's a great motivation for him. We also want to go on a vacation together, maybe go overseas and do mission work and travel in the US. We have a number of rewards for after we are finished paying our debt that I'm so excited for. Having rewards makes me want to save more and not spend as much so that we can continue paying off that debt. Now obviously things still get in the way, like we have to find a place to live this year and we've decided to buy a house that's a big expense that we're saving for instead of paying off debt right now. And that's okay!
4. Use an Online Tracker
We like to use an online tracker, Mint, that is connected to our bank account, loan accounts, our credit card (not Dave Ramsey friendly, but necessary if you want to rent a car unfortunately), and even property we own. This is helpful for us because we can go to one place to monitor all of our accounts. Not only that but we're able to track all of our expenses and categorize them which is not something you can do through your regular online bank account. Mint is similar to Every Dollar through Dave Ramsey but we found Mint first and like that we can access every function of the site for free.
5. Be Flexible and Give Yourself Some Grace
You are not going to be perfect at sticking to your budget if you have never had one before. That's just reality. There are two big reasons for this. One, you aren't used to tracking your money or limiting what you buy and this is something that has to be practiced. Telling yourself no is not an easy task. Two, you might create some budget constraints that aren't achievable or realize that you thought would spend more than you actually do. My advice is to go with your budget for three months and then look at the averages of each category. This will help you create a more accurate budget. Ultimately realize: one, that you aren't a perfect person and two, sometimes life doesn't go as we expect.
I hope these tips will keep you motivated to use your budget and stick to it! Budgeting will help you accomplish financial goals, help you to see what you spend your money on and help you make decisions on what to buy. For spenders this is a great step on the way to becoming a saver!
4. Use an Online Tracker
We like to use an online tracker, Mint, that is connected to our bank account, loan accounts, our credit card (not Dave Ramsey friendly, but necessary if you want to rent a car unfortunately), and even property we own. This is helpful for us because we can go to one place to monitor all of our accounts. Not only that but we're able to track all of our expenses and categorize them which is not something you can do through your regular online bank account. Mint is similar to Every Dollar through Dave Ramsey but we found Mint first and like that we can access every function of the site for free.
5. Be Flexible and Give Yourself Some Grace
You are not going to be perfect at sticking to your budget if you have never had one before. That's just reality. There are two big reasons for this. One, you aren't used to tracking your money or limiting what you buy and this is something that has to be practiced. Telling yourself no is not an easy task. Two, you might create some budget constraints that aren't achievable or realize that you thought would spend more than you actually do. My advice is to go with your budget for three months and then look at the averages of each category. This will help you create a more accurate budget. Ultimately realize: one, that you aren't a perfect person and two, sometimes life doesn't go as we expect.
I hope these tips will keep you motivated to use your budget and stick to it! Budgeting will help you accomplish financial goals, help you to see what you spend your money on and help you make decisions on what to buy. For spenders this is a great step on the way to becoming a saver!
Thursday, December 8, 2016
The First Post
![]() |
| Photo by Alisa Anton |
So this is a little nerve-wracking. But today I'm sitting in Starbucks and I'm trying to write my first blog post. I've finally found some free time to come up to Starbucks to read the first Harry Potter (don't worry, I've already read it a few times), work on the blog a bit and maybe touch some of my end of semester homework. I'm drinking some delicious mint tea and I'm not really sure where to begin this post but the more I write I'm finding my niche. So I guess I'll just start out by telling you a little bit about what this blog will be focused on. To be honest, I'm not exactly sure what kinds of content will show up here but something you should know about me is that I'm interested in a lot of different things right now that I hope to blog about.
Jesus. Marriage. Bullet Journaling. Travel. Personal Finance.
I'm a Christian, I've been a follower of Jesus since I was nine years old. But it wasn't till about 13 or 14 when I truly began following Him. When I started college I began to grow a lot in my faith and got involved in Campus Ministry. Last year, I found my current church, The Grove, and I've grown even more. Josh and I encountered some hard decisions last year and I think that time taught us to have a love for God's Word. I'm sure that will come through on this blog at different points of my life.
Since I just got married in August, I'm super interested in my marriage. I'm learning so much about my husband, Josh, and it really is a lot of fun. It's also a lot of work and it amazes me how one person can teach me so much about myself and about my own faults. Marriage is much different than dating and that is a really good thing. So I'm sure long posts are to come about all the wife life and maybe even some posts about what I learned when we were dating and some things from being single too.
Another thing that's on my mind a lot is bullet journaling. I first heard about bullet journaling on Pinterest (I love Pinterest) and it caught my attention because I've never found a perfect planner and by bullet journaling, I can make my own. I've been bullet journaling in my graph paper notebook for now but I'm hoping to soon invest in a nice notebook and some fancy pens and highlighters. I have a lot of plans for my journal, I plan to start sharing posts about it in January.
I also hope that I can share some of our traveling adventures with you as well! Josh and I have plans to travel in the future and I plan to write about them here. "Live. Laugh. Lowe." was an idea I came up with while studying abroad in Taiwan (you can read more about that adventure on my About Me page). My first major is International Business so I hope that this blog can travel the world and that I can share what I learn about new cultures with you.
Finally, I've become interested in personal finance and I like to talk about money probably because my second major is Finance and my professors like to scare us by talking about retirement. As a 21-year-old, newlywed and college student, money is definitely on the low side. Josh and I are dealing with paying student loans, rent, taking on new responsibilities that our parents used to cover, and we're going to try to buy a house this year. We're big fans of Dave Ramsey and plan to make decisions that will get us to a debt free life pretty quickly. I'll be sharing various plans that we have and maybe even share elements of our budget and planning that we do each month. Ultimately Josh and I want to be people who give, of our time and our money, because we believe that both are given to us by God.
Thanks so much for reading, I'm working on content for each of these subjects and hope to upload them soon!
Grace and peace to you!
Subscribe to:
Posts (Atom)




























