Rt Version 2018 Excel Format — Bir Form 1702

Ensure you are applying the correct income tax rate in Item 40 (25% or 20%).

While the BIR provides official electronic systems, many accountants and business owners actively seek a reliable Excel format of the 2018 version to streamline computations, perform dry runs, and maintain offline backups. What is BIR Form 1702-RT?

Gross Income from Operation=Sales/Revenues/Receipts−Cost of Sales/ServicesGross Income from Operation equals Sales/Revenues/Receipts minus Cost of Sales/Services

"Wait," Arthur said. "I have a backup. On my phone." bir form 1702 rt version 2018 excel format

He approached the queuing machine, took a number, and sat down on a plastic chair that had seen better decades. He pulled out his phone. Now serving 405. He was number 612. He had time.

Also, ensure your Excel automatically flags:

: Draft files can be shared with management, auditors, and tax consultants for continuous correction before final electronic submission. 3. Structural Breakdown of BIR Form 1702-RT (Excel Matrix) Ensure you are applying the correct income tax

Before relying on a downloaded Excel format, manually verify a few calculations. Ensure that the logic correctly picks the higher value between the Normal Corporate Income Tax (NCIT) and the Minimum Corporate Income Tax (MCIT) if your corporation is already subject to MCIT.

| Line | Field Name | Description | | :--- | :--- | :--- | | 27 | Sales/Receipts/Revenues/Fees | Total gross sales/receipts | | 28 | Less: Sales Returns, Allowances and Discounts | Deductions from gross sales | | 29 | Net Sales/Receipts/Revenues/Fees | Line 27 minus Line 28 | | 30 | Less: Cost of Sales/Services | Direct costs of generating revenue | | 31 | Gross Income from Operation | Line 29 minus Line 30 | | 32 | Add: Other Taxable Income Not Subjected to Final Tax | Other income not subject to final withholding tax | | 33 | Total Taxable Income | Sum of Lines 31 and 32 |

An Excel format allows accountants to simulate different tax scenarios. For example, you can easily toggle between choosing versus the Optional Standard Deduction (OSD) to determine which method yields the lowest legal tax liability for your company. 3. Seamless Data Mirroring He pulled out his phone

Ordinary partnerships, joint-stock companies, and associations.

The template automatically compares the regular tax percentage against the 2% MCIT on gross income and applies whichever is higher.

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

The is the definitive Annual Income Tax Return required for corporations, partnerships, and other non-individual taxpayers in the Philippines whose income is subject only to the regular corporate income tax rate . Keeping track of extensive financial records, computing dynamic deductions, and preparing this return manually or directly in the offline eBIRForms package can be prone to human errors.

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