How to Journal Partial Fills: An Order-to-Fill Worksheet

Why partial fills need reconciliation#

A single order can produce several executions: different quantities may fill at different prices and times, while the remainder stays open or is canceled. To journal that accurately, keep one parent record for the submitted order and attach a separate row for every fill. This preserves the link between the order you placed and what actually happened. SEC Rule 605 reporting guidance likewise describes partial executions and cancellations as events associated with a single order record; it is regulatory reporting guidance, not a personal-journal template. SEC.gov | Frequently Asked Questions: Rule 605 of Regulation NMS (April 1, 2026)

The practical goal is reconciliation, not a more elaborate diary. You should be able to answer: What did I submit? What filled, and when? What charges were recorded? What quantity remained? What position did the account show afterward? This guide provides a worksheet and a repeatable check for one order. It does not assess whether the trade was a good decision or whether a strategy has an edge.

Use broker order and activity records as the primary evidence, then compare the relevant confirmation or account statement. FINRA notes that confirmations include transaction date, price, and quantity, may include execution time, and identify commission or certain markups or markdowns. It advises reviewing confirmations and statements and querying unexplained charges. Are You Checking Your Trade Confirmations? | Syndication The available detail and layout can vary, so preserve the original records rather than relying on a journal’s rounded summary alone.

Treat this as an order-to-fill worksheet. Copy field names or identifiers as shown in the broker record where possible; do not silently replace an execution ID with a journal-created label. A broker may, in certain described circumstances, show an average execution price while retaining underlying execution details, and the cited SEC letter is a specific no-action position rather than a universal confirmation rule. Preserve fill-level details when available and record a broker-reported average separately. Average Price, Multiple Capacity Confirmations: No-action Letter dated March 3, 2005

Calculate the weighted-average fill price#

Consider a hypothetical buy order for 100 shares. It fills 40 shares at $25.10 and 60 at $25.14. The gross amounts are 40 × $25.10 = $1,004.00 and 60 × $25.14 = $1,508.40. Combined gross is $2,512.40; filled quantity is 100 shares; weighted-average fill price is $2,512.40 ÷ 100 = $25.124 per share. These figures illustrate the arithmetic only and exclude any fees or other adjustments.

The simple average of $25.10 and $25.14 is $25.12. That is not the weighted average here because the quantities differ. If the quantities were equal, the simple average would match; otherwise, multiply each price by its quantity, add those amounts, then divide by total filled quantity. Keep the underlying fills in the journal even when the average is useful for a compact summary.

Complete the checks in this order so the final position is not used to infer missing executions. Broker confirmations and statements are useful cross-checks, but a summary average may not show every fill detail. FINRA recommends checking those records and raising questions about unexplained information or fees. Are You Checking Your Trade Confirmations? | Syndication The SEC’s cited average-price letter also illustrates why an average shown on a confirmation need not replace the underlying execution record. Average Price, Multiple Capacity Confirmations: No-action Letter dated March 3, 2005

1. Capture the submitted order. Record its broker reference, symbol, side, order type, quantity, limit or stop price where relevant, and entry time with time zone. Save or reference the order record.
2. Add one child row for every execution. Enter the execution ID, actual execution time, quantity, and price from the activity detail. If an execution record is corrected or canceled, preserve the correction trail rather than overwriting the original evidence.
3. Sum executed quantities and gross amounts. Calculate weighted-average price as total of (quantity × price) divided by total filled quantity. If no quantity filled, leave the average blank rather than dividing by zero.
4. Record charges as reported. Enter fill-specific fees only when records attribute them to that fill. If the broker lists a total charge for the order, record it once at order level and label it accordingly. Do not allocate it arbitrarily across fills.
5. Check the order quantity disposition: filled quantity + canceled quantity + still-open quantity should equal the submitted quantity, where the broker’s status information supports those categories. If it does not reconcile, check for amendments, replacements, partial cancellations, or missing activity before deciding the journal is wrong.
6. Verify the resulting position. For this symbol, calculate prior position + filled buys − filled sells, then compare with the account record. Account for other transactions in the same symbol during the period; the position change may not come from this order alone.
7. Attach evidence and note unresolved differences. Reference the confirmation, execution detail, and relevant statement or activity entry. If records disagree or a charge is unexplained, ask the broker rather than guessing.

Handle timestamps, fees, and position carefully#

Keep timestamps in the format and time zone supplied by the broker, and note that time zone explicitly. Order-entry time and execution time are different events; a submitted price is not proof of the price received. FINRA says execution time may appear on a confirmation, so use the detailed activity record when available and mark unavailable fields as unavailable rather than reconstructing them from memory. Are You Checking Your Trade Confirmations? | Syndication

