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
- 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
Get step-by-step solutions from verified subject matter experts
