Evaluate · the log

Trade error log template: 18 fields that make an entry defensible

A trade error log entry is defensible when every field traces to a record: the order, the time-stamped allocation, the fills, the cost, the clause and the signatures. This template lists 18 fields with the source of each, the evidence to attach and what an examiner asks for, and shows how Trade Error Management fills them from the case itself.

Updated · 12 min read

A trade error log template should capture, for every error, what was intended and what happened, how it was found and reported, its kind and root cause, how it was corrected, what it cost each client, who paid under which clause, who decided and approved, when each client was made whole, and who was told. Eighteen fields cover it, and each one should point to the record it came from: the order memorandum, the time-stamped allocation, the fills, the policy version, the signatures. An entry built that way survives an examination; an entry typed from memory into a spreadsheet does not. Botminds' Trade Error Management builds the log from the cases themselves, so each field is filled from, and opens to, its source.

The examiner's request is predictable: every trade error since the last exam and how each was resolved. The log is the index to that answer; the case files are the answer. A template that asks only for a date, a description and an amount produces an index without the files.

A trade error log template: 18 fields, and the record each one comes from

  1. Case number and status

    SourceThe log itself

    One number per error, never reused; open, decided, approved, client whole, closed.

  2. Discovered: when and from what

    SourceThe first signal: a break, alert, notice, letter or report

    Shows how errors are found, and how long they hid.

  3. Reported: by whom and when

    SourceThe report, with its time

    Tests the policy's reporting clock on every case.

  4. Order, block and broker

    SourceOrder memorandum (Rule 204-2(a)(3)); order system audit trail

    Ties the case to the records the SEC requires.

  5. Security, side, quantity, price or limit

    SourceOrder ticket and FIX messages

    What was actually sent.

  6. What was intended

    SourceOrder memorandum, model or written instruction, with its time

    The yardstick for whether this is an error at all.

  7. What was executed and booked

    SourceFills; time-stamped allocation (Rule 204-2(a)(7)(iii)); custodian booking

    Where the chain diverged, and who booked what.

  8. Accounts affected, by type

    SourceAccount master and fund register

    Plan, registered fund, non-US fund or separate account: each has its own clauses.

  9. Kind of error

    SourceThe policy's definitions

    Family and kind, applied the same way each time.

  10. Root cause

    SourceThe timeline, cause categories and past cases

    Who, what and why, with the alternative considered.

  11. Correction

    SourceCorrection approval; corrective fills

    Method (rebook, market trade, cross), who approved, when filled.

  12. Cost per client, line by line

    SourceFills, commission schedule, fee tables, FX rates

    Each client separately; nothing netted across clients.

  13. Gain retained

    SourceThe same calculation

    A gain stays with the client account and is logged as such.

  14. Payer and clause

    SourceThe policy version in force

    Firm, broker or nobody, and the clause that says so.

  15. Decision

    SourceThe decider's signature and reason code

    Who decided, when, and on what evidence.

  16. Approval

    SourceSecond signature by threshold

    Never the decider; never the person who made the error.

  17. Payment and receipt

    SourceError account booking; confirmation of receipt

    The date each client was actually made whole.

  18. Notices, claims and follow-up

    SourceClient and board notices; broker claim; regulator notice where required

    Plus the repeat cause it was linked to and the fix requested.

Our template for an adviser's trade error log; Rule 204-2 references are to the SEC's books and records rule for advisers. Trade Error Management fills each field from the case it was built from.Source: 17 CFR 275.204-2 (eCFR)

What should a trade error log include?

Enough to rebuild the error and its resolution without asking anyone: the eighteen fields above. They fall into four groups. The first six identify the error and its evidence of intent. Fields seven to ten establish what went wrong and why. Eleven to fourteen record the money: the correction, the cost per client, any gain, and who paid. The last four record the people: decision, approval, payment and notices.

