Bank Reconciliation Worksheet

What is a bank reconciliation worksheet?

A bank reconciliation worksheet is a tool used by businesses to compare their own records of financial transactions with the information provided by their bank. It helps to ensure that the company's records match the bank's records and identify any discrepancies or errors that may need to be corrected.

What are the types of bank reconciliation worksheet?

There are two main types of bank reconciliation worksheets: 1. Manual Bank Reconciliation Worksheet: This involves manually comparing the company's records and bank statements to identify discrepancies. It requires more time and effort but provides a detailed analysis of the transactions. 2. Automated Bank Reconciliation Worksheet: This is done using accounting software or online tools that import the bank statements and automatically match them with the company's records. It is quicker and less prone to errors compared to manual reconciliation.

Manual Bank Reconciliation Worksheet
Automated Bank Reconciliation Worksheet

How to complete a bank reconciliation worksheet

Completing a bank reconciliation worksheet is an important task to ensure the accuracy of financial records. Here's a step-by-step guide: 1. Gather the necessary documents: Collect the bank statements, checkbooks, and the company's financial records. 2. Compare records: Match each transaction in the bank statement with the corresponding entry in the company's records. 3. Identify discrepancies: Highlight any differences between the bank statement and the company's records. 4. Investigate discrepancies: Look for missing transactions, errors in amounts, or any other discrepancies. 5. Make adjustments: Make the necessary adjustments in the company's records to match the bank's records. 6. Reconcile: Once all the discrepancies are resolved, reconcile the differences and ensure the final balances in both sets of records match.

01
Gather the necessary documents
02
Compare records
03
Identify discrepancies
04
Investigate discrepancies
05
Make adjustments
06
Reconcile

pdfFiller empowers users to create, edit, and share documents online. Offering unlimited fillable templates and powerful editing tools, pdfFiller is the only PDF editor users need to get their documents done.

Video Tutorial How to Fill Out bank reconciliation worksheet

Thousands of positive reviews can’t be wrong

Read more or give pdfFiller a try to experience the benefits for yourself
4.0
The form was filled out by md but I could not print it legibly.
The form was filled out by md but I could not print it legibly. What was printed was illegible and of no use to me.
Emanuel A. H
5.0
I was very impressed with all the option that were readily available to me.
I was very impressed with all the option that were readily available to me. The library was amazing, and aside from business I found things for my children, as well.
Leslie G.
4.0
The form was filled out by md but I could not print it legibly.
The form was filled out by md but I could not print it legibly. What was printed was illegible and of no use to me.
Emanuel A.

Questions & answers

This monthly bank reconciliation template allows the user to reconcile a bank statement with current checking account records. Use this bank reconciliation example template to help rectify any errors in your financial statement. This is an accessible template.
Balance sheet reconciliation checklist: 4 steps Gather documentation and records. Before you can look over your balance sheet and reconcile it, gather the proper documentation. Compare information. Make adjustments, if needed. Check to see if your sheet is balanced.
The four steps in the bank reconciliation process is as follows: Compare the deposits. Adjust the bank statements. Adjust the cash account. Compare the balances.
Below is step by step procedure for Bank Reconciliation: Match the Opening balance as per Bank statement with the books. Check and tick all the debit entries as reflected in bank ledger with the credit entries in Bank Statement, identify which are missed.
Bank Reconciliation Procedure On the bank statement, compare the company's list of issued checks and deposits to the checks shown on the statement to identify uncleared checks and deposits in transit. Using the cash balance shown on the bank statement, add back any deposits in transit. Deduct any outstanding checks.
0:00 10:11 Speed Up Your Bank Reconciliation With This Excel Template - YouTube YouTube Start of suggested clip End of suggested clip In this video I'm gonna go over my bank reconciliation template. And then this template you canMoreIn this video I'm gonna go over my bank reconciliation template. And then this template you can categorize your transactions which will make it easier to automatically.