Can a bank reconciliation be signed electronically?

Yes. Electronic signatures meet ESIGN and UETA standards when intent, consent, attribution, and retention are present. Document the signer, timestamp, and method to support legal validity under 15 U.S.C. ch. 96 and applicable state UETA rules.

What proof should accompany reconciliations for audit?

Provide the bank statement, copies of deposits, cancelled checks or check images, a clear list of reconciling items, and the signed reconciliation showing preparer and reviewer names and dates for traceability.

How long must reconciliations be retained?

Follow federal and industry rules: retain at least three years for tax records under IRC §6501(a); retain six years for documents containing PHI per 45 CFR §164.530(j); consider longer retention for contract or real estate matters.

What authentication level is recommended for reviewer sign-off?

Use at minimum email-based authentication with an audit trail; for higher assurance, enable multi-factor authentication or organization SSO to strengthen signer attribution.

How do I fix a previously approved reconciliation with errors?

Document a correcting reconciliation showing original and corrected figures, post compensating journal entries where required, and obtain reviewer acknowledgment to preserve audit history.

Which file format is best for long-term storage?

Archive final signed reconciliations as PDF/A to preserve layout and embedded signatures; retain editable spreadsheet copies separately if you need to preserve formulas and source calculations.

Electronic Signature
Templates
Finance
Bank Reconciliation Template

Bank Reconciliation Template

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

BANK RECONCILIATION TEMPLATE

Entity and Record Identification

Company Name:

Department / Location Bank / Account Information

Statement Period From:

To:

Balances and Summary

Bank Statement Date:

Balances (amounts in local currency)

Deposits in Transit

Record deposits received and reflected on the ledger but not yet cleared by the bank.

Date	Source / Description	Amount

Total Deposits in Transit

Outstanding Checks

List checks issued and recorded in the ledger that have not cleared the bank.

Check No.	Check Date	Payee	Amount

Total Outstanding Checks

Other Bank Adjustments

Record bankside items such as service charges, interest income, NSF checks, or bank corrections that appear on the statement but are not recorded in the ledger.

Date	Description	Amount (use negative for deductions)

Total Bank-Side Adjustments

Reconciliation Summary

Compute the adjusted bank balance and adjusted book balance. All additions are indicated as positive amounts; subtractions should be entered as negative amounts.

Bank Statement Balance:

+ Deposits in Transit:

- Outstanding Checks:

+/- Other Bank Adjustments:

Adjusted Bank Balance Book (Ledger) Balance and Book Adjustments Total Book Adjustments Adjusted Book Balance Reconciliation Difference (Adjusted Bank - Adjusted Book)

Supporting Documentation and Certification

The preparer and reviewer affirm that all reconciling items are supported by appropriate documentation (copies of bank statement, cleared checks, deposit slips, journal entries, and other corroborating records). Check all that apply and attach documentation to the reconciliation file.

Bank statement attached

Cleared checks / images attached

Deposit slips / remittance advices attached

Journal entries recorded for ledger adjustments

Reconciliation Notes / Explanations

Certification: I certify that this bank reconciliation has been prepared in accordance with the entity's accounting policies, is based on the bank statement(s) and the general ledger for the period indicated, and that all reconciling items have been investigated or will be investigated and resolved in a timely manner. Any adjustments required to record bank charges, NSF transactions, interest, or errors will be recorded in the accounting records with appropriate approvals.

Preparer Name:

By:

Date:

Reviewer Name:

By:

Date:

What a Bank Reconciliation Template Is and when it's used

A Bank Reconciliation Template is a standardized spreadsheet or form used to compare a company's cash book (general ledger) against the bank statement for a specific period. It identifies timing differences such as deposits in transit and outstanding checks as well as errors, bank fees, and interest. The template documents adjustments needed to reconcile the book balance to the bank balance, records explanations for each reconciling item, and provides a dated, signed record for internal controls, audit trails, and financial reporting.

Why a consistent template matters for accuracy and auditability

A clear Bank Reconciliation Template reduces errors, speeds monthly close, and creates an auditable trail for reviewers and regulators. It standardizes calculations and explanations so managers and auditors can verify cash positions without reworking entries.

Who typically completes and reviews bank reconciliations

Role clarity helps ensure separation of duties and reduces fraud risk.

Staff accountant or bookkeeper responsible for preparing the reconciliation and entering adjustments into the general ledger.
Controller or finance manager who reviews and approves reconciliations for month-end close and financial reporting.
Internal or external auditors who examine reconciliations as part of control testing and audit evidence.

Essential sections to include in a professional template

A robust template groups data, calculations, and supporting notes so a reviewer can trace balances and adjustments quickly.

Header

Company name, account name, bank name, account number (masked), and statement ending date for clear identification and recordkeeping.

Statement Balance

Bank statement ending balance with line for outstanding deposits and checks, and any bank adjustments such as errors or returned items.

Book Balance

General ledger cash balance plus journal entries, adjustments, and reconciling items required to reach the adjusted book balance.

Reconciling Items

Itemized list (date, description, amount, category) for outstanding checks, deposits in transit, bank charges, NSF items, and timing differences.

Adjustments

Journal entries required to correct ledger or bank errors with reference numbers to source documents and approval fields.

Sign-off

Prepared-by, reviewed-by, dates, and space for notes to document who validated calculations and why adjustments were made.

Step-by-step: complete the reconciliation in four tasks

Follow these sequential steps to reconcile the ledger to the bank statement and document adjustments clearly.

01

Collect Records: Obtain the bank statement, general ledger cash detail, and any deposit/clearing reports.
02

