QAP DAT File Reconciliation: Matching Quarterly Totals to Your Annual 1604-E

Reconciling QAP means confirming that the sum of a payee’s expanded withholding tax entries across all four quarterly QAP DAT files equals that same payee’s row on the annual BIR Form 1604-E Alphalist of Payees, before the March 1 filing deadline. The two filings report the same year of withholding activity at different intervals, so a gap between them almost always traces back to one of three causes: a late-registered payee, a corrected BIR Form 2307 that was never carried back into its quarter’s QAP, or an Alphanumeric Tax Code (ATC) applied inconsistently across quarters.

Why QAP and 1604-E totals should tie out in the first place #

QAP and BIR Form 1604-E’s alphalist are not two independent reports — one is a quarterly slice and the other is the full-year consolidation of the exact same withholding relationships. Both trace back to Section 2.83.3 of Revenue Regulations (RR) No. 2-98, as amended, which requires withholding agents to submit alphalists of payees on income payments subject to creditable withholding tax as an integral part of both the quarterly remittance returns and the Annual Information Returns. Secondary summaries of the amended provision describe the requirement this way:

“All withholding agents shall, regardless of the number of employees and payees, whether the employees/payees are exempt or not, submit an alphabetical list of employees and list of payees on income payments subject to creditable and final withholding taxes.”

— Section 2.83.3, Revenue Regulations No. 2-98, as amended, quoted in tax-practitioner commentary summarizing the alphalist submission requirement

Revenue Regulations No. 11-2018 carried this requirement forward for the current forms: the Quarterly Alphalist of Payees (QAP) attaches to BIR Form 1601-EQ (expanded withholding) or 1601-FQ (final withholding) each quarter, while BIR Form 1604-E’s Alphalist of Payees consolidates the full calendar year and is due on or before March 1 of the following year. Because both alphalists draw on the same payee-level records — the same ones used to prepare each BIR Form 2307 certificate during the year — a payee’s annual 1604-E figure is expected to equal the sum of that payee’s entries across whichever quarters they were reported in. For the fuller side-by-side of what each filing covers and when, see QAP vs Annual Alphalist (1604-E).

The three most common causes of a QAP-to-1604-E mismatch #

Most gaps between summed QAP totals and the draft 1604-E alphalist come from one of three sources: a payee who registered with BIR partway through the year, a corrected BIR Form 2307 whose adjustment stayed in the books but never reached the DAT file, or an ATC that changed between quarters for the same payee. Each looks like a discrepancy on the surface, but only two of the three are actual errors — the third is a legitimate timing difference that just needs to be understood, not “fixed.”

Late-registered payees #

A payee who only received a BIR-issued TIN in, say, June will not appear in the Q1 QAP at all, and may show a partial-year figure even in the quarter they first appear if withholding started mid-quarter. This is not a reconciliation error — the 1604-E figure for that payee should equal the sum of only the quarters in which they were validly reported, not four quarters’ worth. Filing a QAP entry for a payee before they had a registered TIN would itself violate the TIN requirement covered in correcting a wrong or missing payee TIN; the fix here is simply confirming the 1604-E total matches the quarters that actually applied, not padding earlier quarters to make four periods look complete.

Corrected or reissued BIR Form 2307s #

When a billing dispute, a duplicate invoice, or a data-entry error is caught after a quarter’s QAP has already been filed, the withholding agent typically reissues a corrected BIR Form 2307 to the payee. If the correction is made in the accounting ledger and on the certificate but the original quarter’s QAP DAT file is never amended and resubmitted, the QAP-as-filed total for that quarter keeps the old, uncorrected figure — and neither the corrected books nor the eventual 1604-E draft will match the sum of the QAP files actually on record with the BIR.

ATC misclassification across quarters #

The same recurring payee can end up coded under two different Alphanumeric Tax Codes in different quarters — for example, a supplier billed as a goods vendor (ATC WC160, 1%) in Q1–Q2 and then miscoded as a services provider (ATC WC158, 2%) in Q3 after a mixed invoice confused the bookkeeper. Because the withholding rate differs between the two codes, the tax-withheld figures for the “same” payee no longer add up consistently across quarters even if the income amounts do. This is the same root cause covered in correcting a wrong ATC on a filed withholding tax return, applied here at the reconciliation-checking stage rather than after a return is already filed.

Worked example: tracing a corrected-2307 mismatch before filing 1604-E #

The scenario and figures below are entirely fictional, built to illustrate how a corrected certificate can leave the QAP-as-filed total and the annual 1604-E draft out of step even after the underlying books are fixed. Meridian Trading Corp. withholds expanded withholding tax from a recurring services supplier, Lumina Print Services (fictional TIN 234-567-890-000), under ATC WC158 (services, 2%), throughout 2026.

In Q3, Meridian’s bookkeeper discovers that a Q3 invoice was overbilled — the actual services rendered totaled ₱150,000, not the ₱200,000 originally invoiced and withheld against. Meridian reissues a corrected BIR Form 2307 to Lumina Print Services showing the reduced ₱150,000 income and ₱3,000 tax withheld, and updates the accounting ledger accordingly. But the Q3 QAP DAT file, already submitted with the original ₱200,000/₱4,000 figures, is never amended.

