View the step-by-step solution to:

Divine Catering Cash Activity Statement As of December 31, 2013 Account Number: 1000 Account Name:

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 Name Memo Amount Beginning Balance 239,645.06 12/1/2013 ACH Chase Mastercard November credit card -5,984.27 12/3/2013 200036 Tempe Chamber of Commerce Provided catering services 2,250.75 12/7/2013 1370 Arizona Public Service Utilities December utilities -175.50 12/8/2013 1371 Goodwin Real Estate Monthly lease payment -7,000.00 12/11/2013 5500036 ASU Extension Services Provided catering services 4,400.00 12/13/2013 1372 AT&T November phone bill -75.00 12/15/2013 ACH State of Arizona November sales tax -2,958.72 12/19/2013 Transfer Payroll account Salaries -2,788.25 12/20/2013 ACH ASU-President's Office Graduation Banquet Catering 12,050.00 12/23/2013 ACH Sysco Foods Inventory purchase -7,000.00 12/24/2013 110035 Watson & Watson Attorneys Holiday reception catering 572.29 12/28/2013 1373 Cox Communication Internet & Cable -99.99 Ending Balance 232,836.37
Background image of page 1
Activity Summary Ending Balance as of 11/30/2013 $234,227.43 Deposits or Additions $27,151.31 Withdrawals or Subtractions ($26,439.67) Ending Balance as of 12/31/2013 $234,939.07 Transactions Date Description Posted Transactions 12/1/2013 Deposit #188542239 $8,450.56 12/1/2013 Check #1365 $106.38 12/2/2013 Chase Mastercard ACH #330 $5,984.27 12/5/2013 Check #1367 $426.55 12/13/2013 Deposit #188542240 $6,650.75 12/15/2013 State of Arizona ACH #331 $2,958.72 12/19/2013 Transfer to account #1235 $2,788.25 12/20/2013 Check #1371 $7,000.00 12/20/2013 ACH Deposit ASU $12,050.00 12/23/2013 Check #1370 $175.50 12/24/2013 Sysco Foods ACH #332 $7,000.00 Totals $27,151.31 $26,439.67 Deposits or Additions Withdrawals or Subtractions
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Great question... View the full answer

EHT.xls

Bank Reconciliation Statement
Decmber 31, 2013.
Balance per Bank Statemnent
Deposits in Transit
Outstanding Checks
True Cash Balance
Deposit in Transit
Total DIT 234,939,07
572.29
-2,674.99...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online