Date Information 13/05/20XX BAC Commercial pays monthly rent of $2000 by EFT. 15/05/20XX The tenant (renter)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Date Information 13/05/20XX BAC Commercial pays monthly rent of $2000 by EFT. 15/05/20XX The tenant (renter) Jill Sharp pays by EFT the rental of $1350 for 15 Drysdale Ave. 20/05/20XX Fred Sykes settles the sale of Ted Johnson's house for $535,000.00. You now need to finalise this account and pay the commission to the agency and send the remaining funds to the Solicitor, Reddy and Co Pty Ltd, for settlement (Chq no 1441). The commission is 2.5% of the value. There will be a $20.00 accounting fee added as well. (Chq no 1442). 30/05/20XX You will pay James Smithson (Chq no 1443) and John Jones (Chq no 1444) the rents owing them less the commissions and statement fees. You will pay the General Account the commission owing with Chq no 1445. TASK INSTRUCTIONS 1. Fill out the receipts for all incoming moneys for two months of accounts. 2. Enter all the transactions to the Cash Receipts, Cash Payments, and Transfer journals from the source documents to facilitate the processing of payments. You must ensure that there is adequate funds in the trust account at all times. 3. Write up the ledger. 4. Reconcile the account at the end of each month. 5. Issue monthly statements for all rental property management accounts. You will include in the statements a fee for $5 for the statement fee. The commission fee for rentals is 7% of the rental each month. Scenario: You work at Your Home Real Estate Pty Ltd. Part of your job is to manage the company's trust account. As part of this role you are required to complete the following tasks: . Document receipts of payment received Enter all the transactions in the appropriate journals from the source documents Write up the ledger Reconcile the accounts once a month You will need to record all appropriate details in the company's Trust Account Cash Receipts, Cash Payment and Transfer journals and ledgers for their trust account. You will be required to use the information included below to complete the tasks. You will be the one issuing the receipts and writing out the cheques. You will not sign the cheques. You have at your disposal access to the bank account to check the statement day to day and see if there are any electronic funds transfers into the account. This will allow you to ensure that sufficient funds are on hand before payments are processed and to maintain the security of the trust account records. You can either use the Excel spreadsheet provided or Xero, Google Sheets or an appropriate accounting software system to complete this task. If you choose the spreadsheet, note that there are five worksheets provided: . Receipt Journals Ledgers Statements Trial Balance & Reconciliation Use the following details to prepare all the journals and ledgers and reconcile from the following details. Date Information Starting Ted Johnson has listed his house with the agency to sell. The address is: 2 Second St date: Wodonga. He has agreed to an advertising campaign. The first payment for the advertising 01/04/20XX of $350.00 is received on 02/04/20XX. You will start with Receipt no. 1206. John Jones of 10 Circuit St Wodonga, has 3 rental properties with the company. They are: 65 Martin St ($1200 per month), 15 Drysdale Ave ($1350 per month), and 47 Robert St ($1,500 per month). Date Information James Smithson has a commercial property he rents through your company. It is located at 34 Drinkwater Parade. It is rented to BAC Commercial for $2000 per month. 03/04/20XX The tenant (renter) Bill Fredericks pays rent for the property at 47 Robert St of $1,500 with a cheque. 08/04/20XX The tenant (renter) Ray Richards pays rent for the property at 65 Martin St by cash $1200. 13/04/20XX BAC Commercial pays monthly rent of $2000 by EFT. 15/04/20XX The tenant (renter) Jill Sharp pays by EFT the rental of $1350 for 15 Drysdale Ave. 20/04/20XX Fred Sykes signs a contract to buy Ted Johnson's house for $535,000.00. He pays 2% ($10,700.00) at the signing of the contract with the balance of the deposit to be paid in 3 days. The contract is due to settle in 30 days. 23/04/20XX Fred Sykes pays the rest of the deposit - $42,800.00. The air conditioning unit needs replacing at 47 Robert St. This will cost $1900. The tenant (renter) wants it done immediately. So John Jones agrees to this and asks you take the necessary funds from the rental at 47 Robert St and the balance from the rental at 65 Martin St. You need to transfer the funds so that the account can be paid and you need to allow for the commission to be paid to the office in the figuring. 28/04/20XX The unit is repaired on 28/4/20XX. A cheque (cheque no 1434) is paid that day to Aircold. Air-conditioning for $1900. 30/04/20XX You will pay the rent owing to James Smithson with Chq no 1435. You will pay the rent owing John Jones with Chq no 1436. You will pay the commission for both of these to the General Account using Chq no 1437. You receive an account from the Agency general account for the advertising fee of $350.00 for Ted Johnson's house. Pay with Chq no 1438. 03/05/20XX Sale of a house at 150 White St Wodonga for D & S Gregson is finalised. The sale price was for $388,000.00. The agency has held the deposit of $38,800 in its trust account. You now need to finalise this account and pay the commission to the agency and send the remaining funds to the Solicitor, Agnew and Fortescue, for settlement. The commission is 2.5% of the value. There will be a $20.00 accounting fee added as well. The Purchaser is B. Archer of 40 Black Rd Wodonga. You will use Chq no 1439 for Agnes & Fortescue and Chq no 1440 for the commission. 03/05/20XX The tenant (renter) Bill Fredericks pays rent for the property at 47 Robert St of $1500 with a cheque. 05/05/20XX Bill Frederick's cheque is dishonoured. 07/05/20XX Bill Frederick pays the rent by cash. 07/05/20XX You receive a deposit from R. Ramirez of 14 Dapto St Wodonga, for the house of A. Jackson at 69 O'Brien Crescent. The full 10% deposit has been received. Deposit amount is $56,900.00. 08/05/20XX The tenant (renter) Ray Richards pays rent for the property at 65 Martin St by cash $1200. Date Information 13/05/20XX BAC Commercial pays monthly rent of $2000 by EFT. 15/05/20XX The tenant (renter) Jill Sharp pays by EFT the rental of $1350 for 15 Drysdale Ave. 20/05/20XX Fred Sykes settles the sale of Ted Johnson's house for $535,000.00. You now need to finalise this account and pay the commission to the agency and send the remaining funds to the Solicitor, Reddy and Co Pty Ltd, for settlement (Chq no 1441). The commission is 2.5% of the value. There will be a $20.00 accounting fee added as well. (Chq no 1442). 30/05/20XX You will pay James Smithson (Chq no 1443) and John Jones (Chq no 1444) the rents owing them less the commissions and statement fees. You will pay the General Account the commission owing with Chq no 1445. TASK INSTRUCTIONS 1. Fill out the receipts for all incoming moneys for two months of accounts. 2. Enter all the transactions to the Cash Receipts, Cash Payments, and Transfer journals from the source documents to facilitate the processing of payments. You must ensure that there is adequate funds in the trust account at all times. 3. Write up the ledger. 4. Reconcile the account at the end of each month. 5. Issue monthly statements for all rental property management accounts. You will include in the statements a fee for $5 for the statement fee. The commission fee for rentals is 7% of the rental each month. Scenario: You work at Your Home Real Estate Pty Ltd. Part of your job is to manage the company's trust account. As part of this role you are required to complete the following tasks: . Document receipts of payment received Enter all the transactions in the appropriate journals from the source documents Write up the ledger Reconcile the accounts once a month You will need to record all appropriate details in the company's Trust Account Cash Receipts, Cash Payment and Transfer journals and ledgers for their trust account. You will be required to use the information included below to complete the tasks. You will be the one issuing the receipts and writing out the cheques. You will not sign the cheques. You have at your disposal access to the bank account to check the statement day to day and see if there are any electronic funds transfers into the account. This will allow you to ensure that sufficient funds are on hand before payments are processed and to maintain the security of the trust account records. You can either use the Excel spreadsheet provided or Xero, Google Sheets or an appropriate accounting software system to complete this task. If you choose the spreadsheet, note that there are five worksheets provided: . Receipt Journals Ledgers Statements Trial Balance & Reconciliation Use the following details to prepare all the journals and ledgers and reconcile from the following details. Date Information Starting Ted Johnson has listed his house with the agency to sell. The address is: 2 Second St date: Wodonga. He has agreed to an advertising campaign. The first payment for the advertising 01/04/20XX of $350.00 is received on 02/04/20XX. You will start with Receipt no. 1206. John Jones of 10 Circuit St Wodonga, has 3 rental properties with the company. They are: 65 Martin St ($1200 per month), 15 Drysdale Ave ($1350 per month), and 47 Robert St ($1,500 per month). Date Information James Smithson has a commercial property he rents through your company. It is located at 34 Drinkwater Parade. It is rented to BAC Commercial for $2000 per month. 03/04/20XX The tenant (renter) Bill Fredericks pays rent for the property at 47 Robert St of $1,500 with a cheque. 08/04/20XX The tenant (renter) Ray Richards pays rent for the property at 65 Martin St by cash $1200. 13/04/20XX BAC Commercial pays monthly rent of $2000 by EFT. 15/04/20XX The tenant (renter) Jill Sharp pays by EFT the rental of $1350 for 15 Drysdale Ave. 20/04/20XX Fred Sykes signs a contract to buy Ted Johnson's house for $535,000.00. He pays 2% ($10,700.00) at the signing of the contract with the balance of the deposit to be paid in 3 days. The contract is due to settle in 30 days. 23/04/20XX Fred Sykes pays the rest of the deposit - $42,800.00. The air conditioning unit needs replacing at 47 Robert St. This will cost $1900. The tenant (renter) wants it done immediately. So John Jones agrees to this and asks you take the necessary funds from the rental at 47 Robert St and the balance from the rental at 65 Martin St. You need to transfer the funds so that the account can be paid and you need to allow for the commission to be paid to the office in the figuring. 28/04/20XX The unit is repaired on 28/4/20XX. A cheque (cheque no 1434) is paid that day to Aircold. Air-conditioning for $1900. 30/04/20XX You will pay the rent owing to James Smithson with Chq no 1435. You will pay the rent owing John Jones with Chq no 1436. You will pay the commission for both of these to the General Account using Chq no 1437. You receive an account from the Agency general account for the advertising fee of $350.00 for Ted Johnson's house. Pay with Chq no 1438. 03/05/20XX Sale of a house at 150 White St Wodonga for D & S Gregson is finalised. The sale price was for $388,000.00. The agency has held the deposit of $38,800 in its trust account. You now need to finalise this account and pay the commission to the agency and send the remaining funds to the Solicitor, Agnew and Fortescue, for settlement. The commission is 2.5% of the value. There will be a $20.00 accounting fee added as well. The Purchaser is B. Archer of 40 Black Rd Wodonga. You will use Chq no 1439 for Agnes & Fortescue and Chq no 1440 for the commission. 03/05/20XX The tenant (renter) Bill Fredericks pays rent for the property at 47 Robert St of $1500 with a cheque. 05/05/20XX Bill Frederick's cheque is dishonoured. 07/05/20XX Bill Frederick pays the rent by cash. 07/05/20XX You receive a deposit from R. Ramirez of 14 Dapto St Wodonga, for the house of A. Jackson at 69 O'Brien Crescent. The full 10% deposit has been received. Deposit amount is $56,900.00. 08/05/20XX The tenant (renter) Ray Richards pays rent for the property at 65 Martin St by cash $1200.
Expert Answer:
Answer rating: 100% (QA)
I understand that you need assistance with recording the transactions and completing the tasks related to the management of the trust account for Your ... View the full answer
Related Book For
Accounting Volume 1
ISBN: 978-0132690096
9th Canadian edition
Authors: Charles T. Horngren, Walter T. Harrison, Jo Ann L. Johnston, Carol A. Meissner, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
12 people are in a tennis club. A doubles tennis match consists of two teams of 2 people playing against each other. What is the smallest number of matches that can be played so that everyone gets to...
-
Presented below is selected information related to the financial instruments of Dawson Company at December 31, 2020. This is Dawson Company?s first year of operations. Instructions a. Dawson elects...
-
Suppose that a state has increased its sales tax rate every other year since 2005. Assume the state collected all sales taxes that residents legally owed. The table below summarizes its experience....
-
Aerobic cells metabolize glucose in the respiratory system. This reaction proceeds according to the overall reaction 6O 2 (g) + C 6 H 12 O 6 (s) 6CO 2 (g) + 6H 2 O(l) Calculate the volume of oxygen...
-
In your opinion, what are the critical success factors of CM?
-
Majka Company was started on January 1, 2016. During 2016, the company experienced the following three accounting events: (1) earned cash revenues of $28,600, (2) paid cash expenses of $13,200, and...
-
You own a portfolio that is 38 percent invested in Stock X, 22percent in Stock Y, and 40 percent in Stock Z. The expected returnson these three stocks are 10 percent, 15 percent, and 12...
-
isabelle sterling, the partner you work for, unexpectedly had to travel to Hong Kong. She left you the Tang Aluminum Products file for your client, Global Bank. Global will be lending Tang 1.9...
-
Do you think the Constitution of Bangladesh is a source of Law? Why do/don't you think? discuss briefly. Which source is this one? Justify your opinion.
-
You ask to borrow one of your friends recipe cards. Which statements about these cards, represented as Java policy file grants, are correct? (Choose two.) A. The policy syntax of the policy file is...
-
Fill in the blanks: ____________ means the state of an object cannot be changed, while _____________ means that it can. A. Encapsulation, factory method. B. Immutability, mutability C. Rigidity,...
-
What is this class an example of? A. Turquoiselist B. Whitelist C. Orangelist D. Blacklist E. Both blacklist and whitelist F. None of the above import java.util.*; public class Nightclub { private...
-
Suppose 20 % of the employees of company ABC have only a high school diploma, 60 % have bachelor degrees, and 20 % have graduate degrees Of those with only a high school diploma, 15 % hold management...
-
Assume you have applied to two different universities A and B. In the past, 30 % of students who applied to University A were accepted, while University B accepted 45 % of the applicants. Assume...
-
Q1. Write a program that displays 24hours time. Example: if user enters 2pm program should display all the remaining time in 24hours. Entered time is 2:00 PM. Make sure it should go up to 1hour less...
-
Find the work done in pumping all the oil (density S = 50 pounds per cubic foot) over the edge of a cylindrical tank that stands on one of its bases. Assume that the radius of the base is 4 feet, the...
-
Minit Company began the year with inventory of $16,000. During the year, Minit purchased $180,000 of goods and returned $12,000 due to damage. Minit also paid freight charges of $2,000 on inventory...
-
Define amortization. What are common misconceptions about amortization?
-
The accounts of Boots Consulting are listed below with their normal balances at October 31, 2014. The accounts are listed in no particular order. Account Balance M. Boots, capital...
-
What are the key differences between financing entrepreneurial and established companies?
-
What is the purpose of staged financing?
-
What are the main types of investors that fund entrepreneurial ventures?
Study smarter with the SolutionInn App