: For large taxpayers and those required to use eFPS, the form is filled out directly in a web browser. Excel Upload Option
While the BIR forms calculate totals automatically, seeing the underlying formulas in Excel helps tax practitioners verify that the computations align with the specific provisions of the TRAIN law (e.g., the calculation of the 20% corporate tax rate for certain entities in 2018). bir form 1702 rt version 2018 excel format
| Row | Item | Excel Tip | |-----|------|------------| | 4 | Gross Sales/Revenues | Link to Sales tab | | 7 | Cost of Sales/Services | Link to Inventory schedule | | 10 | Gross Income (Auto-calc) | =Sales - Cost of Sales | | 12 | Allowable Deductions | Itemize per TRAIN | | 17 | Taxable Income (Auto-calc) | =Gross Income - Deductions | : For large taxpayers and those required to
Nowhere – the BIR does not provide official Excel templates. You may create your own or use a trusted third-party template. You may create your own or use a