Bir Form 1702 Rt Version 2018 Excel Format __top__ -
Detailed breakdown of gross income, sales returns, and cost of services to arrive at taxable income.
To prevent accidental deletion of critical BIR tax formulas (like the RCIT vs MCIT logic statement), all calculation cells should be password-protected or locked.
The version released in January 2018, coded "ENCS" (Enhanced Non-Computational System) in the upper corner, introduced a user-friendly layout specifically for the eBIRForms offline package.
An effective Excel template perfectly mirrors the official BIR layout, which consists of multiple pages and complex schedules. Understanding these zones ensures you populate your spreadsheet correctly: Background Information (Part I) bir form 1702 rt version 2018 excel format
For those handling the Final Adjustment or Consolidated Return for corporations and partnerships, having a workable digital file is essential for efficiency.
High-quality templates feature error-trapping cells. For example, if your total itemized deductions on the summary page do not match the sum of Schedule 3, the cell should turn red.
Click validate and submit. Pay the taxes due through authorized agent banks (AABs) or online payment platforms. Tips for Ensuring Accuracy Detailed breakdown of gross income, sales returns, and
While the BIR provides the Electronic Bureau of Internal Revenue Forms (eBIRForms) offline package for official submission, many accountants, financial officers, and business owners rely heavily on for preparation, computation, and internal auditing.
The Corporate Income Tax (either the Normal Corporate Income Tax or the Minimum Corporate Income Tax, whichever is higher) computes instantly.
Gross Income from Operation=Sales/Revenues/Receipts−Cost of Sales/ServicesGross Income from Operation equals Sales/Revenues/Receipts minus Cost of Sales/Services An effective Excel template perfectly mirrors the official
is the Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject Only to the Regular Income Tax Rate .
If filing manually, print the completed PDF (generated from eBIRForms), not your Excel spreadsheet. The BIR will not accept handwritten Excel printouts.
By organizing your accounting ledger data into an Excel sheet that mirrors the exact layout of the 2018 version of Form 1702-RT, you can easily copy and paste or transcribe data into the official eBIRForms software without getting lost in the various schedules. Key Schedules and Sheets in the 1702-RT Excel Template
Tax laws and regulations may change. Always check the official BIR website for the most current regulations and forms.