Keeping track of where your money is going is crucial to saving the mula, and being able to spend it more without guilt or doubt of your bank account. The problem is, you don’t have a whole day to plan out a sophisticated financial spreadsheet that confuses the hell out of you the next time you take a look at it. So here is the simplest, and most effective way to budget your finances within 10 minutes.
- Create a Google Account if you don’t already have one. – google.com
- Go to sheets.google.com and create a New Blank Sheet.
- Set up a basic spreadsheet like this:
Notice I labeled the Tab for the date range which the budget will take place.
For all the TOTAL cells, I used the SUM formula. So for example, cell D6 looks like: “=SUM(D2:D5)” and that automatically adds up all of the cells in that range.
For the Amount Left cells, I used a simple subtraction formula. Cell E5 looks like: “=B5-D6”
Then I just color coded so I can easily see how much money is coming in and how much is being spent.
This should not take you long to set up, the point is to get it done and over with quickly, but obviously you can go as far in depth with this as you desire with the looks of the page and the details of each expense.
The best thing about using Google Sheets, is that you can access it from just about any device so you’ll always be able to check if an unexpected expense would fit your budget no matter where you are.