Question

In: Accounting

Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If...

Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation

1) If Any Differences or Errors are found, Assume that Our Business made the mistake and the BANK records are accurate.

2) The Following Items were Included on the Bank Statement from the Schwab Bank for the Month as Follows;

  1. Ending Bank Balance at January 31 was $69,000.
  2. Monthly Bank Fees of $1,500
  3. NSF Check from Customer H.Clinton for $11,000
  4. Interest Earned During the month was $3,500
  5. Checks that were paid and cleared by the Bank during January,   #111 =$19,000 and #114 =$55,000.
  6. Deposits recorded by the Bank included the following = Jan20th  for $9,000
  7. Amount Collected by the Bank on account from Our Customer B.Bochy in the Amount of $12,000

3) The Following Items were Included on the GL Books of Our Business for the Month as Follows;

  1. Ending GL Balance at January 31 was $88,000
  2. Checks written from GL Account were = #111=$19,000. #112=$21,000. #113=$30,000. #114=$65,000
  3. Deposits made during the month were = Jan10th =$33,000, Jan20th =$9,000, & Jan30th =$50,000.

Answer the Following Questions and show your answers as a number only no decimals, dollar signs or commas, etc.

Compute the Reconciled Adjusted Cash Balance at Month End

Compute the Total of All Outstanding Checks at Month End=

Compute the Total of All Deposits in Transit at Month End =

Compute Ending Balance in the G/L Cash Account After all Adjustments=

Compute the Net Cash Adjustment we will need to make to our GL Book records to adjust the Cash Account =

Solutions

Expert Solution


Related Solutions

Use the following information to answer questions 6–8. You are doing a bank reconciliation for May,...
Use the following information to answer questions 6–8. You are doing a bank reconciliation for May, 20X1. You have a $2,785 unadjusted ledger cash balance and the following data: Outstanding checks: No. 719, $200; No. 727, $800; No. 732, $625 Deposits in transit, $1,200 Check No. 742 (for repairs) written for $505 but incorrectly recorded as $550 NSF check from a customer, $500 Bank service charge for May, $5 Balance per bank statement, $2,750 8. Which adjustment will you need...
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October...
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙      According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙      Outstanding checks totaled $1,433. ∙      A customer's check for $999 was returned for NSF. ∙      October's service charge was $100. ∙      The bank collected $1,600 from a customer of Lorena Company in payment of...
Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
The information below was used to prepare a bank reconciliation for Lorena Company at October 31:...
The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙      According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙      Outstanding checks totaled $1,433. ∙      A customer's check for $999 was returned for NSF. ∙      October's service charge was $100. ∙      The bank collected $1,600 from a customer of Lorena Company in payment of a...
1. Use the information below to answer the following questions. The following units of an inventory...
1. Use the information below to answer the following questions. The following units of an inventory item were available for sale during the year: Beginning inventory 10 units at $55 First purchase 25 units at $60 Second purchase 30 units at $65 Third purchase 15 units at $70 The firm uses the periodic inventory system. During the year, 60 units of the item were sold. a. Calculate the value of ending inventory using FIFO. b. Calculate the value of ending...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 48,000 $ 48,000 Work in process 9,900 19,700 Finished goods 67,000 33,700 Activities and information for May Raw materials purchases (paid with cash) 194,000 Factory payroll (paid with cash) 150,000 Factory overhead Indirect materials 14,000 Indirect...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 44,000 $ 54,000 Work in process 9,500 18,800 Finished goods 59,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 185,000 Factory payroll (paid with cash) 250,000 Factory overhead Indirect materials 10,000 Indirect...
Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October...
Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October 2019: (1) The cash ledger account showed a balance of $8,510, while the bank statement indicated a cash balance of $12,390. (2) The bank statement showed $45 interest earned for the month of October. (3) ZYX company settled its notes payable by depositing $4,000 directly into Mandy’s bank account. (4) The company issued three checks totaling $1,000, which had not been shown in the...
Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance
Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance: (input each amount as a positive value) Bank balance$ 680Account fees $ 12Checkbook balance$ 642ATM withdrawals$ 80Outstanding checks$ 112Deposit in transit$ 60Direct deposits$ 70Interest earned$ 8
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a)...
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a) The bank statement balance is $3,936. (b) The cash account balance is $4,194. (c) Outstanding checks amounted to $465. (d) Deposits in transit are $655. (e) The bank service charge is $50. (f) A check for $97 for supplies was recorded as $79 in the ledger.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT