Bank reconciliation help, please.
Microsoft Excel non-co T 23 e let 3 AP6-1 (Preparation of bank reconciliation) 5of the bank statement and the accounting records revealed the following information 2016,JB Cames Ltd received is bank statement from the East Coast Savings Bank showing that JB had balance of $12,200. The company's general ledger showed a cash balance of $8,600 at that date. A comparison 6 1. A cheque from one of JB's customers in the amount of $1,120 that had been deposited during the last week 8 The company had writen and mailed out cheques with a value of $4,235 that had not yet cleared the bank of May was returned with the bank statement as NSF #79, which was a payment for advertising expenses of $230, was incorrectly recorded in the 10 s During the month, the bank collected a $2,000 note receivable plus the outstanding interest on behalf of 126. The cash receipts for May 31 amounted to $1.650 and had been deposited in the night drop slot at the bank Bank service charges for the month were $55 general ledger as $320 B. The note was interest-bearing at 5% per annum and had been outstanding for one year. on the evening of May 31. These were not reflected on the bank statement for May 13 Required 14 Prepare the bank reconciliation for JB at May 31, 2016 15 Prepare any journal entries necessary as a result of the bank reconciliation prepared in part "a 9 ch 10 h11 ch 12 Sheet3 Microsoft Excel non-co T 23 e let 3 AP6-1 (Preparation of bank reconciliation) 5of the bank statement and the accounting records revealed the following information 2016,JB Cames Ltd received is bank statement from the East Coast Savings Bank showing that JB had balance of $12,200. The company's general ledger showed a cash balance of $8,600 at that date. A comparison 6 1. A cheque from one of JB's customers in the amount of $1,120 that had been deposited during the last week 8 The company had writen and mailed out cheques with a value of $4,235 that had not yet cleared the bank of May was returned with the bank statement as NSF #79, which was a payment for advertising expenses of $230, was incorrectly recorded in the 10 s During the month, the bank collected a $2,000 note receivable plus the outstanding interest on behalf of 126. The cash receipts for May 31 amounted to $1.650 and had been deposited in the night drop slot at the bank Bank service charges for the month were $55 general ledger as $320 B. The note was interest-bearing at 5% per annum and had been outstanding for one year. on the evening of May 31. These were not reflected on the bank statement for May 13 Required 14 Prepare the bank reconciliation for JB at May 31, 2016 15 Prepare any journal entries necessary as a result of the bank reconciliation prepared in part "a 9 ch 10 h11 ch 12 Sheet3
