Bir Form 1702 Rt Version 2018 Excel Format __link__ Access

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

Once your Excel computation is accurate, here’s how to file Version 2018:

Many searches for "1702-RT Excel format," but an official Excel template was never released by the BIR. The official form is a within the offline eBIRForms Package v7.9.5 or higher—a standalone Windows application for offline filling.

January 2018 (C) - This is the version required by the BIR for reporting.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. bir form 1702 rt version 2018 excel format

Line of Business and ATC (Alphanumeric Tax Code) — typically IC 010 for Domestic Corporations or IC 020 for Resident Foreign Corporations. Part II: Total Tax Payable

: For entities completely Exempt from income tax.

Comprehensive Guide to BIR Form 1702-RT (Jan 2018 v2018) in Excel Format

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. An Excel format allows accountants to simulate different

Importantly, the form is for entities subject only to the regular income tax rate. It is not for those already subject to a final tax, capital gains tax, or those enjoying a special tax regime.

A comprehensive Excel workbook for the 2018 version of Form 1702-RT generally mirrors the physical four-page document format through interconnected tabs: Tab 1: Background Information & Tax Due Summary

Include a column with the exact description of each line item as it appears on the official BIR form. This ensures that every person working on the file understands exactly what information belongs where.

| Rule | Excel Implementation | |------|----------------------| | For corporations with gross sales ≤ PHP 10M are subject to 30% RCIT but MCIT applies only if there is gross income. | IF(AND(GrossSales<=10000000, GrossIncome>0), MIN(Line9, Line12), Line9) | | MCIT = 2% of Gross Income (Line 5) | =Line5 * 0.02 | | If MCIT > RCIT, MCIT is payable. | =MAX(RCIT, MCIT) | | Allowable deductions cannot exceed Gross Income. | Data validation: Deductions <= Gross Income | | Tax credits cannot exceed Tax Due. | Conditional formatting alert | Seamless Data Mirroring Once your Excel computation is

Some users input total deductions directly in Part I. That will fail BIR validation. Always break down deductions per BIR’s schedule.

Here are some tips and reminders when filling out BIR Form 1702 RT Version 2018 Excel Format:

Missing the deadline comes with serious consequences: