Quarterly Account Reconciliation and Custodian Statement Review
Quarterly account reconciliation and custodian statement review template for comparing internal books to custodian records, tracking breaks, and documenting sign-off before period closeout.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Asset Management · Banking And Treasury · Private Equity And Fund Administration · Registered Investment Advisory
Overview
This template is a quarterly control worksheet for reconciling internal account records to custodian statements and documenting the review trail. It is built to help a preparer confirm that every in-scope account has a complete statement, that trades and transactions match across sources, that positions and pricing agree within policy tolerance, and that open breaks are aged, assigned, and approved for follow-up.
Use it when you need a repeatable books-and-records check at quarter-end, when a client, auditor, or compliance team expects evidence of independent review, or when prior-period exceptions must be carried forward until resolved. The structure follows the way a reviewer actually works: confirm scope and completeness first, then test trades and corporate actions, then compare positions, quantities, pricing, cash, and accrued income, and finally close the loop on exceptions and sign-off.
Do not use it as a substitute for a daily trade blotter control or a full valuation policy review. It is also not the right tool if your process has no custodian statement to compare against, or if the account activity is too specialized for standard reconciliation logic without custom fields. Common failure points include missing statements, stale breaks that were never escalated, and pricing variances that were explained verbally but not documented. The template is designed to make those gaps visible before closeout.
Standards & compliance context
- This template supports books-and-records discipline and traceability expected in regulated financial operations, including internal control frameworks used alongside SEC-style recordkeeping requirements.
- The approval and sign-off fields help demonstrate independent review practices commonly expected under ISO 9001:2015-style document control and auditability principles.
- The aging and escalation fields support governance expectations for unresolved exceptions, which is useful in SOX-style control environments and internal audit testing.
- If your organization has retention, valuation, or reconciliation policies tied to a specific regulator or client mandate, map the template fields to those requirements before rollout.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Scope, Period, and Statement Completeness
This section confirms the review window and proves that every in-scope account has complete source records before any matching begins.
-
Reconciliation period matches the quarterly review window
Record the quarter-end date and reconciliation period covered by this inspection.
-
All in-scope accounts are listed and reviewed
Select all accounts included in this quarterly reconciliation.
-
Custodian statements received for all in-scope accounts
Verify statements were received for every account in scope and for the correct statement date.
-
Internal ledger and subledger reports are complete
Confirm the internal books, trade blotter, position reports, and cash activity reports are complete for the review period.
-
Exceptions from prior quarter are carried forward and tracked
Verify unresolved items from the prior quarter are included in the current review with current status.
Trade and Transaction Reconciliation
This section checks whether executed activity, corporate actions, and income events are recorded consistently across internal and custodian sources.
-
All executed trades appear on both internal records and custodian statements
Check for missing trades, duplicate entries, or unmatched executions between systems.
-
Trade quantities match between internal records and custodian statements
Enter the number of quantity breaks identified in the quarter.
-
Trade dates and settlement dates are aligned
Verify trade date, settlement date, and status are consistent across internal and custodian records.
-
Corporate actions and income events are properly reflected
Confirm dividends, interest, splits, mergers, and other corporate actions are captured accurately.
-
Unmatched or missing trades are documented with root cause
Summarize any unmatched items and the reason they occurred.
Position, Quantity, and Pricing Variance Review
This section tests the balances that most often drive financial reporting errors, including quantities, pricing, cash, and accrued income.
-
Position quantities agree across internal and custodian records
Verify holdings quantities match for each security or asset class in scope.
-
Quantity variances are within approved tolerance
Enter the largest quantity variance observed during the review.
-
Security pricing matches approved pricing source
Confirm prices used in internal records match the approved pricing source or documented valuation policy.
-
Pricing variances are identified and explained
Document any pricing differences, including source used and reason for variance.
-
Accrued income and cash balances reconcile
Verify accrued dividends, interest, fees, and cash balances reconcile to the custodian statement or are explained.
Open Items, Aging, and Exception Management
This section keeps unresolved breaks visible, assigned, and time-bound so stale items do not roll forward unnoticed.
-
Open reconciliation items are aged and categorized
Confirm all open items have an aging bucket and exception category assigned.
-
Critical breaks are escalated within required timeframe
Verify material or high-risk breaks were escalated to the appropriate supervisor, operations lead, or compliance contact.
-
Stale items older than policy threshold are identified
Enter the number of open items exceeding the internal aging threshold.
-
Root cause analysis completed for material exceptions
Confirm material breaks have a documented root cause and remediation plan.
-
Corrective actions have owners and due dates
List the corrective actions, assigned owner, and target completion date for each unresolved item.
Review Controls, Approval, and Sign-Off
This section documents independent validation and final approval so the reconciliation has a clear control trail.
-
Reviewer independently validated the reconciliation
Confirm a second reviewer or supervisor performed an independent review where required by policy.
-
Supporting workpapers are retained and traceable
Verify workpapers, statements, exception logs, and evidence are stored in the approved repository.
-
Review date
Record the date and time the quarterly review was completed.
-
Inspector signature
Signature of the person completing the reconciliation review.
-
Approver signature
Signature of the reviewer or approver, if required by policy.
How to use this template
- 1. Enter the quarterly review period, list every in-scope account, and confirm that a custodian statement and internal ledger report exist for each one.
- 2. Compare executed trades, corporate actions, and income events line by line between internal records and custodian statements, and document every unmatched item with a root cause.
- 3. Reconcile positions, quantities, pricing, accrued income, and cash balances, then flag any variance outside the approved tolerance for follow-up.
- 4. Age every open item, assign an owner and due date, and escalate critical breaks according to your policy before the review is marked complete.
- 5. Attach supporting workpapers, record the independent reviewer’s validation, and capture review date, inspector signature, and approver sign-off.
Best practices
- Start with statement completeness before testing any balances, because a missing statement can make a clean reconciliation look valid when it is not.
- Use a documented tolerance for quantity and pricing variances, and do not rely on informal judgment when deciding whether a break is acceptable.
- Tie every unresolved item to a specific root cause category such as timing, booking error, pricing source mismatch, or corporate action processing.
- Carry prior-quarter exceptions forward until they are resolved or formally waived, and never clear an item without evidence.
- Retain workpapers that let a reviewer trace each break from source data to final disposition without reconstructing the analysis.
- Separate preparer and reviewer responsibilities so the sign-off reflects independent validation rather than self-review.
- Photograph or export source evidence at the time of review if your process depends on screenshots or system extracts, so the support matches the period under review.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this quarterly reconciliation template cover?
It covers the core books-and-records checks needed to compare internal account activity against custodian statements for a quarterly review. The template walks through statement completeness, trade matching, position and pricing variance review, open-item aging, and approval sign-off. It is designed to surface missing trades, quantity mismatches, pricing differences, and stale exceptions before closeout.
Who should use this template?
It is typically used by accounting, operations, fund administration, compliance, or controller teams that own books-and-records review. A preparer usually gathers the statements and reconciliation support, while an independent reviewer validates the work and signs off. If your process requires segregation of duties, this template supports that workflow.
How often should this reconciliation be run?
This version is set up for a quarterly cadence, which fits formal close and oversight cycles. Some teams also use it as the control record for month-end monitoring, then roll the open items into the quarterly review. If your policy or client agreement requires a different cadence, you can customize the period field without changing the control logic.
What regulatory or standards framework does it support?
The template is aligned to general books-and-records and internal control expectations rather than a single industry rulebook. It can support compliance programs built around SEC-style recordkeeping, ISO 9001:2015 control discipline, and internal audit or SOX-style review practices where traceability and approval matter. If you operate under a specific regulatory regime, you should map the fields to your own policy and retention requirements.
What are the most common mistakes this template helps catch?
Common misses include statements not received for every in-scope account, trades booked internally but absent from custodian records, and stale breaks that were never escalated. It also helps catch quantity variances caused by corporate actions, pricing differences from using the wrong source, and unreconciled cash or accrued income balances. The aging section is especially useful for identifying items that keep rolling forward without a documented root cause.
Can this template be customized for different account types?
Yes. You can tailor the account list, tolerance thresholds, approved pricing sources, and exception categories for mutual funds, separately managed accounts, private funds, or treasury accounts. If certain accounts have unique events such as capital calls, distributions, or complex corporate actions, add those checks to the transaction review section.
How does this compare with an ad hoc spreadsheet reconciliation?
An ad hoc spreadsheet usually captures the numbers but not the control trail. This template adds structure for completeness checks, aging, root cause analysis, ownership, and sign-off so the review is easier to audit and repeat. It also reduces the risk that prior-quarter exceptions disappear without resolution.
What should be attached as supporting evidence?
Attach the custodian statement, internal ledger or subledger reports, trade blotter extracts, pricing source evidence, and any workpapers used to explain breaks. If a variance was resolved through a corporate action notice, settlement confirmation, or corrected booking entry, include that support as well. The goal is to make every material exception traceable from issue to resolution.
Related templates
Go deeper on the topic
-
Predictive scheduling laws — also called fair workweek laws or secure scheduling — require employers in covered industries to publish employee schedules...
-
Overtime calculation is the process of applying federal, state, local, and contractual rules to hours worked to determine the correct pay — including...
-
A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
See how customers use MangoApps Projects Module to collaborate, track progress, and share knowledge across teams.
-
MangoApps in Okta Integration Network automates user provisioning, SSO, and access management for stronger security and less admin work.
Ready to use this template?
Get started with MangoApps and use Quarterly Account Reconciliation and Custodian Statement Review with your team — pricing built for small business.
