Data table Date Check No. Item Check Deposit Balance 11/1 $ 1,500 5 922 Karter Kitchen $ 22 22 1,478 10 Dividends received $ 270 1,748 14 923 Numero Products 31 1,717 15 924 Filna (payment on account) 63 1,654 19 925 Cash 188 1,466 27 926 Office Max 170 1,296 28 927 Reliant Properties 527 769 29 Monthly Sales 4,225 4,994 Data table Bal, Nov 1 Deposits: Checks: No. Amount 922 $ 22 923 31 924 73* 925 188 Other charges: Printed checks Service charge $ 13 20 20 $ 1,500 270 (314) (33) Bal, Nov 30 *This amount is correct for check no. 924. $ 1,423 Cole's Produce, Inc.'s checkbook lists the following: (Click the icon to view the checkbook.) Cole's Produce, Inc.'s November bank statement shows the following: (Click the icon to view the November bank statement.) Read the requirements. Requirement 1. Prepare Cole's Produce, Inc.'s bank reconciliation on November 30, 2018. How much cash does Cole's Produce actually have on November 30? Start by preparing the bank portion of the reconciliation and then complete the reconciliation by completing the book portion. (If a box is not used in the table leave the box empty; do not select a label or enter a zero.) Balance, November 30 Add: Less: BANK Cole's Produce, Inc. Bank Reconciliation November 30, 2018 Adjusted bank balance, November 30 Cole's Produce, Inc. has cash of on November 30. Balance, November 30 Add: Less: BOOKS Adjusted book balance, November 30 Requirement 2. Prepare all necessary journal entries for Cole's Produce, Inc., to update the Cash account as a result of the bank reconciliation. (Record debits first, then credits. Exclude explanations from any journal entries.) Start by recording the entry for the correction of the book error. Date Nov 30 Journal Entry Accounts Record the entry for the cost of checks. Date Nov 30 Debit Credit Journal Entry Accounts Debit Credit Record the entry for the service charge. Record the entry for the service charge. Date Nov 30 Journal Entry Accounts Debit Credit