An association, cooperative, or non-stock, non-profit organization earning taxable income outside its primary purpose.
Double-check that the formulas match the BIR layout guidelines exactly. A broken formula in a downloaded template can cause severe underpayment or overpayment penalties.
Click "Validate" in eBIRForms to check for software-side errors, then hit "Submit / Final Offer". Save the official email notification receipt. bir form 1702 rt version 2018 excel format free
This section captures basic organizational data. Accuracy here is vital, as typos can cause systemic payment matching errors. Taxpayer Identification Number () and Branch Code Registered Name and Address Line of Business and ATC (Alphanumeric Tax Code) Part II: Computation of Tax The core summary page where final figures converge. Sales/Revenues/Receipts/Fees Less: Cost of Sales/Services Gross Income from Operation
Launch the latest version of the official BIR Offline eBIRForms Package on your computer. Click "Validate" in eBIRForms to check for software-side
Joint-stock companies, joint ventures, and associations subject to regular corporate income tax.
. While the Bureau of Internal Revenue (BIR) provides official PDF and offline eBIRForms versions, many taxpayers seek Excel templates to automate complex calculations like tax due and allowable deductions. Bureau of Internal Revenue Template Features & User Sentiment Accuracy here is vital, as typos can cause
| Section | Description | | :--- | :--- | | | Collects basic taxpayer details: TIN, RDO Code, registered name, address, date of incorporation, contact number, email address, and the chosen method of deduction (Itemized Deductions or Optional Standard Deduction - OSD). | | Part II – Total Tax Payable | Summarizes the final tax due, penalty calculations, and the total amount payable (or overpayment). The overpayment options are irrevocable. | | Part III – Details of Payment | Specifies how the payment was made (e.g., cash, check, debit memo). | | Part IV – Computation of Tax | The core of the form, this section calculates the tax due based on gross income, allowable deductions, and other schedules. | | Schedules (Part VI) | Provides detailed breakdowns for various items, including the Optional Standard Deduction (OSD) , Cost of Sales, Ordinary/ Special Allowable Itemized Deductions, Net Operating Loss Carry Over (NOLCO) schedule, Tax Credits/Payments, and other required attachments like the Audited Financial Statements (AFS) . |
If you need assistance setting up your workbook, let me know. I can clarify , outline how to calculate MCIT vs. RCIT , or help you list required attachments for eAFS submission . Share public link
eBIRForms Package (Offline) or the Electronic Filing and Payment System (eFPS) 📥 Why Use an Excel Format Template for Pre-Filing?