Flasdisk No.

MYOB Qualification Test

LEVEL INTERMEDIATE

Please fill your data:

Full name : ___________________________________________
Place & Date of Birth : ___________________________________________
Phone number : ___________________________________________
Email : ___________________________________________
Lecturer Name : ___________________________________________

Code: L2HD15

Folder
Effective fromname
12 Maret 2015 : ___________________________________________

All rights reserved; no part of this publication may be reproduced, stored in a retrieval system, or
transmitted in any form by any means, electronic, mechanical, photocopying, recording, or otherwise
without permission of Net21Plus. This book may not be lent, resold, hired out or otherwise disposed of
by way of trade in any form of binding or cover, other than in which it is published, without the prior
consent of Net21Plus.
 MYOB Intermediate Qualification Test
MYOB Premier v13
MYOB Qualification Test Level Intermediate

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 Premier 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 circutances 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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
The Case Study

Based the fact given, you are required to :

1. Setup the company data file :

Mrs. Dona is the owner of the company “TANAH BIRU SQUARE”.

Her business as Wholesale Business, she buy and sell cloth, bag and shoes to end users.

Mrs. Dona decided to use MYOB Premier v19 software for preparing her company 1 January to
31 December 2017Financial 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 Premier v19.
So you don’t need to set up the account list completely.

Setup the following information:

Company Addreess : Jl. Tanah biru No. 1, Jakarta
Tel : +6221 567 3425
Fax : +6221 567 3426
Email : [email protected]

The following preferences option must be activated:

 System Preferences : Tick the option for “I Deal Multiple Currencies
(System-Wide)”
 Windows Preferences : Untick option for “Automatically Check Spelling
in Text Fields Before Recording Transaction”
 Sales Preferences : Tick the option for : “Warn for Duplicate
Invoices Numbers on Recorded Sales”
 Purchases Preferences : Tick the option for : “Warn for Purchase Orders
Numbers on Recorded Purchases”
 Security Preferences : Click User IDs to add new User ID as your Name.
[4 marks]

Log-off (exit) from MYOB – no backup is required, and then login to MYOB data file created with
your user name

2. Setup the List below :

Setup the currencies below:
Currency Code Currency Name Exchange Rate Currency
Symbol
IDR Rupiah 1,000000 Rp
AUD Aus Dollar 10.000,000000 A$
MYR Malaysia Ringgit 3.500,000000 RM

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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
Setup the following account list
- The Company don’t use the following account codes anymore :
 1-2120 Payroll Cheque Account
 1-2130 Cash Drawer
 1-2210 Less Prov’n for Doubtful Debts

- The Company changes some account list as follows:

 1-2110 Cheque Account, change to Bank (IDR)
 1-2140 Petty Cash, change to : 1-2120 Cash (IDR)
 1-2160 Undeposited Fund, change to : 1-2170
 1-2200 Trade Debtors, change to Trade Debtors (IDR)
 2-2200 Trade Creditors, change to Trade Creditors (IDR)

- The Company need to add the following accounts:

Account Header/
Account Type Level
# Detail
1-2130 Cash (AUD) Bank Detail 4
1-2131 Cash (AUD) Exchange Bank Detail 4
1-2140 Cash (MYR) Bank Detail 4
1-2141 Cash (MYR) Exchange Bank Detail 4
1-2150 Bank (AUD) Bank Detail 4
1-2151 Bank (AUD) Exchange Bank Detail 4
1-2160 Bank (MYR) Bank Detail 4
1-2161 Bank (MYR) Exchange Bank Detail 4
1-2210 Trade Debtors (AUD) Accounts Receivable Detail 3
1-2211 Trade Debtors (AUD) Exchange Accounts Receivable Detail 3
1-2220 Trade Debtors (MYR) Accounts Receivable Detail 3
1-2221 Trade Debtors (MYR) Exchange Accounts Receivable Detail 3
2-2220 Trade Creditors (AUD) Accounts Payable Detail 3
2-2221 Trade Creditors (AUD) Exchange Accounts Payable Detail 3
2-2230 Trade Creditors (MYR) Accounts Payable Detail 3
2-2231 Trade Creditors (MYR) Exchange Accounts Payable Detail 3
2-2340 VAT Clearing Other Liability Detail 4
8-2000 Forex Gain (Loss) Other Income Header 2
8-2100 Realized Gain (Loss) Forex Other Income Detail 3
8-2200 Unrealized Gain (Loss) Forex Other Income Detail 3

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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
Setup the linked account below:
 Setup linked account for Accounts & Banking Accounts for 4-9999 Currency Gains/
Losses to 8-2100 Realized Gain (Loss) Forex.
Then Combine Account to remove all transaction from Secondary Account:
4-9999 to Primary Account: 8-2100.
 From Currency List, setup linked account for Local Currency & Foreign Currency
