Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please write the answers for reconciliation 1,2and 3 Reconciliation1 Belowarethefollowingfor the PropertyManagementTrust Account: TheTrustCashBookReceiptsandPaymentsforMay20XX BankStatementasat31May20XX YouaretoreconcilethecashbooktotheBankStatementusingthetemplateprovided CASHBOOK-RECEIPTSIDE(TCR) S-CB1 Date 20xx Rec# Type Receivedfrom OnAccountof LF

please write the answers for reconciliation 1,2and 3

Reconciliation1

Belowarethefollowingfor the PropertyManagementTrust Account:

TheTrustCashBookReceiptsandPaymentsforMay20XX

BankStatementasat31May20XX

YouaretoreconcilethecashbooktotheBankStatementusingthetemplateprovided

CASHBOOK-RECEIPTSIDE(TCR) S-CB1

Date 20xx

Rec#

Type

Receivedfrom

OnAccountof

LF

Transaction

Amount

DailyBank

1/5

BalanceBrought

Forward

0.00

2/5

223

Cash

PaulBell

JasonBrown

10

RentX2

900.00

224

Cash

AndyShort

JasonBrown

10

RentX1

550.00

1,450.00

3/5

225

Cash

PeterEdgar

Steve Smith

20

RentX2

1,000.00

226

Chq

AlfredThomas

GrantRoberts

30

RentX1

470.00

1,470.00

4/5

227

Chq

AlisonSommers

Steve Smith

20

RentX2

1,200.00

1,200.00

23/5

233

Cash

PaulBell

JasonBrown

10

RentX2

900.00

234

Cash

PeterEdgar

Steve Smith

20

RentX2

1,000.00

1,900.00

BalanceBroughtDown

6,020.00

6,020.00

THINKREALTYPROPERTYMANAGEMENTTRUSTACCOUNT TRUST CASH BOOK

CASHBOOK-PAYMENTSIDE(TCR) S-CB1

TransactionDate

EFTNo.

CHQ

No

Payee

OnAccountof

LF

Transaction

Amount

5 May

2641

CityWater

JBrown

10

WaterRates

250.00

31May

328

JasonBrown

JBrown

10

Settlement

1,931.25

329

Steve Smith

S Smith

20

Settlement

2,960.00

2642

GrantRoberts

G Roberts

30

Settlement

434.75

331

ThinkRealty

J Brown/Smith

10/20

ManagementFee

444.00

Total

6,020.00

BalanceBroughtDown

0

FinalTotal

0

THINKREALTYPROPERTYMANAGEMENTTRUSTACCOUNT TRUST CASH BOOK

ThinkRealtyPropertyManagementTrustAccount

BankStatementasat31May20xx

DateDetails/ReferenceDebitCreditBalance
Balance b/f0.00
3-MayReceipts1,450.001,450.00
4-MayReceipts1,470.002,920.00
5-MayReceipts1,200.004,120.00
24-MayReceipts1,900.006,020.00
27-May2641250.005,770.00
31-May3281,931.253,838.75
3292,960.00878.57
331444.00434.75

Youaretoacceptalltheentriesinthebankstatementinthisexercisearecorrect

INSTRUCTIONS

OnthenextpageyouaretoreconciletheTrustAccounttothebankstatement

THINKREALTYSALESTRUSTACCOUNT

BankReconciliationasat

Balanceasperbankstatement $

ADDOutstandingDeposits

SubTotal$

AddBankCharges

AddTotalAdjustments

$

$

LESSUnpresentedChequesChq# Amount

Subtotal$

LessTotalAdjustments

CRBalanceasperbankstatement(adjusted)

$

$

DRBalanceaspercashbook$

ASSESSOR USEONLYSNS

Reconciliation2

BelowarethefollowingfortheSalesTrustAccount:

TheTrustCashBookReceiptsandPaymentsforMay20XX

BankStatementasat31May20XX

YouaretoreconcilethecashbooktotheBankStatementusingthetemplateprovided

CASHBOOK-RECEIPTSIDE(TCR) S-CB1

Date 20xx

Rec#

Type

Receivedfrom

OnAccountof

LF

Transaction

Amount

DailyBank

1/5

Balance B/F

274,180

10/5

229

Cash

