Convert Excel Alphalist to BIR .Dat File Format
(www.hr-payroll.net)
From excel alphalist report will be converted to .Dat file format required by BIR.
Follow this steps:
======================
Alphalist excel report layout should not be tampered.
The sequence of worksheet name Sch 7.1, Sch 7.2, Sch 7.3, Sch 7.4, Sch 7.5 should not be change... you can add many worksheet as you want but the first 5 worksheet are reserved.
Alphalist where schedule type is empty or no record should be deleted the row data except the header constant row 1 to 12 for sch. 7.1, 7.2, 7.3 while sch. 7.4 & 7.5 start in row 1 to 13 should not 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 included in 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 used copy and paste special select "values" in desired column to copy the value without formula.
NOTE: User is required to use BIR Alphalist Validation Module to ensure 100% compliance.