Pakistan's Pension Calculator of all Provinces, including Federal, AJK, & Gilgit-Baltistan

Description
Overview
This best-practice Excel workbook calculates the gross pension payable to civil servants of all seven governments of Pakistan: Federal Government, Khyber Pakhtunkhwa, Punjab, Sindh, Balochistan, Azad Jammu & Kashmir, and Gilgit-Baltistan. It is the most comprehensive pension calculator of its kind available for the Pakistani civil service.


The Problem It Solves
Pakistan's pension increase history is fragmented. Each government follows slightly different rates, and the Punjab Finance Department's 2024 notification introduced a major reform that strips post-01-Jul-2024 retirees of four historical increases. Calculating this manually is error-prone. This tool eliminates the guesswork entirely.


Key Features

• Single input field (Government selector 1–7) instantly reconfigures all 12 increase rows for the correct jurisdiction
• Punjab 2024 Reform: rows for 2011, 2015, Jul-2022, and 2024 increases are automatically marked N/A for Punjab pensioners retiring on or after 01-Jul-2024, with a red warning banner
• Sindh-specific rates (2015=10%, Jul-2022=5%, 2025=8%) applied automatically
• April 2022 Federal ad-hoc increase correctly excluded for all non-Federal governments
• Pension Increase Rates reference sheet with all 9 columns (Federal through GB) for full transparency
• Commutation table, BPS Pay Scales, and a detailed How to Use guide with provincial variance notes

Who Should Use This
Finance officers, HR departments, pension section staff, individual civil servants planning retirement, and consultants advising government employees across Pakistan.