Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the following information from the Durable Trading Pty Ltd and prepare The petty cash book in MS Excel file available in e-Learning Assessment 2

Using the following information from the Durable Trading Pty Ltd and prepare The petty cash book in MS Excel file available in e-Learning Assessment 2 Assignment template file.

Record the following transactions in the petty cash book

30/04/2016 Issued cheque no. 536 for $150.00 to establish the petty cash fund

Petty cash transactions have occurred for the current month. Total the columns in the petty cash book to determine total expenditure.

Determine the amount of the reimbursement.

Date

Voucher No.

Details

Amount $ (inc. GST)

GST $

1/4/2016

203

Taxi fare

34.00

3.10

3/4/2016

204

Coffee

15.00

1.35

4/4/2016

205

Stamps

45.00

4.10

6/4/2016

206

Pens

4.50

0.40

8/4/2016

207

Biscuits

8.35

0.75

11/4/2016

208

Newspapers

3.50

0.32

14/4/2016

209

Taxi fare

23.00

2.10

Student ID: __________________ Student Name____________________
Task 1
Managing the Petty Cash System
Petty Cash Book of Durable Pty ltd.
Receipts Date Voucher No. Details Payments Travel Postage Stationery Sundries GST Paid
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Balance C/D
Reimbursment

Task 2

Batch and match the following transaction with the suitable heading. Your company has a policy to record the transaction according to the items of the transactions.

Commission received $500

Cash sales $15000

Purchase inventory from ABC& Company on cash $5000

Commission received from X & suppliers $ 350

Cash sales to Mr. Xu $ 5000

Loan from National Bank Australia $25000

Loan from XYZ Finance Company $ 65000

Cash Collected from Debtors $ 550

Commission paid $250

Cash collected from Miss Money $ 1000

Furniture sold on cash $ 25000

An old computer sold on cash $350

Received discount $ 950 from Mr. Anna as your organisation is a regular client of his business.

Rent collected for the current month $ 2500

Cash collected from Richard Business House, a debtor $ 14000 and given $1000 discount as it paid the dues as per a understanding.

Miss John, a regular party has deposited cash advance, and she will collect the goods from your organisation next month.

KEY:

Batching Category: 1) Sale Journal, 2) Cash Payments Journal, 3) Cash Received Journal, 4) Purchase Journal

Account classification: 1) Income 2) Expense 3) Asset 4) Liability

Account classification

..

..

..

..

..

..

..

..

..

..

..

..

..

..

..

..

Batching Category Batching Category

..

..

..

..

..

..

..

..

..

..

..

..

..

..

..

..

Task 3: Posting to General Journal

To complete this assignment, you will need to enter the following transactions and communicate your manager (Trainer) for approval on these journals for April 2016 into General journal.

Process the journal entries for the following transactions in the Journal worksheet provided.

[Hint] Total debits and credits are $14,330.00

Date

Details

Amount (inc.GST where applicable)

2/4/2016

Durable Pty Ltd receives a cheque (no 683) from Perth News. The cheque is attached to a remittance advice that refers to invoice 1638 issued by Durable Pty Ltd in 12/4/06. Perth News is paying the balance of its account.

650.00

3/4/2016

Durable Pty Ltd issues Invoice 1692 and stock to News Plus relating to its order dated 14/4/05 for magazines

1025.00

3/4/2016

Stock Couriers sends Invoice 12204 to Durable Pty Ltd requesting payment for the previous months delivery

465.0

5/4/2016

News Plus Contacts Durable Pty Ltd as it has been incorrectly charged. Durable Pty Ltd issues an adjustment notice (no. 54) to News Plus for the incorrect amount on Invoice 1692 issued 3/4/2016.

65.00

7/4/2016

Durable Pty Ltd receives Invoice 1224 from Office World for office furniture received on 30/4/06.

2500.00

9/4/2016

Durable Pty Ltd issues cheque no 533 to Hibberd & Co for automatic monthly rent payment for its rented warehouse premises.

1050.00

9/4/2016

Durable Pty Ltd receives a cheque (no. 7542) from News Plus to pay the balance of its account.

960.00

20/4/2016

Durable Pty Ltd receives 750 copies of NERO (stock) from Nero Publishing along with Tax Invoice 887.

2250.00

20/4/2016

Durable Pty Ltd paid Office World via cheque no 534 to pay Invoice no 1224

2500.00

20/4/2016

Durable Pty Ltd paid Stock Couriers via Visa Credit card to pay the balance of Invoice no. 12204.

465.00

20/4/2016

Durable Pty Ltd paid Nero Publishing via cheque 535 to pay Tax Invoice 887.

2250.00

31/4/2016

The Senior Accounts Officer authorises the drawing of cheque 536 to create a petty cash impress (sufficient to cover the next fortnights expenditure from the Petty Cash.)

150.00

Assignment 2, Task 1 Date:________________
Entering Transactions into a General Journal of Durable Pty Ltd
General Journal
Date Details Folio Debit Credit

Task 4 Posting to the General Ledger

At the end of each month, you are required to post the journal entries to the general ledger. Complete the following tasks for Durable Pty Ltd:

Post the journal entries to the general ledger accounts in the Ledger worksheet.

Total each of the account balances in the General ledger?

Student ID: __________________ Student Name____________________
Assignment 2, Task 2
Posting to the General Ledger
Durable Pty Ltd
LEDGERS Accounts
Date Details Account Number Folio Debit Credit Balance $
$0.00 $0.00

Task 5 Prepare a Trial Balance

Prepare a Trial balance in the Trial Balance worksheet for all active general ledger accounts for the month ending 30th April 2016 for Durable Pty Ltd. (Hint: Total debits and credits are $6474.10)

Student ID: __________________ Student Name____________________
Assignment 2, Task 3
Prepare a Trial Balance
TRIAL BALANCE for New Leaf company
as at 31/05/2006
Account Name Debit Credit
$0.00 $0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Benefit Analysis Concepts And Practice

Authors: Anthony E. Boardman, David H. Greenberg, Aidan R. Vining, David L. Weimer

3rd Edition

0131435833, 978-0131435834

More Books

Students also viewed these Accounting questions

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago

Question

What are the steps in the T&D process?

Answered: 1 week ago

Question

Define training and development.

Answered: 1 week ago