Did you know that you can create a budget with Google Drive that will make it easier to keep track of expenses and save money? Google Drive is an online document management service for those who have Gmail accounts. You can even share documents with friends and work on projects together.
Creating an online budget chart is a perfect solution for people who find it difficult to save money. When all the stats are displayed as graphics, it motivates you to refrain from spending money.
Follow these steps and learn how to create a budget chart using Google Drive:
1. Login into your Gmail Account. Go to Google Drive, click on “Create,” and then click on “New Spreadsheet.”
- The new document will open and you can name it something that suits your situation. For example, you can choose something like, “Monthly Finances,” as the title for your spreadsheet.
2. Click on “View,” then “Freeze Columns,” and then “Freeze 2 Rows.” This will freeze the first two rows and make it easier to fill in the factors that you want to track.
- You don’t necessarily have to freeze the first two rows because you can make a similar chart from any side of the spreadsheet. However, having all the factors at the top of the spreadsheet looks better and makes it easier.
3. Type in the name of the factors you want to track. For the purposes of this example, three will be used. But, you can add as many factors as you want.
- On the first row type in the name of the factor. The row below the factor will be the total amount.
- Let’s say that the three factors you want to track are “Spent,” “Earned,” and “Saved.”
- You might notice that there are quite a few columns assigned to each letter of the alphabet. It’s possible to delete the extra columns to clean it up.
4. Input the formulas. Below Row 2, where the names of your factors are listed, you’ll need to type in the formula. This will tell the program what to calculate.
- Click on the area directly below “Spent,” and type in this formula: “=sum(A3:A33).” This formula will calculate all the amounts between Row A3 and A33, and list the total on A2.
- Enter the same formula for “Spent,” but replace “A” with “B” because that’s the column you’re tracking for earned funds.
- “Saved” doesn’t have a column because it’s just there to calculate the difference between the amounts you spent and earned. Enter “=sum(B2-A2)” to calculate the difference between the two numbers.
- You can test to see if the formula is working by typing a number into the row and watch to see if the total amount is calculated correctly.
- Format the numbers by selecting the area and clicking on “Format,” then “Number,” and then “Currency.”
5. Hold CTRL, click A1, then C2, and you’ll create the chart. Google Docs makes this incredibly simple. Select the area and then click on “Insert Chart,” and choose from the types of charts available.
- A bar graph is a good choice because it’s easy to read.
- When you click “Insert Chart,” the chart will appear on the spreadsheet. You can edit it as you please, and move it to the other side of the document.
- Whenever a value changes on the spreadsheet, the graph will recalculate and change as well.
Congratulations! You now know how to create a simple budget chart with a graph. You can build upon the spreadsheet as you please to include more factors. Remember, when you’re trying to save cash, budgets are extremely useful. Create yours today using Google Drive!