Yes, as a supporting schedule, but only if accompanied by the official BIR form (printed from eBIRForms). You cannot submit standalone Excel printouts as the tax return.
| Rule | Excel Implementation | |------|----------------------| | For corporations with gross sales ≤ PHP 10M are subject to 30% RCIT but MCIT applies only if there is gross income. | IF(AND(GrossSales<=10000000, GrossIncome>0), MIN(Line9, Line12), Line9) | | MCIT = 2% of Gross Income (Line 5) | =Line5 * 0.02 | | If MCIT > RCIT, MCIT is payable. | =MAX(RCIT, MCIT) | | Allowable deductions cannot exceed Gross Income. | Data validation: Deductions <= Gross Income | | Tax credits cannot exceed Tax Due. | Conditional formatting alert |
MCIT applies starting on the 4th year of operation. Many Excel templates miss the “4th year” filter. Add a field: “Year of operation” – if less than 4, MCIT = zero.
But remember: the BIR does not accept Excel files as official tax returns. Use your Excel template to compute, validate, and document — then file using the official eBIRForms system.
For amended returns (Line G “Amended” = Yes), Excel should require entry of the original return’s BIR Receipt Date and Reference Number.
Version 2018 mandates 30% RCIT . Never use 25% or 20% (those came later with CREATE Act in 2021). If your tax year covers 2018–2020, it’s 30%.
| 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 |