Bir Form 1702 Rt Version 2018 Excel Format Free [new] Direct
I understand you're looking for BIR Form 1702-RT (version 2018) in Excel format for free. However, I must provide an important clarification:
I cannot directly provide or link to downloadable Excel files. What I can do is guide you on where and how to find it legally and safely.
Part 9: Download Links – BIR Form 1702-RT Version 2018 Excel Format Free
Due to the nature of the web, direct download links change frequently. As of this writing, here are stable sources:
- JuanTax Official Drive – Visit juan.tax/free-excel-templates (look for "1702-RT 2018")
- Google Drive Public Template – Search:
1702-RT 2018 FINAL (with formulas).xlsx – Ensure file owner is a CPA or known tax blogger.
- Microsoft OneDrive – Some Filipino Excel developers share read-only versions.
🔒 Security Tip: Always virus-scan any downloaded Excel file using Windows Defender or VirusTotal before opening. bir form 1702 rt version 2018 excel format free
Step 6: Determine Payment
- Still payable (positive number) or Overpayment (negative).
- Overpayments can be refunded or carried over to next year.
Q2: Can I email the Excel file to the BIR?
A: No. The BIR does not accept Excel files via email. You must file through eFPS, eBIRForms, or over-the-counter with a printed copy.
Accessing the Form:
- BIR Website: The official BIR website (https://www.bir.gov.ph/) is a primary resource where you can find and download the latest versions of BIR forms, including instructions on how to fill them out.
- Tax Software Providers: There are also third-party software and templates available that offer editable BIR forms, including Form 1702 RT. However, ensure these are from reputable sources.
When looking for a "free" version, caution should be exercised to ensure that the source is legitimate and that the form is the official version recognized by the BIR. Using unofficial or outdated forms can lead to issues with tax compliance and potential penalties. Always verify the authenticity and relevance of any tax form or template before use.
Key Feature Functionalities:
1. Version-Specific Template Engine
- Description: The system maintains a library of historical BIR form versions. It specifically loads the exact schema, tax rates, and field validations used for the 2018 tax year, ensuring that calculations for Gross Income, Taxable Income, and Tax Due follow the laws applicable to that period (e.g., correct implementation of the Tax Reform for Acceleration and Inclusion or TRAIN Law provisions for that specific transition year).
- Benefit: Eliminates the risk of using current-year formulas on past-due or amended returns for older tax years.
2. Excel-First Output (Offline Editing)
- Description: Unlike the standard BIR Offline eBIRForms package (which uses a specific Java-based viewer), this feature exports the form data into a native Microsoft Excel spreadsheet.
- Formatting: The Excel file is pre-formatted to match the visual layout of the official PDF. It includes locked cells for automatic calculations and unlocked cells for data entry.
- Benefit: Allows accountants and tax filers to work within Excel (using formulas, copy-paste functions, and macros) to populate data quickly without needing the eBIRForms software environment.
3. Auto-Validation Engine
- Description: Before finalizing the export, the system runs an internal check:
- Validates Tax Identification Numbers (TIN).
- Checks for mathematical consistency between "Gross Sales/Receipts" and "Cost of Services/Goods."
- Flags empty mandatory fields required by the 2018 Revised Corporation Code.
- Benefit: Reduces the "validation errors" often encountered when manually filling out offline forms.
4. Print-to-PDF Compliance Layer
- Description: While the primary output is Excel, the feature includes a "Convert to Print-Ready PDF" button. This formats the Excel data to fit perfectly onto the legal-sized paper layout required by the BIR, ensuring the QR codes (if generated externally) or barcodes are positioned correctly.
- Benefit: Ensures that the digital convenience of Excel does not compromise the physical submission requirements.
5. "Free Tier" Accessibility
- Description: Based on the user's search intent, this feature is designed as a Freemium tool. Users can generate a blank 2018 template for free or fill it out for free, with payment only required for advanced features like direct e-filing integration or bulk generation.
- Benefit: Directly answers the user's intent for a "free" resource while offering a better user experience than a simple raw file download.
Page 1 – Basic Information & Tax Computation
| Cell | Field | What to Enter |
|------|-------|----------------|
| B1 | Line 1 – Gross Sales/Revenues | Total sales less returns, discounts, and allowances |
| B2 | Line 2 – Cost of Sales/Services | Direct costs (inventory, labor, materials) |
| B3 | Line 3 – Gross Income (L1 – L2) | Auto-calculated |
| B4 | Line 4 – Itemized Deductions | Rent, salaries, utilities, depreciation, taxes, etc. |
| B5 | Line 5 – OSD (Optional Standard Deduction) | 40% of Gross Income (L3) – use only if not itemizing |
| B6 | Line 6 – Allowable Deductions | Either L4 or L5, whichever applicable |
| B7 | Line 7 – Taxable Income (L3 – L6) | Auto-calculated |
| B8 | Line 8 – Income Tax Due | L7 × 25% (or 20% if qualified) |
✅ Suggested Features for an Excel-based BIR Form 1702-RT (v2018)
6. Optional Extras
- Year selector (with 2018 as default, but adaptable for later years)
- Dropdown for Itemized vs OSD (40% limit auto-applied)
- Auto-computation of MCIT (if applicable, though 1702-RT focuses on regular rate)
If you want, I can also provide you with a template structure in CSV or markdown table format that you can copy into Excel, along with the exact cell formulas for each line of BIR Form 1702-RT (2018 version). Just let me know. I understand you're looking for BIR Form 1702-RT