for Receivable Accounts & Payable Accounts.

Delete all Tax Codes except N-T (Non Taxable). Setup the Tax Code List as VAT (Value Added
Tax), Tax Type: Goods & Services Tax, Rate: 10%.

Setup the Job List : S for Shoes, C for Clothes, B for Bag, and O for Other.

Setup the Categories List : J for Jakarta, B for Bogor, and D for Depok.

Edit Price Level Name: Level A : IDR, Level B : AUD, Level C : MYR

Setup the item list as follows:

Item No. PB ZS BB
Description Prada Bag Zara Shoes Burberry
Rp 350.000 Rp 280.000 Rp 175.000
Selling Price AU$ 35 AU$ 28 AU$ 17,5
RM 100 RM 80 RM 50
Tax Code
When N-T N-T N-T
Bought/Sold
Selling Unit
Pack Pack Pack
of Measure
I Buy This
5-1000 Purchase 5-1000 Purchase 5-1000 Purchase
Item

I Sell This
4-1000 Sales 4-1000 Sales 4-1000 Sales
Item

I Inventory 1-2300 Merchandise 1-2300 Merchandise 1-2300 Merchandise

This Item Inventory Inventory Inventory

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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
Setup the following customer, supplier and employee list :
Customer  FLO SHOP (Cust.  HANS COLLECTION Mrs. LILA (Cust.
IDR) (Cust. AUD) MYR)

Supplier  PT BAGHOES (Supp.  CLOTH CENTER LUNAR SHOP (Supp.

IDR) (Supp. AUD) MYR)

