Run Quarterly Account Reconciliation and Custodian Statement Review — Free

Scope, Period, and Statement Completeness

Reconciliation period matches the quarterly review window critical (required)

Record the quarter-end date and reconciliation period covered by this inspection.

All in-scope accounts are listed and reviewed critical (required)

Select all accounts included in this quarterly reconciliation.

Yes No N/A

Custodian statements received for all in-scope accounts critical (required)

Verify statements were received for every account in scope and for the correct statement date.

Yes No N/A

Internal ledger and subledger reports are complete critical (required)

Confirm the internal books, trade blotter, position reports, and cash activity reports are complete for the review period.

Yes No N/A

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.

Yes No N/A

Trade and Transaction Reconciliation

All executed trades appear on both internal records and custodian statements critical (required)

Check for missing trades, duplicate entries, or unmatched executions between systems.

Yes No N/A

Trade quantities match between internal records and custodian statements critical (required)

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.

Yes No N/A

Corporate actions and income events are properly reflected

Confirm dividends, interest, splits, mergers, and other corporate actions are captured accurately.

Yes No N/A

Unmatched or missing trades are documented with root cause critical (required)

Summarize any unmatched items and the reason they occurred.

Position, Quantity, and Pricing Variance Review

Position quantities agree across internal and custodian records critical (required)

Verify holdings quantities match for each security or asset class in scope.

Yes No N/A

Quantity variances are within approved tolerance critical (required)

Enter the largest quantity variance observed during the review.

Security pricing matches approved pricing source critical (required)

Confirm prices used in internal records match the approved pricing source or documented valuation policy.

Yes No N/A

Pricing variances are identified and explained

Document any pricing differences, including source used and reason for variance.

Accrued income and cash balances reconcile critical (required)

Verify accrued dividends, interest, fees, and cash balances reconcile to the custodian statement or are explained.

Yes No N/A

Open Items, Aging, and Exception Management

Open reconciliation items are aged and categorized critical (required)

Confirm all open items have an aging bucket and exception category assigned.

Yes No N/A

Critical breaks are escalated within required timeframe critical (required)

Verify material or high-risk breaks were escalated to the appropriate supervisor, operations lead, or compliance contact.

Yes No N/A

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 critical (required)

Confirm material breaks have a documented root cause and remediation plan.

Yes No N/A

Corrective actions have owners and due dates critical (required)

List the corrective actions, assigned owner, and target completion date for each unresolved item.

Review Controls, Approval, and Sign-Off

Reviewer independently validated the reconciliation critical (required)

Confirm a second reviewer or supervisor performed an independent review where required by policy.

Yes No N/A

Supporting workpapers are retained and traceable critical (required)

Verify workpapers, statements, exception logs, and evidence are stored in the approved repository.

Yes No N/A

Review date

Record the date and time the quarterly review was completed.

Inspector signature critical (required)

Signature of the person completing the reconciliation review.

Approver signature

Signature of the reviewer or approver, if required by policy.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Run: Quarterly Account Reconciliation and Custodian Statement Review

Scope, Period, and Statement Completeness

Trade and Transaction Reconciliation

Position, Quantity, and Pricing Variance Review

Open Items, Aging, and Exception Management

Review Controls, Approval, and Sign-Off

Get your results