On July 31, Sheridan Ltd. had a cash balance of $18,630 in its general ledger. The bank statement from the Caisse Populaire on that date showed a balance of $31,376. A comparison of the bank statement with the Cash account revealed the following: 1. 2 3 The bank statement included service charges and debit and credit card processing fees of $164, The bank statement included electronic collections from customers on account totalling $7,570. Sheridan had not recorded the EFT. A deposit of $4.450 made by another company was incorrectly added to Sheridan's account by the Caisse Populaire. Salaries of $6,020 were paid electronically during the month. The company has already recorded these. Cheques outstanding on June 30 totalled $3,980. Of these, 53.090 worth cleared the bank in July, All cheques written in July cleared the bank in July, 4. 5. On July 31, Sheridan Ltd. had a cash balance of $18,630 in its general ledger. The bank statement from the Caisse Populaire on that date showed a balance of $31,376. A comparison of the bank statement with the Cash account revealed the following: 1 2 3 The bank statement included service charges and debit and credit card processing fees of $164. The bank statement included electronic collections from customers on account totalling $7.570. Sheridan had not recorded the EFT. A deposit of $4,450 made by another company y has incorrectly added to Sheridan's account by the Caisse Populaire. Salaries of 56.020 were paid electronically during the month. The company has already recorded these, Cheques outstanding on June 30 totalled $3.980. Of these, 53,090 worth cleared the bank in July. All cheques written in July cleared the bank in July 4 S Prepare the bank reconciliation at July 32. (List items that increase balance as per bank & books first) Prepare any journal entries required from the reconciliation. (List all debit entries before credit entries. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry* for the account titles and enter for the amounts.) Date Account Titles and Explanation Debit Credit July 31 (To record EFT collections) 31 (To record bank service charge)