⚠️ Avoid sites asking for payment. The keyword includes "free" for a reason. No legitimate template for BIR filing should cost money. Also avoid macro-enabled (.xlsm) files from unknown sources—they may contain malware.
: For complex structures dealing with mixed income, operating under multiple tax frameworks like regular rates combined with localized PEZA/BOI special rates. Structural Layout of Form 1702-RT (2018 Version)
Disclaimer: This article is for informational purposes only and does not constitute legal or tax advice. Tax laws and rates are subject to change. Always verify with the Bureau of Internal Revenue (BIR) or a licensed tax professional before filing. bir form 1702 rt version 2018 excel format free
Launch the latest version of the official BIR Offline eBIRForms Package on your computer.
While various accounting communities and forums share of the BIR Form 1702-RT Version 2018 Excel format, you can safely create your own or verify a downloaded file by mapping out these standard cell formulas: Step-by-Step Excel Formula Mapping Form Line / Item Description Excel Formula Implementation Example Gross Profit Total Sales minus Cost of Sales =CELL(Sales_Amount) - CELL(Cost_of_Sales) Total Deductions Sum of all itemized operating expenses =SUM(Cell_Start:Cell_End) of expense schedules Optional Standard Deduction (OSD) 40% of Gross Income (if elected) =CELL(Gross_Profit) * 0.40 Net Taxable Income Gross Profit minus selected deduction method ⚠️ Avoid sites asking for payment
Ensure that any amount entered under (Tax Credits) is backed up completely by physical or electronic certificates. Your total Creditable Tax Withheld at Source must perfectly match the sum of your BIR Form 2307 certificates collected from clients throughout the fiscal year. Step 4: Validate and Transfer to eBIRForms
If you have downloaded a free BIR 1702-RT Excel template, follow these strategic steps to maximize its utility: Step 1: Select Your Deduction Method Carefully Also avoid macro-enabled (
The deadline for filing BIR Form 1702-RT and paying any tax due is . For calendar-year taxpayers, this deadline is typically on April 15 of the following year.
Ensure the downloaded .xlsx or .xlsm file does not contain malicious VBA macros. Run it through updated antivirus software.
Complete Guide to BIR Form 1702-RT Version 2018 (Excel Format Free Download)
If you are creating or editing your own 1702-RT Excel sheet, ensure it includes: