Excel to BIR DAT file. The short way.
Your list is already in Excel. Here is how it becomes the files RELIEF takes in.
The Summary List of Sales and Purchases (SLSP) goes to the BIR as DAT files. If your purchases and sales are already in a spreadsheet, you do not need to type them into RELIEF again.
Four steps
- Lay your list out in these columns. One row per receipt or invoice. Download the Excel template or the CSV.
- Save it as CSV (Save As, CSV UTF-8).
- Choose the CSV in ClockIN, on the File BIR page, SLSP / RELIEF DAT. Every line is checked.
- Make the files. You get the purchases DAT, the sales DAT, and an Excel showing every receipt behind them.
| Column | What goes in it |
|---|---|
type | purchase if you paid the seller, sale if it is your own invoice |
date | YYYY-MM-DD |
name | The registered name of the supplier or customer |
tin | Their TIN, all digits |
address | Their address as printed |
receipt_no | The receipt or invoice number |
total | The total amount, numbers only |
vat | The VAT printed, 0 if none |
vat_exempt, zero_rated | Those amounts if printed, else 0 |
kind | goods, services or capital |
What is done for you
- Names and addresses are cleaned to the RELIEF character rules.
- One line per supplier or customer for the quarter, with the totals added up.
- TINs of nine digits, header and file names written the way RELIEF expects.
- Every line that cannot be right is listed, with the reason: no TIN, VAT too high, the same receipt twice, a date outside the quarter.
Only some DAT files so far
ClockIN writes the RELIEF purchases and sales DAT files, which have passed the BIR’s validation for us. For SAWT and the 1604-C alphalist it prepares and checks the data and makes the Excel; their DAT layouts will be added once a file has passed the BIR’s validator.
Questions
Do I need to install anything?
No. It runs in your browser. The BIR’s own RELIEF validation module is still what you use to test the finished files.
Is my spreadsheet uploaded?
The checker on this site reads files in your browser and sends nothing. In ClockIN the list you check is kept for that quarter, in your own account, so you can come back to it.
My Excel has more columns.
Keep only these columns, in this order, or paste just those into the template.
Skip the hard part
Photograph the papers. ClockIN checks every line and makes the files.