Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started