How to Make a Budget in Google Sheets Part 3

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.

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!

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

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". 

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!

3 Marriage Habits to Start (or Re-start) in the New Year

This year I'm thinking about a lot of areas in my life where I'd like to see improvement. One of those areas is my marriage. It's been a stressful season of life for us, we bought a new house and are remodeling it, we both started new jobs and we're both trying to find a balance in how we spend our time. It's easy for both of us to forget what is important. Because of this, we've had a tendency to have unspoken and unmet expectations, poor communication, and arguments. Since Thanksgiving, Josh and I have discussed several things that we think will remind us to love each other and pursue the Lord together. We've started to implement a few and they've been helpful already.

1. Let's Date Each Other Again

When I think back on dating Josh I think about how we emphasized spending time together. We had one night a week that was reserved for the just the two of us. Monday nights were spent watching a movie, reading the Word, eating dinner together, and it was usually full of a lot of laughter. Now that we are married and live in the same home, we've lost that need or rather lost the motivation to really spend intentional time together. I'd like to start dating again in the new year. Maybe sometimes that will mean leaving the house to do something fun or maybe it will mean eating dinner together at home and just enjoying each other's company. It might even mean double dating with friends. I think we need a healthy dose of fun added back into our weeks together, something that will remind us why we fell in love.

2. Read the Bible and Pray Together

This was such a key part of our dating relationship but I don't think it's something we've valued as much being married. Over the advent season we started reading the story of Jesus' birth together every night and it was so sweet. We were more loving towards each other and I felt we were on the same page in making decisions together. We're a work in progress in this area, but I'm praying that we continue this together. I think just the little glimpse of good I saw over the path month is a reason to read and pray together more.

3. Encourage One Another

We spent our New Year's Eve at home this year and it was a great time of reflecting and planning for the next year. We looked at our budget (party!!!) and made decisions together about our money. We were reminded that our money belongs to the Lord and that we need honor him together in that by both taking responsibility for our finances. Each week we are going to sit down on Friday together to go over our budget, this way we can keep each other accountable to the decisions we have made about spending our money wisely. We also shared other goals, some like the two above, ways we want to be a better spouse, things we want to accomplish with the house, being healthier all around and ways we both want to grow in our individual relationships with the Lord. We have to communicate these things with each other in order to effectively encourage and be encouraged.

Now, I totally don't want to come across as though we have this whole marriage thing figured out...we totally don't! In fact, in the middle of writing this post we had a huge teary, angry fight and it was not fun. After the fight I thought I shouldn't even finish this post because it's obvious the things we've been trying aren't working. But honestly, I think that's Satan's way of trying to convince me that marriage isn't worth it, that it's easier to not try to love Josh or want to make an effort to know him better. Satan knows that when Josh and I are really close we're better at being on the same page and moving towards the Lord. But he also knows that when we fight we are distracted from working our hardest to display in our marriage the beautiful reflection of Christ and His Church. 

So today I'm reminding myself, by sharing these habits with you, that Jesus has already won, that His power is much more capable than my own to hold our marriage together. We're still learning, we're still sinful and it's okay if you are too because if you follow the Lord then your marriage is held together by the Creator of the universe. My goal is to continue to try and make these habits a priority, even if some days it seems like it isn't working, because I know that my marriage doesn't rest on my shoulders or Josh's, but on Christ's and that the only load I carry is His.

"Come to me, all of you who are weary and burdened, and I will give you rest. Take up my yoke and learn from me, because I am lowly and humble in heart, and you will find rest for your souls. For my yoke is easy and my burden is light." - Matthew 11:28-30

Share with me the habits you want to start with your spouse or the dreams you have of what marriage should look like. I'd love to hear them!

Bathroom Inspiration

Wow, it has been quite awhile since I wrote a post and I feel like so much has happened in our lives. Josh has been spending a lot of time on our house and started a new job. I've been spending a lot of time trying to adjust to that crazy corporate work-life balance. And though I like my job a lot, I feel I'm working/driving a lot and I miss those lazy afternoons in college. It's something that I'm starting to figure out... I think... and I've been enjoying getting back into the swing of getting things accomplished at home and also working really hard at my job. I'm learning how to prioritize my time and making sure I focus on things that are truly worth spending my time on. Unfortunately that does mean less time for Netflix, reading, journaling and other things I find relaxing. But I'm slowly starting to realize that spending hours of my time off work watching shows and scrolling through Instagram really isn't the best use of my time. It's relaxing, for sure, and there is definitely a time where I think that relaxing and watching an episode of one show is okay. But I'm coming to the realization that relaxing for me really starts when my relationship with my husband is healthy, when my home is clean and when I meet with friends and read God's word. This means that I have less time to watch Netflix because I'm hanging drywall and cleaning up sawdust, doing laundry and dishes, getting coffee (tea for me) with friends and spending a good amount of time with Jesus. As an introvert my natural inclination is that those things are not classified as relaxing but guys, watching Netflix is SO much more relaxing when Josh is happy, my home is clean and my heart is encouraged. It's totally balanced, and I think that's what makes it so much better.

