A command-line HR Payroll application built with Python and SQLite.
- Add employees with department and salary details
- Auto-calculate tax deductions using Indian tax slabs
- Generate formatted payslips
- Search employees by name
- Delete employee records
- All data persisted in a local SQLite database
- Language: Python 3
- Database: SQLite (via Python's built-in sqlite3 module)
- Concepts: OOP, CRUD operations, parameterised SQL queries
python payroll.py| Income Range | Tax Rate |
|---|---|
| Up to Rs. 3,00,000 | 0% |
| Rs. 3,00,001 – 6,00,000 | 10% |
| Rs. 6,00,001 – 10,00,000 | 20% |
| Above Rs. 10,00,000 | 30% |