Skip to main content

How to Validate a BIR DAT File Before eSubmission

Before a RELIEF, SAWT, alphalist, or QAP DAT file can be submitted to the BIR, it has to pass the BIR’s own Alphalist Data Entry and Validation Module — a free, separate check the Bureau runs independently of whatever tool generated the file. Validating first means catching a rejected TIN or a malformed return period before it turns into a late or defective filing.

This guide covers where to get the Validation Module, how to run a check, what the error report actually flags, and how to fix the failures that come up most often.

What is the BIR Validation Module? #

The BIR Validation Module is the checking component of the Alphalist Data Entry and Validation Module, a free desktop application the Bureau of Internal Revenue distributes at bir.gov.ph/Downloadables. It reads a DAT file — the delimiter-separated format BIR uses for bulk submissions — and confirms the file matches the exact layout, field lengths, and data types required for that filing type before the BIR will accept it.

What it validates:

  • File structure and record layout for the specific form (RELIEF SLSP, SAWT, QAP, Alphalist, MAP, or SRS)
  • TIN format and digit count on every record
  • Return period formatting
  • Numeric field formatting (amounts must be stored as numbers, not text)
  • Alphanumeric Tax Code (ATC) values against the current BIR schedule

The BIR updates the module periodically to add new ATCs and rate changes. Revenue Memorandum Circular No. 15-2025 announced Version 7.4, which added new alphanumeric tax codes and updated rates for creditable and final withholding tax transactions — taxpayers who had already submitted using the older Version 7.3 were required to re-validate and resubmit. Always confirm you’re running the current version before validating, since a file that passed on an outdated version can fail once the BIR reprocesses it against updated codes.

How do you validate a DAT file? #

Validating a DAT file means running it through the downloaded Validation Module and reviewing the error report it produces — a clean report with zero errors is what allows the file to move to eSubmission. The process is the same regardless of which tool generated the original DAT file.

  1. Download and install the current Alphalist Data Entry and Validation Module from bir.gov.ph/Downloadables
  2. Open the module and select the filing type that matches your DAT file (for example, RELIEF Sales, SAWT, or QAP)
  3. Import or validate the DAT file generated by your source tool
  4. Review the validation report the module produces
  5. If errors appear, correct the underlying data and regenerate the DAT file, then re-validate
  6. Once the report shows zero errors, the file is ready for eSubmission

BIR Online Tools already checks your data against BIR’s field formats before it generates a DAT file — for example, the RELIEF and SAWT modules confirm the return period matches a strict MM/YYYY pattern, normalize and check TIN formatting, and reconcile computed output VAT against the reported amount within a small rounding tolerance before allowing the file to be exported. That pre-check catches most errors early, but it doesn’t replace the BIR’s own Validation Module — the Bureau’s module is the tool that determines whether the BIR itself will accept the submission, so run the final DAT file through it regardless of which converter produced it.

What does the validation report flag most often? #

The validation report lists every record that fails a structural or data check, referencing the sheet, row, and field so the error is easy to trace back to the source spreadsheet. Three failure types account for most rejections in practice.

Common errorCauseFix
Invalid TINMissing digits, extra spaces, or dashes left in the TIN fieldRe-enter the TIN as digits only, matching the 9–12 digit format for that field
Return period format errorPeriod entered as a full date or in YYYY-MM order instead of MM/YYYYCorrect the source column to MM/YYYY (e.g., 03/2026) before regenerating
Numeric field stored as textAmounts pasted from another system as text or with currency symbolsReformat the column as Number with two decimal places, with no currency symbol or thousands separator

Fixing an error always means correcting it in the source data and regenerating the DAT file — DAT files are not meant to be hand-edited directly, since a manual edit can silently break the fixed-format layout the Validation Module expects.

How do you submit a DAT file once it’s validated? #

Once the Validation Module reports zero errors, most RELIEF, SAWT, and alphalist DAT files are submitted by email to esubmission@bir.gov.ph, using the subject line format the BIR specifies for that filing type — typically the form type, TIN, RDO code, registered name, and period covered. The BIR replies with an eSubmission validation report confirming receipt, which is the taxpayer’s proof of timely filing.

This is a separate channel from the eAFS portal (eafs.bir.gov.ph), which mainly accepts PDF attachments to an already-filed return — audited financial statements, BIR Form 2316, and BIR Form 2307 certificates. Don’t confuse the two: a RELIEF or SAWT DAT file goes to the esubmission mailbox, not the eAFS portal.

Summary #

A DAT file isn’t ready for submission just because a converter produced it — it’s ready once the BIR’s own Alphalist Data Entry and Validation Module reports zero errors. Download the current version from bir.gov.ph/Downloadables, run the file through it, fix whatever the report flags (usually a TIN, a return period format, or a numeric field saved as text), and only then email the file to esubmission@bir.gov.ph.

This guide is part of the site’s excel-to-DAT series. For the conversion step that comes before validation, see Your First Excel to DAT Conversion and How to Convert Excel to BIR DAT File for RELIEF SLSP. New to BIR Online Tools generally? Start with Start Here: A Guide to BIR Online Tools.

Frequently asked questions #

What is the BIR Validation Module? #

The BIR Validation Module is part of the Alphalist Data Entry and Validation Module, a free application distributed by the Bureau of Internal Revenue at bir.gov.ph/Downloadables. It checks a generated DAT file for structural and data errors and produces a validation report before the file is submitted to the BIR.

Do I need to validate a DAT file even if BIR Online Tools already checked my data? #

Yes. BIR Online Tools validates your data against BIR’s field formats and layout rules before generating the DAT file, but it does not replace the BIR’s own Validation Module, which is the tool the BIR itself uses to accept or reject a submission. Always run the final DAT file through the official module before eSubmission.

Where do I download the BIR Validation Module? #

Download the Alphalist Data Entry and Validation Module from the BIR’s official downloads page at bir.gov.ph/Downloadables. The BIR periodically releases new versions — for example, Revenue Memorandum Circular No. 15-2025 announced Version 7.4, which added updated alphanumeric tax codes and withholding tax rates.

How do I submit a DAT file after it passes validation? #

Once the Validation Module reports zero errors, email the DAT file to esubmission@bir.gov.ph using the subject line format the BIR specifies for that filing type (form type, TIN, RDO code, registered name, and period covered). The BIR replies with an eSubmission validation report confirming receipt.

What’s the most common reason a DAT file fails validation? #

The most common failures are malformed TINs (wrong digit count or stray characters), a return period that isn’t in the exact MM/YYYY format the layout expects, and numeric fields saved as text instead of Number format in the source spreadsheet — each of these causes the Validation Module to reject the record.