Bir Form 1702 Rt Version 2018 Excel Format Site

Understanding and Filing BIR Form 1702 RT Version 2018 in Excel Format

1. Computational Accuracy – Formulas automatically compute taxable income, tax due, surcharges, and interest, minimizing manual miscalculations.
2. Audit Trail – Excel allows users to trace cells and see how each figure is derived, aiding internal audits.
3. Data Integration – Data from general ledgers or accounting software can be pasted directly into Excel templates, reducing re-encoding.
4. Customizable Supporting Schedules – Users can add sheets for detailed listing of revenues, expenses, tax credits, and prior year adjustments.
5. Offline Usability – Unlike online eFPS, Excel works offline and can be saved locally for future reference.

Part VII: Certification

• [ ] All line numbers match the official 2018 PDF.
• [ ] RCIT rate = 30%.
• [ ] MCIT computed at 2% of gross income, starting 4th year.
• [ ] Rounding to nearest peso.
• [ ] No submission without eBIRForms.

1. Formulas: Use Excel formulas to automate calculations, especially for totals and summaries.
2. Data Validation: Apply data validation rules to ensure that inputs are within expected ranges or formats (e.g., date formats, numeric formats).

1. Open Excel: Start a new Excel spreadsheet.
2. Form Layout: Design the layout of the form according to the BIR Form 1702 RT (Version 2018). This involves creating rows and columns that match the sections and fields of the form.

BIR Form 1702-RT (version 2018)

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

Firms handling dozens of corporations use an Excel template of Form 1702-RT (Version 2018) to consolidate data before final encoding into eBIRForms or submission via the new eAFS (Electronic Audit Form System). bir form 1702 rt version 2018 excel format