GST Setup User Guide (2015-04-01)

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

What is

Definitions

Remarks

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 / Expenses

Will be processed during P&L generation

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

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

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

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)

(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

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

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, 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

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

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

List of Format

Simplified Tax Invoice
Tax Invoice
Customer Credit Note
Customer Debit Note
Supplier Debit Note
Supplier Credit Note
GRN
Supplier Invoice
Payment Voucher
Receipt Voucher
Quotation / Job Sheet
Sales Order

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

Inventory > Item > Item Listing

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, 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

PRICE_LIST: 1272

PRICE_SALE: 1166

Use Formula to add 6% to existing price