Bir Form 1702 Rt Version 2018 Excel - Format
For corporations, partnerships, and other non-individual taxpayers in the Philippines, tax compliance is a non-negotiable annual ritual. One of the most critical forms in the corporate tax ecosystem is BIR Form 1702-RT – the Annual Income Tax Return For Corporations, Partnerships and Other Non-Individual Taxpayers Subject Only to the Regular Income Tax (RCIT) Rate Under Sections 27(A) and 40(B)(1) of the Tax Code, as amended, and For Non-Resident Foreign Corporations Not Engaged in Trade or Business (NRFC-NETB).
The version that remains a benchmark for many taxpayers today is the Version 2018 (ENCS) . With the rise of spreadsheet-based tax preparation, many finance professionals actively search for the BIR Form 1702 RT Version 2018 Excel format – a downloadable, editable spreadsheet that mimics the official return.
But where can you find it? Is it still valid? How do you accomplish it correctly? This article provides everything you need to know.
| Line | Description | Amount |
|------|-------------|--------|
| 24 | Total tax due | =L18 |
| 25 | Less: Total tax credits | =SUM(L20:L22) |
| 26 | Net tax payable | =L24 - L25 |
| 27 | Add: Penalties (Surcharge + Interest + Compromise) | [input] |
| 28 | Total amount payable | =L26 + L27 | bir form 1702 rt version 2018 excel format
| Line | Description | Amount |
|------|-------------|--------|
| 9 | Gross sales/revenues/receipts/fees | [input] |
| 10 | Less: Sales returns, discounts, allowances | [input] |
| 11 | Net sales/revenues | =L9 - L10 |
| 12 | Cost of sales/services | [input] |
| 13 | Gross income | =L11 - L12 |
| 14 | Add: Other taxable income | [input] |
| 15 | Total gross income | =L13 + L14 |
| 16 | Less: Deductions (Itemized or OSD) | [input] |
| 17 | Taxable income | =L15 - L16 |
| 18 | Income tax due (MCIT or RCIT, whichever applies) | [input or formula] |
| 19 | Less: Tax credits/payments | |
| 20 | - Creditable withholding tax | [input] |
| 21 | - Quarterly payments | [input] |
| 22 | - Foreign tax credit | [input] |
| 23 | Tax payable (refund) | =L18 - SUM(L20:L22) |
Despite the availability of PDF and eBIRForms, many tax practitioners and corporate finance departments prefer an Excel-based template 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.
The 2018 version’s complexity—particularly with the revised tax rates, Minimum Corporate Income Tax (MCIT) interaction, and creditable withholding tax reconciliation—makes manual computation error-prone. An Excel version with pre-programmed formulas reduces arithmetic mistakes and saves time during tax season. automate carry-forward of prior year’s data
For returns with attachments (audited FS, schedules), you must compress (zip) the .dat file and all attachments, then upload to the eAFS portal.
1. Is the BIR Form 1702 RT Version 2018 Excel format still accepted by BIR?
No, the BIR does not accept Excel files as official tax returns. Use eBIRForms for submission. Excel is for preparation only.
2. Where can I download a working 1702-RT Excel template for free?
Check the Facebook group “BIR eBIRForms Users Philippines” or reputable accounting blogs like Tax and Accounting Philippines. Always scan for viruses. create dynamic schedules for depreciation
3. Can I use the 2018 version for fiscal year 2024?
Yes, unless the BIR releases a newer form version before your filing deadline. Monitor BIR RMC No. and eBIRForms update notices.
4. What’s the difference between 1702-RT and 1702-EX?
1702-RT is for RCIT; 1702-EX is for those availing of income tax exemptions under special laws (e.g., PEZA, BOI). Do not confuse them.
Searching for “BIR Form 1702 RT Version 2018 Excel format free download” can lead to scam sites or malware-laden files. Never download Excel templates from unverified blogs or Facebook groups unless you trust the source.
The safe approach: