App Guide
BIR Online Tools is a free web app that converts Excel data into BIR-compliant DAT files and generates withholding tax certificates, so Philippine taxpayers and accountants can file without the official BIR Alphalist Data Entry tool. This series is a step-by-step, screenshot-by-screenshot guide to every module in the app — from adding your first company to generating QAP, SAWT, and RELIEF DAT files, issuing BIR Form 2307 certificates, and managing your DAT Repository.
Start here #
- Getting Started: Create Your Account and Add Your First Company — the required first step before any other module works
Company Info #
- Getting Started: Create Your Account and Add Your First Company
- Managing Company Profiles in BIR Online Tools
Dashboard #
QAP (Quarterly Alphalist of Payees) #
- QAP in BIR Online Tools: How It Works
- How to Generate a QAP DAT File From BIR Form 1601E
- How to Generate a QAP DAT File From BIR Form 1601F
- How to Generate a QAP DAT File From BIR Form 1621
SAWT (Summary Alphalist of Withholding Taxes) #
- SAWT in BIR Online Tools: How It Works
- How to Generate a SAWT DAT File for BIR Form 1700
- How to Generate a SAWT DAT File for BIR Form 1701
- How to Generate a SAWT DAT File for BIR Form 1701Q
- How to Generate a SAWT DAT File for BIR Form 1702
- How to Generate a SAWT DAT File for BIR Form 1702Q
- How to Generate a SAWT DAT File for BIR Form 2550M
- How to Generate a SAWT DAT File for BIR Form 2550Q
- How to Generate a SAWT DAT File for BIR Form 2551Q
- How to Generate a SAWT DAT File for BIR Form 2553
RELIEF #
- RELIEF in BIR Online Tools: How It Works
- How to Generate a RELIEF Sales DAT File
- How to Generate a RELIEF Purchases DAT File
- How to Generate a RELIEF Importations DAT File
BIR Certificates #
- BIR Certificates in BIR Online Tools: An Overview
- How to Generate a Single BIR Form 2307 PDF: Create, Download, or Email It — part of the BIR Form 2307 series
- How to Bulk-Generate BIR Form 2307 PDFs From Excel
- How to View and Manage Saved BIR Form 2307 Certificates
DAT Repository #
Account #
How the app works #
Topics in this series #
- Setting up a company profile and switching between companies
- Converting Excel data to QAP, SAWT, and RELIEF DAT files
- Generating and delivering BIR Form 2307 certificates, single or in bulk
- Managing saved DAT files and certificates
- Account, billing, and offline/sync behavior
New guides are added as BIR Online Tools ships new features. Each post is tagged bir-online-tools for easy reference.
2026
