Checking Account Reconciliation Worksheet

What is checking account reconciliation worksheet?

A checking account reconciliation worksheet is a tool that helps individuals or businesses track and compare their bank statement with their own records. It allows you to identify any discrepancies or errors in your account transactions and ensure that your records match those of the bank. By using a checking account reconciliation worksheet, you can ensure the accuracy of your financial records and detect any fraudulent activities.

What are the types of checking account reconciliation worksheet?

There are two main types of checking account reconciliation worksheet: manual and electronic. Both types serve the same purpose, but the methods of recording and reconciling transactions differ. Manual reconciliation involves manually recording and comparing transactions on a paper or spreadsheet, while electronic reconciliation utilizes software or online tools to automate the process. Each type has its own advantages and disadvantages, so it's important to choose the one that best fits your needs and preferences.

Manual reconciliation worksheet
Electronic reconciliation worksheet

How to complete checking account reconciliation worksheet

Completing a checking account reconciliation worksheet is a straightforward process that involves the following steps:

01
Gather your bank statement and any supporting documents.
02
Record the ending balance from your bank statement on the worksheet.
03
Compare each transaction on your bank statement with your own records.
04
Mark off each transaction that matches on both the bank statement and your records.
05
Identify any discrepancies and investigate them further.
06
Adjust your records accordingly to reconcile the differences.
07
Calculate the adjusted ending balance on the worksheet.
08
Ensure the adjusted ending balance matches the ending balance on your bank statement.
09
Finalize the reconciliation by documenting the date and your initials on the worksheet.
10
Keep the reconciliation worksheet for future reference and audit purposes.

By following these steps, you can effectively complete a checking account reconciliation worksheet and maintain accurate financial records.

Video Tutorial How to Fill Out checking account reconciliation worksheet

Thousands of positive reviews can’t be wrong

Read more or give pdfFiller a try to experience the benefits for yourself
5.0
Nice to have It's good to know that you can use something like this to fill out...
Nice to have It's good to know that you can use something like this to fill out your documents. You can add and fill out any document you want. It can be confusing when you are using it. We are using ours online and sometimes you have to wait to do what you want. I have a feeling that it can be faster.
Sean N.
5.0
Great customer service Great customer service!
Great customer service Great customer service! Extremely fast to reply and solved my problem right away.I would recommend this company.
Andrew Laird
5.0
This was so convenient This was so convenient.
This was so convenient This was so convenient. It was quick and easy to register and begin filling out forms. This helped me out in a crunch to get my 1099 forms completed.
hamiltondara

Questions & answers

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.
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.
Bank Reconciliation: A Step-by-Step Guide COMPARE THE DEPOSITS. Match the deposits in the business records with those in the bank statement. ADJUST THE BANK STATEMENTS. Adjust the balance on the bank statements to the corrected balance. ADJUST THE CASH ACCOUNT. COMPARE THE BALANCES.
0:11 33:08 How to prepare Bank Reconciliation Statement in excel - YouTube YouTube Start of suggested clip End of suggested clip Amount amount we have balance as per cash flow then we have some transactions. And then we haveMoreAmount amount we have balance as per cash flow then we have some transactions. And then we have balance as for bank statement as on 1st March 2019. Then we have bank statement for the month of March.
How to do bank reconciliation Get bank records. You need a list of transactions from the bank. Get business records. Open your ledger of income and outgoings. Find your starting point. Run through bank deposits. Check the income on your books. Run through bank withdrawals. Check the expenses on your books. End balance.
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.