Form preview

Get the free bank reconciliation worksheet template

Get Form
Monthly Bank Reconciliation WorksheetBank Statement Date: / / Ending Balance from Bank Statement:$ Add Deposits in Transit:$ Total Deposits in Transit:$ Subtract Outstanding Checks:$ Total Outstanding
We are not affiliated with any brand or entity on this form

Get, Create, Make and Sign

Edit
Edit your bank reconciliation worksheet template form online
Type text, complete fillable fields, insert images, highlight or blackout data for discretion, add comments, and more.
Add
Add your legally-binding signature
Draw or type your signature, upload a signature image, or capture it with your digital camera.
Share
Share your form instantly
Email, fax, or share your bank reconciliation worksheet template form via URL. You can also download, print, or export forms to your preferred cloud storage service.

Editing bank reconciliation worksheet online

9.5
Ease of Setup
pdfFiller User Ratings on G2
9.0
Ease of Use
pdfFiller User Ratings on G2
Here are the steps you need to follow to get started with our professional PDF editor:
1
Set up an account. If you are a new user, click Start Free Trial and establish a profile.
2
Simply add a document. Select Add New from your Dashboard and import a file into the system by uploading it from your device or importing it via the cloud, online, or internal mail. Then click Begin editing.
3
Edit bank reconciliation worksheet statement form. Replace text, adding objects, rearranging pages, and more. Then select the Documents tab to combine, divide, lock or unlock the file.
4
Save your file. Select it from your records list. Then, click the right toolbar and select one of the various exporting options: save in numerous formats, download as PDF, email, or cloud.
With pdfFiller, it's always easy to work with documents. Try it out!

How to fill out bank reconciliation worksheet template

Illustration

How to fill out bank reconciliation worksheet?

01
Gather all necessary financial documents, including bank statements, check stubs, deposit slips, and any other relevant records.
02
Compare the ending balance on the bank statement to the ending balance in your general ledger. Note any discrepancies.
03
Identify any outstanding checks or deposits that have not yet cleared the bank. These should be listed in the appropriate sections of the worksheet.
04
Adjust the bank statement balance for any bank errors or fees. Make the necessary adjustments in the worksheet.
05
Verify the accuracy of the recorded transactions by comparing them to the corresponding entries on the bank statement. Make any necessary adjustments.
06
Complete the reconciliation by calculating the adjusted bank balance and comparing it to the adjusted book balance. Ensure that the two balances match.

Who needs bank reconciliation worksheet?

01
Businesses of all sizes use bank reconciliation worksheets to ensure the accuracy and completeness of their financial records.
02
Non-profit organizations also rely on bank reconciliation worksheets to reconcile their accounts and track their financial transactions.
03
Individuals who manage their own finances can benefit from using bank reconciliation worksheets to keep track of their bank transactions and detect any errors or discrepancies.

What is bank reconciliation worksheet Form?

The bank reconciliation worksheet is a writable document that should be submitted to the required address in order to provide some information. It must be completed and signed, which is possible manually, or via a certain solution e. g. PDFfiller. This tool allows to complete any PDF or Word document directly in your browser, customize it depending on your needs and put a legally-binding electronic signature. Right after completion, you can send the bank reconciliation worksheet to the relevant individual, or multiple individuals via email or fax. The blank is printable too from PDFfiller feature and options offered for printing out adjustment. In both electronic and physical appearance, your form will have got clean and professional outlook. You can also save it as the template for later, without creating a new document over and over. You need just to customize the ready document.

Template bank reconciliation worksheet instructions

Once you're about filling out bank reconciliation worksheet .doc form, be sure that you have prepared enough of information required. That's a important part, as far as typos may trigger unwanted consequences from re-submission of the full word template and filling out with deadlines missed and you might be charged a penalty fee. You need to be careful when writing down digits. At first glance, this task seems to be quite simple. But nevertheless, it is easy to make a mistake. Some people use such lifehack as keeping everything in a separate document or a record book and then put it into document's template. Nevertheless, try to make all efforts and provide accurate and correct info in your bank reconciliation worksheet .doc form, and check it twice during the process of filling out all fields. If you find a mistake, you can easily make some more amends while using PDFfiller editing tool without blowing deadlines.

bank reconciliation worksheet: frequently asked questions

1. Can I fill out personal word forms on the web safely?

Products working with such an information (even intel one) like PDFfiller do care about you to be satisfied with how secure your files are. They include the following features:

  • Private cloud storage where all information is kept protected with sophisticated encryption. This way you can be sure nobody would have got access to your personal information but yourself. Disclosure of the information by the service is strictly prohibited all the way.
  • To prevent forgery, every file obtains its unique ID number once signed.
  • If you think this is not safe enough for you, set additional security features you prefer then. They manage you to request the two-factor authentication for every person trying to read, annotate or edit your file. In PDFfiller you can store writable forms in folders protected with layered encryption.

2. Have never heard of e-signatures. Are they similar comparing to physical ones?

Yes, it is absolutely legal. After ESIGN Act released in 2000, a digital signature is considered legal, just like physical one is. You can fill out a word file and sign it, and it will be as legally binding as its physical equivalent. While submitting bank reconciliation worksheet form, you have a right to approve it with a digital solution. Make sure that it suits to all legal requirements as PDFfiller does.

