4125 p 4-11032024140030-0001

.pdf

School

Australian College of Professionals *

*We aren’t endorsed by this school

Course

CPP41419

Subject

Accounting

Date

Jun 19, 2024

Type

pdf

Pages

14

Uploaded by MinisterFlower14089

Report
Project 4 Maintain and protect trust account records In this Section you will demonstrate your skills and knowledge in regard to: - e balancing and reconciling trust accounts * apply agency procedures to respond to discrepancies identified with trust accounts e prepare records and statements of trust account transactions e identify and explain the process for unclaimed trust monies e maintain the security of trust account records What you need to do: You are to undertake the tasks set out below in the spaces provided What you will need: e Access to legislation via www.austlii.edu.au e Access to NSW Fair Trading at www.fairtrading.nsw.gov.au e Access to your offices Policies and Procedures and standard forms and letters When: During your own time What you need to submit: Your answers in the spaces provided or as instructed in the project. Instructions Using the information below perform the following tasks in the spaces provided: a. Balance and reconcile trust accounts I. Set out the process of the monthly balancing and reconciling agency trust accounts. ‘I"f?&x F=if EML«-«\% - Sfodad atl 77 /&Jj—"’s & co mMpare ot P Poute Stafcomenl L>’/ Exrrovs avk /OJMJ—,:Q(J - é’lflA /¢Concf/,'o;#/°,‘ L adjast sz ermors paw balance AHle Mwwv‘“' ASSESSOR USE ONLY S D NS D 2. CPPREP4125-Transact in trust accounts Version 1.0 12 May 2020 Page 23 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125
ii. Undertake the balancing of the trust account and prepare records You are to undertake the reconciliation and necessary adjustments on the foll Reconciliation 1 Below are the following for the Property Management Trust Account: e The Trust Cash Book Receipts and Payments for May 20XX e Bank Statement as at 31 May 20XX e Note that on the previous month's reconciliation there was an outstan presented on 30 April 20xx. owing three sets of agency accounts. You are to reconcile the cash book to the Bank Statement using the template provided THINK REALTY PROPERTY MANAGEMENT TRUST ACCOUNT ding cheque for $2,173.75 not TRUST CASH BOOK CASHBOOK RECEIPTS SIDE (TCR) gg::( F;ec Type Received from On Account of LF | Transaction Amount Daily Bank 2/5 | 223 | Cash | PaulBell Jason Brown 10 | RentX2 900.00 224 | Cash | Andy Short Jason Brown 10 | RentX1 550.00 1,450.00 3/5 225 | Cash | Peter Edgar Steve Smith 20 | RentX2 1,000.00 226 | Chq | Alfred Thomas Grant Roberts 30 | RentX1 470.00 1,470.00 4/5 227 | Chg Alison Sommers Steve Smith 20 Rent X 2 1,200.00 1,200.00 23/5 | 233 | cash | PaulBell Jason Brown 10 | RentX2 900.00 234 | Cash | Peter Edgar Steve Smith 20 | RentX?2 1,000.00 1,900.00 6,020.00 6,020.00 Balag;: :rought 0 THINK REALTY PROPERTY MANAGEMENT TRUST ACCOUNT TRUST CASH BOOK CASHBOOK PAYMENT SIDE (TCP) Transaction CcHQ Date EFTNo. | nNo Payee On Account of LF Transaction Amount 5 May 2641 City Water J Brown 10 Water Rates 250.00 31 May 328 Jason Brown J Brown 10 Settlement 1,931.25 329 Steve Smith S Smith 20 Settlement 2,960.00 2642 Grant Roberts G Roberts 30 Settlement 434.75 331 Think Realty J Brown/Smith 10/20 Management Fee 444.00 Total 6,020.00 Balance Brought Down 0 Final Total 0 2. CPPREP4125-Transact in trust accounts Version 1.0 12 May 2020 Page 24 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125
THINK REALTY PROPERTY MANAGEMENT TRUST ACCOUNT TRUST BANK LEDGER ACCOUNT NAME: BANK ACCOUNT No 100 Date: Details: Folio No Debit Credit Balance 31/4/xx | Balance 0.00 2/5/x%x Receipts TCR 1,450.00 1,450.00 3/5/xx Receipts TCR 1,470.00 2,920.00 4/5/xx Receipts TCR 1,200.00 4,120.00 5/5/xx Payment TCP 250.00 3,870.00 23/5/xx | Receipts TCR 1,900.00 5,770.00 31/5/xx | Payment TCP 1,931.25 3,838.75 31/5/xx | Payment TCP 2,960.00 875.75 31/5/xx | Payment TCP 434.75 444.00 31/5/xx | Payment TCP 444.00 0.00 Think Realty Property Management Trust Account Bank Statement as at 31 May 20xx . Date o , Details/Reference . ~ Debit Credit Balance " Balance b/f 2,173.75 3-May Receipts 1,450.00 3,623.75 4-May Receipts 1,470.00 5,093.75 Payment 2,173.75 2,920.00 5-May Receipts 1,200.00 4,120.00 24-May Receipts 1,900.00 6,020.00 27-May ) 2641 250.00 5,770.00 31-May 328 1,831.25 3,838.75 329 2,960.00 878.75 331 444.00 434,75 You are to accept all the entries in the bank statement in this exercise are correct INSTRUCTIONS On the next page you are to reconcile the Trust Account to the bank statement 2. CPPREP4125-Transact in trust accounts Version 1.0 12 May 2020 Page 25 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125
THINK REALTY PROPERTY MANAGEMENT TRUST ACCOUNT Bank Reconciliationasat 3| I 5 Balance as per bank statement ADD Outstanding Deposits Sub Total S Add Bank Charges 5 Add Total Adjustments LESS Unpresented Cheques Cha#t 2642 Amount $434-775 Sub total S Less Total Adjustments CR Balance as per bank statement (adjusted) DR Balance as per cash book /Zo 24 $434-715 $424 - 7S o) ¢ O ASSESSOR USE ONLY s B 2. CPPREP4125-Transact in trust accounts Version 1.0 12 May 2020 Page 26 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125
Reconciliation 2 Below are the following for the Sales Trust Account: e The Trust Cash Book Receipts and Payments for May 20XX e Bank Statement as at 31 May 20XX You are to reconcile the cash book to the Bank Statement using the template provided THINK REALTY SALES TRUST ACCOUNT TRUST CASH BOOK CASHBOOK ~ RECEIPTS SIDE (TCR) Date | Rec . 20xx | # Type Received from On Account of LF | Transaction Amount Daily Bank . Advertising 10/5 | 229 | Cash | Roger Hamilton Roger Hamilton 50 Contrib 1,600.00 1,600.00 19/5 | 231 | Chg |Jonlames Yates to James 60 10% Deposit | 122,000.00 | 122,000.00 21/5 1232 | Chq | Bert&MaryStewart | Hamiiton to Stewart | 50 | 10% Deposit | 60,000.00 60,000.00 183,600.00 Bal B/d THINK REALTY SALES TRUST ACCOUNT TRUST CASH BOOK CASHBOOK PAYMENT SIDE (TCP) Date EFT# CHQ# Payee On Account of LF Transaction Amount 5 May 407 Aganovski Aganovski 21 Settlement 82,500.00 5 May 408 Think Realty Aganovski 21 Commission 25,500.00 31 May 6324 XYZ Realty Smith 11 Release of Dep 60,500.00 Total 168,500.00 Brought Down 183,600.00 Final Total 15,100.00 *Purchaser agreed to partial release of deposit to purchase another property THINK REALTY SALES TRUST ACCOUNT TRUST BANK LEDGER ACCOUNT NAME: BANK ACCOUNT No 001 Date: Detalls: Folio No Deblt Credit Balance 30/4/xx 274,180.00 5/5/xx | Settlement 82,500.00 191,680.00 5/5/xx Settlement 25,500.00 166,180.00 10/5/xx | Receipt 1,600.00 167,780.00 19/5/xx | Receipt 122,000.00 289,780.00 21/5/xx | Receipt 60,000.00 349,780.00 31/5/xx | Pmt land tax for Smith 60,500.00 289,280.00 2. CPPREP4125-Transact in trust accounts Version 1.0 12 May 2020 Page 27 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help