Employee  ROSE (Employee  STEVEN (Employee DICK (Employee

IDR) MYR) AUD

Personal Last Name : <Your Name>

Addres : <Your Place, Date of Birth>
Phone #1 : <Your Phone Number>
Email : Your Email

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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
3. Setup Balance Sheet information as 01 Jan 2017:

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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
Setup the following ending balance as 31 December 2016:
Customer Name FLO SHOP HANS COLLECTION Mrs. LILA
Total Rp 4.400.000,- Inc. VAT A$ 550 Inc. VAT RM 1.100 Inc. VAT
Invoice# S-140001 S-140002 S-140003
Cust. PO# FS-140001 HC-140001 ML-140001
Category J B D

Supplier Name PT BAGHOES CLOTH CENTER LUNAR SHOP

Total Rp 2.200.000,- Inc. VAT A$ 1.100 Inc. VAT RM 1.100 Inc. VAT
PO# P-140001 P-140002 P-140003
Supp. Inv# PB-140001 CC -140001 LS -140001
Category J B D

Setup the following inventory opening balance as 01 January 2017[Journal#: I-150001]

[Category: J] :
Item No. Item Name Qty Pcs/Unit Cost Account#
PB Prada Bag 100 Pack Rp 245.000,- 1-2300
ZS Zara Shoes 150 Pack Rp 210.000,- 1-2300
BB Burberry 200 Pack Rp 105.000,- 1-2300
[8 marks]
4. The following transactions are made in January 2017. Record these transaction in MYOB
according to the dates and details given below.

02 A purchase was raised to purchase the following inventory item from main supplier, PT
Jan BAGHOES, with Net 25th credit terms. (PO#:P-150001, Inv#:PB-150001). Bill and goods was
2015 received.
 Received 12 Packs of Zara Shoes(ZS) for Rp 210.000,-/pack (Exclude 10% VAT).
[Job :S]. with 3 Packs backorder of Zara Shoes(ZS).
 Received 21 Packs of Burberry(BB) for Rp 105.000,-/pack (Exclude 10% VAT). [Job : C]
[Category :J]
[4 marks]
04 A bill was received from LUNAR SHOP for In-Store Promotion (Acc#: 6-3110) on amount RM
Jan 550 (Include VAT 10%) on COD terms. (PO#: P-150002, Supplier Inv#: LS-150001) (Job: O).
2015 [Category : D] [Rate: 1RM= Rp 2.800]
[4 marks]
Full payment of RM 550 for bill on 4 Jan 2017was paid to LUNAR SHOP from Bank (MYR)
[ID#: D-150001]. [Rate: 1MYR= Rp 2.700]
[4 marks]
06 Return 15 Packs of Burberry(BB) for Rp 105.000,-/pack (Exclude 10% VAT) to PT BAGHOES
Jan (PO#: P-150003, Supplier Inv#: PB-150001) [Job : C]. Edit Journal Memo with "Purchase
2015 Return; PT BAGHOES" [Category : J].
[2 marks]
Immediately applied the Return-Debit note to Trade Creditor balance for PT BAGHOES for
bill on 2 Jan 2017[ID#: P-150003].
[2 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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
10 Sold the following items to Mrs. LILA on Net 28th after EOM term (Inv#: S-150001, Cust PO#:
Jan ML-150001). All the goods & Invoices was delivered:
2015  Ship 20 Packs of Burberry(BB) @RM 50 (Exclude 10% VAT) [Job : C]
 Ship 30 Packs of Prada Bag(PB) @RM 100 (Exclude 10% VAT) [Job : B]
 Ship 30 Packs of Zara Shoes(ZS) @RM 80 (Exclude 10% VAT) [Job : S] [Category : D]
[Salesperson :STEVEN] [Rate: 1RM= Rp 3.700]
[4 marks]
11 Raised sale for Custome Bag, Shoes and Clothes to HANS COLLECTION as Miscellaneous
Jan Income (Acc#: 4-8000) on COD (Inv#: S-150002, Cust PO#: HC-150001) for A$ 1.100
2015 (Include 10% VAT). Invoice was delivered. [Salesperson :DICK] [Job : O] [Category : B]
[Rate: 1A$ = 10.300].
[4 marks]
Payment from HANS COLLECTION to Bank (AUD) [ID#: R-150001] was received with total
amount A$ 1.500, for bill on 31 Dec 2016 with amount A$ 400 and bill on 11 Jan 2017with
amount A$ 1.100 [Rate: 1A$= Rp 10.500]
[4 marks]
12 Issued Discount-Credit Notes to HANS COLLECTION for A$ 10 as Discount Given (Acc# 5-
Jan 3000) (Inv#: S-150003,Cust PO#: HC-150001) and edit Journal Memo with "Sale Discount :
2015 HANS COLLECTION".[Category: B] [Salesperson:DICK]. [Rate: 1A$= Rp 9.900]
[2 marks]
Immediately Pay Refund [Cheque No: D-150002] for A$ 10 the Discount-Credit Note to
HANS COLLECTION from Cash(AUD). [Rate: 1A$= Rp 9.800]
[2 marks]
30 Use Spend Money, Payment from Bank (IDR), by Cheque# : D-150003 for Rp 1.650.000, for
Jan Rp 1.500.000,- Bank Loans and Rp 150.000 Interest Expense for January. [Category: J]
2015 [2 marks]
Use Receive Money [ID#: R-150002] to record: Deposit RM 20 to Bank (MYR), for RM 23 Bank
Interest Income and RM 3 Bank Charges [Category: J] [Rate: 1 RM= Rp 3.600]
[2 marks]
5. Perform a bank reconciliation for the month of 31 Jan 2017 for Bank (MYR) account.
The bank statement shows a balance of RM 1.470 on 31 Jan 2015.
[2 marks]
6. In addition to the transaction above, prepare a journal entry to record the
depreciation journal on 31 Jan 2015, for the following asset categories [GJ#: G-
150001] [Category:J] :
Warehouse Equip Rp 500.000

Save as Monthly Recurring Transaction start from 28 Feb 2017 for those journal
then Use the Recurring to record depreciation journal for 28 Feb 2017 [GJ#: G-
150006] [Category:J].
[4 marks]
Prepare a journal entry to record the VAT Clearing [GJ#: G-150002] on 31 Jan
2017for 31 Dec 2016 balance. [Category:J]
[2 marks]
7. On 31 Jan 2015, prepare adjust inventory to record Inventory Found Unit Cost Unknown
[IJ#: I-150002] [Category:J] for:
 2 Packs of Burberry(BB) as 5-1000 Purchase [Job: C].
[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 : [email protected] | Website : www.net21plus.com
 MYOB Intermediate Qualification Test
MYOB Premier v13
8. Update the Exchange Rate on 31 Jan 2017[1AUD= Rp 9.800, 1RM= Rp 12.800] and then
prepare a journal entry to record Realised Gains (Losses) [GJ#: G-150003] and Unrealised
Gains (Losses) [GJ#: G-150004] on 31 Jan 2017and reverse journal for Unrealised Gains
(Losses) [GJ#: G-150005] on 1 Feb 2017[Category: J].
[6 marks]
9. Generate the following financial reports at 1 January – 31 January 2017to PDF file format,
save in REPORTS folder :
 Account Transactions [Accrual] Banking – Reconciliation Report
 Standard Balance Sheet Receivables Reconciliation [Summary]
 Profit & Loss [Accrual] Payables Reconciliation [Summary]
 Bank Register VAT [Detail-Accrual]
[4 marks]
10. From Security Preference, Lock the Accounting period for 31 Jan 2015. 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]
11. From Company Data Auditor – Transaction Review for 1 Jan 2017to 1 Feb 2015, there is a
“?” mark for Scan for Future Dated Transaction. Display it & Sent to PDF the reports.
[2 marks]
12. Edit the Recurring Transaction Template of Fixed Assets Depreciation for Warehouse
Equipment to Rp 550.000.- per month.
[2 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 : [email protected] | Website : www.net21plus.com