#2 Below the charts, you can edit the names of the categories for the various expenses and income. #1 Clicking the ‘Summary’ sheet, you can indicate the starting balance of the month at the top right corner of the sheet. Next, let us cover the basics of the Monthly budget Google Sheets. It will automatically calculate everything for you.Įnding balance: Starting balance (of the month) + Net savings Monthly budget Google Sheets There is also a graph that shows the changes in total monthly income and expenditure as well as the changes in the ending balance over the months.ĭo note that there is no need to edit this sheet at all. Like the other sheets, you will find the total and average on the last two columns. #6 Under the ‘Summary’ tab, you will find the summary of the monthly income and expenses, as well as the net savings and ending balance. Unlike ‘Expenses’ which deduct from the balance, ‘Income’ will increase the balance. We will then input the various income sources for every month. #5 We can also click on the ‘Income’ tab. Total refers to the total expenditure while the average is the average salary across the months. #4 On the right, you will see the last two columns ‘Total’ and ‘Average’. All you have to do is to indicate in the cells (boxes) the expenditure for each expense for each month. The rows stand for the various expenses while the columns represent the months. In that sheet, you will see various rows and columns. That we will need to tinker with for the setup page. #2 Next we will key in the starting balance. #1 First at the bottom of the sheets we will click ‘Setup’ I will talk about how the Annual budget sheets work. Now, let us start with the Annual budget sheets. Each has slightly different uses but I prefer using the annual budget one. Under the “Personal” section, you can choose from two templates, “Annual Budget” and “Monthly Budget” (See #2).Hover on the right arrow under Google Sheets and click “From a template”.One of the simplest tools that I use to track my budget and savings would be Google Sheets! We can make use of the available templates to help us. Alternatively, I will link a copy of them at the end of the article. I have covered how to get these templates in my ‘Importance of budgeting and saving’ article but I will go through them again in this article. I will be going through both of them and at the end, evaluating which one is better suited for you! (You can check out that article here)įor budget-related sheets, there are two options ‘Annual budget’ and ‘Monthly budget’. This is a follow-up to my past post on budgeting and saving where I recommended the Google Sheets templates as a useful tool. Hey everyone! Today I will be going through how to use the Google Sheets budget tracker templates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |