How to Convert Excel to BIR DAT File for RELIEF SLSP (Sales and Purchases)
Converting Excel to BIR DAT file for RELIEF SLSP means formatting your quarterly sales and purchases data into the column layout the BIR’s Alphalist Data Entry and Validation Module expects, then generating a DAT file for submission alongside your quarterly VAT return. SLSP applies specifically to VAT-registered taxpayers whose quarterly sales or purchases cross set thresholds under Revenue Regulations No. 8-2002.
This guide covers who needs to file SLSP, the thresholds and deadline, how to structure your Excel file, and how to convert it to a BIR-compliant DAT file using the RELIEF module in BIR Online Tools.
What is RELIEF SLSP? #
RELIEF SLSP is the Summary List of Sales and Purchases submitted under the BIR’s Reconciliation of Listing for Enforcement (RELIEF) system, established by Revenue Regulations No. 8-2002. It requires VAT-registered taxpayers above certain thresholds to list their sales and purchases transactions quarterly in a structured, machine-readable DAT file, so the BIR can cross-match reported sales against buyers’ claimed input tax.
Who must submit a Summary List of Sales and Purchases? #
A VAT-registered taxpayer must submit SLSP once quarterly sales or purchases cross the thresholds set in RR No. 8-2002 — the requirement applies separately to sales and to purchases, so a taxpayer could owe one, both, or neither depending on transaction volume.
| Listing | Threshold | Basis for the amount |
|---|---|---|
| Summary List of Sales | Quarterly sales/receipts exceeding P2,500,000 | Taxable (net of VAT), zero-rated, and exempt sales combined |
| Summary List of Purchases | Quarterly purchases exceeding P1,000,000 | Taxable (net of VAT), zero-rated, and exempt purchases combined |
The continuing-obligation rule: under RMO No. 4-2003, once a threshold is crossed in one quarter, the taxpayer must keep submitting the corresponding summary list for the next three succeeding quarters, even if those quarters individually fall back below the threshold.
The Electronic Invoicing/Receipting System (EIS) carve-out: under Revenue Regulations No. 8-2022, taxpayers mandated onto the BIR’s EIS — large taxpayers, exporters, and e-commerce sellers covered by Section 237-A of the NIRC as amended by the TRAIN Law — are not required to submit the Summary List of Sales, since the BIR already receives that transaction data electronically through the EIS itself. The Summary List of Purchases and Importations is still required from these taxpayers; the exemption applies only to the sales side.
What columns does an SLSP Excel file need? #
An SLSP Excel file needs one row per counterparty per quarter, with the customer or supplier’s TIN, name, address, and a breakdown of the transaction amount into taxable, zero-rated, and exempt components, plus the related output or input VAT.
Typical Summary List of Sales columns:
| TIN | Registered Name | Address | Exempt Sales | Zero-Rated Sales | Taxable Sales (Net of VAT) | Output Tax |
|---|---|---|---|---|---|---|
| 123456789000 | ABC Trading Corp. | Makati City | 0.00 | 0.00 | 500000.00 | 60000.00 |
Typical Summary List of Purchases columns:
| TIN | Registered Name | Address | Exempt Purchases | Zero-Rated Purchases | Taxable Purchases (Net of VAT) | Input Tax |
|---|---|---|---|---|---|---|
| 987654321000 | XYZ Supplies Inc. | Quezon City | 0.00 | 0.00 | 300000.00 | 36000.00 |
Keep sales and purchases in separate sheets or separate files — the DAT layout for each listing is distinct, and mixing them in one upload will fail validation.
How do you convert Excel to BIR DAT file for RELIEF SLSP? #
Converting Excel to BIR DAT file for SLSP means uploading the prepared spreadsheet to a converter that maps your columns to the RELIEF layout, validates TINs and amounts, and outputs a properly delimited DAT file.
- Prepare separate sheets for the Summary List of Sales and Summary List of Purchases, using consistent column headers
- Format TINs as text, 9 to 12 digits, with no dashes or spaces
- Upload to the RELIEF module in BIR Online Tools and select Sales or Purchases
- Review the validation preview for TIN, amount, and required-field errors before generating the file
- Download the DAT file and submit it with your quarterly VAT return, on or before the 25th day following the close of the quarter
When is SLSP due, and what happens if it’s late? #
The Quarterly SLSP is due on or before the 25th day following the close of the taxable quarter, the same deadline as the quarterly VAT return (BIR Form 2550Q). Filing the DAT file late, or not at all when required, exposes the taxpayer to the same information-return penalty structure used elsewhere in BIR compliance: P1,000 per failure, capped at P25,000 per calendar year, under RMO No. 4-2003.
How does BIR Online Tools help with SLSP conversion? #
The RELIEF module in BIR Online Tools is built specifically for Summary List of Sales and Purchases conversion, rather than a generic spreadsheet-to-text converter. It validates TIN format and required fields before generating the DAT file, and keeps each quarter’s converted files in your company’s DAT Repository — useful given that SLSP isn’t always a one-time filing: once you cross a threshold, you’re committed to filing for three more quarters, so having last quarter’s file on hand to check consistency matters more than it would for a single, isolated submission.
Frequently asked questions #
What is RELIEF SLSP? #
RELIEF SLSP stands for the Reconciliation of Listing for Enforcement’s Summary List of Sales and Purchases — a quarterly listing of a VAT-registered taxpayer’s sales and purchases, submitted to the BIR in DAT file format under Revenue Regulations No. 8-2002.
Who is required to submit a Summary List of Sales and Purchases? #
VAT-registered taxpayers with total quarterly sales or receipts exceeding P2,500,000 must submit a Summary List of Sales, and those with total quarterly purchases exceeding P1,000,000 must submit a Summary List of Purchases, as set out in Revenue Regulations No. 8-2002.
What happens after I cross the SLSP threshold once? #
Once a taxpayer’s quarterly sales or purchases exceed the applicable threshold, RMO No. 4-2003 requires the summary list to be submitted for the next three succeeding quarters, regardless of whether those later quarters individually exceed the threshold.
When is the SLSP due? #
The Quarterly SLSP is due on or before the 25th day following the close of the taxable quarter, aligned with the deadline for filing the quarterly VAT return (BIR Form 2550Q).
What is the penalty for not submitting SLSP on time? #
Failure to submit the SLSP, or submitting a defective file, can result in a penalty of P1,000 per failure, up to a maximum of P25,000 per calendar year, under RMO No. 4-2003.
Do taxpayers on the BIR’s Electronic Invoicing System still need to submit the Summary List of Sales? #
No. Under Revenue Regulations No. 8-2022, taxpayers mandated onto the BIR’s Electronic Invoicing/Receipting System (EIS) — including large taxpayers, exporters, and e-commerce sellers — are not required to submit the Summary List of Sales, since the BIR already receives that data electronically. They must still submit the Summary List of Purchases and Importations.
Summary #
Converting Excel to BIR DAT file for RELIEF SLSP means structuring your sales and purchases data into separate, correctly formatted listings once quarterly thresholds of P2,500,000 (sales) or P1,000,000 (purchases) are crossed, then submitting the resulting DAT file by the 25th day after quarter-end. Because crossing a threshold once locks in three more quarters of filing under RMO No. 4-2003, a repeatable conversion process matters — BIR Online Tools’ RELIEF module validates the file before generation and keeps each quarter’s DAT file organized in your company’s repository.