Instructions: Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement CHECKBOOK Check number 801 802 803 804 805 Date Description fo transaction 44835 H&H Jewelers 44840 Deposit 44842 L.L. Bean 44844 Cashe 44847 Deposit 44847 Four Seasons Hotel 44849 American Express 44854 ATM Withdrawal 44858 Deposit 44861 Deposit 44862 Home-Depot - Debit Card BANK STATEMENT Statement Date: Checking Account Summary: Account Number: Checking Account Transactions Date Amount Previous Balance Deposits Number Total Credits 879.36 3 44837 44840 44844 44847 44849 44851 44856 44858 44862 44864 BANK RECONCILIATION Check book balance Amount of payment or withdrawal Amount of deposit or interest Balance Forward 879.36 November 3, 2021 October 1-31, 2021 449-56-7792 Adjusted checkbook balance Description 236.77 Check # 801 450.75 Deposit 324.7 Returned item 880.34 EFT payroll deposit 75.89 Check #803 507.82 Check #805 1954.59 $ 120 ATM Withdrawal 623.5 Deposit 48.25 Debit card purchase 34.4 Check printing charge 7 236.77 Bank statement balance 47.2 75.89 Check Number Total Debits Current Balance 1347.83 1486.12 109 507.82 120 48.25 Balance Adjusted statement balance $2 642.59 1093.34 768.64 1648.98 1573.09 1065.27 945.27 1568.77 1520.52 1486.12 450.75 880.34 623.5 208.4
Instructions: Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement CHECKBOOK Check number 801 802 803 804 805 Date Description fo transaction 44835 H&H Jewelers 44840 Deposit 44842 L.L. Bean 44844 Cashe 44847 Deposit 44847 Four Seasons Hotel 44849 American Express 44854 ATM Withdrawal 44858 Deposit 44861 Deposit 44862 Home-Depot - Debit Card BANK STATEMENT Statement Date: Checking Account Summary: Account Number: Checking Account Transactions Date Amount Previous Balance Deposits Number Total Credits 879.36 3 44837 44840 44844 44847 44849 44851 44856 44858 44862 44864 BANK RECONCILIATION Check book balance Amount of payment or withdrawal Amount of deposit or interest Balance Forward 879.36 November 3, 2021 October 1-31, 2021 449-56-7792 Adjusted checkbook balance Description 236.77 Check # 801 450.75 Deposit 324.7 Returned item 880.34 EFT payroll deposit 75.89 Check #803 507.82 Check #805 1954.59 $ 120 ATM Withdrawal 623.5 Deposit 48.25 Debit card purchase 34.4 Check printing charge 7 236.77 Bank statement balance 47.2 75.89 Check Number Total Debits Current Balance 1347.83 1486.12 109 507.82 120 48.25 Balance Adjusted statement balance $2 642.59 1093.34 768.64 1648.98 1573.09 1065.27 945.27 1568.77 1520.52 1486.12 450.75 880.34 623.5 208.4
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Instructions:
Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement
CHECKBOOK
Check number
801
802
803
804
805
Date Description fo transaction
44835 H&H Jewelers
44840 Deposit
44842 L.L. Bean
44844 Cashe
44847 Deposit
44847 Four Seasons Hotel
44849 American Express
44854 ATM Withdrawal
44858 Deposit
44861 Deposit
44862 Home-Depot - Debit Card
BANK STATEMENT
Statement Date:
Checking Account Summary:
Account Number:
Checking Account Transactions
Date
Amount
44837
44840
44844
44847
44849
44851
44856
44858
44862
44864
BANK RECONCILIATION
Check book balance.
Amount of payment or withdrawal Amount of deposit or interest Balance Forward
879.36
November 3, 2021
October 1- 31, 2021
449-56-7792
Previous Balance Deposits Number Total Credits ✓ Check Number Total Debits Current Balance →
879.36
3
1954.59
7
1347.83
1486.12
Description
236.77 Check # 801
450.75 Deposit
324.7 Returned item
880.34 EFT payroll deposit
75.89 Check #803
507.82 Check #805
Adjusted checkbook balance
120 ATM Withdrawal
623.5 Deposit
48.25 Debit card purchase
34.4 Check printing charge
$
236.77
47.2
75.89
109
507.82
120
48.25
Balance
642.59
1093.34
768.64
1648.98
1573.09
1065.27
945.27
1568.77
1520.52
1486.12
Bank statement balance $2
Adjusted statement balance
450.75
USE EXCEL AND SHOW FORMULAS THANK YOU I WILL UPVOTE
880.34
623.5
208.4
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 1 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