Alphalist Conversion to BIR .Dat File Format

Reporting Types:
Reporting Dates:
Company TIN No.:
Branch Code:
Classification:
RDO:

Excel Alphalist to Dat File

Guidelines How It Works

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

Download Alphalist Excel Template Report then try it for .dat file conversion. This alphalist template is credited to bir-excel-uploader.com for sharing this file.

• 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 constant row 1 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.

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 is confident that output file is okay, but still, we do not provide guarantee.

Alphalist File is not stored in the server.

Related Topics

BIR Alphalist .Dat File Format to Convert ITR Form 2316

Any suggestion or bugs... kindly Contact Us and i'am willing to fixed it.

Share to your Facebook Account to help others who need this tools. THANK YOU!