OFFICE ADMINISTRATION QUIZ WORKSHEET FORM 4_____ NAME: __________________________________

Answer ALL questions carefully.

1. State whether the following TWO documents are Debit or Credit Note in the blank spaces provided. (2 marks)

_______________________________
Novelty Sales Company
16 Town Street
Port of Spain
TRINIDAD
Tel: 932 9541 Email: [email protected]
Fax: 932 5814 Website: www.novelties.com.tt

TO: Bits and Pieces Invoice no: 12/690

20 Country Road Note no: 34
Port of Spain Date: 6 March, 2012
TRINIDAD

Quantity Description Price Amount

2 packs Postcards -Caribbean Selection $10.00 $20.00
(missing from Original invoice)
TOTAL $20.00

__________________________________
Novelty Sales Company
16 Town Street
Port of Spain
TRINIDAD
Tel: 932 9541 Email: [email protected]
Fax: 932 5814 Website: www.novelties.com.tt

TO: Bits and Pieces Invoice no: 12/650

20 Country Road Note no: 163
Port of Spain Date: 20 March, 2012
TRINIDAD

Quantity Description Unit price Amount

3 Boxes of 6” Caribbean Views $6.00 $18.00
Coffee mugs (boxes damaged and
Mugs broken)
TOTAL $18.00

HIGHLIGHT THE CORRECT ANSWER IN RED.

2. Deductions from gross pay to produce the net pay (IV) Union subscription
figure usually include:
(I) Income tax (A) I, II and IV only (B) I, III and IV only
(II) National insurance (C) II, III and IV only (D) All of the above
(III) Cost of travel to work
 5. Financial institutions that offer savings accounts to
customers are:
3. The document you receive that states the pay you have (I) Central banks
received is (II) Commercial banks
(A) a time card (B) a payroll (III) Credit unions
(C) a pay slip (D) a payment note (IV) Investment companies

4. What is the main reason for crossing a cheque? (A) I and II only (B) II and III only
(A) to make sure the right person receives it (C) II and IV only (D) III and IV only
(B) to make sure it is paid into the right person’s
account 6. The documents that you need in order to carry out a
(C) to make sure it is easy to read bank reconciliation statement exercise are:
(D) to make sure it is not stale dated
_______________________________________________
_______________________________________________

QUESTION 7
Gmaxx is a large wholesale company. On 6 th January, 2010 Brands Inc. of 7th Bath Street, Gaston, Nevis, ordered 2000
Shore high grade CDs at $5.00 each, and 100 2.0 flash drives at $20.00 each. Gmaxx is offering a cash discount of 12% for
all accounts settled within 20 days. The net amount of the invoice is due in 30 days of billing.

( I ) Use the form provided to complete the invoice to reflect the sales transactions. (7 marks)

( II ) If the debt is paid by 17 January, 2010, how much will Brands Inc. be expected to pay? (1 mark)

________________________________________________________________________

( III ) How much should Brands Inc. pay if the debt is settled by 30 th January 2010? (1 mark)

________________________________________________________________________

ANSWER SHEET FOR PART ( I )

GMAXX 13 Craig Hall, St. Kitts W.I. Tel. 1-869-333-4000. Email: [email protected]
Where all items are for less and the only reduction is in the price
----------------------------------------------------------------------------------------------------------------------------------------
INVOICE
Brands Inc. Invoice No. 0683
7 Bath Street Terms: 12% - 20 days
Gaston, Nevis 8 January 2010

Customer Order No.: 4412

Quantity Description Unit Price Amount

QUESTION 8
(A) Assume that you are Bena Wills. You have a chequing account at the Sea Front Commercial Bank. On 3 January 2010,
you received the following statement from the bank.

Sea Front Commercial Bank

St. John’s, Antigua

In account with
Ms. Bena Wills SFCB
Jolly Beach Road
St. John’s, Antigua
BANK STATEMENT

ACCOUNT # 6205011871 Personal

Beginning Balance
As of 01/12/2009 3, 725.30

Deposits and Other Credits 3, 202.05

Cheques and Other Debits 1, 680.10

Ending Balance as of
31/12/2009 5, 247.25
TRANSACTION INFORMATION
___________________________________________________________________________________
Date Cheque # Description Amount Balance
---------------------------------------------------------------------------------------------------------------------------------------
12/12/09 ABM POS Debit 100.10 - 3, 625.20

13/12/09 Salary from King’s Bank 3, 200.00 6, 825.20

17/12/09 Standing Order – Core Life 75.00 - 6, 750.20

17/12/09 Teller Withdrawal 1, 500.00 - 5, 250.20

20/12/09 Maintenance Fee 5.00 - 5, 245.20

27/12/09 Interest Credit 2.05 5, 247.25

----------------------------------------------------------------------------------------------------------------------------------------
Head Office – 9 – 12 Muttel Place, St. John’s, Antigua, W.I. Tel: 1 (268)346-9745, Email: [email protected]
Website: www.seafront.com

Key to Abbreviations used:

ABM Automated Banking Machine

POS Point of sale

QUESTIONS

All entries on the bank statement were correctly entered in your records.

On the form provided, use the information on the bank statement in questions ( I ) and ( II ) above to prepare a Bank
Reconciliation Statement as at 31 December 2009 to reconcile the balance as shown in your personal records. (5 marks)

