Using the budget and expenses tracking google sheet Savings rate Here are some tips to reading the outputs. Use the appropriate columns and add the Date, Amount, Category and Subcategory to their right place.įor expenses, it's good to also input your payment method in column F, so it will be easier to update the data later on. This is done in the Expense input and Income input tabs. In order for the budget and expenses tracking sheet to be able to do its job, you need to give it some actual data. I promise you, you will not find a more convenient, more usable way to iterate on your budget than this! 3. So, if you have actuals already in the sheet for any year, you can load them into the grid to have a starting point as you make your budget. What the Load budget and actuals -button does is, it loads the budget for the selected year, but also actuals. Google Sheets will ask you permission to run scripts. This stores the values you've input in the grid for other sheets to use. When you are done with your budget, make sure you have the correct year selected and press the blue Save budget -button. The white cells are for showing actuals once you have them. You can add or remove categories on the column B in the Budget Grid Input tab. ![]() Just create your first version of a budget. Don't worry about getting it right the first time.
0 Comments
Leave a Reply. |