Skip to content

About

An interactive Excel dashboard for analysing expenses, payment methods, categories and spending patterns using Pivot Tables, charts, KPIs, slicers and conditional formatting.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

1 Commit

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

Expense Analytics Dashboard

Project Overview

This project presents an interactive Expense Analytics Dashboard developed in Microsoft Excel. It transforms 500 expense transactions from 2024 and 2025 into a clear and filterable report for analyzing spending patterns, departmental expenses, payment methods, approval status, employee-level spending, and monthly trends.

The workbook contains the complete analysis workflow, including the source data, formula-based KPI calculations, PivotTables, PivotCharts, slicers, a date timeline, and the final dashboard.

Expense Analytics Dashboard

Project Objectives

  • Monitor overall organizational expenses and transaction volume.
  • Compare spending across categories and departments.
  • Analyze monthly expense trends.
  • Track approved, pending, and rejected expense records.
  • Evaluate payment-mode distribution and employee-level spending.
  • Enable interactive analysis through slicers and a date timeline.

Dataset

The project uses 500 expense records with the following fields:

  • Expense ID
  • Date
  • Category
  • Subcategory
  • Amount
  • Payment Mode
  • City
  • Department
  • Employee Name
  • Expense Type
  • Status
  • Month

Dashboard KPIs

  • Total Expenses: ₹1,26,71,869.54
  • Average Expense: ₹25,343.74
  • Highest Expense: ₹49,769.27
  • Total Transactions: 500
  • Approved Expenses: 166
  • Approval Rate: 33.20%

Dashboard Visuals

  • Expense by Category
  • Monthly Expense Trend
  • Department-wise Expenses
  • Expense Distribution by Payment Mode
  • Expense Status Analysis
  • Top 5 Employees by Expense

Interactive Filters

  • Category slicer
  • Department slicer
  • Payment Mode slicer
  • Status slicer
  • Date timeline

Business Insights

  • Internet was the highest-spending category.
  • Finance recorded the highest departmental expense.
  • Card was the most-used payment mode.
  • Deepak recorded the highest employee-level expense.
  • The expense approval rate was 33.20%.

Workbook Structure

The workbook includes:

  • Dashboard – Final interactive expense dashboard.
  • Expense_Data – Source expense dataset.
  • Calculations – Formula-based KPI calculations.
  • Category_Pivot – Category-level expense analysis.
  • Date_pivot – Monthly and yearly expense analysis.
  • Dept._Pivot – Department-level expense analysis.
  • PYmode_Pivot – Payment-mode analysis.
  • Status_Pivot – Expense-status analysis.
  • Emp_Pivot – Top employee expense analysis.

Excel Features Used

  • Excel Tables
  • PivotTables
  • PivotCharts
  • KPI Cards
  • Slicers
  • Timeline
  • SUM, AVERAGE, MAX, COUNTA, and COUNTIF formulas
  • Data formatting and dashboard design

Repository Structure

expense-analytics-excel-dashboard/
├── dashboard/
│   └── Expense_Analytics_Dashboard.xlsx
├── screenshots/
│   └── Expense_Dashboard_Preview.png
└── README.md

How to Use

  1. Download Expense_Analytics_Dashboard.xlsx from the dashboard folder.
  2. Open the workbook in Microsoft Excel 2013 or later.
  3. Navigate to the Dashboard worksheet.
  4. Use the slicers and date timeline to explore expense patterns.

Skills Demonstrated

Microsoft Excel, data analysis, expense analysis, PivotTables, PivotCharts, dashboard development, KPI reporting, data visualization, and business reporting.

Author

Shubham Gupta

Aspiring Data Analyst
Microsoft Excel | SQL | MySQL | Data Analysis

LinkedIn Profile

About

An interactive Excel dashboard for analysing expenses, payment methods, categories and spending patterns using Pivot Tables, charts, KPIs, slicers and conditional formatting.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors