Shamara Systems most recently reconciled its bank balance on April 30 and reported two checks outstanding at that time, No. 1771 for \(781 and No. 1780 for \)1,425.90. The following information is available for its May 31, 2017, reconciliation
From the May 31 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE CHECKS AND DEBITS DEPOSITS AND CREDITS 18,290.70 Date 05/01 1771 05/04 No. Amount Date Amount 13,094.80 16,566.80 21,762.70 05/02 1783 05/14 05/04 1782 05/22 1784 05/18 05/26 05/11 05/25 05/25 1787 05/26 1785 05/29 1788 05/31 2,438.00 2,898.00 1,801.80 2,079.00 7,350.00 CM 781.00 382.50 1,285.50 431.80 NSF 8,032.50 63.90 654.00 14.00 SC
From Shamara Systems’s Accounting Records Cash Receipts Deposited Cash Date Debit May 4 2,438.00 14 2,898.00 22 1,801.80 26 2,079.00 31 2,727.30 11,944.10 Cash Disbursements Check Cash No. Credit 1782 1,285.50 1783 382.50 1784 1,449.60 1785 63.90 1786 353.10 1787 8,032.50 1788 644.00 1789 639.50 12,850.60 Cash Acct. No. 101 Date Explanation PR Debit Credit Balance Apr. 30 Balance 16,083.80 May 31 Total receipts R7 11,944.10 28,027.90 31 Total disbursements D8 12,850.60 15,177.30
Additional Information
Check No. 1788 is correctly drawn for \(654 to pay for May utilities; however, the recordkeeper misread the amount and entered it in the accounting records with a debit to Utilities Expense and a credit to Cash for \)644. The bank paid and deducted the correct amount. The NSF check shown in the statement was originally received from a customer, W. Sox, in payment of her account. The company has not yet recorded its return. The credit memorandum (CM) is from a \(7,400 note that the bank collected for the company. The bank deducted a \)50 collection expense and deposited the remainder in the company’s account. The collection and expense have not yet been recorded.
Required
1. Prepare the May 31, 2017, bank reconciliation for Shamara Systems.
