Web Application Payroll Register

Pinoy web application payroll register is a data process that all lists of total information for every pay period upon approved by payroll approver before saving to the payroll register like total gross pay, total overtime, total allowances, total of each type of deduction, and total net pay. The computation for each individual employee like gross pay, net pay, withholding tax, overtime pay and other deduction amount seen in payslip report are stored in database table payroll register.

Information in payroll register are used to generate a report:

  1. Making a monthly payroll tax deduction.
  2. Submitting quarterly payroll tax reports.
  3. Providing annual wage and tax reports to employees.
  4. SSS Remittance Monthly Contribution.
  5. Philhealth Remittance Monthly Contribution.
  6. HDMF Remittance Monthly Contribution.
  7. Generate Alphalist report.
  8. Annual Income Tax Return (ITR Form 2316).
  9. Or other possible report to generate.

Payroll Register Table Structure

CREATE TABLE [dbo].[Payroll_Register] (
    [employee_id]    VARCHAR (15)    NOT NULL,
    [period_from]    DATETIME        NOT NULL,
    [period_to]      DATETIME        NOT NULL,
    [bcode]          VARCHAR (15)    NOT NULL,
    [month]          VARCHAR (2)     NULL,
    [year]           INT             NULL,
    [basic_pay]      NUMERIC (12, 2) NULL,
    [ot_pay]         NUMERIC (12, 2) NULL,
    [sh_pay]         NUMERIC (12, 2) NULL,
    [rh_pay]         NUMERIC (12, 2) NULL,
    [ndiff_pay]      NUMERIC (12, 2) NULL,
    [wtax]           NUMERIC (12, 2) NULL,
    [sss_ee]         NUMERIC (12, 2) NULL,
    [sss_er]         NUMERIC (12, 2) NULL,
    [sss_ec]         NUMERIC (12, 2) NULL,
    [pagibig_ee]     NUMERIC (12, 2) NULL,
    [pagibig_er]     NUMERIC (12, 2) NULL,
    [philhealth_ee]  NUMERIC (12, 2) NULL,
    [philhealth_er]  NUMERIC (12, 2) NULL,
    [loan_sss]       NUMERIC (12, 2) NULL,
    [loan_pagibig]   NUMERIC (12, 2) NULL,
    [loan_others]    NUMERIC (12, 2) NULL,
    [other_earn]     NUMERIC (12, 2) NULL,
    [late_deduct]    NUMERIC (12, 2) NULL,
    [utime_deduct]   NUMERIC (12, 2) NULL,
    [adjust_pay]     NUMERIC (12, 2) NULL,
    [add_back_pay]   NUMERIC (12, 2) NULL,
    [allowance]      NUMERIC (12, 2) NULL,
    [taxable_income] NUMERIC (12, 2) NULL,
    [net_pay]        NUMERIC (12, 2) NULL,
    [gross_pay]      NUMERIC (12, 2) NULL,
    PRIMARY KEY CLUSTERED ([employee_id] ASC, [bcode] ASC, [period_from] ASC, [period_to] ASC)
);