ETA 2020 Part 2 - Compatibility Mode - Word References Mailings Review View Help Table Design Layout label ABC ABC AaBbcc AaBb C Bbccbe to Caption Normal 1 No Spac. Heading 1 Title Subtitle Suur Matagal Styles November 31, 2020: Preparation of November Bank Reconciliation: The golf course received the bank statement for November 2020 from its bank during the first week of November 2020 You need to prepare the bank reconciliation for November by reconciling the cash balance shown on the bank statement with the unadjusted cash balance in the general ledger cash account The bank statement at November 30, 2020 showed the cash balance was $449,636 The general ledger showed the unadjusted cash balance in the general ledger cash account at November 30, 2020 was $452.966 (Use the Bank Reconciliation tab of the Excel workbook) An examination of the bank statement disclosed the following: 1. Outstanding checks totaled 5825 2. The bank had issued a $600 debit memo for three insufficient funds (NSF) checks 3. The bank statement enclosures included a debit memo for $25 that had been deducted from the Idylwild Country Club account to pay for service charges Record the $25 charge to Bank Service Charges in the general ledger 4. The bank statement showed a check was written for $400. The check register showed that Idylwild Country Club had correctly recorded the check as $40. The bank made an error and has been contacted. The check was written for Golf Course Maintenance Expense 5. Deposits in transit were $3.190 LL November 31, 2020: Preparation of November Bank Reconciliation: The golf course received the bank statement for November 2020 from its bank during the first week of November 2020. You need to prepare the bank reconciliation for November by reconciling the cash balance shown on the bank statement with the unadjusted cash balance in the general ledger cash account The bank statement at November 30, 2020 showed the cash balance was $449,636. The general ledger showed the unadjusted cash balance in the general ledger cash account at November 30, 2020 was $452,986. (Use the Bank Reconciliation tab of the Excel workbook) An examination of the bank statement disclosed the following: 1. Outstanding checks totaled $825 2. The bank had issued a $600 debit memo for three insufficient funds (NSF) checks 3. The bank statement enclosures included a debit memo for $25 that had been deducted from the Idylwild Country Club account to pay for service charges. Record the $25 charge to Bank Service Charges in the general ledger, 4. The bank statement showed a check was written for $400. The check register showed that Idylwild Country Club had correctly recorded the check as $40. The bank made an error and has been contacted. The check was written for Golf Course Maintenance Expense. 5. Deposits in transit were $3.190