A bookkeeper issues BIR Form 2307 certificates from one spreadsheet

One spreadsheet of payees becomes a sealed BIR Form 2307 per row, a register of certificates, and matched quarterly totals.

Dozens of 2307s a quarter and 2316s at year-end mean typing the same details and looking up tax codes.

Many clients means different deadlines, tax rules and forms to keep straight.

People report BIR’s filing systems going down at the deadline.

Every time a business withholds creditable expanded withholding tax from a supplier, landlord, or professional, the bookkeeper has three numbers that must agree. In the first 2 months of a calendar quarter, the business remits the tax monthly on BIR Form 0619-E. That monthly remittance form is due on the 10th day of the following month, or the 15th for eFPS users, and a zero remittance still requires a filing. There is no BIR Form 0619-E for the third month of the quarter.

At the end of the quarter, the bookkeeper settles the whole period on BIR Form 1601-EQ, due on the last day of the month after the quarter closes. This quarterly return goes with the Quarterly Alphabetical List of Payees, which lists each payee’s name, TIN, monthly income payments, and tax withheld. At the same time, the payor must give each payee a BIR Form 2307 — Certificate of Creditable Tax Withheld at Source within 20 days from the close of the quarter, or together with the payment if the payee asks for it.

The total tax in the BIR Form 2307 certificates, the tax in the Quarterly Alphabetical List of Payees, and item 19 on BIR Form 1601-EQ should be the exact same number. When a client pays dozens of suppliers, typing each BIR Form 2307 by hand and looking up every Alphanumeric Tax Code is a heavy chore. If a supplier is paid under two different tax codes, such as rent and professional fees, the bookkeeper must prepare two separate certificates for that supplier.

Missing a deadline or filing mismatched numbers carries a high cost. The form guidelines list a 25% surcharge for failing to file or pay on time, plus interest at double the legal rate set by the Bangko Sentral, plus a compromise penalty. Under Revenue Memorandum Circular 29-2021, a withholding agent may e-sign BIR Form 2307 without prior BIR approval, provided the form is an exact replica of the latest BIR version, carries the payee’s signature too, is issued only once, and marks any repeat copy with a RE-PRINT watermark.

Client TIN, RDO, and address: The withholding agent’s registered details go into Part I of the returns and apply to the whole run of certificates.

Payee TIN and registered name: Each payee’s details must match their certificate of registration so their tax credit does not fail later.

Alphanumeric Tax Code per payment: Each certificate covers one payee, one quarter, and one tax code such as WI010.

Monthly gross income payments: The spreadsheet needs the gross payment before tax for month 1, month 2, and month 3 of the quarter.

Actual tax withheld or rate: Supplying the exact amount withheld keeps a percentage rate from recomputing a different figure.

BIR Form 0619-E payment proofs: You subtract the first 2 months’ remittances in items 20 and 21 of BIR Form 1601-EQ so you do not pay twice.

1. Select the client workspace. The bookkeeper signs in, opens the Clients page, and presses Work as next to the client’s name. A form then opens with that client’s TIN, RDO code, registered name, and address already in place. Unfinished drafts stay with that client workspace so work for different taxpayers does not mix.

2. Prepare the payee spreadsheet. In a spreadsheet, the bookkeeper puts one row per payee and Alphanumeric Tax Code, then exports it as a CSV file. If the sheet lists individual payments with a payment date, rows for the same payee and tax code in that quarter are grouped and added into the three monthly columns automatically. The bookkeeper enters the exact tax withheld in the tax_withheld column so a rate does not recompute it.

3. Upload CSV on Certificates page. The bookkeeper opens the Certificates page, chooses the quarter and year, and uploads the CSV file. Every row is checked before any certificate is issued, so a bad TIN with a letter in it or a missing tax code stops the run with the reason instead of leaving the batch half-issued. The bookkeeper fixes any flagged row in the sheet and uploads it again.

