Bir Form 1702 Rt Version 2018 Excel Format -

: Line 39 multiplied by Line 40.

Many tax professionals create their own Excel templates to:

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

Navigating the complexities of Philippine corporate taxation requires precision, and for many businesses, is a crucial document.

: Taxpayer Identification Number (TIN), Registered Name, Registered Address, RDO Code, and Line of Business. bir form 1702 rt version 2018 excel format

If the taxpayer selects OSD, the deduction is strictly limited to 40% of the Gross Income. Your Excel template should feature a conditional formula: =IF(Deduction_Method="OSD", Gross_Income * 0.40, SUM(Schedule_4_Total)) Taxable Income

If you are downloading a template online or building one from scratch, verify that it includes the following advanced functionalities:

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.

Platforms like pdfFiller and DocHub offer editable templates that can be exported to various formats. : Line 39 multiplied by Line 40

Remember that filing the 1702-RT is only half the battle. You must submit your scanned copies of Form 1702-RT with the filing confirmation, Audited Financial Statements, Notes to FS, and BIR Form 2307 (Certificate of Creditable Tax Withheld at Source) via the eAFS portal within 15 days from the statutory filing deadline.

BIR requires peso rounding (0.50 and above round up). Use: =ROUND(computation,0) on all final tax amounts.

High-quality templates feature error-trapping cells. For example, if your total itemized deductions on the summary page do not match the sum of Schedule 3, the cell should turn red.

Tracks historical losses that can be offset against current taxable income. If the taxpayer selects OSD, the deduction is

Excel allows tax preparers to link the tax return directly to the company's Trial Balance, Financial Statements (Balance Sheet and Income Statement), and tax reckoning schedules.

Legislative changes (like the CREATE Act or CREATE MORE Act) dynamically alter corporate tax rates. Ensure the tax rate cell in your Excel file reflects the exact statutory rate applicable to the specific taxable year you are filing.

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.

Accurately compute NOLCO and MCIT in the designated schedules.