Alphalist Conversion to BIR .Dat File Format

Reporting Types:

Reporting Dates:

Company TIN No.:

Branch Code:

Classification:

RDO Code:

Browse Alphalist Excel File

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.

Error encounter during processing the possible tips to be fixed are:

Delete empty row between the header report and Total Amount.
Empty cell should have a value of 0 or 0.00 for column amount.
Column dates should be in custom format "MM/dd/yyyy".
Missing worksheet name required sequence e.g.: 1604C-1, 1604C-2
Avoid row data below Overall Total Amount.

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

Human Resources Management Common Function

The common functions of Human Resources include hiring, training, compensation and benefits, performance management, employee relations, and compliance with employment and labor laws.

Biometric Time Attendance that Integrate Seamlessly in Existing System

Biometric Time Attendance is a system that is used to measure and record the attendance of employees in an organization. It typically uses biometric data such as fingerprints, facial recognition, and retinal scans to identify and authenticate employees.

Daily Filing of Overtime to Integrate in Timekeeping Process

Overtime data entry is a process used to ensure accurate and consistent tracking of overtime worked by employees. This data is used to calculate the hours worked by employees in a given period, as well as to calculate the overtime pay they are owed.

Why Paperless HRIS is Preferred in changing the HR Processes

Investing in a comprehensive HR software system can help your HR department automate and streamline many of its processes. This system can include features such as applicant tracking, performance management, time and attendance tracking, and payroll processing.

Automate Employees Loan Deduction in Every Payroll Process

Automate the loan deduction process by setting up a payroll deduction for each employee loan. This can be done by creating a payroll deduction category specifically for the loan and linking it to the employee's loan.

Benefits of Automated Timekeeping and Attendance Solution

Automated timekeeping and attendance solutions make it easier for employees to track their time and attendance. This can lead to increased productivity, as employees are better able to focus on their work rather than worrying about the accuracy of their time tracking.

Steps How to Manage an HRIS Software Implementation

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.