ClockIN← All BIR guides
Guide · updated 1 Nov 2026

Your SAWT, from a pile of 2307s.

Photos in, a checked list out. The reading is done by a free AI.

The SAWT, the Summary Alphalist of Withholding Taxes, lists the creditable tax your customers withheld, so the credit you claim on your quarterly income tax return is backed by names, TINs and amounts.

Four steps

  1. Collect the quarter’s 2307s and photograph each one, flat and in good light.
  2. Ask a free AI to read them. Open Gemini, Grok (on X) or ChatGPT, paste the prompt below, and attach the photos.
  3. Paste the table it gives back into the checker. Fix what it flags.
  4. Take the Excel. One line per payor and ATC, with the totals, ready for your accountant to key into the BIR’s module.

The prompt

Copy it exactly. The header line matters.

You are helping me prepare my BIR list of creditable withholding tax (the SAWT). I will attach photos or PDFs of BIR Form 2307 certificates that my customers gave me. For EACH income line on each certificate, read ONLY what is printed. Do not guess. If something is not printed or you cannot read it, leave it empty. Return ONE CSV table, nothing else, with exactly this header: payor,tin,address,period_from,period_to,atc,nature,income,withheld Rules: - payor: the name of the one who withheld the tax (the withholding agent), as printed. - tin: that payor's TIN as printed, digits only, keep all digits. - address: that payor's registered address as printed. - period_from and period_to: the "For the period" dates at the top, as YYYY-MM-DD. - atc: the ATC code on the income line, for example WC158, WC160 or WI010. - nature: the "Income payments subject to expanded withholding tax" description. - income: the TOTAL income payment on that line (all three months added), number only. - withheld: the TOTAL tax withheld on that line, number only. - One row per income line (one certificate can have several). Use a period for decimals. After the table, list any certificate or line you could not read clearly.
Open GeminiOpen GrokChatGPT

Always check what the AI read

AI tools misread digits. That is why the second step is not optional: the checker finds the lines that cannot be right. A TIN that is not nine digits, an amount that does not match the ATC rate, a certificate listed twice, a payor name that appears with two TINs a digit apart.

What you get

  • The total tax credit for the quarter, ready to compare with your return.
  • An Excel in SAWT order: sequence, TIN, branch, payor, ATC, nature of income, income payment, tax withheld.
  • Every certificate line behind it, with a note on any line that was left out and why.
Honest about the file. ClockIN prepares and checks the list and makes the Excel. The BIR’s own SAWT DAT file is produced in the BIR’s Alphalist Data Entry module, which your accountant uses. ClockIN will write the DAT itself once its layout has passed the BIR’s validator.

Questions

Is it safe to put certificates into a free AI?

Only you can decide that for your papers. Nothing from the photos is sent to ClockIN; only the table you paste back.

Which quarter does a certificate go in?

The quarter of the period it covers. The checker puts the others aside and says which quarter they belong to.

Skip the hard part

Photograph the papers. ClockIN checks every line and makes the files.

Try the free checkerOpen File BIR in ClockIN
BIR 2307 Template, ATC Rates and a Free CheckerKeep your BIR 2307 certificates in one clean list, check every TIN, ATC and amount, and kn…Free BIR DAT File Checker: RELIEF Purchases and SalesDrop in a RELIEF purchases or sales DAT file and get plain answers: bad characters, wrong …1604-C and Alphalist from Payroll, Without RetypingGet the 1604-C alphalist numbers straight from your pay runs: what feeds each column, what…

Made by ClockIN, by Strong Media Corp, Metro Manila. ClockIN is not BIR-accredited. Test every file in the BIR’s own validation module before you submit it; the filing stays with you and your accountant. Rules and rates change, so confirm against the BIR’s current issuances.