How to Generate a QAP DAT File From BIR Form 1601F in BIR Online Tools

Generating a QAP DAT file from BIR Form 1601F means downloading BIR Online Tools’ three-schedule Excel template, filling in final withholding, fringe benefit, and exempt payee entries as applicable, then uploading it back for validation and DAT file generation. This guide uses the template’s own shipped example rows, which validate successfully as-is, so every screenshot shows real, computed figures.

This guide is part of the App Guide series and builds on the QAP overview. BIR Form 1601F attaches to BIR Form 1601-FQ; for expanded withholding or decedent-deposit withholding instead, see BIR Form 1601E or BIR Form 1621.

How is BIR Form 1601F different from BIR Form 1601E? #

BIR Form 1601F covers final withholding tax rather than creditable/expanded withholding — payments where the tax withheld is the full and final tax on that income, not a credit against a later return. Because final withholding covers a broader mix of payment types, its QAP template adds a third schedule sheet that BIR Form 1601E doesn’t need.

How do you generate a DAT file from BIR Form 1601F payee data? #

1. Open Form 1601F QAP and download the template #

From the sidebar, click QAP, then Open Form 1601F. Click Download Excel Template — the file ships with example rows across all three schedule sheets so you can see the expected layout for each payment type before entering your own data.

2. Fill in your payee data across the applicable schedules #

• Details Sched 1 (required) — final withholding entries: payee TIN, branch code, name, ATC, income payment, and tax withheld
• Details Sched 2 (optional) — fringe benefit entries, including the fringe benefit amount and its gross-up
• Details Sched 3 (optional) — exempt payee entries with no tax withheld

Only .xlsx files are accepted, and you only need rows on the schedules that apply to your filing period.

3. Upload the completed workbook and review validation #

Click Upload Excel File. BIR Online Tools reads every row across all three sheets, then validates and shows every error at once if anything fails, or a full summary if everything passes.

The summary reports each schedule’s totals separately — Sched 1 income payment and tax withheld, Sched 2 fringe benefit, gross-up, and tax withheld, and Sched 3 income payment — since each represents a different category of final withholding.

4. Download the DAT file #

Once validation passes, click Download DAT File. As with every QAP form, rows sharing the same payee TIN, branch code, and ATC are combined into one DAT detail line with amounts summed, and the finished file autosaves to your DAT Repository.

Frequently asked questions #

What does BIR Form 1601F’s QAP alphalist cover? #

Final withholding — the monthly final income tax remittances, fringe benefits, and exempt payees attached to BIR Form 1601-FQ, as distinct from BIR Form 1601E’s expanded/creditable withholding.

What schedule sheets does the 1601F template use? #

Three: Details Sched 1 for final withholding (required), Details Sched 2 for fringe benefits (optional), and Details Sched 3 for exempt payees (optional) — one more schedule than BIR Form 1601E because 1601F covers a wider set of payment types.

Do I need to fill in all three schedule sheets? #

No. Sched 1 is required for any final withholding entries; Sched 2 and Sched 3 are optional and only need rows if you have fringe benefit or exempt payee entries for the period.

How is the fringe benefit gross-up handled? #

The template’s Sched 2 example row shows a fringe benefit amount alongside a separately computed gross-up figure and tax withheld — the validation summary reports all three (fringe benefit, gross up, and tax withheld) once your workbook validates.

Summary #

Generating BIR Form 1601F’s QAP DAT file follows the same download-fill-upload-validate pattern as every QAP form, but spans three schedule sheets instead of two — final withholding, fringe benefits, and exempt payees. For the other two forms, see BIR Form 1601E and BIR Form 1621, or return to the QAP overview.