Question: Task 1 - Practical exercise Complete the following tasks: Process transactions Refer to the list of transactions Appendix A on the following pages. You are

Task 1 - Practical exercise Complete the following tasks: Process transactions Refer to the list of transactions Appendix A on the following pages. You are required to process these transactions in accordance with the policies and procedures of the organisation. As part of the processing you will be required to carry out the following tasks: a) Prepare Invoices, Adjustment Notes, Receipts, Statements, Cheques, Cheque Requisitions and Remittance Advices as requested. These documents are in the Templates provided - spreadsheet tab named "Source Docs - AT1" for the transactions listed in Appendix A. b) Prepare all General Journals for these transactions Use the Templates provided - spreadsheet tabs named as follows:- ??? Source Docs - AT1 ??? Journals - AT1 Note that you will NOT be using the tabs named "Subsidiary Ledgers - AT2" and "AR & AP Schedules - AT2" until Assessment 2. c) As per Transaction 5 on 7/06/2023, (Appendix A), S Golden has approved the extra discount taken. They have instructed you to send an email regarding the incorrect calculation of Discount and to notify Teamwell of the correct discount percentage for future payments. See the Account Balance in Appendix B. Present your email below (not in aAppendix A

Transactions

No Date Details $
1 4/6/2023 Received invoice no. 000158 from Logan Motors for repairs to a delivery vehicle $255.00 incl GST
2 5/6/2023 Paid part of the outstanding balance of Raptor Supplies invoice no. 365. Amount paid was $3,000, using cheque no. 2150. Prepare the cheque requisition, and a remittance advice to go with the cheque. $3,000.00
3 6/6/2023 Invoice no. 468 received from Raptor Supplies for purchases of goods for sale. Freight included - $198.00 incl GST $8,634.00 incl GST
4 6/6/2023 Issued invoice no. 7278 to Top Tier for credit sale of Catering. Delivery included is $33 incl GST. Prepare this invoice. $3,327.60 incl GST
5 7/6/2023

Received cheque from Teamwell in full settlement of balance owing. (Chq details are no. 154368, Big Bank, Other branch) Prepare receipt number 725 which shows the discount taken.

Is this correct calculation for Discount - see the amount owing in Appendix Band the procedures? S Golden has told you to let them pay this amount as is as full payment of the Invoice.

$9,894.00
6 9/6/2023 Issued invoice no. 7279 to Teamwell for credit sale of Catering. Delivery included is $33 incl GST. Prepare this invoice. $14,978.40 incl GST
7 12/6/2023 Issued invoice no. 7280 to Mark Money for credit sale. Delivery charge included is $33 incl GST.Prepare this invoice $934.20 incl GST
8 13/6/2023 Mark Money decided to settle his account, and paid via cheque. Prepare receipt. No discount to be given.
9 13/6/2023

Received payment of invoice 7278 from Top Tier. They took discount with these payments. Prepare receipt no. 727 for this customer. Is this correct calculation for Discount - see the amount owing from Transaction 4and the procedures?

$3,244.41
10 15/6/2023 Received invoice no. 005 from the cleaners, Bright & Shiny Ltd. This was for the period 1 June 2023 to 30 November 2023. $13,200.00 incl GST
11 15/6/2023

Mark Money returned goods originally purchased on 12/6/23. Prepare adjustment note no. 151and pay the refund immediately using cheque no. 2151. Prepare a remittance advice andthe cheque requisition to go with the cheque.

Note: You should record 2 x GJ's for this question. Record the return of goods in your first GJ and the issue of the refund cheque as the 2nd GJ entry.

$75.00 incl GST
12 19/6/2023 Issued invoice no. 7281 to new customer Pinker Products for credit sale. Delivery charge included is $33 incl GST. Prepare inv. 7281. $9,000.00 incl GST
13 20/6/2023 Paid Logan Motors with cheque no. 2152. Prepare a remittance advice andthe cheque requisition to go with the cheque. $255.00
14 30/6/2023 Prepare a statement for Teamwell

Appendix B

Subsidiary Ledger Balances

Accounts Receivable Invoice Details

1-2100 Teamwell $10,200 Inv no. 7275, 25/05/23

1-2110 Delightful Diner $ 1,680 Inv no. 7252, 05/05/23

1-2120 James and Sons $ 5,400 Inv no. 7253, 7/04/23

1-2130 First Class Events $ 600 Inv no. 7268, 15/03/23

Total $17,880

Accounts Payable Invoice Details

2-2011 Raptor Supplies $11,310 Inv nos. 365 18/05/23 $9,120

& 378 28/05/23 $2,190

2-2012 Oasis Suppliers (account in

dispute - waiting for credit note) $ 210 Inv no. April A/c, 8/04/23

Total $11,520

Appendix C

Customer Contact List

Customer Name Contact person Address ABN
Delightful Diner Elizabeth Highland 1 The Grove, North Side, QLD, 4111 98 527 756 693
First Class Events Manager 55 Freshwater Place, Freshwater, QLD, 4200 91 817 413 332
James and Sons Jimmy James 65a Cobbler Cove, Rhinestone, QLD, 4178 81 249 887 348
Mark Money Simone Hobb 1 Bearle Road, Brisbane, QLD, 4000 33 051 775 556
Pinker Products Vijay Singh 78 Landhigh Crescent, Rodeoville, QLD, 4277 90 000 444 502
Teamwell Tim Robbins 12 Beauty Lane, Brisbane, QLD, 4000 12 055 002 951
Top Tier Tony Black 752 Berret Road, Bracken Hill, QLD, 4022 36 969 369 369

Supplier Contact List

Customer Name Contact person Address ABN
Bright and Shiny Ltd Andy Captain 42 Hotpot Drive, Signpost View, QLD, 4369 79 654 321 858
Logan Motors Leigh Mantel 74 Highstep Lane, Payville, QLD, 4287 66 369 874 412
Oasis Suppliers Bernadette Cooper 998a Lighthouse Road, Lightside, QLD, 4999 46 528 724 346
Raptor Supplies Ralph Rich PO Box 95, Marsden, QLD, 4234 65 111 123 453

Appendix D

Chart of Accounts

1-0000 Assets

1-1000 Current Assets

1-1100 MyBank Cheque Account (BSB:111-111 Acc no: 88888888)

1-1160 Petty Cash

1-2000 Accounts Receivable Control

1-3000 Inventory

1-4000 Prepaid Expenses

1-5000 Non-Current Assets

1-5100 Equipment at Cost

1-5200 less Accum Dep Equipment

1-5300 Truck at Cost

1-5400 less Accum Dep Truck

2-0000 Liabilities

2-1000 Current Liabilities

2-2000 Accounts Payable Control

2-3000 GST Liabilities

2-3010 GST Collected

2-3030 GST Paid

2-5000 Payroll Liabilities

2-5010 PAYG Withholding Payable

2-5020 Superannuation Payable

2-5500 Accrued Expenses

2-6000 Non-Current Liabilities

2-6100 Bank Loan - Truck

3-0000 Equity

3-1000 Capital, S Golden

3-2000 Drawings, S Golden

4-0000 Income

4-1000 Sales

4-4000 Delivery Charges

4-5000 Interest Income

4-6000 Other income

4-7000 Profit/Loss on Disposal of Assets

5-0000 Cost of Sales

5-1000 Purchases

5-4000 Freight Paid on Purchases

6-0000 Expenses

6-1000 Advertising

6-1100 Truck Expenses

6-2000 Bank Charges

6-2100 Bad Debts Expense

6-2200 Discount Expense

6-2300 Interest Paid

6-2400 Rounding and Adjustments

6-3000 Insurance

6-3100 IT Support

6-3200 Depreciation Expense

6-3300 Admin Expenses

6-3350 Postage

6-3400 Telephone Expense

6-3550 Stationery

6-4000 Rent

6-4100 Cleaning

6-5000 Superannuation Expense

6-5100 Wages & Salaries Expense

6-5200 Staff Amenities

7-000 Trading and Profit & Loss

7-1000 Trading Account

7-2000 Profit & Loss Account

  1. End of Assessment
Gold Catering - Source Documents You will complete ALL source documents, you will not need to create any additional documents.
Refer to Appendix C for addresses and ABN details for invoices.
Invoices & Adjustment Notes Receipts & Remittance Advice Cheque Requisition Statement of Account
Gold Catering Gold Catering Gold Catering Cheque Requisition Gold Catering Statement for June 2023
15 Buckjumper Ave Tax Invoice Number: 158 15 Buckjumper Ave Receipt Number: 15 Buckjumper Ave Cheque Number: 15 Buckjumper Ave
Rodeocity QLD 42777 Rodeocity QLD 42777 Rodeocity QLD 42777 Rodeocity QLD 42777 Date:
ABN: 11 164 134 314 Date: 4-Jun ABN: 11 164 134 314 Date: ABN: 11 164 134 314 Date: ABN: 11 164 134 314
To: Received from: Paid to: To:
For: For:
Item Details Amount $ GST $ Amount $ Amount Received: Date Details Dr Cr Balance
(Ex GST) (Incl. GST) Amount of cheque:
- Discount included:
Invoice/s attached (Yes/No):
Authorised by:
Subtotal - - -
Gold Catering Gold Catering Cheque Requisition
Delivery Charges 15 Buckjumper Ave Receipt Number: 15 Buckjumper Ave Cheque Number:
Total including GST $ - Rodeocity QLD 42777 Rodeocity QLD 42777 Please pay by the end of the month Total including GST $ -
2.5% Discount if paid within 14 days! Amount of GST $ - ABN: 11 164 134 314 Date: ABN: 11 164 134 314 Date:
Received from: Paid to:
Gold Catering For: For:
15 Buckjumper Ave Tax Invoice Number:
Rodeocity QLD 42777
ABN: 11 164 134 314 Date: Amount Received:
Amount of cheque:
To: Discount included: $ -
Invoice/s attached (Yes/No):
Authorised by:
Item Details Amount $ GST $ Amount $
(Ex GST) (Incl. GST) Gold Catering Gold Catering Cheque Requisition
15 Buckjumper Ave Receipt Number: 15 Buckjumper Ave Cheque Number:
Rodeocity QLD 42777 Rodeocity QLD 42777
ABN: 11 164 134 314 Date: ABN: 11 164 134 314 Date:
Subtotal - - - Received from: Paid to:
For: For:
Delivery Charges
Total including GST $ -
2.5% Discount if paid within 14 days! Amount of GST $ - Amount Received:
Amount of cheque:
Discount included: $ -
Gold Catering Invoice/s attached (Yes/No):
15 Buckjumper Ave Tax Invoice Number: Authorised by:
Rodeocity QLD 42777
ABN: 11 164 134 314 Date:
Gold Catering Remittance Advice Cheque
To: 15 Buckjumper Ave Cheque Number:
Rodeocity QLD 42777 MyBank Cheque number:
ABN: 11 164 134 314 Date: Aspley QLD 4030
Date:
Item Details Amount $ GST $ Amount $ Paid to:
(Ex GST) (Incl. GST) For: Pay:
The sum of: $
Amount Paid:
Subtotal - - - Discount taken: $ - Drawer
Gold Catering Authorised Signature:
Delivery Charges
Total including GST $ - 2150 064 235 56987456
2.5% Discount if paid within 14 days! Amount of GST $ - Gold Catering Remittance Advice
15 Buckjumper Ave Cheque Number: MyBank Cheque number:
Rodeocity QLD 42777 Aspley QLD 4030
Gold Catering ABN: 11 164 134 314 Date: Date:
15 Buckjumper Ave Tax Invoice Number:
Rodeocity QLD 42777 Paid to: Pay:
ABN: 11 164 134 314 Date: For:
The sum of: $
To:
Amount Paid:
Drawer
Discount taken: $ - Gold Catering Authorised Signature:
Item Details Amount $ GST $ Amount $
(Ex GST) (Incl. GST) 2151 064 235 56987456
Gold Catering Remittance Advice MyBank Cheque number:
15 Buckjumper Ave Cheque Number: Aspley QLD 4030
Rodeocity QLD 42777 Date:
Subtotal - - - ABN: 11 164 134 314 Date:
Pay:
Delivery Charges Paid to:
Total including GST $ - For: The sum of: $
2.5% Discount if paid within 14 days! Amount of GST $ -
Amount Paid: Drawer
Gold Catering Authorised Signature:
Gold Catering Discount taken: $ -
15 Buckjumper Ave Adjustment Note Number: 2152 064 235 56987456
Rodeocity QLD 42777
ABN: 11 164 134 314 Date:
To:
Item Details Amount $ GST $ Amount $
(Ex GST) (Incl. GST)
-

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!