Bir Form 1702 Rt Version 2018 Excel Format May 2026

When designing or using an Excel version of Form 1702-RT (2018), ensure these business rules are built-in:

| Rule | Excel Implementation | |------|----------------------| | For corporations with gross sales ≤ PHP 10M are subject to 30% RCIT but MCIT applies only if there is gross income. | IF(AND(GrossSales<=10000000, GrossIncome>0), MIN(Line9, Line12), Line9) | | MCIT = 2% of Gross Income (Line 5) | =Line5 * 0.02 | | If MCIT > RCIT, MCIT is payable. | =MAX(RCIT, MCIT) | | Allowable deductions cannot exceed Gross Income. | Data validation: Deductions <= Gross Income | | Tax credits cannot exceed Tax Due. | Conditional formatting alert |

Also, ensure your Excel automatically flags:

Introduction

The Bureau of Internal Revenue (BIR) Form 1702 RT is a crucial document that taxpayers in the Philippines must submit annually. The form is used to report the income tax returns of individuals and businesses. In this review, we'll take a closer look at the 2018 version of BIR Form 1702 RT in Excel format.

Overview of BIR Form 1702 RT

BIR Form 1702 RT is a comprehensive form that requires taxpayers to report their income, deductions, and credits. The form is divided into several sections, including:

Features of the 2018 Excel Format

The 2018 version of BIR Form 1702 RT in Excel format offers several features that make it easier for taxpayers to complete and submit their income tax returns. Some of these features include:

Pros and Cons

Pros:

Cons:

Conclusion

The BIR Form 1702 RT Version 2018 Excel Format is a useful tool for taxpayers in the Philippines. Its automated calculations, easy data entry features, and comprehensive instructions make it easier for taxpayers to complete and submit their income tax returns. However, taxpayers should still exercise caution and seek professional advice if they are unsure about any aspect of the form.

Rating

Based on its features and functionality, I would give the BIR Form 1702 RT Version 2018 Excel Format a rating of 4 out of 5 stars. While it is a useful tool, its complexity and potential version compatibility issues may deter some taxpayers.

Recommendations

The BIR Form 1702-RT (version 2018) is the Annual Income Tax Return for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate in the Philippines.

While the official filing is typically done through the Offline eBIRForms Package or the eFPS (Electronic Filing and Payment System), many taxpayers use Excel templates for preparation and computation. Key Components of Form 1702-RT (v2018)

To prepare your Excel template, ensure it includes these standard sections:

Part I: Background Information: Taxpayer Identification Number (TIN), RDO Code, Registered Name, Registered Address, and Date of Incorporation.

Part II: Total Tax Payable: Calculation of tax due, less tax credits/payments, plus any applicable penalties (Surcharge, Interest, Compromise).

Part IV: Computation of Tax: Detailed breakdown of Sales/Receipts, Cost of Sales, Gross Income, and Allowable Deductions.

Schedules: Supplementary tables for Itemized Deductions, NOLCO (Net Operating Loss Carry Over), Tax Credits, and the Balance Sheet. Filing and Official Form Access

Understanding Offline eBIRForms: A Comprehensive Guide - JuanTax

Go to the official website of the Bureau of Internal Revenue (BIR) at www.bir.gov.ph. Click on the eServices tab on the main menu, Filing Requirements for BIR Form 1702 in the Philippines

I’m not sure what you mean by “full essay for BIR Form 1702 RT version 2018 Excel format.” I will assume you want a complete, explanatory guide (an essay-style walkthrough) describing how to fill out BIR Form 1702-RT (2018 version) in Excel, including line-by-line explanations, common pitfalls, and worked examples. I’ll produce that. If you meant something else (a filled sample return, template, or legal tax advice), tell me and I’ll adjust.

Do you want:

Pick one of 1–4 or say “proceed with 1” and I’ll produce the essay now.

Enter payments made – quarterly remittances, advance payments, etc.