Accounting HW – Bank Reconciliation

Cash Activity

: Cash – Wells Fargo-ACCT#1234

Name

Provided catering services

ACH

ACH

ACH

-7,000.00

Divine Catering

Cash Activity Statement

As of Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper

December 31, 2012

Account Number: 1000

Account

Name

Date

Check Number

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

4,400.00

12/13/12

1372

AT&T

November phone bill

-75.00

12/15/12

State of Arizona

November sales tax

-2,958.72

12/19/12

Transfer

Payroll account

Salaries

-2,788.25

12/20/12

ASU-President’s Office

Graduation Banquet Catering

12,050.00

12/23/12

Sysco Foods

Inventory purchase

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

Bank Statement

)

Date

Deposits or Additions Withdrawals or Subtractions

12/1/12

12/1/12

12/13/12

12/15/12

12/19/12

12/20/12

12/20/12

12/23/12

12/24/12

$7,000.00

$27,151.31 $26,439.67

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
Description
Posted Transactions
Deposit #188542239					$8,450.56
Check #1365		$106.38
12/2/12	Chase Mastercard ACH #330	$5,984.27
12/5/12	Check #1367		$426.55
Deposit #188542240	$6,650.75
State of Arizona ACH #331	$2,958.72
Transfer to account #1235	$2,788.25
Check #1371		$7,000.00
ACH Deposit ASU	$12,050.00
Check #1370	$175.50
Sysco Foods ACH #332
Totals

Bank Reconciliation-Nov

Divine Catering

Balance

$234,227.43

$8,450.56

)

Deposits in Transit

$8,450.56

$8,450.56

DIT $8,450.56

Outstanding Checks

$106.38

$426.55

$3,032.93

O/S Checks $3,032.93 OK

	Bank Reconciliation
November 30, 2012
	Account #1234
Balance per bank statement
	Deposits in Transit
	Outstanding Checks	(		$3,032.93
True Cash Balance	$239,645.06
Deposits in Transit – Check Figure
Deposit made 11/30/2012	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	Deposits processed by bank	$33,687.14
	OK
Outstanding Checks – Check Figure
Check #1365 to Cox Communications	Total Withdrawals per books	$23,449.14
Check #1367 to Sysco Foods	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	Withdrawals processed by bank	$22,574.96

Bank Reconciliation-Dec

Divine Catering
Bank Reconciliation

December 31, 2012

Account #1234

Sheet2

Use the attached Excel file to prepare a Bank Reconciliation as of December 31, 2012 for the Divine Catering Company.  Remember, in order to complete a bank reconciliation you need three pieces of information; the current month’s (December) cash activities for Divine Catering, the current month’s bank statement for December, and last month’s bank reconciliation from November.  This information is provided to you in the Excel file by clicking on the tabs at the bottom of the file labeled “Cash Activity”, “Bank Statement”, and “November Bank Reconciliation.”  The fourth tab across the bottom is labeled “December Bank Reconciliation”, but is essentially a blank page.  This is where you will create your December Bank Reconciliation using the information presented on the preceeding tabs.  Use the same format as presented for the November Bank Reconciliation. Be sure to include your supporting schedules for Deposits in Transit and Outstanding checks.  You must also give a detailed breakdown of which deposits are still in transit (this must reconcile back to your DIT as of 12/31) and an itemized list of those checks that are still outstanding (this must reconcile back to your O/S Checks as of 12/31.)