UNITEN BUSINESS SCHOOL

SULTAN HAJI AHMAD SHAH CAMPUS

LAB TEST
SEMESTER 2, 2023/2024

PROGRAMME : BACHELOR OF ACCOUNTING (HONS.)

CODE & SUBJECT : AISB333 / ADVANCED ACCOUNTING INFORMATION

SYSTEM
DATE : 4 JUNE 2024

DURATION : 2 HOURS

INSTRUCTIONS TO CANDIDATES:

1. Read the instructions carefully.

2. All transactions need to be posted in SQL Accounting Software.
3. Marks will ONLY be awarded for submitted file during the examination.

ALL THE BEST!!

Name

ID

Section

THIS EXAMINATION BOOKLET CONTAINS 10 PAGES INCLUDING THIS COVER PAGE

 Index

How to turn on Professional Module in SQL Accounting?

Step 1: File | Customize SQL Account Modules

Step 2: Double click on word “PROF” and press OK

Step 3: File | Log on

Step 4: Re-login SQL then you can start your exam

2
Exam for SQL Financial Accounting (Sales & Services Tax)

Assume you are working as an account executive in an electrical products manufacturing company in
Malaysia. This company uses the standard 12 months financial ending 31 December and they are
licensed under the Sales Tax Act 2022. With this act, all the sales are subjected 10% sales tax but certain
products will charge in 5% Sales Tax. This year, accounts department decided to use SQL Financial
Accounting to record and process their accounting transactions

The following details required you to transfer them into the new system. Make sure you had turn on
with Professional Module Set, let’s start!

Part A - Company Details

Database : <Student ID No.>

Company Name : <Student Full Name>
Remark : LAB TEST
Registration Number : 611011-M
Sales Tax No : B16-1808-21030918
Business Nature : Electrical Products Manufacturer
Address : No.1, Jalan Setia Perindustrian, Setia Alam, 40170, Shah Alam,
Selangor.
Phone : 03-7890 1300
Fax : 03-5886 9913
Accounting Year : 01 January 2024 – 31 December 2024

Task
a) Set Financial Period & System Conversion Data
b) Preset your Company Profile & Report Header
c) Start SST effective date on 01 September 2018

3
 Part B – Maintenance

B-1 : Below I the part of account codes of the company, please set up the company chart of
accounts:
Remark: Account code with * is sub account.
A/C Type Account Code Account Description Special
Account Type
Fixed Assets 200-500 Land & Building
Fixed Assets 200-505 Accum Deprn - Land & ?
Building
Fixed Assets 200-600 Machinery
Fixed Assets 200-605 Accum Deprn - Machinery ?
Current Assets 310-100 MayBank* Bank Account
Current Liabilities 431-000 EIS - Staff
Current Liabilities 432-000 PCB - Staff
Non-current Liabilities 490-000 Loan – Car Loan
Sales 500-000 Sales of Finished Goods
Sales 500-100 Sales of Semi-Finished Goods
Sales 500-200 Other Sales
Cost of Goods Sold 610-000 Purchase of Raw Materials
Cost of Goods Sold 610-100 Purchase of Semi-Finished
Goods
Cost of Goods Sold 610-200 Other Purchases
Other Income 540-000 Rental Income
Expenses 909-001 EIS - Employer
Expenses 924-000 Upkeep of Machinery
Appropriation Account 999-000 Drawings

4
B-2: Below is the profile of the customers, please create the following customers’ accounts:

Please create below tariff code & description and assign it accordingly.
Tariff Code 8517623000
Tariff Description : ELECTRICAL APPAATUS FOR SWITCHING OR PROTECTING ELECTRICAL CIRCUIT *

Customer code may follow the code generated by system.

Company Details Agent Credit Tariff Code

Terms & Tax Code
ARB International Sdn. Bhd. Yin Yee 30 Days
Setia City Mall, Persiaran Setia Dagang,
Setia Alam, 40170, Shah Alam, Selangor.
Attn : Miss Grace Ng
Tel : 03-3375 8677
Samsang Electronics (M) Sdn. Bhd. Gabriel 60 Days Tariff Code:
Lot 58, Lebuhraya Pintas Selat Klang, 8517623000
Industrial Park, 42000, Pelabuhan Klang, Selangor. Tax Code:
Attn : Mr. Leon SEC5
Tel : 03-3716 1078
Tax Exemption No. : B10-1809-56734987
Expiry Date : 31 May 2025
HengSen Electric (Langkawi) Sdn. Gabriel 30 Days Tax Code:
Bhd. Lot 177, Jalan Kelibang Kuah, SE
07000 Langkawi.
Attn : Mr. Desmond Lee
Tel : 04-966 5232

B-3: Below is the profile of the suppliers, please create the following suppliers’ accounts:

Please create below tariff code & description and assign it accordingly.
Tariff Code : 7407210000
Tariff Description : COPPER WIRE *

Supplier code may follow the code generated by system.

Company Details Agent Credit Tariff Code &
Terms Tax Code
SP Internatial Sdn. Bhd. Gabriel 30 Days Tariff Code:
183, Jalan Orkid, 8517623000
Bukit Sentosa, 48300, Tax Code:
Serendah, Selangor. PEC5
Attn : Mr. Suvannam
Tel : 03-6022 2078 Tariff Code:
Tax Exemption No: B10-1809-27300376 7407210000
Expiry Date: 31 August 2025 Tax Code:
PEC1
* Please set default tax code as PST (Purchase Sales
Tax 10%).

5
 Eco Iron Sdn. Bhd. Yin 30 Days Tariff Code:
17-5, Jalan Munduk Tengah, Yee 7407210000
46000 Petaling Jaya, Selangor. Tax Code:
Attn : Ms. Yanni PEC1
Tel : 03-3117 1286
Tax Exemption No: B10-1809-23423455
Expiry Date: 31 August 2024

* Please set default tax code as PST (Purchase Sales

Tax 10%).

VYY Sdn. Bhd. Yin 30 Days

13, Jalan Sentosa Jaya 8, Yee
Taman Sentosa, 80150
Johor Bahru, Johor.
Attn : Mr. Shamsul
Tel : 07-207 0875

New Era Sdn. Bhd. Gabriel 30 Days Tax Code:

No. 8, Jalan LGSB 1/3, Pusat Komersial LGSB, PST
Jalan Hospital, 47000 Sungai Buloh, Selangor.
Attn : Ms. Janice
Tel : 03-6151 3632

B-4: Below is the stock group for your stock, please create the following stock group:
Code Description Costing Sales Cash S.Retur Purchase Cash P.Return
Method Code Sales n Code Code Purchase Code
Code Code
RM Raw FIFO 500-200 500-200 510-000 610-000 610-000 612-000
Materials
SF Semi-finished FIFO 500-100 500-100 510-000 610-100 610-100 612-000
Goods
FG Finished Weighted 500-000 500-000 510-000 610-200 610-200 612-000
Goods Average

B-5: Below is the stock in your company, please create the following stock item:
Remarks : the opening stock quantity cost is same as the reference cost.

Description of Tariff Code:

8516310000 – HAIR DRYER
8451400000 – WASHING MACHINE
841410000 – VACUUM CLEANERS

Item Code Item Stock Group UOM Ref Ref Opening Tariff Code
Description Cost Price Stock Qty
Wire Copper Wire Raw M 0.20 0.25 985 7407210000
Materials
Switching Switching Semi- Unit 7.50 9.50 250 8517623000
Mechanisms Mechanisms finished
Goods
6
 Supersonoc Supersonoc Finished Unit 999.00 1699.00 250 8516310000
Hair Dryer Goods
Inverter 15KG Inverter Finished Unit 750.00 1099.00 125 8451400000
Washing Goods
Machine
Cylinder Cylinder V7 Finished Unit 2099.00 2699.00 78 841410000
Fluffy Goods

Part C – Maintenance of Opening Balance

C1: Below is the opening balance for the customers:

Code Company Name Doc No Doc Date Amount
(RM)
300-A0001 ARB International Sdn. Bhd. AR-0001 31/12/2023 69,000
300-H0001 HengSen Electric (Langkawi) AR-0002 31/12/2023 45,800
Sdn. Bhd.
300-S0001 SamSang Electronics (M) Sdn. AR-0003 31/12/2023 43,000
Bhd.

C2: Below is the opening balance for the suppliers:

Code Company Name Invoice No Date Amount
(RM)
400-E0001 Eco Iron Sdn. Bhd. AP-0001 31/12/2023 79,000
400-S0001 SP Internatial Sdn. Bhd. AP-0002 31/12/2023 65,000
400-V0001 VYY Sdn. Bhd. AP-0003 31/12/2023 36,000

C3 Following are the GL Accounts’ Opening Balances:

Code Description Local DR Local CR
200-200 Furniture & Fittings 250,000
200-205 Accum Deprn – Furniture & Fittings 37,500
200-300 Office Equipment 350,000
200-305 Accum. Deprn – Office Equipment 52,500
200-400 Motor Vehicle 248,000
200-405 Accum. Deprn – Motor Vehicle 24,800
200-500 Land & Building 1,500,000
200-505 Accum. Deprn – Land & Building 450,000
200-600 Machinery 985,000
200-605 Accum. Deprn – Machinery 295,500
300-A0001 ARB International Sdn. Bhd. 69,000
300-H0001 HengSen Electric (Langkawi) Sdn. Bhd. 45,800
300-S0001 SamSang Electronics (M) Sdn. Bhd. 43,000
310-100 Maybank 398,540
7
 320-000 Cash In Hand 2,500
