Using the June Bank Reconciliation information, the Cash Receipts and Payments Journals and Bank Statement, please prepare the below Bank Reconciliation for the month of July 20XX. Please make sure you have addressed all of the requirements in the question especially referencing the need to address cash receipts and payments and as well as the bank statement.

Ace Real Estate TRUST BANK RECONCILIATION AS AT 3016120)\" Balance as per bank statement 30l67'20XX $73,734.96 Add: Outstanding Deposits 30767)\" $152000 Subtotal : $75254.96 Deduct: Outstanding Payments 22/6/XX 2344 $ 1500.00 23/6/XX 2348 5 150.00 23/6/XX 2350 5 1860.00 26I6/XX 2352 5 141.00 HIS/XX EFT#445 5 2643.25 Total $6294.25 Subtotal: $68 960.71 Adjustments Adjusted Bank Balance $6896071 Ace Real Estate Cashbook Transactions for the month of July 20XX: Received On Account Date Rec # Type LF Transaction Amount Bank From Of O/Balance 68,960.71 1/07 1203 Cash D Rugg M Munro 118 Rent 1258.00 1258.00 1/07 1204 Cash E Eleanor P Paul 119 Rent 2166.50 2166.50 2/07 1205 Cha D Duck M Mouse 120 Rent 780.00 780.00 Bunny to 4/07 1206 Cha E Fudd 140 Deposit 35,000.00 35,000.00 Fudd Rubble to 7/07 1207 Cha Flintstone Flintstone 150 Deposit 15,000.00 15,000.00 Rental Bond 10/07 1208 Cash G Jetson Bond 1,600.00 Suspense 130 10/07 1209 Cash P Smurf Y Bear 160 Rent 800.00 2,400.00 11/07 1210 Cha D Duck M Mouse 120 Rent 780.00 780.00 14/07 1211 Cha R Runner M Mouse 120 Rent 550.00 550.00 18/07 1212 Cha M Magoo M Squiggle 170 Advertising 2,500.00 2,500.00 20/07 1213 Cha W Cayote Y Sam 162 Rent 760.00 760.00 24/07 1214 Cash H Hound F Bassett 164 Rent 540.00 540.00 24/07 1213 Dish W Cayote Y Sam 162 Dishonour -760.00 -760.00 28/07 1215 Cha D Duck M Mouse 120 Rent 780.00 780.00 30/07 1216 Cash W Cayote Y Sam 162 Rent 980.00 30/07 1217 Cha H Hound F Bassett 164 Rent 540.00 1,520.00 Total Receipts 63274.50Trust Account Cash Payment Journal CB 29 Payee On Account Date Ref # LF Amount Of Transaction Bank Tenancies Rental Bond 1/07 2353 130 Bond 800.00 800.00 Branch Suspense 1/07 2351 H Handyman Y Bear 160 Repairs Roof 6,294.25 6,294.25 3/07 2354 D Duck M Mouse 120 Plumbing Repair 125.60 125.60 10/07 2355 Integrity RE M Mouse 120 Management 150.00 150.00 Fees 10/07 2356 M Mouse M Mouse 120 Settle account 1,628.00 1,628.00 11/07 2357 Slosh 160 Toilet repairs 120.30 120.30 Plumbing Y Bear 12/07 2349 Integrity Re Y Bear 160 Repairs 678.20 678.20 13/07 2358 Tenancies Rental Bond 130 Bond 1,860.00 1,860.00 Branch Suspense 18/07 2351 H Handyman M Mouse 120 Repairs 180.40 180.40 18/07 2354 H Handyman M Mouse 120 Repairs 125.60 125.60 Sales 23/07 2359 Integrity RE C Brown 110 Commission 6,200.00 6,200.00 23/07 EFT443 Martin & Co. Brown to 110 Settlement 8,400.00 8,400.00 Green 27/07 2360 H Handyman M Mouse 120 Unit clean 141.00 141.00 EFT444 Integrity RE Rubble to Sales 29/07 150 Commission 26,000.00 26,000.00 Flintstone 29/07 EFT447 Martin & Co. Rubble to 150 Settlement 16,800.00 16,800.00 Flintstone Management 30/07 EFT440 Integrity RE Y Bear 160 180.00 180.00 Fee Rent to 30/07 EFT446 Y Bear Y Bear 160 2,463.25 landlord 2,463.25 Total 72146.60 PaymentsAce Real Estate - Bank Statement BANK OF AUSTRALIA MELBOURNE CITY BRANCH Date Details Debit Credit Amount 1/7/XX Opening Balance: 73,734.96 CR 1/7/XX Deposit 1520.00 75,254.96 CR 1/7/XX 2351 6,294.25 68,960.71 CR 1/7/XX Deposit 1258.00 70,218.71 CR 1/7/XX Deposit 2166.50 72,385.21 CR 2/7/XX 2344 1,500.00 70,885.21 CR 2/7/XX 2348 150.00 70,735.21 CR 2/7/XX 2350 1,860.00 68,875.21 CR 2/7/XX 2352 141.00 68,734.21 CR 2/7/XX EFT#445 2,643.25 66,090.96 CR 3/7/XX Deposit 780.00 66,870.96 CR 4/7/XX Deposit 35,000.00 101,870.96 CR 2353 800.00 101,070.96 CR 8/7/XX 2354 125.60 100,945.36 CR 8/7/XX Deposit 15,000.00 115,945.36 CR 10/7/XX Deposit 2,400.00 118,345.36 CR 11/7/XX Deposit 780.00 1 19, 125.36 CR 12/7/XX 2349 678.20 118,447.16 CR 14/7/XX Deposit 550.00 118,997.16 CR 18/7/XX Deposit 2,500.00 121,497.16 CR 2351 180.40 121,316.76 CR2354 125.60 121, 191.16 CR 20/7/XX Deposit 760.00 121,951.16 CR 24/7/XX Deposit 540.00 122,491.16 CR Dishonoured cheque 20/6/XX 760.00 121,731.16 CR 2356 1,628.00 120, 103.16 CR 2357 120.30 119,982.86 CR 2359 6,200.00 113,782.86 CR EFT443 - Settlement Dirt 8,400.00 105,382.86 CR 28/7/XX Deposit 780.00 106, 162.86 CR 29/7/XX EFT447 - Settlement Dirt 16,080.00 90,082.86 CR Closing Balance: 90,082.86 CRBank Reconciliation as at 31 July 20XX Ace Real Estate RENTAL TRUST BANK RECONCILIATION AS AT 31/07/20XX Balance as per bank statement 31/07/20XX $ ADD: Outstanding Deposits (Date) (Details) (Banking Amount) Total: $ Subtotal: DEDUCT: Outstanding Payments(Date) (Ref #) (Amount) Total: Subtotal: $ Adjustments (Date) (Details) Adjusted Bank Balance 31/07/20XX Cashbook Balance as at 31/07/20XX Trust Account Cashbook Summary Opening Balance $ Plus, Receipts $ $ Less Payments Closing Balance $Sample answer Reconciliation as at 31 July 20xx Ace Real Estate BANK RECONCILIATION AS AT 31/07/20XX Balance as per bank statement 31/07/20XX $ ......90,082.86............. Add: Outstanding Deposits(Date) (Details) (Banking Amount) ...30/7/XX... Banking... $...1520.00... Total: $ Subtotal: $ ...91,602.86... Deduct: Outstanding Payments (Date) (Ref #) (Amount) 10/7/XX 2355 150.00 13/7/XX 2358 $ 1,860.00 27/7/XX 2360 $ 141.00 29/7/XX EFT#444 $26,000.00 30/7/XX EFT#440 $ 180.00 30/7/XX EFT#446 $ 2,463.25 Total: $ ----30,794.25- Subtotal: $ ...60,808.61 Adjustments Date) (Details) 29/7/20XX. EFT447 - Settlement Pmt..$720........... Adjusted Bank Balance $ ....60,088.61 Trust Account Cashbook Summary Opening Balance $ ... 68960.71 ...... Add Total Receipts for the month $ ...63274.50. .......... Deduct Total Payments for the month $ 72,146,60... Closing Balance $ 60,088.61........"