Employee Masterlist
Structured employee, employment, compensation, government-number, and payroll information used by the system.
Excel-Based Payroll System
Centralize employee information, payroll computation, deductions, and reports.
A structured payroll solution that supports recurring payroll processing, payslip generation, contribution summaries, and annual working files.
Core Modules
A clear base for regular payroll processing.
Rules, tables, cutoffs, and outputs are configured according to the agreed company policy and project scope.
Payroll Computation Module
Period processing for salary, attendance-based items, overtime, allowances, deductions, statutory amounts, and net pay.
Key Features
Automate recurring calculations and reporting work.
Final formulas and outputs depend on the company’s approved payroll policies and maintained statutory settings.
- Automated payroll computation. Calculate salary, overtime, allowances, deductions, and net pay using configured payroll rules.
- Government deductions. Compute SSS, PhilHealth, Pag-IBIG, and withholding tax from maintained tables and settings.
- PDF payslip generation. Generate individual payslips or batch-ready PDF files for the payroll period.
- Monthly and annual reporting. Prepare payroll summaries and year-to-date reports for management and reconciliation.
- Contribution consolidation. Summarize employee and employer contributions for SSS, PhilHealth, and Pag-IBIG.
- BIR Form 1601-C support. Consolidate withholding tax on compensation for periodic reporting.
- Annual Alphalist preparation. Organize year-end compensation and withholding information for employee tax reporting.
- BIR Form 2316 generation. Prepare employee-specific, PDF-ready certificates from validated annual payroll data.
- VBA report and export tools. Automate selected payroll reports, PDF output, and file exports.
- Configurable project scope. Align modules and outputs with approved cutoffs, policies, and processing responsibilities.
System Outputs
Recurring payroll reports and employee documents.
- Payroll Register and Payroll Summary
- Individual and batch payslips in PDF format
- Government contribution reports
- BIR Form 1601-C working report
- Annual Alphalist working file
- BIR Form 2316 in PDF-ready format
Important: System settings and statutory tables should be reviewed whenever government contribution rates, tax rules, or company payroll policies change. VBA functions require the desktop version of Microsoft Excel with macros enabled. All payroll and statutory outputs must be reviewed by the responsible professional before official use.
Technology Note
Designed for desktop Microsoft Excel.
Compatibility: Features that use VBA, automated PDF generation, or desktop file access require a compatible desktop version of Microsoft Excel with macros enabled. Browser-based spreadsheet applications may not support the same automation.
Discuss the payroll workflow and outputs you need.
Share your employee count, cutoffs, payroll rules, current file, and reporting requirements.