330-000 Stock 509,294
400-E0001 Eco Iron Sdn. Bhd. 79,000
400-S0001 SP International Sdn. Bhd. 65,000
400-V0001 VYY Sdn. Bhd. 36,000
410-070 Electricity Accrued 5,800
410-080 Water Accrued 250
100-000 Equity 1,250,000
150-000 Retained Earning 2,019,784
490-000 Loan – Car Loan 85,000

Part D – Transactions

D-1 Below is the order from purchasing department, please record in the purchase order:
Date DocNo Supplier Description
02/01/2024 PO- Eco Iron Sdn. Bhd. 80,000 m of Copper Wire @ RM0.20
00001
03/01/2024 PO- SP Internatial Sdn 1,200 units of Switching Mechanisms @
00002 Bhd RM7.50
12,000 m of Copper Wire @ RM0.25
05/01/2024 PO- VYY Sdn. Bhd. 1,800 units of Switching Mechanisms @
00003 RM8.00
05/01/2024 PO- New Era Sdn. Bhd. 500 units of Switching Mechanisms @ RM7.00
00004

D-2 Company received the inquiry from HengSen Electric (Langkawi) Sdn. Bhd., please issue the
quotation
Date DocNo Customer Description
08/01/2024 QT- HengSen Electric 20 units of Supersonoc Hair Dryer @
00001 (Langkawi) Sdn. RM1,699.00 with Discount 5%
Bhd. 30 units of 15kg Inverter WashingMachine @
RM1,099.00 with Discount 5%
15 units of Cylinder V7 Fluffy @ RM2,699.00
with Discount 5%+5%

D-3 On 6 January 2024, you received the payment of RM45,000 thru cheque (Cheque no:
CIMB2234) from customer ARB International Sdn. Bhd and the company deposited to Maybank.
Please record it in the system.

8
D-4 On 8 January 2024, company received the purchase order from their customers. Please record it
under Sales Order:
Date DocNo Customer Description
08/01/2024 SO- ARB 25 units of Cylinder V7 Fluffy @ RM2,699.00
00001 International 40 units of Supersonoc Hair Dryer @ RM1,699.00
Sdn. Bhd.
08/01/2024 SO- SamSang 200 units of Switching Mechanisms @ RM9.50
00002 Electronics (M)
Sdn. Bhd.

D-5 On 10 January 2024, employee Liew Kien Cheong passed a claim form to Account Department
to Accountant Department, please record this transaction under Cash Book Payment Voucher:

Description: Petrol & Toll Claim from Liew Kien Cheong

Debit 916-000 Toll, Parking& Fined RM35.00
Debit 919-000 Petrol RM120.00
Credit 320-000 Cash in Hand RM155.00

D-6 On 11 January 2024, customer ARB International Sdn. Bhd. requested to deliver the order of
SO-00001at the same day. Please issue the delivery order to their warehouse:
Date Doc No From Doc No Description
11/01/2024 DO-00001 SO-00001 25 units of Cylinder V7 Fluffy @ RM2,699.00 with
Discount 5%
40 units of Supersonoc Hair Dryer @ RM1,699.00 with
Discount 5%

D-7 On 11 January 2024, Maybank called up to inform about the cheque received from ARB
International Sdn. Bhd. on 6 January 2024 was bounced due to missing of signature. After
communicated with ARB International Sdn. Bhd., they made a payment through direct transfer
to your company’s Maybank account again. Please refer below proof of transfer slip and record
it under Customer Payment.

D-8 Please record the drawings of Maybank under Journal Entry.

Description : Withdrawal from Bank (15 January 2024)
Debit 320-000 Cash in Hand RM6,000
Credit 310-100 Maybank RM6,000

9
D-9 On 16 January 2024, account department arranged the payment for last month utility bills.
Please record the transactions under Cash Book Payment Voucher:

Description: Payment of Utility Bills for Jan 2024

Debit Water Accrued RM250
Debit Electricity Accrued RM5,800
Credit Cash in Hand RM6,050

D-10 Please record the one of employees’ salaries transactions under Payment Voucher.

Description: Salaries of January 2024, Date : 30/01/2024

Debit 904-000 Salaries RM4,000.00
Credit 420-000 EPF-Staff RM520.00
Credit 430-000 SOCSO-Staff RM19.75
Credit 431-000 EIS-Staff RM7.90
Credit Maybank RM3,452.35

Part E - Backup & Upload

After you completed all the part, please perform a backup. Upload the backup file on Brighten.

Thank you for your participants, good luck!

10