like this form

On May 31, 2019, XYZ company had a cash balance per books of $10,345. The bank statement from New York State Bank on that date showed a balance of $12,453. A comparison of the statement with the cash account revealed the following: 1. On May 31, the bank statement showed an NSF charge of $324 for a check issued by Sally Aniston, a customer, to XYZ company on account 2. On May 12, the company issued check no. 542 for $345 to Michael Smith on account. The check which cleared the bank in May, was incorrectly journalized and posted by XYZ company for $365 3. May 31 deposits of $298 (Received by bank on June 1). 4. Cash sales of $327 on May 8 were deposited in the bank. The cash receipts journal entry and the deposit slip were incorrectly made for $372. The bank credited XYZ company for the correct amount 5. The statement included a debit memo of $15 for the printing of additional company checks 6. A $1,200 note receivable was collected by the bank for XYZ Company on May 31 plus $50 interest. The bank charged a collection fee of $27. No interest has been accrued on the note 7. Outstanding checks on May 31 totalled $589 8. Included with the cancelled checks was a check (totalled $958) issued by John Park (a customer) to Yummy Sweets company for services provided. The bank deposited the money to XYZ company account Laird Company Bank Reconciliation April 30, 2017 Cash balance per bank statement Add: Deposits in transit $15,907.45 2,201.40 18,108.85 Less: outstanding checks No. 453 No. 457 No. 460 Adjusted cash balance per bank $3,000.00 1,401.30 1,502.70 5,904.00 $12,204.85 Cash balance per books $11,589.45 Add: Collection of notes receivable $1,000, plus interest earned $50, less collection fee $15 Error in recording check no. 443 $1,035.00 36.00 1,071.00 12,660.45 Less: NSF check Bank service charge Adjusted cash balance per books 425.60 30.00 455.60 $12,204.85