Financial Accounting, Student Value Edition (4th Edition)
4th Edition
ISBN: 9780134114811
Author: Robert Kemp, Jeffrey Waybright
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7, Problem 32BE
1.
To determine
Prepare the bank reconciliation.
2.
To determine
Prepare the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Learning Task 5 Directions: Using the information below, prepare a Bank Reconciliation Statement.Bank reconciliation problem:• The bank statement for Juan Company shows a balance per bank of P15,907.45 on April 30,2015.• On this date the balance of cash per books is P11,589.45.• Additional information are provided below: Deposits in transit: April 30 deposit (received by the bank on May 1) P2,201.40 Outstanding checks: No. 453-P3,000.00 No. 457-P1,401.30 No. 460-P1,502.70• Errors: Juan wrote check no. 443 for P1,226.00 and the bank correctly paid that amount. However, he recorded the check as P1,262.00.• Bank memoranda: Debit– NSF check from Pedro P425.60 Debit– Charge for printing company checks P30.00 Credit – Collection of note receivable for P1,000 plus interest earned of P50, less bank collection fee of P15.00.Hint: Bank Debit Memo are deductions made by the bank to the account of the depositor. Bank Credit Memo are additions made by the bank to the account of the deposito
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts.
Note: You must complete part 1 before completing part 2.
Based on the following data, prepare a bank reconciliation for December of the current year:
a. Balance according to the bank statement at December 31, $283,000.b. Balance according to the ledger at December 31, $245,410.c. Checks outstanding at December 31, $68,540.d. Deposit in transit, not recorded by bank, $29,500.e. Bank debit memo for service charges, $750.f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000.
The folowing Information was gathered by Superior Landscaping in order to prepare its Bank Reconciliation at the end of October:
Balance in Cash Ledger account at end of Oct 31 $4,450
Balance of Cash in Bank Statement at end of Oct 31 3,900
Electornic Funds Transfer deposited into your Bank account late Oct 31 600
Outstanding Cheques at end of Oct 31 1,200
Deposits in Transit 2,000
NSF cheque received from a customer 350
Prepare the October 31st Bank Reconciliation
Chapter 7 Solutions
Financial Accounting, Student Value Edition (4th Edition)
Ch. 7.A - Prob. 1SECh. 7.A - Prob. 2SECh. 7.A - Prob. 3AECh. 7.A - Prob. 4AECh. 7.A - Prob. 5BECh. 7.A - Prob. 6BECh. 7.A - Prob. 7APCh. 7.A - Prob. 8APCh. 7 - Which duties should be segregated in the...Ch. 7 - Prob. 2DQ
Ch. 7 - Prob. 3DQCh. 7 - Why does the allowance method of accounting for...Ch. 7 - Prob. 5DQCh. 7 - Prob. 6DQCh. 7 - Prob. 7DQCh. 7 - How would the net realizable value of Accounts...Ch. 7 - Prob. 9DQCh. 7 - Prob. 10DQCh. 7 - Prob. 1SCCh. 7 - Prob. 2SCCh. 7 - Prob. 3SCCh. 7 - Prob. 4SCCh. 7 - Prob. 5SCCh. 7 - Prob. 6SCCh. 7 - Prob. 7SCCh. 7 - Prob. 8SCCh. 7 - Prob. 9SCCh. 7 - Prob. 10SCCh. 7 - Prob. 11SCCh. 7 - Prob. 12SCCh. 7 - Prob. 1SECh. 7 - Prob. 2SECh. 7 - Prob. 3SECh. 7 - Prob. 4SECh. 7 - Prob. 5SECh. 7 - Prob. 6SECh. 7 - Prob. 7SECh. 7 - Prob. 8SECh. 7 - Prob. 9SECh. 7 - Prob. 10SECh. 7 - Prob. 11SECh. 7 - Prob. 12SECh. 7 - Prob. 13SECh. 7 - Prob. 14SECh. 7 - Prob. 15SECh. 7 - Quick ratio (Learning Objective 7) 510 min....Ch. 7 - Prob. 17SECh. 7 - Prob. 18AECh. 7 - Prob. 19AECh. 7 - Prob. 20AECh. 7 - Prob. 21AECh. 7 - Prob. 22AECh. 7 - Prob. 23AECh. 7 - Prob. 24AECh. 7 - Prob. 25AECh. 7 - Prob. 26AECh. 7 - Prob. 27AECh. 7 - Quick ratio and current ratio (Learning Objective...Ch. 7 - Prob. 29AECh. 7 - Prob. 30BECh. 7 - Prob. 31BECh. 7 - Prob. 32BECh. 7 - Prob. 33BECh. 7 - Prob. 34BECh. 7 - Prob. 35BECh. 7 - Prob. 36BECh. 7 - Prob. 37BECh. 7 - Prob. 38BECh. 7 - Prob. 39BECh. 7 - Quick ratio and current ratio (Learning Objective...Ch. 7 - Prob. 41BECh. 7 - Prob. 42APCh. 7 - Prob. 43APCh. 7 - Prob. 44APCh. 7 - Prob. 45APCh. 7 - Prob. 46APCh. 7 - Prob. 47APCh. 7 - Prob. 48APCh. 7 - Prob. 49BPCh. 7 - Prob. 50BPCh. 7 - Prob. 51BPCh. 7 - Prob. 52BPCh. 7 - Prob. 53BPCh. 7 - Prob. 54BPCh. 7 - Prob. 55BPCh. 7 - Continuing Exercise In this exercise, we continue...Ch. 7 - Prob. 1CPCh. 7 - Prob. 1CFSAPCh. 7 - Prob. 1EIACh. 7 - Prob. 2EIACh. 7 - Prob. 1FACh. 7 - Prob. 1IACh. 7 - Prob. 1SBACh. 7 - Prob. 1WC
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
- Help would be appreciated 2. On December 31st, Bub's gym received a bank statement for December. b. Prepare a bank reconciliation. Use the following information from the bank statement and business records. Bank balance $1685.00 Bank service charge $25.00 Outstanding Deposit, Dec 30 $450.00 Outstanding checks, No. 23 and 24 Check book balance on check stub No. 25 $1905.00arrow_forwardThe following information is available for Pyle Garage for March, Year 2: BANK STATEMENTHAZARD STATE BANK215 MAIN STREETHAZARD, GA 30321 Pyle Garage629 Main StreetHAZARD, GA 30321 Account number62-00062March 31, Year 2 Beginning balance 3/1/Year 2 $9,070 Total deposits and other credits 30,096 Total checks and other debits 25,024 Ending balance 3/31/Year 2 14,142 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $ 3,795 March 1 $ 1,140 1463 1,684 March 2 6,548 1464 8,040 March 6 4,976 1465 2,946 March 12 6,209 1466 1,449 March 17 6,006 1467 6,220 March 22 2,126 DM 60 CM 3,091 1468 830 The following is a list of checks and deposits recorded on the books of Pyle Garage for March, Year 2: Date Check No. Amount of Check Date Amount of Deposit March 1 1463 $ 1,684 March 1 $ 6,548 March 5…arrow_forward(Learning Objectives 1, 4, 5, 6: Apply GAAP for revenue, receivables,collections, and uncollectibles using the percent-of-sales method; account for notesreceivable) Hopewell Shipping Corporation is an overnight shipper. Since it sells on credit, thecompany cannot expect to collect 100% of its accounts receivable. At October 31, 2018, and2019, respectively, Hopewell reported the following on its balance sheet (in millions of dollars):October 31,2019 2018Accounts receivable.................................................. $4,200 $4,000Less: Allowance for uncollectible accounts...............Accounts receivable, net........................................... $4,030 $3,840(170) (160)During the year ended October 31, 2019, Hopewell earned service revenue and collected cashfrom customers. Assume uncollectible-account expense for the year was 5% of service revenueon account and Hopewell wrote off uncollectible receivables and made other adjustments as necessary (see below). At year-end,…arrow_forward
- Question Content Area Using the following information: The bank statement balance is $5,065. The cash account balance is $5,459. Outstanding checks amounted to $866. Deposits in transit are $1,191. The bank service charge is $60. A check for $34 for supplies was recorded as $25 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co. Bank Reconciliation May 31 Cash balance according to bank statement $fill in the blank 1 Adjustments: $- Select - - Select - Total adjustments fill in the blank 6 Adjusted balance $fill in the blank 7 Cash balance according to company's records $fill in the blank 8 Adjustments: $- Select - - Select - Total adjustments fill in the blank 13 Adjusted balance $fill in the blank 14arrow_forwardA bank reconciliation must be performed. First you collect the data from June 30th reconciliation as follows: Balance per Bank $ 10,000 add: Deposits in Transit $ 1,800 deduct: Outstanding Cheques $ (2,200 Balance per Books $ 9,600 Second you close your update your Cash and bank account with all transactions recorded before AJE and you have: Balance July 31 $ 12,000 Deposits $ 7,300 Cheques $ 4,800 Third you look at the bank statement provided by your bank and you see the following: Balance July 31 $ 12,430 Deposits $ 6,000 Cheques $ 4,000 Note collected $ 1,000 Bank service charge $ 20 NSF cheque $ 150 Interest received $ 200 Autowithdrawals $ 500 Which of the following adjusting journal entries is required after the bank reconciliation has been prepared? Dr. Cash $20 Cr. bank fees $20 (to reflect bank fees for the month) Dr. Phone Expenses $500 Cr. Cash $500 (to reflect the automatic payment of the phone - autowithdraw) Dr. Interest…arrow_forward(Learning Objective 1: Show how to speed up cash from receivables) Patterson ShirtCompany sells on credit and manages its own receivables. Average experience for the past threeyears has been the following:Sales..................................................Cost of goods sold.............................Uncollectible-account expense...........Other expenses..................................Cash$250,000125,000—82,500Credit$250,000125,00018,00082,500Total$500,000250,00018,000165,000The owner of Patterson is considering whether to accept credit cards (VISA and MasterCard)instead of granting credit to customers. If Patterson were to accept credit cards, the ownerexpects total sales to increase by 10% but cash sales to remain unchanged. Further, if Pattersonwere to accept credit cards, the business can save $9,000 on other expenses, but the credit cardprocessors charge 3% on credit card sales.Requirement1. Should Patterson Shirt Company start accepting credit cards? Show the computations…arrow_forward
- Required information Use the following information for the Exercises 12 below. (Algo) Skip to question [The following information applies to the questions displayed below.] Del Gato Clinic's cash account shows an $13,236 debit balance and its bank statement shows $12,096 on deposit at the close of business on June 30. Outstanding checks as of June 30 total $1,284. The June 30 bank statement lists a $70 bank service charge. Check No. 919, listed with the canceled checks, was correctly drawn for $789 in payment of a utility bill on June 15. Del Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $798. The June 30 cash receipts of $2,363 were placed in the bank’s night depository after banking hours and were not recorded on the June 30 bank statement.arrow_forwardApex Ltd was in the process of preparing a bank reconciliation statement. Apex Ltd book balance =32,800 Deposit in Transit =4,300 Outstanding checks =2,200 Interest earned on checking account =100 Customer NSF check returned by bank =400 The adjusted cash balance as at September 30, 2020 will be?arrow_forwardThe following information is made available while checking the cash accounts of AeronCompany on December 31, 2019:Balance per book 7,100,000Balance in checking account 7,000,000Deposit in transit 1,200,000Outstanding checks 1,500,000Deposit in other bank closed by BSP 1,500,000Currency and coins on hand 600,000Petty cash fund 50,000DAIF checks of customers returned by bank 500,000Error in recording a check in the book. The correct amount as paid bythe bank is P100,000 instead of P200,000 as recorded in the book 100,000The correct cash balance under current assets on December 31, 2019 is_______arrow_forward
- eBook Using the following information, prepare the journal entries to reconcile the bank statement. Bank balance: $6,788 Book balance: $8,393 Deposits in transit: $1,735 Outstanding checks: $579 and $1,523 Bank service charges: $25 Bank incorrectly charged the account $25. The bank will correct the error next month. Check number 2456 correctly cleared the bank in the amount of $137 but posted in the accounting records as $317. This check was expensed to Utilities Expense.arrow_forwardPrepare a bank reconciliation as of December 31, 2020. Use the format shown in Illustration 7A.2 on page 7-35 of our textbook. The data you will need is as follows: Balance per bank statement as of December 31, 2020 $1,738 Deposits in transit as of December 31, 2020 $ 2,500 Outstanding checks as of December 31, 2020 $3,235 Correct Cash Balance as of December 31, 2020 $4,003 Balance per Books as of December 31, 2020 $5,628 Interest collected by the bank in December, 2020 but not recorded in books as of December 31, 2020 $ 600 Bank service charges deducted by the bank in December, 2020 but not recorded in books as of December 31, 2020 $ 75 IN EXCEL FORMAT PLEASEarrow_forwardStewart Recording Studio, owned by Ron Stewart, showed the following bank reconciliation at March 31: Stewart Recording Studio Bank Reconciliation March 31, 2020 Bank statement balance $ 22,200 Book balance $ 31,085 Add: Deposit of March 31 in transit 10,045 $ 32,245 Deduct: Outstanding cheques: #14 $ 843 #22 317 1,160 Adjusted bank balance $ 31,085 Adjusted book balance $ 31,085 Cash Acct. No. 101 Date Explanation PR Debit Credit Balance 2020 March 31 Balance 31,085 April 30 CR17 71,762 102,847 30 CD13 92,000 10,847 A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below: Deposits Made April 7 $ 693 13 4,620 18 5,926 23…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you