Two fields carry most of the weight in an examination. Field six, what was intended, decides whether the event is an error at all, and its source must be a record made before the trade, not an explanation made after. Field fourteen, the payer and clause, is where a reviewer looks for gains netted against losses, losses left with clients and clauses applied inconsistently. What counts as a trade error sets out the kinds that field nine should use.

Does every trade error need a log entry?

Yes, including errors that cost nothing and errors caught before settlement. The free ones are where repeat causes show up first, and a log that only holds expensive errors cannot show an examiner that the definition is applied consistently. In the SEC's 2020 Franklin order, the adviser's own policy required every trade error to be documented, circulated to senior officers and reported to the fund board with the corrective action, and the order found those steps were not followed for the losses at issue (SEC, Franklin Advisers, 2020).

The log should also hold the cases that were opened and found not to be errors, with the reason. A signal routed to the settlement team as a counterparty fail, or a loss classified as a decision rather than an error, is exactly the judgment an examiner may want to see. In the sample, the Intake agent proposed that one morning signal was "a settlement fail, not a trade error" and routed it, with the reason kept on the case.

How do you record the root cause of a trade error?

As who, what and why, with a category and the alternative you rejected. "Human error" is not a cause; "the saved block template filled the Global Value account and the trader did not change it" is. The alternative matters because it shows the cause was weighed, not assumed: in the sample the Cause agent put the template cause at 91% and the alternative, that the portfolio manager entered the wrong fund, at 6%, and it asks the trader or compliance when it is below 85% confident.

"The same set of circumstances can provoke similar errors, regardless of the people involved."

James Reason, Human error: models and management, BMJ, 2000

Reason's paper, written for medicine, distinguishes the "person approach", which "focuses on the errors of individuals", from the system approach, which "concentrates on the conditions under which individuals work" (BMJ 2000;320:768). A cause field that records only who erred cannot find the template, the default or the missing warning that will produce the same error with someone else. The SEC's 2026 Truist order shows the opposite need too: the firm's policy required it to monitor "for patterns of errors by individual" representatives (SEC, Truist, 2026), so the log must record who made the error as well as why.

What evidence should be attached to a trade error report?

The records behind each field, not a summary of them. For an allocation error that is the order memorandum, the order system's audit trail entries, the FIX messages to and from the broker, the time-stamped allocation and affirmation, the custodian's booking, the correction approval and fills, the cost calculation with its inputs, the policy clause, and the signatures. For a broker's error add the claim and the broker's reply; for a fund, the board notice.

Luxembourg's fund regime shows what a regulator expects of the text fields. Its notification form asks for an "origin of the error" and a "remediation plan" that are "clear and precise", and requires that "a quantitative impact calculation allowing the CSSF to trace how the impact of the errors/instances of non-compliance and of the corrective actions was determined must be attached to the notification" (CSSF Circular 24/856, points 153–154). Traceable is the standard to write to, wherever the fund is domiciled.

A trade error report in two minutes, with the order read in by Trade Error Management

Report a trade error screen, tabs for from an order, paste a message, or upload a break report. Order QF-EQ-1019-04172 is found: Larchmont Dental Group, buy 25,000, limit $81.40; PM instruction limit $18.40 from the order note; US Small Cap fund; broker Harwell Securities; filled 25,000 at $18.92 at 10:58 a.m. The Intake agent proposes the kind of error: price or limit, the limit was keyed $81.40 instead of $18.40. The trader's one sentence, when he noticed, and who else knows, then send the report, which goes to Trading Compliance.
Trade Error Management on fictional sample data (the firm, people, funds and broker are invented). Fields four to seven of the log come from the order record, not the trader's memory; the trader adds one sentence.

How do you log a broker's error and the claim that follows?

As a trade error like any other, with three extra fields: the claim, the broker's answer, and the date the client was paid regardless. The error belongs in the adviser's log because the client is the adviser's; the broker's liability changes who ultimately pays, not whether the client is made whole on time. A good policy pays the client first and pursues the broker afterwards, and the log should show both dates.

