The following information relates to the bank account of Doug's Sky Diving Supply Store on June 30. Balance per bank statement $5,327 Balance per books as of June 30 9,265 Outstanding checks: #1007 $ 241 #1008 67 #1009 597 Deposits in transit 229 4,111 Bank service charges 98 NSF check 412 Credit memo for interest earned 16 Error: Check written and recorded by bank as $454 was subtracted from the checkbook as $445. The check was used to pay the telephone bill. Required: Prepare a bank reconciliation as of June 30.
The following information relates to the bank account of Doug's Sky Diving Supply Store on June 30. Balance per bank statement $5,327 Balance per books as of June 30 9,265 Outstanding checks: #1007 $ 241 #1008 67 #1009 597 Deposits in transit 229 4,111 Bank service charges 98 NSF check 412 Credit memo for interest earned 16 Error: Check written and recorded by bank as $454 was subtracted from the checkbook as $445. The check was used to pay the telephone bill. Required: Prepare a bank reconciliation as of June 30.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter5: Bank Reconciliation (bankrec)
Section: Chapter Questions
Problem 2R
Related questions
Question
The following information relates to the bank account of Doug's Sky Diving Supply Store on June 30.
Balance per bank statement | $5,327 | |
Balance per books as of June 30 | 9,265 | |
Outstanding checks: | ||
#1007 | $ 241 | |
#1008 | 67 | |
#1009 | 597 | |
Deposits in transit | 229 | |
4,111 | ||
Bank service charges | 98 | |
NSF check | 412 | |
Credit memo for interest earned | 16 |
Error: Check written and recorded by bank as $454 was subtracted from the checkbook as $445. The check was used to pay the telephone bill.
Required:
Prepare a bank reconciliation as of June 30.
Doug's Sky Diving Supply Store | ||
Bank Reconciliation | ||
June 30, 20-- | ||
Bank statement balance | $fill in the blank 1 | |
Deduct deposits in transit: | $fill in the blank 3 | |
fill in the blank 4 | fill in the blank 5 | |
$fill in the blank 6 | ||
$fill in the blank 9 | ||
fill in the blank 11 | ||
fill in the blank 13 | fill in the blank 14 | |
Adjusted bank balance | $fill in the blank 15 | |
Book balance | $fill in the blank 16 | |
fill in the blank 18 | ||
$fill in the blank 19 | ||
$fill in the blank 22 | ||
fill in the blank 24 | ||
fill in the blank 26 | fill in the blank 27 | |
Adjusted book balance | $fill in the blank 28 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage