# How to Create a Daily Expense Sheet Format in Excel – 4 Easy Steps

## What Is the Daily Expense?

It is a business’s operational cost incurred to produce income.

### Step 1 – Create a Dataset

Create a sample dataset.

• Create a worksheet (Dataset) with three columns: Date, Income, and Expense.
• Select a cell for the date. Here, cells were merged.
• Enter the formula.
`=TODAY()`
• Press Enter to see the result.

### Step 2: List All Categories and Subcategories of Expense

• Create a new sheet. Here, Expense Categories.
• List all categories and subcategories of your expenses.

### Step 3 – Calculate the Total Daily Expense

• Select the date column and use the TODAY function.
`=TODAY()`

• Select the Category column and go to the Data tab.
• In Data Tools, click Data Validation.
• Select Data validation.

• In the Data Validation dialog box, go to Settings.
• In Allow, choose List.
• In Source, go to the Categories sheet and selectÂ B5:B16.
• Click OK button.

• If you click the category cell, you will see a tiny drop-down icon. Click it to select a category.

• Create a drop-down list foo the expenses subcategory.
• Choose the Sub Category column and go to the Data tab.
• Select Data Validation in Data Tools.
• Choose Data validation.

• In the Data Validation window, select Settings.
• In Allow, choose List.
• In Source, refer to C5:C16Â in the Expense Categories worksheet.
• Click OK.

• There is a drop-down list with all spending categories.

• Fill all categories and subcategories and the total amount spent for each category.

To calculate the daily expense for each category, useÂ the SUM function.

• Select a cell for the total expense.
• Enter the formula.
`=SUM(E6:E9)`
• Press Enter.

Read More: Daily Income and Expense Sheet in Excel

### Step 4 – Insert a ChartÂ

• Select category and subcategory and go to the Insert tab.
• In the Charts category, click Insert Column or Bar Chart.
• Choose Clustered Column in 2-D Column.

• The graphical representation of total Expenses will be displayed.

• Change the color of each category.
• Double-click the Series.
• In Format Data Series, click Fill & Line and check Vary colors by point.

### Final Output of Daily Expense Sheet Format

This is the final output.

## Related Articles

<< Go Back to Excel Expense Tracker | Tracker in ExcelÂ |Â Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF