Bir Form 1702 Rt Version 2018 Excel Format
For calculations, if you want to calculate total tax:
If filing manually, print the completed PDF (generated from eBIRForms), not your Excel spreadsheet. The BIR will not accept handwritten Excel printouts.
Pay any outstanding tax liability through Authorized Agent Banks (AABs) or via online payment channels (e.g., GCash, Maya, LinkBizPortal). 6. Critical Reminders and Best Practices
Navigating Philippine tax compliance can be complex, especially with periodic updates to forms like . If you are looking for the January 2018 (ENCS) version in a user-friendly format, an Excel template is a practical tool for pre-calculating figures before official filing.
Input data from the Excel template into the eBIRForms offline package. Validate and submit. bir form 1702 rt version 2018 excel format
Excel allows you to pre-calculate, check subtotals, and verify calculations between schedules (e.g., ensuring Schedule 5 nets to the tax calculation section).
Navigating corporate tax compliance in the Philippines requires precision, especially when dealing with the Bureau of Internal Revenue (BIR). For corporations, partnerships, and other non-individual taxpayers subject only to the regular income tax rate, is a critical annual requirement.
This section contains basic corporate data. Errors here can lead to filing penalties. Your Excel file should include fields for: Taxpayer Identification Number (TIN) and RDO Code. Registered Name, Registered Address, and Contact Details. Line of Business and PSIC Code. Method of Deduction (Itemized or OSD). Part II: Total Tax Due
Payments can be made through Authorized Agent Banks (AABs) or online banking channels (e.g., GCash, PayMaya, Landbank). For calculations, if you want to calculate total
Ensure the Net Income in Schedule 5 matches the amount on Page 2, Part V.
By utilizing a robust, well-mapped Excel template for your BIR Form 1702-RT, you transform a stressful annual tax filing period into a structured, easily auditable, and stress-free corporate routine.
The 2018 version was created under the TRAIN Law framework. Keep in mind that subsequent laws, such as the CREATE Act (Republic Act No. 11534) and CREATE MORE, introduced changing corporate tax rates (e.g., reductions to 25% or 20% depending on net income and assets). Ensure your Excel formulas are updated to reflect the exact tax rate applicable to the specific taxable year you are filing.
While the BIR requires electronic filing via the eBIRForms package (Version 7.9.3 or higher), using an Excel format for preparation is common for several reasons: Input data from the Excel template into the
The BIR’s eBIRForms application (version 7.9 and later) allows offline filing, but it lacks the real-time formula auditing that Excel provides. An Excel version allows users to:
: Certain accounting networks build macro-enabled Excel sheets that export raw text data directly compatible with eFPS system uploads. Key Structure & Schedules of BIR Form 1702-RT
* Number. * Date (MM/DD/YYYY) * Amount. * 23 Cash/Bank Debit Memo. * 24 Check. * 25 Tax Debit Memo. * 26 Others (specify below) Bureau of Internal Revenue BIR Form 1702-RT - eFPS
