Bir Form 1702 Rt Version 2018 Excel Format [repack] Jun 2026

for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate : Ensure you select "1702-RT version 2018 C" within the eBIRForms software. : Filed on or before the 15th day of the 4th month

Your company's (e.g., trading, manufacturing, or services) to map your cost of sales.

Arthur looked at the long line behind him. He looked at his watch. 4:45 PM. Fifteen minutes before the system shut down for maintenance.

It produces the required XML file for easy uploading via the eBIRForms system or eFPS.

Always save the final generated PDF from the eBIRForms package as your record, in addition to your Excel working paper. bir form 1702 rt version 2018 excel format

Captures the balance sheet elements: Assets, Liabilities, and Equity. This section ensures your tax declaration aligns perfectly with the Audited Financial Statements (AFS) submitted to the Securities and Exchange Commission (SEC). Essential Features to Look for in a 1702-RT Excel Template

On or before the 15th day of the 4th month following the close of the taxable year (e.g., April 15 for calendar year filers).

Official BIR Excel files are generally used for Summary Lists of Sales/Purchases (SLSP) or eFPS uploads . Third-party platforms like JuanTax often provide tools that handle the Excel-to-XML conversion for you.

Built-in Excel formulas automatically calculate gross income, allowable deductions (Itemized vs. Optional Standard Deduction), Net Taxable Income, and the final Tax Due. This eliminates manual mathematical errors. He looked at his watch

"Can I airdrop it to you?" Arthur asked.

The default is always electronic filing; manual filing is an exception, not an option.

This column holds your actual financial data. Use formulas to automate calculations across different parts of the form. For example, line 29 (Net Sales) should automatically compute as line 27 minus line 28.

Create a column that exactly mirrors the form's line numbers. This is crucial for seamless data transfer. For example, you might have: It produces the required XML file for easy

Gross sales minus sales returns and allowances to find Net Sales.

Incorporates creditable withholding taxes ( BIR Form 2307 ), prior quarter payments (Form 1702Q), and foreign tax credits. 4. Key Formulas to Embed in Your Excel Template

– Tracking losses from previous years that can be deducted from current gross income.

In the Philippine tax system, the Bureau of Internal Revenue (BIR) requires corporations, partnerships, and other non-individual taxpayers to file annual income tax returns. Among these, —the Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject to Regular Tax—is a critical document. The 2018 version of this form introduced significant changes aligned with the Tax Reform for Acceleration and Inclusion (TRAIN) Law. While the BIR officially provides a PDF version, the demand for an Excel format of BIR Form 1702-RT (2018) has grown among taxpayers and accountants seeking automation, accuracy, and ease of computation. This essay explores the nature of the form, the rationale behind the Excel version, its advantages, limitations, and compliance considerations.

Input your company's financial data, including gross income, allowable deductions, and tax due.