RogerHamilton

RogerHamilton

50

Advertising

Contrib

1,600.00

1,600.00

19/5

231

Chq

JonJames

YatestoJames

60

10%Deposit

122,000.00

122,000.00

21/5

232

Chq

Bert&MaryStewart

HamiltontoStewart

50

10%Deposit

60,000.00

60,000.00

31/5

233

Chq

MStarc

Hazelwood toStarc

70

5% Deposit

50,000

50,000

BalB/d

507,780.00

THINKREALTYSALESTRUSTACCOUNT TRUST CASH BOOK

CASHBOOK-PAYMENTSIDE(TCR) S-CB1

Date

EFT#

CHQ#

Payee

OnAccountof

LF

Transaction

Amount

5 May

407

Aganovski

Aganovski

21

Settlement

82,500.00

5 May

408

ThinkRealty

Aganovski

21

Commission

25,500.00

31May

6324

XYZRealty

Smith

11

ReleaseofDep

60,500.00

Total

168,500.00

Brought Down

507,780.00

FinalTotal

339,280.00

THINKREALTYSALESTRUSTACCOUNT TRUST CASH BOOK

ThinkRealtySalesTrustAccount

BankStatementasat31May20xx

DateDetails/ReferenceDebitCreditBalance
Balance b/f274,180.00
5May20XXEFT40782,500.00191,680.00
5May20XXEFT40825,500166,180.00
11May20xxReceipts1,600.00157,780.00
20May20xxReceipts122,000.00289.780.00
22May20xxReceipts60,000.00349,780.00
CLOSINGBALANCE349,780.00

Youaretoacceptalltheentriesinthebankstatementinthisexercisearecorrect

INSTRUCTIONS

OnthenextpageyouaretoreconciletheTrustAccounttothebankstatement

THINKREALTYSALESTRUSTACCOUNT

BankReconciliationasat

Balanceasperbankstatement $

ADDOutstandingDeposits

SubTotal$

AddBankCharges

AddTotalAdjustments

$

$

LESSUnpresentedChequesChq# Amount

Subtotal$

LessTotalAdjustments

CRBalanceasperbankstatement(adjusted)

$

$

DRBalanceaspercashbook$

ASSESSOR USEONLYSNS

Reconciliation3

BelowarethefollowingfortheProperty ManagementTrustAccount:

TheTrustCashBookReceiptsandPaymentsforJune20XX

BankStatementasat30June20XX

YouaretoreconcilethecashbooktotheBankStatementusingthetemplateprovided

InthisreconciliationyouwillfinderrorsintheBankStatementandtheTrustAccountrecords You are to in the spaces provided: -

Correctlycompletethecashbook and bring thebalancedown.

Preparea bankreconciliationreport

THINKREALTYSALESTRUSTACCOUNTTRUSTCASHBOOK

CASHBOOK-RECEIPTSIDE(TCR) S-CB1
Date 20xxRec #TypeReceivedfromOnAccountofLFTransactionAmountDailyBank
1/5Balanceb/f19,010.00
7/5200EFT 345JBrownRoetoBrown300Deposit65,000.0065,000.00
11/5201EFT 348K MorrowHilltoMorrow310Deposit30,000.0030,000.00
14/5202ChequeGowGow320Advertcontrib1,500.00
203ChequeFaithFaith330149Cert120.001,620.00
15/5203CashKimLeeto Kim340HoldingDep1,000.001,000.00
17/5204EFT 358WalfordWalford350Auctionfee3,500.003,500.00
18/5205ChequeRFullerDowneytoFuller3605% deposit30,500.0030,500.00
28/5208EFT 360K DullyHartto Dully370Deposit20,000.0020,000.00
29/5209EFT361KellyPoulostoKelly380Deposit130,000.00130,000.00
31/5210ChequeRFullerDowneytoFuller3605% deposit30,500.0030,500.00
TOTAL$331,130
ASSESSOR USEONLYSNS

THINKREALTYSALESTRUSTACCOUNTTRUSTCASHBOOK

