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

Using the following information: a. The bank statement balance is $4,265. b. The cash account balance is $4,448. c. Outstanding checks amount to $835. d. Deposits in transit are $954. e. The bank service charge is $55. f. A check for $37 for supplies was recorded as $28 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co. Bank Reconciliation Line Item Description May 31 Amount Amount Cash balance according to bank statement Adjusted balance Cash balance according to company's records Total deductions Adjusted balance
Company developed the following reconciling information and preparing it's April bank recognition: cash balance per bank for 15400, note receivable collected by Bank 8400, outstanding checks 12,600 deposit in transit 6300; bank service charge 150 NSF check 1680; using the above information determine The cash balance per books before adjustment for the company
Bank Reconciliation and Adjusting Entries (Appendix 6.1) Odum Corporation’s cash account showed a balance of $17,198 on March 31, 2019. The bank statement balance for the same date indicated a balance of $17,924.55. The following additional information is available concerning Odum’s cash balance on March 31: • Undeposited cash on hand on March 31 amounted to $724.50. • A customer’s NSF check for $173.80 was returned with the bank statement. • A note for $2,000 plus interest of $25 was collected for Odum by the bank during March. The bank notified Odum of this collection on the bank statement. • The bank service charge for March was $15. • A deposit of $951.75 mailed to the bank on March 31 did not appear on the bank statement. The following checks mailed to creditors had not been processed by the bank on March 31: #429 $57.40 #432 $147.50 #433 $214.80 #434 $191.90 A customer check for $149.50 in payment of his account and listed correctly for that amount on the bank state-ment had…
Using the following information, prepare a bank reconciliation for Young Co. for August 31, 2019, and prepare the journal entries: (a) The bank statement balance is $4,095 (b) The cash account balance is $4,205. (c) Outstanding checks amounted to $517. (d) Deposits in transit are $655. (e) The bank service charge is $45. (f) A check for $84 for supplies was recorded as $48 in the ledger. (g) NSF check for $649.00 (h) EFT collected $715.00 (i) Bank error processed a check for $53 as $35
Consolidated Paper has just completed its bank reconciliation for the month of Febrruary 2023 as shown below. Balance per bank....... Add: Deposit in transit......... O Less: Outstanding checks... $16,200 2,600 (900) Balance per books...... Add: Interest earned. Less: Bank service charge.... Add: Error in posting payment of accounts receivable Reconciled balance........ $17,900 customer............ $17,400 200 (100) 2 3 Reconciled balance............... 4 5 a. Prepare the adjusting entry (debits and credits) that is needed as a result of the bank reconciliation. 6 b. What cash balance will Consolidated Paper report on its February 28, 2023 financial statements 7 8 9 0 1 400 $17,900
As of June 30, Year 1, the bank statement showed an ending balance of $18,181. The unadjusted Cash account balance was $17,028. The following information is available: 1. Deposit in transit, $2,795. 2. Credit memo in bank statement for interest earned in June: $14. 3. Outstanding check: $3,946. 4. Debit memo for service charge: $12. Required: Determine the true cash balance by preparing a bank reconciliation as of June 30, Year 1, using the preceding information. Note: Negative amounts should be indicated with minus sign. Bank Reconciliation Unadjusted bank balance 6/30/Year 1 True cash balance 6/30/Year 1 Unadjusted book balance 6/30/Year 1 True cash balance 6/30/Year 1 $ $ $ 18,181 18,181 4 0
Using the following information, prepare a bank reconciliation for Sunland Company for July 31, 2022. The bank statement balance is $3,770. The cash account balance is $4,170. Outstanding checks totaled $1,360. a. b. C. d. e. f. Deposits in transit are $1,670. The bank service charge is $54. A check for $95 for supplies was recorded as $59 in the ledger.
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
Egrane, Incorporated's monthly bank statement showed the ending balance of cash of $20,400. The bank reconciliation for the period showed an adjustment for a deposit in transit of $2,450, outstanding checks of $3,900, an NSF check of $2,600, bank service charges of $125 and the EFT from a customer in payment of the customer's account of $3,400. What was the cash balance on the Egrane's books (before the adjustments for items on the bank reconciliation)?
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.…
Bank Reconciliation and Adjusting Entries (Appendix 6.1) Instructions Chart of Accounts Labels and Amount Descriptions Bank Reconciliation General Journal X Instructions Odum Corporation’s cash account showed a balance of $17,200 on March 31, 2019. The bank statement balance for the same date indicated a balance of $17,916.55. The following additional information is available concerning Odum’s cash balance on March 31: • Undeposited cash on hand on March 31 amounted to $724.50. • A customer’s NSF check for $180.80 was returned with the bank statement. • A note for $2,000 plus interest of $25 was collected for Odum by the bank during March. The bank notified Odum of this collection on the bank statement. • The bank service charge for March was $15. • A deposit of $950.75 mailed to the bank on March 31 did not appear on the bank statement. The following checks mailed to creditors had not been processed by the bank on March…
On July 31, 2020, Concord Company had a cash balance per books of $6,043.75. The statement from Dakota State Bank on that date showed a balance of $7,738.05. A comparison of the bank statement with the Cash account revealed the following facts. 1. 2. 3. 4. 5. 6. The bank service charge for July was $25. The bank collected $1,680 for Keeds Company through electronic funds transfer. The July 31 receipts of $1,225.50 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31. Company check No. 2480 issued to L. Taylor, a creditor, for $361 that cleared the bank in July was incorrectly entered as a cash payment on July 10 for $316. Checks outstanding on July 31 totaled $1,888.80. On July 31, the bank statement showed an NSF charge of $579 for a check received by the company from W. Krueger, a customer, on account.