Using the information below, prepare the Bank Reconciliation for the month of August. Be sure to show all supporting work. Outstanding Cheques from Month of July Bank Rec: $ Amt $500.00 Chq # 122 125 $725.00 Ledger Acct #101 - Conexus Credit Union Description 01-Aug-20 Beginning Balance 03-Aug-20 Chq #130 06-Aug-20 Chq #131 08-Aug-20 A/R Collected 22-Aug-20 Chq #132 28-Aug-20 Chq #133 31-Aug-20 A/R Collected Date DR CR Balance $15,000.00 $545.55 $14,454.45 $655.00 $13,799.45 $14,899.45 $797.40 $14,102.05 $400.00 $13,702.05 $14,202.05 | $1,100.00 $500.00 Bank Statement from Conexus Credit Union Description Deposit Withdrawal Balance Date 01-Aug-20 Beginning Balance 03-Aug-20 Chq #122 05-Aug-20 Chq #130 08-Aug-20 Deposit 20-Aug-20 NSF Cheq Adjustment 25-Aug-20 Chq #132 $16,225.00 $500.00 $15,725.00 $545.55 $15,179.45 $16,189.45 $200.00 $15,989.45 $997.40 $14,992.05 $1,010.00 Add'I Info: Chq #132 was properly recorded in the ledger, but the bank recorded the wrong amount. The cheque was to pay for Utilities Expense. The Aug 8, 2020 Deposit was correctly recorded by the bank, but was incorrectly recorded in the ledger. The deposit related to a payment from a customer named Ted. The Aug 20, 2020 NSF Cheque related to adjustment related to a customer (Sally) giving us a bum cheque. Required: A) Prepare Bank Reconciliation for the Month of August, 2020 B) Prepare the required adjusting Journal Entries as a result of the Bank Reconciliation
Using the information below, prepare the Bank Reconciliation for the month of August. Be sure to show all supporting work. Outstanding Cheques from Month of July Bank Rec: $ Amt $500.00 Chq # 122 125 $725.00 Ledger Acct #101 - Conexus Credit Union Description 01-Aug-20 Beginning Balance 03-Aug-20 Chq #130 06-Aug-20 Chq #131 08-Aug-20 A/R Collected 22-Aug-20 Chq #132 28-Aug-20 Chq #133 31-Aug-20 A/R Collected Date DR CR Balance $15,000.00 $545.55 $14,454.45 $655.00 $13,799.45 $14,899.45 $797.40 $14,102.05 $400.00 $13,702.05 $14,202.05 | $1,100.00 $500.00 Bank Statement from Conexus Credit Union Description Deposit Withdrawal Balance Date 01-Aug-20 Beginning Balance 03-Aug-20 Chq #122 05-Aug-20 Chq #130 08-Aug-20 Deposit 20-Aug-20 NSF Cheq Adjustment 25-Aug-20 Chq #132 $16,225.00 $500.00 $15,725.00 $545.55 $15,179.45 $16,189.45 $200.00 $15,989.45 $997.40 $14,992.05 $1,010.00 Add'I Info: Chq #132 was properly recorded in the ledger, but the bank recorded the wrong amount. The cheque was to pay for Utilities Expense. The Aug 8, 2020 Deposit was correctly recorded by the bank, but was incorrectly recorded in the ledger. The deposit related to a payment from a customer named Ted. The Aug 20, 2020 NSF Cheque related to adjustment related to a customer (Sally) giving us a bum cheque. Required: A) Prepare Bank Reconciliation for the Month of August, 2020 B) Prepare the required adjusting Journal Entries as a result of the Bank Reconciliation
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
7
Transcribed Image Text:Using the information below, prepare the Bank Reconciliation for the month of August. Be sure to show all
supporting work.
Outstanding Cheques from Month of July Bank Rec:
$ Amt
$500.00
Chq #
122
125
$725.00
Ledger Acct #101 - Conexus Credit Union
Description
01-Aug-20 Beginning Balance
03-Aug-20 Chq #130
06-Aug-20 Chq #131
08-Aug-20 A/R Collected
22-Aug-20 Chq #132
28-Aug-20 Chq #133
31-Aug-20 A/R Collected
Date
DR
CR
Balance
$15,000.00
$545.55 $14,454.45
$655.00 $13,799.45
$14,899.45
$1,100.00
$797.40 $14,102.05
$400.00 $13,702.05
$14,202.05
$500.00
Bank Statement from Conexus Credit Union
Description
Date
Deposit
withdrawal
Balance
01-Aug-20 Beginning Balance
03-Aug-20 Chq #122
05-Aug-20 Chq #130
$16,225.00
$500.00 $15,725.00
$545.55 $15,179.45
$16,189.45
08-Aug-20 Deposit
20-Aug-20 NSF Cheq Adjustment
25-Aug-20 Chq #132
$1,010.00
$200.00 $15,989.45
$997.40 $14,992.05
Add'I Info: Chq #132 was properly recorded in the ledger, but the bank recorded the wrong amount.
The cheque was to pay for Utilities Expense.
The Aug 8, 2020 Deposit was correctly recorded by the bank, but was incorrectly recorded
in the ledger. The deposit related to a payment from a customer named Ted.
The Aug 20, 2020 NSF Cheque related to adjustment related to a customer (Sally) giving us
a bum cheque.
Required:
A) Prepare Bank Reconciliation for the Month of August, 2020
B) Prepare the required adjusting Journal Entries as a result of the Bank Reconciliation
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education