The claim fields should hold the evidence that the broker departed from the instruction: the adviser's order or allocation as sent, the broker's fills or booking, and the broker's own words. In the sample, a Tokyo broker filled 64,000 shares for an order of 46,000; its letter, in Japanese, accepted the error and said it would take the excess 18,000 shares into its own account and bear the loss of ¥1,386,860, about $9,215 at 150.50. The case logs the claim, the letter, its translation line by line, and the acceptance on October 16.

Broker claims in Trade Error Management: the claim, the letter and the 10-day clock

Broker claims screen: 41 claims this year, accepted or paid $498,240; 2 open now, 1 within its clock and 1 disputed; average reply 4.2 business days, none past 10 days this quarter. A list of claims with amounts and status: Calloway Markets $7,380 sent and waiting; Aobadai Securities, Tokyo, $9,215 accepted; Northbay Execution $3,120 disputed, which says the allocation instruction named the wrong fund while the firm's record shows the broker re-keyed it; others paid. The selected claim shows the broker's letter in Japanese beside the English: subject, error in the executed quantity; for the order of October 14, 2026 for Hokuto Precision, buy 46,000 shares, the broker's trader's input error caused execution of 64,000 shares; the broker will take the excess 18,000 shares into its own account and bear the resulting loss of ¥1,386,860, about $9,215 at 150.50, in full; corrected execution details resent today.
Trade Error Management on fictional sample data. The Policy agent drafts each claim, reads the reply in any language with each English line pinned to the original, and keeps the sample policy's 10-business-day clock, after which the firm pays the client and pursues the claim.

How long must a trade error log be kept?

At least five years, because the records it is built from must be. Under Rule 204-2(e)(1) most of an adviser's books and records must survive five full years past the fiscal year of their last entry, and for the first two of those years they must sit in an appropriate office of the adviser (17 CFR 275.204-2(e)(1); investment adviser recordkeeping requirements covers the rest of the rule). The same rule requires a copy of the compliance policies in effect "at any time within the past five years" and "any records documenting the investment adviser's annual review" (Rule 204-2(a)(17)).

Retention clocks that touch a trade error log

5years

adviser books and records under Rule 204-2(e)(1), the first two in an office of the adviser

5years

policies in effect, and records of each annual review, under Rule 204-2(a)(17)

6years

records of each fund cross trade under Rule 17a-7(g)

7years

the audit trail in Trade Error Management, as configured

SEC rules as of October 28, 2026. The last figure is the solution's setting, not a rule. Keep the policy version each case was decided under for as long as the case.Source: 17 CFR 275.204-2 (eCFR)

A practical point follows: the log must keep the policy version each case was decided under. In the sample, Trade Error Policy v5.1 took effect on March 1, 2026; a case decided in February belongs to the version before it, and an examiner reading the log in 2028 will ask which one applied.

What will an examiner ask for about trade errors?

The log of every error in the review period, a sample of case files, the policy versions in force and evidence that the policy was followed, including the annual review. The SEC's fiscal 2027 priorities name trading among the parts of a compliance program examiners review, and say they typically read the annual review as well (SEC, FY2027 priorities).

An examiner's trade error request, and the field that answers each item

  1. All trade errors since the last examination, with resolution

    The log: fields 1, 9, 12, 14 and 17 for every entry, including the free ones.

  2. Case files for a sample of errors

    Fields 4–7 with their source records attached; the cost lines; the signatures.

  3. Errors where the client was not reimbursed

    Field 14, with the clause and the reason; gains retained (field 13) shown separately.

  4. Errors caused by brokers, and claims

    Fields 14 and 18: claim date, reply, amount recovered, and whether the client was paid first.

  5. Errors in plan and fund accounts

    Field 8 by account type, with the plan or fund clauses applied and the board or plan notices.

  6. Repeat causes and what was done

    Field 10 grouped, and field 18's fix with its result.

  7. The policy, its versions and the annual review

    Each version with its dates; the review record and what it changed.

From a spreadsheet log to a case file in Trade Error Management

