Alpha Company does all of its banking with the Micro City Bank & Trust, Co. The following banking information from its bank statement dated January 31, 2018 was provided to you late 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 concerns. One of great concern is that the IT section noted that 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 system generated. It now remains to you to determine 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 once the IT section can get its act together and "fix the system!! Item Amount Cash Balance per Bank (1/31/18) $30,200 Bank Service Charges 175 Collection of Note Receivable from Mr. Yankee-Zulu including the interest of $150 5,145 Micro City B&T paid directly from the cheque account the current portion of Alpha's Mortgage Payable which included the interest due for the month in the amount of $150 2,650 Customer (Mr. Welcher) cheque was returned as NSF by Micro Bank system for $250. The following additional information was determined from a review of the cash payments & receipts and the cheque register for Alpha Company: 1. The following cheques had not cleared the bank as paid: Date | Cke 11/20/17 5005 Bravo Office Supply Store 1/15/18 5025 Zulu Electric Company 1/30/18 5030 Bravo Office Supply Store Accounts Payable Amount $375 2,900 350 2. The following information was recorded in Alpha's cash receipts ledger and have not yet been recorded in the bank statements: Alpha Company does all of its banking with the Micro City Bank & Trust, Co. The following banking information from its bank statement dated January 31, 2018 was provided to you late 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 concerns. One of great concern is that the IT section noted that 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 system generated. It now remains to you to determine 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 once the IT section can get its act together and "fix the system!! Item Amount Cash Balance per Bank (1/31/18) $30,200 Bank Service Charges 175 Collection of Note Receivable from Mr. Yankee-Zulu including the interest of $150 5,145 Micro City B&T paid directly from the cheque account the current portion of Alpha's Mortgage Payable which included the interest due for the month in the amount of $150 2,650 Customer (Mr. Welcher) cheque was returned as NSF by Micro Bank system for $250. The following additional information was determined from a review of the cash payments & receipts and the cheque register for Alpha Company: 1. The following cheques had not cleared the bank as paid: Date | Cke 11/20/17 5005 Bravo Office Supply Store 1/15/18 5025 Zulu Electric Company 1/30/18 5030 Bravo Office Supply Store Accounts Payable Amount $375 2,900 350 2. The following information was recorded in Alpha's cash receipts ledger and have not yet been recorded in the bank statements
