Format ((free)): Bir Form 1702 Rt Version 2018 Excel

If you are designing your own sheet or evaluating a downloaded template from online accounting communities, look for these functional pillars:

A resident foreign corporation engaged in trade or business within the Philippines.

Do you use or the Optional Standard Deduction (OSD) ?

Itemized deductions or Optional Standard Deductions (OSD) calculate perfectly based on gross revenue. bir form 1702 rt version 2018 excel format

This section contains basic corporate data. Errors here can lead to filing penalties. Your Excel file should include fields for: Taxpayer Identification Number (TIN) and RDO Code. Registered Name, Registered Address, and Contact Details. Line of Business and PSIC Code. Method of Deduction (Itemized or OSD). Part II: Total Tax Due

The section where your Audited Financial Statements (Income Statement and Balance Sheet) are transposed. It maps out your Sales/Revenues, Cost of Sales, and Ordinary Allowable Itemized Deductions (such as salaries, rent, utilities, and depreciation). Step-by-Step Guide to Using the Excel Template

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. If you are designing your own sheet or

Details regarding how the tax was paid (Cash, Bank Debit Memo, Check, or Tax Credit Certificate). Mandatory Schedules

Manual tax computation invites human error. A well-built Excel template embeds specific tax formulas—such as calculating the Regular Corporate Income Tax (RCIT) versus the Minimum Corporate Income Tax (MCIT) and automatically applying whichever is higher. 2. Streamlined Data Auditing

Comprehensive Guide to BIR Form 1702-RT (Version 2018) in Excel Format This section contains basic corporate data

To maximize the utility of your BIR Form 1702-RT Excel sheet, verify that the following core logical formulas are correctly embedded: Gross Income Computation

[Trial Balance / FS] ➔ [1702-RT Excel Template] ➔ [Data Validation] ➔ [eBIRForms / EFPS Encoding] ➔ [Online Submission & Payment] Step 1: Populate the Financial Schedules