Information follows for Quartz Industries Ltd.:

aBank service charges
bBank debit memo for $1,050.00 for a customer's cheque returned and marked NSF was included with the June bank statement. Cash received on June 30 and put in the bank's night deposit box on the evening of June 30 was recorded by the bank in the general chequing account on July 2 for the amount of $4,607.96. Because the Cash account balance at June 30 is not given, it must be calculated based on other information in the problem.
Instructions
Prepare a bank reconciliation to the correct balance as at June 30, 2014, for Quartz Industries.

Transcribed Image Text:

QUARTZ INDUSTRIES LTD. Bank Reconciliation May 31, 2014 Balance per bank statement Less: Outstanding cheques No. 6124 No. 6138 No. 6139 No. 6140 $30,928.46 $2,125.00 932.65 960.57 1,420.00 5,438.22 25,490.24 4,710.56 $30,200.80 Add deposit in transit Balance per books (correct balance) CHEQUE REGISTER-JUNE Date Payee Invoice Amount Discount Cash 0 6141 6142 6143 6144 6145 6146 6147 6148 6149 6151 6152 6153 $237.50 915.00 122.90 306.40 89.93 706.00 447.50 4,130.00 390.75 2,250.00 750.00 400.00 $10,745.98 $ 237.50 905.85 120.45 306.40 89.93 691.88 447.50 4,130.00 386.84 2,250.00 750.00 392.00 $37.63 $%10,708.35 June Bren Mfg. 9.15 2.45 1 Stempy Mfg. 8 9 10 17 22 23 25 28 29 30 Regent Co., Inc. Bren Mfg. Petty Cash Pretty Babies Photo Hey Dude Publishing Payroll Account Dragon Tools, Inc. Be Smart Construction M M T, Inc Lasso Co 14.12 3.91 8.00 PROVINCIAL BANK Bank Statement General Chequing Account of Quartz Industries-June 2014 Date Debits Credits Balance $30,928.46 32,370.67 32,824.63 32,109.28 27,968.23 28,735.78 June $2,125.00 237.50 905.85 306.40 1,050.00 12 23 26 28 932.65 1,420.00 4,130.00 89.93 120.45 447.50 11.05 2,250.00 $4,710.56 1,507.06 1,458.55 4,157.48