Bir Form 1702 Rt Version 2018 Excel Format

The BIR regularly updates its forms and requirements. Therefore, always check the BIR website or consult with a tax professional to ensure that your Excel template is compliant with the latest regulations and accurately reflects the current version of BIR Form 1702 RT.

BIR Form 1702-RT (Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject Only to Regular Income Tax Rate) version January 2018 (ENCS)

is the standard form used for annual income tax filing in the Philippines. Bureau of Internal Revenue Availability of Excel Formats Bureau of Internal Revenue (BIR) primarily provides this form in electronic (eBIRForms)

formats, some taxpayers seek Excel versions for easier computation. Bureau of Internal Revenue Official Submission : The BIR requires filing through the eBIRForms Offline Package (currently version as of 2026) or the eFPS online system for electronic filers. Third-Party Excel Tools : Various tax consultancy and software sites offer editable Excel templates

of the 1702-RT 2018 version. These are typically used as "working papers" to prepare data before encoding it into the official BIR software. Exporting to Excel : Some third-party tax software (like ) allows users to import/export tax data in formats for easier bulk editing. Bureau of Internal Revenue Key Features of the 2018 Version As of early 1702-RT v2018C

remains the latest mandated version for reporting income from the 2025 calendar year. Bureau of Internal Revenue Payment/Remittance Forms - Bureau of Internal Revenue bir form 1702 rt version 2018 excel format

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?

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? and other entities. Below

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 4.4. Net Income Tax Payable/Refundable

You are looking for the full content of BIR Form 1702-RT, version 2018, in Excel format. BIR Form 1702-RT is a Philippine tax form used for the annual income tax return for corporations, partnerships, and other entities.

Below, I will provide you with the general details that are typically included in BIR Form 1702-RT. Note that this is not the official Excel format but a description of the sections and information usually required. For the exact official Excel format, you should visit the official website of the Bureau of Internal Revenue (BIR) Philippines or consult with a tax professional.

Open eBIRForms Offline → Select “1702-RT” → Choose version “2018” (if still available; otherwise, contact BIR for legacy access). Manually encode figures from your Excel.

BIR_Form_1702_RT_v2018_Template.xlsx

Once your Excel version of BIR Form 1702 RT Version 2018 is complete, you cannot submit the Excel file directly to the BIR. Follow these steps:

| Line | Field | Excel Formula / Instructions | |------|-------|-------------------------------| | 4 | Gross Sales/Receipts/Revenues/Fees | Sum of all taxable revenue (from audited P&L). | | 6 | Total Deductions | Choose: Itemized (line 12A) OR Optional Standard Deduction (40% of line 4). | | 7 | Taxable Income (line 4 – line 6) | =MAX(0, Line4 – Line6) | | 8A | RCIT Due (25% of line 7 – note pre-CREATE rate) | =Line7 * 0.25 | | 8B | MCIT (2% of gross income) – compute if applicable | =GrossIncome * 0.02 | | 9 | Higher Between RCIT and MCIT | =MAX(8A, 8B) | | 10 | Less: Tax Credits (Creditable Withholding Tax from Form 2307) | Sum of all valid CWT. | | 13 | Total Tax Still Due / (Overpayment) | =Line9 – Line10 – Line11 |