Construct a bank reconcilliation

The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2016, balance of $15,133.37. Information that might be useful in preparing a bank reconciliation is as a. Outstanding checks were $1,371.00 b. The December 31, 2016, cash receipts of $600 were not deposited in the bank until January 2, 2017 c. One check written in payment of rent for $251 was correctly recorded by the bank but was recorded by 0 1 MSI as a $263 disbursement. d. In accordance with prior authorization, the bank withdrew $500 directly from the checking account as payment on a mortgage note payable. The interest portion of that payment was $375. MSI has made no entry to record the automatic payment e. Bank service charges of $19 were listed on the bank statement. f. A deposit of $900 was recorded by the bank on December 13, but it did not belong to MSI. The deposit g. The bank statement included a charge of $50 for an NSF check. The check was returned with the bank h. MSI maintains a $250 petty cash fund that was appropriately reimbursed at the end of December should have been made to the checking account of MIS, Inc. statement and the company will seek payment from the customer i. According to instructions from MSI on December 30, the bank withdrew $12,500 from the account and purchased U.S. Treasury bills for MSI. MSI recorded the transaction in its books on December 31 whern it received notice from the bank. Half of the Treasury bills mature in two months and the other half in six months