🚀 Excel Payroll Automation System

A professional Python automation project that:

• Reads employee Excel data
• Calculates salary bonuses and taxes
• Generates styled Excel payroll reports
• Creates professional PDF payroll reports automatically

Built using:

• Python
• Pandas
• OpenPyXL
• ReportLab

---

📸 Project Screenshots

Excel Report

---

PDF Report

---

✨ Features

✅ Excel Automation
✅ Payroll Calculations
✅ Styled Excel Reports
✅ Automatic PDF Generation
✅ Professional Report Formatting
✅ Beginner Friendly Project

---

📂 Project Structure

excel-payroll-automation/
│
├── data/
│   └── employees.xlsx
│
├── output/
│   ├── final_report.xlsx
│   └── payroll_report.pdf
│
├── screenshots/
│   ├── excel-report.png
│   └── pdf-report.png
│
├── automation.py
├── requirements.txt
├── README.md
└── .gitignore

---

⚙️ Installation Guide

1️⃣ Clone Repository

git clone https://github.com/YOUR_USERNAME/excel-payroll-automation.git

---

2️⃣ Move Into Project Folder

cd excel-payroll-automation

---

3️⃣ Install Dependencies

pip install -r requirements.txt

---

▶️ Run Project

py automation.py

---

📊 Input Excel Format

Name	Salary
Rahul	20000
Amit	30000

---

📄 Output Generated

The project automatically generates:

• Styled Excel Payroll Report
• Professional PDF Payroll Report

Inside:

output/

---

🛠 Technologies Used

• Python
• Pandas
• OpenPyXL
• ReportLab

---

📈 Future Improvements

• Email Automation
• Attendance Management
• Employee ID Generation
• Dashboard Analytics
• AI Payroll Assistant

---

🤝 Contributing

Pull requests are welcome.

---

⭐ Support

If you liked this project, give it a ⭐ on GitHub.