Audited Financial Statements (Balance Sheet, Income Statement). Information Form (for foreign corporations). Certificate of Tax Treaty Relief (if applicable). Tax Debit Memo (if applicable). Final Tips for Compliance Ensure submission by April 15 .
Input your company's financial data, including gross income, allowable deductions, and tax due.
Encode your trial balance into the Excel sheet.
Comprehensive Guide to BIR Form 1702-RT Version 2018 Excel Formats bir form 1702 rt version 2018 excel format
A BIR Form 1702-RT Version 2018 Excel format is a foundational tool for corporate accountants looking to minimize calculation errors, optimize tax planning, and simplify the annual filing season. By utilizing an automated spreadsheet to mirror the eBIRForms layout, you protect your business from costly clerical errors and ensure a smoother, faster tax compliance workflow. To help you find or build the right template, tell me:
The BIR requires all information to be entered in all caps using black ink (if printed).
: Includes the Taxpayer Identification Number (TIN), RDO Code, registered name, address, and method of deduction (Itemized or Optional Standard Deduction). Part II - Total Tax Payable Tax Debit Memo (if applicable)
Itemized deductions or Optional Standard Deductions (OSD) calculate perfectly based on gross revenue.
The 2018 version of Form 1702-RT contains several critical sections that must be filled out accurately: BIR Form 1702-RT - eFPS
Ensure Schedule 1 (Itemized Deductions) and Schedule 2 (Special Deductions) totals correctly map to the primary tax computation on Page 2. 1702-RT - BIR Encode your trial balance into the Excel sheet
On or before April 15 of each year, covering income for the preceding taxable year.
Functionally yes, as long as formulas mirror Excel. However, Google Sheets may handle rounding and data validation differently. Test thoroughly. Never use it for final filing if offline access is required.