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

ABC COMPANY
Bank Reconciliation
Dec 31
Ending Balance Per bank statement	$25,293.67	Ending Balance Per Company record	$37,219.64
Additions:		Additions:
Deposits in transit	$13,545.00
	$38,838.67		$37,219.64
Deductions:		Deductions:
Outstanding checks #2160	$758.02	Service Charges	$75.00
Outstanding checks #2181	$500.00	Error in check# 2163	$900.00
Outstanding checks #2182	$67.34	(2106.88 - $1,206.88)
Outstanding checks #2183	$480.25	Error in check# 2167	$0.04
Outstanding checks #2184	$1,300.00	Error in check# 2180	$511.54
Bank balance per reconciliation	$35,733.06	Company balance per reconciliation	$35,733.06