Bir Form 1702 Rt Version 2018 Excel Format -

If your taxable year began after March 26, 2021 (effectivity of CREATE), you must not use version 2018. You need the 1702-RT Version 2022 (ENCS) or later, which reflects:

However, if you keep an archive of legacy Excel templates, keeping a master copy of BIR Form 1702 RT version 2018 in Excel format is essential for handling BIR audits or assessments covering pre-CREATE years.

Subject: 📄 Resource Share: BIR Form 1702-RT (2018 Version) Excel Format

Are you preparing for the filing of your Annual Income Tax Return? 📉

For those handling the Final Adjustment or Consolidated Return for corporations and partnerships, having a workable digital file is essential for efficiency.

I am sharing a copy of BIR Form 1702-RT (Year 2018 Version) in Excel format. This version is useful for: ✅ Drafting and computation: Easier to validate figures with Excel formulas. ✅ Data validation: Checking for discrepancies before filing. ✅ Record keeping: Maintaining a soft copy for your digital archives.

⚠️ Important Reminder: Please ensure that this specific version (2018) is acceptable for your current filing period or if your jurisdiction requires the latest BIR Offline eBIRForms Package. Always double-check with your tax agent or the official BIR website for the most recent updates and deadlines.

🔗 Download Link: [Insert Download Link Here]

Disclaimer: This file is shared for educational and drafting purposes. Always consult a Certified Public Accountant for specific tax advice.

#TaxSeason #BIR #Form1702RT #AccountingPH #TaxResources #ExcelTemplates

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

If you are looking for an Excel-based version, several third-party platforms provide fillable templates that mimic the official layout and logic. Key Features of 1702-RT (2018 Version)

The 2018 update (marked as 1702-RTv2018C in eBIRForms) introduced specific structural changes:

Tax Rate Inputs: Unlike previous versions, the automatic computation of tax due is often disabled in the latest offline packages to allow taxpayers to manually indicate the applicable rate (e.g., 25% or 20% under CREATE law adjustments). bir form 1702 rt version 2018 excel format

Method of Deduction: Supports both Itemized Deductions (requiring details for schedules like salaries, depreciation, and interest) and Optional Standard Deduction (OSD) (fixed at 40% of gross income).

Net Income Reconciliation: Includes Schedule 3 for the reconciliation of net income per books against taxable income, ensuring consistency with audited financial statements.

Validation Logic: Most Excel versions include "check-figures" to ensure that the Total Tax Payable on Page 1 matches the detailed computations on subsequent pages (e.g., Part IV Item 43 must flow to Part II Item 14). Where to Find the Format

While the Bureau of Internal Revenue (BIR) provides the official PDF Version and the eFPS/eBIRForms interactive tool, Excel formats are typically used for internal preparation before final submission:

Online Editors: Platforms like pdfFiller and DocHub offer editable templates that can be exported to various formats.

eFPS Upload: If using the eFPS system, the BIR allows uploading data via specific .xlsx or .xls files that match their database structure. Pro-Tips for Preparation

CAPITAL LETTERS: The BIR requires all information to be entered in all caps using black ink (if printed).

No Centavos: Figures should generally be rounded (49 centavos or less down, 50 or more up).

Cross-Check Schedules: Ensure Schedule 1 (Itemized Deductions) and Schedule 2 (Special Deductions) totals correctly map to the primary tax computation on Page 2. 1702-RT - BIR

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. If your taxable year began after March 26,

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.

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.

Once your Excel computation is accurate, here’s how to file Version 2018:

For returns with attachments (audited FS, schedules), you must compress (zip) the .dat file and all attachments, then upload to the eAFS portal.

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. However, if you keep an archive of legacy

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

The BIR Form 1702-RT (January 2018 version) is the Annual Income Tax Return for corporations, partnerships, and other non-individual taxpayers subject only to the regular income tax rate. While the Bureau of Internal Revenue (BIR) primarily provides this form via eBIRForms or the eFPS portal, many taxpayers use Excel-based templates for easier data preparation before final encoding. Where to Access the Form

Official Digital Form: The BIR highly encourages using the Offline eBIRForms Package (version 7.9.5 or newer) to ensure automatic calculations and data validation. You can select "1702-RT version 2018" within the software.

Excel Formats: Official BIR Excel files are generally used for Summary Lists of Sales/Purchases (SLSP) or eFPS uploads. Third-party platforms like JuanTax often provide tools that handle the Excel-to-XML conversion for you.

PDF Reference: A permanent PDF copy for manual review can be found on the BIR Official CDN. Key Sections of Form 1702-RT

When preparing your data in Excel, organize your spreadsheets to match these primary parts: 1702-RT - BIR

* Number. * Date (MM/DD/YYYY) * Amount. * 23 Cash/Bank Debit Memo. * 24 Check. * 25 Tax Debit Memo. * 26 Others (specify below) Bureau of Internal Revenue

Firms handling dozens of corporations use an Excel template of Form 1702-RT (Version 2018) to consolidate data before final encoding into eBIRForms or submission via the new eAFS (Electronic Audit Form System).