MYOB Qualification Test

BASIC LEVEL

Please fill your data:

Full name
All rights
reserved; no part :of_______________________________________________
this publication may be reproduced, stored in a retrieval system,
Place & Date
of form
Birth:
or transmitted
in any
by ______________________________________________
any means, electronic, mechanical, photocopying, recording, or
Phone
number
:
_______________________________________________
otherwise without permission of Net21Plus. This book may not be lent, resold, hired out or
Email disposed of by way
: _______________________________________________
otherwise
of trade in any form of binding or cover, other than in which it is
published, without the prior consent of Net21Plus.

Comment:
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
Code: L1JS13
Effective from 1 December 2013

MYOB Qualification Test Level Basic

MYOB Basic Qualification Test

MYOB Accounting v19
Instructions to Participants:
1. You will have 2 hours to complete the test. Answer all questions in the test.
2. Please check that you have MYOB Accounting v19 on your computer. If you do
not see it, please inform the invigilator for assistance.
3. You are NOT allowed to bring any diskettes or paper into the examination room.
4. You must create new folder on harddisk. Please save your .MYO, backup folder,
and report folder in this folder and the folder will be collected from harddisk at
the end of the examination.
5. In the event of any unforseen circumstances e.g. electricity blackout or
computer failure that prohibits you from continuing with the examination, and
such event is not the cause of your own action (s), you will be allocated extra
time to complete the examination at the discretion of the invigilator. (This is to
ensure consistency with all the other instructions, which are expressed in the
first person).
6. If you should encounter any technical difficulties with the computer during the
examination, please inform the invigilator for assistance.
7. Non-programmable electronic calculators are allowed for this examination.
8. You are not allowed to communicate with other examination candidates
throughout the examination.
9. You are NOT allowed to leave the examination room without the permission of
the invigilator.
10.
The assignment and any used or unused paper, must be returned to the
invigilator at the end of the examination.
11.

Total questions 13 with total score 100 points.

PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19

The Case Study

Based the fact given, you are required to:
1. Setup the company data file :

[4 marks]

Mrs. Evira is the owner of the store Evira Jewellery.

As Jewellery Store, Mrs. Evira buys and sells gold and silver to customer.
Mrs. Evira decided to use MYOB Accounting v19 accounting software for preparing his company 1
January to 31 December 2013 Financial Year Reports and prefer to use the 13th accounting
period for the audit trial adjustment.
Please use one of the account list provided by MYOB Accounting v19.
So you dont need to set up the account list completely.
Setup the following information:
The Company address: Jl. Kaliurang No.19 Sleman, Yogyakarta
Tel

: 0274-5707 07

Fax

: 0274-5707 08

Email

: info@evirajewellery.com

The following preferences option must be activated:

:
Tick the option for Warn if Jobs Are Not Assigned to
System Preferences
All Transaction [System-Wide]
:
Untick option for Automatically Check Spelling in
Windows Preferences
Text Fields Before Recording Transaction
:
Tick the option for : Warn for Duplicate Invoices
Sales Preferences
Numbers on Recorded Sales
:
Tick the option for : Warn for Purchase Orders
Purchases Preferences
Numbers on Recorded Purchases
:
Click User IDs to add new User ID as your Name.
Security Preferences
2. Log-off (exit) from MYOB no backup is required., and then login to MYOB data file created
with your user name
Setup the List below:

[8 marks]

Setup the following Account List

-

The Company dont use the following account codes anymore :

1-2120 Payroll Cheque Account
1-2130 Cash Drawer
1-2210 Less Provn for Doubtful Debts

The Company changes some accounts as follows :

1-2140 Petty Cash, Change to 1-2120
1-2160 Undeposited Funds, Change to 1-2130 Undeposited Cheque
PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19
-

The Company need to add the following accounts :

Account #

Account

Type

Header/Detail

Level

2-2340

GST Clearing

Other Liability

Detail

Setup the Tax Code List as GST (Goods & Services Tax), Tax Type: Goods & Services Tax, Rate:
10%
Setup the Job List as GD for Gold, DM for Diamond and SV for Service.
Setup the Category List as YGK for Yogyakarta, BDG for Bandung and SBY for Surabaya.
Setup the Items List as follows:
Item No.

NL

LD

CK

AW

Description

Neil Lane

Leo Diamond

Calvin Klein

Amanda
Wakeley

Selling Price

Rp5.750.000

Rp9.000.000

Rp6.500.000

Rp5.750.000

N-T

N-T

N-T

N-T

Unit

Unit

Unit

Unit

5-1100
Jewellery
Purchase
4-1100
Jewellery
Sales
1-2300
Merchandise
Inventory

