Bir Form 1702 Rt Version 2018 Excel Format //top\\ Free [ PREMIUM × 2024 ]

Once you have your free Excel file, follow these steps to complete it correctly.

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

Method of Deduction (Itemized Deduction vs. Optional Standard Deduction or OSD). 2. Part II – Total Tax Payable bir form 1702 rt version 2018 excel format free

BIR Form 1702-RT Version 2018 Excel Format Free: The Ultimate Guide

: Choose between Itemized Deductions or the Optional Standard Deduction (OSD) . Once chosen, this cannot be changed for that taxable year. Once you have your free Excel file, follow

=IF(OSD_Elected, Gross_Profit - OSD, Gross_Profit - Itemized_Deductions) Net Taxable Income multiplied by current tax rate =CELL(Net_Taxable_Income) * Tax_Rate_Percentage Precautions When Downloading "Free" Files

Yes, as long as the Excel template reflects exactly the fields and format of the official BIR Form 1702 RT (Version 2018). You must print it on the prescribed paper size (A4 or legal) and submit it with the required attachments. Many RDOs accept Excel-generated printed returns. Before typing anything into Excel

A resident foreign corporation receiving income from sources within the Philippines. A general professional partnership or ordinary partnership.

: Non-individual taxpayers (corporations/partnerships) subject to the regular income tax rate, which was historically 30% but has been updated to 25% or 20% under newer regulations like the CREATE Act.

Before typing anything into Excel, finalize your Statement of Comprehensive Income (Income Statement) and Statement of Financial Position (Balance Sheet). Ensure all reconciliation items (such as non-deductible expenses and tax-exempt income) are identified. Step 2: Input Data Chronologically