How often should reconciliations be performed?

Monthly reconciliations are standard for cash accounts; higher-risk or high-volume accounts may require weekly reviews. Timely reconciliation reduces error propagation and improves cash forecasting.

What if a bank transaction is missing?

Investigate bank timing, contact the bank for clearing status, and document a temporary reconciling item. If unresolved after the next statement, escalate for research and corrective entries.

Can the worksheet be signed electronically?

Yes. Electronic signatures are legally valid under the ESIGN Act (15 U.S.C. ch. 96) and UETA where adopted, provided intent, consent, attribution, and record retention requirements are met.

What supporting documents should I attach?

Attach the bank statement page, deposit slips, check images, and any memos or vendor confirmations that explain reconciling amounts to provide clear audit evidence.

How long must reconciliations be kept?

Retain reconciliations per IRS guidance (typically 3 years) and any longer industry or state requirements; healthcare entities should follow HIPAA retention rules of six years.

Who should sign and review the worksheet?

A preparer should complete the worksheet and a separate reviewer or manager should approve it to maintain segregation of duties and strengthen internal controls.

Electronic Signature
Templates
Other
Bank Reconciliation Worksheet

Bank Reconciliation Worksheet

This template is fully customizable. Edit the text, fill out the fields, and send it for signature. Give it a try!

What the Bank Reconciliation Worksheet Is and when it’s used

A Bank Reconciliation Worksheet is an internal accounting document used to compare an entity's cash book balance to the bank statement balance and to explain any differences. It lists deposits in transit, outstanding checks, bank fees, interest, and adjustments so the general ledger and bank statement match. The worksheet supports month-end close, internal controls, and audit trails by summarizing reconciling items, referencing supporting source documents, and recording the preparer and review steps for later verification.

Why a clear worksheet matters for accuracy and controls

A well-prepared Bank Reconciliation Worksheet reduces reconciliation time, highlights cash discrepancies quickly, and documents adjustments for auditors and management. Clear worksheets improve internal controls, support tax reporting, and make fraud or timing errors easier to detect during monthly close procedures.

Typical users and reviewers of the worksheet

Use a consistent template and documented review steps to create an auditable trail for month-end close and external review.

Staff Accountant: Prepares the worksheet, matches ledger entries to bank transactions, and documents reconciling items for each cash account.
Accounting Manager: Reviews reconciliations, confirms adjustments, and flags unusual items for investigation or audit.
CFO/Controller: Approves month-end reconciliations, ensures policy compliance, and signs off for financial reporting or audit purposes.

Core parts of a professional Bank Reconciliation Worksheet

A complete worksheet separates bank and book items, lists reconciling entries with references, and records preparer and approver names and dates. Use structured rows, calculation fields, and a final reconciled balance that matches both sources after adjustments.

Bank Statement Summary

Record the statement ending date and ending balance, including the bank account number or identifier for clear cross-reference.

Book (Ledger) Balance

Enter the general ledger balance per the cash account as of the statement date, including any unposted internal journal entries.

Deposits in Transit

List deposits recorded in the books but not yet reflected on the bank statement; include dates, amounts, and deposit slips.

Outstanding Checks

List checks issued but not yet cleared by the bank, including check numbers, payees, and amounts for traceability.

Bank Adjustments

Record bank fees, NSF checks, interest, and direct deposits shown on the statement but not in the ledger, with source docs referenced.

Reconciliation Notes

Provide brief explanations for significant reconciling items and link to supporting documents or subsequent corrective journal entries.

Step-by-step: filling out the Bank Reconciliation Worksheet

Follow a consistent sequence each month to minimize errors and speed review: gather documents, compare, list reconciling items, and record adjustments.

01

Gather documents: Collect ledger detail, bank statement, deposit slips, and cancelled checks.
02

Compare balances: Confirm statement ending balance versus ledger balance before adjustments.
03

List reconciling items: Record deposits in transit, outstanding checks, and bank-only entries.
04

Post adjustments: Enter corrective journal entries and mark worksheet as reconciled with dates.

Where the worksheet fits in the month-end flow

The worksheet sits between bank statement receipt and final general ledger close; it triggers required journal entries and manager approvals.

Receive Statement: Obtain electronic or paper bank statement for the period and confirm statement date.
Prepare Worksheet: Populate bank and book balances, list reconciling items, and attach supporting documents.
Review and Approve: Manager reviews line items, signs off, and authorizes journal entries.
Post Entries: Enter adjustments in the ledger and confirm the reconciled balance matches bank records.

Customizing the worksheet in an online workflow

When building an online template, configure fields, calculation rules, and signer roles to reflect your internal approval process.

Field	Configuration
Auto-calculation formulas	Enable formulas to sum deposits, subtract checks, and show reconciled balance automatically.
Conditional fields	Show explanation boxes only when amounts exceed predefined thresholds.
Signer order	Set preparer first, reviewer second for sequential approvals.
Notifications	Email or in-app alerts for pending reviews and overdue reconciliations.

How to e-submit and distribute reconciliations

Ensure the platform preserves an audit trail and stores a timestamped signed copy for compliance and future audit requests.

File formats: PDF or Excel for calculation and archiving.
Integrations: Connect to ERP or cloud storage for automatic archiving.
Authentication: Use email, SMS, or stronger methods for reviewer identity.

Common eSignature vendor comparison for worksheet approvals

