Bir Form 1702 Rt Version 2018 Excel Format __full__
Here’s a draft content outline and structure for BIR Form 1702-RT (Version 2018) in Excel format. This can be used as a template guide for data entry or automation.
I am sharing a copy of BIR Form 1702-RT (Year 2018 Version) in Excel format. This version is useful for: ✅ Drafting and computation: Easier to validate figures with Excel formulas. ✅ Data validation: Checking for discrepancies before filing. ✅ Record keeping: Maintaining a soft copy for your digital archives.
The 2018 version of Form 1702-RT contains several critical sections that must be filled out accurately: BIR Form 1702-RT - eFPS bir form 1702 rt version 2018 excel format
Part I – Tax Due Computation
| Line | Field | Excel Formula / Instructions |
|------|-------|-------------------------------|
| 4 | Gross Sales/Receipts/Revenues/Fees | Sum of all taxable revenue (from audited P&L). |
| 6 | Total Deductions | Choose: Itemized (line 12A) OR Optional Standard Deduction (40% of line 4). |
| 7 | Taxable Income (line 4 – line 6) | =MAX(0, Line4 – Line6) |
| 8A | RCIT Due (25% of line 7 – note pre-CREATE rate) | =Line7 * 0.25 |
| 8B | MCIT (2% of gross income) – compute if applicable | =GrossIncome * 0.02 |
| 9 | Higher Between RCIT and MCIT | =MAX(8A, 8B) |
| 10 | Less: Tax Credits (Creditable Withholding Tax from Form 2307) | Sum of all valid CWT. |
| 13 | Total Tax Still Due / (Overpayment) | =Line9 – Line10 – Line11 |
- Line A – H: TIN, RDO Code, Business Name, Registered Address, ZIP Code
- Line I – M: Contact info, fiscal year end (MM/DD), taxable year
- Amended Return? Checkbox logic (Yes/No dropdown)
The January 2018 version introduced several streamlined features for easier reporting: Here’s a draft content outline and structure for
: Detailed line items for gross income, total deductions, and taxable income. : Includes supporting data such as Schedule 1 (Sales/Revenues), Schedule 4 (MCIT computation), and Schedule 5 (Reconciliation of Net Income). Bureau of Internal Revenue Filing and Submission Requirements 1702-RT - BIR
Specifically, BIR Form 1702-RT.
Q4: Can I use Google Sheets instead of Excel?
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.