Versions Compared

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.2: GST Input Tax


1.3 GST Expenses

 

2.GL Code

Accounting > Maintenance > Configuration > Add GL Code

...

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

...

Grand Total: RM 1060

~ Notes: 

 

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

5.1 Inventory > Item > Add Item

...

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 Modified

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 Modified

 

5. Save file as: CSV (Comma delimited)

...

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

 

6. Supplier Maintenance

Supplier > Maintenance > Create 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

...

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

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

10. Printable Format

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

 

Set Default Printable format

...

  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 Modified

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

...