Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 1

PROBLEM DATA
Skye Boats deposits all receipts in a night depository after banking hours. The data needed to reconcile the bank statement as of October 31, 2011, have been extracted from records and are as follows:


REQUIREMENT
As treasurer, you have been asked to prepare a bank reconciliation statement as of October 31. Review the file called BANKREC that follows these requirements. The bank reconciliation as of September 30 is provided for you as a sample completed worksheet. You may need to refer to the September 30 bank reconciliation for information on outstanding checks.