Efficiently manage your finances with our Bank Reconciliation Template, encompassing all stages from initial data gathering to final report creation and approval.
1
Gather all necessary bank statements and financial records
2
Review the business’s bank statement
3
Make note of outstanding checks
4
Identify any deposits in transit
5
Note any errors from the bank's end
6
Calculate total bank statement
7
Compare the calculated total with the cash account
8
Adjust the cash account for discrepancies
9
Integrate any adjustments into the company’s general ledger
10
Run a double-check and review on the reconciliation
11
Approval: Financial Analyst
12
Prepare a final report detailing the reconciliation findings
13
Include copies of reconciled bank statements and ledgers in the report
14
Approval: Manager
15
Compile recommendations if any discrepancies were found
16
Schedule a meeting to discuss reconciliation findings
17
Present reconciliation findings and recommendations to management
18
Approval: CEO
19
Implement recommended adjustments to the accounting procedures
20
Archive all the documents and findings for future reference
Gather all necessary bank statements and financial records
Before starting the bank reconciliation process, gather all bank statements and financial records related to the business. These include bank statements, check registers, deposit slips, and any other relevant documents. This task is important as it ensures that all the required information is readily available for the reconciliation process.
Review the business’s bank statement
Carefully review the business’s bank statement to ensure that all transactions are recorded accurately. Check for any discrepancies between the bank statement and the company's records. This task plays a crucial role in identifying any errors or unauthorized transactions in the bank statement.
1
Deposit
2
Withdrawal
3
Transfer
Make note of outstanding checks
Identify any outstanding checks that have been issued but not yet cleared by the bank. Note down the details of these checks, such as the check number, amount, and date. This task is essential to ensure that the reconciled balance matches the actual bank balance.
Identify any deposits in transit
Identify any deposits that have been made by the business but have not yet appeared on the bank statement. Record the details of these deposits, including the deposit amount and date. This task is necessary to account for the deposits that are still in transit and are not reflected in the bank statement.
Note any errors from the bank's end
If there are any errors in the bank's records or statements, document them in detail. This can include bank charges, incorrect balances, or any other discrepancies. This task is crucial as it helps in rectifying any errors or issues caused by the bank's end.
Calculate total bank statement
Calculate the total amount of the bank statement by adding all the credits and subtracting all the debits. Ensure that the calculations are accurate and match the bank statement. This task is important to determine the actual amount available in the bank account.
Compare the calculated total with the cash account
Compare the calculated total from the bank statement with the cash account balance in the company's records. Identify any differences or discrepancies between the two balances. This task helps in identifying any errors or mismatches in the cash account balance.
Adjust the cash account for discrepancies
If there are any discrepancies between the calculated total and the cash account balance, make necessary adjustments to the cash account. This can include adding or subtracting amounts to reconcile the balances. This task ensures that the cash account reflects the accurate balance.
1
Addition
2
Subtraction
Integrate any adjustments into the company’s general ledger
After making adjustments to the cash account, update the company's general ledger to reflect the changes. Ensure that the adjustments are recorded accurately and classified under the appropriate accounts. This task is important to maintain accurate financial records.
Run a double-check and review on the reconciliation
Double-check the bank reconciliation to ensure that all the calculations and adjustments have been done accurately. Review the entire reconciliation process to identify any potential errors or missed steps. This task helps in ensuring the accuracy and completeness of the bank reconciliation.
Approval: Financial Analyst
Will be submitted for approval:
Run a double-check and review on the reconciliation
Will be submitted
Prepare a final report detailing the reconciliation findings
Create a final report summarizing the bank reconciliation findings. Include details such as the starting and ending balance, outstanding checks, deposits in transit, and any adjustments made. This task is important to document the reconciliation process and its outcomes for future reference.
Include copies of reconciled bank statements and ledgers in the report
Attach copies of the reconciled bank statements and ledgers to the final report. This provides supporting documentation and helps in understanding the reconciliation process. This task ensures that all relevant documents are included in the final report.
Approval: Manager
Will be submitted for approval:
Prepare a final report detailing the reconciliation findings
Will be submitted
Compile recommendations if any discrepancies were found
If any discrepancies or issues were identified during the bank reconciliation process, compile recommendations on how to address and resolve them. This task helps in providing guidance for improving the company's financial processes and minimizing future discrepancies.
Schedule a meeting to discuss reconciliation findings
Schedule a meeting with relevant stakeholders to discuss the bank reconciliation findings. This meeting allows for a thorough review of the findings, addressing any questions or concerns, and determining the next steps to be taken. This task facilitates collaboration and decision-making based on the reconciliation outcomes.
Present reconciliation findings and recommendations to management
Present the bank reconciliation findings and recommendations to the management team. This presentation should include a summary of the reconciliation process, key findings, recommendations, and any proposed actions. This task helps in providing transparency and accountability to the management team.
Approval: CEO
Will be submitted for approval:
Present reconciliation findings and recommendations to management
Will be submitted
Implement recommended adjustments to the accounting procedures
Implement the recommended adjustments identified during the bank reconciliation process. Update the accounting procedures, policies, or systems to incorporate the necessary changes. This task ensures that the improvements suggested in the reconciliation process are implemented effectively.
Archive all the documents and findings for future reference
Archive all the bank reconciliation documents, reports, findings, and recommendations for future reference. This task ensures that the information is easily accessible and can be referred to when needed in the future.