Bir Form 1702 Rt Version 2018 Excel Format May 2026

Introduction: The Search for the Right Tax Form

MCIT applies starting on the 4th year of operation. Many Excel templates miss the “4th year” filter. Add a field: “Year of operation” – if less than 4, MCIT = zero. bir form 1702 rt version 2018 excel format

| Line | Description | Excel Formula/Macro Reference | |------|-------------|-------------------------------| | 1 | Gross Sales/Revenues | SUM(revenue accounts) | | 2 | Sales discounts/returns | Subtract from line 1 | | 3 | Net Sales/Revenues | =Line 1 – Line 2 | | 4 | Cost of Sales/Services | Direct input or linked | | 5 | Gross Income (L3 – L4) | =L3 – L4 | | 6 | Allowable deductions | Itemized or optional (40% OSD for non-VAT?) | | 7 | Taxable Income (L5 – L6) | =L5 – L6 | | 8 | Rate (30% for Version 2018) | Fixed cell: 0.30 | | 9 | Income Tax Due (L7 x L8) | =L7 * 0.30 | | ... | Less: Credits & Withholding | WT, CWT, Tax Paid in prior quarters | | 18 | | Final output | Introduction: The Search for the Right Tax Form

But remember: the BIR does not accept Excel files as official tax returns. Use your Excel template to compute, validate, and document — then file using the official eBIRForms system. | Line | Description | Excel Formula/Macro Reference

Version 2018 mandates 30% RCIT . Never use 25% or 20% (those came later with CREATE Act in 2021). If your tax year covers 2018–2020, it’s 30%.

BIR requires peso rounding (0.50 and above round up). Use: =ROUND(computation,0) on all final tax amounts.