Alpha Company does all of its banking with the Micro City Bani &Tust, Co. The ing banking information from its bank statement dated January 31, 208 was pravided to you ate on the close of business today. Your general manager asked you to prepare the bank reconciliation because it is believed that there may be some personnel concems. One of great concern is that the IT section noted thait the general ledger balances were not being calculated. The day-to-day system information was entered but for some reason no monthly balances could be systen generated. It now remains to you to detenmine what should be the balance per books for the Cash account. This is critical information since it will be used to validate any system generated dollar amount for the Cash account as of 1/31/18 ance the IT section carpet its act together and x" the system!! Amount Cash Balance per Bank(1/31/18 30.200 Barnk Service Charges 175 Collection of Note Receivable from Mr. Yankee Zulu including the interest of $150 5145 Micro City B&T paid directly from the cheque account the cument portion of Alpha's Mortgape Payable which inckaded the interest due for the month in the amount of $150 2.650 Customer (M Wekcher) cheque was retumed as NSF by Micro Bank system For $250 The folowing additional information was detenmined from a review of the cash payments& receipts and the cheque register for Alpha Company 1 The following cheques had not dleared the banik as paid Amount 11/20/17 5005 Bravo Office Supply Store /15/18 5025 Zulu Electric Company /30/18 5030 Bravo Office Supply Store 2. The folowling information was recorded in Alpha's cash receipts ledges and have not 2.900 350 yet been recorded in the bank statements 115/18Store Cash Sales 1/15/18 Cheques from Store Sales 1/31/18 Store Cash Sales 101/18 Oturs from Stare Sales 2,800 320 5,500 Atha Catpany's lead cashier has not returned to work since lanuary MhAfter considerable inquiry It was discovernd that the lead cashier was arnested for llegal drug possession it is critical that you perfonm this monthly bank reconciliation and make notes of you have not noted any errors made by the bank Amy recording errors are considered to be made by Algha Company personnel Therefore, to get started you must prepare, in good form the lancary 31 2018 Dank Reconcilation for Alpha Company hased on the information that you have at hand