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.
Great question... View the full answer