diff_months: 10

September 2021 | Learners GuideCPPREP4125 Transact in trust Accounts

Download Solution Now
Added on: 2024-11-24 17:00:11
Order Code: SA Student Ellena Management Assignment(5_23_34153_731)
Question Task Id: 490648

447675962025Patricia Grolman

September 2021 | Learners GuideCPPREP4125 Transact in trust Accounts

This Learners guide has been written for students attending classes for the above unit of competency in the Certificate IV in Real Estate Practice, course number CPP41419.

The exercises in this guide have been prepared, where possible, to replicate the accounting for Property Management and Property Sales trust account transactions, which take place daily in a Real Estate business. All legislation referred to in this guide was current at the time it was written

00Patricia Grolman

September 2021 | Learners GuideCPPREP4125 Transact in trust Accounts

This Learners guide has been written for students attending classes for the above unit of competency in the Certificate IV in Real Estate Practice, course number CPP41419.

The exercises in this guide have been prepared, where possible, to replicate the accounting for Property Management and Property Sales trust account transactions, which take place daily in a Real Estate business. All legislation referred to in this guide was current at the time it was written

Contents

TOC o "1-3" h z u Prerequisite PAGEREF _Toc83715519 h 2CPPREP4125 Transact in Trust Accounts PAGEREF _Toc83715520 h 2Introduction: PAGEREF _Toc83715521 h 2Trust Accounting PAGEREF _Toc83715522 h 5Trust money PAGEREF _Toc83715523 h 6Receipts for trust money PAGEREF _Toc83715524 h 7Banking of trust money PAGEREF _Toc83715525 h 11Trust deposits PAGEREF _Toc83715526 h 11Payment of trust money. PAGEREF _Toc83715527 h 13Property management payments PAGEREF _Toc83715528 h 15Property sales payments PAGEREF _Toc83715529 h 16Reporting GST collected to Landlords and Vendors. PAGEREF _Toc83715530 h 16Record of trust account transactions PAGEREF _Toc83715531 h 19Cash book PAGEREF _Toc83715532 h 19Trust accounting using a computer program PAGEREF _Toc83715533 h 20Trust account ledger PAGEREF _Toc83715534 h 21Trust account ledger trial balance PAGEREF _Toc83715535 h 22Security and maintenance of the trust accounts PAGEREF _Toc83715536 h 22Records of trust money to be kept by licensees PAGEREF _Toc83715537 h 23Trust account audit requirements PAGEREF _Toc83715538 h 24Review of Trust Accounts PAGEREF _Toc83715539 h 25Unclaimed trust money PAGEREF _Toc83715540 h 27Recording trust accounting transactions to trial balance. PAGEREF _Toc83715541 h 28Trust account transfer journals PAGEREF _Toc83715542 h 30Trust Exercises PAGEREF _Toc83715543 h 37Property Management PAGEREF _Toc83715544 h 37Sales PAGEREF _Toc83715545 h 50Bank Reconciliations PAGEREF _Toc83715546 h 63Comprehensive Example PAGEREF _Toc83715547 h 65Bank reconciliations Exercises PAGEREF _Toc83715548 h 69Solutions to Exercises PAGEREF _Toc83715549 h 81References: PAGEREF _Toc83715550 h 95

Prerequisite:- CPPREP4005 Must have been successfully completed prior to starting this unit.

CPPREP4125 Transact in Trust AccountsAt the end of this unit learners should have the skills and knowledge required to establish, manage, and maintain trust accounts in an agency context including recording trust transactions, and monitoring and reviewing trust accounts. You will learn to:-Apply financial management and accounting principles to maintain a Property management trust account and a Property sales trust account.

commit to client service and maintenance of client confidentiality

establish and manage agency trust accounts

demonstrate knowledge of agency practice, ethical standards, and legislative requirements for the operation of agency trust accounts

comply with legislative requirements for the operation and auditing of agency trust accounts

reconcile trust account with bank statement

Introduction:Purpose of Real Estate Trust Accounts

Trust accounts exist to protect everyone involved in real estate transactions.

Real estate agents are heavily governed by legislation and those who fail to comply with the legislation risk hefty penalties, including loss of licence and possible jail time.

The legislation which governs Real estate agents is the:

Property and Stock Agents ACT, 2002and Property and stock Agent Regulations 2014 (NSW).In addition, NSW Fair Trading publish Supervision guidelines.

The supervision guidelines set out the requirements for proper supervision of a real estate business, including the steps to take to prevent fraud, maintain trust accounts and audit requirements.

The parts and sections of the ACT and Regulations included in this workbook are those which the agency must adhere to when maintaining the agency trust accounts.

General rules of conduct applying to all agents and assistant agents

The Property and Stock Agents Regulations 2014 (NSW)

Schedule 1.1

Knowledge of Act and regulationsAn agent must have a knowledge and understanding of the Act and the regulations under the Act, and such other laws relevant to the category of licence or certificate of registration held (including, laws relating to residential tenancy, fair trading, competition and consumer protection, anti-discrimination, and privacy) as may be necessary to enable the agent to exercise his or her functions as agent lawfully

Schedule 1.8

To act in accordance with client authority

An agent must not act as an agent or represent himself or herself as acting as an agent on behalf of a person without written authority.

This clause does not apply to a sale solely of livestock

Schedule 1.9

To act in accordance with clients instructions

An agent must act in accordance with a clients instructions unless it would be contrary to the Act or regulations under the Act or otherwise unlawful to do so

Schedule 1.10

Licensee must ensure employees comply with the Act and regulations

An agent who is the licensee-in-charge at a place of business of a licensee must take reasonable steps to ensure other licensees or registered persons employed in the business conducted there comply with the Act and regulations under the Act.

Schedule 1.20

Agent to pay rental income monthly to landlord

An agent must pay rental money for each calendar month (less any authorised expenses) owing to a landlord under a residential tenancy agreement at the end of each calendar month, unless instructed otherwise by the landlord.

Schedule 1.22

An agent who is the licensee in charge of a business must ensure that there are separate trust accounts for rental money and sales money and that money from rentals and sales are paid into the appropriate accounts.

Exempt trust accounts

In addition to the Sales trust account, separate trust accounts, (exempt trust accounts), may be opened for the exclusive use of vendors and purchasers in the sale of land. Interest earned on the trust account can be transferred to the vendor and purchase on the settlement of the sale.

You are not required to notify NSW Fair Trading when opening a separate trust account. On the instructions of the client to whom those funds belong. Or for the exclusive benefit of a vendor and purchaser of land.

These separate trust accounts are exempt from directing interest to NSW Fair Trading

Trust AccountingTrust accounting is a simple form of bookkeeping used exclusively for trust transactions. It is based on the double entry bookkeeping principles.

It is the recording by a trustee of the receipts and payments of other people's money into individual trust ledger accounts which are maintained for the person from or on whose behalf the money was received or paid.

All moneys held for a person in relation to real estate transactions, such as property sales, (including money received in advance for advertising and/or auction expenses), property management, and strata management, must be paid into a specially titled trust account.

Money held in the trust accounts cannot go into the agencies general account as it is NOT the agencies money. It is held in trust for the agencys clients.

Only at the end of a sale, once the agent has received the Order on the agent, can they transfer the commission and expenses outlined in the agency agreement into their general account (the agencies working account).

In property management, the agency receives its fees at the end of each month, or at the time outlined in the managing agency agreement.

Trust money

Means money received for or on behalf of any person by a licensee in connection with the licensees business.

Trust money to be paid into trust account:

Property and Stock Agents Act 2002 No 66

Part 7

Division 2 Payment of trust money into trust account

Section 86 Trust money to be paid into trust account

(1)Money received for or on behalf of any person by a licensee in connection with the licensees business as a licensee

(a)is to be held by the licensee or (if the licensee is employed by a corporation) by the corporation, exclusively for that person, and

(b)is to be paid to the person or disbursed as the person directs, and

(c)until so paid or disbursed is to be paid into and retained in a trust account (whether general or separate) at an authorised deposit-taking institution in New South Wales and approved by the Secretary for the purposes of this Part.

(2)If the licence is held by a corporation, the trust account is to be in the name of the corporation and in any other case is to be in the name of the licensee or of the firm of licensees of which the licensee is a member.

(3)The name of a trust account and the description of the trust account in the books and records of the licensee and on all cheques drawn on the trust account

(a)must include the name of the licensee corporation, licensee, or firm of licensees in whose name the trust account is kept, and

(b)must include the words Trust Account, and

(c)may include, at the end of the accounts name, a name or other matter to identify the person on whose behalf money in the account is held.

(4)When opening a trust account at an authorised deposit-taking institution for the purpose of complying with this section, the licensee concerned must ensure that the authorised deposit-taking institution is notified in writing that the account is a trust account required by this Act. The notification must be in a form approved by the Secretary and the licensee must serve a copy of the notification on the Secretary within 14 days after the trust account is opened.

(5)A licensee must, within 14 days after closing a trust account, notify the Secretary in writing of the closure. The notification must be in a form approved by the Secretary.

(6)Subsections (4) and (5) do not apply in respect of

(a)a separate trust account kept on the instructions of a client of a licensee or firm of licensees for the exclusive benefit of the client, or

(b)a separate trust account opened by a licensee for the exclusive benefit of both the vendor and the purchaser of land.

(7)A licensee must also comply with any additional requirements relating to trust accounts prescribed by the regulations.

Maximum penalty100 penalty units.

Example of trust monies received

Monies received Appropriate trust account

Marketing fees for new sales listing. Sales trust account.

10% deposit paid by the purchaser. Sales trust account.

Sales holding deposit. Sales trust account.

Rental Holding deposit of one week. Property Management trust account.

Rent. Property Management trust account.

Water charges. Property Management trust account.

Receipts for trust moneyProperty and Stock Agents Regulation 2014

Part 4 Section 23

(1)A licensee must, immediately on receiving money for or on behalf of any person, prepare or cause to be prepared a receipt in accordance with this clause.

(2) When a receipt is being prepared by a licensee:

From the trust receipt book, a copy of the entries made on the receipt must be made simultaneously on the machine numbered duplicate form provided in the book, or

Otherwise, than from a trust receipt book, a copy of the entries made on the receipt must be made simultaneously in the record required to be kept by clause 26 (Record of trust account transactions).

(3)The following particulars must be shown on a receipt:

(a)The date of issue,

(b)The number of the receipt in numerical sequence,

(c)The name of the licensee and the words Trust Account,

(d)The name of the person from whom the payment was received,

(e)The name and ledger reference number of the person on behalf of whom the payment was made,

(f)Particulars sufficient to identify the transaction, in respect of which the money was paid,

(g)The amount of money received and whether (or the extent to which) it was paid in cash or by cheque, by electronic funds transfer or otherwise.

(4)Receipts must be prepared in the numerical order of the series to which they belong.

(5)The original of a receipt must be issued, on demand, to the person from whom the trust money is received.

(6)A licensee must retain:

(a)Any original receipt that is not issued to the person from whom the trust money is received, and

(b)Any original receipt that is cancelled after it is prepared, and

(c)Duplicate receipts.

(7) A licensee is not required to retain duplicate receipts in relation to money received if an electronic record of receiving the money was made as soon as was practicable after the money was received.

Receipt for rent

(8) When a receipt is issued by a licensee in respect of rent collected additional must be shown on the receipt:-The date to which rent has been calculated and the position of the rental account as at the day the rent was received.

Receipts and recording Rental BondsFrom 30 January 2017, changes to the Residential Tenancies Act 2010 (the Act) make it mandatory for landlords and real estate agents to invite tenants to lodge their rental bonds using Rental Bonds Online (RBO).

The amendment does not change any other provisions in the Act, including those relating to the lodgement and claims for bonds.

Landlords and Real Estate Agents

From 30 January 2017, landlords and real estate agents are required to be registered with RBO and invite new tenants to provide their email address for the purpose of initiating the RBO bond lodgement process.

A landlord or agent, who fails to invite a new tenant to lodge their bond using RBO, prior to accepting a bond, will be in breach of the Act. A penalty of $2,200 may apply.

Bonds can still be lodged using the existing paper form-based method.

You may be required to use the existing paper form method when your tenant does not meet the requirements for an online bond.

NOTE: If a tenant makes the cheque for the bond payable to the Rental Bond Board(RBB), we do not bank it into the trust account, nor do we write a receipt to the tenant or account for it in our records.

We simply forward the cheque to the Rental Bond Board within ten working days from the end of the month, along with the appropriate bond lodgement form.

We will subsequently receive a receipt for the bond amount from the RBB, which we should keep in the landlord's file for future reference. The tenant will also receive a receipt directly from the RBB.

