Explore BrainMass
Share

Explore BrainMass

    Bank Reconciliation Statement for a Restaurant Supply Company

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The bank account as a control device helps to protect cash. One of the requirements is to conduct periodic bank statement reconciliations. Using the following data, complete the bank statement reconciliation.

    Prepare a bank reconciliation using B & B's 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 $2,005.
    - The owner had written check #1598 for $500 and recorded this check as $5,000.
    - The balance on the bank statement as of August 31 was $5,316.
    - 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.

    © BrainMass Inc. brainmass.com October 10, 2019, 7:28 am ad1c9bdddf
    https://brainmass.com/business/financial-accounting-bookkeeping/bank-reconciliation-statement-restaurant-supply-company-583105

    Solution Summary

    A bank reconciliation using B & B's Restaurant Supply Inc.'s information for August 31 is prepared in Excel.

    $2.19