Accounting HW - Bank Reconciliation

340-case-1-bankreconciliation-12c_1.xlsx

Cash Activity

Divine Catering
Cash Activity Statement
As of December 31, 2012
Account Number: 1000
Account Name: Cash - Wells Fargo-ACCT#1234
Date	Check Number	Name	Memo	Amount
Beginning Balance				239,645.06
12/1/12	ACH	Chase Mastercard	November credit card	-5,984.27
12/3/12	200036	Tempe Chamber of Commerce	Provided catering services	2,250.75
12/7/12	1370	Arizona Public Service Utilities	December utilities	-175.50
12/8/12	1371	Goodwin Real Estate	Monthly lease payment	-7,000.00
12/11/12	5500036	ASU Extension Services	Provided catering services	4,400.00
12/13/12	1372	AT&T	November phone bill	-75.00
12/15/12	ACH	State of Arizona	November sales tax	-2,958.72
12/19/12	Transfer	Payroll account	Salaries	-2,788.25
12/20/12	ACH	ASU-President's Office	Graduation Banquet Catering	12,050.00
12/23/12	ACH	Sysco Foods	Inventory purchase	-7,000.00
12/24/12	110035	Watson & Watson Attorneys	Holiday reception catering	572.29
12/28/12	1373	Cox Communication	Internet & Cable	-99.99
Ending Balance				232,836.37

Activity Summary
Ending Balance as of 11/30/2012	$234,227.43
Deposits or Additions	$27,151.31
Withdrawals or Subtractions	($26,439.67)
Ending Balance as of 12/31/2012	$234,939.07
Transactions
Date	Description	Deposits or Additions	Withdrawals or Subtractions
Posted Transactions
12/1/12	Deposit #188542239	$8,450.56
12/1/12	Check #1365		$106.38
12/2/12	Chase Mastercard ACH #330		$5,984.27
12/5/12	Check #1367		$426.55
12/13/12	Deposit #188542240	$6,650.75
12/15/12	State of Arizona ACH #331		$2,958.72
12/19/12	Transfer to account #1235		$2,788.25
12/20/12	Check #1371		$7,000.00
12/20/12	ACH Deposit ASU	$12,050.00
12/23/12	Check #1370		$175.50
12/24/12	Sysco Foods ACH #332		$7,000.00
Totals		$27,151.31	$26,439.67

Divine Catering
Bank Reconciliation
November 30, 2012
Account #1234
	Balance
Balance per bank statement	$234,227.43
Deposits in Transit	$8,450.56
Outstanding Checks	($3,032.93)
True Cash Balance	$239,645.06
Deposits in Transit		Deposits in Transit - Check Figure
Deposit made 11/30/2012	$8,450.56	Total Deposits per books	$35,711.91
		Prev. Month DIT	$6,425.79
		Total Deposits to be processed by bank	$42,137.70
Total DIT	$8,450.56	Deposits processed by bank	$33,687.14
		DIT	$8,450.56	OK
Outstanding Checks		Outstanding Checks - Check Figure
Check #1365 to Cox Communications	$106.38	Total Withdrawals per books	$23,449.14
Check #1367 to Sysco Foods	$426.55	Prev. Month O/S Checks	$2,158.75
Check #1369 to State Farm Insurance	$2,500.00	Total Withdrawls to be processed by bank	$25,607.89
Total O/S Checks	$3,032.93	Withdrawals processed by bank	$22,574.96
		O/S Checks	$3,032.93	OK

Divine Catering

Bank Reconciliation

December 31, 2012

Account #1234