Bir Form 1702 Rt Version 2018 Excel Format _best_ Jun 2026

Supports both Itemized Deductions (requiring details for schedules like salaries, depreciation, and interest) and Optional Standard Deduction (OSD) (fixed at 40% of gross income).

| Line | Description | Excel Formula/Macro Reference | |------|-------------|-------------------------------| | 1 | Gross Sales/Revenues | SUM(revenue accounts) | | 2 | Sales discounts/returns | Subtract from line 1 | | 3 | Net Sales/Revenues | =Line 1 – Line 2 | | 4 | Cost of Sales/Services | Direct input or linked | | 5 | Gross Income (L3 – L4) | =L3 – L4 | | 6 | Allowable deductions | Itemized or optional (40% OSD for non-VAT?) | | 7 | Taxable Income (L5 – L6) | =L5 – L6 | | 8 | Rate (30% for Version 2018) | Fixed cell: 0.30 | | 9 | Income Tax Due (L7 x L8) | =L7 * 0.30 | | ... | Less: Credits & Withholding | WT, CWT, Tax Paid in prior quarters | | 18 | | Final output |

The “Version 2018” indicates the BIR’s electronic filing system format (ENCS – Electronic Filing and Payment System Non-Individual). While tax rates may have changed due to the CREATE Act (Republic Act No. 11534), the structure of the return—schedules, line items, and attachments—remains largely based on this 2018 iteration for many filing purposes, especially for those using offline tools. bir form 1702 rt version 2018 excel format

: Choices between Itemized Deductions (under Section 34 of the Tax Code) or the Optional Standard Deduction (OSD) which represents 40% of Gross Income.

Comprehensive Guide to BIR Form 1702-RT Version 2018 Excel Formats While tax rates may have changed due to

This form is specifically for non-individual taxpayers who do not have "mixed income" or income subject to special preferential rates (such as PEZA or BOI-registered entities).

This article is for informational purposes and does not constitute legal or tax advice. Tax rules change. Always consult a CPA or the BIR RDO for your specific situation. All BIR forms, including version 2018, remain the property of the Bureau of Internal Revenue, Republic of the Philippines. Comprehensive Guide to BIR Form 1702-RT Version 2018

Excel allows users to create supporting schedules and sub-ledgers.

Firms handling dozens of corporations use an Excel template of Form 1702-RT (Version 2018) to consolidate data before final encoding into eBIRForms or submission via the new eAFS (Electronic Audit Form System).

Only if you are filing an amended return for a tax year covered by 2018 rules (e.g., 2018, 2019, 2020, or FY starting in 2020). For current year filing, use the latest BIR form version.