Bir Form 1702 Rt Version 2018 Excel Format (Firefox)
| Line | Description | Amount |
|------|-------------|--------|
| 24 | Total tax due | =L18 |
| 25 | Less: Total tax credits | =SUM(L20:L22) |
| 26 | Net tax payable | =L24 - L25 |
| 27 | Add: Penalties (Surcharge + Interest + Compromise) | [input] |
| 28 | Total amount payable | =L26 + L27 |
| Field | Entry |
|-------|-------|
| Printed name of signatory | [input] |
| Signature | [input] |
| Title/Position | [input] |
| Date | [input] |
| CPA’s name (if applicable) | [input] |
| TIN of CPA | [input] |
| Date of eFiling | [auto or input] |
For Version 2018 filing (if allowed still, or for amended returns):
Searching for “BIR Form 1702 RT Version 2018 Excel format free download” can lead to scam sites or malware-laden files. Never download Excel templates from unverified blogs or Facebook groups unless you trust the source.
The safe approach:
Q1: Is BIR Form 1702-RT version 2018 available in Excel from the BIR?
No. The BIR only provides PDF and XML (via eBIRForms). Excel templates are user-created and should be used as worksheets only.
Q2: Can I use version 2018 Excel for filing in 2025?
Only if you are filing an amended return for a tax year covered by 2018 rules (e.g., 2018, 2019, 2020, or FY starting in 2020). For current year filing, use the latest BIR form version.
Q3: Will BIR accept Excel printouts as an attachment?
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.
Q4: Can I use Google Sheets instead of Excel?
Functionally yes, as long as formulas mirror Excel. However, Google Sheets may handle rounding and data validation differently. Test thoroughly. Never use it for final filing if offline access is required.
Q5: Where can I find a free, reliable Excel template for 1702-RT version 2018?
Try reputable sources: