top of page

Meals & nutrition

Public·4 members

Excel Download for BIR Form 1702-RT: Step-by-Step Instructions


H3: From eBIRForms Package This is the second section of the article that shows two ways to download 1702-RT: from the Bureau of Internal Revenue (BIR) website or from the eBIRForms package. H2: How to Use 1702-RT? H3: Fill in the Required Information H3: Validate and Save the Form H3: Submit Online or Offline This is the third section of the article that shows how to use 1702-RT: fill in the required information, validate and save the form, and submit online or offline. H2: How to Use Excel Tables for 1702-RT? H3: Create a Table with Income Brackets and Tax Rates H3: Apply Formulas to Calculate Taxable Income and Tax Due H3: Copy and Paste the Results to 1702-RT Form This is the fourth section of the article that shows how to use Excel tables for 1702-RT: create a table with income brackets and tax rates, apply formulas to calculate taxable income and tax due, and copy and paste the results to 1702-RT form. H2: Conclusion This is the last section of the article that summarizes the main points and provides some tips and resources for further reading. H2: FAQs H3: What is eBIRForms? H3: What are the advantages of using Excel tables for 1702-RT? H3: What are some common errors when using 1702-RT? H3: How can I check if my 1702-RT submission was successful? H3: Where can I get help if I have questions or problems with 1702-RT? This is an optional section of the article that answers some frequently asked questions about 1702-RT and provides links to relevant sources. Table 2: Article with HTML Formatting How to Download and Use 1702-RT Excel Form




If you are a corporation, partnership, or other non-individual taxpayer subject only to regular income tax rate in the Philippines, you need to file an annual income tax return (ITR) using BIR Form No. 1702-RT. This form shows your income, expenses, deductions, exemptions, tax credits, tax due, and tax payments for the taxable year.


In this article, we will show you what 1702-RT is, how to download it, how to use it, and how to use Excel tables to make your tax computation easier. We will also answer some frequently asked questions about 1702-RT at the end.




1702-rt excel download


DOWNLOAD: https://www.google.com/url?q=https%3A%2F%2Ft.co%2FGq7kSLlklj&sa=D&sntz=1&usg=AOvVaw3lhEYACaoPCrUuJORoUVMR



What is 1702-RT?




BIR Form No. 1702-RT or Annual Income Tax Return for Corporation, Partnership and Other Non-Individual Taxpayer Subject Only to REGULAR Income Tax Rate is one of the different types of ITRs that non-individual taxpayers can use, depending on their tax regime and income sources. The other types are 1702-EX for those exempt from income tax, 1702-MX for those subject to multiple income tax rates or special/preferential rate, and 1702-IT for those subject to income tax, value-added tax (VAT), and percentage tax under the Tax Reform for Acceleration and Inclusion (TRAIN) Law.


1702-RT is applicable to domestic corporations, resident foreign corporations, general professional partnerships, joint ventures, consortiums, associations, and other non-individual taxpayers that are subject only to the regular income tax rate of 30%. This means that they do not have any income subject to final tax, special/preferential rate, or other tax regimes.


1702-RT is due on or before the 15th day of the fourth month following the close of the taxpayer's taxable year. For example, if your taxable year ends on December 31, 2022, you need to file your 1702-RT on or before April 15, 2023.


How to Download 1702-RT?




There are two ways to download 1702-RT: from the BIR website or from the eBIRForms package.


How to download 1702-rt excel form from BIR website


1702-rt excel form for regular income tax rate


1702-rt excel form instructions and guidelines


1702-rt excel form sample computation


1702-rt excel form deadline and penalties


1702-rt excel form vs 1702-ex excel form


1702-rt excel form online submission


1702-rt excel form validation and printing


1702-rt excel form attachment requirements


1702-rt excel form for corporation and partnership


Difference between 1702-rt excel form and 1701Q


Where to file 1702-rt excel form


Who should file 1702-rt excel form


What is the purpose of 1702-rt excel form


Benefits of using 1702-rt excel form


Tips and tricks for filling out 1702-rt excel form


Common errors and mistakes in 1702-rt excel form


How to amend 1702-rt excel form


How to compute tax due in 1702-rt excel form


How to apply tax credits in 1702-rt excel form


How to use eBIRForms for 1702-rt excel form


How to update information in 1702-rt excel form


How to import data from previous 1702-rt excel forms


How to export data from 1702-rt excel form


