You may use the attached spreadsheet to complete this activity. You will find the spreadsheet by clicking on the paper clip found in the upper left hand corner of the screen.
Pacific Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account.