Now, you can calculate the P resent balance using a formula that will automate the Expense Sheet.□ Step 5: Calculate Net Balance of Transaction Mediums You have to edit this data as per your income and the remaining balance from the previous month. Then enter the starting balance of each transaction medium that you use.Here I am showing an example of how you can easily enter a date in the expense table. Now, you are ready to take entry of the expenses. Before entering data, you should convert the cells of the Date columns into the Short Date format.Similarly, apply the same steps to apply drop-down options in the Category cells.Then, select the Medium column cells in the S ource option.Then, in the Data Validation window, select List in the Allow option.Then, go to the Data tab and select the Data Validation tool.For this, to implement a drop-down list in the Medium column cells, select all the cells of the medium column.And you can make a summary of the expense per category and mediums. So, while entering the expense you can easily select options from the drop-down list. Now, you will create drop-down list options in the M edium and C ategory columns in the Expense table. □ Step 3: Create Drop-Down List in Medium and Category Columns You can edit these to add or remove categories as per your use. Also, I have added a list of categories for example. Then, add the list of probable expense categories in the Expense Category column.You will add your Bank Account Names, Credit Cards, or mobile Financial Services here. I have inserted some items here for example. Now, add the list of transaction mediums in the Medium Column that you use.□ Step 2: Insert Transaction Medium and Expense Category Lists It will help you to make a summary of the month’s expenses. Expense Category: Here, you will list the E xpense Category items.Transfer Amount: Here, you will add the transferred Amount From one medium To another.Net Balance: Here, you will insert the list of transaction Mediums, Start balance of each medium, and the P resent balance.You can add a column to add N otes for expenses. Expense Table: In this table, you will add columns for D ate, Description of the E xpense, Category of the E xpense, Medium of transactions and F orecast amount, and the A ctual amount.So you can see how much amount you have in each M edium.įirst, create a blank template in a new worksheet. You should include the types of transaction Medium that you use.You can categorize the expenses so you will get a summary of data that will show where you have spent and how much amount.List of expenses with F orecast and A ctual values.There are some important things you should include in the expense sheet. So, in this article, I will show you the necessary steps to create a personal expense sheet. But it may feel clumsy or daunting work to create an expense tracker in Excel. Making a personal expense sheet is necessary for everyone. Related Articles How to Make Personal Expense Sheet in Excel: Step-by-Step Procedure
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |