The most practical and widely used method for electronically filing this form is the Offline eBIRForms Package . This software provides an interactive, calculator-enabled environment that functions like a user-friendly alternative to a standalone spreadsheet. It offers several key benefits:
Gross Income from Operation=Sales/Revenues/Receipts−Cost of Sales/ServicesGross Income from Operation equals Sales/Revenues/Receipts minus Cost of Sales/Services
For decades, Filipino accountants and bookkeepers have relied on Excel for manual tax computation before encoding data into the BIR’s eBIRForms. The demand for stems from several practical needs:
With the BIR pushing for full digitalization under the Internal Revenue Stamps Integrated System (IRSIS) and the upcoming e-Invoicing system, the days of manually filling out Excel versions may be numbered. However, for the foreseeable future, Excel remains a powerful tool for tax preparers. The will likely remain in use until the BIR radically overhauls the corporate tax return structure.
Are you preparing for the filing of your Annual Income Tax Return? 📉 bir form 1702 rt version 2018 excel format
: Detailed line items for gross income, total deductions, and taxable income. : Includes supporting data such as Schedule 1 (Sales/Revenues), Schedule 4 (MCIT computation), and Schedule 5 (Reconciliation of Net Income). Bureau of Internal Revenue Filing and Submission Requirements 1702-RT - BIR
"Yes. Year ending 2018. Excel format," Arthur said confidently.
To file your returns without hitches, follow this structured data pipeline:
: For RCIT, input 0.25 (25%). For smaller domestic corporations meeting thresholds (Assets ≤ ₱100 million, net taxable income ≤ ₱5 million), input 0.20 (20%). The most practical and widely used method for
This section captures the essential metadata of the reporting entity: Taxpayer Identification Number (TIN) and RDO Code. Registered Name and Registered Address. Line of Business and Date of Incorporation.
💡 Always double-check your Alphanumeric Tax Code (ATC) . For most regular corporations, this is IC 055 . Important Deadlines & Requirements
Below is a structured, informative essay that addresses the purpose, legal context, and practical considerations of using an Excel-based format for BIR Form 1702-RT (2018 version) in the Philippines.
An optimized Excel format replicates the official BIR layout, which consists of multiple pages and schedules. Understanding these sections ensures precise data mapping: Part I: Background Information The demand for stems from several practical needs:
Supports both Itemized Deductions (requiring details for schedules like salaries, depreciation, and interest) and Optional Standard Deduction (OSD) (fixed at 40% of gross income).
Detailed breakdowns of revenue, expenses, and tax calculations. How to Prepare and File BIR Form 1702-RT
The Ultimate Guide to BIR Form 1702-RT (Version 2018) Excel Templates