Example: Receipt for rentOn 5th August 20xx Peter Smithson, tenant at 9 Lyons street, Pymble, paid 2 weeks rent by cash. His weekly rent is $550 per week and is currently paid up to 8th August 2016

200026251460Ultimate Realty Pty Ltd

85 Pitt Street Sydney NSW 2000

Receipt No. 110

Date:--5/8/20xx

Received From: Peter Smithson

The sum of: one thousand and one hundred dollars

Being for: 2 weeks rent 8/8/16 to 22/8/16, 9 Lyons St, Pymble

Landlord: J. TaylorAccount No. 240

Property management trust account

Per: Your signature$1,100

By: Cash/cheque/EFT

Rent in Advance: 1,335.71

00Ultimate Realty Pty Ltd

85 Pitt Street Sydney NSW 2000

Receipt No. 110

Date:--5/8/20xx

Received From: Peter Smithson

The sum of: one thousand and one hundred dollars

Being for: 2 weeks rent 8/8/16 to 22/8/16, 9 Lyons St, Pymble

Landlord: J. TaylorAccount No. 240

Property management trust account

Per: Your signature$1,100

By: Cash/cheque/EFT

Rent in Advance: 1,335.71

The following receipts would be issued:

38023809969500

The above receipt complies with the regulations; the additional information required is calculated as follows:

The date to which rent has been calculated - 22/8/15

Position of the rental account as at that date:

Rent in advance 5/8/15 to 22/8/15 is 17days

Calculation: $550 pw 7 = $78.57 per day x 17 days = $1,335.71

Example: Sales Trust Receipt

A 10% deposit received from J. Franks (by Cheque) on 12/4/20xx for the property, 13 Clyde Street, Balmain, owned by F. Stone. The sales price is $850,000.

:Azure Beach Realty Group Sales Trust Account

144 Symons Road Azure Beach NSW 2100

ACN 604 981 912 150

Receipt No: 920 Date: 12/4/20xx

Received from J. Franks Vendor: F. Stone To J. Franks Purchaser:

The sum of: Eighty-five thousand dollars cents

Being for: 10% deposit for 13 Clyde St, Balmain

Sales Trust Account $85,000

Per: Agents signature By EFT / Cash / Cheque

Example: Sales Trust Receipt - Advertising

A cheque received from P. Carr for $7000 on 12/5/20xx, it is a contribution to the advertising campaign.

Azure Beach Realty Group Sales Trust Account

144 Symons Road Azure Beach NSW 2100

ACN 604 981 912 150

Receipt No: 921 Date: 12/5/20xx

Received from: P. CarrVendor: P. Carrto Purchaser: N/A

The sum of: Seven thousand dollars cents

Being for: Contribution to advertising

Sales Trust Account $ 7,000

Per: Agents signature By EFT / Cash / Cheque

Banking of trust moneyProperty and Stock Agents Regulation 2014

Part 4 section 18

Banking of trust money

A licensee who receives trust money must pay it into the licensees trust account

(a)before the end of the next banking day after the day of its receipt, if that is practicable, or(b)if that is not practicable, as soon as practicable after that day.

Trust depositsProperty and Stock Agents Regulation 2014

Part 4 section 25

A licensee who makes a deposit of money to the licensees trust bank account must ensure:

That the relevant deposit book or other written deposit record is produced to the authorised deposit-taking institution when the deposit is made, and

(b)That the following particulars are entered in the book or record:

(i)The date of the deposit,

(ii)The amount of the deposit,

(iii)Whether the deposit consists of cheques, notes, or coins,

(iv)If cheques are included in the deposit, the name of the drawer, the name and branch of the authorised deposit-taking institution on which the cheque is drawn and the amount of each cheque, and

That a duplicate of the particulars of each deposit is retained by the licensee.

(2)This clause does not apply to a deposit of money made directly to a licensees trust account, electronically or otherwise. (Direct deposit)

Example completed bank deposit

Completed bank deposit slip for the 10% deposit received from J. Franks on 12/4/20xx (Westpac Bank Sydney). The sales price is $850,000.

National Banking Corporation

Balmain NSW 2270

Account Name: Sydney Wide Realty Group Sales Trust Account

Account Number: 0655 29865

Please fill in the following particulars of cheques; proceeds will not be available until cleared

DRAWER Bank Branch Amount

1 J. Franks Westpac Sydney 85,000

2

5

Carried Forward Sub Total 85,000

Paid in by Signature: person who deposited the funds

DEPOSIT

DATE TELLER USE Notes Account Identification Number Teller

$100 Coins

0655 29865 $50

Account Name $20 Cheques 85,000

Sydney Wide Realty Group $10 $5 TOTAL$ 85,000

Payment of trust money.Licensees in charge to authorise trust account withdrawals

Only a licensee in charge (LIC) of a business may authorise trust account withdrawals from a trust account.

This means that LICs are responsible for reviewing and approving all transactions for the trust account before they occur, including electronic fund transfers and payment of trust money by cheque.

There can also only be one LIC who is able to authorise withdrawals for a trust account.

An LIC will be unable to delegate their authority to another person.

LICs should be aware that if they allow another person to withdraw funds from the trust account on their behalf, they may still be held liable for any breach or defalcation.

Note:

Signing Cheques: Only the licensee in charge may sign cheques for payments from an agency trust account. This function cannot be delegated.

Effecting Electronic funds transfers The Regulations allow another person in the agency, other than the licensee in charge, to physically disburse funds from a trust account by electronic means.

For example, under instruction from the licensee in charge, the other person may press a button to release funds from a bank account, but only if the licensee in charge responsible for that trust account has first authorised the withdrawal.

For each electronic funds transfer from an agency trust account, a record must be kept of:

the name of the person effecting the transfer

the reference number or other particulars sufficient to identify the transfer

details identifying the ledger accounts to be debited

the reason for the transfer.

Property and Stock Agents Regulation 2014

Part 4 section 24

Payment of trust money by cheque or electronic funds transfer

(1)Trust money must not be drawn from a licensees trust account otherwise than by cheque or electronic funds transfer in accordance with this clause.

Cheques(2)Each cheque must

(a)be machine numbered in series, and

(b)be marked not negotiable, and

(c)not be payable to cash, and

(d)contain the name of the licensee or (if appropriate) of the licensees firm and the words Trust Account, and

(e)be signed by the licensee in charge.

(3)The licensee must ensure that cheques are drawn in the numerical order of the series to which they belong and that for each cheque a record is kept of:

(a)The number and date of issue of the cheque, the name of the payee and the amount of the cheque, and

(b)details identifying the ledger account to be debited and the name and ledger reference number of the person on behalf of whom the cheque was drawn, and

(c)The reason for which the cheque was drawn and the invoice number that is applicable to that cheque, if one is available to the licensee.

(4)If the licensee maintains an accounting system that (at the same time as that at which, and in the same operation as that in which, a cheque is drawn) causes the particulars required by subclause (3) to be entered directly in the cash book required to be kept under clause 26, the entry of the particulars in the cash book is a sufficient compliance with the record keeping requirements of subclause (3).

Electronic Funds Transfer(5)The licensee must ensure that, for each electronic funds transfer, a record is kept of:

(a)The name of the person effecting the transfer and

(b)The reference number or other particulars sufficient to identify the transfer, the date of the transfer, the name of the payee and the amount transferred to or from each ledger account, and

(c)Details identifying the ledger accounts to be debited and the name and ledger reference number of each person on behalf of whom the transfer was made, and

(d)Particulars of the reason for the transfer.

Property management paymentsThe Managing agency agreement sets out all payment details regarding the funds that the agency holds in the property management trust account. The agency must follow these instructions strictly, and any variation must be completed in writing and signed by both the owner and the agency.

Landlords are generally paid either mid-month, end of the month or in some cases both. The agency must pay the rental monies collected for the month (less the approved expenses) to the owner at the end of each month unless the agent has received other instructions in writing. The agreement will also inform the agency how the owner would like to be paid, which could be by cheque or EFT.

Payments the agency may make on behalf of the owner could include:

management fees (amount set out in the agreement)

water rates

council fees

repairs

strata fees

letting fees

advertising

tribunal fees.

The agent should always confirm repairs or large payments with the owners before paying the tradespeople.

The Agent should:

Check the management agreement

Check the balance in the landlords account, to determine whether there are enough funds to make the payment

Email the Landlord to seek approval to pay the invoice if there are enough funds

If there are not enough funds in the Landlords account, ask the Landlord for instructions.

Do not pay the invoice until instructions from the Landlord have been received in writing.

An Owners statement must always accompany any payment made to the owner.

Property sales paymentsThe sales agreement sets out the agency costs for advertising, commission, auctioneer's fee and any other fees or charges.

A vendor statement must always accompany any payment made to the vendor.

Payments can occur for the following reasons:

Advertising: agency can deduct the advertising fees once the advertisements are completed. That can either be in a lump sum after all agreed advertising or intermittently as advertisements are completed (that is, monthly).

Commission/fees and charges: this payment cannot occur until the agent has received 'the order on the agent' from the solicitor post settlement.

Vendor payment (balance of deposit/interest): this payment cannot occur until the agent has received 'the order on the agent' from the solicitor post settlement.

Refund of deposit: can only occur before exchange or with the instruction of the vendor's solicitor.

Reporting GST collected to Landlords and Vendors.GST is a Goods and services tax (GST) it is a broad-based tax of 10% on most goods, services and other items sold or consumed in Australia.

You need an ABN to register for GST, as the ABN is part of the GST system. Your ABN will also be your GST registration number.

The real estate business will be registered for GST because it will have a turnover of $75,000 p.a. or more.

The GST collected will be recorded in the General business account.

The amount of GST collected must be recorded on the statements to the Vendors at time of settlement and the Landlords monthly statements.

The statements to the Landlord and vendors must have the words Tax Invoice and the businesss ABN number on them.

The management agreements and the sales agreements will set out the amount of commission payable including GST.

Example: - Property Management Statement

Property management commission is 7.7% of rent collected including GST.

Rent collect for the month is$ 3,300 x 7.7% = $254.10 commission inc. GST

The amount of GST included in the commission = $254.10/11 = $23.10 GST

This amount $23.10 GST must be reported to the landlords on their monthly statements.

Sydney Wide Real Estate

TAX INVOICE

ABN 112 334 877

Mr. R Price

180 Clyde Street,

Rose Bay NSW 2029

31 May 20xx

STATEMENT OF ACCOUNT for the month of May 20xx

CREDITDEBIT

$ $

Rent collected3,300

Management Commission @ 7.7%inc GST 254.10

Settlement for May EFT3,045.90

Management Commission includes GST $ 23.10

Sydney Wide Real Estate

TAX INVOICE

ABN 112 334 877

Mr. R Price

180 Clyde Street,

Rose Bay NSW 2029

31 May 20xx

STATEMENT OF ACCOUNT for the month of May 20xx

CREDITDEBIT

$ $

Rent collected3,300

Management Commission @ 7.7%inc GST 254.10

Settlement for May EFT3,045.90

Management Commission includes GST $ 23.10

Example:- Property Sales Vendor statement

Sydney Wide Real Estate

TAX INVOICE

ABN 112 334 877

Mr. K & Mrs. P. Pride

210 Elliot Street

North Bondi NSW 2026

24 May 20xx

Congratulations on the sale of your property at 55 Kent Street Smithfield

STATEMENT OF ACCOUNT

SETTLEMENT DATE: 24 May 20xx

DEBITCREDIT

$ $

Funds held in trust from K. Pike110,000

Settlement cheque85,800

Commission to Sydney Wide Real Estate 24,200

..

Commission includes GST $ 2,200

Sydney Wide Real Estate

TAX INVOICE

ABN 112 334 877

Mr. K & Mrs. P. Pride

210 Elliot Street

North Bondi NSW 2026

24 May 20xx

Congratulations on the sale of your property at 55 Kent Street Smithfield

STATEMENT OF ACCOUNT

SETTLEMENT DATE: 24 May 20xx

DEBITCREDIT

$ $

Funds held in trust from K. Pike110,000

Settlement cheque85,800

Commission to Sydney Wide Real Estate 24,200

..

Commission includes GST $ 2,200

Record of trust account transactionsCash bookProperty and Stock Agents Regulation 2014

Part 4 Section 26

A licensee must keep a record of daily receipts and payments of money into and out of the licensees trust account.

(2)The record must be in the nature of a cash book in which the pages are consecutively numbered and on the respective pages of which are shown:

(a)The consecutive numbers of receipts issued or cancelled, and

(b)The consecutive numbers of cheques drawn or cancelled, and

In the case of money received or disbursed by means of electronic funds transfer, the consecutive reference numbers, or other means of identification of the transfers.

When money required to be paid into the trust account is received, the licensee must enter into the record the particulars required by clause 23 (3) (a), (b) and (d)(g) to be entered in a receipt for the money, together with the date of the deposit of the money to the trust account and the amount of the deposit.

