1702 Rt Version 2018 Excel Format | Bir Form

Here’s a draft content outline and structure for in Excel format . This can be used as a template guide for data entry or automation.

| Line | Description | Amount | |------|-------------|--------| | 9 | Gross sales/revenues/receipts/fees | [input] | | 10 | Less: Sales returns, discounts, allowances | [input] | | 11 | | =L9 - L10 | | 12 | Cost of sales/services | [input] | | 13 | Gross income | =L11 - L12 | | 14 | Add: Other taxable income | [input] | | 15 | Total gross income | =L13 + L14 | | 16 | Less: Deductions (Itemized or OSD) | [input] | | 17 | Taxable income | =L15 - L16 | | 18 | Income tax due (MCIT or RCIT, whichever applies) | [input or formula] | | 19 | Less: Tax credits/payments | | | 20 | - Creditable withholding tax | [input] | | 21 | - Quarterly payments | [input] | | 22 | - Foreign tax credit | [input] | | 23 | Tax payable (refund) | =L18 - SUM(L20:L22) | bir form 1702 rt version 2018 excel format

For tax years after the CREATE Law was enacted, the regular corporate income tax rate was reduced from 30% to 25% or 20% (for certain small businesses). Here’s a draft content outline and structure for

This is the heart of the form. Do not enter centavos. This is the heart of the form

No. The BIR only provides PDF and XML (via eBIRForms). Excel templates are user-created and should be used as worksheets only.

An Excel file preserves your formulas, cell linkages, and notes. This provides your internal accounting team with a clear audit trail during future financial reviews or BIR audits. Core Sections of the Excel Template Explained

Enter all tax credits, including quarters 1 through 3 payments and creditable withholding taxes.