Bir Form 1702 Rt Version 2018 Excel Format
Excel fields should include:
Pro tip: Use Excel data validation (List) for RDO codes and Yes/No fields.
To safely leverage Excel, tax professionals should:
The fluorescent lights of the BIR regional office in Quezon City hummed with a sound that only the weary and the auditors could truly hear. Outside, the May heat radiated off the pavement, but inside, the air conditioning was set to a temperature that felt more like a morgue than a government building.
Arthur wiped a bead of sweat from his forehead, balancing a heavy envelope under his arm. He was a freelance accountant, a digital warrior in a paper battlefield. For the last three weeks, his life had been reduced to a single, daunting quest: The Annual Income Tax Return for Corporations and Partnerships.
Specifically, BIR Form 1702-RT.
And today was the deadline.
He approached the queuing machine, took a number, and sat down on a plastic chair that had seen better decades. He pulled out his phone. Now serving 405. He was number 612. He had time.
Arthur opened his briefcase and pulled out the Holy Grail of his current existence: a USB flash drive. He didn't need the physical papers yet; he needed to check the file one last time. He had spent the entire weekend wrestling with the BIR website, a digital labyrinth that moved with the speed of a sedated carabao.
He plugged the USB into his laptop and navigated to the folder labeled CLIENTS - URGENT.
There it was. The file name that had haunted his dreams: 1702RT_2018_version.xlsx.
The "Version 2018" part was crucial. The Bureau of Internal Revenue, in its infinite wisdom, frequently updated these forms. If you used the 2017 version, the system would reject it. If you used the wrong Alphalist data format, the validator would scream in red font. The 2018 Excel format was a finicky beast—formatted cells, dropdown menus that didn't work if you clicked them the wrong way, and macros that only ran if the planets were aligned.
He double-clicked the file. Excel launched.
The gridlines appeared, stark and white. He scrolled down to Part II, the Tax Computation.
"Please, no," he whispered.
A shadow fell over his screen. It was Mang Pedro, a veteran tax agent who had been working at the BIR since the days of typewriters, holding a thermos of coffee.
"Trouble, Arthur?" Mang Pedro asked, his voice raspy.
"I think the macros aren't calculating the Gross Income correctly, Mang Pedro," Arthur said, his fingers flying over the keyboard. "The formula in cell F45 is supposed to pull from Schedule 1, but it's showing zero."
Mang Pedro peered at the screen over Arthur's shoulder. "Ah. Did you enable editing? The 2018 Excel format is strict. You have to 'Enable Content' at the top or the formulas stay dead."
Arthur looked up. Sure enough, the yellow security bar sat ominously beneath the ribbon. He clicked Enable Content.
The screen flickered. The numbers shifted.
Total Tax Due: PHP 245,000.00.
Arthur exhaled, a long, shuddering breath. "You're a lifesaver, Mang Pedro."
"That is why you do not trust the cloud, Arthur," the old man chuckled, shuffling away to help a confused college student with a 2307 form.
Arthur continued his review. The beauty of the Excel format was in the auto-calculation, but the danger was in the override. One wrong keystroke in a protected cell, and the whole sheet could corrupt. He checked the financial statements against the Excel file.
Gross Sales: Match. Cost of Sales: Match. Operating Expenses: Match.
He closed the laptop. The file was ready. It wasn't just a spreadsheet; it was a story of a company's year—its struggles, its payroll, its taxes paid. And now, it was ready to be uploaded to the BIR's eFPS (Electronic Filing and Payment System).
Or so he thought.
"Number 612!" the teller shouted.
Arthur stood up, walking toward Window 3. He handed over the USB drive to the teller, a young woman with glasses and an expression of perpetual exhaustion.
"1702-RT?" she asked.
"Yes. Year ending 2018. Excel format," Arthur said confidently.
She plugged the USB into her terminal. She clicked. She frowned.
Arthur’s heart skipped a beat. "Is there a problem?"
"The file name," she said, pointing. "You saved it as 1702RT_ClientName_Final_v3.xlsx. The system won't accept special characters or long filenames." bir form 1702 rt version 2018 excel format
Arthur blinked. He had spent hours checking the formulas, but he hadn't checked the filename. The 2018 validator was picky about filenames—it needed to follow a strict convention, usually just the TIN and the form code.
"I can rename it right now," Arthur said, reaching for the mouse.
"Too late," the teller said, sighing. "The system is lagging. If you rename it now, you'll have to re-queue to upload."
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.
"Wait," Arthur said. "I have a backup. On my phone."
He pulled out his phone, navigated to his email drafts where he had sent himself a version earlier that morning just in case. He downloaded the attachment. It was the clean version. The perfect version. The 1702RT_2018_version.xlsx in its pure, uncorrupted, properly named form.
"Can I airdrop it to you?" Arthur asked.
The teller looked at him, then at the line, then at the clock. She pointed to a small icon on her desktop. "Bluetooth."
Arthur connected. Sent the file.
Transfer Complete.
She opened the file. Excel loaded. The numbers populated. She clicked the validate button on the BIR portal.
VALIDATION SUCCESSFUL.
"Payment?" she asked.
"Via online bank transfer earlier," Arthur said, showing the screenshot of the confirmation.
She stamped the physical copies he had brought. RECEIVED.
"Thank you," Arthur breathed, gripping the stamped papers like a winning lottery ticket.
He walked out of the building. The heat of the afternoon sun hit him, but for the first time in weeks, it didn't feel oppressive. He walked toward his car, pulling out his phone to text his client: Filed. Safe.
He opened his laptop bag one last time to put the papers away. He caught a glimpse of the USB drive sitting in the pocket. It was a small piece of plastic, but inside it lay the 2018 Excel Format—a digital labyrinth of cells and formulas that had consumed his life.
He smiled. "Until next year," he whispered to the drive.
He started the car and drove away, leaving the BIR office—and the Version 2018—behind him. At least, until the next deadline.
The BIR Form 1702-RT (version 2018) is the Annual Income Tax Return for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate in the Philippines.
While the official filing is typically done through the Offline eBIRForms Package or the eFPS (Electronic Filing and Payment System), many taxpayers use Excel templates for preparation and computation. Key Components of Form 1702-RT (v2018)
To prepare your Excel template, ensure it includes these standard sections:
Part I: Background Information: Taxpayer Identification Number (TIN), RDO Code, Registered Name, Registered Address, and Date of Incorporation.
Part II: Total Tax Payable: Calculation of tax due, less tax credits/payments, plus any applicable penalties (Surcharge, Interest, Compromise).
Part IV: Computation of Tax: Detailed breakdown of Sales/Receipts, Cost of Sales, Gross Income, and Allowable Deductions.
Schedules: Supplementary tables for Itemized Deductions, NOLCO (Net Operating Loss Carry Over), Tax Credits, and the Balance Sheet. Filing and Official Form Access
Understanding Offline eBIRForms: A Comprehensive Guide - JuanTax
Go to the official website of the Bureau of Internal Revenue (BIR) at www.bir.gov.ph. Click on the eServices tab on the main menu, Filing Requirements for BIR Form 1702 in the Philippines
Navigating Philippine tax compliance can be complex, especially with periodic updates to forms like BIR Form 1702-RT. If you are looking for the January 2018 (ENCS) version in a user-friendly format, an Excel template is a practical tool for pre-calculating figures before official filing.
Mastering BIR Form 1702-RT (Version 2018): Your Guide and Excel Format Tips
BIR Form 1702-RT is the Annual Income Tax Return specifically for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate. While the Bureau of Internal Revenue (BIR) provides official PDF and eBIRForms versions, many accountants prefer an Excel format for internal preparation and reconciliation. Who Needs to File 1702-RT?
This form is mandatory for non-individual taxpayers that do not have mixed income or special/preferential tax rates. Common filers include:
Domestic Corporations receiving income from both within and outside the Philippines. Partnerships (excluding General Professional Partnerships). Joint Stock Companies and associations. Key Features of the 2018 Version Excel fields should include:
The January 2018 version introduced several streamlined features for easier reporting:
Elimination of Centavos: You no longer need to enter centavos. Round down if it's 0.49 or less, and round up if it's 0.50 or more.
CREATE Law Rates: For tax years after the CREATE Law was enacted, the regular corporate income tax rate was reduced from 30% to 25% or 20% (for certain small businesses).
Mandatory Capital Letters: All entries must be in CAPITAL LETTERS using black ink. Payment/Remittance Forms - Bureau of Internal Revenue
Understanding and Filing BIR Form 1702 RT Version 2018 in Excel Format
The Bureau of Internal Revenue (BIR) of the Philippines requires taxpayers to submit various forms to comply with tax regulations. One of these essential forms is the BIR Form 1702, also known as the Annual Income Tax Return for Corporations, Trusts, Estates, and Joint Ventures. This article will focus on the RT version of 2018 and provide guidance on how to file it using Excel format.
What is BIR Form 1702?
BIR Form 1702 is a tax return form used by corporations, trusts, estates, and joint ventures to report their annual income and compute their income tax liability. The form is used to declare the taxpayer's gross income, deductions, and credits, as well as compute the net taxable income and income tax due.
RT Version 2018
The RT version of 2018 refers to the revised version of BIR Form 1702, which was released by the BIR in 2018. This version is used for reporting income earned from January 1 to December 31 of the same year.
Filing BIR Form 1702 RT Version 2018 in Excel Format
The BIR provides an Excel template for BIR Form 1702 RT Version 2018, which can be downloaded from the BIR website or other authorized sources. Using this template, taxpayers can easily fill out and compute the necessary information for their tax return.
Benefits of Filing in Excel Format
Filing BIR Form 1702 RT Version 2018 in Excel format offers several benefits, including:
How to Fill Out BIR Form 1702 RT Version 2018 in Excel Format
To fill out BIR Form 1702 RT Version 2018 in Excel format, follow these steps:
Submission and Deadline
Once the BIR Form 1702 RT Version 2018 is completed and validated, it must be submitted to the BIR on or before the deadline. The deadline for filing is typically on or before April 15 of the year following the taxable year.
Conclusion
Filing BIR Form 1702 RT Version 2018 in Excel format is a convenient and efficient way to comply with tax regulations. By following the steps outlined in this article, taxpayers can ensure accuracy and completeness in their tax returns. Note that tax laws and regulations are subject to change, so stay informed and up-to-date on the latest requirements.
Introduction
The Bureau of Internal Revenue (BIR) Form 1702 RT is a crucial document that taxpayers in the Philippines must submit annually. The form is used to report the income tax returns of individuals and businesses. In this review, we'll take a closer look at the 2018 version of BIR Form 1702 RT in Excel format.
Overview of BIR Form 1702 RT
BIR Form 1702 RT is a comprehensive form that requires taxpayers to report their income, deductions, and credits. The form is divided into several sections, including:
Features of the 2018 Excel Format
The 2018 version of BIR Form 1702 RT in Excel format offers several features that make it easier for taxpayers to complete and submit their income tax returns. Some of these features include:
Pros and Cons
Pros:
Cons:
Conclusion
The BIR Form 1702 RT Version 2018 Excel Format is a useful tool for taxpayers in the Philippines. Its automated calculations, easy data entry features, and comprehensive instructions make it easier for taxpayers to complete and submit their income tax returns. However, taxpayers should still exercise caution and seek professional advice if they are unsure about any aspect of the form.
Rating
Based on its features and functionality, I would give the BIR Form 1702 RT Version 2018 Excel Format a rating of 4 out of 5 stars. While it is a useful tool, its complexity and potential version compatibility issues may deter some taxpayers.
Recommendations
The BIR Form 1702-RT (version January 2018) is the Annual Income Tax Return for corporations, partnerships, and other non-individual taxpayers subject only to the Regular Income Tax Rate.
If you are looking for an Excel-based version, several third-party platforms provide fillable templates that mimic the official layout and logic. Key Features of 1702-RT (2018 Version)
The 2018 update (marked as 1702-RTv2018C in eBIRForms) introduced specific structural changes:
Tax Rate Inputs: Unlike previous versions, the automatic computation of tax due is often disabled in the latest offline packages to allow taxpayers to manually indicate the applicable rate (e.g., 25% or 20% under CREATE law adjustments).
Method of Deduction: Supports both Itemized Deductions (requiring details for schedules like salaries, depreciation, and interest) and Optional Standard Deduction (OSD) (fixed at 40% of gross income).
Net Income Reconciliation: Includes Schedule 3 for the reconciliation of net income per books against taxable income, ensuring consistency with audited financial statements.
Validation Logic: Most Excel versions include "check-figures" to ensure that the Total Tax Payable on Page 1 matches the detailed computations on subsequent pages (e.g., Part IV Item 43 must flow to Part II Item 14). Where to Find the Format
While the Bureau of Internal Revenue (BIR) provides the official PDF Version and the eFPS/eBIRForms interactive tool, Excel formats are typically used for internal preparation before final submission:
Online Editors: Platforms like pdfFiller and DocHub offer editable templates that can be exported to various formats.
eFPS Upload: If using the eFPS system, the BIR allows uploading data via specific .xlsx or .xls files that match their database structure. Pro-Tips for Preparation
CAPITAL LETTERS: The BIR requires all information to be entered in all caps using black ink (if printed).
No Centavos: Figures should generally be rounded (49 centavos or less down, 50 or more up).
Cross-Check Schedules: Ensure Schedule 1 (Itemized Deductions) and Schedule 2 (Special Deductions) totals correctly map to the primary tax computation on Page 2. 1702-RT - BIR
Comprehensive Guide to BIR Form 1702-RT (Version 2018) in Excel Format
The BIR Form 1702-RT, or the Annual Income Tax Return for Corporations, Partnerships, and other Non-Individual Taxpayers subject only to the Regular Income Tax Rate, is a critical compliance document for businesses in the Philippines. The January 2018 (ENCS) version introduced significant updates to align with modern tax regulations like the CREATE Act. What is BIR Form 1702-RT?
This form is specifically for non-individual taxpayers who do not have "mixed income" or income subject to special preferential rates (such as PEZA or BOI-registered entities).
Tax Rate: It is generally used by entities subject to the regular corporate income tax rate, which is now 25% (or 20% for certain small businesses) following recent tax reforms.
Filing Frequency: It is an annual return filed once every taxable year. Why Use an Excel Format for Form 1702-RT?
While the Bureau of Internal Revenue (BIR) provides the Offline eBIRForms Package for electronic filing, many accountants prefer an Excel format for preparation because:
Automatic Computation: Excel templates often include built-in formulas for calculating Minimum Corporate Income Tax (MCIT) versus Normal Income Tax.
Data Import: It is easier to copy data from accounting software or trial balances directly into an Excel sheet.
Review and Audit: An Excel file allows for a clear audit trail and easier internal review before the final data is encoded into the eFPS or eBIRForms system. Key Components of the 2018 Version
The 2018 version of Form 1702-RT contains several critical sections that must be filled out accurately: BIR Form 1702-RT - eFPS
To create a feature that supports BIR Form 1702-RT (version June 2018)
in Excel format, you should focus on replicating the specific fields and logical flow required for electronic filing (eFPS/eBIRForms). This form is used by corporations and partnerships subject to the regular income tax rate. Core Data Sections to Include 1702-RT - BIR
The BIR Form 1702-RT (Annual Income Tax Return for Corporations, Partnerships, and Other Non-Individual Taxpayers Subject Only to Regular Income Tax Rate) underwent a significant update in January 2018 to comply with modern tax regulations. Purpose and Scope
Form 1702-RT is specifically for entities earning income subject to the regular corporate income tax rate. This distinguishes it from the 1702-EX (for exempt entities) and 1702-MX (for those with mixed income tax regimes). Key Components of Version 2018
The 2018 version is structured to capture comprehensive financial data across several pages:
Part I: Background Information: Includes TIN, RDO Code, Registered Name, Address, and Date of Incorporation.
Part II: Total Tax Payable: Summarizes the final tax due after applying credits and penalties.
Part IV: Computation of Tax: Detailed breakdown of gross income, sales returns, and cost of services to arrive at taxable income.
Part V: Tax Relief Availment: Used for reporting special allowable deductions or credits.
Schedules: Includes Schedule 1 for itemized deductions, Schedule 3 for Net Operating Loss Carryover (NOLCO), and Schedule 4 for Minimum Corporate Income Tax (MCIT). Filing Methods and Excel/Electronic Formats
While the BIR does not typically provide a standalone "Excel version" for final submission, the data is often managed in spreadsheets before being uploaded or encoded into official systems: 1702-RT - BIR Pro tip: Use Excel data validation (List) for
This is a critical legal question. The BIR occasionally updates forms. However, as of this writing:
👉 Bottom line: Excel templates based on the 2018 version are still legally relevant for preparation, though final submission should use the current eBIRForms package (.dat file).