Bir Form 1702 Rt Version 2018 Excel Format Jun 2026

Are you planning to use or the Optional Standard Deduction (OSD) ?

I am sharing a copy of in Excel format . This version is useful for: ✅ Drafting and computation: Easier to validate figures with Excel formulas. ✅ Data validation: Checking for discrepancies before filing. ✅ Record keeping: Maintaining a soft copy for your digital archives. bir form 1702 rt version 2018 excel format

Pro tip: Use Excel data validation (List) for RDO codes and Yes/No fields. Are you planning to use or the Optional

| Line | Field | Excel Formula / Instructions | |------|-------|-------------------------------| | 4 | Gross Sales/Receipts/Revenues/Fees | Sum of all taxable revenue (from audited P&L). | | 6 | Total Deductions | Choose: Itemized (line 12A) OR Optional Standard Deduction (40% of line 4). | | 7 | Taxable Income (line 4 – line 6) | =MAX(0, Line4 – Line6) | | 8A | RCIT Due (25% of line 7 – note pre-CREATE rate) | =Line7 * 0.25 | | 8B | MCIT (2% of gross income) – compute if applicable | =GrossIncome * 0.02 | | 9 | Higher Between RCIT and MCIT | =MAX(8A, 8B) | | 10 | Less: Tax Credits (Creditable Withholding Tax from Form 2307) | Sum of all valid CWT. | | 13 | Total Tax Still Due / (Overpayment) | =Line9 – Line10 – Line11 | | Line | Field | Excel Formula /

The Excel format of BIR Form 1702-RT (Version 2018) is not an official substitute but a powerful auxiliary tool for efficient and accurate tax computation. In an era of increasing tax complexity, especially following the TRAIN Law, Excel empowers taxpayers to organize data, minimize errors, and streamline the filing process. However, compliance with BIR regulations requires that the final submission be made using the government’s official channels. When used responsibly, Excel bridges the gap between manual calculation and full automation—serving as an indispensable ally for Philippine corporate taxpayers.

There is on the BIR website. However, tax professionals have long created unofficial Excel templates that mirror the exact line items, column headers, and compute tax automatically. These are what most people mean when they search for an "Excel format."

Even with a powerful Excel template, mistakes happen. Avoid these: