Good afternoon, I am working on bank reconciliation and need some help. I was wondering if you could help me? The think the Bank Statement
Good afternoon, I am working on bank reconciliation and need some help. I was wondering if you could help me? The think the Bank Statement Balance is 4,612.20 and the Book Balance is, 4,081.20 I just need help figuring this out.
*The cheques that are dated April 2 to April 30 are the details for the book balance, 4,081.20.
The following statement from the Community Bank was received on May record the actual information ($9 bank charges for the statements). nk was received on May 7, 2018, too late to Prepare a Bank Reconciliation as of April 30, 2018, in proper form. The Bank Reconciliation Adjustments have not been included in the solution but may determined and included at the discretion of the instructor. Community Bank 938 Carlton Street St. Catharines, Ontario L2R 3C6 1 Dep DM Sound Bytes Electronics 1577 Scott Street St. Catharines, Ontario L2N 4F8 Account Number: 261686342-1484 Statement period 1 Apr 2018 to 30 Apr 2018 Enclosed items 8 Page 1 Date Ch. No. Withdrawals Deposits Balance or Code April 14,964.00 401 1,695.00 13,269.00 339.00 13,608.00 50.00 13,558.00 | 5 Dep 222.00 13,780.00 6 402 791.00 12,989.00 10 403 555.00 12,434.00 10 Dep 610.20 13,044.20 13 405 700.00 12,344.20 13 404 546.00 11,798.20 13 AC 610.20 11,188.00 406 6,438.00 4,750.00 16 Dep 610.20 5,360.20 16 407 339.00 5,021.20 30 DM 400.00 4,621.20 31 SIC 9.00 4,612.20 DM Debit Memo DD Direct Deposit NSF Not Sufficient Funds, Item returned AC Item returned, Account Closed S/C Service Charge Cor Correction 02-Apr 4 No. 401 1,695.00 5 Date Apr 02 6 To Mall Management 7 For Lease 20 14,964473 Balance Forward Deposited Deposited Deposited Subtotal This Cheque Other* Balance 14,964.00 1,695.00 13,269.00 18 74 No. 402 75 Date 76 To 77 For $791,00 Date: Apr 5 To: City News Services For: Advertisement 79 80 13,269.00 339.00 222.00 82 Balance Forward Deposited Deposited Deposited Subtotal This Cheque Other DR Memo Balance 13,830.00 791.00 50.00 12,989.00 86 87 88 89 1 8 116) AON 09-Apr 117 No. 403 555.00 118 Date PREMIUM Mar 30 PRONALA ATROPEL20 119 To Active Electronics 120 For Pay invoice AMBASSADOR PARA 121 122 Balance Forward 12,989.00 Deposited 124 Deposited 125 Deposited Subtotal 12,989.00 127 This Cheque 555.00 Other Balance 12.434.00 130 123 - - - 126 128 129 I w 131 132 160 No. 404 161 Date 162 To 163 For 164 165 CD 546.00 Apr 13 20 Receiver General To pay March HST balances 166 12,434,00) 610.20 167 168 Balance Forward Deposited Deposited Deposited Subtotal This Cheque Other Balance 169 170 171 172 13,044 20 546.00 12,498.20 173 174 175 176 177 178 13-Apr 179 No. 405 700.00 180 Date Apr 13 181 To Andre's Auto Repair 182 For Car repairs NHL 1 200 18 183 184 12,498.20 185 186 187 188 189 190 Balance Forward Deposited Deposited Deposited Subtotal This Cheque Other Balance 12.498.20 700.00 11,798.20 DE 4 AB 38 No. 406 6,438.00 99 Date Apr 13 DO TO Active Electronics Inc. 01 For Payment for invoice 20 02 11,798.20 205 11,798.20 6,438.00 208 209 5,360.20 03 Balance Forward 04 Deposited Deposited 206 Deposited 207 Subtotal This Cheque Other DR Memo 210 Balance 211 212 213 1214 215 216 16-Apr 217 No. 407 339.00 218 Date Apr 16 219 To Metro Hydro 220 For Bill payment 20 18 221 222 5,360.20 223 224 225 226 227 228 Balance Forward Deposited Deposited Deposited Subtotal This Cheque Other DR Memo Balance 5,360.20 339.00 610.20 4,411.00 229 230 LUJ 1 8 284 30-Apr MM 285 No. 408 640.00 286 Date MANOMATYRIMANE Apr 30 HORARIOARA PE OAMAN 20 287 To Julie-ann Patton 288 For Salary M A RINA AT MAN HARGA MONACO MONTEROWTAROSTWA PARIMATA ADARA 289 Balance Forward 4.411.00 291 Deposited 610.20 292 Deposited 100.00 293 Deposited 294 Subtotal 5.121.20 295 This Cheque 640.00 296 Other DR Memo 400.00 297 Balance 4,081.20 290 298 299 300
