Question

ABC Company Checking DATE BALANCE 12/1 12/2 12/3 124 1215 1216 1217 12/9 12/9 12/10 12/11 12/12 12/13 12/14 18 19 December DEPOSIT/ (CHECK) Beginning Balance: 2157 (175.29) 2158 (759.36) 2159 (1,368.73) 2160 (758.02) 2161 (675.16) 2162 (10,009 28) 28,745.12 2163 (1.206.38) 2164 (11,733.34) 2165 (367.01) 2166 (893.70) 2167 (1.105.50) 2168 (1,381.56) 2169 (1,050.79) 2170 (889.99) 2171 (429.42) 20,158.45 2172 (651.25) 2173 (819.18) 2174 (1,231.91) 2175 (34.34) 2176 (1,27623) 2177 (763.82) 2178 (755.91) 2179 (435.14) 2180 255.77 2181 (500.00) 2182 (6734) 13,545.00 2183 (480.25) 2184 (130000) 20 Bank of La Crosse December DEPOSIT / DATE # (CHECK) BALANCE Beginning Balance: 18,337.99 12/8 Deposit 28,745.12 47,083.11 12/19 Deposit 20,158.45 67 241.56 12/1 2154 (299.95) 66,941.61 12/1 2155 (375.00) 66,566.61 12/2 2156 (2,028.34) 64.538 27 12/3 2157 (175.29) 64,362.98 124 2158 (759.36) 63,603.62 125 2159 (1,368.73) 62,234.89 1217 2161 (675.16) 61,559.73 12/8 2162 (10,009.28) 51,550.45 12/9 2163 (2,106.88) 49,443.57 12/10 2164 (11,733.34) 37,71023 12/11 2165 (367.01) 37,343.22 12/12 2166 (893.70) 36,449.52 12/13 2167 (1.105.54) 35,343.98 12/14 2168 (1,381.56) 33,962.42 12/15 2169 (1,050.79) 32,911.63 12/16 2170 (889.99) 32,021.64 1217 2171 (429.42) 31,592.22 12/18 2172 (651.25) 30,940.97 12/19 2173 (819.18) 30,121.79 1220 2174 (1.231.91) 28,889.88 1221 2175 (3434) 28,855.54 1222 2176 (1.276.23) 27,579.31 1223 2177 (763.82) 26,815.49 12/24 2178 (755.91) 26,059.58 12/25 2179 (435.14) 25,624.44 12/26 2180 (255.77) 25,368.67 12/31 Monthly Fei (75.00) 25,293.67 12/15 15,634.70 15,459.41 14,700.05 13,331.32 12,573.30 11,898.14 1,888.86 30,633.98 29,427.10 17,693.76 17,326.75 16,433.05 15,327.55 13.945.99 12,895.20 12,005.21 11,575.79 31,734 24 31,082.99 30,263.81 29,031.90 28,99756 27,72133 26,957.51 26,201.60 25,766.46 26,022.23 25,522.23 25,454.89 38,999.89 38,519.64 37.219.64 12/16 12/17 12/18 12/19 12/20 1221 12/22 1223 12/24 12/25 1226 1227 12/28 12/30 12/30 1231 39 Date 12/31 Checking Account Item Description Book Balance: Amount 37,219.64 Date 12/31 Bank Statement Item Description Bank Statement Balance: Amount 25,293.67 11/30 11/30 11/30 O/S Check 2154 O/S Check 2155 O/S Check 2156 (299.95) (375.00) (2,028.34) Reconciled Book Balance 372219.64 Reconciled Bank Balance 72,59038 Reconciling difference: 14,629.26 there is a reconciling issue, assume the bank is correct.

Answer 1

Reconciliation Statement			Remarks
DATE	ITEM DESCRIPTION	AMOUNT
12/31	Book Balance	37219.64
12/4	O/s Check 2160	758.02
12/9	Check 2163 (Wrong)	1206.88
12/9	Check 2163 (Correct)	-2106.88
12/13	Check 2168	-0.04	Difference as per Bank
12/26	O/s Check 2180 (Wrong)	-255.77	Added, but it should be deducted, so rectified the addition
12/26	O/s Check 2180 (Correct)	-255.77	After correction, it should be deducted
12/27	O/s Check 2181	500.00
12/28	O/s Check 2182	67.34
12/28	O/s Check 2183	480.25
12/30	O/s Check 2184	1300.00
12/31	Deposit	-13545.00
12/31	Monthly Fee	-75.00
	Bank Statement Balance	25293.67