Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ETA 2020 Part 2 - Compatibility Mode - Word References Mailings Review View Help Table Design Layout label ABC ABC AaBbcc AaBb C Bbccbe to

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Building Accounting Systems Using Access 2010

Authors: James Perry, Richard Newmark

8th Edition

1111530998, 978-1111530990

More Books

Students also viewed these Accounting questions