A 19-tab .xlsx file with a full year of sample data; 3 printable forms: tax invoice/receipt, 50 Tawi, payment voucher; Monthly VAT and WHT summaries calculated automatically; AR aging, P&L, cash flow and tax calendar

When do I receive it, and how much is it?

It costs ฿1,990. Pay by PromptPay or LoongTeeAi credits; once confirmed, download it from your account page.

เทมเพลต Excel / Google Sheets

SME Accounting, VAT & Withholding Tax System for Excel / Google Sheets (Business System Pro)

A 19-tab .xlsx file with a full year of sample data
3 printable forms: tax invoice/receipt, 50 Tawi, payment voucher
Monthly VAT and WHT summaries calculated automatically
AR aging, P&L, cash flow and tax calendar

฿1,990

Business System Pro

VAT return due soon — do you know how much VAT you owe?

Tax invoices, VAT return, WHT, 50 Tawi, receivables and P&L

For: Small VAT-registered companies and partnerships · Online shops and freelancers who issue tax invoices · Owners who want to see the books before sending them to the accountant

฿1,990

ExcelGoogle Sheets

30-second demo

Problems this file solves

1Tax invoices made in Word with duplicate numbers

2VAT totals not ready at month end

3Forgetting 50 Tawi certificates and losing track of unpaid customers

Q&A with real numbers from the sample file

What are sales and profit this year?Sample data: revenue 6,463,040 baht, expenses 3,178,324 baht, pre-tax profit 3,284,716 baht (50.8%)

How much VAT is payable?Output VAT 452,413, input VAT 127,633, payable 324,780 baht, by month on the P.P.30 tab

How much do customers owe?Receivables 1,281,140 baht, 785,589 overdue, split into 1–30 / 31–60 / 61–90 / 90+ days

Settings you can switch yourself

ชื่อกิจการ

ที่อยู่

เลขประจำตัวผู้เสียภาษี

สาขา

จดทะเบียน VAT

อัตรา VAT

อัตราภาษีเงินได้นิติบุคคล (ประมาณการ)

เงินสด/เงินฝากยกมา

ผู้มีอำนาจลงนาม

What is inside (19 tabs)

What you get

A 19-tab .xlsx file with a full year of sample data
3 printable forms: tax invoice/receipt, 50 Tawi, payment voucher
Monthly VAT and WHT summaries calculated automatically
AR aging, P&L, cash flow and tax calendar
Works in Microsoft Excel and Google Sheets

Get the file in 3 steps

Order and pay by PromptPay or credit
Download the .xlsx file from My Account
Open it in Excel, or upload it to Google Drive and open with Google Sheets, add your business name in Settings and start

FAQ about this system

Does it work in Excel and Google Sheets?Both. Open it in Excel 2016 or later / Microsoft 365, or upload it to Google Drive and open it with Google Sheets

Do I need to be good at Excel?No. Fill in the white cells only; dark cells are formulas, and a 5-step guide is inside the file

Can I change the business name and address on the forms?Yes. Edit them once in Settings and every form updates

How do I clear the sample data?Delete only the white cells on the data tabs; formulas and forms stay in place

How much data can it hold?Up to 2,000 invoices and 3,000 sales lines, tested with full tables and no formula errors

Can I print or save the forms as PDF?Yes. Forms are set up for A4; pick the document number and print or save as PDF

What happens if I type the wrong kind of value?Number and date cells are validated and show a message, and formulas are guarded against error values

Is the tax invoice a proper full-form invoice?It is a full tax invoice with seller and buyer names, addresses, tax IDs and branch, number, date, items and separate VAT

Does it separate P.N.D.3 and P.N.D.53?Yes, by supplier type: individuals go to P.N.D.3 and companies to P.N.D.53, summarised monthly

Can I issue 50 Tawi certificates?Yes. Pick the expense number and the withholding certificate fills with the amount and rate

Can a non-VAT business use it?Yes. Switch "VAT registered" off in Settings and documents skip VAT

Excel / Google Sheets Templates