Bir Form 1702 Rt Version 2018 Excel Format

Manually copy the figures from Excel to the software. Click "Validate" to check for errors.

The Excel format performs automatic computations, reducing human error in complex tax calculations.

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. bir form 1702 rt version 2018 excel format

On or before the 15th day of the 4th month following the close of the taxpayer’s designated fiscal year. The Value of an Excel Format for BIR Form 1702-RT

On or before the 15th day of the 4th month following the close of the taxable year (e.g., April 15 for calendar year filers). Manually copy the figures from Excel to the software

A common point of confusion is the existence of an official Excel version of this form. The Bureau of Internal Revenue (BIR) that can be directly filed.

Encode your trial balance into the Excel sheet. Only if you are filing an amended return

Let’s assume you have a blank Excel workbook structured like the official 1702-RT. Here is how to fill it out line by line.

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

The visual arrangement of rows and columns should exactly match the sequence of the eBIRForms application screen. This makes manual data transcription seamless and fast.

Always save the final Excel draft alongside your finalized Audited Financial Statements and your eBIRForms .xml or PDF confirmation receipt. This forms your core defense file for future tax assessments.