Reference no: EM133085679

Question - On July 31, 2028, Massive Ltd. had a cash balance of $6,793 in its general ledger. The bank statement from the Bank of Auditing on that date showed a balance of $6,578. A comparison of the bank statement with the Cash account revealed the following:

a. Cash receipts for July 31 recorded on the company's books were $3,500, but this amount does not appear on the bank statement.

b. A cheque of $5,100 made by another company was incorrectly deducted to Massive's account by the Bank of Auditing.

c. The bank statement included service charges and debit and credit card processing fees of $65.

d. Cheques outstanding on June 30 totaled $6,200. Of these, $4,600 worth cleared the bank in July. All cheques written in July cleared the bank in July.

e. The bank statement included electronic collections from customers on account totaling $8,800. Massive had not recorded the EFT.

f. Salaries of $4,800 were paid electronically during the month. The company has already recorded these.

g. An NSF cheque for $1,900 and a processing fee of $50 from a customer was returned with the statement.

Required - Prepare a bank reconciliation for Massive Ltd at July 31, 2028.