When money is paid out of the trust account, the licensee must enter into the record the particulars required by clause 24 (3) to be recorded for a cheque or required by clause 24 (5) to be recorded for an electronic funds transfer.

(5)At the end of each named month, the licensee must balance the cash book or other record and either

(a)carry forward the balance to the commencement of the next month, or

(b)carry forward the balance to a ledger account provided for the purpose.

(6)The licensee must, at the end of each named month, prepare a statement reconciling the balance of the licensees trust account with the balance of the related cash book or other record. (Bank reconciliation)

Trust accounting using a computer programWhether the Agency maintains their trust accounts manually or by computer system, they must comply with all parts of the Act and Regulations.

If they choose to use a computer system, they must also ensure they comply with the following regulation:

Property and Stock Agents Regulation 2014

Part 4 section 22

Computer systems control

(1)If a licensee maintains records for the purposes of this Part by means of a computer system, the licensee must comply with this clause in relation to the records.

(2)The licensee must maintain a record, compiled in chronological sequence, of all changes (including creation, amendment or deletion) to any of the following information

(a)the name of the person on behalf of whom the licensee acts,

(b)the address of the person on behalf of whom the licensee acts,

(c)the code reference number, if any, of the person on behalf of whom the licensee acts,

(d)agency description,

(e)trust account number,

disclosing the details of the information before and after the change.

(3)The licensee must ensure, in respect of any journal

(a)that entries balance before those entries are made in the ledger, and

(b)that any journal reference numbers are allocated in sequence under program control.

(4)The licensee must ensure in respect of any ledger that no program is capable of accepting the entry of a transaction resulting in a debit balance to an account unless a contemporaneous record of the transaction is made in such a manner as to enable the production in permanent legible form, on demand, of a separate chronological report of all such occurrences.

(5)The licensee must ensure in respect of any ledger that no program enables the deletion of an account unless

(a)the balance of the account is zero, and

(b)the account when deleted is retained (as it was immediately before deletion) in a form from which the information can be produced on demand in permanent legible form in the English language.

(6)The licensee must ensure that any entry in a record produced in visible form appears in chronological sequence.

(7)The licensee must ensure that a report, or each page of or entry in a report, is numbered sequentially under program control in a manner that enables the completeness of the records required to be kept by this Part to be conveniently verified.

(8)The licensee must ensure that no amendment to the particulars of a transaction already recorded can be made otherwise than by a separate transaction effecting the amendment.

(9)The licensee must ensure that each program requires input in each field of a data entry screen intended to receive information required by this Part to be included in records.

(10)The licensee must ensure that either

(a)a back-up copy of all records to which this clause refers is made on a computer disk or magnetic tape or by other electronic means not less frequently than once each month, and the most recent back-up copy is kept in such a place at a separate location that any incident (such as fire, or a power or disk failure) that could adversely affect the records would not also affect the back-up copy, or

(b)all records to which this clause refers are backed up using cloud technology through the internet not less frequently than once each month.

Property and Stock Agents Regulation 2014

Part 4 Section 28

Trust account ledger(1)A licensee must maintain a separate ledger account for trust money received on behalf of or paid to each person on behalf of whom the agent acts.

(2)The ledger account must include the name of the person on behalf of whom the licensee acts, a reference number or other identification and particulars of each transaction affecting trust money.

(3)Those particulars must include the following

(a) the date of the transaction,

(b) a description of the transaction,

(c) particulars sufficient to identify the trust record originating the transaction,

(d) the amount of the transaction,

(e) the resulting current balance of account arising from the transaction.

Property and Stock Agents Regulation 2014

Part 4 Section 29

Trust account ledger trial balance(1)A licensee must, within 21 days after the end of each named month, prepare a trial balance statement of all ledger accounts current as at the end of that month.

(2)The trial balance statement must

(a)specify the month to which it refers and the date of its preparation, and

(b)list each ledger account that does not have a zero balance at the end of that month by stating the name of the person on behalf of whom the agent is acting, the reference number or other identification and the balance of the account at the end of the month, and

(c)show the total of the ledger account balances at the end of that month, and

(d)show a comparison between that total and the balance in the cash book reconciled with the balance in the trust account as required by clause 26 (6).

Security and maintenance of the trust accountsIt is a legal requirement for all licensees in charge to ensure that the trust accounts are secure. To do this, the following procedures and checks are used:

carry out monthly trial balances and bank reconciliations, as per regulations

maintain control over cheque books and receipt books

understand and operate the trust accounting computer system

Have written procedures instructing employees of their duties regarding the trust account from receipt of monies to the bank reconciliation

Ensure employees are adequately trained to operate computer system

have individual passwords for each employee and restrict access to what the employee is legally allowed to do

create organisational policy against sharing passwords

carry out periodic checks on the work of employees

carry out monthly internal audits/reviews

carry out yearly external audits as per the ACT

back up off-site every night if using a computerised trust account system.

Electric tracking

When choosing a computer system to maintain the trust accounts ensure it has electronic tracking capabilities. Electric tracking leaves a breadcrumb trail of who accessed the trust accounts and the date it was accessed. Electronic tracking provides an audit trail that clearly identifies transactions in and out of the trust accounts.

Records of trust money to be kept by licenseesProperty and Stock Agents Regulation 2014

Part 5 Section 33

Records and book entries to be in English languageRecords and book entries to be in English language

A licensee must ensure that all written records required to be made or produced by the licensee, and all entries in books of account required to be kept by the licensee, by the provisions of the Act and this Regulation, are in the English language.

Note: There are no restrictions on the technology that can be used to make and keep records. Records can be made and kept on paper or by electronic means.

Property and Stock Agents Act 2002 No 66

Part 8 Division 1 section 104

Keeping and inspection of records

(1)A licensee must make the following records

(a)a record containing full particulars of all transactions by or with the licensee in connection with his or her business as a licensee,

(b)such other records relating to the licensees business as a licensee as may be required by the regulations.

(2)A record required by this section must be kept for at least 3 years after it is made.

(3)The record must be kept

(a)by the licensee at the licensees registered office (while the licensee remains a licensee)

(b)if the licensee ceases to be a licensee, by the former licensee in his or her possession, custody or control unless the former licensee authorises some other person to have possession, custody or control of the record, or

(c)by any other person who obtains possession, custody, or control of the record whether as a result of being the personal representative of a deceased licensee or by transfer of the business of the licensee or otherwise.

Trust account audit requirementsSecretarys Guidelines for the Proper Supervision of the Business of a Licensee under s32 of the Property and Stock Agents Act 2002 states:

Licensees' records in relation to the handling of trust money must be audited.

Who is required to have their trust accounts audited?

The following people must have their trust accounts audited if they received or held trust money during the financial year ending 30 June:

a licensee (corporation or individual)

a former licensee (corporation or individual), or

a personal representative of a licensee.

Generally, for licensed corporations, it is the corporation that receives and is responsible for trust funds and not an individual licensee. In these cases, the corporation must ensure the trust account audit takes place.

However, if an individual licensee receives and is responsible for trust money, then they must ensure the trust account audit is done.

Who is required to submit an audit?

All trust account audits must be completed and submitted online by the auditor through the Auditors Report Online portal.

When must the audit be submitted?

All audits must be submitted to the Secretary within 3 months after the end of the audit period and no later than 30 September of that year.

Please note that all previously approved alternate audit periods are now rescinded.

If a trust account audit is not submitted by the due date, licensees could be disqualified from holding or renewing a licence.

Who can conduct the audit?

Auditors must be qualified under section 115 of the Property and Stock Agents Act 2002.

Registered audit companies, authorised company auditors and members of a Professional Accounting Body holding a Public Practising Certificate or Certificate of Public Practice can conduct the audit.

Professional Accounting Body is defined under the Australian Securities and Investments Commission Act 2001, for example, CPA Australia, Chartered Accountants Australia and New Zealand and the Institute of Public Accountants.

Who can't conduct the audit?

Within the last 2 years of the audit period, an auditor must not have been employed by, nor be a partner of, the person whose records or documents are to be audited.

An auditor must not be a licensee, or a shareholder in a corporation that is a licensee with less than 20 shareholders.

Check that an auditor is registered by searching for their details on the ASIC website.

Audit recordsLicensees are required to hold a copy of their trust account audit (whether qualified or not) at their registered place of business, for at least 3 years, and make it available to Fair Trading inspectors for examination if required.

NOTE:A qualified audit is an audit which discovered a breach of the ACT or regulations.

No trust monies heldLicensees who did not hold or receive trust money during the audit year are required to note whether or not they did so when they next re-apply for their licence.

Review of Trust AccountsSecretarys Guidelines for the Proper Supervision of the Business of a Licensee under s32 of the Property and Stock Agents Act 2002

Extract:

3. Trust account procedures

3.1A principal licensee who employs a licensee in charge must:

3.1.1ensure that each trust account maintained in accordance with Part 7 o

the Act by the principal licensee, in connection with their business as a

licensee, has only one licensee in charge who is responsible for and able

to authorise withdrawal of money from that account, and

3.1.2prepare and maintain a document that clearly identifies each licensee

in charge and the trust account/s for which they are responsible.

3.2A principal licensee must prepare and maintain written procedures for the

review of trust accounts and daily or next day banking practices with respect

to the receipt of trust money.

3.3.Without limiting clause 3.2, the written procedures must ensure:

3.3.1 that each trust account has only one licensee in charge who can

authorise the withdrawal of trust money from that account, and details of

the relevant licensee in charge and trust account have been recorded for

each trust account,

3.3.2a review of trust account transactions is conducted at least once per

calendar month,

3.3.3 the amounts deposited into and withdrawn from the trust account have

been verified using the relevant financial institutions records as source

documents,

3.3.4 all persons who have access to the trust account system have

separate logins, and their passwords are not shared with anyone,

3.3.5 any adjustments shown in an end of month reconciliation can be

explained with evidence,

3.3.6 there are processes for obtaining and documenting the express

authorisation of a licensee in charge to withdraw trust funds in

accordance with the Regulation,

3.3.7rental and sales money is paid into the appropriate trust accounts, and

3.3.8rental money owing to a landlord under a residential tenancy

agreement (less any authorised expenses) is paid to the landlord at the

end of each calendar month, unless instructed otherwise by the landlord.

3.A licensee in charge must maintain a record of all cash transactions which

includes, at a minimum:

3.4.1the cash amount received,

3.4.2the name of the person who received the cash from the payer,

3.4.3the name of the person who prepared the daily banking of those funds,

3.4.4the name of the person who deposited the funds in trust at the financial

institution, and

3.4.5the trust account details.

Unclaimed trust moneyFrom 1 July 2013, the responsibility for handling unclaimed trust money was transferred from NSW Fair Trading to Revenue NSW.

The Unclaimed Money Act 1995 now applies to unclaimed money held in a trust account under the Act.

Trust money is considered unclaimed if it has been held by a licensee for more than two years in a trust account. This applies to all amounts of money.

A licensee must make reasonable efforts to locate the owner of any outstanding money in the trust account.

Failure to do so could attract a penalty of up to $5,500.

Money held in a trust account by a former licensee, or the personal representative of a deceased licensee is unclaimed money and must be returned to the Revenue NSW within three months after the person ceased to be a licensee or became a personal representative.

Failure to comply can attract a penalty of up to $5,500 and up to $550 for each additional day of non-compliance.

What to do with unclaimed trust money

All returns and payments should be made to the Chief Commissioner Revenue NSW, and not to Fair Trading.

Recording trust accounting transactions to trial balance.Trust Accounting Flow Chart

Source documents: - When transactions take place source documents are created, such as a receipt is written, or a cheque is drawn, and the details of the cheque are recorded on the cheque butt.

Journals: - The details of the transactions are entered into Journals (trust cash book) from the source documents. The trust cash book consists of the trust cash receipts journal and the trust cash payments journal. All the pages of the trust cash book must be numbered consecutively.

Trust account transfer journal:-In the event a transaction has been posted to the wrong trust ledger account the entries required to make the correction must be recorded in the trust account transfer journal.

Ledger Accounts: - A separate ledger account must be maintained for each principal. Transferring the transactions form the trust cash book to the ledger is referred to as posting to the ledger. This should be done as soon as possible after the transaction has occurred.

Note: When posting to the trust ledger accounts there must be a cross reference established between the trust cash book and the trust ledger accounts. The trust cash book page number is recorded in the trust cash book Number (TCB No.) column of the trust ledger account and the trust ledger account numbers are recorded in the trust cash book.

