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 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
...
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
...
Selling Price RM 1415.09
...
RM 1,500.00
Selling Price RM 1,415.09
6% RM
...
84.91
Item price include tax rate : Disable
Mostly used in Distribution
...
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)
...
- 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
...