Daily Expense Sheet Format in Excel: A Step-by-Step Guide

Creating a daily expense sheet in Excel can be an effective way to track your income and expenses, making it easier to manage your finances. In this article, we will walk you through the process of creating a daily expense sheet format in Excel with ease.

Step 1: Record Income & Expense Data

To create a daily income and expense sheet in Excel, you need to record the income and expense data of a person for an individual day. Start by creating a new worksheet named 'Dataset' and make three columns - Date, Income, and Expense.

Step 2: List All Categories & Subcategories of Income & Expense

Once you have recorded your income and expense data, it's time to categorize and subcategorize your income and expenses. Create a new worksheet named 'Income & Expense Categories' and list all the categories and subcategories of your income and expenses.

Step 3: Summarize Daily Income and Expense

After recording and categorizing your income and expense data, it's time to summarize your daily income and expense in Excel. To do this, create a new worksheet with two columns - one for income categories and another for expense categories. List all the categories and subcategories of your income on the left side of the sheet and those of your expenses on the right side.

Creating Subcategories Dropdown List

To make it easy to select your category of expense from the dropdown list, follow these steps:

1. Select cells F6:F13.

2. Choose your category of expense from here easily.

3. As a result, you will see all the categories of your expenses are in a dropdown list in cells E6:E13.

4. At the Source: text box, refer to cells D6:D17 from the Income & Expense Categories worksheet.

5. Choose List option from the Allow: options.

6. Go to the Settings tab and select the List option.

Creating Dropdown List for Income Category

To create a dropdown list similarly to the expenses category, follow these steps:

1. Select cells C6:C13.

2. You can select your income category from here with a single click rather than writing it every time individually.

3. At the Source: text box, refer to cells B5:B9 from the Income & Expense Categories worksheet.

4. Choose List option from the Allow: dropdown list.

By following these steps, you will be able to create a daily expense sheet format in Excel that is easy to use and understand. This will help you to track your income and expenses effectively and make it easier to manage your finances.

Daily expense sheet format in excel