Bir Form 1702 Rt Version 2018 Excel Format Guide

There is on the BIR website. However, tax professionals have long created unofficial Excel templates that mirror the exact line items, column headers, and compute tax automatically. These are what most people mean when they search for an "Excel format."

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