Accounting for Cash

I need help with a Accounting question. All explanations and answers will be used to help me learn.

You are an employee at a full service bookkeeping and auditing firm called Accounting Solutions. You have been doing general bookkeeping services for one of your clients, Atlas Travel. Today, the owner Amy, has specifically asked for some assistance with recording transactions on receivables and bad debt. She also wants help with preparing a bank reconciliation statement.

Amy gives you the following information. Use this template to complete fourth quarter journal entries for Atlas Travel. Also complete the December bank reconciliation statement on the second worksheet (Atlas Travel Bank Rec.).

(i added the actual spreadsheet that needs to be done, and the practice one that shows what and how needs to be done.)