Maintain Stock Group 2. Click New 3. Enter the stock group code and description 4. Click Save For this task, maintain the following stock groups: Stock Group Code Stock Group Description SG001 Stationery SG002 Paper SG003 Office Supplies ANSWER: Stock Maintain Stock Group New Enter the stock group code and description as stated in the question. Click save. Repeat the steps for the remaining stock groups. D2: Maintain Stock Item Stock Maintain Stock Item"> Maintain Stock Group 2. Click New 3. Enter the stock group code and description 4. Click Save For this task, maintain the following stock groups: Stock Group Code Stock Group Description SG001 Stationery SG002 Paper SG003 Office Supplies ANSWER: Stock Maintain Stock Group New Enter the stock group code and description as stated in the question. Click save. Repeat the steps for the remaining stock groups. D2: Maintain Stock Item Stock Maintain Stock Item">
SQLAccountWorkBook 5 (Answer Sheet)
SQLAccountWorkBook 5 (Answer Sheet)
SQLAccountWorkBook 5 (Answer Sheet)
[Date]
1
SQL Account Workbook 1
Contents
Create New Database..................................................................................................3
Setup Financial Start Period in SQL Account...............................................................4
Maintain Company Profile............................................................................................5
Task A : Chart of Account.............................................................................................7
Task B : Trade Debtors / Customers Maintenance......................................................9
Task C : Trade Creditors / Suppliers Maintenance....................................................11
Task D : Stock Group & Maintain Stock Item.............................................................12
D1 : Maintain Stock Group......................................................................................12
D2: Maintain Stock Item..........................................................................................13
Task E : Opening Balance..........................................................................................14
Task F: Daily Transactions in Daily Basis Task.........................................................21
Task G : Backup & Folder..........................................................................................61
[Date]
2
SQL Account Workbook 1
Mate Paper Supplies Sdn Bhd (Company Reg. No. 122533668794) is an office supply
company in Setia Alam. They bought & start using SQL Financial Accounting Software to
computerize their account from 1st of Jan 20YY.
[Date]
3
SQL Account Workbook 1
ANSWER:
Tools Options General Ledger
[Date]
4
SQL Account Workbook 1
ANSWER:
File Company Profile to fill in your address, attention, email and report header
[Date]
5
SQL Account Workbook 1
s
[Date]
6
SQL Account Workbook 1
GL Maintain Account
Maintain following accounts at chart of accounts:
Note : please read the remark column before create the following account
A/C Type A/C A/C Description Special Remark
Code Type A/C
Fixed 200-500 Land & Building -
Assets
Fixed 200-505 Accum Deprn – Land Accumulated -
Assets & Building Deprn. Acc
Current 310-001 Maybank Bank *Create this
Assets Account account under
Cash 310-000
Current 451-000 Interest Payable -
Liabilities
Current 452-000 EIS - Staff
Liabilities
Sales 500-000 Sales of Finished *Replace 500-000
Goods to Sales of Finished
Good
Sales 500-001 Sales of Semi- -
Finished Goods
Sales 500-002 Other Sales -
Cost Of 610-000 Purchases of Raw *Replace 610-000
Goods Material to Purchases of
Sold Raw Material
Cost Of 610-001 Purchase of Semi- -
Goods Finished Goods
Sold
Cost of 610-002 Other Purchases -
Goods
Sold
Expenses 925-000 EIS - Employer
Expenses 926-000 Legal & Professional -
Fees
Expenses 927-000 First Aid Kit & -
Medicine Supplies
Other 531-000 Rental Income -
Income
[Date]
ANSWER:
GL Maintain Account
Highlight on the orange color mother account, and create new button.
7
SQL Account Workbook 1
Insert the code, description, special account (if have) accordingly to the question.
[Date]
8
SQL Account Workbook 1
Note :
ANSWER:
Customer Maintain Customer New
[Date]
9
SQL Account Workbook 1
[Date]
10
SQL Account Workbook 1
ANSWER:
Supplier Maintain Supplier New
[Date]
Note : please assign FIFO costing method for all stock group.
Code Description Sales S/Rtrn C/Sales Purchase C/Purchase P/Rtrn
ANSWER:
Stock Maintain Stock Group New
[Date]
12
SQL Account Workbook 1
ANSWER:
Stock Maintain Stock Item New
13
SQL Account Workbook 1
GL Maintain Opening Balance Trade Debtor Select your Debtor & click on Debit
Column, & select Open Customer Invoice.
ANSWER:
GL Maintain Opening Balance Trade Debtor Select your Debtor & click on
Debit Column, & select Open Customer Invoice.
Then, Click on New, after select customer, insert document number, date & amount (make
sure after insert date, you see the past invoice wording)
[Date]
14
SQL Account Workbook 1
Below is detail outstanding statement from Eco Sungai Buloh Trading as at 31/12/20XX.
15
SQL Account Workbook 1
ANSWER:
GL Maintain Opening Balance Trade Creditor Select your Creditor & click on
Credit Column, & select Open Supplier Invoice
[Date]
Then, Click on New, select supplier, insert invoice number, date & amount (make sure see
the past invoice wording)
16
SQL Account Workbook 1
ANSWER:
GL Maintain Opening Balance Click on edit button Enter the Opening balances
accordingly
[Date]
17
SQL Account Workbook 1
18
SQL Account Workbook 1
ANSWER:
GL Bank Reconciliation | New | right click | Opening Bank Reconciliation
[Date]
19
SQL Account Workbook 1
[Date]
20
SQL Account Workbook 1
ANSWER:
QT-00002
[Date]
21
SQL Account Workbook 1
Both quotations immediately confirmed, please fully transfer both quotation to Invoice as
date same with quotation date.
ANSWER:
Sales | Sales Invoice | New | Right Click on the title “Sales Invoice” wording | Transfer
From Quotation | Tick on the quotation number according to the question.
[Date]
[Date]
23
SQL Account Workbook 1
F-2 : Received a Payment Voucher & cheque from Debtor (ABC Stationery Shop) send by
courier. Please record this into customer payment & knock off accordingly.
ANSWER:
Customer | Customer Payment | New , Select customer, insert date, choose received by
Maybank, insert cheque number, insert date, insert paid amt, tick (knock off) the invoice
as per question)
[Date]
24
SQL Account Workbook 1
F-3: Issue a Cash Sales for walk in Customer as below :
ANSWER:
CS-00001
When save, system will prompt out the payment dialog box, key in the paid amount and
choose the payment method Cash In Hand, then click OK
[Date]
25
SQL Account Workbook 1
F-4 : Ms.Yao is the purchasing department, she helps to order some item as below :
i.
Doc No Doc Date Supplier Description
PO-00001 15/02/20YY Pentel Malaysia 2000 units of Silver Blade
@ RM 0.80
4000 units of 2B
Sharpener @ RM 0.50
26
SQL Account Workbook 1
ANSWER:
ii. Pentel Malaysia send the goods partially on 20/02/20YY. Stock keeper informs
they had collected 1500 unit of Silver Blade and 4000 unit of 2B Sharpener on
[Date]
ANSWER:
27
SQL Account Workbook 1
Purchase | Goods Received | New | Right Click on the title “Purchase Order” wording | tick
on the purchase order according to the question.
iii. Ms.Yao had called Pentel Malaysia on 01/03/20YY to cancel order the balance of
500 unit from PO-00001. (PC-00001)
ANSWER:
[Date]
Purchase | Purchase Cancelled Note | New | Right Click on the title “Purchase Order”
wording | Transfer From Purchase Order | tick on the purchase order according to the
question.
28
SQL Account Workbook 1
iv. Eco Sg. Buloh Trading had sent the order PO-00002 on 30/03/20YY and attached
Invoice together. (GR-00002 & PI-00004)
ANSWER:
Purchase | Goods Received | New | Right Click on the title “Purchase Order” wording | tick
on the purchase order according to the question.
[Date]
29
SQL Account Workbook 1
Purchase | Purchase Invoice | New | Right Click on the title “ Purchase Invoice” wording |
Transfer From Goods Received | tick on the good s received according to the question.
[Date]
30
SQL Account Workbook 1
ANSWER:
Purchase | Purchase Invoice | New | Right Click on the title “ Purchase Invoice” wording |
Transfer From Goods Received | tick on the good s received according to the question.
[Date]
31
SQL Account Workbook 1
vi. Account Department has issue Maybank cheque for payment PI-00004 & PI-
00005 on 01/04/20YY, fully knocked off. (PV-00001 & PV-00002)
32
SQL Account Workbook 1
ANSWER:
Supplier | Supplier Payment | New | select supplier, insert date, choose payment by
Maybank, insert date, insert bank charges, insert paid amount, tick (knock off invoice
based on FIFO)
PV-00001
[Date]
33
SQL Account Workbook 1
F-5 :
i. On 16 Feb 20YY, ABC Stationery Shop send in their purchase order as below:
Doc Date Doc No Customer Item Required
16/02/20Y SO-00001 ABC Stationery A4 Paper – 100 unit @ RM 20
Y Shop (discount 10%)
2B Pencil Sharpener– 100 unit @
RM 1.50 (discount 10%)
[Date]
ANSWER:
SO-00001
ii. Calby, the sales manager order her staff to packing SO-00001 and deliver the
order by 20/02/20YY. However, when packing time, the staff told Calby that 50 of
the 2B Pencil Sharperner packaging spoilt, at last they only able to send 50 units
of 2B Pencil Sharperner to ABC Stationery Shop and 100 unit of A4 Paper, and
Calby decided to give a free gift to ABC Stationery Shop to make up the
relationship between customer. The free gift they given is 10 unit of 2B Pencil.
Please generate the Delivery Order (DO-00001) as situation above and attached
together with Invoice. (IV-00006) on 20/02/20YY.
ANSWER:
Sales | Delivery Order | New | Right Click on the title “Delivery Order” wording | Transfer
From Sales Order | tick on the sales order according to the question.
[Date]
35
SQL Account Workbook 1
DO-00001
36
SQL Account Workbook 1
iii. Insert the Sales Cancelled Note for balance from SO-00001 on 28/02/20YY. (CC-
00001)
ANSWER:
Sales | Sales Cancelled Note | New | Right Click on the title “Sales Order” wording |
Transfer From Sales Order | tick on the sales order according to the question.
37
SQL Account Workbook 1
iv. Fuzion Paper Sdn Bhd requested an urgent deliver. Please issue Delivery Order as
detail below.
Doc No Doc Date Customer Item Required
DO-00002 10/03/20Y Fuzion Paper Sdn Moulded Paper Pulp – 50 unit @
Y Bhd RM250 per unit
2B Pencil – 500 unit @RM 2.10 per
unit
2B Pencil Sharpener – 2000 unit @
RM 1.50 per unit
[Date]
38
SQL Account Workbook 1
ANSWER:
DO-00002
ANSWER:
Sales | Invoice | New | Right Click on the title “Invoice” wording | Transfer From Delivery
Order | tick on the delivery order according to the question.
[Date]
39
SQL Account Workbook 1
ANSWER:
Customer | Customer Payment | New , Select customer, insert date, choose received by
Maybank , insert cheque number, insert date, insert paid amt, tick (knock off) the invoice
as per question)
[Date]
vii. Unfortunately, the next day, ABC informed that the cheque they bank in forgot to
sign by another director, cheque bounced on 25/03/20YY.
40
SQL Account Workbook 1
ANSWER:
Customer | Customer Payment | look for OR-00002 & edit it | Right click on the blue color
“customer payment” wording | Bounced Status
Key in the bounced date & save (once save, the knock off for invoice will be automatically
untick)
viii. On 27/03/20YY, Fuzion Paper Sdn Bhd online transfer into Maybank RM 16550
fully knocked off IV-00007. (OR-00003)
*Remark “Online Transfer” at cheque no column.
ANSWER:
[Date]
Customer | Customer Payment | New , Select customer, insert date, choose received by
Maybank, insert cheque number, insert date, insert paid amt, tick (knock off) the invoice
as per question)
41
SQL Account Workbook 1
OR-00003
F6 : You received rental income from Mr Wai on 30/03/20YY, kindly maintain an official
receipt in cash book entry:
ANSWER:
GL → Cash Book Entry → New OR
Key in received from who according to question, insert date, choose gl code, key in amount
& save
[Date]
42
SQL Account Workbook 1
F-7 : ABC Stationery Shop redo another payment on 01/04/20YY, RM 65,000 by cheque
(PBB 89088) from ABC Stationery Shop and it knocked off the full amount of IV-00001,
IV-00003, IV-00004 and balance partially knocked off IV-00006.
ANSWER:
Customer Customer Payment New
Select customer, select received in Maybank, insert date, key in paid amount , tick (knock
off) the invoice.
F-9: Account department received the bank statement from Maybank on 01/04/20YY,
[Date]
43
SQL Account Workbook 1
ANSWER:
GL → Bank Reconciliation → New
Insert the bank statement date , choose the bank account, untick display period, key in
bank statement bank closing figure as per question, tick (do reconciliation) for all payment
/ receipt that cleared according to the bank statement
[Date]
44
SQL Account Workbook 1
F-10 : A payment made to Pentel Malaysia on 14/05/20YY. Below is a payment voucher
that issued (PV-00003).
ANSWER:
Supplier | Supplier Payment | New | select supplier, insert date, choose payment by
Maybank, insert date, insert paid amount, tick (knock off invoice based on FIFO)
PV-00003
F-11 : You withdraw RM 500.00 cash from Maybank for petty cash on 15/05/20YY.
[Date]
Enter Description as Cash Withdrawal and make sure your double entry is Dr. Cash
In Hand & Cr. Maybank
ANSWER:
45
SQL Account Workbook 1
F-12 : On 17/05/20YY, Plus Supply Sdn Bhd called Calby to deliver 100 moulded paper
pulp. (DO-00003)
ANSWER:
[Date]
F-13:
46
SQL Account Workbook 1
i. Winner Sdn Bhd had delivered 2000 units of 2B Pencil, 500 units of A4 Paper and
1000 units 2B Pencil Sharpener based on your Purchase Order (PO-00003), kindly
issue the Purchase Order and a Goods Received Note (GR-00003) on 18/05/20YY.
ANSWER:
Purchase | Goods Received | New | Right Click on the title “Purchase Order” wording | tick
on the purchase order according to the question.
[Date]
47
SQL Account Workbook 1
ii. Received the Invoice (PI-00006) from Winner Sdn Bhd on 18/05/20YY for GR-
00003.
ANSWER:
Purchase | Purchase Invoice | New | Right Click on the title “ Purchase Invoice” wording |
Transfer From Goods Received | tick on the good s received according to the question.
[Date]
48
SQL Account Workbook 1
iii. After store keeper checking, Mr.Muthu realized that there is 20 unit of 2B Pencil
broken, do a purchase returned to Winner Sdn Bhd on 20/05/20YY. (SC-00001)
ANSWER:
Purchase | Purchase Returned | New | Right Click on the title “Purchase return” wording |
Transfer From Purchase Invoice | Select PI-00006
[Date]
49
SQL Account Workbook 1
[Date]
50
SQL Account Workbook 1
F-14 :
i. Fuzion Paper Sdn Bhd request a quotation on 2 June 20YY for 50 unit of silver
blade for sharpener and 10 unit of A4 paper. Ms.Calby the sales manager agreed
to give 5% discount for both item. (QT-00003)
ANSWER:
ii. Fuzion Paper Sdn Bhd agreed with the quotation, they request for sending all the
order by 5 June 20YY. May prepare DO-00004 transfer from QT-00003 and
generate Invoice as well.(IV-00008)
ANSWER:
Sales | Delivery Order | New | Right Click on the title “Delivery Order” wording | Transfer
From Quotation | tick on the sales quotation according to the question.
[Date]
51
SQL Account Workbook 1
Sales | Sales Invoice | New | Right Click on the title “Invoice” wording | Transfer From
Delivery Order | tick on the delivery order according to the question.
[Date]
52
SQL Account Workbook 1
iii. On 16 June 20YY, you received a post dated cheque from Fuzion Paper Sdn Bhd,
kindly issue customer payment in your system. This payment is to knock off IV-
00002 and IV-00008.
[Date]
53
SQL Account Workbook 1
ANSWER:
Customer | Customer Payment | New , Select customer, insert date, choose received by
Maybank, insert cheque number, insert date, insert paid amt, tick (knock off) the invoice
as per question
OR-00006
Right Click on the blue customer “customer payment” wording | Set Posting Date
20/06/20YY
[Date]
54
SQL Account Workbook 1
[Date]
55
SQL Account Workbook 1
F-15: Kindly issue a payment voucher for below document & put the date as 30/06/20XX
(PV-00004) and cheque number: MBB 39878
ANSWER:
GL → Cash Book Entry → New PV
Key in Payment to who, insert date, select payment by CIMB Bank, choose gl Code, key in
amount & save.
F-17 : On 01/07/20YY, please fully transfer the Delivery Order into Invoice
Sales | Sales Invoice | New | Right Click on the title “Invoice” wording | Transfer From
Delivery Order | tick on the delivery order according to the question.
56
SQL Account Workbook 1
F-18 : Ms.Yong helped to buy First Aid Kit from NBC Pharmacy, please issue a payment
voucher to Ms.Yong for her monthly claim expenses on 30/08/20YY.
57
SQL Account Workbook 1
ANSWER:
GL → Cash Book Entry → New PV
Key in Payment to who, insert date, select payment by Cash In Hand, choose gl Code, key
in amount & save.
F-19: On 06/08/20YY, supplier Eco Sg. Buloh Trading agreed to offset the outstanding
[Date]
balances with the customer Plus Supply Sdn Bhd. Kindly record this transaction in the
system. The knock off document is based on First-in First-out basis. (CT-0001)
ANSWER:
Supplier → Supplier Contra → New
select supplier, insert date, insert contra amount, tick (knock off invoice)
58
SQL Account Workbook 1
ANSWER:
59
SQL Account Workbook 1
[Date]
60
SQL Account Workbook 1
Besides that, create a New Folder with name it as “NAME_StudentID”, and put all report
requested into the folder. Document checking list:
Backup File
ANSWER:
File →Backup Database → Click on the three dot button, select your location, click ok
[Date]
61
SQL Account Workbook 1
GL →Print Profit & Loss Statement → Put in Date 31/12/20YY→Choose This Year – 2
column Report and Apply
[Date]
62