Versions Compared

Version Old Version 2 New Version Current
Changes made by

Jia Pei Chan

Jia Pei Chan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before start reading" GST Setup User Guide", you might need to understand:-

What isDefinitionsRemarks
Real (Category Type)Refer to Assets/ Liability/ Equity

Will be processed for c/f & b/f over next accounting periods

Will NOT be processed for P&L

Temp (Category Type)Refer to Revenue / ExpensesWill be processed during P&L generation

GST Setup

 1.

...

 GL Category

...

Accounting > Maintenance > Configuration > GL Category Maintenance > Create

1.1: GST Output Tax

...

Image Added


1.2: GST Input Tax

 

Image RemovedImage Added


1.3 GST Expenses
Image RemovedImage Added

 

2.GL Code

Accounting > Maintenance > Configuration > Add GL Code

2.1 GL code for Sales Output Tax:  gst_Output

Image RemovedImage Added

2.2 GL Code for Purchase Input Tax: gst_Input

Image RemovedImage Added

2.3 GL Code for Sales Deposit: gst_Output_Suspended

Image RemovedImage Added

2.4: GL Code for Supplier Input Tax Bad Debt Relief: badDebtAP

Image RemovedImage Added

2.5: GL Code for Supplier Input Tax Bad Debt Paid: badDebtAP_Paid
Image RemovedImage Added

 

2.6: GL Code for Sales Output Tax Bad Debt Relief: badDebtAR

 Image RemovedImage Added

2.7: GL Code for Sales Output Tax Bad Debt Recovered: badDebtAR_Recovered

  Image Removed Image Added


2.8 GL Code for GST Expenses (Non-claimable input tax): gst_Expenses

Image Added

 

2.89: GL Code for Imported Goods from Oversea: gst_contra

    Image RemovedImage Added

23.90: GL Code for IRR Adjustment (applicable for Mixed Supply: gst_Control

Image RemovedImage Added

3. Activation for Malaysia GST

 Control Panel > System Admin > EMP configuration > Tax

3.1 General

Image RemovedImage Added

 

3.2: Sales (Output Tax)

  • Updated all information except Branch (Branch activate on 31 March after business hour)

  • Recommendation: Retailer used INCLUSIVE TAX method 

Image Added  

  • Item price include tax rate :  Enable

When issue a tax invoice, the price enter is Amount Inclusive of GST

e.g: Grand Total           RM 1,500.00

       Selling Price           RM 1,415.09

                6%                 RM       84.91

Image Added

  • Item price include tax rate :  Disable

  • Mostly used in Distribution

When issue a tax invoice, the price enter is Amount Exclusive of GST

e.g: RM 1500 (Selling Price)

System Calculation:

Sub Total:     RM 1500

GST 6%:        RM    90

Grand Total: RM  1590

** Appendix

Image Added

3.3: Purchase (Input Tax)

Image Added

...

  • Updated all information except Branch (Branch activate on 31 March after business hour)

Image Removed

 

 

           

 

 

 

  • Item price include tax rate : Disable

When create the GRN, the price enter is Amount Excluding GST (cost price)

(Assuming received TAX Invoice)

e.g: RM 1000

System Calculation:

Sub Total:     RM 1000

GST 6%:        RM     60

Grand Total: RM 1060

~ Notes: 

 

4. Activation GST Code

Accounting > Maintenance > Configuration > List Tax Config

Image Added

  • 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

Image Added

GST Code Description:

Image Added

Image Added

5. Item Maintenance

5.1 Inventory > Item > Add Item

Image Added

5.2 Inventory > Item > Edit Item

Image Added

5.3 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

 

Image Added

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"

Image Added

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

Image Added

 

5. Save file as: CSV (Comma delimited)

Image Added

 

6. Inventory > Item > Upload Item code

Choose File and click "Submit" 

Image Added

Message pop up if upload successfully

Image Added

If information not match, Upload Error List, Column with red background is invalid.

Image Added

 

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

Image Added

Image Added

 

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

Image Added

Image Added

Mandatory Field

Control Panel > System Admin > EMP Configuration > Customer > Customer Account Creation Configurations

Image Added

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 > Company > Edit

Image Added

Image Added

9. Company Tax Year

Accounting > Maintenance > Configuration > Add Tax Year

Image Added

  • If the financial year end on 30 June 2015, the Tax Year set to 2015-04-01 to 2016-06-30

10. Printable Format

Control Panel > System Admin > File Cabinet: upload gst printable jrxml format

Image Added

 

Set Default Printable format

Control Panel > System Admin > Developer > Branch Maintenance > Branch Listing > Edit 

Image Added

List of Format

  1. Simplified Tax Invoice
  2. Tax Invoice
  3. Customer Credit Note
  4. Customer Debit Note
  5. Supplier Debit Note
  6. Supplier Credit Note
  7. GRN
  8. Supplier Invoice
  9. Payment Voucher
  10. Receipt Voucher
  11. Quotation / Job Sheet
  12. Sales Order

11. Item Price Update (for Inclusive GST Method, update 31 March, after business hour)

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

Image Added

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"

Image Added

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

PRICE_LIST: 1272

PRICE_SALE: 1166

Use Formula to add 6% to existing price

  1. Insert 2 column
  2. Use formula “PRICE_LIST”*1.06
  3. Copy the formula column to new column, Paste Special, only Values
  4. Copy header PRICE_LIST
  5. Delete Original PRICE_LIST & formula column
  6. Save file as: CSV (Comma delimited)

Image Added

Image Added

Image Added

Upload the excel file to update the price

Inventory > Item > Upload Item code

Choose File and click "Submit" 

Image Added

12. Activation of GST Branch (31 March after business hour)

 Control Panel > System Admin > EMP configuration > Tax

Image Added

Image Added


EMP Output Tax VS Customer Tax Option Configuration

EMP Output Tax Configuration: Item Price include tax rate : Enable

Customer Maintenance: Tax Option: Exclude Tax

Image Added

13.  Rounding Adjustment (Sales, GRN, SINV and PV transaction)

14. Major Industry Code Configuration

Related:

GST code

https://drive.google.com/open?id=1bhhLHzvq6pOgI4H7lj9fK8ipNjMH-W3F5ANe7GgBk3A&authuser=0

GST Flow

Please download the attachment for reference. 

https://drive.google.com/open?id=1HS-rb8gAyI6sLho_yzbjQY5EVmiXj9gktz6FWafC32Y&authuser=0

GST_outline.pdf

GST briefing.pdf