FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Bank reconciliation and entries
Instructions
Chart of Accounts
Amount Descriptions
Bank Reconciliation
Journal
Final Questions
X
Instructions
Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 20Y2, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account.
CASH ACCOUNT: | |
Balance as of June 1 | $9,317.40 |
CASH RECEIPTS FOR MONTH OF JUNE | 9,223.76 |
DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June:
Date
|
Amount
|
|
Date
|
Amount
|
|
Date
|
Amount
|
June 1 | $1,080.50 | June 10 | $996.61 | June 22 | $897.34 | ||
3 | 854.17 | 15 | 882.95 | 24 | 947.21 | ||
8 | 840.50 | 17 | 1,606.74 | 30 | 1,117.74 |
CHECKS WRITTEN: Number and amount of each check issued in June:
Check No.
|
Amount
|
|
Check No.
|
Amount
|
|
Check No.
|
Amount
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
740 | $237.50 | 747 | Void | 754 | $449.75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
741 | 495.15 | 748 | $450.90 | 755 | 272.75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
742 | 501.90 | 749 | 640.13 | 756 | 113.95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
743 | 761.30 | 750 | 276.77 | 757 | 407.95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
744 | 506.88 | 751 | 299.37 | 758 | 259.60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
745 | 117.25 | 752 | 537.01 | 759 | 901.50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
746 | 298.66 | 753 | 380.95 | 760 | 486.39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total amount of checks issued in June: $8,395.66
BANK RECONCILIATION FOR PRECEDING MONTH:
Refer to the June Bank Statement.
X
Chart of Accounts
|
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 nowThis is a popular solution!
Step by stepSolved in 4 steps with 2 images
Knowledge Booster
Similar questions
- Hills Company's June 30 bank statement and the June ledger account for cash BANK STATEMENT Checks Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 June 1 June June 30 Debit Balance Deposits Balance E5-5 (Static) Part 1 $ 19,100 Cash (A) 6,800 19,000 6,400 Deposits $ 18,000 Credit 19,400 Checks written Other $ 30 June Balance $ 7,200 25,200 6,100 6,070 6,070 Required: 1. Prepare a bank reconciliation A comparison of the checks written with the checks that have cleared the bank shows outstanding checks of $700. Some of the checks that cleared in June were written prior to June. No deposits in transit were noted in May, but a deposit is in transit at the end of Junearrow_forwardSal's Surf Shop deposits all receipts in the bank and makes all payments by check. On July 31 the cash account had a balance of $6,105.42. The bank statement on July 31 reported a balance of $4,146.46. Upon comparing the bank statement to the books, the following items were found. а. A bank debit memo issued for an NSF check from a customer of $21.25. b. A bank credit memo issued for interest of $8.50 earned during the month. С. During the evening of July 31, a deposit of $1,948.25 was made, which is not shown on the bank statement. d. A bank debit memo issued for $18.50 for bank service charges. е. Checks for the amounts of $34.00, $17.85, and $93.25 were written during July but have not yet been received by the bank. f. The reconciliation from the previous month, June, showed outstanding checks of $260.80. One of these checks in the amount of $7.38 has not yet been received by the bank. g. After comparing the canceled checks to the bank statement, it was discovered that a check…arrow_forwardBank reconciliation and entries Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproducedmas follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of June 1 $9,317.40 CASH RECEIPTS FOR MONTH OF JUNE $9,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Beeler Furniture Company Bank Reconciliation May 31 20Y2 Cash balance according to bank statement $ 9,447.20 Add deposit for May 31, not recorded by bank 690.25 Deduct outstanding checks: No. 731 $162.15 736 345.95 738 251.40 739 60.55 820.05 Adjusted balance $ 9,317.40 Cash balance according to company's records $ 9,352.50 Deduct bank service charges 35.10…arrow_forward
- In the process of reconciling its bank statement for April, Donahue Enterprises' accountant compiles the following information: Cash balance per company books on April 30 Deposits in transit at month-end Outstanding checks at month-end Bank charge Note collected by bank on Donahue's behalf A check paid to Donahue during the month by a customer is returned by the bank as NSF The adjusted cash balance per the books on April 30 is: $6,275 $1,300 $ 620 $ 45 $770 $ 480arrow_forwardHelp with Correct Answerarrow_forwardBased on the information in the worksheet, Calculate: February Deposits in Transit: Date Amount February Outstanding Checks: Check # Amountarrow_forward
- Hello tutor please help me with this Questionarrow_forwardThe phone data where accumulated for use and reconciling the bank account of Mathers Co. For July: 1. Cash balance according to the company's records at July 31st $18,310. 2. Cash balance according to the bank statement at July 31st, $19,360. 3. Checks outstanding, $3,720. 4 . Deposit in transit, not recorded by Bank $2,980. 5. A check for $480 in payment of an account was erroneously record it in the check register as $840. 6. Bank debit memo for service charges, $50. A. Prepare a bank reconciliation, using the format showing in exhibit 14 Mather Co. Bank Reconciliation July 31 ___________________________________________ Cash balance according to bank statement $ _______ _______ ______ Adjusted balance. $_____ Cash balance according to companies records $ ___ ________ ________ Adjusted balance.…arrow_forwardThe bank statement for Jeffrey Co. indicates a balance of $8,785 on October 31. After the journals for October had been posted, the cash account had a balance of $8,998. a. Cash sales of $945 had been erroneously recorded in the cash receipts journal as $495. b. Deposits in transit not recorded by bank, $778. c. Bank debit memo for service charges, $40. d. Bank credit memo for note collected by bank, $23,985 plus $885 interest. e. Bank debit memo for $756 NSF (not sufficient funds) check from Calin Sams, a customer. f. Checks outstanding, $1,860. Record the appropriate journal entries that would be necessary for Jeffrey Co. Record the entry that increases cash first. If an amount box does not require an entry, leave it blank.arrow_forward
- Bank reconciliation and entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours.The data required to reconcile the bank statement as of July 31, 20Y0, have been taken from various documents and records and are reproduced as follows.The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of July 1 $9,578.00 CASH RECEIPTS FOR MONTH OF JULY 6,465.42 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in July: Date Amount Date Amount Date Amount July 2 $569.50 July 12 $580.70 July 23 $713.45 5 701.80 16 600.10 26 601.50 9 819.24 19 701.26 31 1,777.87 CHECKS WRITTEN: Number and amount of each check issued in July: BANK RECONCILIATION FOR PRECEDING MONTH: Sunshine Interiors Bank Reconciliation June 30,20Y0 Cash balance according to bank statement $9,422.80…arrow_forwardHow do I journalize this in the genral journal, what accounts would I use?arrow_forwardBank Reconciliation and Related Journal Entries The book balance in the checking account of Lyle's Salon as of November 30 is $3,337.11. The bank statement shows an ending balance of $2,136.00. By examining last month's bank reconciliation, comparing the deposits and checks written per books and per bank in November, and noting the service charges and other debit and credit memos shown on the bank statement, the following were found: An ATM withdrawal of $153.00 on November 18 by Lyle for personal use was not recorded on the books. A bank debit memo issued for an NSF check from a customer of $19.40. A bank credit memo issued for interest of $19.00 earned during the month. On November 30, a deposit of $1,201.00 was made, which is not shown on the bank statement. A bank debit memo issued for $18.00 for bank service charges. Checks No. 549, 561, and 562 for the amounts of $167.00, $23.00, and $9.60, respectively, were written during November but have not yet been received by the bank.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
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