P7.7B (LO 4) AP The Agricultural Genetics Company's Cash account in its general ledger reported a...

P7.7B

(LO 4) AP The Agricultural Genetics Company's Cash account in its general ledger reported a balance of $6,782 on May 31, 2021. The company's bank statement from Western Bank reported a balance of $6,405 on the same date.

A comparison of the details in the bank statement with the details in the Cash account revealed the following facts.

1.The bank statement included a debit memo of $40 for bank service charges.
2.Cash sales of $836 on May 18 were deposited in the bank. The journal entry to record the cash sales and the deposit slip to deposit the cash were incorrectly made out for $886. The bank correctly credited Agricultural Genetics Company for the correct amount.
3.The April 30 deposit of $2,190 was included on the May bank statement. The deposit had been placed in the bank's night deposit vault on April 30.
4.The May 31 deposit of $2,416 was not included on the May bank statement. The deposit had been placed in the bank's night deposit vault on May 31.
5.Cheques #928 for $180 and #1014 for $236 were outstanding on April 30. Of these, #928 cleared the bank in May. All of the cheques written in May except for #1127 for $105 and #1195 for $235 had cleared the bank by May 31.
6.On May 18, the company issued cheque #1151 for $685 to L. Kingston, on account. The cheque, which cleared the bank in May, was incorrectly journalized and posted by Agricultural Genetics Company for $658.
7.A review of the bank statement revealed that Agricultural Genetics Company received $2,200 of electronic payments from customers on account in May. The bank had also credited the company's account with $80 of interest revenue on May 31. The bank charged a $20 collection fee. Agricultural Genetics Company had no previous notice of these amounts.
8.On May 31, the bank statement showed an NSF charge of $680 for a cheque issued by Pete Dell, a customer, to Agricultural Genetics Company on account.

Instructions

a.

Prepare the bank reconciliation at May 31.

b.

Prepare the necessary adjusting entries at May 31.

Taking It Further

What would you say to the Agricultural Genetics Company's bank manager, who is concerned that the company's May 31 Cash account balance shows a different amount than the May 31 bank statement?

Expert Solution

ekkarill92 answered 1 year ago

A company's general ledger shows a cash balance of $4,590. Comparing the company's cash records with...

A company's general ledger shows a cash balance of $4,590. Comparing the company's cash records with the monthly bank statement reveals several additional cash transactions such as checks outstanding of $2,850, bank service fees of $120, and interest earned of $27. Calculate the correct balance of cash..

The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at...

The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company's bank statement showed a balance of $22,000 at the same date. The only reconciling items consisted of: (1) a $5,000 deposit in transit, (2) a bank service charge of $200, (3) outstanding checks totaling $9,000, (4) a $3,000 check marked "NSF" from Susque Company, one of Lyco's customers, and (5) a check written...

On October 31, 2021, Damon Company's general ledger shows a checking account balance of $8,439

On October 31, 2021, Damon Company's general ledger shows a checking account balance of $8,439. The company's cash receipts for the month total $74,600, of which $71,365 has been deposited in the bank. In addition, the company has written checks for $72,509, of which $71,234 has been processed by the bank. The bank statement reveals an ending balance of $12,749 and includes the following items not yet recorded by Damon: bank service fees of $290, note receivable collected by the bank...

Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021

Exercise 4-9A Calculate the balance of cash using a bank reconciliation (LO4-5) Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021. The July cash receipts of $1,825, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $49. The bank processes all checks written by the company by...

On October 31, 2021. Damon Company's general ledger shows a checking account balance of $8.457 ...

On October 31, 2021. Damon Company's general ledger shows a checking account balance of $8.457. The company's cash receipts for the month total $74,720, of which $71,395 has been deposited in the bank. In addition, the company has written checks for $72,527, of which $71,342 has been processed by the bank. The bank statement reveals an ending balance of $13,187 and includes the following items not yet recorded by Damon: bank service fees of $350, note receivable collected by the bank...

Spielberg Company's general ledger shows a checking account balance of $22,880 on July 31, 2021. The...

Spielberg Company's general ledger shows a checking account balance of $22,880 on July 31, 2021. The July cash receipts of $1,795, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $46. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for...

The following list includes all of the account balances from Blue and White Company's general ledger...

The following list includes all of the account balances from Blue and White Company's general ledger on December 31, 2020, after all the adjusting entries have been posted. The accounts are listed in alphabetical order, and all accounts have a normal balance. This was Blue and White Company's first year in business. Instructions: Using the information provided above, prepare a multiple-step income statement, statement of owner's equity, and classified balance sheet for Blue and White Company for the fiscal year...

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance:...

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance: CASH No. 101 Date Explanation Ref Debit Credit Balance May 31 Balance 6,841 The bank statement from Canada Bank on that date showed the following balance: CANADA BANK Cheques and Debits Deposits and Credits Daily Balance XXX XXX 5/31 6,804 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts. 1.The statement included a...

Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30...

Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30 and the bank statement as of that date indicates a balance of $4,450.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $34.00. 2. A bank memo stated that Bao Dai’s note for $900 and interest of $46.00 had been collected on June 29, and the bank had charged $6.30...

Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30...

Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30 and the bank statement as of that date indicates a balance of $4,145.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $33.00. 2. A bank memo stated that Bao Dai’s note for $897.00 and interest of $42.00 had been collected on June 29, and the bank had charged $7.50...

Question