Next, you can customize your categories based on your household’s spending. This is important because it allows you to focus more on the variable or flexible spending categories that have a greater impact on your day-to-day spending. Now, all of those fixed expenses take up only one line on the Summary spreadsheet. Next, change the first line on the expenses column from Food to Fixed Expenses and enter the total from the Fixed Expenses spreadsheet in the Planned column. Total the fixed expenses and flip back over to the Summary spreadsheet. You may also want to include irregular expenses in this worksheet. Then, list your fixed expenses and how much you spend on them every month.įixed expenses include things like your rent/mortgage, cell phone bill, TV bill, utilities, subscriptions and insurance payments. In the lower-left corner, click to plus sign for “Add Sheet” and change the tab name to Fixed Expenses. The purpose of this additional spreadsheet is to separate your fixed and variable expenses. The third step is to customize your sample monthly budget.īefore you adjust the expense categories on the Summary spreadsheet, I recommend that you add a third spreadsheet for Fixed Expenses. You’ll get a pop-up that warns about editing the spreadsheet, but go ahead and click OK. If you think that you may need additional expense categories, click “Add 1000 more rows at bottom” just like you did on the Transactions spreadsheet. The Summary spreadsheet ends with row 44. Then, zero out the sample Home (cell D31) and Paycheck (cell J29) amounts shown in the shaded Planned column. To start with a clean slate, adjust the starting balance in cell L8 from $1,000 to $0. Once you’ve made those changes, flip back to the Summary spreadsheet. Now, you’ll have 1,033 rows for transactions. That will be a problem if you have more than 33 transactions in a month, so click “Add 1000 more rows at bottom” to avoid any issues. Next, scroll down to the bottom of the Transactions spreadsheet. Then, click on Delete Values from the Edit drop-down menu. To delete the sample expenses for Rent and Paycheck, click on the number 5 to select that entire row. You can access it by clicking on the Transactions tab at the bottom of the screen. Let’s begin with the Transactions spreadsheet. Warning: If you don’t follow the instructions below, it may break the formulas in the spreadsheet. Next, you want to delete sample amounts on the Summary and Transactions spreadsheets. You’ll understand why that’s important later on in this article. In the upper-left corner, change the name of the spreadsheet from “Monthly budget” to “SAMPLE BUDGET TO COPY EVERY MONTH.” To start with a clean slate, you need to give the budget template a new name. If you don’t see a thumbnail for it, click on “Template Gallery” and find it under “Personal.” 2. When you open Google Sheets from a computer, look for the “Monthly Budget” spreadsheet located near the top of the screen. The first step is to find the Google Sheets budget template. Locate and Open the Google Sheets Monthly Budget Template Track Your Expenses Throughout the Monthġ.Make a Copy of the Sample Budget and Plan Your Spending.Locate and Open the Google Sheets Monthly Budget Template.And the right Google Sheets budget template can make that process easier than ever. No matter what your financial goals are, a budget is a great starting point to reach them. Because remember: Balance is the key to creating (and sticking to) a good budget. And to help you figure out where the fun stuff fits into your budget. It’s designed to make budgeting a little easier. Start with this Google Sheets Monthly Budget template (you’ll need to make a copy of this one, too). This one also offers a subscription for automatic updates. PS: Like the FIRE spreadsheet above, you’ll have to make a copy to customize it. This Quarterly Estimated Tax Sheet helps you estimate your business’ quarterly tax bill in real time. The good news is there’s a Google Sheets budget template to help you do that, too. You’ll need to add important business stuff to your budget. Psst…this spreadsheet doesn’t give you the option to edit, so you’ll need to make a copy of the original file to customize it. If that’s you, this Google Sheets budget template makes it easy to stay on top of your net worth and the return on your investments. And it’s picking up steam among those willing to invest up to 75% of what they earn. ICYMI: FIRE stands for financial independence, retire early. Use the FIRE spreadsheet to keep track of your progress.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |