1:59College Accounting.....Jun 1Jun 2# 580$2,275.00$12,115.00# 581$135.00$11,980.00# 577Jun 3$1,500,00$10,480.00$1,137.45$75.00# 582Jun 4Jun 4$2,456.00 $11,798.55# 586Jun 17Jun 17 $2,345.25 $14,068.80$13,944.05#587Jun 20$124.75#585Jun 28$745.65$13,198.40NSFJun 28$255,45$12,942.95NSF chargeService Charge Jun 30Jun 28$15.00$12,927.95$45.50$12,882.45RequiredPrepare a bank reconciliation at June 30, 2023. Assume that any errors weremade by the bookkeeper and Cheque #585 was for office supplies.GROUP B PROBLEMS(Excel templates for all questions are available in Mylab Accounting)Preparing a bank reconciliation,including collection of a noteO (20 min)P9-18. As the bookkeeper of Rose Company of Drumheller, you received the bank state-ment from TD Canada Trust indicating a balance of $5,820. The ending cheque-book balance was $6,321. Prepare the bank reconciliation for Rose Company as ofJuly 31, 2023, and prepare journal entries as needed based on the following:Chok Figea. Deposits in transit, $2,875.b. Bank service charges, $24.c. Cheques outstanding: No. 111, $478; No. 115, $1,147.Reconciled balance $7,630d. TD Canada Trust collected a note for Rose, $1,770, less a $12 collection fee.e. NSF cheque, $525.f. Rose Company records cheque No. 107 as $900 to pay the month's rent. Thecancelled cheque and bank statement show the actual cheque was $800.g The bank made an error by deducting a cheque for $560 issued by anotherbusiness.P9-28. Several source documents from RJ's Tax Services are presented belo. AdditionalPreparing a bank reconciliationwith an NSF chequeinformation is as follows.O 40 min)a. The PMT on September 29 was a loan payment taken out of RJ's Tax Servicesaccount in error due to a bank clerk's mistake.Chk Figeb. Cheque No. 674 was a payment for insurance to B. Brubacher Brokers. Thebookkeeper recorded it as $690 in error.c. The NSF cheque was in payment of an accounts receivable balance owed byVinny Vanelswyk.Reconciled balance $4,441448CHAPTER 9RJ's Tax ServicesBank ReconciliationAugust 31, 2023Unadjusted Cash G/LBank Statement Balance$3,000Balance$3,351Add:Deposits in transit(Aug 29)1,5004.500Deduct: Outstanding chequesNo. 669 600No. 670 5491,149Adjusted Cash G/LBalanceAdjusted Bank Balance$3,351$3,351Bank Statement for the month ending September 30, 2023Cheques/ChargesReferenceDeposits/CreditsBalanceDateAwonnt ReferenceDateAwonntAug 31Sep 1BAL$3,000#669S600DEPSep 11,5003,900#6713,650Sep 4Sep 5250#674600DEPSep 5Sep 17Sep 228003,850DEP5004,350NSFSep 22300DEP7004,750PMTSep 294004,350S/C4,365Sep 30Sep 3035INTSep 3050BAL$4,365General Ledger Cash AccountDateExplanationDebitCreditBalanceAug 31Balance$3,351Sep. 30Cash Receipts3,5006,851Sep. 30Cash Disbursements2,2154,636Deposits MadeCheques Written

Hi student Since there are multiple questions, we will answer only first question.

ENcel ter ons P9-18. As the bookkeeper of Rose Company of Drumheller, you received the bank state- ment from TD Canada Trust indicating a balance of $5,820. The ending cheque- book balance was $6,321. Prepare the bank reconciliation for Rose Company as of July 31, 2023, and prepare journal entries as needed based on the following a. Deposits in transit, $2,875. b. Bank service charges, $24. c. Cheques outstanding No. 111, $478; No. 115, $1,147. d. TD Canada Trust collected a note for Rose, $1,770, less a $12 collection fee. e. NSF cheque, $525. f. Rose Company records cheque No. 107 as $900 to pay the month's rent. The cancelled cheque and bank statement show the actual cheque was $800. g The bank made an error by deducting a cheque for $560 issued by another business.