ANSWER SHEET

BANK RECONCILIATION STATEMENT 3 JANAURY 2010

Balance shown on statement 31 December 2009 $ 5, 247.25

Less unpresented cheques:

Cheque to J. Morres & Co. Ltd. (bank not aware) _____________________

Adjusted Balance

Plus: deposits not yet recorded by bank:

31 December (Bank not aware) _____________________

Balance as per personal records

QUESTION 9
Assume that you work in the accounts department of Fores Construction Company. Your duties include preparing
statements of accounts. The account of Charters Equipment of 36 Hades, Park, Anguilla, showed the following
transactions for the month of December.

Purchase on December 12 amounted to $1 270. 00

Purchase returns on December 15 were $ 760.00
A cheque was received on December 18 for $1 104.55

The statement number was 5732 and the brought forward balance on December 02 was $655.25.

Use the form provided to prepare a statement of accounts to be sent to Charters Equipment Company.
(9 marks)

ANSWER SHEET

STATEMENT
No. 963
Fores Construction
Fores Park
Antigua
DATE:

NUMBER:

TERMS:

TO:

DATE DETAILS DR CR BALANCE

QUESTION 10
Walter James is an employee of Singh Song Company. His weekly payroll information is given in Table 1
below.

TABLE 1: PAYROLL DATA FOR WALTER JAMES

Employee Hourly rate Basic hours Overtime hours Commission National

pay worked (paid at time earned insurance
and a half) deducted

Walter James $10.00 40 5 hours $50.00 5%

( I ) Use this information to calculate Walter James’ weekly

a) gross pay _______________________________

b) net pay _______________________________ (6 marks)

( II ) Use the form, provided as an insert, to prepare the weekly cheque for Mr. Walter James. (3 marks)

ANSWER SHEET

Golden Bank, Antigua _________________________________

Pay to
The order of _________________________________________________ $

The sum of ______________________________________________________ Dollars

Johanna Bravo
123456789 007897-749302039-999
 QUESTION 11
You are Seeta Roopria, petty cashier, who has been handling small cash transactions for the marketing
division of the Starlet Electrical Company, J48 Taylor Drive, Belmont, St. Kitts.

Use the Petty Cash Book form provided to record the following information. You are required to balance
the book and restore the imprest on June 01. (12 marks)

May 01 Petty cash brought forward $300.00

May 06 Paid postage – PCV #1 $20.00

May 08 Bought stationery – PCV #2 $10.00
May 09 Paid travel expenses – PCV #3 $30.00
May 11 Paid office expenses – PCV #4 $25.00
May 13 Paid window cleaner – PCV #5 $40.00
May 15 Bought sundry items – PCV #6 $30.00
May 21 Paid for small office supplies – PCV #7 $35.00
May 22 Bought stamps – PCV #8 $10.00
May 24 Paid for steno pad – PCV #9 $15.00
May 31 Paid taxi fare – PCV #10 $20.00

ANSWER SHEET
RECEIPTS AND PAYMENTS ANALYSIS OF PAYMENTS
Imprest $ Date Details Voucher # Payments Postage Fares Cleanin Stationery
2013 g
120 1 May To imprest
 QUESTION 12
TMBT Enterprise is a newly established wholesale company which specialized to manufacturing and
exporting trendy men, women and children’s polo shirts globally. Frank and James Enterprises, Port of
Spain, Trinidad, issued the following order two weeks ago.

ORDER
TO: TMBT Enterprises
High Street
Greenfield
St Vincent 23 June 2014

Please supply the following: COD

QUANTITY DESCRIPTION UNIT PRICE

20 boxes Ladies’ polo (black and red) $210.00
10 boxes Men’s polo (green and brown) $250.00
5 boxes Boys’ polo (white only) $100.00
10 boxes Girls’ polo (pink and purple) $120.00

Order carries a 15% VAT charge on the subtotal

The goods are ready for shipment. Terms and conditions are stipulated as cash on delivery and errors
and omissions excepted.

Use the form, provided as an insert, to calculate and write the required information on Invoice #7. Use
today’s date. (9 marks)

ANSWER SHEET

INVOICE
Invoice To: _____________________________ From: __________________________________

_____________________________ __________________________________

_____________________________ __________________________________

Date: _____________________________ Invoice no: ______________________________

QUANTITY DESCRIPTION UNIT PRICE TOTAL

 QUESTION 13
The following are bank statement and cash book as at April 1.

BANK STATEMENT
Date Particulars Debit Credit Balance

1 March 2013 Balance b/f $300.00

12 March M. Mark $80.00 $220.00

20 March Deposit $500.00 $720.00

CASH BOOK
Date Particulars Fol Bank Date Particulars Fol Bank

1 March 2013 Balance b/d $300.00 23 March 2013 A. Vince $80.00

27 March K. Baker $500.00 27 March O. Moore Cheque 12945 $100.00

27 March Balance c/d $620.00

$800.00 $800.00

1 April Balance b/d $620.00

Use the bank statement and cash book to prepare the bank reconciliation statement starting with the
bank statement balance of 1 March 2013. Cheque No. 12945 had not yet been presented to the bank.
(5 marks)