GST Setup
...
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 GST Expenses (Non-claimable input tax): gst_Expenses
2.9: GL Code for Imported Goods from Oversea: gst_contra
3.0: 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)
- Recommendation: Retailer used INCLUSIVE TAX method
Item price include tax rate : Enable
...
6% RM 84.91
Item price include tax rate : Disable
Mostly used in Distribution
...
Grand Total: RM 1590
** Appendix
3.3: Purchase (Input Tax)
Updated all information except Branch (Branch activate on 31 March after business hour)
...
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
5.1 Inventory > Item > Add Item
5.2 Inventory > Item > Edit Item
5.3 Export Item and Import Method
...
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, GLCODE, 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
...
- 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.
...
Control Panel > Developer > Organization Structure > Company > Edit
9. Company Tax Year
Accounting > Maintenance > Configuration > Add Tax Year
- If the financial year end on 30 June 2015, the Tax Year set to 2015-04-01 to 2016-06-30
...
Control Panel > System Admin > File Cabinet: upload gst printable jrxml format
Set Default Printable format
Control Panel > System Admin > Developer > Branch Maintenance > Branch Listing > Edit
List of Format
...
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, GLCODE, TAX_OPTION, TAX_RATE, TAX_CODE, TAX_TYPE, TAX_RATE_OUTPUT, TAX_CODE_OUTPUT, TAX_TYPE_OUTPUT, PRICE_LIST, PRICE_SALE, PRICE_DISC1, PRICE_DISC2, PRICE_DISC3 then click add 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
...
- Insert 2 column
- Use formula “PRICE_LIST”*1.06
- Copy the formula column to new column, Paste Special, only Values
- Copy header PRICE_LIST
- Delete Original PRICE_LIST & formula column
- Save file as: CSV (Comma delimited)
Upload the excel file to update the price
...
Choose File and click "Submit"
12. Activation of GST Branch (31 March after business hour)
Control Panel > System Admin > EMP configuration > Tax
EMP Output Tax VS Customer Tax Option Configuration
...
Customer Maintenance: Tax Option: Exclude Tax
Please download the attachment for reference.
...