Bank Account Reconciliation Worksheet

Download Bank Reconciliation Worksheet (Excel – .xlsx)

Instructions

  1. Steps to balance your bank account
    1. Fill out the top portion of the bank reconciliation worksheet.
    2. Enter the month end balance from the bank statement.
    3. Enter any deposits in transit as of the end of the month you are reconciling.
    4. Enter the month end balance from the check register.
    5. Enter all outstanding checks as of the end of the month you are reconciling. Outstanding checks are those that have not cleared.
    6. Enter any outstanding adjustments as of the end of the month you are reconciling.
    7. The Adjusted Bank Statement Balance and the Adjusted Check Register should equal.
  2. Steps to balance to the authorized Custodian Fund amount
    1. Enter the checks written through the month you are reconciling that have not been replenished.
    2. Enter the total amount of checks that have a stop payment. Enter the amount as a negative amount. Note that checks 90 days or older are to have a stop payment placed in US Bank SinglePoint.
    3. Enter the current authorized amount.
    4. Difference should be zero.
    5. Total amount of replenishment that needs to be requested from Cash Management to replenish the bank account. Note that replenishments are to be completed at least every 90 days or sooner.

Download an Illustration of Instructions (Excel – .xlsx)