top of page
phlemuphburredisti

BIR Form 1702-RT: The Ultimate Guide to Excel Download and Filing



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.




1702-rt excel download



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.


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 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


How to Download 1702-RT?




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


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 "=IF(D2<=250000,0,IF(D2<=400000,E2*0.2,IF(D2<=800000,50000+E2*0.25,IF(D2<=2000000,150000+E2*0.3,IF(D2<=8000000,550000+E2*0.32,2410000+E2*0.35)))))". This formula will determine your tax due based on your taxable income and tax rate.



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



You should have a table that looks like this (assuming your gross income is P1,500,000):



Gross Income


Taxable Income


Tax Due


P1,500,000


P700,000


P360,000


Copy and Paste the Results to 1702-RT Form




Now that you have calculated your taxable income and tax due using Excel tables, you can copy and paste the results to your 1702-RT form. To do so:



  • Go back to your 1702-RT form and find the section "Tax Computation".



  • In item 27A (Gross Income), enter the value from cell D2 of your Excel table.



  • In item 28A (Less: Allowable Deductions), enter the value from cell E2 of your Excel table.



  • In item 29A (Taxable Income), enter the value from cell F2 of your Excel table.



  • In item 30A (Income Tax Rate), enter the corresponding tax rate from column B of your Excel table based on your income bracket.



  • In item 31A (Income Tax Due), enter the same value from cell F2 of your Excel table.



  • Complete the rest of the form as instructed.



You should have a form that looks like this:



Conclusion




In this article, we have shown you how to download and use 1702-RT Excel form for filing your annual income tax return as a non-individual taxpayer subject only to regular income tax rate. We have also shown you how to use Excel tables to make your tax computation easier and faster.


We hope that this article has been helpful and informative for you. If you have any questions or problems with 1702-RT or any other BIR forms, you can contact the BIR through their hotline numbers, email address, or website. You can also consult a professional tax advisor or accountant for more guidance and assistance.


Thank you for reading and happy filing!


FAQs




What is eBIRForms?




eBIRForms is an online system that allows taxpayers to fill in and submit BIR forms electronically. It is designed to make tax filing more convenient, accurate, and efficient. You can access eBIRForms through the eBIRForms package or the eBIRForms online web application. You can learn more about eBIRForms .


What are the advantages of using Excel tables for 1702-RT?




Using Excel tables for 1702-RT has several advantages, such as: - You can easily create and update your tax table with the income brackets and tax rates for non-individual taxpayers. - You can quickly calculate your taxable income and tax due using formulas and functions in Excel. - You can avoid manual errors and discrepancies in your tax computation and form filling. - You can save time and effort in preparing and filing your 1702-RT form.


What are some common errors when using 1702-RT?




Some of the common errors when using 1702-RT are: - Using the wrong form or version of the form. Make sure to use the latest version of 1702-RT and check if it is applicable to your tax regime and income sources. - Leaving blank fields or entering incorrect or incomplete information. Make sure to fill in all the required fields and verify the accuracy and completeness of your information. - Miscalculating your taxable income or tax due. Make sure to follow the proper tax computation and use the correct income brackets and tax rates for non-individual taxpayers. - Failing to validate, save, print, or submit the form. Make sure to validate and save the form as a PDF file, print a copy for your records, and submit the form online or offline on or before the due date.


How can I check if my 1702-RT submission was successful?




You can check if your 1702-RT submission was successful by: - Checking your email for a confirmation message from the BIR. The email will contain your filing reference number, date and time of submission, and payment details (if any). - Logging in to your eFPS or eBIRForms account and viewing your filing history. You will see the status of your submission, whether it was received, processed, accepted, or rejected by the BIR. - Contacting the BIR through their hotline numbers, email address, or website. You will need to provide your TIN, registered name, filing reference number, and other details to verify your submission.


Where can I get help if I have questions or problems with 1702-RT?




If you have questions or problems with 1702-RT, you can get help from: - The BIR website. You can access various resources, such as forms, manuals, guides, circulars, advisories, FAQs, and contact information on . - The BIR hotline numbers. You can call (02) 8981-7003 or 8981-7020 for general inquiries or (02) 8981-7030 for eFPS-related concerns. You can also send an email to contact_us@cctr.bir.gov.ph or eFPS_support@cctr.bir.gov.ph. - The BIR Revenue District Office (RDO) where you are registered. You can visit the RDO personally or call their landline number to get assistance from their staff. - A professional tax advisor or accountant. You can hire a qualified and licensed tax practitioner to help you with your tax filing and compliance. 44f88ac181


0 views0 comments

Recent Posts

See All

Comments


bottom of page