ABSS Qualification Test

SINGLE CURRENCY (ABSS Accounting v25)

Please fill your data:

Full name :

Place & Date of Birth:

Phone number :

Email :

Comment:

Code: L1-191122-AM-01-
Effective from 22 Nov 2019

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.
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)

ABSS Qualification Test Single Currency

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 ABSS Accounting v25 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 hard disk. Please save your .MYO, backup
folder, and report folder in this folder and the folder will be collected from
hard disk 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 Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)
The Case Study
Based the fact given, you are required to:

1. Setup the Company data file : [2 marks]

1A Mrs. Luly is the owner of the company “Pieter Lim”.

Setup the following information:
Company Address : Jl. Srigunting Raya no. 1 Bandung
Tel : 022 – 157 610
Fax : 022 – 157 611
Email : [email protected]
Mrs. Luly decided to use ABSS Accounting v25 software for preparing her company 1
January to 31 December 2019 Financial Year Reports and prefer to use the 13th
accounting period for the audit trial adjustment.

1B
As Hairdresser business type. Hairdresser is someone who specializes in cutting,
colouring and styling hair in order to enhance or maintain a person's appearance.

Please use one of the account list provided by ABSS Accounting v25.
So you don’t need to set up the account list completely.
[2 marks]

1C 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 [System-
Wide]”
 Sales Preferences : Tick the option for : “Warn for Duplicate Invoice
Numbers on Recorded Sales [System-Wide]”
 Purchases Preferences : Tick the option for : “Warn for Duplicate
Purchase Order Numbers on Recorded Purchases
[System-Wide]”
 Security Preferences : Click User IDs to add new User ID as your Name.

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

2. Setup the List below:

Setup the following Account List [2 marks]

2A - 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

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)

- The Company changes some accounts as follows :

 1-2110 Cheque Account, change to Bank
 1-2140 Petty Cash, change to 1-2120

- The Company need to add the following accounts :

 2-2340 VAT Clearing

2B Setup the Tax Code List for VAT (Value Added Tax), Tax Type: Value Added Tax with
Rate: 10%. [1 marks]

2C Setup the Job List : PD for Product & SV for Service. [1 marks]

2D Setup the Categories List : BDG for Bandung, SLO for Solo, SBY for Surabaya
[1 marks]

2E Setup the following Cards List: [1 marks]

Customer PHIE SALON SHINJUKU TAWI SALON
Supplier ROB PEETOM TRIBECA RETREAT THE PARLOUR
Employee HAKAN ALVARO -
Last Name : <Your Name>
Address : <Your Place, Date of Birth>
Personal
Phone #1 : <Your Phone Number>
Email : <Your Email Address>

2F Setup the Items List as follows: [2 marks]

Item No. HT OC HC NT

Item Name HAIR TREATMENT OMBRE COLOURING HAIRCUT NAIL TREATMENT

Selling Price Rp1,299,000.- Rp1,190,000.- Rp200,000.- Rp890,000.-

Tax Code
When N-T N-T N-T N-T
Bought/Sold
Selling Unit
Unit Unit Unit Unit
of Measure

I Buy This 5-1000 Supplies- 5-1000 Supplies- 5-1000 Supplies-

-
Item Puchases Puchases Puchases
I Sell This 4-1400 Hair 4-1400 Hair 4-1300 Novelty
4-1100 Hair Cuts
Item Products Products Items

I Inventory
1-2300 Inventory 1-2300 Inventory - 1-2300 Inventory
This Item

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)
3. Setup Account Opening Balance information as of 01 January 2019: [2 marks]

3A

3B Setup the customer ending balance as 31 Dec 2018: [2 marks]

Customer Name PHIE SALON SHINJUKU TAWI SALON

Total Rp3,960,000.- Inc. VAT Rp6,050,000.- Inc. VAT Rp1,123,100.- Inc. VAT
Invoice# AR-18001 AR-18002 AR-18003
Cust. PO# PS-180001 SH-180001 TS-180001
Category BDG SLO SBY

3C Setup the supplier ending balance as 31 Dec 2018: [2 marks]

Supplier Name ROB PEETOM TRIBECA RETREAT THE PARLOUR
Total Rp4,455,000.- Inc. VAT Rp5,637,500.- Inc. VAT Rp2,392,500.- Inc. VAT
PO# AP-18001 AP-18002 AP-18003
Supp. Inv# RP-180001 TR-180001 TP-180001
Category BDG SLO SBY

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)
3D Setup the following inventory opening balance as 01 January 2019 [Journal#: INV-1901]
[Category: BDG]: [2 marks]

Item No. Item Name Qty Unit Cost Account#

HT HAIR TREATMENT 18 Units Rp919,000.- 1-2300
NT NAIL TREATMENT 10 Units Rp667,000.- 1-2300
OC OMBRE COLOURING 24 Units Rp988,900.- 1-2300

4. The following transactions are made in January 2019. Record these transactions in ABSS
according to the dates and details given below.

4A 03 A purchase was raised to purchase the following inventory item from main POINT
Jan supplier, TRIBECA RETREAT, with Net 30 credit terms. (PO#:P-190001, Inv#:TR- [4 marks]
2019 190001). Bill and goods was received.
 Received 10 Units of HAIR TREATMENT (HT) for Rp919,000.-/Unit (Job : PD)
(Exclude 10% VAT).
 Received 7 Units of OMBRE COLOURING (OC) for Rp988,900.-/Unit (Job : PD)
(Exclude 10% VAT). [Category : SLO]

4B 04 Raised purchase service to THE PARLOUR for Shop Supplies (Acc#:6-4700) POINT
Jan Rp3,699,300.- (Include 10% VAT), with COD terms. (PO#: P-190002, Supplier [4 marks]
2019 Inv#: TP-190001). Bill was received. [Job: SV] [Category: SBY]

Payment to THE PARLOUR from Petty Cash [Cheque#: D-190001] with total
[4 marks]
amount Rp6,091,800.- with the following details Rp 2,392,500.- for bill 31 Dec
2018 and Rp3,699,300.- for bill 04 Jan 2019.

4C 08 Return 2 units of OMBRE COLOURING (OC) for Rp988,900.-/unit (Exclude 10% POINT
Jan VAT) to TRIBECA RETREAT (PO#: DN-19001, Supplier Inv#: TR-190001) (Job: [2 marks]
2019 PD). Edit Journal Memo with "Purchase Return; TRIBECA RETREAT". [Category :
SLO]
[2 marks]
Immediatelly Applied the Return-Debit Note to Trade Creditor balance for
TRIBECA RETREAT [ID#: DN-19001] for bill on 03 Jan 2019.

4D 10 Raised sale services to TAWI SALON for Blowdry as Miscellaneous Income (Acc#: POINT
Jan 4-8000) Rp1,232,000.- (Include 10% VAT) on Net 28 credit terms (Inv#: S- [4 marks]
2019 190001, Cust PO#: TS-190001). Invoice was delivered. [Job: SV] [Salesperson :
HAKAN] [Category : SBY]

4E 15 Sold the following items to PHIE SALON on COD terms (Inv#: S-190002, Cust PO#: POINT
Jan PS-190001). All the goods & Invoices was Received: [4 marks]
2019  Ship 5 Units of HAIR TREATMENT (HT) Rp1,299,000.-/unit (Exclude 10% VAT)
[Job : PD]
 Ship 5 Units of NAIL TREATMENT (NT) Rp890,000.-/unit (Exclude 10% VAT)
[Job : PD]
 Ship 10 Units of OMBRE COLOURING (OC) Rp1,190,000.-/unit (Exclude 10%
VAT) [Job : PD] [Salesperson : ALVARO] [Category : BDG]

Full payment of Rp25,129,500.- for invoice on 15 Jan 2019 was received from [4 marks]
PHIE SALON deposit to Bank [ID#: R-190001].

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)
4F 19 Issued Discount-Credit Notes to PHIE SALON Rp150,000.- as Discounts Given POINT
Jan (Acc#: 5-3000) (Inv#: CN-19001, Cust PO#: PS-190001) and edit Journal Memo [2 marks]
2019 with "Sale Discount: PHIE SALON". [Job: SV] [Category: BDG] [Salesperson:
ALVARO]

Immediatly Pay Refund [Cheque#: CN-19001] for the Rp150,000.- Discount- [2 marks]
Credit Notes to PHIE SALON from Bank.

25 Use Spend Money, transfer Rp6,091,800.- from Bank (Acc#:1-2110) to Petty POINT
4G
Jan Cash (Acc#:1-2120). [Cheque#: D-190002] [Category: BDG] [4 marks]
2019
29 Receive Money for total Rp523,600.- to Bank, for Rp557,000.- as Interest POINT
4H [4 marks]
Jan Income (Acc#: 8-1000) with Rp33,400.- Bank Charges (Acc#: 6-1200) [ID#: R-
2019 190002] [Category: BDG]

5. Perform Bank Reconciliation for Bank the Bank Statement shows a balance [4 marks]
5
Rp376,411,300.- on 31 Jan 2019.

6. Prepare journal entry to record the depreciation on 31 Jan 2019, for the [4 marks]
6A
following asset categories [GJ#:G-190001] [Category : BDG] :
 Shop Equipment Rp 10,000,000.-

Save as Monthly Recurring Transaction start from 28 Feb 2019 for those journal
then use the recurring to record depreciation journal for 28 Feb 2019 [GJ#:G-
190003] [Category : BDG]

6B
Prepare a journal entry to record the VAT Clearing journal on 31 Jan 2019 [4 marks]
[GJ#:G-190002] for Jan 2019. [Category : BDG]

7. On 31 Jan 2019, prepare adjust inventory to record Inventory Found [IJ# : INV- [4 marks]
7
1902] [Category : BDG] for :
 1 unit of NAIL TREATMENT (NT) Rp667,000.- [Job : PD] as 5-1000
Supplies-Puchases
8. Generate the following financial reports at 1 January – 31 January 2019 to PDF [4 marks]
8
file format, save in REPORTS folder :
 Account Transaction [Accrual]
 Standard Balance Sheet
 Income Statement [Accrual]
 Cash Disbursements
 Cash Receipts
 Reconciliation Report

9 9. From Company Data Auditor – Transaction Review for 1 Jan 2019 to 31 Jan [4 marks]
2019, there is a “?” mark for Scan for Future Dated Transaction. Display it and
send to PDF, save in REPORTS folder.

10 10. From Security Preference, Lock the Accounting period for 1 Feb 2019. BACKUP [4 marks]
your ABSS Company Data File (ONLY), Check Company File for Error and Save
the ABSS Company data backup file name as Your Name in Backup folder.

11 11. Delete all related transaction on 08 Jan 2019. [4 marks]

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id
 ABSS Qualification Test
Single Currency (ABSS Accounting v25)
12. Edit the Recurring Transaction Template of Fixed Assets Depreciation for Shop [4 marks]
12
Equipment to Rp11,000,000.- per month.

13. Generate and modify the report fields of Items Register [Detail] report like the [4 marks]
13
sample below and then save as PDF Format.

~End of Assignment~

PT. NET21PLUS
Menara Karya, Lt. 28, Jl. H.R. Rasuna Said, X-5, Kav. 1-2, Jakarta 12950. Indonesia.
Tel. : 021-5789 5812 | Fax. : 021-5789 5888
E-mail : [email protected] | Website : www.net21plus.co.id