Bir Form 1702 Rt Version 2018 Excel Format -

| Line | Description | Excel Formula/Macro Reference | |------|-------------|-------------------------------| | 1 | Gross Sales/Revenues | SUM(revenue accounts) | | 2 | Sales discounts/returns | Subtract from line 1 | | 3 | Net Sales/Revenues | =Line 1 – Line 2 | | 4 | Cost of Sales/Services | Direct input or linked | | 5 | Gross Income (L3 – L4) | =L3 – L4 | | 6 | Allowable deductions | Itemized or optional (40% OSD for non-VAT?) | | 7 | Taxable Income (L5 – L6) | =L5 – L6 | | 8 | Rate (30% for Version 2018) | Fixed cell: 0.30 | | 9 | Income Tax Due (L7 x L8) | =L7 * 0.30 | | ... | Less: Credits & Withholding | WT, CWT, Tax Paid in prior quarters | | 18 | | Final output |

The is the Annual Income Tax Return specifically designed for corporations, partnerships, and other non-individual taxpayers whose income is subject only to the Regular Income Tax Rate . While the Bureau of Internal Revenue (BIR) primarily provides this through the Offline eBIRForms Package or eFPS, many taxpayers seek an Excel format to simplify complex financial computations before final submission. Key Features of the 2018 Version bir form 1702 rt version 2018 excel format

Once your Excel version of is complete, you cannot submit the Excel file directly to the BIR. Follow these steps: | Line | Description | Excel Formula/Macro Reference

: Supplementary tables for Itemized Deductions, NOLCO (Net Operating Loss Carry Over), Tax Credits, and the Balance Sheet. Filing and Official Form Access Key Features of the 2018 Version Once your