Challenges
Stream has joined the National e-Payment project as a consortium partner. Stream is involved in providing the hardware infrastructure for receiving electronic payments from banks and other data from various parties. Stream develops a system to support e-Payment data from financial institutions (banks) and non-financial institutions (non-banks). The system will help categorize tax types; VAT, income tax and withholding tax for efficient auditing, ultimately leading to better resource allocation for national development.
Our Solution
Stream works intensively with the Revenue Department at the conception stage to design the system and shape the business logic around the data following Thailand’s tax regulations and treaties. We work to understand the tax computation and set the data requirements as well as reconciliation with Banks and other parties. The e-Payment data is then used as the basis for e-WHT and e-VAT for online tax investigations with enriched data. On the other hand, e-TaxInvoice and e-Receipt data is also imported into the database, validated against the ETDA standards, and managed for further tax investigations against e-Payment data. The system must meet the scale, availability, PDPA and security required.
The electronic payment data import system (Managed File Transfer: MFT) will decrypt the data and verify the electronic signature. The system will then send an Acknowledge file and an email summarizing the file transfer results to the data sender and the Revenue Department officials to inform them of the decryption and electronic signature results. The data will be sent to the file type separation process to improve and verify the data at the Electronic Payment Data and Electronic Card Data Extraction-Transform-Load (ETL) system.
The features of the ETL system include:
- Data Validation: The system validates the data and sends a report file and an email summarizing the validation results to the data sender and the Revenue Department officials. Both the data sender and the Revenue Department officials can view the details of each error through the website.
- Reconciliation: Only Cross Border, Domestic, and MT940 data types are sent to the reconciliation process to verify the accuracy of the withholding tax amount. The system sends a reconciliation report and an email summarizing the reconciliation results to the data sender and the Revenue Department officials.
- Data Enhancement: Cross Border, Domestic, and Special data are enhanced with information from the Revenue Department’s internal systems, such as: Taxpayer information from the NID system, VAT registrant information from the VAT system, Audit team information from the ESUP system
- Data Verification: The system verifies the accuracy of the withholding tax (WHT) and value-added tax (VAT) amounts for Cross Border and Domestic data. The system sends an email summary to the Revenue Department officials, and they can also view the data accuracy report through the website.
Key Achievements
The Revenue Department has a more comprehensive tax database, and is able to use the data for analysis, tax administration policy formulation efficiently, fairly and comprehensively.
