BIR DAT File Checker & Builder (SAWT, QAP 1601-EQ)
Check a BIR SAWT or QAP (1601-EQ) .DAT file before you submit: every error explained with the line and the fix, totals recomputed, correct file name. Or build the .DAT from a form or Excel. Free, nothing uploaded.
Tool inputs stay in your browser · optional AI search sends your query
Loading tool…
Good to know: Reads SAWT and QAP (1601-EQ) .DAT files on your own device, using the BIR file structures in RMC No. 15-2025 Annex A (SAWT) and RMC No. 25-2024 Annex A (QAP), and the file-name rule in RMC No. 15-2025 Annex B. It checks TINs, branch codes, name lengths, the return period, ATC codes and rates, tax = income x rate, sequence numbers and the control totals, then explains each problem with the fix. The cleaned download fixes format only and never changes an amount. The ATC list is the one built into the official BIR Alphalist module v7.4, plus the three codes RR 24-2025 added later; an ATC the module does not know is flagged, because the module rejects it. The checks follow the same validation rules (4-digit branch, income above zero, tax = income x rate, control totals). This is a pre-check: the BIR still requires you to validate the file in its Alphalist Data Entry and Validation Module before eSubmission. Not tax advice.
How to use it (step by step)
- 1To check: drop your .DAT file (or open a sample). Nothing is uploaded; the file is read in your browser.
- 2Read "What to fix". Each item names the line and field, says what is wrong in plain words, and gives the fix. Errors first, then things to check, then notes.
- 3Press Download cleaned file to fix the format problems (TIN digits, branch, names, decimals, totals, file name). Correct any amount, rate or ATC the report flags in your source and check again.
- 4To build: choose QAP 1601-EQ or SAWT, fill in your TIN, period and RDO, then type the rows or paste them from Excel. The download unlocks when there are no errors.
- 5Last step: open the file in the BIR Alphalist Data Entry and Validation Module, validate, and submit by eSubmission.
Words to know
- DAT file
- The text file the BIR accepts for alphalists. Every line follows a fixed list of fields; one extra comma or a name that is too long makes the whole file fail.
- SAWT
- Summary Alphalist of Withholding Taxes: the list of taxes others withheld from you (from the 2307s you received), attached to 1701Q, 1702Q, 2550M, 2551Q and similar returns.
- QAP
- Quarterly Alphalist of Payees: the list of suppliers and payees you withheld tax from, attached to BIR Form 1601-EQ.
- ATC
- Alphanumeric Tax Code. Says what kind of payment it was and fixes the rate, for example WC158 (goods bought by a top withholding agent, 1%). WI is for individual payees, WC for corporations.
- Control line
- The last line of the file (CSAWT, C1 or C2) with the totals. It must equal the sum of the detail lines to the centavo.
- Branch code
- The last digits after the 9-digit TIN. Head office is 0000. In the file the TIN and branch go in separate fields.
- RDO
- Revenue District Office: the 3-digit code of the BIR office where you are registered.
Sources & methods
- BIR RMC No. 15-2025: Alphalist Data Entry and Validation Module v7.4 (PDF) ↗
- BIR RMC No. 15-2025 Annex A: SAWT file structure (PDF) ↗
- BIR RMC No. 15-2025 Annex B: standard file naming convention (PDF) ↗
- BIR RMC No. 25-2024 Annex A: QAP 1601-EQ and MAP file structures (PDF) ↗
- BIR: Revenue Regulations No. 11-2018 (expanded withholding rates, PDF) ↗
- Expanded withholding tax rates and ATCs, full table (sulat.ph) ↗
References checked November 18, 2026. Read each tool’s scope and assumptions before relying on its result.
Spotted a wrong result or an outdated rule? Report a mistake · How we check our tools · Get new tools by email