Prepare a bank reconciliation statement

Statement Jan 1, 2012 to Jan 31, 2012 Date: Balance as of 12/31/11 Total Withdrawals Total Deposits Balance as of 1/31/12 5,031,581 2,685,741 2,071,581 4,417,421 DEBITS CLEARED CHECKS Check # 1157 1159 1161 1162 1163 1165 1166 1167 1168 1169 1170 Date 2-Jan 4-Jan 5-Jan 6-Jan 6-Jan 9-Jan 10-Jan 10-Jan 11-Jan 12-Jan 12-Jan Amount 5,682 45,985 326,854 58,978 28,945 125,478 2,685 95,820 46,857 5,681 265,846 Check # 1171 1172 1173 1174 1175 1177 1180 1182 1183 1184 1186 Date 13-Jan 14-Jan 15-Jan 18-Jan 20-Jan 22-Jan 23-Jan 25-Jan 27-Jan 28-Jan 30-Jan Amount 126,800 46,859 7,495 46,821 69,851 80,752 265,874 468,597 2,685 369,874 191,322 Total Debits 2,685,741 CREDITS DEPOSITS Date Posted 2-Jan 6-Jan 13-Jan 20-Jan 27-Jan Amount 62,857 457,568 504,982 521,647 524,527 Total Credits 2,071,581 Additional Information for Part 1 The following checks were noted in the cash disbursements journal for the month of January Check # 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 Date 6-Jan 7-Jan 9-Jan 9-Jan 9-Jan 9-Jan 11-Jan 11-Jan 12-Jan 12-Jan 12-Jan 16-Jan 17-Jan 17-Jan 20-Jan 21-Jan 24-Jan 24-Jan 26-Jan 27-Jan 27-Jan Amount 2,685 95,820 46,857 5,681 265,846 126,800 46,859 7,495 46,821 69,851 4,678 80,752 21,648 584,257 265,874 658 468,597 2,685 369,874 8,421 191,322 The following deposits were noted in the cash receipts journal for the month of January Date 3-Jan 10-Jan 19-Jan 25-Jan 30-Jan Amount 457,568 504,982 521,647 524,527 76,248