Bir Form 1702 Rt Version 2018 Excel Format May 2026
Step 1: Setting Up the Excel Template
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
- Download the Excel Template: Obtain the official Excel template for BIR Form 1702 RT Version 2018 from the BIR website or authorized sources.
- Enter Basic Information: Fill in the taxpayer's basic information, such as name, address, and taxpayer identification number (TIN).
- Report Income: Report the taxpayer's gross income from various sources, such as business, investments, and other income.
- Claim Deductions and Credits: Claim allowable deductions and credits, such as operating expenses, depreciation, and tax credits.
- Compute Tax Liability: Compute the net taxable income and income tax liability based on the information entered.
- Review and Validate: Review and validate the information entered to ensure accuracy and completeness.
Excel-based template
Despite the availability of PDF and eBIRForms, many tax practitioners and corporate finance departments prefer an of BIR Form 1702-RT (2018). Excel offers flexibility not found in static PDFs: users can link worksheets, automate carry-forward of prior year’s data, create dynamic schedules for depreciation, NOLCO (Net Operating Loss Carry-Over), and itemized deductions, and perform instant error-checking through formulas. Moreover, Excel allows for easy conversion to CSV or other formats when integrating with accounting systems. bir form 1702 rt version 2018 excel format