Bir Form 1702 Rt Version 2018 Excel Format !!exclusive!! Direct

BIR Form 1702-RT (January 2018 version) is the Annual Income Tax Return specifically designed for

corporations, partnerships, and other non-individual taxpayers in the Philippines that are subject only to the regular income tax rate

. While the official Bureau of Internal Revenue (BIR) format is distributed through the software or the

portal, Excel-based versions are frequently used by accountants for preparation, draft computations, and bulk data organization before final submission. Bureau of Internal Revenue Key Features of the 2018 Version Tax Code Compliance

: Aligned with the TRAIN Law, requiring simplified reporting compared to older versions. Alphanumeric Tax Code (ATC) : Primarily uses for domestic corporations subject to regular income tax. Version 1702-RTv2018C

: An updated sub-version ("C") often found in eBIRForms which disables automatic tax computation

to allow taxpayers to manually input rates (like 20% or 25%) as mandated by the CREATE Act. Method of Deductions : Allows a choice between Itemized Deductions Optional Standard Deduction (OSD) of 40% of gross income. Bureau of Internal Revenue Core Components for Excel Preparation

Excel templates for this form typically mirror the official BIR layout, divided into several critical parts: Part I: Background Information

: Taxpayer Identification Number (TIN), RDO Code, registered name, and address. Part II: Total Tax Payable : Summary of the final tax due and any overpayments. Part IV: Computation of Tax

: Detailed line items for gross income, total deductions, and taxable income. : Includes supporting data such as Schedule 1 (Sales/Revenues), Schedule 4 (MCIT computation), and Schedule 5 (Reconciliation of Net Income). Bureau of Internal Revenue Filing and Submission Requirements 1702-RT - BIR

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

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

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. BIR Form 1702-RT (January 2018 version) is the

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

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. Sheet 1: Taxpayer Information (Page 1) Excel fields

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

Here’s a draft content outline and structure for BIR Form 1702-RT (Version 2018) in Excel format. This can be used as a template guide for data entry or automation.

Sheet 1: Taxpayer Information (Page 1)

Excel fields should include:

• Line A – H: TIN, RDO Code, Business Name, Registered Address, ZIP Code
• Line I – M: Contact info, fiscal year end (MM/DD), taxable year
• Amended Return? Checkbox logic (Yes/No dropdown)

Pro tip: Use Excel data validation (List) for RDO codes and Yes/No fields.

Understanding BIR Form 1702-RT (2018 Version)

BIR Form 1702-RT is filed annually by domestic corporations and partnerships whose gross annual sales or earnings exceed the VAT threshold and are subject to the regular corporate income tax (RCIT) rate of 25% (or 20% for certain qualified entities). The 2018 version reflects amendments brought by the TRAIN Law (Republic Act No. 10963), including adjustments to optional standard deduction (OSD) rates, improvements in allowable deductions, and alignment with the revised withholding tax regulations.

The form consists of several parts: taxpayer information, computation of taxable income, income tax due, tax credits and payments, and summary of tax payable. Filing is done via the BIR’s Electronic Filing and Payment System (eFPS) for mandated taxpayers, or manually with electronic filing (eBIRForms) for others. The official format is a government-issued PDF with embedded calculations.

Formatting Tips for Excel

• Use border grid for readability
• Freeze top rows for header visibility
• Add data validation for dropdowns (e.g., Yes/No, OSD/Itemized)
• Protect formula cells from accidental overwriting
• Use =SUM, =IF, =ROUND for accurate calculations
• Include validation warnings for negative values

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:

• Accuracy: The Excel template helps ensure accuracy in computations and reduces errors in tax returns.
• Convenience: The template is easy to use and allows taxpayers to save time in preparing their tax returns.
• Efficiency: The Excel format enables taxpayers to easily update and revise their tax returns as needed.

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:

1. Download the Excel Template: Obtain the official Excel template for BIR Form 1702 RT Version 2018 from the BIR website or authorized sources.
2. Enter Basic Information: Fill in the taxpayer's basic information, such as name, address, and taxpayer identification number (TIN).
3. Report Income: Report the taxpayer's gross income from various sources, such as business, investments, and other income.
4. Claim Deductions and Credits: Claim allowable deductions and credits, such as operating expenses, depreciation, and tax credits.
5. Compute Tax Liability: Compute the net taxable income and income tax liability based on the information entered.
6. Review and Validate: Review and validate the information entered to ensure accuracy and completeness.

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.

Part 3: Structure of BIR Form 1702-RT (Version 2018) – Line-by-Line in Excel

A well-designed Excel version of Form 1702-RT version 2018 typically includes five major sections, each on a separate worksheet or a continuous grid.