Skip to main content

Bir Form 1702 Rt Version 2018 Excel Format ((free)) Jun 2026

: For entities completely Exempt from income tax.

Payments can be made through Authorized Agent Banks (AABs) or online banking channels (e.g., GCash, PayMaya, Landbank).

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

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.

It is faster to edit, copy, and paste data from financial statements (Trial Balance/Financial Statements) into Excel than directly into the eBIRForms software. : For entities completely Exempt from income tax

In the Philippine tax system, the Bureau of Internal Revenue (BIR) requires corporations, partnerships, and other non-individual taxpayers to file annual income tax returns. Among these, —the Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject to Regular Tax—is a critical document. The 2018 version of this form introduced significant changes aligned with the Tax Reform for Acceleration and Inclusion (TRAIN) Law. While the BIR officially provides a PDF version, the demand for an Excel format of BIR Form 1702-RT (2018) has grown among taxpayers and accountants seeking automation, accuracy, and ease of computation. This essay explores the nature of the form, the rationale behind the Excel version, its advantages, limitations, and compliance considerations.

Your Excel should automatically compute if applicable (line 10–12) and compare with RCIT. While tax rates may have changed due to

Check the BIR Forms section for downloadable PDF versions, which some users convert to Excel.

I understand you're looking for a complete essay related to the . However, the phrasing of your request seems to blend two distinct concepts: (1) the legal/tax compliance aspects of the form itself, and (2) its technical implementation in Excel.

: Instead of manually cross-referencing lines, Excel formulas automate math calculations like:

The form consists of several parts: taxpayer information, computation of taxable income, income tax due, tax credits and payments, and summary of tax payable. Filing is done via the BIR’s Electronic Filing and Payment System (eFPS) for mandated taxpayers, or manually with electronic filing (eBIRForms) for others. The official format is a government-issued PDF with embedded calculations.