BIR Form 1702 is a tax form used to report an individual's or entity's annual income and compute their income tax liability. The form is used to declare all income earned from various sources, such as employment, business, or investments, and to pay the corresponding income tax.
| 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 | bir form 1702 rt version 2018 excel format
Aggregates creditable withholding taxes from quarters 1 to 3, plus any prior year excess credits. Best Practices When Using an Excel Format for BIR Filing BIR Form 1702 is a tax form used
Tax laws are dynamic. Ensure your Excel templates are regularly updated to reflect modifications in corporate tax rates, minimum corporate income tax (MCIT) rules, or changes in deduction parameters. minimum corporate income tax (MCIT) rules
A domestic corporation subject to the regular corporate income tax rate.