QAP Guide for Philippine Withholding Tax Workflows

If your business pays rent, professional fees, contractor invoices, or commissions, you're probably a withholding agent — you hold back a slice of what you owe and remit it to the BIR on the payee's behalf. The Quarterly Alphalist of Payees (QAP) is the companion list to that remittance: the line-by-line record of everyone you withheld from during the quarter, and how much. It's the BIR's way of cross-checking that the lump sum on your withholding return actually came from real payees with real TINs. This guide explains what the QAP is, who files it, how it sits alongside your quarterly EWT remittance, why it travels as a DAT file, and how it reconciles to your books and to the 2307s you issue.

The short answer

The QAP is a quarterly alphalist — an alphabetical list of payees — that a withholding agent submits to substantiate the creditable withholding tax it withheld and remitted that quarter. Your quarterly remittance return reports a total withheld; the QAP breaks that total down payee by payee, so the BIR can match it to each payee's own records and to the 2307 certificates you handed out. It's filed as a DAT file through the BIR's electronic channels, and the right time to get it correct is when you record the payment — not when the deadline is bearing down.

Who this guide is for

• Business owners who withhold on rent, professional fees, or contractor payments and have to file a QAP each quarter.
• Bookkeepers and accountants assembling the QAP for clients and tired of rebuilding it by hand from scattered records.
• Anyone reconciling a withholding return that won't tie to the certificates issued, and needs to see where the QAP fits.

What the QAP actually is

The QAP is the payer's view of withholding. When you withhold creditable tax from a payment, three things have to agree: the amount you remit (your return), the certificate you issue to the payee (their 2307), and the line you report on your alphalist (the QAP). The QAP is the bridge between the single number on your remittance return and the many individual payees behind it. Each entry typically carries the payee's registered name, their TIN (in the BIR's standard 000-000-000-000 shape), the Alphanumeric Tax Code (ATC) for the income payment, the income amount, and the tax withheld.

It's an alphalist in the literal sense — the payees are listed alphabetically — and it's a quarterly one, which is what distinguishes it from the year-end alphalist that consolidates the whole year. Don't confuse the QAP with the SAWT: the QAP is what you, the payer, file to report tax you withheld from others; the SAWT is what a payee files to claim the tax that was withheld from them. Same certificates, opposite ends of the transaction.

How the QAP relates to your EWT remittance

Withholding has two moving parts: remitting the cash and reporting the detail. The quarterly remittance return — the 1601EQ-type form for expanded/creditable withholding — is where you declare and pay the total tax you withheld for the quarter. The QAP is the alphalist that supports that return: it itemizes the same total across every payee. Think of the return as the summary line and the QAP as the schedule behind it. They're filed as a pair, and the QAP's grand total has to equal what the return reports — if they don't tie, you have a reconciliation problem before the BIR even looks.

Why the QAP is a DAT file

Nobody wants to type a quarter's worth of payees into a web form, and the BIR doesn't want them to. So the QAP is submitted as a .DAT file — a strictly-structured, machine-readable data file the BIR's systems ingest directly. You build it in the BIR's offline alphalist data-entry tool (or generate it from software that writes the same layout), run it through the validation module to confirm the structure and reference data are sound, then transmit it through the BIR's electronic channel. The validator is exacting: a malformed record or a bad TIN fails the whole file. For the full mechanics of building, validating, and submitting these files, see the BIR DAT file guide.

How to prepare the QAP, step by step

1. 1

   Pull the quarter's withholding entries

   Gather every payment you withheld creditable tax on during the quarter, with the payee, the income amount, the ATC, and the tax withheld.

2. 2

   Group by payee

   Consolidate multiple payments to the same payee under one entry where the alphalist expects it, so each payee appears once with their total.

3. 3

   Confirm the reference data

   Check every payee's registered name and TIN against your master records — a wrong TIN or a name mismatch is the single most common DAT rejection.

4. 4

   Tie the total to your return

   Confirm the QAP's grand total of tax withheld equals the total on your quarterly remittance return before you generate the file.

5. 5

   Generate and validate the DAT file

   Produce the file in the BIR's alphalist tool (or compatible software) and run the validation module until it passes cleanly.

6. 6

   Submit and archive

   Transmit through the BIR's prescribed channel, then keep the validated file and the acknowledgement with your records so you can reproduce what you sent.

Reconciling the QAP to your 2307s

Here's the check that catches most problems before the BIR does: every line on your QAP should correspond to a 2307 you issued. When you withhold, you give the payee a BIR Form 2307 — the certificate they need to claim the tax as a credit on their own return (via their SAWT). If your QAP says you withheld a certain amount from a payee under a certain ATC, the 2307 you handed that payee must say the same thing. A payee on the QAP with no matching certificate, a certificate with no QAP line, or amounts that don't agree are all signals that something is out of sync. Reconciling the two before filing means your payees can claim their credits without disputes — and your return, your QAP, and your certificates all tell one story.

How this connects to your books

The QAP is hard to build after the fact and trivial to build as you go. The difference is whether your books capture the withholding at the moment of the payment. When each payment you record tags the payee, the ATC, the income amount, and the tax withheld — and posts a balanced entry that books the withholding payable — then the QAP is just a quarterly view of those entries, the remittance return is their total, and the 2307s are the same data formatted as certificates. One posted ledger, three outputs that automatically agree. Rebuild each one separately from spreadsheets and emailed certificates, and you've signed up for a reconciliation scramble every quarter — exactly the drift the validator (and later the BIR's cross-matching) will surface.

Common mistakes

• A QAP total that doesn't tie to the return. The alphalist's grand total must equal the remittance return's total — reconcile them before you generate the file.
• Wrong or missing TINs. A single bad TIN can fail the whole DAT file; keep payee master data clean rather than fixing it at deadline.
• Mismatched name formats. The payee's name on the QAP should match their BIR registration, not a nickname or a trade name.
• Mixing withholding types. Don't fold final-tax or compensation payees into the creditable-withholding QAP; classify by ATC first.
• QAP lines with no matching 2307. Every payee you report should hold a certificate that agrees — otherwise they can't claim the credit and the numbers won't cross-check.