How to save and backup 1702-rt excel form


How to email 1702-rt excel form to BIR


How to print multiple copies of 1702-rt excel form


How to sign and stamp 1702-rt excel form


How to pay tax liability using 1702-rt excel form


How to request for refund or carryover using 1702-rt excel form


From BIR Website




You can download 1702-RT from the BIR website by following these steps:



  • Go to and click on the "BIR Forms" tab.



  • Select "Income Tax Returns" from the drop-down menu.



  • Scroll down to find "BIR Form No. 1702-RT - Annual Income Tax Return for Corporation, Partnership and Other Non-Individual Taxpayer Subject Only to REGULAR Income Tax Rate" and click on the "Download" button.



  • Save the file to your computer and open it using Adobe Acrobat Reader or any compatible software.



From eBIRForms Package




You can also download 1702-RT from the eBIRForms package by following these steps:



  • Go to and click on the "Download Offline eBIRForms Package v7.9.1" button.



  • Save the file to your computer and extract it using WinZip or any compatible software.



  • Open the extracted folder and double-click on the "eBIRForms v7.9.1" icon.



  • Select "Form" from the menu bar and choose "Annual Income Tax Return" from the drop-down list.



  • Select "1702-RT" from the list of forms and click on the "OK" button.



Note: You need to have an internet connection and a valid Taxpayer Identification Number (TIN) to use the eBIRForms package.


How to Use 1702-RT?




Once you have downloaded 1702-RT, you need to fill in the required information, validate and save the form, and submit it online or offline. Here are the steps to do so:


Fill in the Required Information




You need to fill in the following information on 1702-RT:



  • Taxpayer details: TIN, registered name, registered address, contact number, email address, main line of business, method of accounting, authorized representative (if any), etc.



  • Taxable year: The year for which you are filing the return.



  • Tax computation: The summary of your income, expenses, deductions, exemptions, tax credits, tax due, and tax payments for the taxable year. You need to attach additional schedules as needed.



  • Certification: The declaration that you are authorized to file the return and that all information is true and correct. You need to sign and date the form.



You can use the "Help" button on each page of the form to get more guidance on how to fill in each field.


Validate and Save the Form




After filling in all the required information, you need to validate and save the form. To do so:



  • Click on the "Validate" button at the bottom of each page of the form. This will check if there are any errors or inconsistencies "P50,000 + 25% of the excess over P400,000".



  • In cell A5, type "Over P800,000 but not over P2,000,000". In cell B5, type "P150,000 + 30% of the excess over P800,000".



  • In cell A6, type "Over P2,000,000 but not over P8,000,000". In cell B6, type "P550,000 + 32% of the excess over P2,000,000".



  • In cell A7, type "Over P8,000,000". In cell B7, type "P2,410,000 + 35% of the excess over P8,000,000".



  • Select cells A1 to B7 and click on the "Insert" tab. Then click on the "Table" button and check the box that says "My table has headers". Click on the "OK" button.



  • Format the table as you like. You can change the color, font, alignment, and borders of the cells.



You should have a table that looks like this:



Income Bracket


Tax Rate


Not over P250,000


0%


Over P250,000 but not over P400,000


20% of the excess over P250,000


Over P400,000 but not over P800,000


P50,000 + 25% of the excess over P400,000


Over P800,000 but not over P2,000,000


P150,000 + 30% of the excess over P800,000


Over P2,000,000 but not over P8,000,000


P550,000 + 32% of the excess over P2,000,000


Over P8,000,000


P2,410,000 + 35% of the excess over P8,000 ,000


Apply Formulas to Calculate Taxable Income and Tax Due




Now that you have the table with income brackets and tax rates, you can use formulas to calculate your taxable income and tax due based on your gross income. To do so:



  • In cell D1, type "Gross Income". In cell E1, type "Taxable Income". In cell F1, type "Tax Due".



  • In cell D2, enter your gross income for the taxable year. This is the total amount of income you earned from all sources before any deductions or exemptions.



  • In cell E2, enter the formula "=IF(D2<=250000,0,IF(D2<=400000,D2-250000,IF(D2<=800000,D2-400000,IF(D2<=2000000,D2-800000,IF(D2<=8000000,D2-2000000,D2-8000000)))))". This formula will determine your taxable income based on your income bracket.



In cell F2, enter the formula "


About

Welcome to the group! You can connect with other members, ge...
bottom of page