Bir Form 1702 Rt Version 2018 Excel Format Link

Despite the convenience of Excel, many taxpayers stumble. Watch out for:

1. Using the wrong tax rate
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%.

2. MCIT applicability
MCIT applies starting on the 4th year of operation. Many Excel templates miss the “4th year” filter. Add a field: “Year of operation” – if less than 4, MCIT = zero.

3. Rounding errors
BIR requires peso rounding (0.50 and above round up). Use: =ROUND(computation,0) on all final tax amounts. bir form 1702 rt version 2018 excel format

4. Missing the “Previously filed” reference for amended returns
For amended returns (Line G “Amended” = Yes), Excel should require entry of the original return’s BIR Receipt Date and Reference Number.

5. Improper Schedule of Deductions
Some users input total deductions directly in Part I. That will fail BIR validation. Always break down deductions per BIR’s schedule.

Q1: Is BIR Form 1702-RT version 2018 available in Excel from the BIR?
No. The BIR only provides PDF and XML (via eBIRForms). Excel templates are user-created and should be used as worksheets only. Despite the convenience of Excel, many taxpayers stumble

Q2: Can I use version 2018 Excel for filing in 2025?
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.

Q3: Will BIR accept Excel printouts as an attachment?
Yes, as a supporting schedule, but only if accompanied by the official BIR form (printed from eBIRForms). You cannot submit standalone Excel printouts as the tax return.

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. Q1: Is BIR Form 1702-RT version 2018 available

Q5: Where can I find a free, reliable Excel template for 1702-RT version 2018?
Try reputable sources:

If filing manually, print the completed PDF (generated from eBIRForms), not your Excel spreadsheet. The BIR will not accept handwritten Excel printouts.