Bir Form 1702 Rt Version 2018 Excel Format ✔

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

Introduction: The Search for the Right Tax Form bir form 1702 rt version 2018 excel format

: Visit www.bir.gov.ph → under “Taxes & Forms” → select “Income Tax” → filter by “Form 1702-RT” → choose version “January 2018 (ENCS)”. Part 5: Key Validation Rules in Excel for Version 2018 When designing or using an Excel version of Form 1702-RT (2018), ensure these business rules are built-in: BIR requires peso rounding (0

| Rule | Excel Implementation | |------|----------------------| | For corporations with gross sales ≤ PHP 10M are subject to 30% RCIT but MCIT applies only if there is gross income. | IF(AND(GrossSales<=10000000, GrossIncome>0), MIN(Line9, Line12), Line9) | | MCIT = 2% of Gross Income (Line 5) | =Line5 * 0.02 | | If MCIT > RCIT, MCIT is payable. | =MAX(RCIT, MCIT) | | Allowable deductions cannot exceed Gross Income. | Data validation: Deductions <= Gross Income | | Tax credits cannot exceed Tax Due. | Conditional formatting alert | Part 5: Key Validation Rules in Excel for

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.

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%.