ENcel ter ons P9-18. As the bookkeeper of Rose Company of Drumheller, you received the bank state- ment from TD Canada Trust indicating a balance of $5,820. The ending cheque- book balance was $6,321. Prepare the bank reconciliation for Rose Company as of July 31, 2023, and prepare journal entries as needed based on the following a. Deposits in transit, $2,875. b. Bank service charges, $24. c. Cheques outstanding No. 111, $478; No. 115, $1,147. d. TD Canada Trust collected a note for Rose, $1,770, less a $12 collection fee. e. NSF cheque, $525. f. Rose Company records cheque No. 107 as $900 to pay the month's rent. The cancelled cheque and bank statement show the actual cheque was $800. g The bank made an error by deducting a cheque for $560 issued by another business.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The cash receipts and cash payments of Detuya Company for April 2020 follow: CASH RECEIPTS CASH PAYMENTS Cash Debit Check No. Cash Credit P 44,550 7,350 96,500 33,200 73,600 Date Apr. 2 8 P 208,700 20,350 27,950 109,350 92,700 4113 4114 10 4115 16 4116 22 4117 29 53,000 16,850 4118 50,000 31,600 83,750 5,000 120,650 30 4119 4120 4121 4122 Detuya Company received the following bank statement on April 30, 2020: BANK STATEMENT April 2020 P 95,550 Beginning balance Add: Deposits and other credits: Apr. 1 P 16,300 Electronic fund transfer 208,700 20,350 27,950 109,350 68,400 Bank collection 92,700 4 9 12 17 22 23 543,750 Less: Checks and other debits: Apr. 7 13 P 44,550 69,500 45,150 Unauthorized signature 7,350 33,200 10,950 Electronic fund transfer 73,600 50,000 1,000 Service charge 14 15 18 21 26 30 30 335,300 P 304,000 Ending balance
As on 30 April the Bank statement of CAT LLC reports a bank balance of RO 6,250, without recording a credit transfer from a customer of RO 4,200 and a standing order payment of RO 3,500. Deposits awaiting clearance were RO 3,400 and the value of cheques yet to be presented on this date was RO 3,780. The cash bank balance is. a. RO 4330 b. Ro 8170 c. RO 2830 d. RO 1920
please answer
On December 31st, the cheque book balance of Bob's Burgers Ltd. was $1,301.31. The bank statement balance was $1,670.26. Cheques outstanding were $3,152.88. The statement revealed a deposit in transit of $2,815.35 as well as a bank service charge of $112.88. The company earned interest income of $44.30. Complete a bank reconciliation for Bob's Burgers Ltd. $1,332.73 $1,968.23 $1.514.04 $1,345.61 $1,414.19 $1,896.66 $1.269.89 $2.454.19
prepare a bank reconciliation report.
On July 31, 2022, Carla Vista Co. had a cash balance per books of $6,335.00. The statement from Dakota State Bank on that date showed a balance of $7,885.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $19.00. 2. The bank collected $1,715.00 from a customer for Carla Vista Co. through electronic funds transfer. 3. The July 31 receipts of $1,394.30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31. 4. Company check No. 2480 issued to L. Taylor, a creditor, for $374.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $347.00. 5. Checks outstanding on July 31 totaled $2,046.10. 6. On July 31, the bank statement showed an NSF charge of $770.00 for a check received by the company from W. Krueger, a customer, on account.…
answer in text form please (without image)
The following data were available for Nina School of Rock at Dec 31, 2022:Cash in bank - BPI (per books) 75,000Cash in bank - Metrobank (1,000)Payroll fund 25,000Petty cash fund, 3,000 (includes 500 unreplenished vouchers)Additional information at Dec 31:a. Outstanding checks, P1,200b. Service charge for Dec P200 (unrecorded by books)c. Deposit in transit, P2,000How much is the amount of cash at Dec 31, 2022? 102,000 102,300 102, 800 103,100
You are the bookkeeper of Mel Traders. You undertake a bank reconciliation at the end of every month. Mel Traders received its bank statement for the month ending 31 May 2021. The bank reconciliation at the end of April showed a deposit in transit of $11,700 and two outstanding cheques (no. 663 for $3,060and no. 671 for $6,300). The adjusted cash balance in the entity’s records was $106,305 debit at the end of April. Below are theentity’s May bank statement and the entity’s book records that indicate the deposits made and cheques written during the month of May: AU Bank - Bank Statement For the period 01/05/2021 – 31/05/2021 Mel Traders Dr Cr Balance $ Balance brought forward 103,965 CR 1 May Deposit 11,700 115,665 CR 3 May Deposit 10,620 126,285 CR May Cheque # 682 4,680 121,605 CR 6 May Deposit 6,120 127,725 CR 8 May # 671 6,300 121,425 CR…
Prepare a bank reconciliation statement
Attached is some information about DGA Groceries. Use this information to prepare a bank reconciliation for April 30, 2020. Bank of Edmonton Downtown Edmonton, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 7800-7802364 Description Deposit Withdrawal Date Balance Balance Forward 1-Apr-20 15,032.00 Cheque#7801010 200.00 1-Apr-20 14,832.00 EFT 2,900.00 1-Apr-20 17,732.00 Cheque Deposit 1,800.00 2-Apr-20 19,532.00 Cheque Deposit 800.00 3-Apr-20 20,332.00 Cheque#7801012 1,500.00 3-Apr-20 18,832.00 Cheque#7801013 1,912.00 3-Apr-20 16,920.00 Checque Deposit 13,200.00 3-Apr-20 30,120.00 Cheque#7801014 110.00 6-Apr-20 30,010.00 Cash Withdrawal 100.00 7-Apr-20 29,910.00 Cash Deposit 1,275.00…