5-1100
Jewellery
Purchase
4-1100
Jewellery
Sales
1-2300
Merchandise
Inventory

5-1100
Jewellery
Purchase
4-1100
Jewellery
Sales
1-2300
Merchandise
Inventory

5-1100
Jewellery
Purchase
4-1100
Jewellery
Sales
1-2300
Merchandise
Inventory

Tax Code
When
Bought/Sold
Selling Unit of
Measure
I Buy This
Item
I Sell This
Item
I Inventory
This Item

Setup the following Cards List:

DIAMOND STAR (Customer)

KEYNIA JEWELLERY (Supplier)
ERNEST COLLECTION (Customer) OLIVE COLLECTION (Supplier)
UNIQUE SILVER (Customer)
SAPPHIRE SILVER (Supplier)

ROSE (Employee)
JULIA (Employee)

3. Setup Account Opening Balance Sheet information as of 01 January 2013:

[8 marks]

PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19

Setup the following ending balance as 31 Dec 2012:

Customer Name
Total
Invoice#
Cust. PO#
Category

DIAMOND STAR
Rp3.300.000 Inc. GST
S-120001
DS-120001
YGK

ERNEST COLLECTION
Rp4.400.000 Inc. GST
S-120002
EC-120001
BDG

UNIQUE SILVER
Rp2.200,000 Inc. GST
S-120003
US-120001
SBY

Supplier Name
Total
PO#
Supp. Inv#
Category

KEYNIA JEWELLERY
Rp4.400.000 Inc. GST
P-120001
KJ-120001
YGK

OLIVE COLLECTION
Rp2.200.000 Inc. GST
P-120002
OC-120001
BDG

SAPPHIRE SILVER
Rp2.200.000 Inc. GST
P-120003
SS-120001
SBY

