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 |
To create a feature that supports BIR Form 1702-RT (version June 2018) bir form 1702 rt version 2018 excel format
BIR Form 1702-RT (Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject Only to Regular Income Tax Rate) version January 2018 (ENCS) | Data validation: Deductions <= Gross Income |
Enter payments made – quarterly remittances, advance payments, etc. | Data validation: Deductions <
For returns with attachments (audited FS, schedules), you must compress (zip) the .dat file and all attachments, then upload to the eAFS portal.