GST Setup
1.GL Category
Accounting > Maintenance > Configuration > GL Category Maintenance > Create
1.1: GST Output Tax
1.2: GST Input Tax
1.3 GST Expenses
2.GL Code
Accounting > Maintenance > Configuration > Add GL Code
2.1 GL code for Sales Output Tax: gst_Output
2.2 GL Code for Purchase Input Tax: gst_Input
2.3 GL Code for Sales Deposit: gst_Output_Suspended
2.4: GL Code for Supplier Input Tax Bad Debt Relief: badDebtAP
2.5: GL Code for Supplier Input Tax Bad Debt Paid: badDebtAP_Paid
2.6: GL Code for Sales Output Tax Bad Debt Relief: badDebtAR
2.7: GL Code for Sales Output Tax Bad Debt Recovered: badDebtAR_Recovered
2.8: GL Code for Imported Goods from Oversea: gst_contra
2.9: GL Code for IRR Adjustment (applicable for Mixed Supply: gst_Control
3. Activation for Malaysia GST
Control Panel > System Admin > EMP configuration > Tax
3.1 General
3.2: Sales (Output Tax)
Updated all information except Branch (Branch activate on 31 March after business hour)
Item price include tax rate : Enable
When issue a tax invoice, the price enter is Amount Inclusive of GST
e.g: Grand Total RM 1376.94
Selling Price RM 1299
6% RM 77.94
*Please refer to Appendix for Excluded method
3.3: Purchase (Input Tax)
Updated all information except Branch (Branch activate on 31 March after business hour)
Item price include tax rate : Disable
When create the GRN, the price enter is Amount Excluding GST (cost price)
e.g: RM 1000
System Calculation:
Sub Total: RM 1000
GST 6%: RM 60
Grand Total: RM 1060
*Please refer to Appendix for Included method
4. Activation GST Code
Accounting > Maintenance > Configuration > List Tax Config
Click Edit to Inactive un-used tax code
e.g: TX-RE, IS, DS-ISRV, TX-E43, ES43, TX-N43, ESN43, ATMS, ISRV, RS. FR
GST Code Description:
5. Item Maintenance
Inventory > Item Add Item
Inventory > Item > Edit Item
Export Item and Import Method
Inventory > Item > Item Listing
1.Click "Generate Report Now" to get all item listing
Notes: Can filter by Category 1 to 10; Status: Active, Inactive
2. Click "Export Data"
3. Select Source Fields: ITEM_CODE, NAME, STATUS, ITEM_TYPE1, SERIALIZED, TAX_OPTION, TAX_RATE, TAX_CODE, TAX_TYPE, TAX_RATE_OUTPUT, TAX_CODE_OUTPUT, TAX_TYPE_OUTPUT then click Add to Target Fields, click "Export"
4. Update field information:
TAX_OPTION: ENABLED
TAX_RATE: 6 or 0
TAX_CODE: TX,NR,IM,IS,BL,ZP,EP,OP,TX-E43,TX-N43,TX-RE,GP,ATMS,ISRV,AJP
TAX_TYPE: GST-MY INPUT
TAX_RATE_OUTPUT: 6 or 0
TAX_CODE_OUTPUT: SR,ZRL,ZRE,DS,DS-ISRV,OS,ES,ES43,ESN43,RS,GS,AJS
TA X_TYPE_OUTPUT: GST-MY OUTPUT
5. Save file as: CSV (Comma delimited)
6. Inventory > Item > Upload Item code
Choose File and click "Submit"
Message pop up if upload successfully
If information not match, Upload Error List, Column with red background is invalid.
6. Supplier Maintenance
Supplier > Maintenance > Create Supplier
Supplier > Maintenance > Edit Supplier
- GL Code: accPayable used for Trade Supplier
- GL Code: otherPayable used for Non-Trade Supplier
- This section is optional. Only set this for suppliers with special GST Tax Rate / Code (e.g: NR, IM, BL, OP, GP, ZP)
- The Tax Code set here will take precedence over the Tax Code set in EMP Configuration-Tax and Item Maintenance
7. Customer Maintenance
- This section is optional. Only set this for customers with special GST Tax Rate / Code (e.g: DS, OS, GS, ZRL, ZRE)
- The Tax Code set here will take precedence over the Tax Code set in EMP Configuration and Item
Mandatory Field
Control Panel > System Admin > EMP Configuration > Customer > Customer Account Creation Configurations
NOTES
If no tax code is set for supplier /customer, it should follow the tax_code set at item level. However, Item level have 2 different tax_code and tax_code_output for purchase and sales side.
So, if the page is for purchase txn, it should select tax_code, and if the page is for sales txn, it should select tax_code_output.
Then again, if neither is available, it should follow branch level tax_code. Lastly if even that is not available, it should be assigned to blank
8. Company GST ID
Control Panel > Developer > Organization Structure > Edit
