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

Generating a QAP DAT file from BIR Form 1621 means downloading BIR Online Tools’ single-schedule Excel template for decedent deposit account withdrawals, uploading your completed data, and downloading the validated DAT file. This guide uses the template’s own shipped example rows, which validate successfully as-is — including a full DAT file preview with real computed totals.

This guide is part of the App Guide series and builds on the QAP overview. For the other two QAP forms, see BIR Form 1601E and BIR Form 1601F.

What is BIR Form 1621 for? #

BIR Form 1621 covers tax withheld on amounts withdrawn from a decedent’s deposit account — a specific, narrower scenario than BIR Form 1601E or 1601F’s broader withholding categories, per BIR Form No. 1621. Because it covers one transaction type, its QAP template uses a single schedule sheet instead of two or three.

How do you generate a DAT file from BIR Form 1621 data? #

1. Open Form 1621 QAP and download the template #

From the sidebar, click QAP, then Open Form 1621. Click Download Excel Template — the file ships with example detail rows on Details Sched 1, the form’s single schedule sheet.

2. Fill in your withdrawal data #

Enter each withdrawal’s details: the depositor/payee’s TIN and branch code, name, the withdrawal date, the amount withdrawn, and the tax withheld. Only .xlsx files are accepted.

3. Upload and validate #

Click Upload Excel File. Once validation passes, the results card reports the parsed row count, the return period, and totals for the amount withdrawn and tax withheld.

4. Review the DAT file preview and download #

Scroll down to see the Download DAT File button alongside a text preview of the exact file content — header, detail, and control lines — before you commit to downloading.

The filename follows BIR’s convention — <TIN(9)><BC(4)><MMYYYY>1621.DAT — and the file autosaves to your DAT Repository as soon as it validates, alongside any other DAT files you’ve generated.

Frequently asked questions #

What does BIR Form 1621 cover? #

Tax withheld on amounts withdrawn from a decedent’s deposit account — a narrower, single-schedule scenario compared to BIR Form 1601E or 1601F’s broader withholding categories.

How many schedule sheets does the 1621 template use? #

One — Details Sched 1 — since BIR Form 1621 covers a single, specific transaction type rather than multiple payment categories.

What does the DAT file preview show before I download? #

A text preview of the exact DAT file content, including header, detail, and control lines, so you can review the data before downloading — the example workbook’s two rows produce a header line, two detail lines, and a control line totaling withdrawn amounts and tax withheld.

What does the downloaded DAT filename look like? #

It follows the pattern <TIN(9)><BC(4)><MMYYYY>1621.DAT, built from your active company’s TIN and branch code and the return period parsed from your uploaded workbook.

Summary #

Generating BIR Form 1621’s QAP DAT file is the simplest of the three QAP forms — one schedule sheet for decedent deposit withdrawals, the same download-fill-upload-validate pattern, and a DAT file preview before download. For the other two forms, see BIR Form 1601E and BIR Form 1601F, or return to the QAP overview.