On July 31, 2022, Wildhorse Co. had a cash balance per books of $6,290.00. The statement from Dakota State Bank on that date showed a balance of $7,840.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $18.00. 2. The bank collected $1,670.00 from a customer for Wildhorse Co. through electronic funds transfer. The July 31 receipts of $1,350.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. 3. Company check No. 2480 issued to L. Taylor, a creditor, for $354.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $345.00. 4. 5. Checks outstanding on July 31 totaled $1,983.10. 6. On July 31, the bank statement showed an NSF charge of $725.00 for a check received by the company from W. Krueger, a customer, on account. Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.) WILDHORSE CO. Bank Reconciliation v : 2$ 24 > > > >

On July 31, 2022, Wildhorse Co. had a cash balance per books of $6,290.00. The statement from Dakota State Bank on that date showed a balance of $7,840.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $18.00. 2. The bank collected $1,670.00 from a customer for Wildhorse Co. through electronic funds transfer. The July 31 receipts of $1,350.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. 3. Company check No. 2480 issued to L. Taylor, a creditor, for $354.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $345.00. 4. 5. Checks outstanding on July 31 totaled $1,983.10. 6. On July 31, the bank statement showed an NSF charge of $725.00 for a check received by the company from W. Krueger, a customer, on account. Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.) WILDHORSE CO. Bank Reconciliation v : 2$ 24 > > > >

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

Please help.me to do part a and b. Thank you for your help
On february 28th, 2022, Mark, the accountant of the scented candle business Smells LTD, prepared the documents for his february bank reconciliation. He noted a Cash balance of $15,534 in the general ledger. The bank statement on that date showed a balance of $17,675. A comparison of the bank statement with the cash account revealed the following The bank statement included service charges and card processing fees of $50 The bank statement included electronic collections (EFT) from customers, totaling $5,520. Smells LTD had not recorded the EFT yet A deposit of $200 made by another company was incorrectly added to Breathe-ins account by their bank Recent deposits worth $5,400 are not currently showing on the bank statement Cheques outstanding on January 31 totaled $3,754. Of these, $1,883 cleared the bank in February and are no longer outstanding. All new cheques written in February cleared the bank during the month Enter amounts with the final number rounded to the nearest $.…
The 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, 2024
The Cash account of ReeseCorporation had a balance of $3,540 at October 31, 2018. Included were outstanding checkstotaling $1,800 and an October 31 deposit of $300 that did not appear on the bank statement.The bank statement, which came from Turnstone State Bank, listed an October 31 balance of$5,570. Included in the bank balance was an October 30 collection of $600 on account froma customer who pays the bank directly. The bank statement also showed a $30 service charge,$10 of interest revenue that Reese earned on its bank balance, and an NSF check for $50.Prepare a bank reconciliation to determine how much cash Reese actually had at October 31.
A company's general ledger shows a cash balance of $2,350. Comparing the company's cash records with the monthly bank statement reveals several additional cash transactions such as deposits outstanding of $1,750, note collected by the bank on the company's behalf of $1,400, and interest earned of $33. The company also finds an error by the bank of an additional deposit of $140. Calculate the correct balance of cash. Cash balançe
Using the following information, prepare a bank reconciliation for Cole Co. for May 31 of the current year: (a) The bank statement balance is $3,012. (b) The cash account balance is $3,165. (c) Outstanding checks amounted to $590. (d) Deposits in transit are $704. (e) The bank service charge is $30. (f) A check for $76 for supplies was recorded as $67 in the ledger.
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.
The 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…
The books of Cajardo Service, Inc. disclosed a cash balance of P687,570 on December 31, 2010. The bank statement as of December 31 showed a balance of P547,800. Additional information that might be useful in reconciling the two balances follows: A. Check No. 748 for P30,000 was originally recorded on the books as P45,000. B. A customer's note dated September 25 was discounted on October 12. The note was dishonored on December 29, the note's maturity date. The bank charged Cajardo's account for P142,650, including a protest fee of P2,650. C. The deposit of December 24 was recorded on the books as P28,950 but it was actually a deposit of P27,000. D. Outstanding checks totaled P98,850 as of December 31. E. There was a bank service charge for December of P2,100 not yet recorded on the books. F. Cajardo's account had been charged on December 26 for a customer's NSF check for P12,960. G. Cajardo properly deposited P6,000 on December 3 that was not recorded by the bank. H. Receipts of…
The ending bank statement balance at November 30 is $6,850. The bank statement shows a service charge of $85, electronic funds receipts of $500, and a NSF check for $350. Deposits in transit total $2,350 and outstanding checks are $1,535. The balance per books at November 30 is $7,600. What is the adjusted bank balance at November 30? A. $8,415 B. $6,915 C. $6,850 D. $7,665
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.…
Jessie has a cash account per general ledger that shows a balance of $78,659 atOctober 31, 2021. Bank statement from Ocean Paradise Bank on that dateshows the following date shows the following balance. 31 October Amount $88,080 Comparison of checking account details with cash account details reveals factsas follows.1. A note receivable of $13,070 was invoiced by the bank for Jessie on the 14thOctober plus $713 interest and the bank has charged $137 on the billing. No interest has been recognized on these notes.2. Check No. 175 the amount of $5,741 was entered in the cash journal as $5,471and Check No. 189 of $2,040 was entered in the cash journal as$2,400. Both checks have been issued to pay for the purchase of supplies.3. The bank has charged Jessie account. for customer unbilled checks amounting to $789 on October 23. 4. Deposit in progress is $7,388 and outstanding check no. 123 on October 28totaling $5,309.5. There was a canceled check issued by Kenny to Leo for $2,079 that was…