FLASHDISK No.
MYOB Qualification Test
LEVEL BASIC
Please fill your data:
Full name : ________________________________________________
Place & Date of Birth: _______________________________________________
Phone number : ________________________________________________
Email : ________________________________________________
Lecturer Name : ________________________________________________
Please fill your data:
Full name : ___________________________________________
Code: L1DS15
Place & Date of Birth : ___________________________________________
Effective from 27 Maret 2015
Phone number : ___________________________________________
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
Email : ___________________________________________
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 Accounting v19
MYOB Qualification Test Level Basic
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 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 Accounting v19
The Case Study
Based the fact given, you are required to :
1. Setup the company data file :
Mr. Hery is the owner of the company “HERRY FOOD”.
His business as Delicatessen buys and sells instant food to end users.
Mr. Hery decided to use MYOB Accounting v19 accounting software for preparing his company
1 January to 31 December 2015 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 don’t need to set up the account list completely.
Setup the following information:
Company Address : Tangerang, Indonesia
Tel : +6221 122 5577
Fax : +6221 122 5578
Email :
[email protected] The following preferences option must be activated:
System Preferences : Tick the option for “Warn if Jobs Are Not
Assigned to All Transaction [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 and Password
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 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:
o 1-2140 Petty Cash, Change to 1-2120
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 Accounting v19
o 1-2160 Undeposited Funds, Change to 1-2130 Undeposited Cheque
o 2-2300 GST Liabilities, Change to VAT Liabilities
o 2-2310 GST Collected, Change to VAT Collected
o 2-2330 GST Paid, Change to VAT Paid
- The Company need to add the following accounts :
o 2-2340 VAT Clearing
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 as FF for Fast Food, HF for Healthy Food and SV for Services.
Setup the Category List as TGR for Tangerang, JKT for Jakarta and YGK for Yogyakarta.
Setup the item list as follows:
Item No. VP VB HS HO
Description Vege Pizza Vegan Burger Health Soup Health Origano
Selling Price Rp 48.000,- Rp 24.000,- Rp 36.000,- Rp 60.000,-
Tax Code When
N-T N-T N-T N-T
Bought/Sold
Selling Unit of
Unit Unit Unit Unit
Measure
5-1000
I Buy This Item 5-1000 Purchases 5-1000 Purchases 5-1000 Purchases
Purchases
I Sell This Item 4-1000 Sales 4-1000 Sales 4-1000 Sales 4-1000 Sales
1-2800 1-2800 1-2800 1-2800
I Inventory This
Merchandise Merchandise Merchandise Merchandise
Item
Inventory Inventory Inventory Inventory
Setup the following customer, supplier and employee list :
- NATU VEGE (Customer) - GO VEGE(Supplier) - MERRY (Empl)
- HEALTHY GO (Customer) - VEGAN HUT (Supplier) - DELSI (Empl)
- Mrs. DEVA (Customer) - MR. CHARL (Supplier)
[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 : [email protected] | Website : www.net21plus.com
MYOB Intermediate Qualification Test
MYOB Accounting v19
3. Setup Balance Sheet information as 01 Jan 2015 :
Setup the following ending balance as 31 December 2014:
Customer Name NATU VEGE HEALTHY GO MRS. DEVA
Total Rp4.400.000 Inc. VAT Rp2.200.000 Inc. VAT Rp3.960.000 Inc. VAT
Invoice# S-140001 S-140002 S-140003
Cust. PO# NV-140001 HG-140001 MD-140001
Category JKT TGR YGK
Supplier Name GO VEGE VEGAN HUT MR. CHARL
Total Rp2.200.000 Inc. VAT Rp1.100.000 Inc. VAT Rp2.640.000 Inc. VAT
PO# P-140001 P-140002 P-140003
Supp. Inv# GV-140001 VH-140001 MC-140001
Category JKT TGR YGK
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 Accounting v19
Setup the following inventory opening balance as 01 January 2015 [Journal#: I-150001]
[Category: TGR]:
Item No. Qty Unit Cost Account#
VP 12 unit Rp 45.000 1-2800
VB 35 unit Rp 20.000 1-2800
HS 8 unit Rp 30.000 1-2800
HO 20 unit Rp 55.000 1-2800
[8 marks]
4. The following transactions are made in January 2015. Record these transaction in MYOB
according to the dates and details given below.
03 Jan A purchase was raised to purchase the following inventory item from main supplier, GO
2015 VEGE, with Net 30 days term credit terms. (PO#:P-150001, Inv#:GV-150001). Bill and
goods was received.
Received 3 unit of Vege Pizza (VP) for Rp 44.000/unit (Include 10% VAT) each. With
backorder 2 unit of Vege Pizza (VP).[Job: FF]
Received 4 unit of Health Origano (HO) for Rp 55.000/unit (Include 10% VAT).[Job:HF]
[Category:YGK]
[4 marks]
05 Jan Raised purchase service to VEGAN HUT for Advertising (Acc#: 6-2010) amount Rp
2015 1.188.000 (Include VAT 10%)on COD terms. Bill was received (PO#: P-150002, Supplier
Inv#: VH-150001)[Job: SV] [Category :JKT]
[4 marks]
Payment to VEGAN HUT from Cheque Account [Cheque No: D-150001] with total
amount Rp 1.188.000 for bill on 05 Jan 2015
[4 marks]
06 Jan Return 2 unit of Health Origano (HO) for Rp 55.000 (Include 10% VAT) to GO VEGE,
2015 (PO#:P-150003, Supplier Inv#: GV-150001). Edit Journal Memo with “Purchase Return;
GO VEGE”. [Job: HF][Category: YGK].
[2 marks]
Immediately applied the Return-Debit note to Trade Creditors balance for, GO
VEGE[ID#:P-150003] for bill on 3 Jan 2015 [2 marks]
09 Jan Sold the following items to HEALTHY GO on Net 20 after EOM terms (Inv#: S-150001,
2015 Cust PO#: HG-150001). All the goods & Invoices was Received:
Ship 15 unit of Vegan Burger (VB) Rp 25.000,-/unit(Exclude 10% VAT) [Job: FF]
Ship 5 unit of Health Soup (HS) Rp 40.000,-/unit (Exclude 10% VAT) [Job: HF]
Ship 7 unit of Vege Pizza (VP) Rp 50.000,-/unit (Exclude 10% VAT) [Job: FF]
[Category: TGR] [Salesperson: MERRY] [4 marks]
10 Jan Sold 12 Units of Health Origano (HO) Rp 66.000,- /unit (Include 10% GST) to Mrs. DEVA
2015 on Net 10 days term (Inv#: S-150002, Cust PO#: MD-150001) All the goods & Invoice was
received. [Salesperson : DELSI] [Job : HF] [Category : YGK]
[4 marks]
Full payment of Rp792.000 for invoice on 10 Jan 2015 was received from MRS. DEVA and
deposits to Cheque Account [ID#: R-150001].
[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 Accounting v19
12 Jan Issued Discount-Credit Notes to MRS. DEVA Rp 39.600 as Discount Given (Acc# 5-3000)
2015 (Inv#: S-150003, Cust PO#: MD-150001) and edit Journal Memo with “Sale DISCOUNT:
MRS. DEVA”. [Category: YGK] [Salesperson: DELSI]
[2 marks]
Immediately Pay Refund [Cheque No: D-150002] for the Rp 39.600 Discount-Credit
notes to MRS. DEVA from the Petty Cash.
[2 marks]
23 Jan Using Spend Money, to record expenses from Cheque Account Rp 5.500.000,- for Rent
2015 Rp 5.000.000,- and Telephone Rp 500.000,- [Cheque# : D-150003]. [Category: TGR]
[4 marks]
27 Jan Receive Money for total Rp240.000 to Cheque Account, for Rp300.000 as Interest
2015 Income with Rp60.000 Bank Charges [ID#: R-150002] [Category: TGR]
[4 marks]
5. Perform Bank Reconciliation for the month of 31 Jan 2015 for Cheque Account account. The
bank statement shows a balance of Rp194.344.000 on 31 Jan 2015.
[4 marks]
6. In addition to the transaction above, prepare a journal entry to record the depreciation on 31
Jan 2015, for the following asset categories [GJ#: G-150001] [Category:TGR] :
Bldgs & Imprvmnts Rp 250.000
Save as Monthly Recurring Transaction start from 28 Feb 2015 for those journal then Use
the Recurring to record depreciation journal for 28 Feb 2015 [GJ#:G-150003]
[Category:TGR].
[4 marks]
Prepare a journal entry to record the VAT Clearing [GJ#: G-150002] on 31 Jan 2015 for 31
Dec 2014 balance. [Category:TGR]
[4 marks]
7. On 31 Jan 2015, prepare adjust inventory to record Inventory Total Unit Cost Adjustment
[IJ#: I-150002] [Category : TGR] for:
Vege Pizza (VP) increased by Rp 10.000,- as 5-1000 Purchases [Job: FF].
Health Origano (HO) decreased by Rp 6.000,- as 5-1000 Purchases [Job: HF].
[4 marks]
8. Generate the following financial reports on 1 Jan – 31 Jan 2015 to PDF file format:
Profit & Loss [Accrual] Purchases & Payable Journal
Standard Balanace Sheet GST [Detail-Accrual]
Account Transactions [Accrual] Payables Reconciliation
Bank Reconciliation Report [Summary]
Sales & Receivables Journal
[4 marks]
9. 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]
10. From Company Data Auditor – Transaction Review for 1 Jan 2015 to 31 Jan 2015, there is a
“?” mark for Scan for Future Dated Transaction. Display it & Sent to PDF the reports.
[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 Accounting v19
11. Edit Recurring Transaction Template of Fixed Assets Depreciation for Bldgs & Imprvmnts to
Rp 300.000,- per month.
[4 marks]
12. Delete all transaction on 12 Jan 2015
[4 marks]
13. Generate and modify the Purchases & Payables Journal 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
