#Daily expenses excel sheet india how to
#Daily expenses excel sheet india plus
#Daily expenses excel sheet india tv
#Daily expenses excel sheet india free

Click OK when prompted with a pop-up warning.Highlight the cells you want to duplicate.Go to the last row of the expense column (Custom category 3, line 41).It doesn’t hurt to have extra blank rows, so I suggest that you add about 5 or 10 rows even if you won’t use them all. But if you do want to add extra rows or think you may need to in the future, there’s a specific way to do it to avoid messing up the formulas.įirst, determine the number of expense categories that you want to add. If you don’t need additional rows of expenses beyond line 41, you can skip ahead to the next step at this point.

#Daily expenses excel sheet india how to

How to add more custom categories in Google Sheets If you need help determining your budget categories, review your recent credit card and bank statements. You can safely change the shaded expense and income categories on the Summary spreadsheet through line 41, but don’t fill in the Planned column for your expense categories (except Fixed Expenses) just yet. Now, all of those fixed expenses take up only one line on the Summary spreadsheet and you can focus on the variable or flexible spending categories that have a greater impact on your day-to-day budget. Next, change the first line on the expenses column from Food to Fixed Expenses and enter the total from the other spreadsheet. Total the fixed expenses and flip back over to the Summary spreadsheet. You may also want to include irregular expenses in this worksheet.

#Daily expenses excel sheet india tv

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 and insurance payments.

#Daily expenses excel sheet india plus

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. Before you adjust the expense categories on the Summary spreadsheet, I recommend that you add a third spreadsheet for Fixed Expenses. The third step is to customize your sample monthly budget. 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. 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 dropdown 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.

In the upper-left corner, change the name of the spreadsheet from “Monthly budget” to “SAMPLE BUDGET TO COPY EVERY MONTH.” You’ll understand why that’s important later on in this article. 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

#Daily expenses excel sheet india free

Credit Cards With Free Cell Phone Protectionġ.Compare the Best Credit Card Offers Right Now.Consumer Cellular Review (AT&T & T-Mobile).US Mobile Review (Verizon & T-Mobile Networks).Tello Mobile Review (T-Mobile’s Network).Mint Mobile Review (T-Mobile’s Network).Xfinity Mobile Review (Verizon’s Network).Switching Phone Plans? 7 Mistakes to Avoid.10 Things to Know Before You Sign Up for a Cheap Phone Plan.Stream Everything You Want & Save Money: 10 Tips!.I Got an 800 Credit Score and You Can Too.