Question

Home NBPR BSA Bank reconciliation and entries OBS 1. Adjusted balance: Beeler Furniture Company deposits all cash recipes cach W iesday and Priclay in a nicht $13,216 deponry after hanking hours. The data required to reconcile the bank statement as of June 30 hurve been taken from various documents and records and are reproduced as follows, The Sources of the data are printed in capital letters. All checks were written for payments on account CASH ACCOUNT Balance as of June 1 Swact Checks given CASH RECEIPTS FOR MONTH OF JUNE DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June der 15.541.16 $9317.40 $9.223.76 Date June 10 Date June 22 Where youstart on Company NA Accord MA 10, 145,5 cm Amount $1.080.50 854.17 840 SO Amount $996.61 8295 160674 Amount $ 897.34 947.21 1.117.74 CHECKS WRITTEN Number and amount of each check issued in June Check No. Amount 747 sits company e crrors 742 750 Check No. 5237.50 741 495.15 501.90 749 76139 7:44 506.88 745 117.25 746 298,66 Total amount of checks issued in June BANK RECONCILIATION FOR PRECEDING MONTH Void 545090 640.13 276 27 29937 537 01 380.95 755 756 757 758 759 760 $ 449.75 272.75 113.95 407.95 259.60 901.50 486.39 58,395.66 is too 753 $ 9.447.20 690.25 Beeler Furniture Company Bank Reconciliation May 31 2012 Cash balance according to bank statement.. Add deposit for May 31, not recorded by bank... Deduct outstanding checks: No. 731 ......... 736 ... 738 739 Adjusted balance.. Cash balance according to company's records Deduct bank service charges.. Adjusted balance. $162.15 345.95 251.40 60.55 820.05 $ 9,317.40 $ 9,352.50 35.10 $ 9,317.40 Instructions 1. Prepare a bank reconciliation as of June 30, 20Y2. If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales. All checks are written to satisfy accounts payable.

Answer 1

Beeler Furniture Bank Reconciliation June 30 2012 Cash Balance according to bank statement Add :Deposit of June 30, not recorded by bank 13624.71 1117.74 14742.45 Deduct :outstanding checks No. 731 756 758 251.4 113.95 259.6 901.5 759 1526.45 13216 Adjusted Balance 10145.5 Cash Balance according to Company's records Add:Proceeds of Note Collected by Bank Principal Interest Error in recording Check No. 743 3500 210 3710 13945.5 550 100 Deduct:Check returned because of insufficient funds Error in recording June 10 deposits Error in recording June 24 deposits Service Charges Adjusted Balance 4.5 75 729.5 13216 Balnce as per Bank account, June 1 Add:June Receipts Deduct June dixsbursement Balnce as per Bank account, June 30 9317.4 9223.76 -8395.66 10145.5