/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 18 The following data were accumula... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

The following data were accumulated for use in reconciling the bank account of Spectrum Co. for July: a. Cash balance according to the company’s records at July 31, \(8,346.50. b. Cash balance according to the bank statement at July 31, \)9,066.35. c. Checks outstanding, \(3,175.25. d. Deposit in transit, not recorded by bank, \)2,615.40. e. A check for \(240 in payment of an account was erroneously recorded in the check register as \)420. f. Bank debit memorandum for service charges, $20.00. Prepare a bank reconciliation, using the format shown in Exhibit 7.

Short Answer

Expert verified
The reconciled cash balance for Spectrum Co. by both bank statement and company records is $8,506.50.

Step by step solution

01

Prepare the format for reconciliation

To reconcile the bank statement with the company’s cash records, you'll need to adjust the balances according to bank and book records. Prepare two columns: 'Bank Statement' and 'Company's Records'. Begin with the given balances: 1. Bank statement balance: \(9,066.35\) 2. Company’s cash records balance: \(8,346.50\).
02

Adjust Bank Statement Balance

Adjust the bank statement balance for outstanding checks and deposits in transit, as these have not yet been processed by the bank: 1. Subtract outstanding checks: \[9,066.35 - 3,175.25 = 5,891.10\]2. Add deposit in transit: \[5,891.10 + 2,615.40 = 8,506.50\]The adjusted bank statement balance becomes \(8,506.50\).
03

Adjust Company's Cash Record

Adjust the company's cash records for any errors and bank charges: 1. Correct the error in the check register: The check was recorded as 420 instead of 240, so adjust by adding back the difference:\[420 - 240 = 180\]\[8,346.50 + 180 = 8,526.50\]2. Subtract the bank service charges:\[8,526.50 - 20.00 = 8,506.50\]The adjusted company’s records balance is \(8,506.50\).
04

Compare Adjusted Balances

After adjusting, compare the adjusted bank statement balance \(8,506.50\) and the adjusted company’s record balance \(8,506.50\). Since they match, the bank reconciliation is complete.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Outstanding Checks
Outstanding checks refer to checks that have been written by a company but have not yet been cashed or cleared by the bank. This means that these amounts have been deducted from the company’s cash account but are not yet reflected in the bank balance. When performing a bank reconciliation, outstanding checks must be subtracted from the bank statement balance.

The purpose of this adjustment is to align the bank's reported balance with the company's records. In our example, Spectrum Co. had \(3,175.25\) in outstanding checks. This amount needs to be accounted for when reconciling the bank statement with the company's cash records. Keep in mind that outstanding checks can sometimes remain uncashed for a period, delaying this reconciliation process.
Deposit in Transit
A deposit in transit is any deposit that has been recorded by the company but not yet processed by the bank. These transactions have been added to the company's cash balance but haven't appeared on the bank's records by the statement date.

When reconciling, you should add any deposits in transit to the bank statement balance, ensuring both records reflect them accurately.

For Spectrum Co., there is a deposit in transit valued at \(2,615.40\). This amount was included in the company's cash records but not reflected in the bank statement, requiring an adjustment to ensure parity between the two accounts.
Bank Statement Balance
The bank statement balance reflects the amount of money in the company's bank account as reported by the bank at the end of a given period. This figure often differs from the company's cash records, primarily due to the timing of transactions.

In a bank reconciliation, you start with the bank statement balance and make necessary adjustments for outstanding checks and deposits in transit, among others, to arrive at an adjusted balance. This ensures that all transactions affecting the bank account are accurately recorded.

For example, Spectrum Co.'s initial bank statement balance was \(9,066.35\), which required adjustments for outstanding checks and a deposit in transit to reconcile with the company's cash records.
Company Cash Records
The company cash records consist of all entries related to cash transactions maintained by the business. These records usually include all checks issued, deposits made, and any bank charges or errors needing correction. These records are crucial for monitoring and managing cash flow.

During bank reconciliation, adjustments based on these records, such as correcting entry errors or accounting for bank fees, ensure that the cash balance aligns with the bank statement balance.

In Spectrum Co.'s case, the cash records initially showed \(8,346.50\). Adjustments were necessary for recording errors and bank service fees to reconcile these with the bank statement balance, ensuring both amounts matched after the reconciliation process.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Amber Meehan works at the drive-through window of Jackpot Burgers. Occasionally, when a drive-through customer orders, Amber fills the order and pockets the customer's money. She does not ring up the order on the cash register. Identify the internal control weaknesses that exist at Jackpot Burgers, and discuss what can be done to prevent this theft.

The actual cash received from cash sales was \(\$ 21,099.75\), and the amount indicated by the cash register total was \(\$ 21,114.26\). Journalize the entry to record the cash receipts and cash sales.

Accompanying a bank statement for Bionics Company is a credit memorandum for \(17,750, representing the principal (\)15,000) and interest ($2,750) on a note that had been collected by the bank. The depositor had been notified by the bank at the time of the collection, but had made no entries. Journalize the entry that should be made by the depositor to bring the accounting records up to date.

Identify each of the following reconciling items as: (a) an addition to the cash balance according to the bank statement, (b) a deduction from the cash balance according to the bank statement, (c) an addition to the cash balance according to the company’s records, or (d) a deduction from the cash balance according to the company’s records. (None of the transactions reported by bank debit and credit memoranda have been recorded by the company.) 1\. Bank service charges, \(48. 2\. Outstanding checks, \)8,125.50. 3\. Deposit in transit, \(12,200. 4\. Note collected by bank, \)8,750. 5\. Check drawn by company for \(150 but incorrectly recorded as \)510. 6\. Check for \(200 incorrectly charged by bank as \)2,000. 7\. Check of a customer returned by bank to company because of insufficient funds, $1,200.

Argonaut Co. records all cash receipts on the basis of its cash register tapes. Argonaut Co. discovered during November 2008 that one of its sales clerks had stolen an undetermined amount of cash receipts when she took the daily deposits to the bank. The following data have been gathered for November: Cash in bank according to the general ledger $12,510.45 Cash according to the November 30, 2008 bank statement 22,060.65 Outstanding checks as of November 30, 2008 6,381.42 Bank service charge for November 35.00 Note receivable, including interest collected by bank in November 7,140.00 No deposits were in transit on November 30, which fell on a Sunday. a. Determine the amount of cash receipts stolen by the sales clerk. b. What accounting controls would have prevented or detected this theft?

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.