Explore BrainMass
Share

Explore BrainMass

    Formal Two-Sided Bank Reconciliation (Bank and Books)

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

    Please see attachment with detailed information and statements. I am providing an answered spreadsheet(bank.rec) which is missing information. Please complete the missing numbers highlighted on spreadsheet.

    © BrainMass Inc. brainmass.com October 9, 2019, 11:18 pm ad1c9bdddf
    https://brainmass.com/business/auditing/formal-two-sided-bank-reconciliation-bank-books-252316

    Attachments

    Solution Preview

    The company missed two transposition errors; one in a deposit and another in ...

    Solution Summary

    This solution presents a formal, two-sided bank reconciliation, wherein both the bank balance and book balance are reconciled to the "actual balance." It also translates those reconciliations into journal entries and explains each journal entry. The actual reconciliation and journal entries are performed on an Excel spreadsheet.

    $2.19