SQL Accounting Guide: SST Module

In accounting and financial management, mastering the intricacies of SQL queries is essential for unlocking the full potential of specialised modules like the SST (Sales and Service Tax) module. Whether you’re a seasoned SQL developer seeking to enhance your skills or a newcomer eager to delve into the world of accounting data manipulation, this guide is tailored to cater to your needs.

Our comprehensive guide is designed to provide you with a deep dive into the SQL queries associated with the SST module, offering a theoretical understanding, practical insights, and best practices. From extracting and manipulating accounting data to deciphering the intricate relationships between different tables within the SST module, this guide aims to empower you with the knowledge needed to navigate and leverage SQL for your accounting endeavours.

So, whether you’re embarking on a journey to deepen your SQL proficiency or seeking to streamline your accounting practices, join us as we unravel the intricacies of the SST module through the lens of SQL. Let’s dive into SQL Accounting and elevate your capabilities to new heights!

Start SST

sst module in sql

Activate SST

Activating the SST Module in SQL Account is a crucial first step to seamlessly integrate the Sales and Service Tax functionalities into your financial management system. Follow these step-by-step instructions to ensure a smooth activation process:

Step 1: Navigate to the SST Menu

  • Launch SQL Account and locate the “SST” option within the main menu.
  • Click on “Start SST Now” to commence the setup process.

start sst now

Step 2: Select Country.

Choose “Malaysia” as the country for the SST application and click “Next.” It’s important to note that the country selection made during this step cannot be reversed later, so ensure accuracy.

choose a country

Step 3: Set your SST Effective Date & click next.

Specify the accurate SST effective date for your company. Refer to your MySST approval letter for the correct date. While SST2.0 in Malaysia generally began on September 1, 2018, individual company effective dates may vary based on financial year-end dates and other considerations.

set sst effective date

Step 4: Enter Tax Numbers

Provide your Sales Tax Number and Service Tax Number, then click “Next.” In case of any errors, corrections can be made later under “File” > “Company Profile.”

set sales and service tax no

Step 5: Review Auto-Generated Accounts

SQL Account will automatically create essential SST-related accounts. Click “Next” to proceed.

maintain gl account

Step 6: Select Default Tax

Choose your preferred default tax (Sales Tax or Service Tax) and click “Finish.” If Sales Tax is selected, the system will automatically set the default tax code to “ST 10%.” You can modify this later in the “Maintain Tax” section.

set default sales tax

Step 7: Re-login

Click “OK” to re-login to the system.

re logon

Step 8: Verify SST Activation

Upon successful login, you’ll notice a new dropdown list labelled “SST Functions” within the menu. This indicates the completion of the SST setup, and your SQL Account is now ready to utilise the features and functionalities of the SST Module.

completed sst setup

Maintain Tariff

Ensuring accurate and up-to-date tariff codes for your products is essential for proper taxation and compliance. Follow these steps in SQL Account to maintain tariff information:

Step 1: go to Tools | Maintain tariff | New

Access the “Maintain Tariff” feature by going to “Tools” > “Maintain Tariff” > “New.”

  • Insert Product Tariff Code:

In the provided field, insert the specific tariff code applicable to your product. You can obtain this code from the official Malaysian Customs website at http://mysstext.customs.gov.my/tariff/.


Tax Code

SQL Financial Accounting provides a comprehensive list of tax codes to categorise transactions and ensure accurate tax calculations. These codes play a crucial role in defining the tax treatment for various financial activities. Common tax codes in SQL Financial Accounting include, but are not limited to:

tax code

  • ST (Sales Tax): Used to identify transactions subject to Sales Tax.
  • SR (Sales Tax Relief): Applicable when providing relief from Sales Tax.
  • SR0 (Sales Tax Exempt): Indicates exempted transactions from Sales Tax.
  • TX (Taxable): Denotes transactions that are taxable.
  • ES43 (Export Services 4%): Specifies tax treatment for export services at 4%.
  • ZRE (Zero-Rated): Designates transactions subject to a 0% tax rate.
  • NTR (Not Taxable): Used for transactions that are not taxable.

These tax codes play a crucial role in accurately reflecting the tax implications of each financial transaction within the SQL Financial Accounting system.

By diligently maintaining tariff codes and associating them with appropriate tax codes, you ensure compliance with tax regulations and facilitate precise financial reporting within your SQL Account. This meticulous approach to tariff and tax code management contributes to the integrity and accuracy of your overall accounting processes.

SST Return from SST

To ensure compliance with Sales and Services Tax (SST) regulations, it’s crucial to accurately process SST returns in SQL Account. Follow these steps to initiate and complete the SST return process:

Step 1: Process SST Return from SST | New SST Return

Begin by navigating to “SST” and selecting “New SST Return.” This initiates the SST return process.

new sst return

Step 2: Enter Relevant Information

  • 2a: Enter Your Taxable Period

Specify the taxable period for which you are filing the SST return.

  • 2b: Key in Declaration

Input the necessary declaration information. This declaration will appear in SST02 Form Part F. It’s a one-time entry, and subsequent returns will automatically include this information.

  • 2c: Click on Process

After entering the required details, click “Process” to proceed.

process new sst return

Step 3: click on SST-02

Click on “SST-02” to access the relevant forms based on your company’s tax obligations. If your company is subject to both Sales Tax and Service Tax, ensure that you have filled in both Sales Tax Number and Service Tax Number in “File” > “Company Profile.”

(A) SST02 – Sales Tax: This form is for companies subject to Sales Tax.

(B) SST02 – Service Tax: For companies subject to Service Tax.

(C) SST-02 – Sales & Services Tax: This form combines both Sales Tax and Service Tax for internal checking purposes.

(D) Print SST Listing: This report enables you to check and filter information for the selected SST taxable period.

open sst return

company profile

open sales tax return

If your company is subject to both Sales Tax and Service Tax, SQL Account will automatically create separate forms for each during the SST return process. This ensures compliance with the requirement to submit Sales Tax and Service Tax separately.

By following these steps diligently, you streamline the SST return process, adhere to regulatory requirements, and facilitate internal checks for both Sales and Services Tax obligations within SQL Account. Take the next step towards enhanced accounting efficiency and accuracy by choosing A-Plus Computer Software as your SQL accounting software provider.