Malaysia Tourism Tax System (MyTTx)

From eStream Software

Introduction

TTx is a tax charged and levied on a tourist staying at any accommodation premises made available by an operator at the rate fixed by the Minister. It is the duty of the tourist to pay TTx to the operator.
Tourist means any person, whether he is a Malaysian national or otherwise, visiting any place in Malaysia for any of the following purposes, namely:
a) pleasure, recreation or holiday;
b) culture;
c) religion;
d) visiting friends or relatives;
e) sports;
f) business;
g) meetings, conferences, seminars or conventions;
h) studies or research;
i) any other purpose which is not related to an occupation that is remunerated from the place visited.
Accommodation premises means any building, including hostels, hotels, inns, boardinghouses, rest houses and lodging houses, held out by the proprietor, owner or manager, either wholly or partly, as offering lodging or sleeping accommodation to tourists for hire or any other form of reward, whether or not food or drink is also offered.
Therefore, we have designed a database structure specially for business which has provide accommodation to tourists.

Modules Require

  1. SQL Accounting Basic
  2. DIY field
  3. DIY script


See below the overview of MyTTx process flow:
File:01 MyTTx-00.jpg

MyTTx Database

Last Customisation Update : 14 Aug 2017

1. Get the NEW database structure for MyTTx (in backup format) from this link
2. Restore this backup.
3. Enter the user ID and password with “ADMIN” to login.

History New/Updates/Changes

Last Customisation Update :

  • Not available

MyTTx Settings

MyTTx - Maintain Account

[GL | Maintain Account...]

GL Account Description
TTx-201 TTx - Payable


MyTTx - Maintain Stock Group

[Stock | Maintain Stock Group...]

Stock Group Description Costing Method Sales Code Cash Sales Code S.Return Code
TTx TTx Fixed Costing TTx-201 TTx-201 TTx-201
MyTTx-01.jpg


MyTTx - Maintain Stock Item

[Stock | Maintain Stock Item…]

MyTTx-02a.jpg


MyTTx list settings are:
No. Code Description Item Group Base UOM Ref.Price Output Tax Stock Control
1. TTx TTx TTx ROOM/NIGHT 10.00 NS Untick
2. TTxE TTx Exempted TTx ROOM/NIGHT 0.00 NS Untick
NOTE:
1. For GST registered person, output tax must set to NS. 
   NS - Matters to be treated as neither a supply of goods nor a supply of services, and no GST chargeable (0%)
2. For Non-GST registered person, output tax must LEAVE IT BLANK.


Room Settings

Room - Maintain Account

[GL | Maintain Account...]

GL Account Description
500-000 SALES


Room - Maintain Stock Group

[Stock | Maintain Stock Group...]

Stock Group Description Costing Method Sales Code Cash Sales Code S.Return Code
ROOM ROOM Fixed Costing 500-000 500-000 500-000
MyTTx-03.jpg


Room - Maintain Stock Item

[Stock | Maintain Stock Item…]

MyTTx-04a.jpg


Example of the room list settings are:
No. Code Description Item Group Base UOM Ref.Price Output Tax Stock Control
1. ROOM-NORM NORMAL-ROOM CHARGES ROOM ROOM/NIGHT 200.00 Untick
2. ROOM-EXEC EXECUTIVE-ROOM CHARGES ROOM ROOM/NIGHT 400.00 Untick
3. ROOM-DELUX DELUXE-ROOM CHARGES ROOM ROOM/NIGHT 600.00 Untick
NOTE:
For GST or Non-GST registered person, output tax always LEAVE IT BLANK.


Service Charge Settings

Service Charge - Maintain Account

[GL | Maintain Account...]

GL Account Description
500-001 SERVICE CHARGES


Service Charge - Maintain Stock Group

[Stock | Maintain Stock Group...]

Stock Group Description Costing Method Sales Code Cash Sales Code S.Return Code
SERVICE-CHARGE SERVICE CHARGE Fixed Costing 500-001 500-001 500-001
MyTTx-05.jpg


Service Charge - Maintain Stock Item

[Stock | Maintain Stock Item…]

MyTTx-06a.jpg


1. Example of the Service Charge setting:
No. Code Description Item Group Output Tax Stock Control
1. SERVICE-CHARGE Service Charge SERVICE-CHARGE Untick
2. UOM Tab can be use to preset the types of room rate.
No. UOM RATE Ref.Price
1. ROOM-NORM 1.00 200.00
2. ROOM-EXEC 1.00 400.00
3. ROOM-DELUX 1.00 600.00
3. SERVICE SETTINGS
3.1 Tick to confirm this is Service Charge code.
3.2 Enter a service rate %. Example the screenshot below is 10%.
MyTTx-06b.jpg


NOTE:
For GST or Non-GST registered person, output tax always LEAVE IT BLANK.


New Guest Details

[Customer | Maintain Customer...]

1. You can maintain all the guest particular details at Maintain Customer.
2. Record the passport no at company name 2. See the screenshot below.
MyTTx-07.jpg


Record of Tax Invoice / Invoice

[Sales | Invoice...]

MyTTx-08e.jpg
1. Click on New.
2. Select a customer (guest).
3. Select an agent (eg. front desk agent).
4. Enter the room, service charges, date stay, TTx at the details parts.
5. Select the room, service charges and TTx at Item Code column.
MyTTx-08a.jpg
6. Enter the number of rooms to be stay at No of Room column.
MyTTx-08b.jpg
7. For service charges, select the types of the room (eg. room normal or executive) to calculate the service charge % on the room type rate.
MyTTx-08c.jpg
8. Enter the Date Stay.
MyTTx-08c.jpg
9.To confirm the Invoice, click on Save.
10. You can preview/print the Tax Invoice or Invoice.


A. Sample of Tax Invoice (For GST Registered Person)
MyTTx-09a.jpg


B. Sample of Invoice (For Non-GST Registered Person)
File:MyTTx-09b.jpg


Adjustment Using Debit/Credit Note

[Sales | Debit Note...]

[Sales | Credit Note...]


Print TTX-03 form

[Sales | Print Sales Price History...]