Wonderland Inc. has introduced new accounting software and have been facing lot of challenges with reconciling its bank statement and have asked you to help them to identify the differences between bank balance and the bank statement. Wonderland bank with DB Bank (DB) and is wondering if bank statement reflect accurate information. Following are the details for the month of July 2021  Balance as per DB as at July 31st was $103,220  Cheque amounting to $5,579 was issued to Carry over Corp on 28th July which was not presented to the bank  Cheque amounting to $2,425 was received on 30th July 2021 which was deposited in the bank on July 31st, cashier confirmed that the cheque was deposited before the closing hours but bank statement did not have deposit of this amount  Surex Ltd issued the cheque amounting to $1,998 and $3,593 that were deposited on July 31st. cheque were not recorded by the bank  The below two cheques were issued to Matra Inc. but were still outstanding Chq Date Issued Amount 10009 11-Jun $10,040 9994 2-Mar $9,514  Unrecorded receipts at the end of the months were as below P a g e 8 | 9 Customer details Payment details Amount Drinkit EFT on July 11th $1,872 Greycam EFT on July 18th $3,400  EFT made to Ravel Corp on July 31st for $6,512, bank statement for July did not have this amount  Cheque written on 16th July to Salvation for $2,780 was still outstanding, cheque #10112  The below two cheques were deposited but not recorded by bank Customer details Chq Amount IT Systems 002254 $1,517 True care 12229 $2,980  Accountant forgot to record the below electronic fund transfers from the customers Customer details Payment details Amount Freeflow Corp EFT on 30th July $2,525 Try it EFT on 31st July $3,350 Honda Trans EFT on 31st July $3,351  Cheque amounting to $807 was issued to Letapis (chq #10091 Dt 1st July) was incorrectly entered in cash payment as $708  Below three cheques were returned by bank due to non-sufficient funds Customer details Chq Amount PlayB 988 $1,444 Devinde Inc 477 $2,050 Crazt Corp 1125 2966  Finally there were bank service charges for the month which were not recorded in cash book, $325  Balance as per Cash account as at July 31st was $69,325 Required  Prepare bank reconciliation for the month of July  Pass necessary Journal entries to record the results of the bank reconciliation

Financial Accounting
14th Edition
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Carl Warren, Jim Reeve, Jonathan Duchac
Chapter8: Sarbanes-oxley, Internal Control, And Cash
Section: Chapter Questions
Problem 18E
icon
Related questions
Question

Wonderland Inc. has introduced new accounting software and have been facing lot of challenges
with reconciling its bank statement and have asked you to help them to identify the differences
between bank balance and the bank statement.
Wonderland bank with DB Bank (DB) and is wondering if bank statement reflect accurate
information.
Following are the details for the month of July 2021
 Balance as per DB as at July 31st was $103,220
 Cheque amounting to $5,579 was issued to Carry over Corp on 28th July which was not
presented to the bank
 Cheque amounting to $2,425 was received on 30th July 2021 which was deposited in the
bank on July 31st, cashier confirmed that the cheque was deposited before the closing
hours but bank statement did not have deposit of this amount
 Surex Ltd issued the cheque amounting to $1,998 and $3,593 that were deposited on July
31st. cheque were not recorded by the bank
 The below two cheques were issued to Matra Inc. but were still outstanding
Chq Date Issued Amount
10009 11-Jun $10,040
9994 2-Mar $9,514
 Unrecorded receipts at the end of the months were as below
P a g e 8 | 9
Customer details Payment details Amount
Drinkit EFT on July 11th $1,872
Greycam EFT on July 18th $3,400
 EFT made to Ravel Corp on July 31st for $6,512, bank statement for July did not have this
amount
 Cheque written on 16th July to Salvation for $2,780 was still outstanding, cheque #10112
 The below two cheques were deposited but not recorded by bank
Customer details Chq Amount
IT Systems 002254 $1,517
True care 12229 $2,980
 Accountant forgot to record the below electronic fund transfers from the customers
Customer details Payment details Amount
Freeflow Corp EFT on 30th July $2,525
Try it EFT on 31st July $3,350
Honda Trans EFT on 31st July $3,351
 Cheque amounting to $807 was issued to Letapis (chq #10091 Dt 1st July) was incorrectly
entered in cash payment as $708
 Below three cheques were returned by bank due to non-sufficient funds
Customer details Chq Amount
PlayB 988 $1,444
Devinde Inc 477 $2,050
Crazt Corp 1125 2966
 Finally there were bank service charges for the month which were not recorded in cash
book
, $325
 Balance as per Cash account as at July 31st was $69,325
Required
 Prepare bank reconciliation for the month of July
 Pass necessary Journal entries to record the results of the bank reconciliation

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Bank reconciliation statement
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.
Similar questions
Recommended textbooks for you
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning