Establishing secure connection…Loading editor…Preparing document…

Securities Reconciliation Form

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

SECURITIES RECONCILIATION FORM

Account & Reconciliation Period

Account Name:

Account Number:      Custodian Name:

Reconciliation Period From:    To:    Reconciliation Date:

Summary of Balances

Book Total Market Value:    Custody Total Market Value:

Total Quantity (Book):    Total Quantity (Custody):    Net Difference (Value):

Reconciliation Result:

Detailed Securities Schedule

List each security and provide quantities & values as recorded in internal books and as reported by the custodian. Include all reconciling items in the following section.

CUSIP / ISIN Security Description Qty (Book) Qty (Custody) Price Value (Book) Value (Custody) Qty Diff Value Diff

Subtotal (Book):    Subtotal (Custody):

Reconciling Items / Adjustments

Record each reconciling item explaining the cause, associated documentation, and proposed clearing action. Items not cleared within five business days must be escalated per internal policy.

Date Description / Reason Amount Reference (Trade ID / Memo) Responsible

Exceptions & Action Items

List unresolved exceptions with required remedial actions, owner, and expected resolution date. Items that remain open beyond the stated resolution date must be escalated to management.

Supporting Documentation

Attach or reference supporting schedules, trade confirmations, custody statements, and clearing memos that substantiate the reconciliation and each reconciling item.

Supporting Documents Reference:

Certification & Representation

I certify that the information provided above is true, complete and accurate to the best of my knowledge. I further certify that this reconciliation was prepared in accordance with applicable internal control procedures and that all material differences have been investigated. Any unresolved items are disclosed in this form and will be escalated in accordance with the firm’s escalation procedures.

By signing below the preparer and reviewer each attest that they have executed all appropriate inquiries and performed the procedures required by policy to support the reconciliation as of the Reconciliation Date. Deliberate misstatement or omission of reconciliation items may result in disciplinary action.

Preparer / Reviewer Information

Preparer:

By:

Date:

Reviewer / Approver:

By:

Date:

Enter text

What the Securities Reconciliation Form Is and when it applies

The Securities Reconciliation Form is a standardized record used to compare and reconcile positions, transactions, and cash balances for brokerage accounts, custodial ledgers, or internal trading books. It documents opening and closing balances, trade details, corporate actions, fees, and any adjustments required to align internal records with custodial or counterparty statements. Organizations use the form to support monthly and periodic reconciliations, audit trails, regulatory reporting, and internal controls. Accurate reconciliation reduces settlement risk, supports regulatory compliance, and creates a defensible record for audits and investor inquiries.

Why a formal reconciliation form matters

A consistent Securities Reconciliation Form provides an auditable record that strengthens control environment, reduces operational loss risk, and supports compliance with recordkeeping rules applicable to brokers, advisors, and custodians.

Why a formal reconciliation form matters

Who completes and reviews the Securities Reconciliation Form

The form is typically prepared by middle- or back-office teams and reviewed by compliance, finance, or internal audit before final sign-off.

  • Operations teams responsible for trade capture and settlement reconciliation; they prepare line-by-line matching and document variances.
  • Compliance and risk teams that verify exceptions, approve adjustments, and maintain regulatory evidence for inspections.
  • Portfolio managers or desk controllers who review material breaks, validate position accuracy, and authorize any manual corrections.

Final sign-off should come from an authorized approver documented on the form, and copies must be retained according to applicable retention policies.

Primary signers and reviewers

Portfolio Manager

A portfolio manager reviews material discrepancies and approves adjustments. They attest that reconciled positions reflect investment decisions and that any exceptions are understood and managed. Their signature or electronic approval ties the reconciliation to decision-making authority and supports client reporting.

Compliance Officer

A compliance officer or designee verifies that reconciliations meet regulatory standards, documents remediation of breaks, and signs to confirm adherence with internal controls, supervisory procedures, and recordkeeping obligations.

Essential data fields to include

Account Number: Unique account identifier
Security Identifier: CUSIP or ISIN
Description: Security name and class
Quantity: Shares or units
Market Value: Price × quantity
Reconciliation Date: Statement date reconciled

Step-by-step: completing the Securities Reconciliation Form

Follow these sequential steps for a complete, auditable reconciliation that aligns internal records with statements and identifies exceptions.

  • 01
    1. Gather source data: Collect internal ledger, custodian statement, trade blotter, and fee reports.
  • 02
    2. Match line items: Match quantities and values by security identifier and trade date.
  • 03
    3. Document breaks: Record exceptions, their cause, and required corrective actions.
  • 04
    4. Review and sign: Obtain reviewer approval and retain the completed form with audit trail.

Configuring an online reconciliation workflow

Set up fields and routing once to reduce manual steps and ensure consistent approval sequencing.

Field Configuration
Upload Template Use a PDF/Word template with named fields
Assign Signers Define preparer, reviewer, and approver roles
Authentication Choose email or two-factor authentication
Notification Settings Enable reminders and escalation routing

Where to send and how routing typically works

Routing destinations and handoffs determine who receives the form and how signed copies are archived.

  • Prepare File: Upload completed form with supporting attachments
  • Assign Reviewers: Send to compliance and accounting in parallel or sequence
  • Sign and Approve: Authorized parties eSign and date the form
  • Archive: Store signed record in secure repository with audit trail

Technical requirements for electronic completion and sharing

Use a platform that supports PDF and DOCX templates, audit trails, and integrations with cloud storage and ERP systems.

  • File formats: PDF, DOCX, XLSX supported
  • Integrations: Salesforce, NetSuite, Microsoft 365
  • Authentication: Email, SMS, or stronger MFA

Ensure the chosen solution provides tamper-evident signed documents, secure storage (AES-256), and an exportable audit trail to meet internal and regulatory recordkeeping requirements.

Common timelines and reporting cadence to follow

Reconciliations commonly follow monthly and quarterly schedules; some items require immediate investigation and reporting to management.

Monthly Cutoff:

Complete reconciliations within 5–10 business days after month end

Quarterly Review:

Senior review and exception sign-off during quarter close

Year-end Close:

Finalize reconciliations to support audited financial statements

Regulatory Reporting:

Retain evidence aligned with regulator schedules and requests

Ad hoc Investigations:

Investigate material breaks immediately and document remediation

Frequent mistakes to avoid when preparing the form

  • Using inconsistent security identifiers (ticker vs CUSIP) that prevent automated matching and create false exceptions requiring manual review.
  • Rounding and pricing mismatches where market price sources differ and currency conversions are not documented, leading to unexplained variances.
  • Failing to attach supporting documentation such as trade confirmations or corporate action notices, which lengthens resolution time and weakens audit evidence.
  • Delaying reconciliation beyond established cutoffs so that stale exceptions grow larger and create increased operational and reporting risk.

Risks and potential consequences of incorrect reconciliation

Regulatory Fines: Fines or enforcement by regulators
Audit Findings: Control deficiencies noted by auditors
Investor Disputes: Client claims and remediation costs
Operational Loss: Settlement losses from unresolved breaks
Reputational Harm: Negative impact on trust and business
Reporting Errors: Misstated financial disclosures

Comparison: eSignature vendor pricing and basic features

This table compares base starting prices and feature availability for common eSignature vendors relevant to handling Securities Reconciliation Forms.

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 Varies by vendor Varies by vendor Varies by vendor Varies by vendor
Bulk Send Yes Yes Yes Yes No
Audit Trail Yes Yes Yes Yes Yes
HIPAA Compliant Yes Yes Yes No No

Real-world examples of reconciliation workflows

Two concise examples show how organizations use the form to resolve breaks and document approvals.

Martin Properties

A regional property manager standardized monthly reconciliations to reduce settlement differences.

  • The team automated template routing to replace paper signoffs.
  • "I can process and execute all of these documents online with 100% compliance and built-in security," says Tim Martin, describing faster turnaround and defensible audit logs.

Fertility Centers of Illinois

A healthcare provider reconciled custodial accounts for patient-related funds requiring strict privacy controls.

  • They added a privacy addendum and audit trail to each signed record.
  • John Butler notes the API and support improved integrations and compliance with internal procedures while preserving chain-of-custody for sensitive funds.

Best practices for accurate and efficient completion

Follow these practices to reduce errors, shorten resolution time, and produce audit-ready reconciliations.

Standardize identifiers
Use CUSIP/ISIN consistently and require that upload templates and data feeds use the same fields to enable automated matching and minimize manual intervention.
Attach supporting documents
Always attach trade confirmations, corporate action notices, and fee schedules to each reconciliation entry so exceptions can be resolved quickly and audit evidence remains complete.
Use role-based approvals
Configure workflows so preparers, reviewers, and approvers are distinct people with documented responsibilities to maintain segregation of duties.
Record remediation steps
When breaks are identified, document root cause, corrective action, and expected timing so reviewers and auditors can validate remediation.

FAQs and troubleshooting for common reconciliation questions

Answers to frequent questions about execution, signatures, and recordkeeping for Securities Reconciliation Forms.


Need help? Contact support

be ready to get more
Join over 28 million airSlate SignNow users