BUT ANYWAY.

This post was supposed to be about our bathroom and the cheerful place it will soon be. Our plan for the bathroom is to make it bigger and more open without encroaching too much on the kitchen, and to make it more updated and less fishy, literally. We've already done so much thanks to my in-laws who helped Josh tile the floors and the shower. Josh has already installed the new cabinet, tub and toilet. We're keeping the vanity that came with the house and the new sink/countertop combo arrived a couple days ago.

Before 

We'd already started destroying walls in the bathroom when I realized we hadn't taken any pictures yet. We had to rip everything out, the floor, ceiling, walls, all of the plumbing. You can already see some of the torn out wall in the picture. And the first picture is of the space that we gained by tearing out a built in cabinet. 

Inspiration 

When I was creating our wedding registry I asked Josh what color he wanted the bathroom walls to be and he said yellow. I didn't really have a preference but I love that he picked such a cheerful color for the bathroom. So I put on our registry that we would need gray accessories for the bathroom. I think the yellow and gray combination will be pretty! 

We're going with a Behr paint color for the walls called Pale Honey and it drys really nicely on the wall. I think it's the perfect shade of yellow!

The shower will have subway tile which I think is so classic and simple. I've always dreamed of having a bathroom with subway tile. We'll also add in black hardware like the picture below. 

The vanity will be getting a fresh coat of gray paint as well as the tall linen cabinet we're installing. And it will also get a clean white countertop that will pair nicely with the white tile on the floor and in the shower. 

Let us know what you think and check out our progress on the bathroom here.

I'll be blogging soon about our kitchen and living room plans and some day you'll see updates on the bedroom and bathroom projects. Stay tuned!

Adventure: Dallas (and Waco)

This blog is a little delayed from the actual fun but we had such a great trip to Dallas for our anniversary earlier this month. I thought I would share a little bit about our trip and some fun pictures too! You can also check out our vlog, we took a lot more video than pictures.

Friday 
Travel day 1 was fun, Dallas is only around 6 hours from home so it wasn't too bad of drive for us. Of course we didn't start the day off on time (my bad), we left an hour after we said we would. LOL. But road tripping is always fun, you get to see new places and I think that our country is just so beautiful! We had some lunch in Oklahoma on the way down at good ole McDonald's (don't judge) and had a funny interaction with the guy behind us in line who said we got out of the car really fast?

We hit a little bit of traffic when we got to Dallas but thanks to Waze, our favorite road trip GPS, we got through it pretty quickly and made it to our hotel.

We stayed at the Hilton Dallas Lincoln Centre and we thought it was really nice! We booked our room through Hotels.com and got a pretty sweet deal: our room, free parking in the hotel garage and breakfast vouchers. We felt pretty fancy with our king bed and sit down fancy breakfasts. The first thing we did after throwing our stuff in our room was swim in the outdoor pool!

After swimming we met up with my cousins and Aunt at Whiskey Cake Kitchen & Bar in Plano. Josh and I both had their Chicken and Cheese melt which was a chicken sandwich with pesto, avocado, bacon, lettuce and tomato, it was SO good guys. And the restaurant had great decor too which was really fun, it was loud place, you could tell other people were enjoying their conversations and dinners just as much as we were. We really should have taken a family picture but we didn't....

Saturday 

We started Saturday off with an awesome breakfast buffet in our hotel, bacon, eggs, potatoes, and banana bread, anything that our hearts desired. Then we headed to Waco. Since we have been renovating our house we thought it would be fun to visit Magnolia Market, the store created by Chip and Joanna Gaines from Fixer Upper. Waco is about a two hour drive from Dallas and I'm glad we made the time to go. The store was fun but we enjoyed the atmosphere more than the shopping. It was clear that they had designed to be a place where people could just come to relax. We didn't buy anything we just had a good time and ate some food found at the food trucks. I know that some people are like, how could you go and not buy anything?! We frankly didn't see anything that we NEEDED, but the creative and interesting designs gave us some ideas of things that we can make and incorporate into our new home. 

It was super hot in Waco we were melting by the time we decided to leave. We drove around the town for a little bit and saw the campus of Baylor University and even stopped by some other shops that are featured on Fixer Upper. It was a cute town and it's crazy that I almost decided to go to school there.

