Bir Form 1702 Rt Version 2018 Excel Format Online

Version 2018 mandates 30% RCIT . Never use 25% or 20% (those came later with CREATE Act in 2021). If your tax year covers 2018–2020, it’s 30%.

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.

For amended returns (Line G “Amended” = Yes), Excel should require entry of the original return’s BIR Receipt Date and Reference Number. bir form 1702 rt version 2018 excel format

But remember: the BIR does not accept Excel files as official tax returns. Use your Excel template to compute, validate, and document — then file using the official eBIRForms system.

Introduction: The Search for the Right Tax Form Version 2018 mandates 30% RCIT

BIR requires peso rounding (0.50 and above round up). Use: =ROUND(computation,0) on all final tax amounts.

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. Only if you are filing an amended return

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