In this assignment, you will develop a simple worksheet for bank reconcilation. The primary focus in your design of the worksheet is to use Input controls to prevent the user from making mistakes. You may consider the features such data validation, conditional formating in Excel as the controls. Of course, you can use any other feature you know to make the input contoris better. For instace, the layout of the sheet may help. Certain functions can help a user to make Judgement, and so forth. Recall the examples we used in the lab session about input controls. This may help. You can find a template on the sheet named "template" in this file. You will also find a set of data that you can use to validate your worksheet. The data can be found on the sheet named "question in this file. Amount Total Total Amount Per Statement Per Book OT Note Collections Note 1 2 2 3 ON Total Other Addition Total Note 1 2 3 C/O Check Number Bank Service 4 Note 1 2 3 4 5 6 7 Total Total Bank Errors Our Errors 1 2 Total Total Correct Balance Do the correct balances agrees Balance per Bank Statement Balance per Book $ 107,525.33 $ 106,928.68 97525.33 106928.68 Collection of Notes receivable by the banke Principal Interests Fee charged by the bank for collection $ $ $ 10,000.00 30.00 20.00 Interests on the reconciled account $ 11.95 21.95 Monthly Charge by the bank 25.00 25 Deposit in Transit Note Payment, Beethoven Payment, Mozart Payment, Mikey Refund, Pooh Amount $ 12,000.00 $ 13,000.00 $ 8,000.00 S 7,000.00 15000 25000 Outstanding Cheks Check number 1234 1235 1237 1239 1240 Amount $ 2,256.75 S 4.775.50 $ 3,567.45 S 7,500.00 s 12,500.00 2256.75 13567.95 14775 In this assignment, you will develop a simple worksheet for bank reconcilation. The primary focus in your design of the worksheet is to use Input controls to prevent the user from making mistakes. You may consider the features such data validation, conditional formating in Excel as the controls. Of course, you can use any other feature you know to make the input contoris better. For instace, the layout of the sheet may help. Certain functions can help a user to make Judgement, and so forth. Recall the examples we used in the lab session about input controls. This may help. You can find a template on the sheet named "template" in this file. You will also find a set of data that you can use to validate your worksheet. The data can be found on the sheet named "question in this file. Amount Total Total Amount Per Statement Per Book OT Note Collections Note 1 2 2 3 ON Total Other Addition Total Note 1 2 3 C/O Check Number Bank Service 4 Note 1 2 3 4 5 6 7 Total Total Bank Errors Our Errors 1 2 Total Total Correct Balance Do the correct balances agrees Balance per Bank Statement Balance per Book $ 107,525.33 $ 106,928.68 97525.33 106928.68 Collection of Notes receivable by the banke Principal Interests Fee charged by the bank for collection $ $ $ 10,000.00 30.00 20.00 Interests on the reconciled account $ 11.95 21.95 Monthly Charge by the bank 25.00 25 Deposit in Transit Note Payment, Beethoven Payment, Mozart Payment, Mikey Refund, Pooh Amount $ 12,000.00 $ 13,000.00 $ 8,000.00 S 7,000.00 15000 25000 Outstanding Cheks Check number 1234 1235 1237 1239 1240 Amount $ 2,256.75 S 4.775.50 $ 3,567.45 S 7,500.00 s 12,500.00 2256.75 13567.95 14775
