60.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer