Can someone tell me why the trial balance is out and what ive done wrong please..see documents attached

Trust Account Receipt Side Date Rec No Type 4/30/2010 Received From On account of LF Transaction Balance c/d 5/2/2010 101 CHQ Olsen Mckenzie/olsen 770 Deposit -investment 5/3/2010 102 CHQ A Jones R Wales 750 Rent 5/5/2010 103 CHQ A Ward R Wales 750 Rent 5/10/2010 104 CHQ L willis R Wales 750 Rent 5/10/2010 105 CHQ L willis Rental Bond sus 760 Bond 5/2/2010 106 CHQ Olsen Mckenzie/olsen 770 Deposit -investment 5/22/2010 107 CHQ P Unsworth C Beer 780 Deposit - Preliminary 5/27/2010 108 CHQ P Unsworth C Beer 780 Remaining Deposit Balance 10% 5/27/2010 109 CHQ R langfield G Robson 790 part deposit -house purchase 5/30/2010 110 CHQ R langfield G Robson 790 balance of deposit 5/31/2010 111 CHQ E Calnan R Weaver 730 Rent from E Calnan 5/31/2010 112 CHQ E Calnan Rental Bond Suspense 5/31/2010 113 CHQ B Brooke R Weaver 5/31/2010 114 CHQ B Brooke Rental Bond Suspense RECEIPTS TOTAL Balance c/d Bond from E Calnan 730 Rent from B Brooke Bond from B Brooke TC1 Amount Bank $20,080.00 $ 74,000.00 ### $ 900.00 ### $ 400.00 ### $1,200 $1,200 $2,400.00 $2,400.00 74,226.00 ### $ $500 $ 500.00 $ 19,000.00 ### $ 7,500.00 ### $ 8,400.00 ### $ 1,040.00 ### $ 2,080.00 ### $ 850.00 ### $ 1,700.00 ### $ 194,196.00 $214,276.00 $112,556.00 Trust Account Payment Side Date Chq No Payee On Account of LF Transaction 5/2/2010 710 Countrywide Bank Mckenzie/ Olsen 770 Invest Dep 5/7/2010 711 Darkside Plumbing R Wales 750 Repairs 5/7/2010 712 Evansdale Realty Rental Bond Sus 760 Bond Refund 5/16/2010 713 McKenzie to Olsen Evansdale Realty 770 Commission 5/17/2010 716 Evansdale Realty Rental Bond Sus 760 Bond Refund 18/05.2010 717 Sproule to Hill Evansdale Realty 720 Commission 18/05.2010 718 Evansdale Realty Sproule to Hill 720 Setllment dep 5/21/2010 719 R Weaver Evansdale Realty 730 PM fees 5/21/2010 720 Evansdale Realty R Weaver 730 Setllment dep 5/22/2010 721 R richardson Evansdale Realty 740 Advertising 5/25/2010 722 R wales Evansdale Realty 750 Commision 5/25/2010 723 Evansdale Realty R wales 750 Setllment dep SUBTOTAL Balance c/d TOTAL TC1 Bank $ 74,000.00 $160.00 $ 1,480.00 $ 12,500.00 $ 2,400.00 $1,800 $3,200 $140 $1,860.00 $ 940.00 $170 $3,070.00 $101,720.00 $112,556.00 $214,276.00 Trust Account Ledgers Name: Trust Account Bank Date Particulars LF Account No: 700 Debit Credit 4/30/2010 Balance c/d $20,080.00 DR 4/30/2010 Receipts $194,196.00 4/30/2010 Payments Particulars $214,276.00 DR $101,720.00 $112,556.00 DR Name: Davis to Kendal Date LF Account No: 710 Debit Credit 4/30/2010 Balance c/d Particulars Balance $9,700.00 CR Name: Sproule to Hill Date Balance LF Account No: 720 Debit Credit 4/30/2010 Balance c/d Balance $5,000.00 CR 5/18/2010 Agent Commission TC1 $1,800.00 5/18/2010 Settlment deposit TC1 $3,200.00 $3,200.00 CR NIL Name: R Weaver Date Particulars LF Account No: 730 Debit Credit Balance 4/30/2010 Balance c/d $2,000.00 CR 5/21/2010 PM fees TC1 $140.00 $1,860.00 5/21/2010 Setllment amount TC1 $1,860.00 $0.00 5/31/2010 Rent from E Calnan TC1 $1,040.00 5/31/2010 Rent from B Brooke TC1 $850.00 Name: R Richardson Date Particulars LF Account No: 740 Debit Credit $1,890.00 CR Balance 4/30/2010 Balance c/d 5/22/2010 Evansdale Newspapers fee $1,000.00 CR TC1 Name: R Wales Date Particulars LF $940.00 $60.00 CR Account No: 750 Debit Credit Balance 4/30/2010 Balance c/d $900.00 CR 5/3/2010 Rent from A Jones TC1 $900.00 $1,800.00 CR 5/5/2010 Rent from A Ward TC1 $400.00 $2,200.00 CR 5/7/2010 Repairs - Plumbing TC1 $160.00 5/10/2010 Rent from L Willis TC1 5/25/2010 Evansdale Commission TC1 $170.00 5/25/2010 Settlment amount TC1 $3,070.00 $2,040.00 CR $1,200.00 $3,240.00 CR $3,070.00 Nil Name: Rental Bond Suspense Date Particulars LF Account No: 760 Debit Credit Balance 4/30/2010 Balance c/d 5/7/2010 Bond Refund $1,480.00 CR TC1 $1,480.00 Nil 5/10/2010 Bond from L Willis TC1 5/17/2010 outsdtanding Bond TC1 5/31/2010 Bond from E Calnan TC1 $2,080.00 5/31/2010 Bond from B Brooke TC1 $1,700.00 Name: McKenzie to Olsen Date Particulars LF 5/2/2010 Deposit TC1 5/2/2010 Invest deposit TC1 5/16/2010 Settlment invest deposit TC1 5/16/2010 Evansdale Comission TC1 Name: C Beer Date Particulars 5/22/2010 Deposit from P unsworth LF $2,400.00 $2,400.00 $2,400.00 CR Nil Account No: 770 Debit Credit $74,000.00 $74,000.00 $3,780.00 CR Balance $74,000.00 CR $0.00 $74,226.00 $12,500.00 $61,726.00 CR Account No: 780 Debit Credit Balance TC1 $500.00 $500.00 CR 5/27/2010 10% balance deposit from P unsTC1 $19,000.00 $19,500.00 CR Name: G Robson Date Particulars LF Account No: 790 Debit Credit Balance 5/27/2010 part deposit from R langford TC1 $7,500.00 $7,500.00 CR 5/27/2010 part deposit from R langford TC1 $8,500.00 $16,000.00 CR Trust Trial Balance Trial balance as at: Name LF Debit Credit Trust Trial Balance 700 $112,556.00 Davis to Kendal 710 $9,700.00 R Weaver 730 1890 R Richardson 740 60 Rental Bond Suspense 760 $3,780.00 McKenzie to Olsen 770 61726 C Beer 780 19500 G Robson 790 $16,000.00 TOTALS $112,556.00 $112,656.00 Evansdale Realty Trust Bank Reconciliation as at 31/05/10 Credit balance as per bank statement 31/05/10 $51,230.00 Add: Oustanding deposit Date Amount 31-May 5670 Less: Unpresented cheques Chq No Debit balance as per Trust Cash Book as at Amount $5,670.00 Tasks 2 - 4 Practical exercise You are to complete the appropriate books of account based on the following scenario. Scenario Students to note the following: The Trust Cash Book, Trust Ledger and Trust Trial Balance are to be completed so as to comply with the Property, Stock and Business Agents Act 2002. The 2003 Regulation and the Amendment Regulation 2005 under the Act. The next Trust Receipt Number to be issued is number 101 and the next Trust Cheque number is 710. All trust receipts are banked on the day of receipt. All receipts and payments are by cheque unless otherwise stated. All transactions are GST free unless stated. The accounts in the Trust Ledger had the following balances as at 30th April, 2010. 2 700 710 720 730 740 750 760 Trust Bank Ledger Davis to Kendal Sproule to Hill R Weaver (owner) R Richardson (owner) R Wales (owner) Rental Bond Suspense $20,080 9,700 5,000 2,000 1,000 900 1,480 Debit Credit Credit Credit Credit Credit Credit May 2010 2nd Received a deposit $74,000 from Olsen for a development property owned by McKenzie. The cheque was payable to the agent who made special arrangements for its clearance to facilitate investment in an interest bearing account at Countrywide Bank with the proceeds being distributed equally in accordance with a special agreement. 3rd Received rent from the tenant A Jones for the owner R Wales $900 5th Obtained a new tenant A Ward for R Wales who paid a bond (cheque made payable to Rental Bond Board) as well as 2 weeks rent in advance as a second cheque. Details were: Bond $880 Rent $440 7th Paid Darkside Plumbing on behalf of R Wales $160 Paid outstanding amount due to the Rental Bond Board. 10th Obtained a new tenant L Willis for R Wales who paid a bond (cheque payable to the agent) as well as 2 weeks rent in advance. Details were: Bond $2400 Rent $1,200 16th Settlement occurred between McKenzie and Olsen. The initial deposit plus $226 interest was rebanked into the Trust Account. Sales commission was $12,500 with the appropriate balance of funds being sent to the two parties involved. 17th Paid outstanding amount due to Rental Bond Board. 18th The sale regarding Sproule to Hill was settled and the vendor's solicitors requested the deposit be released after commission had been deducted. The commission amounted to $1,800. 21st Settled with R Weaver. Property management fees GST inclusive $140 and the balance was paid to landlord. 22nd Received a preliminary deposit from P Unsworth on a property owned by C Beer, $500. Funds held on behalf of R Richardson were for advertising. Paid Evansdale Newspapers form this amount, the sum of $940. 3 25th Settled the outstanding balance to date with the owner R Wales. The commission will be as shown, however, you must deduct any amounts paid on behalf of the owner to date. The commission was $170. 27th The balance of a 10% deposit was received from P Unsworth on a property with a sale price of $195,000. Received part deposit from R Langfield for the purchase of a house owned by G Robson $7,500. 30th Received balance of deposit from R Langfield $8,400. 31st Received two new tenants for R Weaver each of whom paid 2 weeks rent and a bond (cheques payable to agent). Details were: E Calnan Rent 1,040 Bond 2,080 B Brooke Rent 850 Bond 1,700 Your tasks Using the information provided by the licensee of Evansdale Realty above you are to complete the following: The blank forms required for this exercise can be found on a separate document called 'answer .xls'. Click on tabs at the bottom of the window (i.e. - receipt side of cash book, payment side of cash book, ledgers & trial balance & bank reconciliation) to access the relevant worksheet for each task . Task 2 - Correctly complete the Trust Cash Book Task 3 - Correctly complete the Trust Ledger and Trust Trial Balance as at 31st May, 2010 Task 4 - Using the Trust Cash Book and ledger records of Evansdale Realty that you completed in Tasks 2 & 3, prepare a Trust Bank Reconciliation so it complies with the Regulations. You are entitled to assume that the bank statement is correct. Countrywide Bank Evansdale Realty Trust Account Date 3/05/2010 3/05/2010 4/05/2010 4 Details Bal b/f Deposit 710 Deposit Debit Credit $ 74,000.00 $ 74,000.00 $ 900.00 Balance $ 20,080.00 $ 94,080.00 $ 20,080.00 $ 20,980.00 cr cr cr cr 6/05/2010 10/05/2010 11/05/2010 18/05/2010 20/05/2010 23/05/2010 27/05/2010 28/05/2010 31/05/2010 Deposit 712 Deposit Deposit 713 714 715 717 718 Deposit 719 716 722 Deposit Deposit $ $ 440.00 1,480.00 $ 3,600.00 $ 74,226.00 $ $ $ $ $ 12,500.00 113.00 61,613.00 1,800.00 3,200.00 $ $ $ 140.00 2,400.00 170.00 $ 500.00 $ 26,500.00 $ 8,400.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 21,420.00 19,940.00 23,540.00 97,766.00 85,266.00 85,153.00 23,540.00 21,740.00 18,540.00 19,040.00 18,900.00 16,500.00 16,330.00 42,830.00 51,230.00 cr cr cr cr cr cr cr cr cr cr cr cr cr cr cr 5