Bir Form 1702 Rt Version 2018 Excel Format Jun 2026

Includes TIN, RDO Code, Registered Name, Address, and Date of Incorporation.

Mastering BIR Form 1702-RT Version 2018 in Excel Format: A Comprehensive Guide for Philippine Corporations

BIR Form 1702-RT (January 2018 version) is the Annual Income Tax Return specifically designed for

I am sharing a copy of in Excel format . This version is useful for: ✅ Drafting and computation: Easier to validate figures with Excel formulas. ✅ Data validation: Checking for discrepancies before filing. ✅ Record keeping: Maintaining a soft copy for your digital archives. bir form 1702 rt version 2018 excel format

receiving regular income (e.g., trading, manufacturing, service-oriented businesses).

Yes, as a supporting schedule, but only if accompanied by the official BIR form (printed from eBIRForms). You cannot submit standalone Excel printouts as the tax return.

Details regarding how the tax was paid (Cash, Bank Debit Memo, Check, or Tax Credit Certificate). Mandatory Schedules Includes TIN, RDO Code, Registered Name, Address, and

| 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 |

While the official filing is typically done through the or the eFPS (Electronic Filing and Payment System) , many taxpayers use Excel templates for preparation and computation. Key Components of Form 1702-RT (v2018)

To provide a more tailored Excel solution, please let me know: Yes, as a supporting schedule, but only if

When preparing the form in Excel, ensure you have the following sections:

#TaxSeason #BIR #Form1702RT #AccountingPH #TaxResources #ExcelTemplates