#Daily expenses excel sheet india download#

Download the household budget spreadsheetĬlick here to download the household budget excel file. Again, another technique from Sort and Display chart data automatically post. In this, the expenses are sorted from highest to lowest and grouped by category. There is an “analysis” worksheet where you can see some graphs based on your expenses. For this, Sovan uses Conditional Formatting. You can also highlight expenses above certain pre-defined amount. Sovan uses the circular reference formula technique we described in that post. As you enter the expense, the time stamp is automatically generated (read automatic timestamps in excel). Using this spreadsheet, you can track your expenses. So here they are, Household Budget Spreadsheet I immediately asked him if it is ok to share these files with our community and he is more than happy. Naturally I got excited to see such prudent use of excel. Sovan, one of our blog readers from Chennai, India, sent me 2 excel budgeting spreadsheets. But I am here to tell you fun ways to track expenses and household budgets using spreadsheets. So when we got our first job (did I tell you that both Jo and I started working in same company and sat in same floor? Oh, it was such a lovely time), we were very prudent and decided not to waste money on anything trivial (we still are, just that over last 6 years our earning capacity increased a bit and we became parents).Īnyways, I am not here to bore you about my household. Our upbringing has taught us value of money in the most effective way – by exposing us to not having any. PHD and I come from very modest backgrounds. Once you have all of your costs entered, you can begin to track your spending and see where you can cut back.At PHD household, we believe in using money wisely. Be sure to include all of your fixed costs, such as rent or mortgage payments, as well as variable costs, such as utilities and food. On each sheet, create columns for your income and expenses. Then, create a sheet for each month of the year. To create a budget in Excel, start by creating a new workbook. You can also use Excel to create a budget for your business. By creating a budget in Excel, you can easily track your income and expenses, and see where your money is going. You can also use it to plan for future months and years.īudgeting in Excel can be a great way to get a handle on your finances. Once you have your budget set up in Excel, you can use it to track your progress and make sure you are sticking to your budget. You can also use the PivotTable function to create a budget for multiple months or even years. This allows you to see where all of your money is going and track your spending over time. This will give you your total budget for the month.Īnother way to make a budget in Excel is to use the PivotTable function.

One way is to use the SUM function to add up all of your expenses and income, and then subtract your expenses from your income. Your PivotTable will nowĪssuming you have your budget set up in Excel, there are a few ways you can go about making a budget in Excel. In the resulting dialog box, choose which fields you want to use for rows, columns, and values then click OK. To do this, simply select all your data (including headers), then go to Insert > PivotTable. If you want to get more sophisticated, you can use the PivotTable feature in Excel to create a budget that automatically updates as you enter new data. You can also use the SUM function to add up multiple categories - for example, if you have a separate column for each type of expense, you could use the SUM function to add up all your expenses and get your total monthly or annual spending. For example, if you have columns for each month of the year, you could use the SUM function to add up all 12 months and get your total annual budget. Save your budget by clicking on the 'File' tab, then click 'Save As.' Choose a location for your budget and give it a name.Īssuming you have your budgeted amounts by category in an Excel spreadsheet, you can use a simple SUM function to add these up and get your total budget. Click on the 'File' tab, then click 'New.'Ĭlick 'Budget' under the 'Available Templates' heading.ĭouble-click on the template you want to use.Įnter your budget information into the appropriate cells.