While the Bureau of Internal Revenue (BIR) provides the Offline eBIRForms Package for electronic filing, many accountants prefer an for preparation because:
When designing or using an Excel version of Form 1702-RT (2018), ensure these business rules are built-in:
If choosing , fill out the breakdown of administrative and selling expenses.
BIR Form 1702-RT must be filed on or before the . For calendar year taxpayers, this means the deadline is April 15 of the following year.
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.
BIR Form 1702-RT (Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject Only to Regular Income Tax Rate) version January 2018 (ENCS)
For amended returns (Line G “Amended” = Yes), Excel should require entry of the original return’s BIR Receipt Date and Reference Number.
This section contains embedded mathematical logic. It takes your Gross Income, subtracts your chosen deduction method, applies the current statutory corporate tax rate, and outputs the final tax due. Part IV: Details of Income / Deductions
: Excel allows financial teams to map out multiple draft iterations without accidentally submitting raw, unverified data online.