CASHBOOK-PAYMENTSIDE(TCR) S-CB1
DateChq#EFT#PayeeOnAccountofLFTransactionAmount
1/544BuildriteFaith330Inspection2,400.00
45Redback Pest ControlFaith330Inspection800.00
3/5606ThinkRealtyMetcalftoJames80Commission4,700.00
666JamesMetcalftoJames80Settlement11,110.00
16/5672FarWestNewsGow320Ads1,477.00
20/546FarWestCouncilFaith330149Cert120.00
26/547DomainGow320Ads656.00
27/548Advance SignsGow320Signboard460.00
30/5AdjustmentFullerDowneytoFuller360

Dishonoured

Cheque

30,500.00
TOTAL$52,223
BroughtDow$331,130
FINALTOTAL$278,907
ASSESSOR USEONLYSNS

ThinkRealtySalesTrustAccount

BankStatementasat31May20xx

Youaretoacceptalltheentriesinthebankstatementinthisexercisearecorrect

INSTRUCTIONS

OnthenextpageyouaretoreconciletheTrustAccounttothebankstatement

DateDetails/ReferenceDebitCreditBalance
Balance b/f19,010.00CR
3 MayEFT6064,700.0014,310.00CR
EFT66611,110.003,200.00CR
6 MayChq 442,400.00800.00CR
7 MayEFT 345-RefBrown65,000.0065,800.00CR
10 MayChq 45800.0065,000.00CR
11 MayEFT 348RefMorrow30,000.0095,000.00CR
15 MayManual Deposits1,620.0096,620.00CR
16 MayCashDeposit1,000.0097,620.00CR
17 MayEFT 358RefWalford3,500.00101,120.00CR
19 MayDepositChq30,500.00131,620.00CR
19 MayEFT6721,477.00130,143.00CR
28 MayChq.47656.00129,487.00
29 MayEFT 360-RefDully20,000.00149,487.00CR
29 MayChq 46120.00149,367.00
EFT 361-RefThomas130,000.00279,367.00CR
30 MayDishonouredChq-Fuller30,500.00248,867.00CR
31 MayBankCharges173.00248,694.00CR

INSTRUCTIONS

OnthenextpageyouaretoreconciletheTrustAccounttothebankstatement

THINKREALTYSALESTRUSTACCOUNT

BankReconciliationasat

Balanceasperbankstatement $

ADDOutstandingDeposits

SubTotal$

AddBankCharges

AddTotalAdjustments

$

$

LESSUnpresentedChequesChq# Amount

Subtotal$

LessTotalAdjustments

CRBalanceasperbankstatement(adjusted)

$

$

DRBalanceaspercashbook$

image text in transcribedimage text in transcribedimage text in transcribed THINK REALTY SALES TRUST ACCOUNT Bank Reconciliation as at Balance as per bank statement $ ADD Outstanding Deposits Sub Total Add Bank Charges Add Total Adjustments S LESS Unpresented Cheques Cha# Amount Sub total $ Less Total Adjustments CR Balance as per bank statement (adjusted) DR Balance as per cash book ASSESSOR USE ONLY S NS 2. CPPREP4125-Transact in trust accounts Version 2.1 29 March 2022 Page 26 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125THINK REALTY SALES TRUST ACCOUNT Bank Reconciliation as at Balance as per bank statement $ ADD Outstanding Deposits Sub Total Add Bank Charges Add Total Adjustments S LESS Unpresented Cheques Cha# Amount Sub total $ Less Total Adjustments CR Balance as per bank statement (adjusted) DR Balance as per cash book ASSESSOR USE ONLY S NS 2. CPPREP4125-Transact in trust accounts Version 2.1 29 March 2022 Page 29 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125THINK REALTY SALES TRUST ACCOUNT Bank Reconciliation as at Balance as per bank statement $ ADD Outstanding Deposits Sub Total Add Bank Charges Add Total Adjustments S LESS Unpresented Cheques Cha# Amount Sub total $ Less Total Adjustments CR Balance as per bank statement (adjusted) DR Balance as per cash book ASSESSOR USE ONLY S NS 2. CPPREP4125-Transact in trust accounts Version 2.1 29 March 2022 Page 33 of 35 DOCUMENT LOCATION: Sharepoint/NSW/CPP41419/CPPREP4125

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Decision Modeling Business Analytics With Spreadsheet

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

4th Edition

1501515101, 978-1501515101

More Books

Students also viewed these Accounting questions

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago