The is more than just a spreadsheet—it is a practical solution for accurate tax computation, audit readiness, and stress-free annual filing. While the BIR has moved toward online systems, the flexibility of Excel ensures that small businesses and accounting professionals can maintain control over their numbers without expensive software.
| Cell | Field | What to Enter | |------|-------|----------------| | B1 | Line 1 – Gross Sales/Revenues | Total sales less returns, discounts, and allowances | | B2 | Line 2 – Cost of Sales/Services | Direct costs (inventory, labor, materials) | | B3 | Line 3 – Gross Income (L1 – L2) | Auto-calculated | | B4 | Line 4 – Itemized Deductions | Rent, salaries, utilities, depreciation, taxes, etc. | | B5 | Line 5 – OSD (Optional Standard Deduction) | 40% of Gross Income (L3) – use only if not itemizing | | B6 | Line 6 – Allowable Deductions | Either L4 or L5, whichever applicable | | B7 | Line 7 – Taxable Income (L3 – L6) | Auto-calculated | | B8 | Line 8 – Income Tax Due | L7 × 25% (or 20% if qualified) | bir form 1702 rt version 2018 excel format free
Giao Hàng Tận Nơi
Miễn phí giao hàng toàn quốc, Ship siêu tốc 2h trong nội thành
Hàng Chính Hãng 100%
Cam kết sản phẩm chính hãng, hàng tuyển chọn, chất lượng cao
Siêu Tiết Kiệm
Giá Rẻ Nhất cùng nhiều Ưu Đãi lớn khi mua sản phẩm
Thanh toán dễ dàng
Hỗ trợ các hình thức thanh toán: Tiền mặt, Chuyển Khoản, Quẹt Thẻ
