After filling in eBIRForms offline, you can export the return data to CSV/XML, then import into Excel. This is not a blank template but a completed return record.
Where to find the official reference PDF:
Visit www.bir.gov.ph → under “Taxes & Forms” → select “Income Tax” → filter by “Form 1702-RT” → choose version “January 2018 (ENCS)”.
Despite the availability of PDF and eBIRForms, many tax practitioners and corporate finance departments prefer an Excel-based template of BIR Form 1702-RT (2018). Excel offers flexibility not found in static PDFs: users can link worksheets, automate carry-forward of prior year’s data, create dynamic schedules for depreciation, NOLCO (Net Operating Loss Carry-Over), and itemized deductions, and perform instant error-checking through formulas. Moreover, Excel allows for easy conversion to CSV or other formats when integrating with accounting systems.
The 2018 version’s complexity—particularly with the revised tax rates, Minimum Corporate Income Tax (MCIT) interaction, and creditable withholding tax reconciliation—makes manual computation error-prone. An Excel version with pre-programmed formulas reduces arithmetic mistakes and saves time during tax season.
Introduction: The Search for the Right Tax Form
Every corporation, partnership, or non-individual taxpayer in the Philippines dreads one thing: the annual income tax return. For corporations under the Regular Corporate Income Tax (RCIT) regime, the go-to form is BIR Form 1702-RT. Specifically, the Version 2018 (January 2018 ENCS) remains a critical reference point because later versions (like the 2022 EOPT update) introduced major changes. However, many taxpayers still need to reconstruct or compute prior-year filings, or prefer working in a spreadsheet before transcribing into the eBIRForms package.
If you have been searching for "BIR Form 1702 RT version 2018 excel format" , you are likely looking for:
This article covers everything — from understanding the form, to using an Excel version effectively, to legal compliance notes.
The Excel format of BIR Form 1702-RT (Version 2018) is not an official substitute but a powerful auxiliary tool for efficient and accurate tax computation. In an era of increasing tax complexity, especially following the TRAIN Law, Excel empowers taxpayers to organize data, minimize errors, and streamline the filing process. However, compliance with BIR regulations requires that the final submission be made using the government’s official channels. When used responsibly, Excel bridges the gap between manual calculation and full automation—serving as an indispensable ally for Philippine corporate taxpayers.
Comprehensive Guide to BIR Form 1702-RT (Version 2018) in Excel Format
The BIR Form 1702-RT, or the Annual Income Tax Return for Corporations, Partnerships, and other Non-Individual Taxpayers subject only to the Regular Income Tax Rate, is a critical compliance document for businesses in the Philippines. The January 2018 (ENCS) version introduced significant updates to align with modern tax regulations like the CREATE Act. What is BIR Form 1702-RT? bir form 1702 rt version 2018 excel format
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).
Tax Rate: It is generally used by entities subject to the regular corporate income tax rate, which is now 25% (or 20% for certain small businesses) following recent tax reforms.
Filing Frequency: It is an annual return filed once every taxable year. Why Use an Excel Format for Form 1702-RT?
While the Bureau of Internal Revenue (BIR) provides the Offline eBIRForms Package for electronic filing, many accountants prefer an Excel format for preparation because:
Automatic Computation: Excel templates often include built-in formulas for calculating Minimum Corporate Income Tax (MCIT) versus Normal Income Tax.
Data Import: It is easier to copy data from accounting software or trial balances directly into an Excel sheet.
Review and Audit: An Excel file allows for a clear audit trail and easier internal review before the final data is encoded into the eFPS or eBIRForms system. Key Components of the 2018 Version
The 2018 version of Form 1702-RT contains several critical sections that must be filled out accurately: BIR Form 1702-RT - eFPS
Navigating Philippine tax compliance can be complex, especially with periodic updates to forms like BIR Form 1702-RT. If you are looking for the January 2018 (ENCS) version in a user-friendly format, an Excel template is a practical tool for pre-calculating figures before official filing.
Mastering BIR Form 1702-RT (Version 2018): Your Guide and Excel Format Tips After filling in eBIRForms offline, you can export
BIR Form 1702-RT is the Annual Income Tax Return specifically for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate. While the Bureau of Internal Revenue (BIR) provides official PDF and eBIRForms versions, many accountants prefer an Excel format for internal preparation and reconciliation. Who Needs to File 1702-RT?
This form is mandatory for non-individual taxpayers that do not have mixed income or special/preferential tax rates. Common filers include:
Domestic Corporations receiving income from both within and outside the Philippines. Partnerships (excluding General Professional Partnerships). Joint Stock Companies and associations. Key Features of the 2018 Version
The January 2018 version introduced several streamlined features for easier reporting:
Elimination of Centavos: You no longer need to enter centavos. Round down if it's 0.49 or less, and round up if it's 0.50 or more.
CREATE Law Rates: For tax years after the CREATE Law was enacted, the regular corporate income tax rate was reduced from 30% to 25% or 20% (for certain small businesses).
Mandatory Capital Letters: All entries must be in CAPITAL LETTERS using black ink. Payment/Remittance Forms - Bureau of Internal Revenue
The BIR Form 1702-RT (January 2018 ENCS) is the Annual Income Tax Return specifically designed for corporations, partnerships, and other non-individual taxpayers whose income is subject only to the Regular Income Tax Rate. While the Bureau of Internal Revenue (BIR) primarily provides this through the Offline eBIRForms Package or eFPS, many taxpayers seek an Excel format to simplify complex financial computations before final submission. Key Features of the 2018 Version
The 2018 revision updated the form to comply with the TRAIN Law and later adjustments from the CREATE Act. 1702-RT - BIR
BIR Form 1702-RT (January 2018 version) is the Annual Income Tax Return specifically designed for Despite the availability of PDF and eBIRForms, many
corporations, partnerships, and other non-individual taxpayers in the Philippines that are subject only to the regular income tax rate
. While the official Bureau of Internal Revenue (BIR) format is distributed through the software or the
portal, Excel-based versions are frequently used by accountants for preparation, draft computations, and bulk data organization before final submission. Bureau of Internal Revenue Key Features of the 2018 Version Tax Code Compliance
: Aligned with the TRAIN Law, requiring simplified reporting compared to older versions. Alphanumeric Tax Code (ATC) : Primarily uses for domestic corporations subject to regular income tax. Version 1702-RTv2018C
: An updated sub-version ("C") often found in eBIRForms which disables automatic tax computation
to allow taxpayers to manually input rates (like 20% or 25%) as mandated by the CREATE Act. Method of Deductions : Allows a choice between Itemized Deductions Optional Standard Deduction (OSD) of 40% of gross income. Bureau of Internal Revenue Core Components for Excel Preparation
Excel templates for this form typically mirror the official BIR layout, divided into several critical parts: Part I: Background Information
: Taxpayer Identification Number (TIN), RDO Code, registered name, and address. Part II: Total Tax Payable : Summary of the final tax due and any overpayments. Part IV: Computation of Tax
: 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