Setup the following inventory opening balance as 01 January 2013 [Journal #: I-130001]
[Category: YGK]:
Item No.
AW
CK
LD
NL

Qty
8 units
12 units
9 units
10 units

Unit Cost
Rp 5.400.000
Rp 5.200.000
Rp 7.200.000
Rp 4.600.000

4. The following transactions are made in January 2013. Record these transactions in MYOB
according to the dates and details given below.
PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19
02
Jan
2013

A purchase was raised to purchase the following inventory item from main
supplier, SAPPHIRE SILVER, with Net 30 after EOM credit terms. (PO#:P130001, Supplier Inv#: SS-130001)
Received 4 units Leo Diamond (LD) for Rp7.200.000/unit (Exclude
10% GST) each. With backorder 1 units of LD. [Job: DM]
Received 3 units Amanda Wekeley (AW) for Rp5.400.000/unit
(Exclude 10% GST). [Job: GD] [Category: SBY]

POINT
[4 marks]

03
Jan
2013

A bill was received from OLIVE COLLECTION for Advertising (Acc# 6-3100) on
amount Rp2.200.000 (Include GST 10%) on COD terms. (PO#: P-130002,
Supplier Inv#: OC-130001) [Job: SV] [Category : BDG]

POINT
[4 marks]

Payment to OLIVE COLLECTION from Cheque Account [Cheque No: D130001] with total amount Rp3.200.000 for bill on 31 Dec 2012 with amount
Rp1.000.000 and bill on 3 Jan 2013 with amount Rp2.200.000.

[4 marks]

Return 1 of Leo Diamond (LD) for Rp7.200.000 (Exclude 10% GST) to

SAPPHIRE SILVER, (PO#: P-130003, Supplier Inv#: SS-130001). Edit Journal
Memo with Purchase Return; SAPPHIRE SILVER. [Category: SBY]

POINT
[2 marks]

04
Jan
2013

Immediately applied the Return-Debit note to Trade Creditor balance for,

SAPPHIRE SILVER [ID#: P-130003] for bill on 2 Jan 2013.

[2 marks]

15
Jan
2013

Sold the following items to ERNEST COLLECTION on Net 10 days terms (Inv#:
S-130001, Cust PO#: EC-130001). All the goods & Invoice was Received :
Ship 7 units of Amanda Wekeley (AW) Rp5.750.000/unit (Exclude
10% GST) [Job : GD]
Ship 5 units of Calvin Klein (CK) Rp6.500.000 /unit (Exclude 10%
GST) [Job: GD] [Category: BDG] [Salesperson: JULIA]

POINT
[4 marks]

16
Jan
2013

Sold 4 unit Neil Lane (NL) Rp6.325.000 (Include 10% GST) to DIAMOND STAR
on Net 20th terms (Inv#: S-130002, Cust PO#: DS-130001). All the goods &
Invoice was received. [Job: DM][Category: YGK] [Salesperson: ROSE]

POINT
[4 marks]

17
Jan
2013

Raised sale services for Rings Reparation to UNIQUE SILVER as Repairs (Acc#
4-1300) for Rp770.000 (Include 10% GST) on COD terms (Inv#: S-130003,
Cust PO#:US-130001). Invoice was delivered. [Job: SV] [Salesperson: JULIA]
[Category: SBY].

[2 marks]

Full payment of Rp770.000 for invoice on 17 Jan 2013 was received from
UNIQUE SILVER and deposits to Petty Cash [ID#: R-130001].
18
Jan
2013

Issued Discount-Credit Notes to UNIQUE SILVER Rp70.000 as Discount Given

(Acc# 5-3000) (Inv#: S-130004, Cust PO#: US-130001) and edit Journal
Memo with Sale DISCOUNT: UNIQUE SILVER. [Category: SBY] [Salesperson:
JULIA]
Immediately Pay Refund [Cheque No: D-130002] for the Rp70.000 DiscountCredit notes to UNIQUE SILVER from the Petty Cash.

20

Use Spend Money, transfer Rp3.000.000 to Cheque Account from Petty Cash

[2 marks]
POINT
[2 marks]

[2 marks]
POINT
[4 marks]

PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19
Jan
2013

and pay Rp10.000 as Bank Charges. [Cheque No#: D-130003] [Category:

YGK]
Receive Money for total Rp250.000 to Cheque Account, for Rp260.000 as
Interest Income with Rp10.000 Bank Charges [ID#: R-130002] [Category:
YGK]

[4 marks]

5.

Perform Bank Reconciliation for the month of Jan 2013 for Cheque Account
the Bank statement shows a balance of Rp500.050.000 on 31 Jan 2013.

[4 marks]

6.

In addition to the transaction above, prepare a journal entry to record the

Depreciation on 31 Jan 2013, for the following asset categories [GJ#:G130001] [Category: YGK]:
Bldgs & Imprv Rp100.000

[2 marks]

Save as Monthly Recurring Transaction start from 28 Feb 2013 for those
journal then use the recurring and record depreciation journal for 28 Feb
2013 [GJ#: G-130003] [Category: YGK]
Prepare a journal entry to record the GST Clearing journal on 31 Jan 2013
[GJ#: G-130002] for Dec 2012 balance. [Category: YGK]

[2 marks]

7.

On 31 Jan 2013, prepare adjust inventory to record Inventory Total Unit Cost
Adjustment [IJ#: I-130002] [Category : YGK] for:
Calvin Klein (CK) increased by Rp210.000 as 5-1100 Jewellery
Purchase [Job: DM].
Neil Lane (NL) decreased by Rp120.000 as 5-1100 Jewellery
Purchase [Job: DM].

[4 marks]

8.

Generate the following financial reports at 1 January 31 January 2013 to

PDF file format, save in REPORTS folder :

[4 marks]

General Ledger [Summary]

Standard Balance Sheet
Profit & Loss [Accrual]
GST [Detail Accrual]
Receivables Reconciliation [Summary]
Payables Reconciliation [Summary]
Bank Register
Reconciliation Report

9.

From Security Preference, activate the option for Use Audit Trail Tracking,
then Lock the Accounting period for 31 Jan 2013. BACKUP your MYOB
Company Data File (ONLY), Check Company File for Error and Save the
MYOB company data backup file name as Your name in Backup folder.

[4 marks]

10.

From Company Data Auditor Transaction Review for 1 Jan 2013 to 31 Jan
2013, there is a ? mark for Scan for Future Dated Transaction. Display it
and send to PDF, save in REPORTS folder and than delete that future date
transaction.

[4 marks]

PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com

MYOB Basic Qualification Test

MYOB Accounting v19
11.

Edit payment from UNIQUE SILVER on 17 Jan 2013 to split payment for total
amount Rp770.000 deposit to Petty Cash for invoice on 31 Dec 2012 with
amount Rp500.000 and for invoice on 17 Jan 2013 with amount Rp270.000.
Keep the Cheque No. record as R-130001.

[4 marks]

12.

Delete all related transaction on 4 Jan 2013.

[4 marks]

13.

Generate and modify the Inventory Value Reconciliation report like the
sample below and then save as PDF Format.

[4 marks]

~ End of Assignment ~

PT. NET21PLUS
Menara KADIN Indonesia, Lt. 30, Jl. H.R. Rasuna Said, X-5, Kav. 2-3, Jakarta 12950. Indonesia.
Tel. : 021-5570 0905 | Fax. : 021-5570 0907
E-mail : info@net21plus.com | Website : www.net21plus.com