The solution does not keep a separate log; the cases are the log. Each case holds the eighteen fields because the agents fill them as they work: the Intake agent records the signal and the report, the Reconstruction agent the order, intent and execution with each event cited, the Cause agent the cause with its confidence and alternative, the Cost agent the cost per client, the Policy agent the clause and route, and the people their decisions, approvals, booking and confirmation. The examiner pack is built from that record: the log, each case file with its evidence, policy versions, decisions and signatures, the audit trail and the agents' versions, hash-verified, with wealth clients' names and account numbers masked and every download logged.

The same error in a spreadsheet row and in a case file

Spreadsheet rowCase file in Trade Error Management
Intent

Spreadsheet row: "Meant for Equity Income" typed by operations.

Case file in Trade Error Management: The order memorandum, opened from the order system, with its time.

What happened

Spreadsheet row: A sentence and a pasted screenshot.

Case file in Trade Error Management: Fifteen events from four systems and the chat archive, each cited, the error and the missed chance marked.

Cost

Spreadsheet row: One total; the lines in someone's workbook.

Case file in Trade Error Management: Each line per client from the fills; recomputed independently; $0 netted shown.

Decision

Spreadsheet row: "Approved by CCO" in a comment.

Case file in Trade Error Management: Clause, reason code, maker, approver and times, each signed.

Closure

Spreadsheet row: A date the row was marked done.

Case file in Trade Error Management: Payment booked and receipt confirmed by fund accounting, each with a name and time.

Our comparison, using the solution's fictional sample case TE-2026-0318 for the right column.

A closed case in Trade Error Management: the log entry and its evidence in one place

Closed case TE-2026-0318 viewed by fund accounting: allocation, wrong fund, US equities, fund board. All eight steps checked. Cost to correct $38,412.00 paid by the firm under §2.3 with each line: loss on the unwind $33,768.00, commissions $3,600.00, fees $144.00, higher price for Equity Income $900.00; to Global Value $37,512.00, to Equity Income $900.00, netted $0.00. Decided by Nadia Rahman 11:44 a.m., approved by Catherine Moreau 11:47, booked by Derek Lindqvist 11:50, receipt confirmed by Joanna Pike 11:53. Closed, every step signed and logged, with a case file download.
Trade Error Management on fictional sample data. The case file download carries the fields of the log with every source attached.

Because the cases carry the fields, the log can be cut any way the reader needs: by cause for the head of trading, by fund for a board, by broker for a claims review, by period for an examiner. What to ask of trade error software covers the controls behind the fields, and the trade error process shows who fills each one.

Questions people ask

What is a trade error report form?

The first document in a case: who found the error, when, on which order, and one sentence on what went wrong. It should take minutes, because a slow form delays the report and every hour after T+1 settlement costs money. The rest of the log should be filled from records, not from the form.

Should the log record the name of the person who made the error?

Yes, alongside the system cause. Patterns by individual are a control the SEC enforced in the Truist order, and patterns by system are what fixes repeat errors. Recording both, without treating the log as a disciplinary file, serves both purposes.

Is a trade error log a required record?

Rule 204-2 does not name one, but the records it is built from are required, and an adviser that documents errors under its policy must keep the policy and the review records the rule names. In practice the log is how an adviser shows its policy was followed, which is what Rule 206(4)-7 asks.

Can a broker's error log replace the adviser's?

No. A broker documents its own account changes, with FINRA requiring "the essential facts relied upon by the person approving the change" to be kept (FINRA Rule 4515), but the adviser's duty runs to its client. The adviser's log should reference the broker's correction, not depend on it.

What is the difference between a trade error log and an incident log?

An incident log usually covers any operational event; a trade error log covers events that put a client's account somewhere it should not be, with the money and the payer recorded. Keeping trade errors as a category of an incident log works if the eighteen fields are kept for that category.

Trade Error Management.
See it on your own files.

An agentic solution from Botminds. Logs each trade error, finds its cause and applies the error policy for trading and compliance Book a demo, or explore how it works.