Homework Help is Here – Start Your Trial Now!
Business
Accounting
AND COMPLETE BANK RECONCILIATION

AND COMPLETE BANK RECONCILIATION

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

PLEASE SHOW THE FORMULAS IN EXCEL

AND COMPLETE BANK RECONCILIATION

THE FORMAT IS IN THE BOTTOM PART

I WILL UPVOTE

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 USE EXCEL AND SHOW FORMULAS THANK YOU 48.25 Balance Bank statement balance $2 Adjusted statement balance 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
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 USE EXCEL AND SHOW FORMULAS THANK YOU 48.25 Balance Bank statement balance $2 Adjusted statement balance 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
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS