Note: This post may contain affiliate links.
 

How to Use Google Sheets as a Bill Tracker (Plus a Freebie!)

Could you use some help organizing your budget and bills? Would you love a freebie that would help you do this? Would you love even more to see a video by me that will walk you through it step-by-step and answer your FAQ’s?

You’re in luck! You had no idea how lucky you’d be today because I have all of that for you right here in this post!

Let’s go! I’m going to explain everything in writing in case you don’t/can’t do video. But everything from this point is covered in my video down at the bottom of the page.

 

 

Step 1: Get my Simple Budget Download

Here is my free Google Sheet called The Simple Budget!

All you have to do is click this link. There will be a pop-up window that contains a link to my shared Google Sheet.

Click on that link, and it will open in a new tab.

If you do not already have a Google account (Gmail, Drive, Photos, Google+, etc.), then you will need to sign up for one.

 

Step 2: Make it Yours

First, we have to make it yours so that you can edit the spreadsheet with your own figures!

Go to File → Make a Copy

You will see a popup that looks like this:

 

 

You can choose to change the name of the document here, or file it in a certain folder in your Drive. Or just leave it as-is for now.

Click ‘OK.’

The Sheet will now be saved to your Drive.

 

Step 3: Plug in Your Income and Expenses

I suggest writing in the expenses when you want to pay them instead of when they are due. This will give you a bit of a time cushion to make sure you are not late with your payment.

Not sure what type of things should you include? See post here.

 

Recurring Monthly Expenses

On the first tab, called ‘Budget,’ you have the opportunity to enter income or expenses that recur monthly. Simple replace my example amounts with your own.

Enter an income like this: 400.62

Enter an expense like this: -400.62

Everything on this ‘Budget’ page will show up automatically into all of the other Month tabs. (Be sure to erase all of my examples.)

 

Non-Monthly Expenses

Anything that does not occur every single month should be entered in the Month tabs.

For example, if your life insurance is due on November 15th every year, simply write it in on the 15th in the November tab.

If you pay for something annually, biannually, quarterly, or bimonthly, it will need to be entered directly on the Month tabs.

Likewise, any one-time expenses will need to be entered on the Month tabs wherever they belong.

 

Step 4: Use it!

You can choose to print off one month at a time if you prefer to have your budget in print and right in front of you.

Each month when you sit down to pay your bills, you can easily see what you are expecting.

If you need to change a monthly bill, simply update it on the ‘Budget’ tab and it will automatically take effect into the rest of the Month tabs.

You can add as much stuff as you want in your budget – even things like groceries, gifts, and allowances. The yellow box will give you an overall balance for the month.

 

Video Tutorial

Here’s my video on how to use this Google Sheet. I also answer some FAQs in this video such as the following:

  • What is the best way to print out my calendar?
  • Can I add or delete rows?
  • How do I delete or rearrange a tab?
  • What do I do if I accidentally erase a formula?
  • Is the ‘Budget Worksheet’ combinable with this worksheet?
Conclusion

I’m so excited for you to get your bills organized! And I really hope this Google Sheet will help you along your journey to better finances.

 

Do you have a great way to organize your bills that you’d like to share? Do you have any questions about using this Sheet? Leave a comment below or email me directly.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.