Trade Allocation Fairness Review Worksheet
Use this worksheet to review block trade allocations across client accounts, confirm the method matches policy, and document any preferential-treatment concerns before they become a compliance issue.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Investment Management · Broker Dealer Compliance · Wealth Management · Hedge Funds
Overview
This worksheet is for reviewing how a block trade was allocated across eligible client accounts and whether the final distribution followed the firm’s approved policy. It gives the reviewer a structured way to confirm the review period, identify the trade sample, compare the trade blotter and allocation blotter, verify account eligibility, and test whether the allocation method was applied consistently. It also captures late changes, rounding treatment, exceptions, root cause analysis, corrective actions, and final sign-off.
Use this template when you need a repeatable control for fair dealing, fiduciary oversight, and supervisory documentation. It is especially useful where allocations are manual, where multiple accounts participate in the same order, or where restricted, proprietary, or employee accounts could create conflict concerns. The worksheet helps show whether pre-trade order entry time, account status, or other non-policy factors influenced the outcome.
Do not use this as a substitute for the underlying allocation policy, order management records, or trade blotter source data. It is also not meant for simple single-account trades with no allocation decision. If your firm does not permit block allocations, or if the review is purely operational with no fairness question, a lighter trade reconciliation form may be a better fit. The value here is in documenting the control logic behind the allocation, not just the numbers.
Standards & compliance context
- This worksheet supports supervisory controls and fair dealing expectations commonly used in SEC- and FINRA-regulated environments.
- It can be aligned to fiduciary duty controls, books-and-records practices, and internal code-of-ethics procedures for investment advisers and broker-dealers.
- Firms may map the review to broader compliance management frameworks such as ISO 9001-style non-conformance tracking or internal audit programs.
- Where proprietary, employee, or restricted accounts are involved, the review helps document that conflicts were handled under the firm’s approved policy and not by ad hoc judgment.
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
Review Scope and Trade Identification
This section defines exactly which trades are in scope so the review can be traced back to source records and policy references.
-
Review period and sample set are documented
Record the date range, number of block trades reviewed, and sampling method used.
-
Trade blotter, allocation blotter, and order records are available
Verify source records are complete enough to trace each block trade from execution to final allocation.
-
Eligible client accounts for each block trade are identified
Confirm the universe of eligible accounts was defined before allocation decisions were made.
-
Allocation policy or SOP reference is documented
Enter the policy, procedure, or desk guidance governing trade allocation.
Allocation Method and Proportionality
This section tests whether the allocation math and method match the approved process for every eligible account.
-
Allocation method matches the approved policy
Verify the method used (for example, pro rata, model-based, or rotation-based) matches the approved allocation rule for the strategy.
-
Allocations were completed using the same methodology for all eligible accounts
Confirm no eligible account received a different treatment without a documented, approved exception.
-
Allocation percentages are consistent with order size and account eligibility
Check whether the final allocation percentages reasonably align with the intended methodology and account constraints.
-
Rounding differences are immaterial and consistently applied
Verify any rounding or minimum-lot adjustments were applied consistently and did not favor specific accounts.
-
Late or manual allocation changes are documented and approved
Confirm any post-trade changes were authorized, time-stamped, and supported by a valid business reason.
Fair Dealing and Preferential Treatment Checks
This section looks for conflict patterns and treatment differences that could indicate favoritism or unfair influence.
-
No client account received a consistently favorable allocation pattern
Review for repeated over-allocation, better fills, or systematic preference to any account or related group of accounts.
-
Pre-trade order entry time did not influence allocation unfairly
Confirm that any time priority, order aggregation, or internal queueing rules were applied consistently and in line with policy.
-
Restricted, proprietary, or employee accounts were not favored over client accounts
Verify client accounts were not disadvantaged by allocations to proprietary, house, or affiliated accounts.
-
Any exceptions to standard allocation were independently reviewed
Confirm exceptions were reviewed by compliance or another independent reviewer and supported by documented rationale.
Documentation, Exceptions, and Corrective Actions
This section turns any deficiency into a tracked non-conformance with ownership, due dates, and follow-up.
-
Exceptions and non-conformances are logged with trade identifiers
Record each deficiency with the trade date, security, account(s) affected, and nature of the allocation issue.
-
Root cause analysis completed for any failed allocation review item
Document whether the issue was caused by process error, system logic, manual override, or policy gap.
-
Corrective action owner and due date are assigned
Enter the responsible person or team and the target completion date for remediation.
-
Follow-up monitoring is scheduled for repeat issues
Confirm a follow-up review or enhanced sampling plan is in place when repeated deficiencies are identified.
Review Sign-Off
This section records the final control decision and shows who completed the review and what they concluded.
-
Overall review result
Select the final outcome of the fairness review.
-
Inspector comments
Summarize key findings, exceptions, and any material concerns about fairness or preferential treatment.
-
Inspector signature
Signature of the reviewer completing the inspection.
How to use this template
- 1. Enter the review period, sample set, and trade identifiers, then attach or reference the trade blotter, allocation blotter, order records, and the applicable allocation policy or SOP.
- 2. Identify every client account that was eligible for each block trade and confirm the eligibility basis matches the order instructions and account restrictions.
- 3. Compare the actual allocation method to the approved policy and verify that the same methodology was applied to all eligible accounts for the trade.
- 4. Test proportionality, rounding, and any late or manual changes, and document whether each exception was approved and supported by a clear business reason.
- 5. Check for patterns that could indicate preferential treatment, including repeated favorable allocations, employee or proprietary account preference, or unfair influence from pre-trade order entry timing.
- 6. Record findings, assign corrective actions and due dates for any non-conformances, and complete the sign-off only after follow-up monitoring is scheduled where needed.
Best practices
- Tie every sampled trade to source records so the reviewer can trace the allocation from order entry through final distribution.
- Use the same eligibility rules and proportionality test for every account in the sample to avoid inconsistent review standards.
- Flag any late or manual allocation change as a review item even when the final numbers look reasonable.
- Treat repeated favorable treatment patterns as a control failure, not just an isolated exception, and escalate them for independent review.
- Document rounding logic explicitly when small differences are immaterial, because undocumented rounding is a common audit gap.
- Separate operational errors from policy exceptions so root cause analysis points to the real control weakness.
- Require reviewer independence from the trader or portfolio manager who made the allocation decision.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this trade allocation fairness review worksheet cover?
It covers the review of block trade allocations across eligible client accounts to confirm the allocation method matches the approved policy and that no account received preferential treatment. The worksheet also captures supporting records such as the trade blotter, allocation blotter, and order records. It is designed to document exceptions, non-conformances, and corrective actions in one place. Use it as a control record for fair dealing and fiduciary oversight.
When should this worksheet be used?
Use it after block trades are allocated and before the review is closed out, especially when multiple client accounts participate in the same order. It is also useful during periodic compliance testing, supervisory reviews, or targeted audits of a desk, strategy, or portfolio manager. If your firm handles late allocations, manual adjustments, or restricted accounts, this worksheet helps document those edge cases. It is not a trade ticket or execution log; it is the review record.
Who should complete the review?
A compliance reviewer, supervisory principal, operations control owner, or other independent reviewer should complete it, depending on your firm’s control structure. The key point is independence from the person who made the allocation decision. If the same person both allocates and signs off, the review loses much of its value. Many firms also require escalation to compliance when exceptions or repeated patterns are found.
How often should trade allocation reviews be performed?
The cadence depends on trading volume and risk, but many firms review block allocations on a sample basis daily, weekly, or monthly. Higher-risk desks, manual allocation processes, and strategies with frequent exceptions may warrant more frequent review. The worksheet supports both routine sampling and event-driven reviews after a complaint, surveillance alert, or policy change. Whatever cadence you choose, document the review period and sample set clearly.
What regulations or standards does this template support?
This worksheet supports fair dealing and fiduciary oversight expectations under securities compliance programs, as well as internal supervisory controls and recordkeeping practices. It is commonly used alongside policies aligned to SEC and FINRA expectations, investment adviser fiduciary duties, and general books-and-records requirements. The template is not a legal opinion, but it helps demonstrate that allocations were reviewed against an approved policy and that exceptions were handled consistently. Firms may also adapt it to internal code-of-ethics or best-execution controls.
What are the most common mistakes this review catches?
Common issues include allocations that do not match the approved methodology, rounding that is applied inconsistently, and late manual changes that are not documented or approved. Reviewers also often find patterns that favor one client, employee, or proprietary account over others. Another frequent issue is missing support for why an account was eligible or excluded from a block trade. This worksheet is built to surface those problems before they become repeated findings.
Can this worksheet be customized for different trading desks or asset classes?
Yes. You can tailor the review scope, eligibility rules, allocation method fields, and exception criteria to match equities, fixed income, options, or other trading workflows. Firms often add desk-specific policy references, approval thresholds, or surveillance notes for manual allocations. The structure should stay consistent so reviewers can compare results across periods, but the detailed checks can be adapted to your process. That makes it easier to standardize oversight without forcing every desk into the same operational details.
How does this differ from an ad-hoc spreadsheet review?
An ad-hoc spreadsheet usually records numbers, but it often misses the control questions that matter: Was the method approved, were all eligible accounts treated the same, and were exceptions independently reviewed? This worksheet turns the review into a repeatable audit trail with scope, findings, root cause, corrective action, and sign-off. That makes it easier to defend the review during an internal audit or regulatory exam. It also reduces the chance that a reviewer forgets to check for preferential patterns.
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 Trade Allocation Fairness Review Worksheet with your team — pricing built for small business.