Need help with a simple bank reconciliation. You are asked to complete your work on the excel file by creating a Bank Reconciliation as of December 31, 2013. You are given the (3) pieces of information required to do a bank reconciliation: Last month's bank rec from November, the Cash Ledger and transactions that occurred on the company's books during December, as well as the December 31st Bank Statement from Wells Fargo. On the tab labeled "December Bank Reconciliation" is where you will create from scratch the reconciliation as well as prepare the supporting schedules for DIT and O/S Checks. You must also create an itemized list of each DIT still waiting to be processed by the bank as of December 31st as well as an itemized list of each O/S check.

Divine Catering Cash Activity Statement As of December 31, 2013 Account Number: 1000 Account Name: Cash - Wells Fargo-ACCT#1234 Date Check Number Beginning Balance 12/1/2013 12/3/2013 12/7/2013 12/8/2013 12/11/2013 12/13/2013 12/15/2013 12/19/2013 12/20/2013 12/23/2013 12/24/2013 12/28/2013 Ending Balance ACH 200036 1370 1371 5500036 1372 ACH Transfer ACH ACH 110035 1373 Name Chase Mastercard Tempe Chamber of Commerce Arizona Public Service Utilities Goodwin Real Estate ASU Extension Services AT&T State of Arizona Payroll account ASU-President's Office Sysco Foods Watson & Watson Attorneys Cox Communication Memo November credit card Provided catering services December utilities Monthly lease payment Provided catering services November phone bill November sales tax Salaries Graduation Banquet Catering Inventory purchase Holiday reception catering Internet & Cable Amount 239,645.06 -5,984.27 2,250.75 -175.50 -7,000.00 4,400.00 -75.00 -2,958.72 -2,788.25 12,050.00 -7,000.00 572.29 -99.99 232,836.37 Activity Summary Ending Balance as of 11/30/2013 Deposits or Additions Withdrawals or Subtractions Ending Balance as of 12/31/2013 $234,227.43 $27,151.31 ($26,439.67) $234,939.07 Transactions Date Description Posted Transactions 12/1/2013 Deposit #188542239 12/1/2013 Check #1365 12/2/2013 Chase Mastercard ACH #330 12/5/2013 Check #1367 12/13/2013 Deposit #188542240 12/15/2013 State of Arizona ACH #331 12/19/2013 Transfer to account #1235 12/20/2013 Check #1371 12/20/2013 ACH Deposit ASU 12/23/2013 Check #1370 12/24/2013 Sysco Foods ACH #332 Totals Deposits or Additions Withdrawals or Subtractions $8,450.56 $106.38 $5,984.27 $426.55 $6,650.75 $2,958.72 $2,788.25 $7,000.00 $12,050.00 $27,151.31 $175.50 $7,000.00 $26,439.67 Divine Catering Bank Reconciliation November 30, 2013 Account #1234 Balance per bank statement Deposits in Transit Outstanding Checks True Cash Balance Balance $234,227.43 $8,450.56 ($3,032.93) $239,645.06 Deposits in Transit Deposit made 11/30/2013 $8,450.56 Total DIT $8,450.56 Outstanding Checks Check #1365 to Cox Communications Check #1367 to Sysco Foods Check #1369 to State Farm Insurance Total O/S Checks $106.38 $426.55 $2,500.00 $3,032.93 Deposits in Transit - Check Figure Total Deposits per books Prev. Month DIT Total Deposits to be processed by bank Deposits processed by bank DIT $35,711.91 $6,425.79 $42,137.70 $33,687.14 $8,450.56 OK-matches individual DIT 's Outstanding Checks - Check Figure Total Withdrawals per books Prev. Month O/S Checks Total Withdrawls to be processed by bank Withdrawals processed by bank O/S Checks $23,449.14 $2,158.75 $25,607.89 $22,574.96 $3,032.93 OK-matches sum of individual o/s checks Divine Catering Bank Reconciliation December 31, 2013 Account #1234