How to Build a SAWT DAT File From Multiple BIR Form 2307 Certificates: A Worked Example

Building a SAWT DAT file from multiple BIR Form 2307 certificates means listing every certificate you received in the period as one detail row — payor TIN, payor name, ATC, income payment, and tax withheld — then generating a DAT file whose totals tie exactly back to those certificates. The resulting file supports the creditable withholding tax (CWT) credit you claim on your quarterly or annual income tax return, such as BIR Form 1701Q.

This guide walks through a full numeric example: a freelance consultant who received three BIR Form 2307 certificates from three different clients in one quarter, how each certificate’s figures map into a SAWT row, and how the combined CWT credit is applied against the income tax due. For the underlying definition and filing rule, start with What Is SAWT?.

Why consolidate multiple BIR Form 2307 certificates into one SAWT? #

A taxpayer who receives income from more than one payor in a quarter accumulates one BIR Form 2307 certificate per payor, but the BIR return claiming the credit needs a single consolidated schedule, not a stack of separate certificates. SAWT is that schedule — it is the payee’s side of the withholding transaction, built to let the BIR verify a CWT credit electronically instead of manually cross-checking paper certificates against the return.

Each certificate already proves the amount withheld by one payor for one period. SAWT does not replace those certificates — it summarizes them into Alphalist-layout rows so the BIR’s own validation module can check the data mechanically. The certificate itself, covered in What Is BIR Form 2307?, stays on file as the supporting document behind each SAWT row.

What is the legal basis for requiring SAWT? #

SAWT’s legal basis traces to Section 2.57.2 of Revenue Regulations (RR) No. 2-98, which created the creditable withholding tax system, and to RR No. 2-2006, which made the consolidated alphalist a mandatory attachment whenever that credit is claimed. RR No. 2-2006 is titled, in full, “Mandatory Attachments of the Summary Alphalist of Withholding Agents of Income Payments Subjected to Tax Withheld at Source (SAWT) to Tax Returns with Claimed Tax Credits Due to Creditable Tax Withheld at Source.”

Section 2 of RR No. 2-2006 states the requirement directly:

“SECTION 2. Mandatory Submission of Summary Alphalist of Withholding Agents of Income Payments Subjected to Creditable Withholding Taxes (SAWT) by the Payee/Income Recipient.”

That section heading is the operative rule: the obligation to submit SAWT sits with the payee — the income recipient claiming the credit — not with the payors who issued the BIR Form 2307 certificates. RR No. 2-2015 later carried the same Section 2 language forward and tied submission to the electronic modes introduced by RR No. 1-2014, which RMC No. 5-2014 clarified further. Under those issuances, SAWT reaches the BIR as an eFPS attachment, through the eSubmission facility, or by email to the taxpayer’s RDO, in every case as a validated DAT file rather than loose certificate scans. Official texts and current issuances remain on bir.gov.ph.

What fields does each SAWT row need? #

Each SAWT detail row reproduces five pieces of data taken directly from one BIR Form 2307 certificate: the payor’s TIN, the payor’s registered name, the Alphanumeric Tax Code (ATC) printed on the certificate, the income payment amount, and the tax withheld amount. The period covered must also match the return the SAWT supports.

One row represents one certificate. If a single payor issued more than one certificate in the period — for example, a monthly retainer billed and withheld on separately each month — some SAWT layouts allow consolidating same-payor, same-ATC rows into one line, but the combined totals must still equal what the certificates show.

Worked example: three BIR Form 2307 certificates, one SAWT #

A freelance IT consultant who billed three corporate clients in the third quarter of 2026 received three separate BIR Form 2307 certificates — one per client — each withheld at 10% under Alphanumeric Tax Code WI010 (professional fees paid to an individual payee, sworn declaration on file). Names and TINs below are fictional for illustration only.

The consultant opted into the 8% income tax rate on gross receipts in lieu of the graduated income tax rates and percentage tax, under Section 24(A)(2)(b) of the Tax Code as amended by the TRAIN Law (RA No. 10963), and this was the consultant’s first quarter of operations for the year, so the full ₱250,000 annual deduction is still available against this quarter’s gross receipts.

The three certificates:

Step 1 — List each certificate as one SAWT DAT row. The SAWT file for Q3 2026 carries three detail lines, each reproducing a certificate’s payor TIN, payor name, ATC, income payment, and tax withheld exactly as printed:

111222333000|BRIGHT HORIZONS CONSULTING CORP|WI010|150000.00|15000.00
222333444000|METRO FINTECH SOLUTIONS INC|WI010|220000.00|22000.00
333444555000|COASTAL REALTY HOLDINGS INC|WI010|130000.00|13000.00

(The exact delimiter, field order, and header requirements come from the BIR’s current Alphalist Data Entry and Validation Module — the layout above illustrates the mapping, not a literal file to submit without validating through that module first.)

