A full-featured cheque printing and Provident Fund (PF) management system built in ASP.NET Core MVC.
This system is designed for Finance departments to generate printable cheques, calculate PF deductions, and maintain cheque history with export capabilities.
- 🖨️ Cheque Generation — Automatically fetch employee data from Excel and generate formatted cheques
- 📋 PF Calculator — Real-time deduction calculation with Grand Total update
- 🔍 Search & Filter — Filter cheque history by employee name, personal number, and date range
- 📥 Excel Export — Download full or filtered cheque history in Excel format using EPPlus
- 🧾 Print-Ready Layout — Designed for printing on real cheque stationery (precise layout using
cm) - 💾 Local JSON Storage — All data saved locally in
App_Data/history.jsonfor persistence - 🛠️ Ready for SQLite — Structure designed to easily switch to Entity Framework + SQLite
- ASP.NET Core 8.0 (MVC)
- C# and Razor Views
- EPPlus for Excel Integration
- JavaScript (Vanilla)
- JSON Serialization for local data storage
- Bootstrap 5 for styling
- Git & GitHub for version control
- Sample employees included in
wwwroot/files/Employees.xlsx - Use any 6-digit Personal Number (e.g.
123456,456789) from the sheet to:- Generate a cheque
- Simulate PF calculation
- All generated cheques are saved and shown in the History tab
Controllers/ Views/ wwwroot/ App_Data/ # JSON storage for cheque history files/ # Excel data file (Employees.xlsx & PFFile1.xlsx) Models/ # ViewModels and Data Models
- This is a sample version for demo/portfolio use
- Original employee data has been removed for privacy
- You can modify the Excel sheet and re-upload for your organization
Ali Mohtisham Shoukat
[email protected]
923454640268
Built for learning, finance automation, and real-world application
Feel free to connect or fork for your own needs!