FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
The following data were accumulated for use in reconciling the bank account of Mathers Co. for July:
- Cash balance according to the company's records at July 31, $32,110.
- Cash balance according to the bank statement at July 31, $31,350.
- Checks outstanding, $2,870.
- Deposit in transit, not recorded by bank, $4,150.
- A check for $170 in payment of an account was erroneously recorded in the check register as $710.
- Bank debit memo for service charges, $20.
a. Prepare a bank reconciliation, using the format shown in Exhibit 14.
Mathers Co. | |
Bank Reconciliation | |
July 31 | |
Cash balance according to bank statement | $ |
Add deposit in transit, not recorded by bank | |
Deduct outstanding checks | |
Adjusted balance | $ |
Cash balance according to company's records | $ |
Add error in recording check as $710 instead of $170 | |
Deduct bank service charge | |
Adjusted balance | $ |
a. Set up two columns: one for the company cash account section and the other for the bank balance section. Determine the effect of the data on each column. Recall that when you are finished, the adjusted balances in the bank and company sections of the reconciliation must be equal. If not, an item has been overlooked or treated in error.
b. If the
$
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 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.Similar questions
- The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $93,115. The bank statement indicated a balance of $125,800 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $30,080. b. A deposit of $19,240, representing receipts of June 30, had been made too late to appear on the bank statement. c. The bank collected $24,075 on a $2,500 note, including interest of $1,575. d. A check for $1,800 returned with the statement had been incorrectly recorded by Pala Medical Co. as $180. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. e. A check drawn for $390 had been erroneously charged by the bank as $930. f. Bank service charges for June amounted to $50. Instructions 1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for…arrow_forwardThe following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $14,720. Cash balance according to the bank statement at July 31, $15,730. Checks outstanding, $2,990. Deposit in transit, not recorded by bank, $2,400. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $30. a. Prepare a bank reconciliation, using the format shown inarrow_forwardThe cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,991. During October, the total cash deposited was $139,960, and checks written totaled $137,747. The bank statement indicated a balance of $43,370 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $6,476. b. A deposit of $1,779 representing receipts of October 31, had been made too late to appear on the bank statement. c. The bank had collected for Coastal Bike Co. $5,250 on a note left for collection. The face of the note was $5,000. d. A check for $580 returned with the statement had been incorrectly charged by the bank as $850. e. A check for $210 returned with the statement had been recorded by Coastal Bike Co. as $120. The check was for the payment of an obligation to Rack Pro Co. on account. f. Bank service charges for October amounted to $28. g. A check for…arrow_forward
- Peterson Company's general ledger shows a cash balance of $7,720 on May 31. May cash receipts of $1,340, included in the general ledger balance, are placed in the night depository at the bank on May 31 and processed by the bank on June 1. The bank statement dated May 31 shows an NSF check for $190 and a service fee of $60. The bank processes all checks written by the company by May 31 and lists them on the bank statement, except for one check totaling $1,710. The bank statement shows a balance of $7,840 on May 31. Prepare a bank reconciliation to calculate the correct ending balance of cash on May 31. (Amounts to be deducted should be indicated with a minus sign.) Bank's Cash Balance Before reconciliation After reconciliation PETERSON COMPANY Bank Reconciliation May 31 SA Company's Cash Balance Before reconciliation 0 After reconciliation SA 0arrow_forwardThe cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $17,865. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $6,095 on a note left for collection. The face of the note was $5,750. A check for $390 returned with the statement had been incorrectly recorded by Stone Systems as $930. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account. A check drawn for $1,810 had been incorrectly charged by the bank as $1,180. Bank service charges for July amounted to $80. Required: 1. Prepare a bank reconciliationarrow_forwardEntries for Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31, $22,240. Cash balance according to the bank statement at July 31, $23,450. Checks outstanding, $4,510. Deposit in transit, not recorded by bank, $3,630. A check for $590 in payment of an account was erroneously recorded in the check register as $950. Bank debit memo for service charges, $30. Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge. a. July 31 b. July 31arrow_forward
- The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31. a. On July 31, the company's Cash account has a $25,127 debit balance, but its July bank statement shows a $27,260 cash balance. b. Check Number 3031 for $1,420, Check Number 3065 for $486, and Check Number 3069 for $2,188 are outstanding checks as of July 31. c. Check Number 3056 for July rent expense was correctly written and drawn for $1,290 but was erroneously entered in the accounting records as $1,280. d. The July bank statement shows the bank collected $9,000 cash on a note for Branch. Branch had not recorded this event before receiving the statement. e. The bank statement shows an $805 NSF check. The check had been received from a customer, Evan Shaw. Branch has not yet recorded this check as NSF. f. The July statement shows a $14 bank service charge. It has not yet been recorded in miscellaneous expenses because no previous notification…arrow_forwardThe following data were accumulated for use in reconciling the bank account of Nakajima Co. for July: Cash balance according to the company's records at July 31, $49,910. Cash balance according to the bank statement at July 31, $48,250. Checks outstanding, $4,460. Deposit in transit, not recorded by bank, $6,450. A check for $590 issued in payment of an account was erroneously recorded in the check register as $950. Bank debit memo for service charges, $30. Question Content Area a. Prepare a bank reconciliation, using the format shown in Exhibit 12. Nakajima Co.Bank ReconciliationJuly 31 Cash balance according to bank statement $fill in the blank 8740c9ff3f91023_1 - Select - - Select - Adjusted balance $fill in the blank 8740c9ff3f91023_6 Cash balance according to company's records $fill in the blank 8740c9ff3f91023_7 - Select - - Select - Adjusted balance $fill in the blank 8740c9ff3f91023_12 Question Content Area b. If the…arrow_forwardRefer to the information given below: a. The August 31 balance shown on the bank statement is $9,050. b. There is a deposit in transit of $1,300 at August 31. c. Outstanding checks at August 31 totaled $1,620. d. Interest credited to the account during August but not recorded on the company's books amounted to $68. e. A bank charge of $44 for checks was made to the account during August. Although the company was expecting a charge, the amount was not known until the bank statement arrived. f. In the process of reviewing the canceled checks, it was determined that a check issued to a supplier in payment of accounts payable of $142 had been recorded as a disbursement of $412. g. The August 31 balance in the general ledger Cash account, before reconciliation, is $8,436. Required: a-1. Show the reconciling items in a horizontal model that should be prepared to reflect the reconciling items as on August 31. (Use amounts with + for increases and amounts with for decreases.) Cash Assets…arrow_forward
- The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $26,110. Cash balance according to the bank statement at August 31, $27,460. Checks outstanding, $5,300. Deposit in transit not recorded by bank, $4,260. A check for $480 in payment of an account was erroneously recorded in the check register as $840. Bank debit memo for service charges, $50. a. Prepare a bank reconciliation, using the format shown in Exhibit 13. b. If the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash?arrow_forwardEntries for Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: 1. Cash balance according to the company's records at July 31, $17,410. 2. Cash balance according to the bank statement at July 31, $18,430. 3. Checks outstanding, $3,530. 4. Deposit in transit, not recorded by bank, $2,840. 5. A check for $590 in payment of an account was erroneously recorded in the check register as $950. 6. Bank debit memo for service charges, $30. Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge. a. July 31 Cash |X Accounts Payable b. July 31 Miscellaneous Expense Feedback Cash Check My Work Keep in mind that the company needs to journalize any adjusting items in the company section of the bank reconciliation, decrease Cash. If the company made an error that understates cash in the company section, the journal adjustment woularrow_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_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