need help asap

Lightning Corporation's bank statement shows a balance of $7870 on May 31. Its general ledger shows a cash balance of $7660 on May 31. Outstanding checks on May 31 totaled $1,710. The bank statement dated May 31 shows an NSF check for $200 and a service fee of $70, which were not yet recorded by Lightning Corporation. Deposits in transit at May 31 totaled 1,230. ho Prepare a bank reconciliation to calculate the correct ending balance of cash on May 31. LIGHTNING CORPORATION Bank Reconciliation May 31 Bank's Cash Balance Company's Cash Balance