Bir Form 1702 Rt Version 2018 Excel Format [SECURE — 2026]
The official submission must ultimately pass through official software like eBIRForms or eFPS. However, utilizing a localized Excel format during tax preparation offers distinct advantages:
: 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
There is on the BIR website. However, tax professionals have long created unofficial Excel templates that mirror the exact line items, column headers, and compute tax automatically. These are what most people mean when they search for an "Excel format."
: Excel allows financial teams to map out multiple draft iterations without accidentally submitting raw, unverified data online.
If filing manually, print the completed PDF (generated from eBIRForms), not your Excel spreadsheet. The BIR will not accept handwritten Excel printouts. bir form 1702 rt version 2018 excel format
Gross Sales: Match. Cost of Sales: Match. Operating Expenses: Match.
Before pushing data to the unyielding interface of eBIRForms, Excel allows accounting teams to trace numbers back to the trial balance. You can link your financial statements (Income Statement and Balance Sheet) directly to the tax return schedules. 3. Scenario Planning
While the Bureau of Internal Revenue (BIR) provides the official offline eBIRForms package and the Electronic Filing and Payment System (eFPS), many accountants, tax practitioners, and business owners heavily rely on a for preparation, internal auditing, and mock computations.
For amended returns (Line G “Amended” = Yes), Excel should require entry of the original return’s BIR Receipt Date and Reference Number. The BIR will not accept handwritten Excel printouts
And today was the deadline.
: Line 39 multiplied by Line 40.
Inputting financial figures directly into eBIRForms without a dry run can lead to formatting errors, missing fields, or miscalculated deductions that are difficult to correct once submitted.
The form must be filed on or before the following the close of the taxpayer’s taxable year. For calendar-year corporations, this crucial deadline falls on April 15 of each year. Understanding the "Version 2018" Changes whichever is higher) computes instantly.
A general professional partnership (GPP) or taxable partnership. An estate or trust engaged in trade or business.
Never trust an internet-downloaded Excel template blindly. Manually recalculate a sample line to verify that the sums and tax rates applied in the cell formulas are accurate.
Also, ensure your Excel automatically flags:
The Corporate Income Tax (either the Normal Corporate Income Tax or the Minimum Corporate Income Tax, whichever is higher) computes instantly.