Accounting HW - Bank Reconciliation

profilekevin
case_1.docx
Home>Business & Finance homework help>Accounting homework help>Accounting HW - Bank Reconciliation

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.)