Match Transactions: Compare statement items to ledger entries and mark matches; flag timing differences and exceptions.
03

List Reconciling Items: Record deposits in transit, outstanding checks, bank errors, fees, interest, and NSF items with amounts.
04

Adjust and Sign: Post required journal entries, update ledger, and obtain preparer and reviewer signatures and dates.

How to customize the template for online workflows

Configure fields, approvals, and integrations so reconciliations can be completed and retained digitally with minimal manual steps.

Field	Configuration
Statement Date Field	Set to MM/DD/YYYY with validation to prevent future dates.
Amount Fields	Numeric format with two decimals and automatic sum formulas.
Attachment Field	Allow PDF upload for bank statement and supporting docs.
Approval Flow	Sequential signer order: preparer then reviewer with timestamped audit trail.

Digital distribution and platform considerations

Ensure chosen platform supports audit trails, secure storage, and export to standard archival formats.

Formats Supported: Use PDF or Excel (XLSX) for records and formulas; PDF is preferred for final archived copies.
Integrations: Connectors with ERP/GL systems reduce duplicate data entry and preserve references.
Authentication: Use email or stronger signer authentication for reviewer sign-offs to improve attribution.

Where reconciliations are stored and who receives final copies

Routing rules determine where reconciliations are filed and which stakeholders receive copies after approval.

Accounting Ledger: Post adjustment journal entries to the general ledger with reference numbers.
Controller Folder: Store signed reconciliations in a centralized shared drive or document management system.
Auditor Access: Provide read-only copies and audit trail links to internal or external auditors.
Bank Attachments: Retain the original bank statement and digital attachment for cross-reference.

Timing best practices and close-cycle expectations

Consistent timing helps meet reporting deadlines and supports timely detection of anomalies.

Monthly Close Target:

Complete reconciliations within 10 business days after statement close for timely reporting.

High-Risk Accounts:

Reconcile weekly or daily for payroll and cash concentration accounts to reduce fraud risk.

Audit Requests:

Provide requested reconciliations within auditor timelines; typical response windows are 5–10 business days.

Quarterly Review:

Controllers should perform a quarterly sample review of reconciliations for controls testing.

Retention Start:

Retention period begins on reconciliation date or date of final approval, whichever is later.

Common mistakes to avoid when preparing reconciliations

Omitting supporting documents such as deposit slips or bank advice, which prevents verification and delays audit reviews.
Failing to record bank fees, NSF checks, or direct debits in the ledger, leading to persistent unreconciled variances.
Using inconsistent date formats or rounding rules between bank and ledger data, which results in small unexplained differences.
Not obtaining a separate reviewer sign-off, weakening segregation of duties and increasing control risk.

Risks and potential downstream consequences of incorrect reconciliations

Financial Misstatement: May lead to misstated cash balances and incorrect financial reporting.

Audit Findings: Auditors may report control deficiencies or substantive misstatements.

Regulatory Exposure: Inaccuracies can trigger regulatory inquiries in regulated industries.

Tax Impact: Errors can affect tax filings and associated liabilities.

Fraud Risk: Unreconciled items may conceal unauthorized transactions.

Operational Delay: Inefficient reconciliations slow month-end close processes.

Data and security considerations for storing reconciliation files

Encryption: TLS 1.2/1.3 in transit; AES-256 at rest.

Access Controls: Role-based permissions and least-privilege access.

Audit Trail: Timestamped actions and signer attribution recorded.

Retention Policy: Automated archival and deletion workflows.

Compliance: Support for ESIGN, UETA, and HIPAA where applicable.

File Formats: PDF/A for long-term archival compatibility.

Selected eSignature pricing and capability snapshot for reconciliation workflows

Compare basic pricing and a few capability markers relevant to high-volume reconciliation processes without implying endorsement.

	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 required	No	No	Yes, limited	Yes, limited
Bulk Send	Yes	Yes	Yes	Yes	No
Audit Trail	Yes	Yes	Yes	Yes	Yes
HIPAA Compliant	Yes	Yes	Yes	No	No

Frequently asked questions about the Bank Reconciliation Template and eSigning

Answers to common questions about use, e-signature legality, storage, and troubleshooting for reconciliation records.

Need help? Contact support

Can a bank reconciliation be signed electronically?
Yes. Electronic signatures meet ESIGN and UETA standards when intent, consent, attribution, and retention are present. Document the signer, timestamp, and method to support legal validity under 15 U.S.C. ch. 96 and applicable state UETA rules.
What proof should accompany reconciliations for audit?
Provide the bank statement, copies of deposits, cancelled checks or check images, a clear list of reconciling items, and the signed reconciliation showing preparer and reviewer names and dates for traceability.
How long must reconciliations be retained?
Follow federal and industry rules: retain at least three years for tax records under IRC §6501(a); retain six years for documents containing PHI per 45 CFR §164.530(j); consider longer retention for contract or real estate matters.
What authentication level is recommended for reviewer sign-off?
Use at minimum email-based authentication with an audit trail; for higher assurance, enable multi-factor authentication or organization SSO to strengthen signer attribution.
How do I fix a previously approved reconciliation with errors?
Document a correcting reconciliation showing original and corrected figures, post compensating journal entries where required, and obtain reviewer acknowledgment to preserve audit history.
Which file format is best for long-term storage?
Archive final signed reconciliations as PDF/A to preserve layout and embedded signatures; retain editable spreadsheet copies separately if you need to preserve formulas and source calculations.

be ready to get more

Join over 28 million airSlate SignNow users

Sign Now