BKAS1013_A121_UBS.docx

7/29/2019 BKAS1013_A121_UBS.docx

http://slidepdf.com/reader/full/bkas1013a121ubsdocx 1/11

BKAS1013 ICT FOR ACCOUNTING (SEMESTER A121)

GROUP ASSIGNMENT 4: COMPUTERISED ACCOUNTING PACKAGE

SUBMISSION DUE: 20 DEC 2012 (THURSDAY)

Pustaka Fajar Sdn Bhd sells both academic and non-academic books. The company starts its business operation

since 2001. The company hires two permanent workers and a part time worker in managing the business

operation. As the business is growing, Mr. Shahrul Naim, the CEO of Pustaka Fajar start to realise the

importance of handling his business accounting records in more efficient manner. Taking into consideration the

potential of IT, he decided to consider UBS accounting to support his company’s accounting function.

Suppose you are working for accounting package dealer and consulting service. You have been assigned by your

manager to facilitate Pustaka Fajar Sdn Bhd in the conversion processes. For a start, you have accumulated the

following information about the company:

a.

Address: <specify your own address>b. Company registration no: <specify your registration no.>

c. Current accounting period for the company is March 1st, 2012 to February 28, 2013.

d. The management intends to computerise its accounting system effective June 1st

, 2012.

Ms. Zahra, an account officer of Pustaka Fajar supplied the following accounting-related information:

A. Trial balance as at May 31, 2012

B. Debtors and creditors aging analysis as at May 31, 2012

C. List of books maintained

D. Stock values from March to June 2012

E. Source documents for transactions on June 2012F. Other adjustments information

A. Trial Balance as at May 31, 2012

Description Debit Credit

1000/000 Capital 110,000

1030/000 Profit and loss account 43,000

2010/000 Motor vehicle – Toyota Avanza 60,000

2010/100 Accumulated Depreciation – Motor vehicle 12,000

2020/000 Office equipment 25,000

2020/100 Accumulated Depreciation –Office equipment 7,5003000/000 Debtors control account 28,650

3100/000 Bank – Bank Islam Malaysia Berhad 74,310

3200/000 Cash on hand 3,200

3300/000 Stock (as at 29 February 2012) 30,100

4000/000 Creditors – control account 37,750

5000/000 Sales 87,500

5100/000 Sales return 3,100

7/29/2019 BKAS1013_A121_UBS.docx


1

6010/000 Purchases 54,700

6020/000 Purchases return 1,420

9010/000 Sales discount 1,100

9020/000 Salaries expense 9,400

9030/000 Wages expense 3,500

9040/000 Utilities expense 1,6009050/000 Petrol expense 1,200

9060/000 Motor vehicle maintenance expense 1,750

9070/000 Miscellaneous expenses 1,100

9080/000 Computer supplies expense 460

299,170 299,170

B. Debtors and creditor Aging Report

Amount due (RM)

> 5 mths 4 mths 3 mths 2 mths 1 mth Current

DebtorCode Description

3000/A01 Aneka Buku - 2,900 2,400 3,100 3,700

3000/K01 Kids Zone - - 2,350 - 3,500 4,700

3000/N01 Nureen’s bookshop - - 3,100 2,900 -

Creditor

Code Name

4000/E01 Excel Knowledge - - - 3,790 5,220 -

4000/M01 Megah Cemerlang - 7,500 3,200 2,680 2,140

4000/U01 Utara Distributor - - 5,650 - 3,420 4,150

C. Accounting records

Firm currently maintains the following books on monthly basis:

i. Sales journal

ii. Sales return journal

iii. Purchase journal

iv. Purchase return journal

v. Cash bookvi. Bank book

vii. General journal

D. Stock value

Closing stock as at 31-3-2012 29,100

7/29/2019 BKAS1013_A121_UBS.docx


2




E. Source documents for transactions occurred for the month of June 2012

Note: key-in the following entries prior to record the transactions for June 2012.

Batch : General journal

Period : 4

Date : 1 June 2012

Reference no : <group member’s matric number>

Journal Entry

Dr Cash on hand RM 1.00

Cr Capital RM 1.00

*Repeat the same entry for each group member

Invoices Sent

PUSTAKA FAJAR SDN. BHD.

TO: ANEKA BUKU INVOICE NO: INV-2578

Date: 10 June 2012

DELIVERY ORDER NUMBER AMOUNT

DO 6010/2012 5,700DO 6015/2012 1,900

DO 6019/2012 2,300

9,900


TO: NUREEN’S BOOKSHOP INVOICE NO: INV-2580

Date: 17 June 2012


DO 6017/2012 2,600

DO 6027/2012 3,900

DO 6031/2012 4,100

10,600


TO: KIDS ZONE INVOICE NO: INV-2583

7/29/2019 BKAS1013_A121_UBS.docx


3

Date: 19 June 2012


DO 6022/2012 4,100

DO 6029/2012 3,900

DO 6035/2012 4,400

12,400


TO: ANEKA BUKU INVOICE NO: INV-2587

Date: 25 June 2012


DO 5022/2012 1,800

DO 5029/2012 2,100

DO 5035/2012 1,700

5,600

Invoices Received

MEGAH CEMERLANG

TO: PUSTAKA FAJAR SDN. BHD. INVOICE NO: 5876

Date: 2 June 2012

NO DESCRIPTION AMOUNT

1 PRODUCT F-01 1,200

2 PRODUCT G-04 2,100

3 PRODUCT H-05 2,000

5,300

UTARA DISTRIBUTOR


Date: 14 June 2012


1 PRODUCT J-02 2,300

2 PRODUCT K-03 2,700

3 PRODUCT L-04 1,600

6,600

EXCEL KNOWLEDGE

TO: PUSTAKA FAJAR SDN. BHD. INVOICE: 4525

