Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
bartleby

Concept explainers

Question
Book Icon
Chapter 5, Problem 1R
To determine

Prepare bank reconciliation statement as of October 31 on worksheet.

Expert Solution & Answer
Check Mark

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 5, Problem 1R

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Haverman Company maintains a checking account at the Commerce Bank. At July 31, selected data from the ledger balance and the bank statement are shown below.           Per Books Per Bank Balance, July 1 $17,600 $16,800 July receipts 81,400   July credits   82,470 July disbursements 77,150   July debits   74,756 Balance, July 31 $21,850 $24,514         Analysis of the bank data reveals that the credits consist of $79,000 of July deposits and a credit memorandum of $3,470 for the collection of a $3,400 note plus interest revenue of $70. The July debits per bank consist of checks cleared $74,700 and a debit memorandum of $56 for printer additional company checks. You also discover the following errors involving July checks: (1) A check for $230 to a creditor on an account that cleared the bank in July was journalized and posted as $320. (2) A salary check to an…
On October 1, Jessica Clay received her bank statement showing a balance of $374.52.Her checkbook records indicate a balance of $338.97. There was a service charge for themonth of $4.40 on the statement. The outstanding checks were for $47.10, $110.15, $19.80,and $64.10. The deposits in transit totaled $125.50. There was a $75.70 debit for automaticpayment of her telephone bill. Use the following form to reconcile Jessica's checking account.Debits Checks OutstandingAmount AmountSvc. Chg.Total TotalCHECKBOOK BALANCE STATEMENT BALANCEAdd: Interest & Other Credits Add: Deposits in TransitSUB TOTAL SUB TOTALDeduct: Service Charges & Other Debits Deduct: Outstanding ChecksADJUSTED CHECK BOOK BALANCE ADJUSTED STATEMENT BALANCE
The book balance in the checking account of Kyri Enterprises as of November 30 is $2,964. The bank statement shows an ending balance of $2,525. The following information is discovered by (1) comparing last month’s deposits in transit and outstanding checks with this month’s bank statement, (2) comparing deposits and checks written per books and per bank in the current month, and (3) noting service charges and other debit and credit memos shown on the bank statement. Deposits in transit: 11/29 $125   11/30 200 Outstanding checks: No. 322 17   No. 324 105   No. 327 54 Unrecorded ATM withdrawal:*   100 Bank service charge:   25 NSF check:   185   Error on Check No. 321 Checkbook shows it was for $64, but it was actually written for $44. Accounts Payable was debited.   *Funds were withdrawn by Susan Kyri for personal use.     Kyri Enterprises Bank Reconciliation November 30, 20-- 1 Bank statement balance, November 30     2…

Chapter 5 Solutions

Excel Applications for Accounting Principles

Knowledge Booster
Background pattern image
Accounting
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Text book image
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Text book image
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,