Raceway Motor Sports Co. Bank Reconciliation Statement July 31, 20-- Task 2: Prepare a bank reconciliation statement for the Raceway Motor Sports Co. using the following information: | The Cash account balance in the company ledger is $3651.40. A deposit of $565 was recorded in the company journal, but not the bank statement. Attached to the bank statement is a debit memo for $85 for a customer's NSF cheque. Bank service charges of $11.40 are shown on the bank statement.
Raceway Motor Sports Co. Bank Reconciliation Statement July 31, 20-- Task 2: Prepare a bank reconciliation statement for the Raceway Motor Sports Co. using the following information: | The Cash account balance in the company ledger is $3651.40. A deposit of $565 was recorded in the company journal, but not the bank statement. Attached to the bank statement is a debit memo for $85 for a customer's NSF cheque. Bank service charges of $11.40 are shown on the bank statement.
College Accounting (Book Only): A Career Approach
13th Edition
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:Scott, Cathy J.
Chapter6: Bank Accounts, Cash Funds, And Internal Controls
Section: Chapter Questions
Problem 5DQ
Related questions
Question
pls answer this asap thanks. on excel or google sheets not on paper
Transcribed Image Text:Raceway Motor Sports Co. Bank Reconciliation Statement
July 31, 20--
Task 2: Prepare a bank reconciliation statement for the Raceway Motor Sports
Co. using the following information:
The Cash account balance in the company ledger is $3651.40.
A deposit of $565 was recorded in the company journal, but not the bank statement.
Attached
the bank statement is a debit memo for $85 for a customer's NSF cheque.
Bank service charges of $11.40 are shown on the bank statement.
Marks Breakdown
Mark
out of
Task 2- Correct Balance Inputted
/1
Task 2 - Deposit Put in Correct Spot
/1
Task 2 - Charges & Memos Correctly Inputted
12
Task 2 - Final Cash Balance is Correct
/1
Task 2 - All Numbers and Formatting Correct
12
Task Total
17
Worksheet Total
121
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage