Best Execution Review and Documentation Worksheet
Best Execution Review and Documentation Worksheet template for recording periodic trade execution reviews, broker selection, and routing decisions. Use it to capture evidence, note exceptions, and create an audit trail for oversight.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Broker Dealers · Asset Management · Wealth Management · Institutional Trading
Overview
This Best Execution Review and Documentation Worksheet is a structured record for periodic oversight of trade execution quality, broker selection, and trade routing. It gives reviewers a consistent place to define the review period, explain the basis for the review, compare execution against a benchmark, document broker and venue decisions, and capture exceptions with follow-up ownership.
Use this template when you need a repeatable review record for a trading desk, investment program, or supervisory compliance process. It is especially useful after routing changes, broker onboarding, venue changes, or any period where execution quality needs to be assessed against internal policy or market benchmarks. The audit trail section helps preserve the supporting documents and data sources that justify the conclusions.
Do not use this worksheet as a substitute for the underlying execution policy or as a generic trade blotter. It is not meant to capture every order detail or replace transaction-level systems. If your review does not involve broker selection, routing rationale, or execution quality analysis, a simpler oversight form may be a better fit. The template is also not ideal when no benchmark is available, because the assessment fields depend on a defined comparison basis. For best results, keep the entries specific, attach the source reports, and document any conflicts or exceptions before the review is closed.
Standards & compliance context
- This worksheet supports documented oversight and audit trail expectations by showing what was reviewed, who reviewed it, and what evidence was used.
- If the form collects names or other PII, include a clear disclosure of how the information will be used and retained in line with data minimization principles.
- Keep the review scope limited to the information needed for best execution oversight and avoid collecting unrelated personal or trading details.
- The attestation field should confirm the reviewer completed the assessment based on the listed data sources and supporting documents.
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
Submission Notice and Review Scope
This section defines the exact review window, scope, and basis so the record is tied to a specific oversight cycle.
- Review period start date
- Review period end date
- Review frequency
- Scope of review
- Primary basis for this review
-
Review notes
Summarize the objective of the review and any constraints, such as asset class coverage or data limitations.
Reviewer and Governance
This section identifies who performed the review and whether any conflicts or additional participants affected the process.
- Reviewer name
- Reviewer title or role
- Department
-
Additional participants or approvers
List names and roles only if needed for the audit trail.
- Any conflicts of interest disclosed?
-
Conflict details
Describe the conflict and any mitigation steps taken.
Execution Quality Assessment
This section captures the core best execution analysis, including the benchmark and the quality factors reviewed.
- Price improvement assessed
- Execution speed assessed
- Fill rate assessed
- Market impact assessed
-
Execution quality summary
Summarize the data reviewed, trends observed, and whether execution quality met expectations.
- Benchmark or comparison method used
Broker and Venue Review
This section explains which brokers and venues were reviewed and why the routing or selection decision was made.
- Brokers reviewed
- Venues reviewed
-
Routing rationale
Explain why the selected broker or venue remained appropriate based on execution quality, cost, and service considerations.
- Did broker selection change during the review period?
-
Broker change details
Describe the change, effective date, and reason for the decision.
- Any venue or broker concerns identified?
Exceptions, Corrective Actions, and Follow-Up
This section turns findings into action by assigning owners, due dates, and the next review date.
-
Exceptions summary
Summarize any outliers, failed trades, routing issues, or other exceptions.
-
Corrective actions
List actions to address issues, including policy updates, broker discussions, or monitoring changes.
- Follow-up owner
- Follow-up due date
- Next scheduled review date
Audit Trail and Attestation
This section preserves the evidence behind the review and confirms the record is complete and accurate.
-
Supporting documents
Attach reports, broker scorecards, or analysis files used in the review.
-
Data sources used
Identify the systems, reports, or datasets used for the review.
- Attestation
How to use this template
- Enter the review period, review frequency, scope, and basis so the worksheet clearly states what was examined and why.
- Record the reviewer, department, and any additional participants, then disclose any conflicts and explain them in the conflict details field if needed.
- Assess execution quality by completing the price improvement, speed, fill rate, and market impact fields and summarizing the result against the chosen benchmark.
- Review the brokers and venues used, explain the routing rationale, and note whether broker selection changed or whether any concerns were identified.
- Document exceptions, assign corrective actions to a named owner, set the follow-up due date, and schedule the next review date.
- Attach the supporting documents and data sources, then complete the attestation only after the review record is complete and accurate.
Best practices
- Use a single benchmark definition for the entire review period so the assessment is comparable from one cycle to the next.
- Mark required fields clearly and keep optional narrative fields short when the underlying data already supports the conclusion.
- Document conflicts of interest immediately, even if they seem minor, so the review record shows how independence was handled.
- Tie every exception to a named corrective action and due date instead of leaving concerns as open-ended notes.
- Attach the source reports used for the review, not just a summary memo, so the audit trail can be traced back to original data.
- Keep broker and venue names consistent with your internal systems to avoid mismatches between the worksheet and execution records.
- Use progressive disclosure for follow-up details so reviewers only see extra fields when a change, exception, or concern is present.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this worksheet used for?
This worksheet documents a periodic review of trade execution quality, broker selection, and routing decisions. It is designed to capture the basis for the review, the benchmarks used, exceptions found, and any follow-up actions. The result is a clear audit trail that supports best execution oversight.
How often should this review be completed?
Use it on the cadence your policy or oversight program requires, such as monthly, quarterly, or after a material routing or broker change. The template includes review period and review frequency fields so you can standardize the schedule. If your trading activity or venue mix changes quickly, shorter review cycles may be more appropriate.
Who should fill out the template?
It is typically completed by a trading supervisor, compliance reviewer, operations lead, or another designated reviewer with access to execution data. The reviewer and governance section lets you record the responsible person, department, and any additional participants. If there is a conflict of interest, the template includes a disclosure field so it is documented.
What evidence should be attached?
Attach the reports, order records, broker statements, venue analytics, and benchmark outputs used to support the review. The supporting documents and data sources fields are meant to show where the conclusions came from. Keep the attachments aligned with the review period so the record is easy to trace later.
Does this template replace a formal best execution policy?
No. This worksheet records the review and documentation step, but it does not replace a written policy or broker oversight framework. It works best when paired with a policy that defines the review cadence, benchmarks, escalation path, and approval authority. Use the worksheet to prove the policy was actually followed.
What are common mistakes when using this form?
Common issues include leaving the benchmark vague, skipping the rationale for broker or venue selection, and failing to document exceptions or follow-up owners. Another frequent mistake is collecting too much narrative without attaching the underlying data. Keep the entries specific, dated, and tied to the actual review period.
Can this be customized for different asset classes or venues?
Yes. You can tailor the execution quality section to equities, fixed income, options, or other trading workflows by changing the benchmark and venue fields. The routing rationale and venue review fields can also be adapted for internal crossing, algorithmic routing, or external broker review. Keep the core structure intact so the audit trail stays consistent.
How does this fit into a compliance workflow?
The worksheet is built to support documented oversight, exception handling, and attestation. It helps show that execution quality, broker choice, and routing were reviewed against a stated basis rather than handled ad hoc. That makes it easier to retain evidence for internal reviews, audits, and supervisory checks.
How should this be rolled out across a team?
Start by defining the required fields, the review cadence, and who owns follow-up actions. Then standardize the benchmark sources and supporting documents so every reviewer uses the same inputs. A short pilot with one desk or strategy can help you refine the conditional logic and reduce missing fields before broader rollout.
Related templates
Go deeper on the topic
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
Job hazard analysis (JHA) — also called job safety analysis (JSA) — is the structured exercise of breaking a work task into sequential steps, identifying the...
-
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...
-
AI governance is the framework a company uses to decide what AI tools are allowed to do, who's accountable for their outputs, what data they're allowed to...
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
Learn how AI-driven workflows close compliance gaps in hiring, field inspections, and compensation — before they become audit findings.
-
MangoApps Shifts & Schedules unifies frontline scheduling, time, and leave management in one native platform for faster, simpler operations.
Ready to use this template?
Get started with MangoApps and use Best Execution Review and Documentation Worksheet with your team — pricing built for small business.
