Bir Form 1702 Rt Version 2018 Excel Format [hot] Guide

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).

"Yes. Year ending 2018. Excel format," Arthur said confidently.

Input your company's financial data, including gross income, allowable deductions, and tax due.

: Includes details for sales, cost of services, itemized deductions, and reconciliation of net income per books against taxable income. Bureau of Internal Revenue Filing and Submission Guidelines bir form 1702 rt version 2018 excel format

If the deadline falls on a weekend or legal holiday, filing is moved to the next working day.

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

This comprehensive guide breaks down the core functions of BIR Form 1702-RT (January 2018 ENCS version), the practical benefits of using an Excel template, a step-by-step walkthrough of its schedules, and how to successfully file your final figures. What is BIR Form 1702-RT Version 2018? Firms handling dozens of corporations use an Excel

If you can tell me (e.g., domestic corporation, branch office) or if you have special tax incentives , I can give you more specific advice on how to fill out the form. Share public link

The BIR’s eBIRForms application (version 7.9 and later) allows offline filing, but it lacks the real-time formula auditing that Excel provides. An Excel version allows users to:

Under Revenue Memorandum Circular (RMC) No. 50-2021, the BIR updated the offline eBIRForms Package to v7.9. This added a letter "C" after the version date (1702-RTv2018C), enabling compliance with the CREATE Act (RA No. 11534). A key change was the ; users must now refer to an attached rate matrix to determine the correct tax rate. You are strongly advised to use this latest "C" version. Excel format," Arthur said confidently

High-quality templates feature error-trapping cells. For example, if your total itemized deductions on the summary page do not match the sum of Schedule 3, the cell should turn red.

A toggle option to quickly view changes in tax liability when testing alternative deduction methods (Itemized Deductions vs. Optional Standard Deduction, if applicable). Best Practices for Filing Your Final 1702-RT Return

This section captures basic corporate demographics. Your Excel template should feature drop-down menus or text blocks for: Taxpayer Identification Number (TIN) and RDO Code Registered Name and Registered Address

While Excel is practical, it is . The BIR requires filing via eFPS, eBIRForms (offline), or authorized agent banks—all using the official PDF or XML. An Excel file, even if perfectly formatted, cannot be directly uploaded to BIR systems. Taxpayers must manually transcribe or use macros to transfer Excel data into the official return.

– If the taxpayer elects the 40% Optional Standard Deduction instead of itemizing.