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
Filing your BIR Form 1702-RT (Annual Income Tax Return) can be simplified by using an Excel format for data preparation before encoding it into the eBIRForms or eFPS systems. This form is specifically for corporations, partnerships, and non-individual taxpayers subject only to the regular income tax rate. Guide to BIR Form 1702-RT (v2018)
The January 2018 (ENCS) version of Form 1702-RT includes several schedules and parts that require precise data entry. While the official BIR website provides PDF versions, many taxpayers use Excel templates to automate calculations like Cost of Sales and NOLCO. Key Components of the 2018 Version
Part I: Background Information (TIN, RDO Code, Registered Name).
Part II: Total Tax Payable (Summary of tax due and penalties).
Part IV: Computation of Tax (Where you input Gross Income and Deductions). Schedules: Schedule I: Ordinary Allowable Itemized Deductions. Schedule III: Net Operating Loss Carry Over (NOLCO).
Schedule V: Reconciliation of Net Income per Books against Taxable Income. How to Use Excel for Filing
Download a Template: Use a trusted source or create your own based on the official 1702-RT PDF.
Prepare Your Data: Encode your trial balance into the Excel sheet.
Automate Calculations: Ensure your Excel formulas for Gross Income (Sales minus Cost of Sales) and Taxable Income match BIR's logic.
Encoding: Once your Excel figures are ready, open the Offline eBIRForms Package and select "1702-RT version 2018".
Validation: Manually copy the figures from Excel to the software. Click "Validate" to check for errors.
💡 Pro Tip: Always double-check your Alphanumeric Tax Code (ATC). For most regular corporations, this is IC 055. Important Deadlines & Requirements
Filing Date: 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).
Attachments: You must submit the Audited Financial Statements (AFS) and the Summary Alphalist of Withholding Agents (SAWT) via the BIR eAFS system. If you'd like, I can help you with: A detailed list of account titles for Schedule I Explaining how the CREATE Law affects your tax rate Steps for submitting attachments via eAFS Which part of the 1702-RT process should we focus on next?
AI responses may include mistakes. For financial advice, consult a professional. Learn more bir form 1702 rt version 2018 excel format
The BIR Form 1702-RT (January 2018 version) is the Annual Income Tax Return for corporations, partnerships, and other non-individual taxpayers subject only to the regular income tax rate. While the Bureau of Internal Revenue (BIR) primarily provides this form via eBIRForms or the eFPS portal, many taxpayers use Excel-based templates for easier data preparation before final encoding. Where to Access the Form
Official Digital Form: The BIR highly encourages using the Offline eBIRForms Package (version 7.9.5 or newer) to ensure automatic calculations and data validation. You can select "1702-RT version 2018" within the software.
Excel Formats: 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.
PDF Reference: A permanent PDF copy for manual review can be found on the BIR Official CDN. Key Sections of Form 1702-RT
When preparing your data in Excel, organize your spreadsheets to match these primary parts: 1702-RT - BIR
* Number. * Date (MM/DD/YYYY) * Amount. * 23 Cash/Bank Debit Memo. * 24 Check. * 25 Tax Debit Memo. * 26 Others (specify below) Bureau of Internal Revenue
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. Introduction The Bureau of Internal Revenue (BIR) Form
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."
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. Section 1: Taxpayer Information Section 2: Income Section
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.
I’m not sure what you mean by “full essay for BIR Form 1702 RT version 2018 Excel format.” I will assume you want a complete, explanatory guide (an essay-style walkthrough) describing how to fill out BIR Form 1702-RT (2018 version) in Excel, including line-by-line explanations, common pitfalls, and worked examples. I’ll produce that. If you meant something else (a filled sample return, template, or legal tax advice), tell me and I’ll adjust.
Do you want:
Pick one of 1–4 or say “proceed with 1” and I’ll produce the essay now.
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
I understand you're looking for a complete essay related to the BIR Form 1702-RT (Version 2018) Excel format. However, the phrasing of your request seems to blend two distinct concepts: (1) the legal/tax compliance aspects of the form itself, and (2) its technical implementation in Excel.
Below is a structured, informative essay that addresses the purpose, legal context, and practical considerations of using an Excel-based format for BIR Form 1702-RT (2018 version) in the Philippines.
For returns with attachments (audited FS, schedules), you must compress (zip) the .dat file and all attachments, then upload to the eAFS portal.
To safely leverage Excel, tax professionals should:
=SUM, =IF, =ROUND for accurate calculationsComprehensive 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
You are looking for the full content of BIR Form 1702-RT, version 2018, in Excel format. BIR Form 1702-RT is a Philippine tax form used for the annual income tax return for corporations, partnerships, and other entities.
Below, I will provide you with the general details that are typically included in BIR Form 1702-RT. Note that this is not the official Excel format but a description of the sections and information usually required. For the exact official Excel format, you should visit the official website of the Bureau of Internal Revenue (BIR) Philippines or consult with a tax professional.