After Waco we made the drive back to Dallas and decided we were going to check out a church's Saturday evening service. There are a couple of churches that Josh and I like to follow online and learn from because they have great teaching Pastors and seem like churches that have a great vision of discipleship and sharing the gospel. So we knew that our weekend would be filled with making some visits and experiencing what we already believe to be awesome in person. The church we tried, key word tried, to visit on Saturday was The Village Church and we tried to go to their original campus in Flower Mound (a suburb of Dallas). So on our way back from Waco we saw a pretty wicked thunderstorm ahead of us, there was a lot of lightning and rain but we were far enough behind we weren't really in it too bad. When we got to the church all the lights were off and we were 30 minutes early and we thought maybe that's their thing....then we heard an announcement that the power was out and they wouldn't be able to get it turned back on for the 5 pm service. Everyone promptly left the building and we thought it was funny watching all the people arrive at church and then find out the news that they couldn't get the power back on. We think the storm must've been pretty wicked and knocked their power out.

We were kind of bummed because we couldn't stay for their later service as we already had plans but we redeemed the situation by having some yummy dinner at Chipotle which is a delicacy to our small town pallets. And then we headed for another worship service in Klyde Warren Park in downtown Dallas. This service was put on by Watermark Community Church  and it was such a great night of song and prayer for Dallas and to thank God for what he is doing in their community. It was fun to be a part of. After a long day we were ready for bed and headed back to our hotel excited for Sunday morning.

Sunday - 1st Wedding Anniversary 

Our day was very sweet. I'm so thankful that we decided to go to Dallas to celebrate because we left so encouraged about what God is doing there and full of belief that he can do the same things where we live too. We started Sunday off by visiting a fun little donut shop called Glazed Donut Works. I've decided that eating donuts on our anniversary is going to be a tradition since we also ate donuts on our six month wedding anniversary. Then we went to church at Watermark, it was just as good as we thought it would be and we were so encouraged by the culture of their church. It was evident that they truly want to do things with excellence in order to share truth effectively. A lot of thought and effort go into how they life together as a church each week, and I'm not talking about just on Sundays.

After church we went to the Bishop Arts District and had lunch at Dallas Grilled Cheese Co. It was super yummy and the atmosphere was great too!

He is the cutest in these glasses! <3

Such a cute little place! The neighborhood of Bishop Arts was cute too but it was a little to artsy for us, lol, we didn't stay as long as I thought we would. Josh wasn't too mad about it because we had enough time to go to The Village Church again and this time the power was on, lol. We really enjoyed both churches that we visited. The services were simple and focused on the Gospel which left us feeling really encouraged. It was clear that the mission of these churches was focused and focused on good things, sharing the Gospel and making disciples. The aren't big churches because they tried to be, they are big because faithfulness and focus on the Gospel brings people who see that you have something real to offer. God is using these two churches, just like he is using churches all over the world to bring people to himself and that is a beautiful thing to see. 

Sunday evening we played mini golf and arcade games at Adventure Landing and we had a blast laughing and enjoying each other's company. Our short trip to Dallas was so refreshing and exactly what we needed to start another year of marriage on a good note and with an energy that this year we will love and serve Jesus together, that we will share the Gospel together, that we will encourage each other and pray for each other and that we will pursue biblical community with other believers. These things aren't always easy but we're asking God to teach us and to lead us as we walk into another year. We don't know what is in store but we can trust that God is faithful and that he works everything for his glory and our good.  

Bedroom Inspiration

So if you haven't been following along with the new vlog that my husband and I started you totally should, you can check it out here. But if you have been following along you know that we bought a house a few weeks ago and are renovating the whole thing. The first room we will be working on is our master bedroom. It's a necessary room to complete first just so we can feel a little more organized and have a place to retreat from the chaos. And it is one of the easier rooms to complete in our new home that is requiring a lot of work to make it feel like home. The plan for our bedroom is to make the opening to the closet wider, refinish the hardwood floors and paint the walls and trim.

Before 

Our Inspiration

We got this comforter as a wedding gift and it will be the colorful piece of the room. 

We like the pattern of this door but we'll probably use a black track and paint the door white like we will do with the rest of the doors in the house and the trim. 

 We've decided to paint the room this color gray. It is Behr Silverstone paint and we really like that it's right in between light and dark gray. Gray will go well with our purple comforter.

This is all inspiration but our room might not end up looking exactly like this but it's always good to have ideas to help you plan for the end result! Let us know what you think in the comments and if you have any other ideas! We're so excited to continue working on our room Tuesday evening! If you want to watch all the videos from our bedroom renovation click here.