Configuration
Collapse menu
Fixed sidebar
Top navbar
Top navbar v.2
*Primary layout
Boxed layout
Fixed footer
Skins
Reporting Types:
Reporting Dates:
Company TIN No.:
Branch Code:
Classification:
RDO Code:

Guidelines How It Works

Download Alphalist v7.0 from BIR website and install this free program for your testing and validation module.

Download Alphalist Excel Template Report then try it for .dat file conversion.

• After downloading the excel file Alphalist Template Report, kindly analyze the sample data in the file. The format data will give you an idea on what your file should look like before copying the row data for .dat file output.

• The sequence of worksheet names 1604C-1, 1604C-2 should not be changed... you can add many worksheets as you want, but the first 2 worksheets are reserved.

• Alphalist where schedule type is empty or no record should be deleted the row data except the header value from row 1 to row 13 should not be removed.

• Don't insert additional column or delete column within the template worksheet... you can insert row data as many as you want, but the existing formula given within the cell is always there and also the TOTAL format and formula is available because the total amount value, it's also included on the output .dat file.

• Don't create formula in cell to get a value because the output column cell with formula will be 0.00 in .dat file except the existing formula given will get the value in .dat file output.

• If you want to create a formula to get a value used outside the column template, then use copy and paste special select "values" in desired column to copy the value without formula.

• Provide data in worksheet 1604C-1 column AP -> lastname, column AG -> firstname, column AR -> middlename for employee name separated field in dat file output.

• Provide data in worksheet 1604C-2 column BA -> lastname, column BB -> firstname, column BC -> middlename for employee name separated field in dat file output.

Disclaimer

Users are required to use BIR Alphalist Validation Module to ensure 100% compliance. This web application .dat file conversion tools created this December 2018, almost 2 weeks of development during my free time... (revised this year January 2021 for BIR Updates) on my self-testing and I'am confident that output file is okay, but still, we do not provide guarantee.

Alphalist File is not stored in the server.


LATEST BLOG POST

Steps How to Test and Explore HRIS and Payroll System

Step by step procedure how to test and explore the online application using available modules from employees master data and other setup-to-proceed user testing.

HR Private Employee Master Data

HR private employee master data contains the personal details, job information, educational background, training, allowance, and 201 files of your employees that all information stored in the database for easy retrieval of records.

HR Public Employee Master Data: Personal Data Sheet

Personal Information, Family Background, Educational Background, Civil Service Eligibility, Work Experience, Voluntary Work, Learning & Development, Other Information, Questionnaire, 201 Files, Payroll Setup, Job Information, Allowance.

HR Payroll System Application Modules

List of application modules available in HR & Payroll System like table maintenance, human resources, time & attendance, time keeping, payroll and customized HR & payroll reports etc.

How to Compute Payroll in Daily Rate or Monthly Rate

Source of payroll process is coming from the timekeeping processing called as work hour distribution that confirmed by employee and approved by head department prior to payroll processing.

How To Calculate Employees Regular Hours, Night Differential & Overtime

Computation of timesheet is tricky, not only recorded time in biometric device as source of data but we should include the approval filing of notices like locator slip, overtime, leave, broken time, invalid logs, and temporary shift.

How to Generate Timesheet from Biometric Time Logs

Biometric time logs row data contains a field with identifiers where time-in is equal to '0' and time-out is equal to '1' or other taggings to pair the daily time record.

DTR Biometric Finger Scanner Time-In/Time-Out Attendance System

Biometric fingerprint authentication is a solution for time attendance that is accurately and timely tracked for management reporting and accounting payroll processing.


Tips how to start?

  • Create an account.
  • Verify the account via email sent by the system after registration is completed.
  • Fill-up the form available in your dashboard account and wait for admin approval.
  • After your account is approved the first step to do is create a department located at HRD -> Tools -> Department.
  • Now ready to create employee master data located at HRD -> Employees.
  • Explore the HR Payroll user guide manual as reference for self-testing.

Free Online Tools