The 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 reconciliation.
Stone Systems
Bank Reconciliation
July 31, 20Y5
Cash balance according to bank statement $
Adjustments:
Deposit of July 31, not recorded by bank $
Bank error in charging check as $1,180 instead of $1,810
Outstanding checks
Total adjustments
Adjusted balance $
Cash balance according to company's records $
Adjustments:
Proceeds of note collected by bank, including $345 interest $
Error in recording check by Stone Systems
Bank service charges
Total adjustments
Adjusted balance $
Feedback
1 & 3. Set up two sections: one for the company cash account section and the other for the bank balance section. Determine the effect of the data on each section. 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.
Recall that the company's cash account balance is updated for any items in the company section of the bank reconciliation.
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 reconciliation.
Stone Systems
Bank Reconciliation
July 31, 20Y5
Cash balance according to bank statement $
Adjustments:
Deposit of July 31, not recorded by bank $
Bank error in charging check as $1,180 instead of $1,810
Outstanding checks
Total adjustments
Adjusted balance $
Cash balance according to company's records $
Adjustments:
Proceeds of note collected by bank, including $345 interest $
Error in recording check by Stone Systems
Bank service charges
Total adjustments
Adjusted balance $
Feedback
1 & 3. Set up two sections: one for the company cash account section and the other for the bank balance section. Determine the effect of the data on each section. 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.
Recall that the company's cash account balance is updated for any items in the company section of the bank reconciliation.
1 answer:
Answer:
Refer explanation and attachment
Explanation:
The goal of a reconciliation statement is to ascertain the differences between the banks records and the depositor’s records and make accounting changes as deemed appropriate. There is a general flow that is used to make the correcting entries:
1. The process flow starts with the bank’s ending cash balance
2. Add any deposits made by the company to the bank that are in transit
3. Deduct any cheques that are uncleared by the bank
4. Add or deduct any other differences available as necessary
5. In the company bank records, once again start with the ending balance
6. Add interests earned
7. Deduct any bank service fees, penalties and NSF (Non-Sufficient Funds) cheques.
8. Add or deduct any other differences available as necessary
At the end of this process, it is likely that both accounts would be equal and tally
You might be interested in