For charges, distinguish gross trade amount from fees. On a basic cash-equity example, gross amount is quantity multiplied by execution price. A buy’s cash debit is generally gross plus recorded charges, while a sell’s proceeds are generally gross less recorded charges; broker statement conventions and other adjustments can differ. Record the source’s presentation, and avoid double-counting a charge shown both at fill and order level. FINRA identifies commissions and, in some cases, markups or markdowns on confirmations. Are You Checking Your Trade Confirmations? | Syndication

Finally, the position check is a reconciliation, not proof that each fill was recorded correctly. Compare the calculated position with the account’s position after considering other buys, sells, transfers, or corporate actions. If an execution is missing, a quantity differs, or a fee is unexplained, preserve the records and seek clarification from the broker. FINRA also provides a guide to brokerage account statements and trade confirmations. https://www.finra.org/sites/default/files/2020-12/understanding-brokerage-account-statements-and-trade-confirmations.pdf

A compact journal summary can show the order’s total quantity, weighted-average price, and total recorded charges. Keep the child rows or a reliable reference to them behind that summary. If the journal software cannot link parent and child records, use a consistent broker order ID in each row and retain the source files in a place you can find later.

• One row per order, but no fill detail: this hides price and time differences between executions.
• One separate trade for every fill without a shared order ID: this loses the connection to the original instruction and can make the order quantity appear larger than it was.
• A simple average of fill prices: this is wrong when execution quantities differ.
• A fee split invented for convenience: keep an order-level total at order level unless records specify an allocation.
• An order-entry price entered as the fill price: record actual executions, not the intended or displayed price.
• A final position treated as the only proof: it may include other transactions and cannot by itself explain this order’s fills.

Should every partial fill be a separate trade in my journal?

Usually, keep one parent order record and create a child row for each execution, linked by the broker order ID. This shows both the original instruction and the separate fills. SEC Rule 605 guidance discusses partial executions associated with a single order record, though it is not a personal-journal rule. SEC.gov | Frequently Asked Questions: Rule 605 of Regulation NMS (April 1, 2026)

How do I calculate average price across different fill sizes?

Use total gross amount divided by total filled quantity: sum each fill’s quantity multiplied by its price, then divide by the sum of quantities. A simple price average is only equivalent when the fills have equal quantities.

What if my broker reports one fee for the whole order?

Record the total once at order level and label it as a combined charge. Do not assign portions to individual fills unless the broker record provides that allocation. Confirmations may show commission or certain markups or markdowns. Are You Checking Your Trade Confirmations? | Syndication

What if the confirmation shows no execution timestamp?

Mark the timestamp unavailable in that record and check the broker’s detailed activity or execution history. Do not substitute the order-entry time or estimate an execution time; confirmations may include execution time, but the available fields can vary. Are You Checking Your Trade Confirmations? | Syndication

The simplest reliable record#

A useful partial-fill journal answers four questions without guesswork: which order was submitted, which executions occurred, how quantity and charges reconcile, and what position the account showed afterward. Keep one parent order, one row per fill, and a visible link to the broker evidence. A weighted average is a summary; it should not replace the execution trail.

Sources#

• SEC.gov | Frequently Asked Questions: Rule 605 of Regulation NMS (April 1, 2026) — sec.gov
• Are You Checking Your Trade Confirmations? | Syndication — syndication.finra.org
• Average Price, Multiple Capacity Confirmations: No-action Letter dated March 3, 2005 — sec.gov
• https://www.sec.gov/files/ib_confirmations.pdf — sec.gov
• https://www.sec.gov/reports/report-practice-preferencing — sec.gov
• https://www.sec.gov/files/rules/final/2024/34-99679.pdf — sec.gov
• https://www.sec.gov/rules-regulations/2005/02/confirmation-requirements-point-sale-disclosure-requirements-transactions-certain-mutual-funds-other — sec.gov
• https://www.sec.gov/rules-regulations/1998/04/confirmation-affirmation-securities-trades-matching — sec.gov
• https://www.sec.gov/files/news/studies/2012/917-financial-literacy-study-part4.pdf — sec.gov
• https://www.sec.gov/answers/sec31.htm — sec.gov
• https://www.sec.gov/rules-regulations/2002/09/confirmation-requirements-transactions-security-futures-products-effected-futures-accounts — sec.gov
• https://www.finra.org/sites/default/files/ADF_FIX-Specs_OrderResponseRptg_Version1.6.pdf — finra.org
• https://www.sec.gov/files/rules/sro/finra/2016/34-78573-ex2a.pdf — sec.gov
• https://www.sec.gov/rules-regulations/2001/12/commission-guidance-scope-section-28e-exchange-act — sec.gov
• https://www.sec.gov/rules-regulations/staff-guidance/trading-markets-frequently-asked-questions/faq-rule-606-regulation — sec.gov
• https://www.finra.org/sites/default/files/2020-12/understanding-brokerage-account-statements-and-trade-confirmations.pdf — finra.org