Filing your BIR Form 1702-RT (Annual Income Tax Return) can be simplified by using an Excel format for data preparation before encoding it into the eBIRForms or eFPS systems. This form is specifically for corporations, partnerships, and non-individual taxpayers subject only to the regular income tax rate. Guide to BIR Form 1702-RT (v2018)
The January 2018 (ENCS) version of Form 1702-RT includes several schedules and parts that require precise data entry. While the official BIR website provides PDF versions, many taxpayers use Excel templates to automate calculations like Cost of Sales and NOLCO. Key Components of the 2018 Version
Part I: Background Information (TIN, RDO Code, Registered Name).
Part II: Total Tax Payable (Summary of tax due and penalties).
Part IV: Computation of Tax (Where you input Gross Income and Deductions). Schedules: Schedule I: Ordinary Allowable Itemized Deductions. Schedule III: Net Operating Loss Carry Over (NOLCO). bir form 1702 rt version 2018 excel format
Schedule V: Reconciliation of Net Income per Books against Taxable Income. How to Use Excel for Filing
Download a Template: Use a trusted source or create your own based on the official 1702-RT PDF.
Prepare Your Data: Encode your trial balance into the Excel sheet.
Automate Calculations: Ensure your Excel formulas for Gross Income (Sales minus Cost of Sales) and Taxable Income match BIR's logic. Filing your BIR Form 1702-RT (Annual Income Tax
Encoding: Once your Excel figures are ready, open the Offline eBIRForms Package and select "1702-RT version 2018".
Validation: Manually copy the figures from Excel to the software. Click "Validate" to check for errors.
💡 Pro Tip: Always double-check your Alphanumeric Tax Code (ATC). For most regular corporations, this is IC 055. Important Deadlines & Requirements
Filing Date: On or before the 15th day of the 4th month following the close of the taxable year (e.g., April 15 for calendar year filers). Understanding BIR Form 1702-RT (2018 Version) BIR Form
Attachments: You must submit the Audited Financial Statements (AFS) and the Summary Alphalist of Withholding Agents (SAWT) via the BIR eAFS system. If you'd like, I can help you with: A detailed list of account titles for Schedule I Explaining how the CREATE Law affects your tax rate Steps for submitting attachments via eAFS Which part of the 1702-RT process should we focus on next?
AI responses may include mistakes. For financial advice, consult a professional. Learn more
BIR Form 1702-RT is filed annually by domestic corporations and partnerships whose gross annual sales or earnings exceed the VAT threshold and are subject to the regular corporate income tax (RCIT) rate of 25% (or 20% for certain qualified entities). The 2018 version reflects amendments brought by the TRAIN Law (Republic Act No. 10963), including adjustments to optional standard deduction (OSD) rates, improvements in allowable deductions, and alignment with the revised withholding tax regulations.
The form consists of several parts: taxpayer information, computation of taxable income, income tax due, tax credits and payments, and summary of tax payable. Filing is done via the BIR’s Electronic Filing and Payment System (eFPS) for mandated taxpayers, or manually with electronic filing (eBIRForms) for others. The official format is a government-issued PDF with embedded calculations.
eBIRForms will produce a PDF confirmation receipt. Save it.
Open eBIRForms Offline → Select “1702-RT” → Choose version “2018” (if still available; otherwise, contact BIR for legacy access). Manually encode figures from your Excel.