BIR requires peso rounding (0.50 and above round up). Use: =ROUND(computation,0) on all final tax amounts.
| Line | Field Name | Description | | :--- | :--- | :--- | | 34 | Ordinary Allowable Itemized Deductions | From Schedule 1, Line 18 | | 35 | Special Allowable Itemized Deductions | From Schedule 2 (if applicable) | | 36 | Total Allowable Itemized Deductions | Sum of Lines 34 and 35 | | 37 | Optional Standard Deduction (OSD) | 40% of Gross Income (if OSD chosen in Part I, Line 13) |
BIR Form 1702-RT (version 2018) is the Annual Income Tax Return specifically for corporations, partnerships, and other non-individual taxpayers subject only to the regular income tax rate. While the official filing is done via eFPS or the Offline eBIRForms Package , many taxpayers use Excel templates to organize their data before final submission. Bureau of Internal Revenue Core Components of Form 1702-RT (v2018)
The Annual Income Tax Return (AITR) using Form 1702-RT must be filed and paid . bir form 1702 rt version 2018 excel format
This section summarizes your final tax liability. Do not enter centavos (49 centavos or less drop down; 50 or more round up).
While Excel is practical, it is . The BIR requires filing via eFPS, eBIRForms (offline), or authorized agent banks—all using the official PDF or XML. An Excel file, even if perfectly formatted, cannot be directly uploaded to BIR systems. Taxpayers must manually transcribe or use macros to transfer Excel data into the official return.
Be extremely cautious when downloading "unofficial Excel templates." The only authorized format for BIR submission is the official 2018C form through eBIRForms, eFPS, or accredited Tax Software Providers (TSPs). Any submission outside these official platforms will be accepted by the BIR. BIR requires peso rounding (0
To get the BIR Form 1702-RT (Jan 2018 v2018) in Excel format, you have a few options:
: Selectable toggles for Calendar Year or Fiscal Year, Year-End date, and whether the filing is an Amended Return.
Meeting the filing deadline is a critical part of tax compliance. While the official filing is done via eFPS
If you have a tax payable, you will specify the payment method and details in this section.
If you choose the Itemized Deductions method, you will need to complete these supporting schedules to provide a detailed breakdown of your expenses.
| Line | Description | Excel Formula/Macro Reference | |------|-------------|-------------------------------| | 1 | Gross Sales/Revenues | SUM(revenue accounts) | | 2 | Sales discounts/returns | Subtract from line 1 | | 3 | Net Sales/Revenues | =Line 1 – Line 2 | | 4 | Cost of Sales/Services | Direct input or linked | | 5 | Gross Income (L3 – L4) | =L3 – L4 | | 6 | Allowable deductions | Itemized or optional (40% OSD for non-VAT?) | | 7 | Taxable Income (L5 – L6) | =L5 – L6 | | 8 | Rate (30% for Version 2018) | Fixed cell: 0.30 | | 9 | Income Tax Due (L7 x L8) | =L7 * 0.30 | | ... | Less: Credits & Withholding | WT, CWT, Tax Paid in prior quarters | | 18 | | Final output |