3. I have a sheet with some of required information all set. Can I use it with this form somehow?

In PDFfiller, there is a feature called Fill in Bulk. It helps to make an export of data from the available document to the online template. The big yes about this feature is, you can use it with Excel sheets.

Fill reconciliation worksheet template : Try Risk Free

Rate free reconciliation worksheet pdf form

4.4
Satisfied
48 Votes

For pdfFiller’s FAQs

Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.

The person or entity responsible for reconciling the bank accounts must file the bank reconciliation worksheet. This is typically performed by the accounting department or a designated financial professional within the organization.
To fill out a bank reconciliation worksheet, follow these steps: 1. Gather necessary information: Collect your bank statement (received from your bank) and any supporting documents, such as canceled checks or deposit slips. 2. Compare statement with records: Start with opening balances on both the bank statement and your own records. Make sure they match. Then, compare each transaction listed on the bank statement with your own records, marking off items that match. 3. Identify discrepancies: If any items on the bank statement do not match your records, identify the discrepancies. This can include outstanding checks, deposits in transit, bank errors, or transactions you may have forgotten to record. 4. Adjustments for outstanding checks: If any checks from your records appear on the bank statement as "outstanding," deduct them from your ending balance. 5. Adjustments for deposits in transit: If any deposits from your records appear on the bank statement as "deposits in transit," add them to your ending balance. 6. Account for bank errors: If the bank has made an error, such as recording transactions incorrectly, notify them and adjust your records accordingly. 7. Record adjustments: Once you have identified all discrepancies and adjusted accordingly, record these adjustments on your reconciliation worksheet. This includes adding or subtracting amounts as necessary. 8. Calculate adjusted ending balance: Add or subtract the adjustments made to the beginning balance to determine the adjusted ending balance. 9. Compare balances: Compare the adjusted ending balance on your reconciliation worksheet to the ending balance listed on the bank statement. They should match if all adjustments have been recorded correctly. 10. Note any remaining discrepancies: If there are still discrepancies, double-check all entries and calculations. It is essential to resolve any discrepancies before finalizing the reconciliation. 11. Prepare a final bank reconciliation report: Once all adjustments are accounted for, prepare a final bank reconciliation report that summarizes the reconciliation process and displays the corrected balances. Remember, accuracy is crucial when filling out a bank reconciliation worksheet. Double-check your calculations and ensure all adjustments are accounted for.
The purpose of a bank reconciliation worksheet is to compare the bank statement and the company's own records, such as a general ledger, to identify and rectify any discrepancies between the two. This process helps ensure that the company's financial records are accurate and complete. It also helps to detect any errors or fraudulent activities such as unauthorized transactions or missing deposits. Overall, the bank reconciliation worksheet ensures the accuracy of the company's financial statements and provides a clear picture of its cash position.
The following information must be reported on a bank reconciliation worksheet: 1. Bank statement balance: This is the ending balance as shown on the bank statement. 2. Outstanding checks: These are checks that have been written and deducted from the bank account but have not yet cleared the bank. 3. Deposits in transit: These are deposits that have been made but have not yet been recorded by the bank. 4. Bank errors: If there are any errors made by the bank in recording transactions, they need to be identified and adjusted. 5. Adjusted bank balance: This is the adjusted balance after considering outstanding checks, deposits in transit, and any bank errors. 6. Book balance: This is the balance as shown on the company's books or accounting records. 7. Adjustments to book balance: Any other adjustments or reconciling items that need to be made to align the book balance with the adjusted bank balance. 8. Adjusted book balance: This is the adjusted balance after considering any adjustments to the book balance. 9. Reconciling items: These are the differences between the adjusted bank balance and the adjusted book balance, which need to be identified and resolved. By comparing these items, the bank reconciliation worksheet helps to ensure that the company's records are accurate and complete and that any discrepancies between the bank statement and the company's records are identified and resolved.
The penalty for the late filing of a bank reconciliation worksheet can vary depending on the specific circumstances and regulations of the bank or financial institution involved. In some cases, there may be no specific penalty outlined, but the late filing could result in other consequences such as the suspension of certain banking services or the imposition of fees. It is best to refer to the terms and conditions provided by the bank or consult with a representative for accurate information regarding any penalties associated with late filing of bank reconciliation worksheets.
pdfFiller allows you to edit not only the content of your files, but also the quantity and sequence of the pages. Upload your bank reconciliation worksheet statement form to the editor and make adjustments in a matter of seconds. Text in PDFs may be blacked out, typed in, and erased using the editor. You may also include photos, sticky notes, and text boxes, among other things.
Get and add pdfFiller Google Chrome Extension to your browser to edit, fill out and eSign your bank reconciliation worksheet template, which you can open in the editor directly from a Google search page in just one click. Execute your fillable documents from any internet-connected device without leaving Chrome.
Yes, you can. With the pdfFiller mobile app, you can instantly edit, share, and sign reconciliation worksheet pdf form on your iOS device. Get it at the Apple Store and install it in seconds. The application is free, but you will have to create an account to purchase a subscription or activate a free trial.

Fill out your bank reconciliation worksheet template online with pdfFiller!

pdfFiller is an end-to-end solution for managing, creating, and editing documents and forms in the cloud. Save time and hassle by preparing your tax forms online.

Get started now
Form preview