Prepare a Bank Reconciliation the month ended Nov 30, 20xx

Please show all work, thank you

Salt & Pepper Salads is trying to perform its bank reconciliation for the month of November and its owner, your favorite cousin, Tom, needs your help. His books show a cash balance of an even $8,000 while the bank statement he just received for this past month only shows a cash balance of $6,865.34. Tom was paying all his bills yesterday and wrote these check. He could not see these checks included in the bank statement. #112 in the amount of $200.99 to Energy Source for the electric bill #113 in the amount of $877.26 to SYSCO for food purchased #114 in the amount of $36.41 to Flyers Everyone for flyers made #1155 in the amount of $45.61 to Staples for office supplies He also deposited two checks yesterday and they have not been processed by the back as yet 1. a check of $988.36 from Mr. Velez where Tom catered an office lunch event 2. a check of $745.00 from Ms. Shaw for a wedding shower Tom catered for her daughter The bank paid Tom $2.63 in interest for the month. Unfortunately, one of the checks Tom deposited from a client turned out to be a non-sufficient fund check, thus the bank also charged Tom a service fee of $35 as a processing fee. That particular check was from Ms. Joyce, in the amount of $679.20. The book also collected a check for Tom in the amount of $200. Since Tom did not keep a minimum balance of $10,000, the bank also charges him a monthly fee of $50. Prepare a bank reconciliation the month ended Nov 30, 20x>