Loading...
compliance

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 (weight 3.0)

    Record the date range, number of block trades reviewed, and sampling method used.

  • Trade blotter, allocation blotter, and order records are available (critical · weight 4.0)

    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 (critical · weight 4.0)

    Confirm the universe of eligible accounts was defined before allocation decisions were made.

  • Allocation policy or SOP reference is documented (weight 4.0)

    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 (critical · weight 8.0)

    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 (critical · weight 8.0)

    Confirm no eligible account received a different treatment without a documented, approved exception.

  • Allocation percentages are consistent with order size and account eligibility (weight 6.0)

    Check whether the final allocation percentages reasonably align with the intended methodology and account constraints.

  • Rounding differences are immaterial and consistently applied (weight 4.0)

    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 (critical · weight 4.0)

    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 (critical · weight 8.0)

    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 (weight 5.0)

    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 (critical · weight 6.0)

    Verify client accounts were not disadvantaged by allocations to proprietary, house, or affiliated accounts.

  • Any exceptions to standard allocation were independently reviewed (weight 6.0)

    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 (critical · weight 6.0)

    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 (weight 5.0)

    Document whether the issue was caused by process error, system logic, manual override, or policy gap.

  • Corrective action owner and due date are assigned (weight 4.0)

    Enter the responsible person or team and the target completion date for remediation.

  • Follow-up monitoring is scheduled for repeat issues (weight 5.0)

    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 (critical · weight 3.0)

    Select the final outcome of the fairness review.

  • Inspector comments (weight 3.0)

    Summarize key findings, exceptions, and any material concerns about fairness or preferential treatment.

  • Inspector signature (critical · weight 4.0)

    Signature of the reviewer completing the inspection.

How to use this template

  1. 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. 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. 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. 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. 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. 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:

Allocation percentages do not match the approved method for one or more eligible accounts.
Manual allocation edits were made after the initial run but were not approved or explained.
Rounding was applied inconsistently across accounts or across similar trades.
A proprietary, employee, or restricted account received a more favorable allocation than client accounts without documented justification.
The reviewer could not reconcile the allocation blotter to the trade blotter and order records.
One account repeatedly received better fills or larger participation than comparable eligible accounts.
Exceptions were noted but no root cause analysis or corrective action owner was assigned.

Common use cases

Compliance Analyst Reviewing Equity Block Trades
A compliance analyst samples equity block trades each month to confirm allocations followed the desk’s approved pro rata method. The worksheet gives them a consistent way to document eligibility, rounding, and any manual overrides.
Supervisor Reviewing Portfolio Manager Allocations
A supervisory principal reviews a portfolio manager’s discretionary allocations after a client complaint. The template helps separate policy-based decisions from potential preferential treatment and records the escalation path.
Internal Audit Testing of Conflict Controls
Internal audit uses the worksheet to test whether the firm’s allocation controls are operating as designed across multiple desks. It provides a repeatable audit trail for exceptions, root causes, and corrective actions.
Operations Review of Late Allocation Changes
An operations manager reviews trades where allocations were changed after the initial booking because of missing instructions or system issues. The form captures the approval trail and whether the late change created a fairness concern.

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.

Go deeper on the topic

Related concepts
  • 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...
Related guides

Ready to use this template?

Get started with MangoApps and use Trade Allocation Fairness Review Worksheet with your team — pricing built for small business.

Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?