How to Issue a Withholding Tax Certificate Using Google Spreadsheets for Free
Withholding Tax in Thailand
Content:
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Our services
In Thailand, withholding tax is a common requirement for businesses when they make payments to suppliers, service providers, or contractors. It involves deducting a certain percentage of the payment and remitting it to the Revenue Department on behalf of the recipient.
After making the deduction, the payer must issue a Withholding Tax Certificate (WHT certificate) to the recipient, serving as proof of the tax withheld and submitted. While many businesses use accounting software to issue these certificates, you can also do it efficiently using Google Spreadsheets for free.
Why Use Google Spreadsheets for WHT Certificates?
Google Spreadsheets offers a flexible, cost-effective solution for issuing WHT certificates, especially for small and medium-sized enterprises (SMEs) that may not have access to sophisticated accounting software. Using Google Spreadsheets, you can create a template, manage records, and generate WHT certificates without any additional cost.
Note: The file that we provided is already set up the necessary formula to issue WHT certificate
Step 1: Upload the file in to your google drive
Step 2: Set Up a Withholding Tax Certificate Template
The first step in issuing a WHT certificate using Google Spreadsheets is to setup a template. The template should include all the necessary details that are required for the WHT certificate, such as:
- Your company name
- Your company short capital
- Your company address
- Your company tax ID
Set up these columns in your Google Spreadsheet and format them for clarity. You can use conditional formatting to highlight important fields or errors, such as missing information.
Step 3: Inputting Data into the Template
Once the template is ready, you can start inputting data for each transaction. If you have a list of transactions in another spreadsheet, you can copy and paste them into the template to save time. Make sure to fill in all the necessary fields accurately:
- WHT – Certificate No.: This column will hold the certificate number for the Withholding Tax.
- Payment Date: This column will record the date when the payment was made.
- Supplier Company Name: The name of the company from which services were purchased.
- Supplier Company Address: The address of the supplier company.
- Type of Services Purchased: Describe the type of services your company purchased from the supplier.
- Purchase Amount (Pre VAT): Record the purchase amount before VAT is applied.
- Percentage (Depends on Type of Services): The percentage rate used for withholding, which varies based on the type of service.
- Withholding Amount: This column will calculate the withholding amount based on the purchase amount and the percentage.
Step 4: Creating the Withholding Tax Certificate
Once all the data is entered, you can produce the WHT certificate using the information from your spreadsheet. The WHT certificate number is located in the first column of the “Database” sheet. To issue a WHT certificate:
- Update the WHT certificate number, and all relevant details will automatically adjust, as each certificate corresponds to a single row.
- Press `Ctrl + P`, and change the printer setting to “Save as PDF.”
- Save the file to your preferred location.
Using Google Spreadsheets to issue Withholding Tax Certificates is a practical, cost-effective solution for businesses in Thailand, especially for managing AP expenses. By following these steps, you can easily generate WHT certificates and stay compliant with Thai tax regulations at no extra cost. It’s important to also understand the relevant tax rules. For more details, click the button below.