Bank Reconciliation Worksheet
What is bank reconciliation worksheet?
A bank reconciliation worksheet is a tool used by businesses and individuals to compare their records of bank transactions with those of the bank. It allows them to identify and rectify any discrepancies between the two sets of records. The worksheet typically includes details of deposits, withdrawals, fees, and other bank-related transactions.
What are the types of bank reconciliation worksheet?
There are two main types of bank reconciliation worksheets:
Manual reconciliation worksheet: This type of worksheet involves manually comparing bank statements and records with the help of paper and pen or spreadsheet software. It requires careful attention to detail and can be time-consuming.
Automated reconciliation worksheet: This type of worksheet utilizes specialized software or online tools, such as pdfFiller, to automatically compare and reconcile bank transactions. It saves time and reduces the chances of errors.
How to complete bank reconciliation worksheet
To complete a bank reconciliation worksheet, follow these steps:
01
Gather all your bank statements and records for the relevant period.
02
Compare the transactions listed on your bank statement with your own records, such as checkbook register or financial software.
03
Note down any discrepancies or differences between the two sets of records.
04
Investigate the discrepancies by cross-checking receipts, invoices, and other supporting documents.
05
Make necessary adjustments or corrections to your records to reflect the accurate information.
06
Update your bank reconciliation worksheet with the corrected information.
07
Repeat the process for all transactions until you have reconciled all items.
08
Review the final reconciliation report and ensure that the ending balances match.
09
Save the completed bank reconciliation worksheet for future reference.
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
Related templates