Version 2018 Excel Format | Bir Form 1702 Rt

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

• 2.1. Income Statement (or Profit and Loss Statement) for the period
  • Build in automated tax due calculations (RCIT vs. MCIT – Minimum Corporate Income Tax).
  • Cross-check tax credits against creditable withholding tax (BIR Form 2307).
  • Flag errors before official submission.

  Why an Excel Format?

  The 2018 version requires comprehensive data entry across several key sections: Part I - Background Information bir form 1702 rt version 2018 excel format

  following the close of the taxable year (typically April 15 for calendar year taxpayers). Using Excel for Attachments The BIR provides downloadable Excel Supplemental Forms BIR Form 1702-RT (January 2018 version) is the

  Even with a powerful Excel template, mistakes happen. Avoid these: Build in automated tax due calculations (RCIT vs

  | Error | Consequence | Fix | |-------|-------------|-----| | Using pre-CREATE tax rate (25% instead of 20% for small corps) | Overpayment or underpayment | Update your Excel formula to reference current law. | | MCIT miscalculation – using “net income” instead of “gross income” | Incorrect tax due | MCIT = 2% of Gross Sales/Receipts less returns/discounts. | | Missing schedule of deductions | Penalty for incomplete attachment | Ensure Schedule 1 in Excel is printed/filled. | | Forgetting to convert Excel to eBIRForms .dat | Filing rejection | Never submit .xlsx; always migrate data to eBIRForms. |