Project – Trust account management

profilejasveerD
TemplatesEXCEL.xlsx

receipt

Trust Account Receipt
No 01206
Date / /
Your Home Real Estate Pty Ltd
14 Main St
Wodonga 3690
Ph 1234 5678
ABN 222 333 444
Received from:
Address:
The Sum of:
For:
File:
Signed:
For and on behalf of Your Home Real Estate Pty Ltd
Cheque $
Cash $
Money order $
EFT $
Duplicate

Cheque Butts

Date
Payment to
Trust Ledger Account and Folio no
Reason for payment
Amount
Cheque Number

Journals

TCRJ Transfer Journal
Date Particulars Property address Rec No. Amount $ Bank $ Date Particulars Folio/File From $ To $
TCPJ
Date Particulars Property address Chq No. Amount $ Bank $

Ledgers

Client File
Address
Other Party
Transaction Type
Charges 7% comm GST incl gross rental, $5 statement fee GST inc
Date Particulars Paid to Jnl ref Rec no chq no EFT Debit $ Credit $ Balance $

Statements

Your Home Real Estate Pty Ltd
14 Main St
Wodonga
Ph 1234 5678
ABN 222 333 444
Statement of Account
Date:
Client
RE:
Your Home Real Estate Pty Ltd
14 Main St
Wodonga
Ph 1234 5678
ABN 222 333 444
Date:
To:
Rental Statement/Tax Invoice for the month of:
Tenant Address Period Paid To Total
Disbursements
All fees and charges GST inc
7% commission on:
Letting fees charged at
Statement fee
Cheque herewith

Trial balance & Reconciliation

Your Home Real Estate Pty Ltd Trial balance of Your Home Real Estate Pty Ltd for the month ended:
Trust Account Reconciliation Statement at_________________ Account Name Debit Credit
1 Trust Cash Journal $ $ Bank
Balance Brought Forward from
Add total receipts for:
Deduct total payments for:
Balance as at:
2 AFI statement
Balance as per AFI statement:
Add deposits not yet credited
Deduct unpresented cheques
Total trust money at:
3 Trust Ledger balances
Total of attached listing of ledgers as at:
I certify that the Trust Account Reconciliation Statement is accurate:
Date:
Estate Agent/Licensed Wording Director/OIEG
Bank Statement for: Your Home Real Estate Pty Ltd
Date: Details Dr Cr Balance
5/31/13 General Account chq no 1445 $443.50 $62,506.50
5/20/13 General Account chq no 1442 $13,395.00 $62,950.00
Reddy & Co Chq no 1441 $40,105.00 $76,345.00
5/15/13 Deposit $1,350.00 $116,450.00
5/13/13 Deposit $2,000.00 $115,100.00
5/8/13 Deposit $1,200.00 $113,100.00
5/7/13 Deposit $58,400.00 $111,900.00
5/7/13 Adjustment Dis chq $1,500.00 $53,500.00
5/3/13 Deposit $1,500.00 $55,000.00
General Account Ch no 1440 $9,720.00 $53,500.00
Agnew & Fortescue ch no 1439 $29,080.00 $63,220.00
John Jones Ch no 1436 $1,851.50 $92,300.00
James Smithson Ch no 1435 $1,855.00 $94,151.50
Aircold Air Cond Ch no 1434 $1,900.00 $96,006.50
General Account Ch no 1438 $350.00 $97,906.50
General Account Ch no 1437 $443.50 $98,256.50
4/23/13 Deposit $42,800.00 $98,700.00
4/20/13 Deposit $10,700.00 $55,900.00
4/15/13 Deposit $1,350.00 $45,200.00
4/13/13 Deposit $2,000.00 $43,850.00
4/8/13 Deposit $1,200.00 $41,850.00
4/3/13 Deposit $1,500.00 $40,650.00
4/2/13 Deposit $350.00 $39,150.00
4/1/13 Opening Balance $38,800.00