Bank reconciliation statement

Part 2 The accountant of Jaycee Company was tasked to perform monthly bank reconciliation. She downloaded the company's May 31 bank statement that showed a balance of #32,400. She also printed the cash ledger from the company's computerized accounting system. It contains the ending balance of P8,350. She also found the following reconciling items: The bank statement showed bank service fee of #800 The bank collected $1,500 from a note receivable for Jaycee Company. A collection fee of $250 was charged. Deposit in transit $51,000. Checks outstanding on May 31, P79,100. The accountant found a check issued to Rein Corp. for #4,500 that cleared the bank but was not in the cash ledger. Required: Prepare a bank reconciliation statement