Comprehensive Monthly Payroll Workbook

Description
The "Comprehensive Monthly Payroll Workbook" is a detailed Excel-based system designed to manage and automate corporate salary processing. Users begin by configuring the Control Panel with specific company data, including attendance policies and statutory contribution rates for funds like EOBI and Social Security. The tool incorporates an Income Tax Slab sheet to ensure deductions align with current fiscal year legislation for salaried individuals. Central to the workbook is the Employee Master, which stores personnel records and contracted salaries, feeding data into a formula-driven Payroll Register that calculates net pay and the total Cost to Company. Final outputs include individual, printable payslips, a Bank Advice file for fund disbursement, and a visual Dashboard that summarizes departmental costs and headcount. This integrated approach allows for a streamlined transition from raw employee data to final financial reporting and payment.

README – how to use it

Control Panel – all editable assumptions (salary structure %, attendance/OT policy, EOBI/PF/SESSI/gratuity rates)

Tax Slabs – FBR salaried-individual slabs (TY 2026), auto-applied via VLOOKUP

Employee Master – 15 sample employees, CFO to Junior Officer, with bank details

Payroll Register – the engine: attendance/LOP proration → salary breakup → overtime → income tax (annualized method) → EOBI/PF → Net Pay → employer CTC (40 columns)

Payslip – pick an Employee ID from the dropdown, it auto-fills

Bank Advice – disbursement list ready for the bank

Dashboard – KPI cards, department-wise cost table, bar + pie charts