Bir Form 1702 Rt Version 2018 Excel Format -

Only if you are filing an amended return for a tax year covered by 2018 rules (e.g., 2018, 2019, 2020, or FY starting in 2020). For current year filing, use the latest BIR form version.

| 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 | bir form 1702 rt version 2018 excel format

MCIT applies starting on the 4th year of operation. Many Excel templates miss the “4th year” filter. Add a field: “Year of operation” – if less than 4, MCIT = zero. Only if you are filing an amended return

Introduction: The Search for the Right Tax Form | Less: Credits & Withholding | WT, CWT,

: Visit www.bir.gov.ph → under “Taxes & Forms” → select “Income Tax” → filter by “Form 1702-RT” → choose version “January 2018 (ENCS)”. Part 5: Key Validation Rules in Excel for Version 2018 When designing or using an Excel version of Form 1702-RT (2018), ensure these business rules are built-in:

Every corporation, partnership, or non-individual taxpayer in the Philippines dreads one thing: the annual income tax return. For corporations under the Regular Corporate Income Tax (RCIT) regime, the go-to form is . Specifically, the Version 2018 (January 2018 ENCS) remains a critical reference point because later versions (like the 2022 EOPT update) introduced major changes. However, many taxpayers still need to reconstruct or compute prior-year filings, or prefer working in a spreadsheet before transcribing into the eBIRForms package.