Spread, bid-ask prices and cost basis
Identify what is already inside transaction prices before adding a separate cost.
Choose the producing price
A reference midpoint, last trade, executable quote and actual transaction price are different objects. A calculation using invented reference prices can be a useful plan, but a realised payoff requires actual transactions and their quantities. State the producing price and clock rather than silently treating one source as another. The difference between two actual transaction prices can already reflect a spread-related effect. A separate all-in cost estimate may then repeat part of that effect. This guide does not estimate a live spread or claim a particular venue's fill quality; it defines the accounting question before subtracting anything.
Map inclusion component by component
Prepare a cost map with the original entry basis, exit basis, separately booked commission, exchange charge, financing and excluded amounts. Mark each component as included in prices, added once or not supplied. Avoid an unexplained single label such as all-in when the components have different treatment. If the input is already net cash P&L, subtracting the same fee again changes the completed result. Software subscription expense may belong to a separate attribution policy rather than every position. The new three-leg workbook declares its extra cash cost is additional to its invented prices, so its arithmetic has one explicit inclusion convention.
Reproduce a narrow numerical case
Suppose an invented 100-unit long enters at an actual-price assumption of 100.10 and exits at 102.00. Gross transaction-price P&L is 190 before an additional commission assumption of 10. Net cash is 180. If a reviewer then subtracts another 20 labelled spread without establishing that it is additional, the record becomes 160 for a different and potentially duplicated cost policy. No observed spread, actual broker fee or market transaction is supplied. Keep both the original basis and the changed assumption rather than saying one outcome is proven simply because the spreadsheet subtracts a number.
Preserve a missing component
When a charge is unknown, identify it as missing rather than estimating it from an unrelated provider or assuming zero. An educational case can explicitly assume zero, but the assumption must not migrate into an actual net-performance claim. Borrow and financing may depend on instrument, size and holding path; the linear cash worksheet excludes them unless a separate total is deliberately supplied, and cannot certify completeness. Actual fee schedules and transaction statements have different effective dates. A later page read is not the date the charge applied. The proper completed finding may be reproducible price P&L with net cash still unresolved.
Completed invented payoff case
The fictional reviewer keeps transaction-price P&L 190 and separately added commission 10, producing 180 net cash. The source map has no additional spread debit, borrowing amount or tax record. Those absent records are not declared zero in an actual account conclusion. A second row subtracting an unverified 20 is a changed hypothetical policy, not a correction to observed performance. This distinction survives in the input notes rather than being hidden behind a net-return headline.
| Object | Record | Bounded finding |
|---|---|---|
| Price basis | 100 units; 100.10 to 102.00 | 190 gross transaction-price cash |
| Additional fee | 10 | 180 net under this assumption |
| Extra spread debit | Not established | Do not silently subtract |
| Actual account | No supplied statements | Net verification outstanding |

Primary references and scope
Expanded source review: 13 October 2026. Documentation supports the stated mechanism, not a tested account, hypothetical fill or provider outcome.