When Meridian’s accountant drafts the 1604-E alphalist in February 2027, pulling straight from the corrected ledger, Lumina Print Services shows ₱750,000 income and ₱15,000 tax withheld — a figure that does not match the ₱800,000 and ₱16,000 that the four QAP DAT files actually filed with the BIR during the year sum to. Neither number is “wrong” in isolation; they simply reflect two different versions of Q3 that were never reconciled to each other.

Tracing and fixing it: the ₱50,000 income / ₱1,000 tax gap isolates cleanly to Q3 once totals are compared quarter by quarter instead of only at the annual level. Because the certificate was already corrected, Meridian should also amend and resubmit the Q3 QAP DAT file to carry the corrected ₱150,000/₱3,000 figures — consistent with the amended-return process under NIRC Section 6(A) — so that the QAP-as-filed sum (now ₱750,000/₱15,000) matches both the corrected books and the 1604-E draft before filing, rather than carrying an unreconciled ₱50,000 gap into the annual return.

Reconciliation checklist before filing 1604-E #

1. Export each payee’s tax withheld from all four quarters’ QAP DAT files and sum by TIN, not just by quarter.
2. Pull the same payee’s row from the draft 1604-E alphalist and compare the annual figure to the QAP sum.
3. Check by ATC as well as by grand total — an ATC that changed mid-year can offset against another and hide a real gap in the total alone.
4. Confirm any payee missing from an earlier quarter has a legitimate reason — a late-registered TIN or a transaction that genuinely started later in the year — rather than assuming every partial-year payee is an error.
5. Cross-check any corrected or reissued BIR Form 2307 against the QAP DAT file for the quarter it corrects, confirming the DAT file itself was amended, not just the certificate and the ledger.
6. Trace any remaining gap to a specific quarter and payee before adjusting the 1604-E draft — don’t force the annual total to match by editing a number with no underlying transaction behind it.
7. Re-run the corrected 1604-E draft through the BIR Alphalist Data Entry and Validation Module for a zero-error report before eSubmission — see validating a BIR DAT file before eSubmission for that step.

Frequently asked questions #

Why should QAP quarterly totals match the annual 1604-E alphalist? #

BIR Form 1604-E’s Alphalist of Payees is a year-end consolidation of the same expanded withholding tax activity already reported quarter by quarter through QAP DAT files attached to BIR Form 1601-EQ or 1601-FQ. Because both draw on the same underlying payee, ATC, and withholding records, the annual per-payee totals on 1604-E should equal the sum of that payee’s four quarterly QAP entries.

What causes a mismatch between QAP and 1604-E totals? #

The three most common causes are a late-registered payee whose TIN only became valid partway through the year, a corrected or reissued BIR Form 2307 whose adjustment was never carried back into the quarter’s QAP DAT file, and an Alphanumeric Tax Code applied inconsistently to the same payee across different quarters.

Does a late-registered payee count as a reconciliation error? #

Not on its own. A payee who only obtained a BIR-registered TIN partway through the year will legitimately appear in fewer than four quarters of QAP, and the 1604-E should still tie to the sum of the quarters in which that payee was actually reported. The check is whether the amounts across those quarters add up correctly, not whether every payee appears in all four.

If I issue a corrected BIR Form 2307 mid-year, does the QAP DAT file need to change too? #

Yes, if the corrected certificate changes the income or tax withheld reported for that payee. The QAP DAT file for the quarter the correction relates to should be amended and resubmitted to match the corrected BIR Form 2307, otherwise the original, uncorrected figure stays in that quarter’s QAP total and never reconciles with either the corrected books or the annual 1604-E.

How do you check QAP against 1604-E before filing? #

Export each payee’s tax withheld from all four quarterly QAP DAT files, sum them by TIN, and compare that sum to the same payee’s row on the draft 1604-E alphalist. Do this at the per-payee level and by Alphanumeric Tax Code, not only on the grand total, since offsetting errors in different ATCs can cancel out and hide a real discrepancy.

What happens if I file 1604-E with totals that don’t reconcile to QAP? #

An unreconciled 1604-E can still pass the BIR’s structural validation and be accepted for filing, because the Alphalist Data Entry and Validation Module checks file format, not cross-period consistency. The mismatch surfaces later, when BIR’s own matching process compares 1604-E against the year’s QAP filings, potentially triggering a discrepancy notice or complicating a payee’s BIR Form 2307 credit claim.

Summary #

QAP and the annual BIR Form 1604-E alphalist report the same expanded withholding tax activity on different clocks, and the two should reconcile at the per-payee, per-ATC level before the March 1 deadline. Most gaps trace to one of three causes — a late-registered payee whose partial-year figures are actually correct, a corrected BIR Form 2307 whose adjustment never made it back into that quarter’s QAP DAT file, or an ATC that shifted mid-year for the same recurring payee — and the fix is always to trace the gap to a specific quarter and transaction rather than editing the annual total to force a match. Build the export-sum-compare habit into February’s close, before the 1604-E draft is finalized, and a mismatch becomes a five-minute correction instead of a discrepancy notice months later. For the underlying difference between the two filings, see QAP vs Annual Alphalist (1604-E); for the fuller list of 1604-E-specific rejection patterns, see Common 1604-E Alphalist of Payees Errors.