Bir Form 1702 Rt Version 2018 Excel Format -

After filling in eBIRForms offline, you can export the return data to CSV/XML, then import into Excel. This is not a blank template but a completed return record.

Where to find the official reference PDF:
Visit www.bir.gov.ph → under “Taxes & Forms” → select “Income Tax” → filter by “Form 1702-RT” → choose version “January 2018 (ENCS)”.

| Line | Field | Excel Formula / Instructions | |------|-------|-------------------------------| | 4 | Gross Sales/Receipts/Revenues/Fees | Sum of all taxable revenue (from audited P&L). | | 6 | Total Deductions | Choose: Itemized (line 12A) OR Optional Standard Deduction (40% of line 4). | | 7 | Taxable Income (line 4 – line 6) | =MAX(0, Line4 – Line6) | | 8A | RCIT Due (25% of line 7 – note pre-CREATE rate) | =Line7 * 0.25 | | 8B | MCIT (2% of gross income) – compute if applicable | =GrossIncome * 0.02 | | 9 | Higher Between RCIT and MCIT | =MAX(8A, 8B) | | 10 | Less: Tax Credits (Creditable Withholding Tax from Form 2307) | Sum of all valid CWT. | | 13 | Total Tax Still Due / (Overpayment) | =Line9 – Line10 – Line11 |

Before hunting for the Excel format, let’s decode the form itself. BIR Form 1702-RT is the annual income tax return (ITR) for:

Important note on versioning: The “Version 2018” indicates the BIR’s electronic filing system format (ENCS – Electronic Filing and Payment System Non-Individual). While tax rates may have changed due to the CREATE Act (Republic Act No. 11534), the structure of the return—schedules, line items, and attachments—remains largely based on this 2018 iteration for many filing purposes, especially for those using offline tools.

For the most accurate and updated version of BIR Form 1702-RT in Excel format:

Always ensure you're using the most current version of the form to avoid issues with filing. If you're unsure or need assistance, consulting with a tax professional is advisable.

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

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. bir form 1702 rt version 2018 excel format

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

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. After filling in eBIRForms offline, you can export

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

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.

Subject: 📄 Resource Share: BIR Form 1702-RT (2018 Version) Excel Format

Are you preparing for the filing of your Annual Income Tax Return? 📉

For those handling the Final Adjustment or Consolidated Return for corporations and partnerships, having a workable digital file is essential for efficiency.

I am sharing a copy of BIR Form 1702-RT (Year 2018 Version) in Excel format. This version is useful for: ✅ Drafting and computation: Easier to validate figures with Excel formulas. ✅ Data validation: Checking for discrepancies before filing. ✅ Record keeping: Maintaining a soft copy for your digital archives.

⚠️ Important Reminder: Please ensure that this specific version (2018) is acceptable for your current filing period or if your jurisdiction requires the latest BIR Offline eBIRForms Package. Always double-check with your tax agent or the official BIR website for the most recent updates and deadlines.

🔗 Download Link: [Insert Download Link Here]

Disclaimer: This file is shared for educational and drafting purposes. Always consult a Certified Public Accountant for specific tax advice.

#TaxSeason #BIR #Form1702RT #AccountingPH #TaxResources #ExcelTemplates

The BIR’s eBIRForms application (version 7.9 and later) allows offline filing, but it lacks the real-time formula auditing that Excel provides. An Excel version allows users to:

Because the BIR does not provide an official Excel, you have three options:

Open eBIRForms Offline → Select “1702-RT” → Choose version “2018” (if still available; otherwise, contact BIR for legacy access). Manually encode figures from your Excel.

The BIR regularly updates its forms and requirements. Therefore, always check the BIR website or consult with a tax professional to ensure that your Excel template is compliant with the latest regulations and accurately reflects the current version of BIR Form 1702 RT. | Line | Field | Excel Formula /