Annual Payroll Workbook Financial Year 2025-2026

Description
A payroll workbook I built for Pakistani companies. It is a single Excel file that runs the entire July 2025 to June 2026 financial year, from the first monthly register to Full & Final Settlement.

✅ FBR Tax Year 2026 progressive income-tax slabs, applied automatically every month
✅ EOBI, Provident Fund, Social Security and Gratuity. All rates editable from one Control Panel
✅ 12 monthly payroll registers that auto-prorate for mid-month joiners and leavers
✅ A dropdown-driven payslip generator
✅ A one-click bank disbursement sheet
✅ An annual summary with full tax reconciliation
✅ A dashboard with department breakdown and a 12-month trend
✅ A full & final settlement statement for departing staff

It's pre-loaded with 150 sample employees. Full-year staff, mid-year joiners, mid-year leavers, even short-tenure hires, so every formula gets tested before you ever touch real data. Every number is a live formula. Nothing is hardcoded.

If you run payroll for a Pakistani company, or build tools for people who do, I think you'll find this useful.

Name of Worksheets in file:
README
Control Panel
Tax Slabs
Employee Master
25-Jul
25-Aug
25-Sep
25-Oct
25-Nov
25-Dec
26-Jan
26-Feb
26-Mar
26-Apr
26-May
26-Jun
Annual Summary
Payslip
Bank Advice
Annual Dashboard
Final Settlement


Connect for more Excel/Payroll builds.