| A | B | C | |---|---|---| | BIR Form No. | 1702-RT | (Version 2018) | | Annual Income Tax Return | | | | For Corporation, Partnership, and Other Non-Individual Taxpayer | | | | Part I – Taxpayer Information | | | | 1 | TIN | [input] | | 2 | RDO Code | [input] | | 3 | Business Name | [input] | | 4 | Registered Address | [input] | | 5 | Zip Code | [input] | | 6 | Taxable Year | [input (YYYY)] | | 7 | Amended Return? (Yes/No) | [dropdown] | | 8 | Short Period Return? (Yes/No) | [dropdown] |
Because the BIR does not provide an official Excel, you have three options:
Firms handling dozens of corporations use an Excel template of Form 1702-RT (Version 2018) to consolidate data before final encoding into eBIRForms or submission via the new eAFS (Electronic Audit Form System). bir form 1702 rt version 2018 excel format
Several accounting forums and Facebook groups (e.g., “BIR Tax Help Philippines”) share user-made Excel files. Before using any:
| 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) | | A | B | C |
|---|---|---|
| BIR Form No
Auditors and tax heads prefer Excel because changes are tracked. When preparing the 1702-RT, multiple team members can review formulas and inputs without logging into a BIR-locked environment.
Even with a powerful Excel template, mistakes happen. Avoid these: Because the BIR does not provide an official
| Error | Consequence | Fix | |-------|-------------|-----| | Using pre-CREATE tax rate (25% instead of 20% for small corps) | Overpayment or underpayment | Update your Excel formula to reference current law. | | MCIT miscalculation – using “net income” instead of “gross income” | Incorrect tax due | MCIT = 2% of Gross Sales/Receipts less returns/discounts. | | Missing schedule of deductions | Penalty for incomplete attachment | Ensure Schedule 1 in Excel is printed/filled. | | Forgetting to convert Excel to eBIRForms .dat | Filing rejection | Never submit .xlsx; always migrate data to eBIRForms. |
| 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 |