Trial balance The Trial Balance is merely a list of all the account balances in the trust ledger. If the double entry procedures have been followed correctly, the debit balance (The trust bank ledger account) will be equal to the credit balances (The total of the principals ledger accounts.

Financial reports are prepared: - The reports prepared from the trust ledgers will include Statements to Landlords, in accordance with the management agreements for properties under management and statements to vendors on the completion of a sale.

Trust account transfer journalsIn the event a transaction has been posted to the wrong trust ledger account the correction must first be recorded in the trust account transfer journal and signed by the Licensee in charge. This must be done prior to the transaction being entered into the trust accounting records. This is the source document for the transaction.

Property and Stock Agents Regulation 2014

Part 4 section 27

(1)A licensee must record in a journal, maintained exclusively for the licensees trust account, all transfers between accounts in the trust account ledger that are not effected by cheque or electronic funds transfer.

(2)The recording must include the following

(a) the date of the transfer,

(b) the amount transferred to and from each ledger account,

(c) the names of all ledger accounts to be debited or credited,

(d) the relevant reference number or other identification,

(e) sufficient particulars to identify the transfer and the reason for the transfer.

(3)Each transfer, when entered in the journal, is to be numbered consecutively.

Example: Trust account transfer journal:- The bond ($2,800) paid by a tenant J. Strick is posted to the Landlords, K. Smyth account and should have been posted to the Rental Bond Board Suspense account, RBB.

DR

Transfer from CR

Transfer to Date Particulars Ledger Account No. $ $ 11.5.20xX K Smyth (landlord) 210 2800.00 Signature of licensee in charge.

11.5.20xX RBB

(Rental Bond Board Suspense) 200 2800.00 Bond monies for J. Strick mistakenly placed in owner ledger K Smyth

Error rectified by transferring monies from K Smyth to RBB

Cash book

The cash book includes the trust cash receipts journal and the cash payments journal.

Each page of the trust cash book must be numbered, e.g., TCB01.

The information recorded in the Trust cash receipts journal is as follows:

Date:

The date the receipt was issued.

Receipt Number: Enter the receipt number. Receipts are source documents.

Receipt Type:

How was the money received, Cheque, EFT or Cash

Received from: The name of the person who paid the money.

On account of: Who did you receive the money for, i.e. On whose behalf are you holding the money, this will be the ledger account name.

NB: If one payment is received for both rent and bond, two receipts will be issued and will require two entries in the trust receipt journal.

Account number: Enter the trust ledger account number.

Transaction:

Why did you receive the money, e.g.,10% or preliminary deposit, rent, etc.

Amount $:

How much money was received?

Bank $: How much money was banked on this day, i.e., there may be several transactions on one day and the total of those transactions are banked on the day.

If a payment was made, it will be recorded in the trust cash payments journal, the details for each payment made are recorded as follows:-The information recorded in the Trust payments journal is as follows

Date:

The date the payment was made.

Cheque/EFTNumber: Enter the cheque number or the EFT transaction number. This is the source document number.

Payee

The name of the person/entity the payment was made to, i.e. The name on the cheque.

On account of: Who did you make the payment for, i.e., on whose behalf are you making the payment, this will be the name of ledger account.

Account number: The trust ledger account number the transaction will be posted to.

Transaction:

Why did you pay the money, e.g., stove repairs, fence repairs etc.

Bank $: The amount the cheque/EFT was for. A cheque /EFT can only be drawn for one amount.

Immediately after you have recorded the transaction in the trust cash book, post the transaction to the Principals trust ledger account. The Principals ledger accounts must be kept up to date.

Trust Ledger Accounts

The trust bank account ledger is updated at the end of each month. Receipts are posted to the Debit (DR) column and payments to the Credit (CR) column. The bank must always result in a DR balance.

Account Name: Trust Bank Account e.g., Property Management Trust AccountAccount Number: Number allocated to bank account

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

Last day of month Receipts

Cash book page number

e.g., 01 Total amount of receipts for month-Money in Total amount of payments for the month Money Out Balance after each transaction is posted. (must always be a DR balance)

The Principals ledger accounts are updated after each transaction, money received is posted to the credit column and payments are posted to the debit column, The Principals accounts must always result in a CR balance

Account Name: Name of the Principal funds are held for e.g., Landlords nameAccount Number: Account number allocated to Principal

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

Date of

transaction Details of transaction

Cash book page number

e.g., 01 Amount of Money paid out. Amount of money received Balance after each transaction is posted. (must always result in a CR balance)

End of month procedure

Balance the trust cash book.

The steps to balancing the trust cash book are as follows:

Step 1Total Receipts:

Add up both the amount column and the bank column (include the balance brought forward, if there is one) of the trust cash receipts journal, the total of these two columns must be the same. Only the total of receipts for the month is posted to the DR column of the bank trust ledger.

Step 2Total Payments:

Add up the bank column of the trust cash payments journal and write the total next to the word Sub/total.

Step 3Balance carried forward:

Calculate the balance to be carried forward to the next period; this is the amount of money which you have in the trust bank account at the end of the period. It is the amount of money which will be brought forward in the next period. The receipts minus the payments.

Note: The closing balance of one period is always the opening balance of the next period.

Total receipts journal Total payments journal = balance carried forward

Step 4Record balance carried forward:

Record the balance carried forward figure, (you just calculated), under the sub/total of payments figure and add it to the sub/total payment figure, the total should be equal to the total receipts.

Step 5Record balance carried forward, receipt side:

Record the balance brought forward figure in the bank column of the trust cash receipts journal. The date is the first day of the next period, this balance will be the entered in the amount and the bank column, as the brought forward for the beginning of the period.

Post to trust bank ledger account

The total of the receipts for the current month is posted to debit column of the trust bank ledger, the balance is then updated. The total of the payments for the month is posted to the credit column of the trust bank ledger, and then the balance is updated. The date is the last day of the month. The balance of the trust bank ledger account will be the same as the balance brought forward in the trust cash book and must always have a debit balance (DR).

Note: The amount of receipts posted to the debit column is the total received for the month; If the trust bank account had a balance brought forward from the previous period, the amount posted will be the total receipts at the end of the period minus the balance brought forward, the updated balance will be equal to total receipts in the cash book.

Prepare a Trial Balance

Only include the trust ledger accounts which have a balance. Record the trust ledger account name, account number and the balance of the account, in the corresponding debit or credit column. The total debit balance (only the trust bank account) must be equal to the total of the trust ledger accounts credit balances. If the debit balance is equal to the credit balances, you have followed the double entry accounting process correctly, you balance!!!

TRIAL BALANCE AS AT

Name of trust Account

Last day of month

__________________________________________

Name Account

Number Debit ($) Credit ($)

Trust bank account Account number Balance of trust bank account ledger Name of Principals account Account number Balance of Principals accounts

TOTAL XXXXXXX XXXXXXX

The debit balance at the bank must equal the credit balances.

Dishonoured cheques

If a cheque has been received and banked and then the bank notifies you that the cheque has been dishonoured (for example, because there are insufficient funds in the drawers bank account, or the drawer has instructed the bank not to pay the cheque), a reversal entry must be made to record that you have less money in the trust bank account than you anticipated.

It is important that you have an arrangement with the bank not to debit bank and government fees and charges to the general trust account.

Debiting the trust bank account with charges for processing a dishonoured cheque could lead to a breach of the regulations, because you would be disbursing trust money other than as directed by the client. Such charges should be debited to the businesss general bank account, or paid separately, and be entered in the office account records.

An example of a reversal entry is as follows. On 7th December 20xx J. Peters gives you a cheque for $5000 (in advance) for auction and advertising costs. As you have not yet incurred the costs and rendered a tax invoice, you pay the money into the trust account. You write a receipt, enter the receipt in the trust account receipts cash book, and post the entry to the ledger, resulting in a credit in the clients, J. Peters, ledger account.

On 10 December 20xx you receive notice from the bank the cheque has been dishonoured and make a reversal entry in the cash book. The entry is made in the cash payments journal, no cheque number, and no payee, (you are not making a payment) on account of is J. Peters and the transaction is dishonoured cheque. You then post the entry to the ledger as a debit, bringing the balance of the account back to nil, as it should be.

When J Peters pays you again with, a bank cheque or cash, a new receipt is issued and recorded in the trust cash book and trust ledger account. Any bank fees incurred are collected from the J. Peters and paid into the general business account.

Trust Exercises

Property ManagementExercise No. 1 - Class

Using the following information provided by the licensee of Sydney Realty Pty Ltd, you are required to:

Correctly complete the Trust Cash Book

Correctly complete the Trust Ledgers

Correctly complete the Trust Trial Balance as at 30th November, 20xx.

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 Agents Act 2002, and the Regulations 2014.

The next Trust Receipt Number to be issued is Number 001 and the next Trust Cheque Number is Number 001

All trust receipts are banked on day of receipt.

All receipts and payments are by cheque unless otherwise stated.

All transactions are GST free unless stated.

November 20xx

2ndObtained a tenant M. Moon, owner H. Clause. M. Moon paid with two cheques. One cheque was for two weeks rent, which amounted to $1,000, the other for $2,000, made payable to the Rental Bond Board. Do not record Bond it was made out to the RBB

Paid the office telephone account $2,500-Do not record this transaction, it belongs in the general business accounts

5thPaid J. Freshman $5,600 being his share of commission for the month of October.

7thApproved a new tenant for a townhouse owned by P. Cox. The tenant J. June paid the agency with cash, total of $3,000. This represented two weeks rent and four weeks bond.

11thPaid the Rental Bond Board all outstanding money

14thPaid B. Black $340 for repairs to the shower recess. The property is owned by P. Cox.

16thM. Moon paid three weeks rent.

18thPaid $1,200 valuation fees to N. Milan, a qualified valuer.

Paid the petrol account $978 for the month of October,

19thAdvised19/11/ by the bank the cheque from M. Moon was dishonoured.

21stM. Moon came into the office and paid cash for the same amount of the dishonoured cheque.

23rdSettled with P. Cox for the month. Property management fees 7.7% of rent collected GST inclusive.

Trust Cash Book Receipts JournalProperty Management Trust AccountSydney RealtyExercise No.PM-1 TCB No. 01

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/11/23 Balance B/FwdNIL

2/11/23 001 CHQ M. Moon H. Clause 011 2 weeks rent 1,000 1,000

7/11/23 002 CASH J. June P. Cox 012 2 weeks rent 1,000 7/11/23 003 CASH J. June Rental Bond Board (RBB) 013 Bond 2,000 3,000

16/11/23 004 CHQ M. Moon H. Clause 011 3 weeks rent 1,500 1,500

21/11/23 005 CASH M. Moon H. Clause 011 3 weeks rent 1,500 1,500

STEP 1 Add up receipts 7,000 7,000

1/12/23 Balance B/FWd2,500

Trust Cash Book Payments JournalExercise No. PM 1 TCB No. 01

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

11/11/23 001 Rental Bond Board Rental Bond Board 013 Bonds 2,000

14/11/23 002 B. BLACK P. Cox 012 Shower recess repair 340

19/11/23 ----- ---------------------- H. Clause 011 Dishonoured Chq - Moon 1,500

23/11/23 003 Sydney Realty Pty Ltd P. Cox 012 Management fee 77

23/11/23 004 P. Cox P. Cox 012 Settlement 583

STEP 2 Add up payments Subtotal 4,500

Step 3 Calaculate Bal C/Fwd7000-4500=2500 Step 4 record and add bal C/Fwd2,500

7,000

Trust Ledger Accounts.Exercise No. PM -1

Account Name: Property Management Trust bank AccountAccount Number: 010

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/11/23 Balance B/FwdNIL

30/11/23 Receipts 01 7,000 7,000 DR30/11/23 Payment 01 4,500 2,500 DRAccount Name: H. ClauseAccount Number: 011

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

2/11/23 2 weeks rent - Moon 001 1,000 1,000 CR16/11/23 3 weeks rent Moon 001 1,500 2,500 CR19/11/23 Dishonoured Chq- Moon 001 1,500 1,000 CR21/11/23 3 weeks rent Moon 001 1,500 2,500 CRAccount Name: P. Cox

Account Number: 012

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

7/11/23 2 weeks rent June 01 1,000 1,000 CR14/11/23 Shower recess repair 01 340 660 CR23/11/23 Management fee 01 77 583 CR23/11/23 Settlement 01 583 NIL

Account Name: Rental Bond BoardAccount Number: 013

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

7/11/23 Bond June 01 2,000 2,000 CR11/11/23 Bonds 01 2,000 nil

TRIAL BALANCE AS AT

_____30/11/23__________

Name Account

Number Debit ($) Credit ($)

PM Trust bank Account 010 2,500 H. Clause 011 2,500

TOTAL 2,500 2,500

Property Management

Trust Exercise No. 2

This exercise includes recording opening balances.

Using the following information provided by the licensee of Bondi Realty Pty Ltd, you are required to:

Correctly complete the Trust Cash Book

Correctly complete the Trust Ledgers

Correctly complete the Trust Trial Balance as at 31st May, 20xx.

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, and the Regulations 2014.

The next Trust Receipt Number to be issued is Number 55 and the next Trust Cheque Number is Number 73

All trust receipts are banked on day of receipt.

All receipts and payments are by cheque unless otherwise stated.

All transactions are GST free unless stated.

The Trust Ledger had the following balances as at 30th April 20xx

100Trust Bank Account$ 2,000 Debit

130L. Fox$ 2,000 Credit

Record opening balances:-The opening balance for the trust bank account is recorded on the first line in the amount and bank columns of the trust cash receipts journal and on the first line of trust bank ledger account. The date is 1st day of the period. Balance brought forward can be abbreviated to Balance B/Fwd.

The balance(s) B/Fwd. are recorded in the principals trust ledger accounts.

Once the trust cash book and ledgers have been established and the opening balances have been recorded, you can start recording the transaction for the month

May

2ndObtained a new tenant, P. Marcher for a property owned by K. Richards. Marcher paid with 2 cheques, one for 2 weeks rent $1,100 and the other made payable to the Rental Bond Board $2,200.

3rdP. Malone, who rents from L. Fox paid 3 weeks, rent $1,500, by EFT.

6thPaid $250 to ABC repairs for a repair to the stove on behalf of L. Fox

9thObtained a new tenant D. Shaw, for a property owned by M. Pike, Shaw paid a total of $3,360 for 2 weeks and 4 weeks bond.

10thSettled with L. Fox for the month, management fee $120 Inc. GST

10thPaid all monies held to the Rental Bond Board

15thPurchased a new photocopier $5,600

Paid monthly salaries $5,600

17thReceived 1 weeks rent from D. Shaw (Landlord M. Pike)

20thThe last cheque from D. Shaw was dishonoured. D. Shaw came into the office and paid with cash and it was banked today.

21stPaid Wentworth Courier $920 for the months advertising.

25thPaid $275 to All Fences for a fence repair to the property owned by M. Pike.

27thP. Malone paid 2 weeks rent (Landlord Fox)

30th Settled with M. Pike, management fee is 7.7%including GST of rent collected.

Trust Cash Book Receipts JournalExercise No. PM02TCB No. 02

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/5/23 Balance B/Fwd2,000 2,000

2/5/23 55 CHQ P. Marcher K. Richards 131 2 weeks rent 1,100 1,100

3/5/23 56 EFT P. Malone L. Fox 130 3 weeks rent 1,500 1,500

9/5/23 57 CHQ D. Shaw M. Pike 132 2 weeks rent 1,120 9/5/23 58 CHqD. Shaw Rental Bond Board (RBB) 133 Bond 2,240 3,360

17/5/23 59 CHQ D. Shaw M. PIKE 132 1 weeks rent 560 560

20/5/23 60 CASH D. Shaw M. Pike 132 1 weeks rent 560 560

27/5/23 61 CHQ P. Malone L. Fox 130 2 weeks rent 1,000 1,000

10,080 10,080

1/6/23 Balance C/ Fwd2,100

Trust Cash Book Payments JournalExercise No. 2TCB No.02

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

6/5/23 73 ABC Repairs L. Fox 130 Stove repair 250

10/5/23 74 Bondi Realty Pty Ltd L. Fox 130 Management fee 120

10/5/23 75 L. Fox L. Fox 130 Settlement 3,130

10/5/23 76 Rental Bond Board RBB 133 Bonds 2,240

20/5/23 ------ ----------------------- M. Pike 132 Dishonoured chq Shaw 560

25/5/23 77 All Fences M. Pike 132 Fence repair 275

30/5/23 78 Bondi Realty Pty Ltd M. Pike 132 Management fee @ 7.7% 129.36

30/5/23 79 M. Pike M. Pike 132 Settlement 1,275.64

Sub/Total 7,980

10,080 7980 = 2,100 Balance C/Fwd2,100

10,080

Trust Ledger Accounts.

Account Name: Bondi Realty Property Management Trust Bank AccountAccount Number: 100

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/5/23 Balance B/Fwd2,000 DR31/5/23 Receipts 02 8,080 10,080 DR31/5/23 Payments 02 7,980 2,100 DRAccount Name: L. FoxAccount Number: 130

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/5/23 Balance b/Fwd2,000 CR3/5/23 3 weeks rent Malone 02 1,500 3,500 CR6/5/23 Stove repair 02 250 3,250 CR10/5/23 Management fee 02 120 3,130 CR10/5/23 Settlement 02 3,130 NIL

27/5/23 2 weeks rent Malone 02 1,000 1,000 CRAccount Name: K. RichardsAccount Number: 131

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

2/5/23 2 weeks rent - Marcher 02 1,100 1,100 CR

Account Name: M. PikeAccount Number: 132

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

9/5/23 2 weeks rent - Shaw 02 1,120 1,120 CR17/5/23 1 weeks rent Shaw 02 560 1,680 CR20/5/23 Dishonoured Chq- Shaw 02 560 1,120 CR20/5/23 1 weeks rent 02 560 1,680 CR25/5/23 Fence repair 02 275 1,405 CR30/5/23 Management fee 02 129.36 1,275.64

30/5/23 Settlement 02 1,275.64 NIL

Account Name: Rental Bond BoardAccount Number: 133

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

9/5/23 Bond shaw 02 2,240 2,240 CR10/5/23 Bonds 02 2,240 NIL

Account Name: Account Number:

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

TRIAL BALANCE AS AT

_________________31/5/23_________________________

Name Account

Number Debit ($) Credit ($)

Bondi Realty PM Trust Account Bank 100 2,100 L. fox 130 1,000

K. Richards 131 1,100

TOTAL 2,100 2,100

Sales

Exercise 1- Class

Using the following information provided by the licensee of Sydney Realty Pty Ltd, you are required to:

Correctly complete the Trust Cash Book

Correctly complete the Trust Ledgers

Correctly complete the Trust Trial Balance as at 30th November, 20xx.

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 Agents Act 2002, and the Regulations 2014.

The next Trust Receipt Number to be issued is Number 001 and the next Trust Cheque Number is Number 001

All trust receipts are banked on day of receipt.

All receipts and payments are by cheque unless otherwise stated.

All transactions are GST free unless stated.

November 20xx

2ndSigned an exclusive listing for a property owned by P. Gold. The property has been listed for sale at $965,000.

Received $25,000 being a deposit from J. Lots for a property owned by S. Pleat

3rdReceived $720 from P. Gold for advertising his property.

Received a bank cheque for $235,000 (10% deposit) from L. Snow for a property owned by T. Thong. Both parties agreed for this amount to be deposited in an interest bearing account with Citibank until settlement takes place, at which time the interest earned thereon will be shared equally between the two parties.

Paid the office telephone account $2,500

20thReceived $40,000 from C. Lowman, being a preliminary deposit for a property owned by S. Pauly.

24thC. Lowman paid the remainder of the 10% deposit for the property owned by S. Pauly, Sale price is $1,100,000.

30thThe sale Thong to Snow settled. The initial investment, plus interest of $2,100 was bank into the trust account. Cheques were draw including a cheque for $162,440 for commission.

Trust Cash Book Receipts JournalSales Trust AccountExercise No. ST Ex01TCB No. 01

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/11/23 Balance B/FwdNIL

2/11/23 001 CHQ J. Lots Pleat to Lots 011 Deposit 25,000 25,000

3/11/23 002 CHQ P. Gold P. Gold 012 Advertising 720 3/11/23 003 B CHQ L. Snow Thong to Snow 013 10% Deposit 235,000 235,720

20/11/23 004 CHQ C. Lowman Pauly to Lowman 014 Preliminary deposit 40,000 40,000

24/11/23 005 CHQ C. Lowman Pauly to Lowman 014 Balance of 10% deposit 70,000 70,000

30/11/23 006 CHQ Citibank Thong to Snow 013 10% deposit plus interest 237,100 237,100

607,820 607,820

1/12/23 Balance B/Fwd135,720

Trust Cash Book Payments JournalExercise No.01TCB No.01

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

3/11/23 001 Citibank Thong to Snow 013 Investing 10% deposit 235,000

30/11/23 002 Sydney Realty Pty Ltd Thong to Snow 013 Commission 162,440

30/1/23 003 Snow Thong to Snow 013 Half interest earned 1,050

30/1/23 004 Thong Thong to Snow 013 Settlement + interest 73,610

Sub/Total 472,100

Bal C/Fwd 607,820-472,100 = 135,720 Balance c/Fwd135,720

607,820

Trust Ledger Accounts.Exercise No. S 01

Account Name: Sydney Realty Sales Trust Bank accountAccount Number: 010

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/11/23 Balance b/FwdNIL

30/11/23 Receipts 01 607,820 607,820 DR30/11/23 Payments 01 472,100 135,720 DRAccount Name: Pleat to Lots

Account Number: 011

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

2/11/23 Deposit 01 25,000 25,000 CRAccount Name P. Gold

Account Number: 012

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

3/11/23 Advertising 01 720 720 CR

Account Name: Thong to Snow

Account Number: 013

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

3/11/23 10% Deposit 01 235,000 235,000 CR3/11/25 Invest 10% deposit 01 235,000 NIL

30/11/23 10% Dep + Int 01 237,100 237,100 CR30/11/23 Commission 01 162,440 74,660 CR30/11/23 interest 01 1,050 73,610 CR30/11/23 Settlement + Int 01 73,610 NIL

Account Name: Pauly to LowmanAccount Number: 014

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

20/11/23 Prelim Dep 01 40,000 40,000 CR24/11/23 Bal 10% deposit 01 70,000 110,000 CRTRIAL BALANCE AS AT

_________________30/11/23_________________________

Name Account

Number Debit ($) Credit ($)

Sales trust bank account 010 135,720 Pleat to Lots 011 25,000

P. Gold 012 720

Pauly to Lowman 014 110,000

TOTAL 135,720 135,720

Sales- Exercise 2

This exercise includes recording opening balances.

Using the following information provided by the licensee of Bondi Realty Pty Ltd, you are required to:

Correctly complete the Trust Cash Book

Correctly complete the Trust Ledgers

Correctly complete the Trust Trial Balance as at 31st May, 20xx.

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 Agents Act 2002, and the Regulations 2014.

The next Trust Receipt Number to be issued is Number 55 and the next Trust Cheque Number is Number 73

All trust receipts are banked on day of receipt.

All receipts and payments are by cheque unless otherwise stated.

All transactions are GST free unless stated.

The Trust Ledger had the following balances as at 30th April 20xx

100Trust Bank Account$44,000 Debit

110P. Nords to J. Ride$24,000 Credit

120J. Stein to K. Peters$20,000 Credit

Record opening balances:-The opening balance for the trust bank account is recorded on the first line in the amount and bank columns of the trust cash receipts journal and on the first line of trust bank ledger account. The date is 1st day of the period. Balance brought forward can be abbreviated to Balance B/Fwd.

The balance(s) B/Fwd. are recorded in the principals trust ledger accounts.

Once the trust cash book and ledgers have been established and the opening balances have been recorded, you can start recording the transaction for the month.

May

5thReceived $550,000 a 10% deposit, from C. Lone for a property owned by R. Rob. Both parties agreed to invest the deposit in an interest bearing account, at Westpac, until settlement. Interest earned will be shared equally between the two parties.

7thThe sale Stein to Peters has now settled, the balance of the deposit was forwarded to the vendor by after deducting commission of $8,300 including GST.

15thPurchased a new photocopier $8,600

Paid monthly salaries $9,600

17thReceived a preliminary deposit $55,000 from S. Rite for a property owned by T. Antler.

19thReceived $5,500 for auction and advertising for a new listing of property owned by J Swift

21stPaid Wentworth Courier $620 for the months advertising.

28thS. Rite paid the balance of the 10% deposit on the property owned by T. Antler; the sale price is $1,500,000.

31st The sale Rob to Lone settled. The initial deposit plus the interest earned, $1,200 was received into the trust bank account by EFT. Cheques were draw including a cheque for commission of $105,000.

Trust Cash Book Receipts JournalSalesExercise No.2TCB No.02

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/5/23 Balance B/Fwd44,000 44,000

5/5/23 55 CHQ C. Lone Rob to Lone 121 10% Deposit 550,000 550,000

17/5/23 56 CHQ S. Rite Antler to Rite 122 Preliminary dep 55,000 55,000

19/5/23 57 CHQ J. Swift J. Swift 123 Auction & Advertising 5,500 5,500

28/5/23 58 CHQ S. Rite Antler to Rite 122 Balance of 10% Dep 95,000 95,000

31/5/23 59 EFT Westpac Rob to Lone 121 10% deposit + interest 551,200 551,200

Step 1 1,300,700 1,300,700

1/6/23 Step 5 - Balance B/Fwd179,500

Trust Cash Book Payments JournalExercise No.2TCB No.02

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

5/5/23 73 Westpac Rob to Lone 121 Investing 10% deposit 550,000

7/5/23 74 Bondi Realty Stein to Peters 120 Commission 8,300

7/5/23 75 Stein Stein to Peters 120 Settlement 11,700

31/5/23 76 Bondi Realty Rob to Lone 121 Commission 105,000

31/5/23 77 Lone Rob to Lone 121 interest earned on deposit 600

31/5/23 78 Rob Rob to Lone 121 Settlement + Int 445,600

Step 2 Sub/total 1,121,200

31/5/23 Step 3- Bal C/Fwd = 1300700-1121200 = Step 4 179,500

179,500 1,300,700

Trust Ledger Accounts.Exercise No.02

Account Name: Bondi Realty Sales Trust AccountAccount Number: 100

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/5/23 Balance B/Fwd44,000 DR31/5/23 Receipts 02 1,256,700 1,300,700 DR31/5/23 Payments 02 1,121,200 179,500 DRAccount Name: P. Nords to J. RideAccount Number: 110

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/5/23 Balance B/Fwd24,000 CRAccount Name: J. Stein to K PetersAccount Number: 120

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/5/23 Balance B/Fwd20,000 CR7/5/23 Commission 02 8,300 11,700 CR7/5/23 Settlement 02 11,700 NIL

Account Name: Rob to LoneAccount Number: 121

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

5/5/23 10% Deposit 02 550,000 550,000 CR5/5/23 Invest 10% dep 02 550,000 NIL

31/5/23 Dep + Int 02 551,200 551,200 CR31/5/23 Commission 02 105,000 446,200 CR31/5/23 Int 02 600 445,600 CR31/5/23 Settlement + Int 02 445,600 NIL

Account Name: Antler to Rite

Account Number: 122

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

17/5/23 Prelim Dep 02 55,000 55,000 CR28/5/23 Bal 10% Dep 02 95,000 150,000 CRAccount Name: J. SwiftAccount Number: 123

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

19/5/23 Auction & Ads 02 5,500 5,500 CR

TRIAL BALANCE AS AT

_________________31/5/23________________________

Name Account

Number Debit ($) Credit ($)

Bondi Sales Trust Account 100 179,500 Nord to Ride 110 24,000

Antler to Rite 122 150,000

J. Swift 123 5,500

TOTAL 179,500 179,500

Bank ReconciliationsWhat is a Bank Reconciliation?

A bank reconciliation bank rec', is a process by which you identify and explain any differences between how much cash you think you have, and the amount of cash shown on your bank balance.

It is very unlikely that at any given moment the bank's records will exactly match those of the business.

Bank reconciliations

Trust Account

It is a requirement of the Property, Stock and Business Agents Regulation 2014:- The Licensee must, at the end of each month, prepare a statement reconciling the balance of the licensees trust account with the balance of the related cash book. A bank reconciliation must be performed on the Trust bank account at the end of each month.

General Business Account

A bank reconciliation has two extremely important purposes: To verify that your accounting records are accurate and to ensure that the bank has correctly credited your account with all the cash owed to you. The reconciliation allows you to ensure that your records, and the bank's, are correct.

What can cause discrepancies?

A discrepancy is something which appears in one of these sets of records but not in the other. In order for the two sets of records to match, any errors must be removed, and every legitimate transaction must appear somewhere in both sets.

TimingThe accounting and bank records you are working with are a snapshot of your financial position from two different perspectives and one of the main causes of differences between them is simply timing for example, you will have recorded a transaction in your cash ledger the moment you received a cheque or made a deposit, but this may not yet have been processed by the bank. In a few days the bank's records will catch up with your own.

Bank fees and chargesThe bank may automatically debit your account with fees or interest. Until you receive your statement you will have no record of these amounts. When opening a Trust account an arrangement with the financial institution needs to be made, so any fees or charges are debited to the general business.

Un-presented chequesWhen a company issues a cheque it immediately records the payment as having been made, but many cheques do not get presented by the recipient until sometime later. You will have to account for the missing cheque in each bank reconciliation until it is finally cashed or is cancelled and reissued.

Other DiscrepanciesDuring a reconciliation you may also identify errors in one of the sets of records for example transposed figures (652 instead of 562) or amounts which were incorrectly credited or debited to your account by the bank.

If the error occurred in the cash book, it must be corrected in the cash book and the relevant ledger account updated. If the bank made the error, it must be recorded on the bank reconciliation and the error must be communicated to the bank.

How to perform a bank reconciliation

Step 1.Compare your bank statement with your records (cash book)

Verify transactions by comparing the trust bank statement to the trust cash records of the business, i.e., trust cash receipts and trust payments journals (trust cash book) and the previous months bank reconciliation. Tick off transactions which match. That is, tick off transactions which appear in the trust records of both the business and the bank statement.

Note: If you are preparing the first bank reconciliation for the business, there will not be a bank reconciliation from the previous month. Therefore, you will only compare the cash book with bank statement.

Step 2.Update cash records of the business

Transactions which appear in the bank statement but were not ticked off in step 1 ("bank initiated transactions") must be recorded in the trust cash book. These transactions may include direct deposits, dishonoured cheques.

If the trust cash book has already been balanced and posted to the trust bank ledger account, these transactions should be recorded in the trust general journal and posted directly to the bank ledger account.

If trust cash book has not yet been balanced and posted to the ledger, the transactions may be added to the appropriate journal of the trust cash book, before the cash book is balanced, and included in posting the totals to the trust bank ledger account.

Where errors have been identified in Step 1 and it is determined that the bank record of the transaction is correct, an adjustment should be made as part of this step. Errors by the bank will be adjusted in Step 3.

Step 3.Prepare bank reconciliation

Transactions which appear in the cash records of the business but were not ticked off in Step 1 have not yet been received or processed by the bank. These transactions will include:

Outstanding deposits - recorded by the business as cash receipts but not appearing as a credit on the bank statement.

Unpresented cheques - recorded by the business as a cash payment but not yet debited to the bank statement.

These outstanding transactions must be allowed for in order to reconcile the bank statement balance with the final bank account balance determined in Step 2.

Bank errors - Where errors were identified in Step 1 and it is determined that the trust records of the business are correct; the bank statement balance must be adjusted to correct the error in this step. If you find any errors, add or deduct the amounts from your bank balance, on the bank reconciliation, and contact the bank with details.

Step 4.Compare the final balances

The adjusted bank balance and the adjusted trust cash book balance should be the same. If they don't match, then you will need to check everything again. Reconciliation has only been achieved when both sets of records show the same, true cash balance.

Step 5.Adjust your accounting records

If you have made any adjustments to your cash balance you will need to record these in your accounts, both in your bank ledger and in the corresponding ledger account. For example, if a customer's cheque has bounced you will need to record both the decrease in your cash balance, and an increase in the amount owed to your business by that customer.

Comprehensive ExampleThe example below shows the bank reconciliation as at 31 January 20xx, cash receipts and payments journals (cash book simplified) for February 20xx and the trust bank account statement received from the bank as at 28 February.

Note: The trust cash book in this example and the following exercises has been simplified, providing you only with the information you need to prepare a bank reconciliation.

Step 1 Has been completed with matching transactions ticked off (in red) between the trust bank statement and the simplified trust cash book and the following items identified:

An error has been identified in the amount of cheque number 43564 (circled in red).

Bank initiated transactions appearing on the trust bank statement which are not recorded in the trust cash book. (Indicated with an asterisk *).

Outstanding deposits (o/s) and unpresented cheques (u/p) marked on the trust cash book.42405301569720

00

190500681355Sydney Property Services Pty LtdTrust Bank Reconciliation as at 31/1/20xx

Credit balance as per bank statement 31/1/20xx$ 6,075

Add: Outstanding deposits 850

6,925

Less:Unpresented cheques $

Cheque No.43560 23243558up485 717

Debit balance as per Trust Cash Book 31/1/20xx 6,208

00Sydney Property Services Pty LtdTrust Bank Reconciliation as at 31/1/20xx

Credit balance as per bank statement 31/1/20xx$ 6,075

Add: Outstanding deposits 850

6,925

Less:Unpresented cheques $

Cheque No.43560 23243558up485 717

Debit balance as per Trust Cash Book 31/1/20xx 6,208

33318451806575

00

3400425197104000Trust Cash Book (Simplified)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

Feb

balance b/Fwd57150121920

00

6,208

Feb

236855175260

00

6

1057910123825

00

Receipts

770

5 Payments 43561 198755139065

00

510

15

1057910119380

00

Receipts

1,840

14 Payments 43562 76835187960

00

3,020

23

106235516256000Receipts

860

18 Payments 43563 14224017970500 1,260

28

Receipts

o/s 2,46022 Payments 43564 error 41523 Direct deposit 1,100 28 Payments 43565 3956051650900up 92016 Dishonoured c 250

23 Adj for error 43564 36

Sub/Tot 6,411

Bal C/Fwd6,827

13,238 13,238

1/3 Bal B/Fwd6,827

Step 2

The entries required for step two are shown above with cash journals and bank initiated transactions recorded in the simplified trust cash book (In blue). An adjusting entry is also recorded for the error in cheque number 43564 assuming the trust bank statement entry is correct. Balance the cash book, the procedure for balancing the cash is the same as in the previous exercises.

CITI BANKBank Statement Sydney Property Services Pty LtdTrust Account

Date

Details

Debit

Credit

Balance

FEB

1 1 Opening Balance 205740244475

00

6,075 CR1

Deposit 850 6,925 CR7

Deposit 22860039370

00

770 7,695 CR8 43560 28765533655

00

232 7,463 CR10 43561 22479025400

00

510 243840276860

00

6,953 CR15 Deposit 1,840 8,793 CR16 Dishonoured chq *250 8,543 CR18 43562 7429544450

00

3,020 5,523 CR22 43563 8001059690

00

1,260 4,263 CR23 Direct Deposit *1,100 5,363 CR23 43564 742952921000error 45124 Deposit 31242058420

00

860 5,772 CR28 Bank fees *40 5,732 CR28 Dishonoured chq fee *95 5,637 CR

Step 3Prepare bank reconciliation

Note: Arrangements have been made for any bank fees to be debited to the general business account, therefore the fees are added to the bank reconciliation and the bank would be notified to correct the error.

Bank Reconciliation as at 28/2/2015

Credit balance as per bank statement $

$

5,637

Add: outstanding deposits: 28/2/15 2,460 Bank fees in error 40 Dishonoured chq fee 95 2,595

8,232

Less: unpresented cheques: - chq 43558 (still O/S from previous month) 485 - chq 43565 920 1 405

Debit balance as per trust cash book 6,827

Bank reconciliations ExercisesExercise No. 1 (Simple, no previous bank reconciliation)

Trust Bank Reconciliation, 31/12/20xx

Sydney Property Services Pty Ltd

Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

Dec 1 Balance B/Fwd813 Dec 2 Payments 501 x266

9 Receipts x341 11 Payments 502 x260

20 Receipts x1,520 16 Payments 503 Up 385

28 Receipts x2,550 18 Payments 504 x380

31 Receipts o/s 3,202 27 Payments 505 x98

8,426 29 Payments 506 up310

31 Payments 507 up450

Payments 508 up31

1/1/xx Bal B/Fwd6,246 Sub/tot 2,180

Bal C/F 6,246

8,426

Note: Arrangements have been made for all bank fees and charges to be debited to the general business account. If errors are detected, the bank statement is correct.

Westpac Bank Statement

Sydney Property services Pty Ltd - TRUST ACCOUNT-

Date

Details

Debit

Credit

Balance

20xx $ $ $

Dec 1 Balance B/Fwd813 CR2 501 x266 547 CR9 Cash/Chqx341 888 CR14 502 x260 628 CR20 Cash/Chqx1,520 2,148 CR28 505 x98 2,050 CR28 Cash/Chqx2,550 4,600 CR29 504 x380 4,220 CR

Sydney Property Services Pty Ltd

Trust Bank Reconciliation as at 31/12/20xx

$ $

Credit balance as per bank statement 31/12/20XX Add: Outstanding deposit 31/12/20xx Less: Unpresented cheques Chq No Debit balance as per Trust Cash Book as at 31/12/20xx

Exercise No. 2 (Errors in cash book)

From the following records, prepare a bank reconciliation as at 30 June 20xx. Where there are differences in amounts between the bank statement and the records of the business, assume that the Bank statement is correct.

Previous months bank reconciliation

TOP Property services Pty LtdBank Reconciliation Statement as at 31 May 20xx

Credit balance as per bank Statement 31/5/xx $ $

29,000

Add: Outstanding deposit 27/5/xx

28/5/xx

Bank fees in error

x4,923

x2,729

x21 7,673

36,673

Less: unpresented cheques. Chq No. 873

881

897

906

908 up463

x1,000

x471

x873

up1,190 3,997

Debit balance as per Trust cash book 31/5/xx 32,676

TOP Property services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

June 1 Balance B/Fwd32,676 June 1 Payments 910 up175

5 Receipts x10,070 3 Payments 911 x2,120

10 Receipts x4,093 7 Payments 912 x2,163

15 Receipts x10,782 12 Payments 913 x1,124

20 Receipts x830 20 Payments 914 x295

25 Receipts x19,347 21 Payments 915 up4,090

30 Receipts o/s 1,460 21 Payments 916 x174

5 Adjust for err 1.00 23 Payments 917 up81

79,259 26 Ajust for error 914 (2.00)

10,220

Bal C/F 69,039

1 July Bal B/F 69,039 79,259

79259-10220

WestpacTOP Property Services Pty Ltd Trust Account

Date Particulars Debit Credit Balance

June 1 Balance B/Fwd29,000 CRDeposit x4,923 33,923 CR2 Deposit x2,729 36,652 CR881 x1,000 35,652 CR897 x471 35,181 CR906 x873 34,308 CR6 Deposit x10,071 44,379 CR911 x2,120 42,259 CR7 Reversed bank fees x21 42,280 CR12 Deposit x4,093 46,373 CR912 x2,163 44,210 CR16 Deposit x10,782 54,992 CR913 x1,124 53,868 CR21 Deposit x830 54,698 CR26 Deposit x19,347 73,045 CR914 x293 73,752 CR30 916 x174 73,578 CR

TOP Property services Pty Ltd

Trust Bank Reconciliation as at 30/6/20xx

$ $

Credit balance as per bank statement 30/6/20XX 73,578

Add: Outstanding deposit 30/6/20xx 1,460 1460

75,038

Less: Unpresented cheques Chq No

873 463

908 1,190

910 175

915 4,090 917 81 5,999

Debit balance as per Trust Cash Book as at 30/6/20xx 69,039

Exercise No. 3 (Cashbook error)

From the following records, prepare a bank reconciliation as at 31 May 20xx. Where there are differences in amounts between the bank statement and the records of the business, assume the Bank Statement is correct

Charlestown Property Services Pty LtdBank reconciliation statement as at 30/4/20xx

$ $

Credit balance as per bank statement 30/4/xx 6,092

Add: Outstanding deposits 29/4/20xx

30/4/20xx

Add: Adjustment to deposit 18/4/xx

Bank fee in error 2,040

1,700

125

30 3,740

155

9,987

Less: unpresented cheques: Chq No Less: Error- Adjust chq No. 606 601

604

608

609

610

110

400

750

200

57 1,517

20

1,537

Debit balance per Trust cash book 30/4/xx 8,450

Charlestown Property Services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank$

May 1 Balance B/Fwd8,450 May 3 Payments 611 555

5 Receipts 3,400 7 Payments 612 480

8 Receipts 2,100 16 Payments 613 65

28 Receipts 2,450 21 Payments 614 810

31 Receipts 1,800 30 Payments 615 120

Payment 616 262

WestpacCharlestown Property Services Pty Ltd Trust Account

Date Particulars Debit Credit Balance

May 1 Balance B/Fwd6,092

2 Deposit 2,040 8,132 CRDeposit 1,700 9,832 CR4 Adjust error deposit 18/4 125 9,957 CRAdjust error bank fees 30 9,987 CR5 Deposit 3,400 13,387 CR604 400 12,987 CR7 608 750 12,237 CR610 57 12,180 CR612 480 11,700 CR9 Deposit 2,100 13,800 CR17 611 525 13,275 CR18 609 200 13,075 CR613 65 13,010 CR20 601 110 12,900 CR25 614 810 12,090 CR30 Deposit 2,450 14,540 CRAdjust error chq 606 20 14,520 CR

Charlestown Property Services Pty Ltd

Trust Bank Reconciliation as at 31/05/20xx

$ $

Credit balance as per bank statement 31/05/20XX Add: Outstanding deposit 31/05/20xx Less: Unpresented cheques Chq No Debit balance as per Trust Cash Book as at 31/05/20xx

Exercise No.4 (Direct deposit, dishonoured cheque. Bank fee & cashbook error)

Sydney Property Services Pty Ltd

Trust Bank Reconciliation as at 31/1/20xx

$ $

Credit balance as per bank statement 31/1/20XX 6,075

Add: Outstanding deposit 31/1/20xx x850 850

6,925

Less: Unpresented cheques Chq No 560 x232 558 up485 717

Debit balance as per Trust Cash Book as at 31/1/20xx 6,208

From the following records, prepare a bank reconciliation as at 28 February 20xx. Where there are differences in amounts between the bank statement and the records of the business, assume that the Bank statement is correct

Sydney Property Services Pty Ltd

Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

Feb 1 Balance B/Fwd6,208 Feb 6 Receipts x770 5 Payments 561 x510

15 Receipts x1,840 14 Payments 562 x3,020

23 Receipts x860 18 Payments 563 x1,260

28 Receipts o/s2,460 22 Payments 564 xerr415

23 Direct Deposit 1,100 28 Payments 565 up920

13,238 23 Adj error 564 36

16 DIShon250

Sub/Tot 6,411

Bal C/F 6827

13,238

1/3 Bal B/F 6,827 13238-6411=

Sydney Property Services Pty Ltd

Trust Bank Reconciliation as at 28/2/20xx

$ $

Credit balance as per bank statement 28/2/20XX 5,637

Add: Outstanding deposit 28/02/20xx 2,460 Bank fees in error 40 Dishon chq fee 95 2,595

8,232

Less: Unpresented cheques Chq No 558 485 565 920 1,405

Debit balance as per Trust Cash Book as at 28/02/20xx 6,827

Westpac Sydney Property Services Pty Ltd

Trust Account

Date Particulars Debit Credit Balance

FEB 1 Opening Balance 6,075 CR1 Deposit x850 6,925 CR7 Deposit x770 7,695 CR8 560 x232 7,463 CR10 561 x510 6,953 CR15 Deposit x1,840 8,793 CR16 Dishonoured Chqx250 8,543 CR18 562 x3,020 5,523 CR22 563 x1,260 4,263 CR23 Direct Deposit 1,100 5,363 CR23 564 x451 4,912 CR24 Deposit x860 5,772 CR28 Bank fees 40 5,732 CR28 Dishonoured Chq fee 95 5,637 CR

Exercise No. 5 (Direct deposit & Bank made errors)

From the following records, prepare a bank reconciliation as at 30 June 20xx. Where there are differences in amounts between the bank statement and the records of the business, assume the Trust Cash book is correct.

TOP Property Services Pty LtdBank reconciliation statement as at 31/5/20xx

$ $

Credit balance as per bank statement 7,800

Add: Outstanding deposit 31/5/20xx 3,400 3,400

11,200

Less: unpresented cheques: Chq No 1810

1817

1822

1825

2,500

1,500

500

3,200 7,700

Debit balance per Trust cash book 31/5/20xx 3,500

TOP Property Services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank$

June 1 Balance B/Fwd3,500 June 1 Payments 1827 2,200

5 Receipts 10,071 6 Payments 1828 407

10 Receipts 4,093 11 Payments 1829 1,305

12 Receipts 10,582 14 Payments 1830 1,102

24 Receipts 230 21 Payments 1831 293

30 Receipts 1,500 28 Payments 1832 240

WestpacTOP Property Services Pty LtdTrust Account

Date Particulars Debit Credit Balance

June 1 Balance B/Fwd7,800 CRDeposit 3,400 11,200 CR1817 1,500 9,700 CR1825 3,200 6,500 CR2 Direct Deposit 450 6,950 CRBank Fees 24 6,926 CR1822 500 6,426 CR1827 2,200 4,226 CR6 Deposit 10,071 14,297 CR10 Deposit 4,093 18,390 CR13 1829 1,300 17,090 CR14 Deposit 10,582 27,672 CR

25 Deposit 330 28,002 CR1810 2,500 25,502 CR1831 293 25,209 CR30 Deposit 1,500 26,709 CR

TOP Property services Pty Ltd

Trust Bank Reconciliation as at 30/6/20xx

$ $

Credit balance as per bank statement 30/6/20XX Add: Outstanding deposit 30/6/20xx Less: Unpresented cheques Chq No Debit balance as per Trust Cash Book as at 30/6/20xx Solutions to ExercisesProperty Management Exercise No. 1

Trust Cash Book Receipts JournalProperty Management Trust AccountSydney RealtyExercise No.PM-1 TCB No. 01

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/11/20xx Balance B/FwdNIL

2/11/20xx 001 CHQ M. Moon H. Clause 011 2 weeks rent 1,000 1,000

7/11/20xx 002 CASH J. June P. Cox 012 2 weeks rent 1,000 003 CASH J. June Rental bond board 013 Bond 2,000 3,000

16/11/20xx 004 CHQ M. Moon H. Clause 011 3 weeks rent 1,500 1,500

21/11/20xx 005 CASH M. Moon H. Clause 011 3 weeks rent 1,500 1,500

Step 1- Add receipts 7,000 7,000

1/12/20xx Step 5 Balance B/FWd2,500

Trust Cash Book Payments JournalExercise No.PM 1 TCB No. 01

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

11/11/20xx 001 Rental Bond Board Rental bond Board 013 Bonds 2,000

14/11/20xx 002 B. Black P. cox 012 Shower repair 340

19/11/20xx ------- --------------------- H. Clause 011 Dishonoured Cheque 1,500

23/11/20xx 003 Sydney Realty Pty Ltd P. Cox 012 Management fees 77

23/11/20xx 004 P. Cox P. Cox 012 Settlement 583

Step 2. Total Payments 4,500

Step 4. Record balance C/Fwd2,500

Step 3 Calculate Balance carried forward 7,000-4500= 2,500 7,000

Trust Ledger Accounts.Exercise No. PM -1

Account Name: Trust bank Account Property ManagementsAccount Number: 010

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/11/20xx Balance B/FwdNIL

30/11/20xx Receipts 01 7,000 7,000 DR30/11/20xx Payments 01 4,500 2,500 DRAccount Name: H. ClauseAccount Number: 011

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

2/11/20xx 2 weeks rent - Moon 01 1,000 1,000 CR16/11/20xx 3 weeks rent Moon 01 1,500 2,500 CR19/11/20xx Dishonoured Chq Moon 01 1,500 1,000 CR21/11/20xx 3 weeks rent Moon 01 1,500 2,500 CRAccount Name: P. CoxAccount Number: 012

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

7/11/20xx 2 weeks rent June 01 1,000 1,000 CR14/11/20xx Shower repair 01 340 660 CR23/11/20xx Management fee 01 77 583 CR23/11/20xx Settlement 01 583 NIL

Account Name: Rental Bond Board Account Number: 013

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

7/11/20xx Bond June 01 2,000 2,000 CR11/11/20xx Bond 01 2,000 NIL

TRIAL BALANCE AS AT

_______________30/1120xx___________________________

Name Account

Number Debit ($) Credit ($)

Trust bank account 010 2,500 H. clause 011 2,500

TOTAL 2,500 2,500

Solution Sales Exercise No.1

Trust Cash Book Receipts JournalSales Trust AccountExercise No. ST Ex01TCB No. 01

Date Receipt

No. Receipt

Type Received From On Account Of AccountNumber Transaction Amount

$ Bank

$

1/11/20xx Balance b/FwdNIL

2/11/20xx 001 ChqJ. Lots S. Pleat to J. Lots 011 Deposit 25,000 25,000

3/11/20xx 002 CHQ P. Gold P. Gold 012 Advertising 720 3/11/20xx 003 B/ChqL. Snow Thong to Snow 013 10% Deposit 235,000 235,720

20/11/20xx 004 CHQ C. Lowman Pauly to Lowman 014 Preliminary deposit 40,000 40,000

24/11/20xx 005 ChqC. Lowman Pauly to Lowman 014 Balance of 10% deposit 70,000 70,000

30/11/20xx 06 CHQ Citibank Thong to snow 013 10% deposit + Interest 237,100 237,100

Total receipts 607,820 607,820

1/12/20xx Balance B/Fwd135,720

Trust Cash Book Payments JournalExercise No.TCB No.

Date ChequeNo. PAYEE On Account Of Account

Number Transaction Bank

$

3/11/20xx 001 Citibank Thong to snow 013 Invest 10% deposit 235,000

30/11/20xx 002 Sydney Realty Pty Ltd Thong to snow 013 Commission 162,440

30/11/20xx 003 Snow Thong to Snow 013 interest earned 1,050

30/11/20xx 004 Thong Thong to Snow 013 Settlement + interest 73,610

Total Payments 472,100

Rec Payments = Bal C/Fwd 135,720Balance C/Fwd135,720

607,820

Trust Ledger Accounts.Exercise No. Sales 01

Account Name: Sales Trust AccountAccount Number: 010

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

1/11/20xx Balance B/FwdNIL

30/11/20xx Receipts 01 607,820 607,820 DR30/11/20xx Payments 01 472,100 135,720 DRAccount Name: Pleat to LotsAccount Number: 011

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

2/11/20xx Deposit 01 25,000 25,000 CRAccount Name: P. GoldAccount Number: 012

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

3/11/20xx Advertising 01 720 720 CR

Account Name: Thong to SnowAccount Number: 013

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

3/11/20xx 10% deposit 01 235,000 235,000 CR3/11/20xx Invest 10% deposit 01 235,000 NIL

30/11/20xx 10% dep + Interest 01 237,100 237,100

30/11/20xx Commission 01 162,440 74,660 CR30/11/20xx interest 01 1,050 73,610 CR30/11/20xx Settlement + Int 01 73,610 NIL

Account Name: Pauly to LowmanAccount Number: 014

Date Particulars TCBNumber Debit

$ Credit

$ Balance

$

20/11/20xx Prelim deposit 01 40,000 40,000 CR24/11/20xx Bal 10% Dep 01 70,000 110,000 CRTRIAL BALANCE AS AT

______________30/11/20xx____________________________

Name Account

Number Debit ($) Credit ($)

Trust bank Account 010 135,720 Pleat to Lots 011 25,000

P. Gold 012 720

Pauly to Lowman 014 110,000

TOTAL 135,720 135,720

Bank reconciliation Exercise 1- Solution

Sydney Property Services Pty Ltd

Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

Dec 1 Balance B/Fwd813 Dec 2 Payments 501 266

9 Receipts 341 11 Payments 502 260

20 Receipts 1,520 16 Payments 503 385

28 Receipts 2,550 18 Payments 504 380

31 Receipts o/s 3,202 27 Payments 505 98

29 Payments 506 310

31 Payments 507 450

Payments 508 31

Sub/Total 2,180

Bal C/Fwd6,246

8,426 8,426

Jan 1 20xx 6,246 Sydney Property Services Pty Ltd

Trust Bank Reconciliation as at 31/12/20xx

$ $

Credit balance as per bank statement 31/12/20XX 4,220

Add: Outstanding deposit 31/12/20xx 3,202 3,202

Less: Unpresented cheques Chq No 503 385 506 310 507 450

508 31 1,176

Debit balance as per Trust Cash Book as at 31/12/20xx 6,246

Bank reconciliation Exercise 2- Solution

TOP Property services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

June 1 Balance B/Fwd32,676 June 1 Payments 910 175

5 Receipts 10,070 3 Payments 911 2,120

10 Receipts 4,093 7 Payments 912 2,163

15 Receipts 10,782 12 Payments 913 1,124

20 Receipts 830 20 Payments 914 295

25 Receipts 19,347 21 Payments 915 4,090

30 Receipts O/S 1,460 21 Payments 916 174

5 Deposit error 1.00 23 Payments 917 81

Adjust - error 914 (2.00)

Sub/Total 10,220

Bal C/Fwd69,039

79,259 79,259

1 July 20xx Bal B/Fwd69,039 TOP Property services Pty Ltd

Trust Bank Reconciliation as at 30/6/20xx

$ $

Credit balance as per bank statement 30/6/20XX 73,578

Add: Outstanding deposit 30/6/20xx 1,460 1,460

75,038

Less: Unpresented cheques Chq No 873 463 908 1,190 910 175 915 4,090 917 81 5,999

Debit balance as per Trust Cash Book as at 30/6/20xx 69,039

Bank reconciliation Exercise No 3 - Solution

Charlestown Property Services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank$

May 1 Balance B/Fwd8,450 May 3 Payments 611 555

5 Receipts 3,400 7 Payments 612 480

8 Receipts 2,100 16 Payments 613 65

28 Receipts 2,450 21 Payments 614 810

31 Receipts O/S1,800 30 Payments 615 120

Payment 616 262

17 Adjust for error 611 (30)

2,262

Bal C/Fwd15,938

18,200 18,200

1 June Balance B/Fwd15,938 Charlestown Property Services Pty Ltd

Trust Bank Reconciliation as at 31/05/20xx

$ $

Credit balance as per bank statement 31/05/20XX 14,520

Add: Outstanding deposit 31/05/20xx 1,800 1,800

16,320

Less: Unpresented cheques Chq No

615 120

616 262 382

Debit balance as per Trust Cash Book as at 31/05/20xx 15,938

Bank reconciliation Exercise No 4 - Solution

Sydney Property Services Pty Ltd

Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

Feb 1 Balance B/Fwd6,208 Feb 6 Receipts 770 5 Payments 561 510

15 Receipts 1,840 14 Payments 562 3,020

23 Receipts 860 18 Payments 563 1,260

28 Receipts O/S 2,460 22 Payments 564 Error 415

23 Direct Deposit1,100 28 Payments 565 920

16 Dishon Chq250

23 Adj for error 564 36

Sub/Total 6,411

13,238 13,238

1/3/20xx Bal B/Fwd6,827 Sydney Property Services Pty Ltd

Trust Bank Reconciliation as at 28/2/20xx

$ $

Credit balance as per bank statement 28/2/20XX 5,637

Add: Outstanding deposit 31/12/20xx 2,460 Bank fee in error 40 Dishonoured chq fee 95 2,595

8,232

Less: Unpresented cheques Chq No Still unpresented from last month 558 485 565 920 1,405

Debit balance as per Trust Cash Book as at 28/2/12/20xx 6,827

Bank reconciliation Exercise No 5 - Solution

TOP Property Services Pty Ltd Trust Cash Book (SIMPLIFIED)

Cash Receipts Journal Cash Payments Journal

Date20xx Particulars

Bank$ Date20xx Particulars

Chq No.

Bank

$

June 1 Balance B/Fwd3,500 June 1 Payments 1827 2,200

5 Receipts 10,071 6 Payments 1828 407

10 Receipts 4,093 11 Payments 1829 BE 1,305

12 Receipts 10,582 14 Payments 1830 1,102

24 Receipts 230 21 Payments 1831 293

30 Receipts 1,500 28 Payments 1832 240

2 Direct Deposit 450 Sub/Total 5,547

Bal C/Fwd24,879

30,426 30,426

1 July Bal B/Fwd24,879 TOP Property services Pty Ltd

Trust Bank Reconciliation as at 30/6/20xx

$ $

Credit balance as per bank statement 30/6/20XX 26,709

Add: Bank fees in error 24 24

26,733

Less: Unpresented cheques Chq No

1828 407 1830 1,102 1,102

1832 240 Adjustment for bank error 1829 5 1,752

24,979

Less: Bank error deposit overbanked 25/6/20xx 100

Debit balance as per Trust Cash Book as at 30/6/20xx 24,879

References:Property and Stock Agents Act 2002 No 66Current version for 1 September 2021

https://legislation.nsw.gov.au/view/html/inforce/current/act-2002-066Property and Stock Agents Regulation 2014Current version for 1 September 2021

https://legislation.nsw.gov.au/view/html/inforce/current/sl-2014-0563Supervising an agency

https://www.fairtrading.nsw.gov.au/housing-and-property/property-professionals/running-a-property-agencyAudit requirements

https://www.fairtrading.nsw.gov.au/housing-and-property/property-professionals/running-a-property-agency/trust-accounts

Knowledge assessment 3 of 3

Criteria

Unit code, name and release number

CPPREP4125 - Transact in trust accounts (1)

Qualification/Course code, name and release number

CPP41419 - Certificate IV in Real Estate Practice (1)

Student details

Student number

Student name

Assessment declaration

This declaration only needs to be completed if you are not submitting your assessment online.

This assessment is my original work and no part of it has been copied from any other source except where due acknowledgement is made.

No part of this assessment has been written for me by any other person except where such collaboration has been authorised by the assessor concerned.

I understand that plagiarism is the presentation of the work, idea, or creation of another person as though it is your own. Plagiarism occurs when the origin of the material used is not appropriately cited. No part of this assessment is plagiarised.

Student signature and Date

Version:20210826

Date created:03 July 2020

For queries, please contact:

Technology and Business Service SkillsPoint

TAFE NSW Ultimo

2020 TAFE NSW, SydneyRTO Provider Number 90003 | CRICOS Provider Code: 00591E

This assessment can be found in the: Learning BankThe contents in this document is copyright TAFE NSW 2020, and should not be reproduced without the permission of the TAFE NSW. Information contained in this document is correct at time of printing: DATE @ "d MMMM yyyy" * MERGEFORMAT 26 August 2021. For current information please refer to our website or your teacher as appropriate.

Assessment instructions

Table SEQ Table * ARABIC 1 Assessment instructions

Assessment details Instructions

Assessment overview The objective of this assessment is to assess your knowledge as would be required to conduct transactions in real estate trust accounts.

Assessment event number 3 of 3

Instructions for this assessment This is a written assessment that will assess your knowledge of the unit.

This assessment is in one part:

Part 1: 7 Short answer questions

The assessment also contains an assessment feedback form.

Submission instructions Where possible, complete and submit this assessment online via the TAFE NSW online learning platform. Upload all the required assessment files in the assessment area on the online learning platform.

Alternatively, hand all required assessment files to your assessor for marking. Make sure you have added your name to the bottom of each page of the assessment.

It is important that you keep a copy of all electronic and hardcopy assessments submitted to TAFE NSW and complete the assessment declaration when you submit the assessment.

What do I need to do to achieve a satisfactory result? To achieve a satisfactory result for this assessment, you must answer all questions correctly.

What do I need to provide? Computer with internet access; and Microsoft Office.

What will the assessor provide? Access to this assessment and supporting online resources.

Due date and time allowed Fully online students should refer to their Training Plan for due dates, other students should refer to the Unit Assessment Guide for due dates.

The indicative time to complete this assessment is 40 minutes.

Supervision This is an unsupervised assessment. You may access your referenced text, learning notes and other resources.

Your assessor may ask for additional evidence to verify the authenticity of your submission and confirm that the assessment task was completed by you.

Assessment feedback, review or appeals In accordance with the TAFE NSW policy Manage Assessment Appeals, all students have the right to appeal an assessment decision concerning how the assessment was conducted and the outcome of the assessment. Appeals must be lodged within 14 working days of the formal notification of the result of the assessment.

If you would like to request a review of your results or if you have any concerns about your results, contact your teacher or head teacher. If they are unavailable, contact the student administration officer.

Appeals are addressed in accordance with Every Students Guide to Assessment.

Part 1: Short answer

Read the question carefully.

Explain how authorisation is given for payments made from the trust accounts, in the following circumstances:

Activity Your answer

Settlement of a sale and payment of commission to the agent Payment of an invoice on behalf of a landlord

Payment of management fees from a landlord Payment of advertising expenses on behalf of a vendor Summarise the actions an Agent would need to take if they received an invoice for an emergency plumbing repair at a Landlords property. The invoice is for an amount more than the amount specified in the Management agreement. The plumber has given 30 days to pay the account.

Summarise the actions the licensee would need to take if there were unclaimed funds in the trust account.

Explain how long and where a licensee is required to keep all trust account records. Include in your answer the correct section from the Property and Stock Agent Act 2002 and/or the Property and Stock Agent Regulations 2014 (NSW).

Discuss how password security and electronic tracking of transactions assist in the security and maintenance of the trust accounts.

The licensee in charge has legislative responsibilities, under the Property and Stock Agents Act 2002 to schedule external audits of the trust accounts, and obligations to schedule regular internal audits of the trust accounts.When should the licensee schedule the following:

External audits

Internal audits/Review

Outline the maximum penalty for not paying trust monies collected on behalf of a client into the trust account. In your answer refer to the correct section of the Property and Stock Agents Act 2002.

Assessment feedback

NOTE: If you are submitting through an online learning platform, the assessor will give you feedback via the platform.

Assessment outcome

Satisfactory

Unsatisfactory

Assessor Feedback

Are you assured that the evidence presented for assessment is the students own work?

Was the assessment event successfully completed?

If no, was the resubmission/re-assessment successfully completed?

Was reasonable adjustment in place for this assessment event?If yes, ensure it is detailed on the assessment document.

Comments:

Assessor name and date:

NOTE: Make sure you add your name to the footer, so it appears at the bottom of each page.

  • Uploaded By : Pooja Dhaka
  • Posted on : November 24th, 2024
  • Downloads : 0
  • Views : 159

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more