Ex 2: Bank reconcilation

1. Fliteboard company has a bank balance of $3,070 and a book balance of $4,095. Q 2. Monthly bank service charge $10 3. A NSF Check $700 4. Deposit in transit $2,400 5. Two Outstanding checks check no. 501 $500 and check no. 505 $900 6. Bank collection of note receivable $1,000 7. Interest Revenue earned on bank balance $15 8. EFT for rent expense $330 Refer to the formula to perform the bank reconciliation: Internal Control - Bank Reconciliation

the first photo is the question and the second one is how i need it to be done

Ex 2: Bank reconcilation 1. Fliteboard company has a bank balance of $3,070 and a book balance of $4,095. 2. Monthly bank service charge $10 3. A NSF Check $700 4. Deposit in transit $2,400 5. Two Outstanding checks : check no. 501$500 and check no. 505$900 6. Bank collection of note receivable $1,000 7. Interest Revenue earned on bank balance $15 8. EFT for rent expense $330 Refer to the formula to perform the bank reconciliation