Date: 18 June 2012

7/29/2019 BKAS1013_A121_UBS.docx


4


1 PRODUCT M-01 3,100

2 PRODUCT N-01 2,500

5,600

EXCEL KNOWLEDGE


Date: 29 June 2012


1 PRODUCT M-02 1,500

2 PRODUCT P-07 2,090

3 PRODUCT R-06 1,340

4,930

Credit Notes


TO: NUREEN’S BOOKSHOP CREDIT NOTE NO: CN 212

Date: 20 June 2012


FOR GOODS BEING RETURNED (INV-2580 ) 550.00

UTARA DISTRIBUTOR

TO: PUSTAKA FAJAR SDN. BHD. CREDIT NOTE NO: 2445

Date: 21 June 2012


BEING GOODS RETURNED ITEM 300.00

(INVOICE NO: 7134)

7/29/2019 BKAS1013_A121_UBS.docx


5

Official Receipts

PUSTAKA FAJAR SDN. BHD. OFFICIAL RECEIPT

NO: OR-2200

Date: 16 June 2012

Received from : ANEKA BUKUPayment for : INV-2578

Amount : SEVEN THOUSAND AND NINE HUNDRED ONLY

RM 7,900 Cash / Cheque No: 321435


NO: OR-2201

Date: 26 June 2012

Received from : NUREEN’S BOOKSHOP Payment for : INV-2580

Amount : TEN THOUSAND AND FIFTY ONLY



NO: OR-2202

Date: 28 June 2012

Received from : KIDS ZONEPayment for : INV-2583

Amount : NINE THOUSAND AND FOUR HUNDRED ONLY



NO: OR-2203

Date: 29 June 2012

Received from : NUSA DUA SDN BHDPayment for : BUILDING RENTAL FOR JUNE 2012

Amount : TWO THOUSAND AND FIVE HUNDRED ONLY


7/29/2019 BKAS1013_A121_UBS.docx


6

Payment Vouchers

PUSTAKA FAJAR SDN. BHD. PAYMENT VOUCHER

NO: PV-2300

Date: 21 June 2012

Pay to : MEGAH CEMERLANGFor : PAYMENT FOR INVOICE NO: 5876

Amount : FIVE THOUSAND AND THREE HUNDRED ONLY



NO: PV-2301

Date: 27 June 2012

Pay to : UTARA DISTRIBUTOR

For : PAYMENT FOR INVOICE NO: 7134

Amount : SIX THOUSAND AND THREE HUNDRED ONLY



NO: PV-2302

Date: 30 June 2012

Pay to : EXCEL KNOWLEDGE

For : PAYMENT FOR INVOICE NO: 4525

Amount : FIVE THOUSAND AND SIX HUNDRED



NO: PV-2303

Date: 30 June 2012

Pay to : MICHELLE YEOHFor : SALARY FOR JUNE 2012

Amount : ONE THOUSAND ONLY


7/29/2019 BKAS1013_A121_UBS.docx


7

7/29/2019 BKAS1013_A121_UBS.docx


8


NO: PV-2304

Date: 30 June 2012

Pay to : AZWAN HAFIZ

For : SALARY FOR JUNE 2012Amount : ONE THOUSAND AND ONE HUNDRED ONLY



NO: PV-2305

Date: 30 June 2012

Pay to : PART TIME STAFF

For : WAGES FOR JUNE 2012

Amount : FIVE HUNDRED AND TEN ONLY

RM 510 Cash / Cheque No:


NO: PV-2306

Date: 30 June 2012

Pay to : FAST PRINT SDN BHD

For : PRINTING BOOKLET FOR PROMOTION

Amount : TWO HUNDRED AND FIFTY ONLY


7/29/2019 BKAS1013_A121_UBS.docx


9


NO: PV-2306

Date: 30 June 2012

Pay to : POS MALAYSIA

For : UTILITY BILLS – WATER, TELEPHONE & ELECTRICITY

Amount : FOUR HUNDRED AND TWENTY ONLY


F. OTHER ADJUSTMENTS INFORMATION

a. Cancel the invoices issued to Aneka Buku (INV-2587) due to the delivery of ordered goods has

been put on hold. You have been given permission by the manager to delete the transaction.b. Allocation of annual depreciation expense for all fixed assets is 10% of the asset’s cost.

c. Change account type description for ‘Sales’ as ‘Revenue’

G. BACKUP AND MONTH END PROCESSING

a. Perform month end closing until June 2012

b. Perform backup procedure

H. KEY FIGURES

Complete the following figures based on various reports available in UBS system (use suggested format in

presenting your answer)

Description Amount

H-1 Trial balance total as at 30 June 2012

H-2 Cash on hand as at 30 June 2012

H-3 Cash at bank as at 30 June 2012

H-4 Total sales for the month of June 2012

H-5 Net profit for the month of June 2012

H-6 Net profit as at 30 June 2012

H-7 Working capital as at 30 June 2012

H-9 Account balance of each debtor

Aneka

Kids Zone

Nureen

7/29/2019 BKAS1013_A121_UBS.docx


10

H-10 Account balance of each creditor

Excel

Megah

Utara

H-11 All fixed assets balance (net) as at 30 June 2012

Motor vehicle

Office equipment

SUBMISSION GUIDELINES

A. Upload the backup file (backup.acc) in the learning zone.

B. The following reports must be submitted in hard copy

i) Key figures (as specified in section H)

ii) Batch of transactions (for all batches created in section C)

iii) Trial balance as at 30 June 2012

iv) Profit and loss account for the month of June 2012 and year to date (select this year-this month

option)

v) Balance sheet as at 30 June 2012 (select this year – last year option)

BKAS1013_A121_UBS.docx

Documents

Transcript of BKAS1013_A121_UBS.docx