4. Fill the quarterly 1601-EQ return. In a workflow step for BIR Form 1601-EQ, the same payables sheet builds one row per Alphanumeric Tax Code for items 13 to 18, summing the tax base and tax withheld across the sheet. That keeps the return totals aligned with the certificates generated from the same rows. The bookkeeper then enters the two monthly BIR Form 0619-E remittances in items 20 and 21.

5. Send draft for review. Before anything is handed out or filed, the preparer saves the draft shared with the unit and sends it to a reviewer by email. The reviewer opens the Review queue, checks the figures against the payment proofs, and either approves the draft or returns it with a note. If a payee later loses a certificate, the bookkeeper re-issues it from the register under the same document number with a RE-PRINT watermark.

Mismatching the return and certificates. A common rejection happens when totals differ between BIR Form 1601-EQ, the Quarterly Alphabetical List of Payees, and the BIR Form 2307 certificates. Check that the sum of tax withheld per tax code agrees across all three before filing.

Issuing a fresh second original. A payee may not use a BIR Form 2307 twice for the same payment, payor, and period. Never generate a brand-new original when a supplier asks for another copy; issue a re-print from the register so it carries the RE-PRINT watermark required by Revenue Memorandum Circular 29-2021.

Forgetting monthly payments on 1601-EQ. Items 20 and 21 on BIR Form 1601-EQ must show what was already paid on the two monthly BIR Form 0619-E remittances. Leaving those boxes blank makes the whole quarter look unpaid and causes the client to pay twice.

Putting the filing month on 0619-E. Item 1 on BIR Form 0619-E asks for the month the tax was withheld, not the month the bookkeeper files and pays. Also remember that a zero remittance still requires filing BIR Form 0619-E for the first 2 months of the quarter.

From the Certificates run, the bookkeeper downloads one sealed PDF of BIR Form 2307 (January 2018 ENCS version) for each payee and Alphanumeric Tax Code row, plus a CSV register of what was issued. Each PDF carries a tamper-evident seal and a document id, and its file name follows the Revenue Regulations 2-2015 format using the payor’s registered name, 12-digit TIN, and the period end date. A Free account includes 5 clean BIR Form 2307s per quarter and 5 clean BIR Form 2316s per year on the record, while a 2307 Quarter Pass or a paid plan covers larger runs. For the remittances and returns, the bookkeeper gets filled PDFs of BIR Form 0619-E and BIR Form 1601-EQ.

PhilForms fills and seals the forms, and never files anything with the government. The bookkeeper checks that every amount and TIN matches the client’s books and the payee’s certificate of registration. An authorized signatory of the withholding agent signs each BIR Form 2307 by hand or places an e-signature, and collects the payee’s signature on the Conforme line, either manually or via a phone signing link from the Certificates page. Finally, the bookkeeper gives the signed certificates to the payees within 20 days after the quarter closes, and files BIR Form 0619-E, BIR Form 1601-EQ, and the Quarterly Alphabetical List of Payees with the BIR or an Authorized Agent Bank.

People report that BIR filing and upload portals crash near deadlines and that Windows-only validation software demands manual updates. PhilForms does not replace the BIR portals, generate the alphalist validation file, or submit returns electronically. It also cannot resolve conflicting rules across Revenue District Offices when cleaning up client backlogs, and it does not advise on which annual return attachments must go to the eAFS portal; ask your RDO or a CPA when a requirement is unclear.

• BIR Form 2307 from Excel: one PDF per payee
• BIR 0619-E and 1601-EQ: expanded withholding tax
• Form pack: withholding tax on suppliers and landlords
• BIR 2307
• BIR 1601-EQ
• BIR 0619-E
• A payroll officer closes the year’s BIR 2316s and the 1604-C alphalist
• A liaison firm stops retyping each client’s details on BIR Form 1901
• A family registers a kasambahay with SSS, PhilHealth and Pag-IBIG