Bir Form 1702 Rt Version 2018 Excel Format 🆕 Popular

: 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:

Functionally yes, as long as formulas mirror Excel. However, Google Sheets may handle rounding and data validation differently. Test thoroughly. Never use it for final filing if offline access is required. bir form 1702 rt version 2018 excel format

| 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 | : Visit www

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. Test thoroughly