Comparison of typical plan features and starting prices across vendors; signNow appears first per vendor ordering requirements.

	signNow	DocuSign	Adobe Sign	PandaDoc	HelloSign
Starting Price	$8/user/mo	$15/user/mo	$14/user/mo	$19/user/mo	$15/user/mo
Free Trial	7-day free trial, no credit card	Varies by plan	Varies by plan	Varies by plan	Varies by plan
Bulk Send	Yes	Yes	Yes	Yes	Varies by plan
Audit Trail	Yes	Yes	Yes	Yes	Yes
HIPAA Compliant	Yes (BAA required)	Yes (BAA available)	Yes (BAA available)	Varies by plan	Varies by plan
Envelope Cap	No cap	100 envelopes/user/year	Varies	Varies	Varies

Practical tips to keep reconciliations accurate and auditable

Apply consistent procedures, clear documentation, and a two-person review to reduce errors and improve audit readiness.

Use a standard template

Adopt a single worksheet layout across accounts and months so reviewers can quickly validate entries and reconciliations without searching for fields.

Attach supporting documents

Always link the bank statement page, deposit slips, check images, and journal entries to the worksheet to provide immediate evidence during review or audit.

Automate calculations

Where possible, use spreadsheet formulas or online fields to compute totals and highlight variances; manual math increases the risk of transposition errors.

Apply segregation of duties

Have one person prepare the worksheet and a different person review and approve to strengthen internal controls and deter fraud.

Common mistakes to avoid when preparing reconciliations

Failing to match transaction dates, which creates phantom reconciling items and delays closure.
Leaving reconciling items unexplained for multiple periods, increasing audit risk and hiding recurring errors.
Recording journal entries without supporting documentation, making audits and investigations time consuming.
Relying on manual calculations without cross-checks, which raises the chance of arithmetic or transposition mistakes.

Risks and downstream penalties from incorrect reconciliations

Tax Reporting Risk: Incorrect 1099 filings can trigger IRC §6721 penalties

Audit Exposure: Unexplained variances increase the chance of a formal audit

Cash Misstatement: Misstated cash affects financial statements and covenants

Fraud Detection Delay: Slow reconciliations delay discovery of unauthorized transactions

Late Adjustments: Late journal entries can distort interim reporting

Backup Withholding: Incorrect TINs may trigger backup withholding at 24%

Security and compliance considerations for electronic worksheets

Encryption in Transit: TLS 1.2/1.3

Encryption at Rest: AES-256

Audit Trail: Detailed timestamps and action logs

HIPAA Support: BAA available where required

ESIGN / UETA: Compliant for electronic signatures

Certifications: SOC 2 Type II / ISO 27001

How different organizations use digital reconciliation approval workflows

Real organizations report faster processing and simpler approvals after moving reconciliation sign-off into a secure digital workflow.

Optica Ventures — Finance

A small finance team moved approvals online to reduce paper routing and reviewer delays.

"The interface is simple and easy-to-use for our team; more importantly, it is just as easy for our customers."
The streamlined workflow decreased time-to-approval and improved documentation for monthly close and external review.

Martin Properties — Real Estate

A property manager used digital signatures to finalize reconciliation approvals remotely during month-end.

"I can process and execute all of these documents online with 100% compliance and built-in security."
The configuration supported mobile review and retained timestamped evidence for audits and lender requests.

Typical timing expectations and recommended deadlines

Set clear monthly deadlines for reconciliation completion, review, and posting to keep the close process predictable and auditable.

Monthly Reconciliation Due Date:

Complete reconciliations within 15–30 days after month-end depending on company policy.

Reviewer Sign-off:

Require manager approval within 5 business days of worksheet submission.

Journal Entry Posting:

Post approved adjustments before the final close of the reporting period.

Quarterly Audit Review:

Retain reconciliations for internal audit sampling each quarter.

Annual Archive:

Archive reconciliations to long-term storage after year-end close and validation.

Frequently asked questions about completing and storing the worksheet

Answers to common questions about frequency, missing items, signature validity, and record retention for Bank Reconciliation Worksheets.

Need help? Contact support

How often should reconciliations be performed?
Monthly reconciliations are standard for cash accounts; higher-risk or high-volume accounts may require weekly reviews. Timely reconciliation reduces error propagation and improves cash forecasting.
What if a bank transaction is missing?
Investigate bank timing, contact the bank for clearing status, and document a temporary reconciling item. If unresolved after the next statement, escalate for research and corrective entries.
Can the worksheet be signed electronically?
Yes. Electronic signatures are legally valid under the ESIGN Act (15 U.S.C. ch. 96) and UETA where adopted, provided intent, consent, attribution, and record retention requirements are met.
What supporting documents should I attach?
Attach the bank statement page, deposit slips, check images, and any memos or vendor confirmations that explain reconciling amounts to provide clear audit evidence.
How long must reconciliations be kept?
Retain reconciliations per IRS guidance (typically 3 years) and any longer industry or state requirements; healthcare entities should follow HIPAA retention rules of six years.
Who should sign and review the worksheet?
A preparer should complete the worksheet and a separate reviewer or manager should approve it to maintain segregation of duties and strengthen internal controls.

Explore Templates

Industrial Contractor Agreement Structure Erection Contractor Agreement Foundation Contractor Agreement Air Filtration Contractor Agreement Fireplace Contractor Agreement Last Will and Testament FAQ

be ready to get more

Join over 28 million airSlate SignNow users

Sign Now