Step 2 — Confirm the SAWT total ties to the certificates. Total income payment is ₱500,000.00 and total tax withheld is ₱50,000.00, matching the three certificates line for line. A SAWT that shows a different total than the certificates on file — even a rounding difference of a few pesos — is a common source of a BIR query.

Step 3 — Apply the CWT credit on BIR Form 1701Q. The consultant’s gross receipts for the quarter are ₱500,000.00. Under the 8% rate, with the ₱250,000.00 annual deduction available in full this quarter:

The ₱50,000.00 CWT credit exceeds the ₱20,000.00 income tax due for the quarter, so no tax is payable this period. The ₱30,000.00 excess is not refunded on the spot — it carries forward and reduces the income tax due on the consultant’s next quarterly return, consistent with how creditable withholding tax is applied against tax liability under the Tax Code. This is the mechanism SAWT exists to document: the certificates prove the ₱50,000.00 was actually withheld and remitted by the three payors, and the SAWT is the machine-readable schedule that lets the BIR verify the credit against the return without re-keying each certificate by hand.

Common mistakes when consolidating several certificates #

Most SAWT errors on multi-certificate quarters come from treating the consolidation step casually — copying an ATC from memory instead of the certificate, or skipping a certificate that arrived late. Each of the following breaks the one-to-one tie between certificates and SAWT rows that the BIR’s validation checks for.

• Typing one ATC for every row out of habit, even when certificates from different payors carry different codes for similar-sounding services
• Omitting a certificate that arrived after the return was almost ready, which understates both the income reported and the credit claimed
• Entering income payment net of the withheld tax instead of the gross amount shown on the certificate
• Using a shortened or trade name for the payor instead of the registered name printed on the certificate
• Letting the SAWT total drift from the certificate total by a rounding adjustment made during data entry rather than during the certificate’s own computation

From spreadsheet to validated DAT file #

Once every certificate for the period is listed in one spreadsheet, the remaining step is converting that spreadsheet into a DAT file the BIR’s Alphalist module accepts — a mechanical conversion, separate from the certificate-matching work covered above. The column layout, delimiter rules, and validation steps for that conversion are covered in How to Convert Excel to BIR DAT File for SAWT.

A generic spreadsheet-to-DAT converter checks formatting — TIN length, required fields — but does not check whether a row’s ATC or amount actually matches the certificate behind it. What that gap looks like in practice, and what a certificate-aware alternative adds, is covered in Best BIR Excel Uploader Alternative for SAWT Filing.

Frequently asked questions #

Do I need a separate SAWT DAT file for each BIR Form 2307 certificate I received? #

No. SAWT consolidates every BIR Form 2307 certificate for the period into one DAT file — one detail row per certificate (or per payor/ATC combination, depending on the layout) — not a separate file per certificate. You submit a single SAWT alongside the return claiming the credit.

What happens if two clients issue me BIR Form 2307 certificates under different ATC codes for the same type of work? #

Each SAWT row must carry the ATC actually printed on the certificate it represents, even if two payors used different codes for similar work. Do not standardize ATCs to match each other — the SAWT must mirror what each payor withheld and reported, not what you think the correct code should have been.

Can the total creditable withholding tax from my SAWT exceed the income tax due for the quarter? #

Yes. If the certificates withhold more tax than the quarter’s income tax due, the excess is not refunded immediately — it carries over and reduces the income tax due on the next quarterly or annual return, consistent with how creditable withholding tax credits are applied under the National Internal Revenue Code.

Do I still need to keep the original BIR Form 2307 certificates after filing the SAWT? #

Yes. The SAWT DAT file is a summary, not a replacement for the underlying documents. Keep the original or scanned BIR Form 2307 certificates on file, since the BIR can ask for them to substantiate the creditable withholding tax credit claimed on the return the SAWT supports.

What if a client forgets to give me a BIR Form 2307 certificate before I file? #

Omit that payment from the SAWT and the credit claim for the period, since a SAWT row without a supporting certificate is not substantiated. Follow up with the client for the certificate and claim the credit in a later period or through an amended return once you have it on file.

Summary #

Consolidating multiple BIR Form 2307 certificates into one SAWT DAT file means listing each certificate’s payor TIN, payor name, ATC, income payment, and tax withheld as its own row, then confirming the file’s totals tie exactly to the certificates on hand before generating the DAT file. In the worked example above, three certificates totaling ₱500,000.00 in income and ₱50,000.00 in tax withheld became three SAWT rows, and that ₱50,000.00 credit more than offset the ₱20,000.00 income tax due on the quarter’s BIR Form 1701Q. For the rule requiring SAWT in the first place, see What Is SAWT?; for the Excel-to-DAT conversion mechanics, see How to Convert Excel to BIR DAT File for SAWT; and for what a certificate-aware tool adds over a generic converter, see Best BIR Excel Uploader Alternative for SAWT Filing.