1 Stewart Recording Studio owned by Ron Stewart showed the following hak reconciation of March a tutti SH Seconciliation March 200 23.00 halanta 953 311.92 5. sit Hari tu Deduct Outstanding the 14 wa 119 1 14 $30,00 Musta Orbit Credit Date 2020 Maret April Explanation 11 Balance 30 Actate Balance 30,00 102.14 11.11 ORIY 1,437 13 0, A list of deposits made and cheques written during April, taken from the Cash Peces Jumal and Cash Disbursements Journalis shown below Deposits Made Aril 33 18 2) 45 , 13,50 Total A Cavi Hecept 573,437 Cheques Written No 25 24 25 26 27 28 29 30 31 32 Total April Cash Disbursements $ 5,196 3,148 938 309 4,217 4,900 19,547 40,510 411 11,375 $90,851 ped ences The following bank statement is available for April: Bank Statement To: Stewart Recording Studio Cheques/Charges Deposits/Credits 31 04/03 #28 04/07 #26 04/13 NSF 84/18 w24 04/23 23 04/27 #29 04/30 PMT 04/30 INT 04/30 SC 04/30 NSF - Not Sufficient Funds 411 9,400 309 14,150 3,148 5, 196 19,547 15,830 04/03 04/07 04/13 04/18 04/23 84/27 34/30 9,952 689 4,593 5,894 13,883 1,751 119,000 April 30, 2020 Bank of Canada Balance 22,000 31,541 22,830 27,114 18,858 29,593 26,148 125,601 109,771 109,331 109,154 INT - Interest on Bank Loan 440 177 SC - Service Charge PMT - Payment of Principal on the loan 1 . In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #28, for delivery expense, was recorded in the Cash Disbursements Journal correctly as $4.900. The NSF cheque for $14.150 was that of customer Oprah Winney, deposited in March . On the bank statement, the payment for $15,830 is regarding a note payable, There is also a deposit of $119.000 dated April 30. It is an investment made by the owner into the business (the bank transferred the funds electronically from the owner's personal account to his business account, which is why it was not recorded in the Cash Receipts Journal). ant Required: 6. Prepare a bank reconciliation for Stewart Recording Studio at April 30. ences STEWART RECORDING STUDIO Bank Reconciliation April 30, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: 0 0 Deduct: Deduct: Outstanding choques Cisch BANK Statement 1 Company S BOOKS Bank Statement balance Add: Book balance Add: 0 Deduct: Deduct Outstanding cheques ce 0 0 Adjusted bank balance Adjusted book balance Check 1 10 b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation View transaction lit Journal entry worksheet 5 > Record to reinstate customer account Dato General Journal Debit Credit Apr 30 1 10 Stewart Recording Studio owned by Ron Stewart, showed the following bank reconciliation at March 31 Stewart Recording Studio Bank Reconciliation March 31, 2020 Bank statement balance $22,000 look balance $30,805 Add Deposit of March 31 in transit 9,952 $31,952 Deduct: Outstanding the quest 14 3828 #22 319 1.167 Adjusted bank balance 538,805 Adjusted book balance 530,895 Spord 000 Punt Cash Explanation PR Acct. No. 101 Balance Debit Credit Date 2020 March April Balance 33 30 30 CRY 71,437 C013 30,005 102,242 11,391 90,851 A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journalis shown below: Deposits Made April 2 13 18 23 27 30 TAT.1 Anitrach Barsinta $ 689 4,593 5,894 13,883 1,251 44,627 (71.42 1 Deposits Made April 7 13 18 23 27 30 Total April Cash Receipts 5 689 4,593 5,894 13,883 1,751 44,627 $71,437 ht kinded eBook Print Terences Cheques written No. 23 24 25 26 27 28 29 30 31 32 Total April Cash Disbursements $ 5,196 3,148 938 309 4,217 4,900 19,547 40,810 411 11.375 $90,851 The following bank statement is available for April: Bank Statement To: Stewart Recording Studio Cheques/Charges Deposits/Credits April 30, 2020 Bank of Canada Balance 22,000 31,541 #31 04/03 411 04/e3 9.952 1 Bank Statement Deposit/Credit 10 pat To: Stewart Recording Studie Ch/Charges 31 04/03 20 01/07 26 04/1 NSE 01/18 04/23 # M/27 20 0/10 PNT 04/30 INT 04/30 SC 04/30 NSF - Not sufficient Funds 431 9,400 Jos 14,150 3,141 5,190 19,547 15,830 40 172 SC Service Charge 04/03 06/07 04/13 04/18 04/23 03/27 04/10 9.952 6 4,599 5.11 1), 1,751 119.000 April 30, 2020 Bank of Canada Balance 22,000 51,541 22, 27.114 18,85 29,593 20,140 125.61 109.71 10,31 109,154 Interest HT- Payment of Principal on the loan L In tevlewing cheques returned by the bank, the bookkeeper discovered that cheque #28 for delivery expense, was recorded in the Cash Disbursements Journal correctly as $4,900, The NSF cheque for $14,150 was that of customer Oprah Winney, deposited in March, . On the bank statement, the payment for $15,830 is regarding a note payable . There is also a deposit of $119,000 dated April 30, it is an investment made by the owner into the business (the bank transferred the funds electronically from the owner's personal account to his business account, which is why it was not recorded in the Cash Receipts Journal) Required: o. Prepare a bank reconciliation for Stewart Recording Studio at April 30, 1 Required: n. Prepare a bank reconciliation for Stewart Recording Studio at April 30, 10 point STEWART RECORDING STUDIO Bank Reconciliation April 30, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add wo 0 Deduct: Deduct Outstanding cheques 0 0 Adjusted bank balance Adjusted book balance 1 b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation 10 View ansactions Journal entry worksheet Pre Record to reinstate customer account Notenter det before che General Journal Debit Credit Date Apr 30 Record entry Clear entry View general Journal 1 1 b. Prepare the necessary journal enties to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation 10 View transactions Journal entry worksheet Record the Agribank service charges be General Journal Debit Credit Date Apr 30 Record Clear entry View general Journal 1 Check my work b. Prepare the necessary journal entries to bring the Greatedger Cash account into agreement with the adjusted balance on the bara reconciliation 10 D Views Journal entry worksheet % Record the Art interest expense General Journal Debe Candil AN 30 Her y Care View general ME Grow Bill P 1 of 12 !!! Next > 1 Check my work b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adisted balance on the bank reconciliation 10 Do View transactions S Journal entry worksheet 3 5 > Record the April payment on note store General Journal Debit Credit Date Ar 30 Record entry Clear entry Wewenal Journal ME 1 CHIN b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation 10 DO Views Journal entry worksheet $ > Recond the westment by owner Monteret General Journal Debit Date Apr 30 Credit Recorded Clearly View general Journal 1 Problem 7-9A Preparing a bank reconciliation and recording adjustments LO6 Stewart Recording Studio, owned by Ron Stewart showed the following bank reconciliation at March 31 Stewart Hecording Studio Bank Reconciliation March 11, 2020 522,000 look balance $30,05 Blank statent balance Add Deposit of March 31 in transit 9,952 531,952 Deducti Outstanding cheques : 14 N22 Adjusted bank balance $828 119 1.147 $30,805 Adjusted book balance $30,005 Cash Explanation Acct. No. 101 Balance PR Debit Credit Date 2020 March April 31 Balance 30 30 CR37 71,437 CD13 30,805 102,242 11,391 90,851 A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below: Deposits Made Ceny w 1 SOLO A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journal shown below: Depositede April $ 689 13 10 5.894 23 27 13,883 1,75 10 44.627 Total April Cash Receipts 571,437 int Chemes Written No. $ 5,196 3.145 23 24 25 200 27 4,217 4,900 19,547 40,510 411 30 31 32 Total April Cach Disbursements 590,851 The following bank statement is available for April dan Statens U won The following bank statement is available for April Bank Statement il 30, 2030 Bank of Canada Balance Deposits/Credits 22 to Start Hecording Studio Chesha 04/03 01/07 m/ NSH 24 04/23 123 04/21 39 04/30 PET 04/30 TNT 01/30 SC 04/30 IST Mut sufficient Funde 411 9,400 909 14,15 3,14 5.16 19,147 19,00 140 122 SC Service M/0) 04/07 114/1) 14/10 04/23 04/27 04/10 9,92 489 4,393 5,894 11,53 1,751 119.000 31,50 22.30 224 18,58 29.5 26,140 125, 109,773 10,33 Chare PHT Payment of Principal o the loan 109,154 TNT Tetest on tank Loan . In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #28. for delivery expense, was recorded in the Cash Disbursements Journal correctly as $4,900 . The NSF cheque for $14,150 was that of customer Oprah Winney, deposited in March . On the bank statement, the payment for $15,830 is regarding a note payable. . There is also a deposit of $119,000 dated April 30. It is an investment made by the owner into the business (the bank transferred the funds electronically from the owner's personal account to his business account, which is why it was not recorded in the Cash Receipts Journal Required: . Prepare a bank reconciliation for Stewart Recording Studio of April 30, STEWART RECORDING STUDIO Bank Reconciliation April 30, 2020 Da Bank Statement Company's Books Bank statement balance Add: Book balance Add: 0 Deduct Deduct Outstanding Cheques D 0 Adjusted book balance Adjustod bank balance 1 b. Prepare the necessary journal entities to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation View transactions O Stoped Journal entry worksheet tor Record to reinstate customer account. Not Enter debut before credits General Journal Debit Credit Date Apr 30 Record entry Clear entry View general Journal