A video on how to prepare a bank reconciliation statement ?
1 view
1 view
1
answer
Sort By
ChatGPT
Dec 11, 2023
I'm sorry, but as a text-based AI, I am unable to provide videos. However, I can guide you through the steps to prepare a bank reconciliation statement. Here is a step-by-step process:
Step 1: Gather necessary documents Collect your bank statement for the relevant period and your own records, including checkbook, cash receipts, and any other relevant financial documents.
Step 2: Compare the ending balances Start by comparing the ending balance on your bank statement with the ending balance in your records. Note any discrepancies.
Step 3: Identify outstanding checks List all the checks that have been issued but have not yet cleared the bank. Compare this list with the checks recorded in your records. Mark the checks that appear on both lists.
Step 4: Identify deposits in transit Identify any deposits that you have made but are not yet reflected in your bank statement. Compare this list with the deposits recorded in your records. Mark the deposits that appear on both lists.
Step 5: Identify bank charges and interest Check your bank statement for any bank charges, such as service fees, and any interest earned. Compare these items with your records and note any differences.
Step 6: Adjust the bank statement balance Add any outstanding deposits in transit to the bank statement balance and subtract any outstanding checks. Also, consider any bank charges or interest that were not recorded in your records. This will give you an adjusted bank statement balance.
Step 7: Adjust your records balance Add any deposits in transit to your records balance and subtract any outstanding checks. Consider any bank charges or interest that were not reflected in the bank statement. This will give you an adjusted records balance.
Step 8: Compare the adjusted balances Compare the adjusted bank statement balance with the adjusted records balance. They should match. If they don't, recheck your calculations and look for any errors.
Step 9: Make necessary adjustments If there are any discrepancies between the adjusted balances, review your records and the bank statement to identify the cause. It could be an error in recording transactions or a bank error. Make the necessary adjustments to reconcile the balances.
Step 10: Prepare the bank reconciliation statement Finally, prepare a bank reconciliation statement that summarizes the adjustments made to reconcile the bank statement balance with your records balance. This statement should include the adjusted balances, outstanding checks, deposits in transit, and any other relevant information.
Remember, this is a general guide, and the specific steps may vary depending on your circumstances. It's always a good idea to consult with a professional accountant or refer to your accounting software's documentation for more detailed instructions.