Securities Reconciliation Form
What the Securities Reconciliation Form Is and when it applies
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.
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.
Step-by-step: completing the Securities Reconciliation Form
-
011. Gather source data: Collect internal ledger, custodian statement, trade blotter, and fee reports.
-
022. Match line items: Match quantities and values by security identifier and trade date.
-
033. Document breaks: Record exceptions, their cause, and required corrective actions.
-
044. Review and sign: Obtain reviewer approval and retain the completed form with audit trail.
Configuring an online reconciliation workflow
| 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
-
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
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
Comparison: eSignature vendor pricing and basic features
| 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
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
FAQs and troubleshooting for common reconciliation questions
-
Can a reconciliation be signed electronically?
Yes. Electronic signatures are legally enforceable under the ESIGN Act (15 U.S.C. ch. 96) and UETA where adopted, provided intent, consent, attribution, and retention requirements are met.
-
What signature methods are acceptable?
Typed, drawn, or cryptographic digital signatures are acceptable. For higher-assurance needs use multi-factor authentication or PKI-based digital signatures for stronger attribution and non-repudiation.
-
Is notarization required for reconciliation forms?
Not generally required for internal reconciliations. State notarization requirements depend on document purpose; check state law when reconciliations serve as legal conveyances or affidavits.
-
How long must reconciliations be retained?
Retention depends on industry: IRS records 3 years (IRC §6501(a)), SEC broker-dealer records 6 years (17 CFR §240.17a-4), HIPAA 6 years for health records (45 CFR §164.530(j)).
-
What if names or account numbers do not match?
Document the mismatch, gather supporting evidence, and route to compliance for remediation. Do not alter originals; record any corrective entries with rationale.
-
How to ensure signed records are admissible?
Capture an audit trail (timestamp, IP, signer identity), preserve the signed PDF/A file, and maintain a reproducible record so the electronic signature meets ESIGN/UETA validity tests.