Excel Communications had a computer failure on August 1, 2017, which resulted in the loss of data,
Question:
a. An examination showed that two cheques (#461 for $645.00 and #492 for $225.00) had not been cashed as of August 1. Eyers recalled that there was only one deposit in transit on the July 31 bank reconciliation, but was unable to recall the amount.
b. The cash receipts and cash payments journal contained the following entries for August 2017:
c. The bank provided the following statement as of August 31, 2017:
d. The deposit made on August 16 was for the collection of a note receivable ($540.00) plus interest.
e. The EFTs had not yet been recorded by Excel Communications since the bank statement was the first notification of them.
¢ The August 17 EFT was for the monthly payment on an insurance policy for Excel Communications.
¢ The August 19 and 24 EFTs were collections on accounts receivable.
¢ The August 22 EFT was in error-the transfer should have been to Accel Communications.
f. The NSF cheque on August 26 was received from a customer as payment of $1,792.50 for installation of a satellite purchased from Excel.
g. Cheque #504 was correctly written for $860.00 for the purchase of inventory (assume a perpetual system), but incorrectly recorded by the cash payments clerk.
Required
1. Prepare a bank reconciliation as of August 31, 2017, including the calculation of the book balance of August 31, 2017.
2. Prepare all journal entries that would be required by the bank reconciliation.
Step by Step Answer:
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo Ann L. Johnston, Peter R. Norwood