An Excel tax planning workbook for Thai online sellers, freelancers, and small business owners who want to estimate personal income tax before filing season. It brings annual income, documented expenses, allowances, progressive tax brackets, tax credits, and VAT threshold alerts into one practical workbook.
What is included
- Annual tax dashboard showing total income, deduction used, net taxable income, estimated tax due, and VAT status
- Monthly income log separated by online sales 40(8), freelance/service income 40(2), professional/consulting income 40(6), other income, and annual totals
- Actual expense tracker for cost of goods, platform fees, ads, packaging, shipping subsidy, software, travel, office supplies, and payment fees
- Allowance worksheet for personal, spouse, children, social security, insurance, funds, home loan interest, donations, and other editable items
- Progressive tax bracket sheet showing taxed amount, rate, tax per bracket, and cumulative tax
- Built-in guide explaining how to fill the workbook and what evidence to keep before filing
Why it matters
- Online sellers often receive income from multiple channels such as Shopee, Lazada, TikTok Shop, Facebook, LINE OA, and websites. A clean yearly log makes tax planning easier.
- Freelancers often have multiple withholding tax certificates. This workbook helps combine tax credits and estimate whether more tax should be prepared.
- Comparing standard deduction and actual documented expenses helps users understand what records should be kept throughout the year.
- The VAT threshold alert helps growing sellers notice when annual revenue approaches the 1.8 million baht review point.
Best for
- Online sellers selling across multiple marketplaces
- Freelancers with several clients and withholding tax records
- Small shops that want a cleaner view of cost, ads, shipping, and yearly profit planning
- Users who want a structured workbook before filing by themselves or discussing numbers with an accountant
How to use
Disclaimer: This workbook is for planning and estimation only. It is not tax advice and does not replace official tax filing forms. Tax rules and allowance caps may change, so users should verify current information or consult a professional before filing.
- Fill monthly income by category
- Enter only documented work-related expenses
- Add eligible allowances and tax credits
- Review the dashboard for net taxable income, estimated tax due, and VAT status
- Keep the workbook as a yearly tax planning file or share it with an accountant for review