Sunland Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the company’s Cash account per its general ledger showed a balance of $6,000.00.
The bank statement from Emporia State Bank on that date showed the following balance.
Emporia State Bank
|
|||||||
---|---|---|---|---|---|---|---|
Checks and Debits | Deposits and Credits | Daily Balance | |||||
XXX | XXX | 5-31 | 6,305.60 |
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 debit memo of $40 for the printing of additional company checks. | ||
2. | Cash sales of $780.96 on May 12 were deposited in the bank. The cash receipts entry and the deposit slip were incorrectly made for $830.96. The bank credited Sunland Company for the correct amount. | ||
3. | Outstanding checks at May 31 totaled $942.95, and deposits in transit were $2,094.35. | ||
4. | On May 18, the company issued check No. 1181 for $692 to H. Moses, on account. The check, which cleared the bank in May, was incorrectly journalized and posted by Sunland Company for $629. | ||
5. | $2,500 was collected from a customer’s note receivable by the bank for Sunland Company on May 31 through electronic funds transfer. | ||
6. | Included with the canceled checks was a check issued by Tomins Company to C. Pernod for $430 that was incorrectly charged to Sunland Company by the bank. | ||
7. | On May 31, the bank statement showed an NSF charge of $460 for a check issued by Sara Ballard, a customer, to Sunland Company on account. |
1. Prepare the bank reconciliation at May 31, 2022. (List items that increase cash balance first.)
2. Prepare the necessary
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- 5 Brangelina Adoption Agency's general ledger shows a cash balance of $11,663. The balance of cash in the March- end bank statement is $7,345. A review of the bank statement reveals the following additional information: deposits outstanding of $2,803, bank service fees of $85, and unrecorded electronic funds transfer for utilities of $1,430. Calculate the correct balance of cash at the end of March. (Amounts to be deducted should be indicated with a minus sign.) Bank balance Deposits outstanding Cash balance per reconciliation Company balance Service fees EFT for utilities Cash balance per reconciliationarrow_forwardThe Cash account of Gate City Security Systems reported a balance of $2,490 at December 31, 2024. There were outstanding checks totaling $1,000 and a December 31 deposit in transit of $300. The bank statement, which came from Tri Cities Bank, listed the December 31 balance of $3,810. Included in the bank balance was a collection of $630 on account from Nicole Lee, a Gate City customer who pays the bank directly. The bank statement also shows a $20 service charge and $10 of interest revenue that Gate City earned on its bank balance. Prepare Gate City's bank reconciliation at December 31. Gate City Security Systems Bank Reconciliation December 31, 2024 Bank: Balance, December 31, 2024 ADD: LESS Adjusted bank balance, December 31, 2024 Book: Balance, December 31, 2024 ADD: LESS Adjusted book balance, December 31, 2024arrow_forwardVaughn Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the company’s Cash account per its general ledger showed a balance of $6,000.00. The bank statement from Emporia State Bank on that date showed the following balance. Emporia State Bank Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,008.00 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 debit memo of $50 for the printing of additional company checks. 2. Cash sales of $922.64 on May 12 were deposited in the bank. The cash receipts entry and the deposit slip were incorrectly made for $972.64. The bank credited Vaughn Company for the correct amount. 3. Outstanding checks at May 31 totaled $775.45, and deposits in transit were $1,633.45. 4. On May 18, the company issued check No. 1181 for $671 to H. Moses, on account. The check, which cleared…arrow_forward
- Uramilabenarrow_forwardprepare a bank reconciliation report.arrow_forwardThe following information was available to reconcile A.C. Forrest Company's book cash balance with its bank statement as of June 30, 2020: The June 30 cash balance according to the accounting records was $14,630. Oustanding checks from May's bank reconciliation: Check # 229 $770 Check # 230 540 Below is a record of the cash receipts and cash payments for June: Cash Deposits Cash Payments Date Amount Check# Amount Jun 2 $3,600 231 $1,500 Jun 5 4,210 232 7,510 Jun 11 5,230 233 1,800 Jun 17 4,500 234 3,230 Jun 23 3,350 235 1,100 Jun 27 5,100 236 1,250 Jun 30 5,390 237 6,270 238 1,650 239 820 240 1,430 241 740 242 1,310 243 2,190 244 5,300 Continued…arrow_forward
- prepare journa entries and bank rencoliationarrow_forwardI NEED HELP WITH T-TABLE Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2020, the company’s Cash account per its general ledger showed a balance of $7,402.00.The bank statement from Emporia State Bank on that date showed the following balance. Emporia State Bank Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 8,403.20 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 debit memo of $30 for the printing of additional company checks. 2. Cash sales of $993.48 on May 12 were deposited in the bank. The cash receipts entry and the deposit slip were incorrectly made for $1,043.48. The bank credited Timmins Company for the correct amount. 3. Outstanding checks at May 31 totaled $941.35, and deposits in transit were $2,013.15. 4. On May 18, the company issued…arrow_forwardOn 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.…arrow_forward
- Please reconcile The Hylton Enterprise Company bank statement to the cash book as of August 31, 2022. 1. Balance per cash book is $10,500 2. Balance per bank statement is 15,600 3. Bank charges recorded in bank but not In cash book is $115. 4. Checks issued but not yet cashed at the bank is $45,800 5. Deposit in Transit is $58,700 6. Proceeds from the closure of an Investment account is $26,700. plus Interest revenue of 1,500 7. Customer check was returned as Non-Sufficient Fund for $10,085.arrow_forwardHeadlands has the following assets at December 31, 2017. Cash in bank-savings account 138,800 Certificates of deposit (270-day) 244,000 Cash on hand 1,200 Postdated checks 6,500 Cash refund due from State Taxing Authority 31,500 Checking account balance 10,800 What amount should be reported as cash? Cash to be reported 2$arrow_forwardRequired information Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Del Gato Clinic's cash account shows a $15,374 debit balance and its bank statement shows $15,539 on deposit at the close of business on June 30. a. Outstanding checks as of June 30 total $2,735. b. The June 30 bank statement lists a $55 bank service charge. c. Check No. 919, listed with the canceled checks, was correctly drawn for $289 in payment of a utility bill on June 15. Del Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $298. d. The June 30 cash receipts of $2,524 were placed in the bank's night depository after banking hours and were not recorded on the June 30 bank statement. Exercise 6-12 Bank reconciliation LO P3 "repare its bank reconciliation using the above information. DEL GATO CLINIC Bank Reconciliation June 30 Bank statement balance Book balance Add: Add: Deduct:…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education