The bank account as a control device that helps to protect cash. One of the requirements is to conduct periodic bank statement reconciliations. Using the following data, complete the bank statement reconciliation. (Use the format shown on page 255 of your textbook) (25 points)
Prepare a bank reconciliation using ABC Restaurant Supply Inc.’s information for August 31.
· A NSF check from Johnny Jones for $3,164.
· Two deposits made on August 31 were not on the bank statement, totaling $2,897.
· The bank collected an EFT payment for Rent for $2,600.
· August 31 balance in Cash was $1,905.
· The owner had written check # XXXXX for $500 and recorded this check as $5,000.
· The balance on the bank statement as of August 31 was $5,216.
· Bank service charge of $28 was shown on the bank statement.
· Checks #1572, 1606, 1116, and 1242 for $419, $126, $650, and $1,105, respectively, were not shown on the bank statement, even though the company had sent the checks.
BANK BALANCE: $5,216Add: Deposits in transit $2,897Less: Outstanding Checks $2,300Adjusted bank balance = $5,813BOOK BALANCE $1,905Less: NSF Check $3,164Add: Rent collected $2,600Add: Error in recording check $4,500Less; Bank Service charge $28ADJUSTED BOOK BALANCE: $5,813If this helped, then rate my service as "excellent" so that I can be compensated for assisting you today. Otherwise, click "reply" or "continue conversation" for continued dialog with me.VERY IMPORTANT - IF you are having DIFFICULTY RATING, please let me know IMMEDIATELY. If you don't rate my response, I don't get paid even though your deposit is retained by the site. Thanks for your cooperation in this matter.
TN CPA with Master's degree from Ole Miss
Thank you for the positive rating. Please remember me the next time you have a financial question. Simply enter "MyVirtualCPA" in the subject of your question, and it will be routed directly to me. Thank you again for using JustAnswer